SWA is a world leader in landscape architecture, planning, and urban design. Professionally focused and employee-owned, its foremost passion is to create exceptional places for clients.
SWA works with large, multi-functional sites and small, intimate spaces, and is one of the few firms capable of creating high-profile projects at a large scale. Its designs and plans are customized for each client's aspirations—based on deep experience, technical knowledge, cutting-edge research, and ""big ideas.""
SWA's work is fueled by a deep appreciation for nature and the beauty of natural systems. SWA is also inspired by the complexity of human-made systems and the human interactions they influence. At SWA’s core is a passion for imaginative, solution-oriented design that adds value to land, buildings, cities, regions, and people’s lives.
Landscape Architecture; Urban Design
Chengdu Greenland Tower, Chengdu
The Exchange 106, Kuala Lumpur
Dongguan International Trade Center 1, Dongguan
Greenland Group Suzhou Center, Suzhou
OKO - Residential Tower, Moscow
Jiangxi Nanchang Greenland Central Plaza, Parcel A, Nanchang
Jiangxi Nanchang Greenland Central Plaza, Parcel B, Nanchang
Shenzhen Zhongzhou Holdings Financial Center, Shenzhen
Jiangxi Nanchang Greenland Zifeng Tower, Nanchang
Jing An Kerry Centre Tower 2, Shanghai
Beijing Greenland Center, Beijing
Kingtown International Center, Nanjing
Emaar Square The Address Hotel & Residences, Istanbul
Sichuan Airlines Center, Chengdu
Jing An Kerry Centre Tower 3, Shanghai
Pudong Financial Plaza Office Tower 1, Shanghai
Chengdu Greenland Center Tower 2, Chengdu
Chengdu Greenland Center Tower 3, Chengdu
Poly International Plaza – Dawangjing , Beijing
Shenzhen Zhongzhou Holdings Financial Center Tower B, Shenzhen
Emaar Square Heights Residences , Istanbul
3001 John F Kennedy Boulevard, Philadelphia
Emaar Square Office Tower , Istanbul
3025 John F Kennedy Boulevard, Philadelphia
Pudong Financial Plaza Office Tower 2, Shanghai
Pudong Financial Plaza Office Tower 3, Shanghai
Pudong Financial Plaza L+Mall, Shanghai
Emaar Square Residences A, Istanbul
Emaar Square Residences B, Istanbul
Emaar Square Residences D, Istanbul
Emaar Square Residences C, Istanbul
Membership Level
Silver
Member Since
2010
Member Offices
Sausalito
Rank | Name | City |
Status
Completed Architecturally Topped Out Structurally Topped Out Under Construction On Hold Proposed Vision Never Completed Demolished Competition Entry Canceled Proposed Renovation Under Renovation Renovated Under Demolition
Filter by
✕
Completed Architecturally Topped Out Structurally Topped Out Under Construction On Hold Proposed Vision Never Completed Demolished Competition Entry Canceled Proposed Renovation Under Renovation Renovated Under Demolition
+
Select All | Completion | Height |
---|---|---|---|---|---|
1 |
- |
1000 m / 3,281 ft |
|||
2 |
2022 |
828 m / 2,717 ft |
|||
3 |
2015 |
632 m / 2,073 ft |
|||
4 |
2022 |
468 m / 1,535 ft |
|||
5 |
2010 |
450 m / 1,476 ft |
|||
6 |
2019 |
445.1 m / 1,460 ft |
|||
7 |
2019 |
438 m / 1,437 ft |
|||
8 |
2020 |
426.9 m / 1,401 ft |
|||
9 |
2020 |
375.6 m / 1,232 ft |
|||
10 |
2021 |
358 m / 1,175 ft |
Rank | Name | City |
Status
Completed Architecturally Topped Out Structurally Topped Out Under Construction On Hold Proposed Vision Never Completed Demolished Competition Entry Canceled Proposed Renovation Under Renovation Renovated Under Demolition
Filter by
✕
Completed Architecturally Topped Out Structurally Topped Out Under Construction On Hold Proposed Vision Never Completed Demolished Competition Entry Canceled Proposed Renovation Under Renovation Renovated Under Demolition
+
Select All | Completion | Height |
---|---|---|---|---|---|
1 |
- | 1000 m / 3,281 ft |
|||
2 |
2022 | 828 m / 2,717 ft |
|||
3 |
- | 636 m / 2,087 ft |
|||
4 |
2015 | 632 m / 2,073 ft |
|||
5 |
- | 476 m / 1,560 ft |
|||
6 |
2022 | 468 m / 1,535 ft |
|||
7 |
- | 468 m / 1,535 ft |
|||
8 |
2010 | 450 m / 1,476 ft |
|||
9 |
2019 | 445 m / 1,460 ft |
|||
10 |
2019 | 438 m / 1,437 ft |
|||
11 |
2020 | 427 m / 1,401 ft |
|||
12 |
2020 | 376 m / 1,232 ft |
|||
13 |
2021 | 358 m / 1,175 ft |
|||
14 |
2015 | 354 m / 1,162 ft |
|||
15 |
2010 | 330 m / 1,083 ft |
|||
16 |
2013 | 309 m / 1,015 ft |
|||
17 |
2013 | 306 m / 1,005 ft |
|||
18 |
2015 | 303 m / 994 ft |
|||
18 |
2015 | 303 m / 994 ft |
|||
20 |
2015 | 301 m / 987 ft |
|||
21 |
2015 | 268 m / 879 ft |
|||
22 |
2013 | 260 m / 853 ft |
|||
23 |
2016 | 260 m / 853 ft |
|||
24 |
2013 | 246 m / 805 ft |
|||
25 |
2014 | 231 m / 759 ft |
|||
26 |
2020 | 229 m / 753 ft |
|||
27 |
2016 | 228 m / 748 ft |
|||
28 |
2015 | 225 m / 736 ft |
|||
29 |
2018 | 206 m / 677 ft |
|||
30 |
2016 | 204 m / 669 ft |
|||
31 |
2013 | 198 m / 649 ft |
|||
32 |
2017 | 194 m / 635 ft |
|||
33 |
2020 | 173 m / 568 ft |
|||
34 |
2020 | 166 m / 545 ft |
|||
35 |
2016 | 161 m / 529 ft |
|||
36 |
2014 | 158 m / 517 ft |
|||
37 |
2017 | 157 m / 515 ft |
|||
38 |
- | 156 m / 512 ft |
|||
39 |
2019 | 146 m / 479 ft |
|||
40 |
2017 | 142 m / 466 ft |
|||
41 |
2007 | 114 m / 375 ft |
|||
42 |
- | 110 m / 361 ft |
|||
43 |
2020 | 102 m / 334 ft |
|||
44 |
2017 | 100 m / 328 ft |
|||
44 |
2017 | 100 m / 328 ft |
|||
46 |
2017 | 100 m / 328 ft |
|||
47 |
2018 | 93 m / 306 ft |
|||
48 |
2019 | 88 m / 289 ft |
|||
49 |
2017 | 74 m / 243 ft |
|||
50 |
2017 | 70 m / 230 ft |
22–23 September 2012
Nanjing, the venerable “Southern capital,” is in the midst of the type of redevelopment surge impacting many Chinese cities.
Subscribe below to receive periodic updates from CTBUH on the latest Tall Building and Urban news and CTBUH initiatives, including our monthly newsletter. Fields with a red asterisk (*) next to them are required.
View our privacy policy1 x Application (95.81%) | 714.56ms |
1 x Booting (4.17%) | 31.09ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
select * from `ctbuh_company` where `ctbuh_company`.`id` = '6935' limit 1
12.49ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
SELECT c1.status, c2.id AS new_id, c2.name AS new_name, c2.status AS new_status, c1.new_company_year FROM ctbuh_company c1 LEFT JOIN ctbuh_company c2 ON c1.new_company = c2.id WHERE c1.id = '6935' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name
2.09ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '6935' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
155ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '6935' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
129ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'SWA Group' and `active` = '1'
7.53ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (6935, 6935)
4.25ms/app/CtbuhCompany.php:328buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (1082, 8829, 12845, 16679, 16680, 363, 12025, 14403, 10293, 8771, 13688, 21222, 21223, 21224, 21225, 21226, 21227, 9110, 1858, 14460, 13773, 56, 10825, 3, 505, 23594, 379, 464, 454, 9109, 8772, 8823, 2, 14196, 165, 12572, 9671, 15292, 15196, 16049, 14198, 16849, 30601, 33983, 29814, 35323, 36246, 36245, 36434, 36435, 24971, 31705, 36595, 36599, 36600) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
5.4ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (630, 745, 746, 752, 754, 776, 789, 795, 802, 803, 806, 813, 972, 1072, 1118, 1439, 1450, 1478, 1488, 1554, 1640, 1657, 1693, 1789)
2.02ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 34, 72, 85, 112, 135, 137, 158, 163)
1.52ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 34, 72, 85, 112, 135, 137, 158, 163)
1.53ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select `v3_images`.*, `v3_building_image`.`building_id` as `pivot_building_id`, `v3_building_image`.`image_id` as `pivot_image_id`, `v3_building_image`.`position` as `pivot_position` from `v3_images` inner join `v3_building_image` on `v3_images`.`id` = `v3_building_image`.`image_id` where `v3_building_image`.`building_id` in (2, 3, 56, 165, 363, 379, 454, 464, 505, 1082, 1858, 8771, 8772, 8823, 8829, 9109, 9110, 9671, 10293, 10825, 12025, 12572, 12845, 13688, 13773, 14196, 14198, 14403, 14460, 15196, 15292, 16049, 16679, 16680, 16849, 21222, 21223, 21224, 21225, 21226, 21227, 23594, 24971, 29814, 30601, 31705, 33983, 35323, 36245, 36246, 36595, 36599, 36600) order by `position` asc
13.41ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.66ms/app/Http/Controllers/CtbuhCompanyController.php:59buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `v2_members`.*, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id`, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id` from `v2_members` inner join `v2_ctbuh_company_member` on `v2_members`.`id` = `v2_ctbuh_company_member`.`member_id` where `v2_ctbuh_company_member`.`ctbuh_company_id` = 6935 and `v2_members`.`deleted_at` is null
2.97ms/app/CtbuhCompany.php:91buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `name`, `name_chinese` from `v2_membership_levels` where `id` = 15
1.13ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_awards` where (`building_id` in (2, 3, 9671, 56, 33983, 12845, 10293, 165, 24971, 8823, 14196, 14198, 12572, 363, 379, 454, 464, 9109, 9110, 505, 13773, 8771, 14460, 8829, 1082, 13688, 1858, 12025, 16049, 15292, 8772, 31705, 16679, 16680, 16849, 23594, 21227, 36245, 14403, 21226, 10825, 36246, 30601, 36595, 36599, 35323, 15196, 29814, 36600, 21222, 21223, 21225, 21224) or `company_id` = 6935) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc
2.52ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `ctbuh_building`.`id` in (24971, 3, 16849, 56, 56, 9109, 14460, 8771, 56, 9109, 3, 15196, 8771, 464, 8829, 454, 3, 3, 165) and `ctbuh_building`.`deleted_at` is null
5.11ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 315
2.45ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 315
1.87ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 315
1.2ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
2,3,9671,56,33983,12845,10293,165,24971,8823,14196,14198,12572,363,379,454,464,9109,9110,505,13773,8771,14460,8829,1082,13688,1858,12025,16049,15292,8772,31705,16679,16680,16849,23594,21227,36245,14403,21226,10825,36246,30601,36595,36599,35323,15196,29814,36600,21222,21223,21225,21224
)
AND id_company_type IN(13, 11)
AND id_company IN(
6935
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
2,3,9671,56,33983,12845,10293,165,24971,8823,14196,14198,12572,363,379,454,464,9109,9110,505,13773,8771,14460,8829,1082,13688,1858,12025,16049,15292,8772,31705,16679,16680,16849,23594,21227,36245,14403,21226,10825,36246,30601,36595,36599,35323,15196,29814,36600,21222,21223,21225,21224
)
AND category_id IN(1, 2)
AND company_id IN(
6935
)
7.77ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('6935')
1.24ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('6935')
2.18ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resources` where `id` in (1399, 1402) order by `date` desc
2.25ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1072)
1.49ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 24 limit 1
1.5ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 24 limit 1
1.72ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_initiatives` where `id` in (21) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1744222179) order by `start_date` desc
8.04ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (789)
2.84ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 315 and `v2_people`.`member_id` is not null
3.48ms/app/Http/Controllers/CtbuhCompanyController.php:423buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `v2_roles`.*, `v2_person_role`.`person_id` as `pivot_person_id`, `v2_person_role`.`role_id` as `pivot_role_id`, `v2_person_role`.`year_start` as `pivot_year_start`, `v2_person_role`.`year_end` as `pivot_year_end`, `v2_person_role`.`title` as `pivot_title`, `v2_person_role`.`link` as `pivot_link`, `v2_person_role`.`display_order` as `pivot_display_order`, `v2_person_role`.`hide_in_lists` as `pivot_hide_in_lists` from `v2_roles` inner join `v2_person_role` on `v2_roles`.`id` = `v2_person_role`.`role_id` where `v2_person_role`.`person_id` in (1759, 3830, 8434, 8435, 21753, 21754, 21755, 21756, 21757, 21758, 21759, 21760, 37729) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.65ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'SWA Group' and `active` = '1'
5.02ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (6935, 6935, 6935)
1.52ms/app/CtbuhCompany.php:328buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (1082, 8829, 12845, 16679, 16680, 363, 12025, 14403, 10293, 8771, 13688, 21222, 21223, 21224, 21225, 21226, 21227, 9110, 1858, 14460, 13773, 56, 10825, 3, 505, 23594, 379, 464, 454, 9109, 8772, 8823, 2, 14196, 165, 12572, 9671, 15292, 15196, 16049, 14198, 16849, 30601, 33983, 29814, 35323, 36246, 36245, 36434, 36435, 24971, 31705, 36595, 36599, 36600) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
9.37ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 2 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.66ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 3 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.53ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 9671 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.46ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 56 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.72ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 33983 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.71ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 12845 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.68ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 10293 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.95ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 165 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.56ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 24971 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.44ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 8823 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.38ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 14196 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.38ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 14198 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.3ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 12572 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.39ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 363 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.24ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 379 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.35ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 454 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.65ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 464 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.97ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 9109 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.82ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 9110 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.49ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 505 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.58ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 13773 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.65ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 8771 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.36ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 14460 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.42ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 8829 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.59ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 1082 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.36ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 13688 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
8.62ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 1858 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.52ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 12025 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.43ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 16049 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.44ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 15292 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.48ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 8772 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.36ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 31705 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.5ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 16679 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.41ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 16680 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.32ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 16849 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.06ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 23594 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.25ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21227 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.25ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 36245 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.38ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 14403 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.55ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21226 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.43ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 10825 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.17ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 36246 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
7.54ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 30601 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.43ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 36595 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.39ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 36599 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.54ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 35323 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.46ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 15196 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.63ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 29814 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.34ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 36600 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.55ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21222 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.39ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21223 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.32ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21225 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.34ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 21224 and `published_at` < '2025-04-09 18:09:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.55ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT
ctbuh_building.id,
name_intl,
status,
(height_architecture - height_floor) AS vanity_height,
((height_architecture - height_floor) / height_architecture) AS vanity_height_pct,
floors_above,
completed,
height_architecture,
height_floor
FROM ctbuh_building
WHERE
height_floor != 0 AND
completed > 0 AND
active = 1 AND structure_type IN('building') AND ctbuh_building.id in (2, 3, 9671, 56, 33983, 12845, 10293, 165, 24971, 8823, 14196, 14198, 12572, 363, 379, 454, 464, 9109, 9110, 505, 13773, 8771, 14460, 8829, 1082, 13688, 1858, 12025, 16049, 15292, 8772, 31705, 16679, 16680, 16849, 23594, 21227, 36245, 14403, 21226, 10825, 36246, 30601, 36595, 36599, 35323, 15196, 29814, 36600, 21222, 21223, 21225, 21224) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC
2.58ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 315 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1
2.7ms/app/Member.php:28buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 315 order by `headquarters` desc, `contact` desc, `name` asc
1.96msview::companies.partials.display-overview:17buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 315 order by `display_order` asc, `field` asc
1.26msview::companies.partials.display-overview:53buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
2.07ms/app/NavMenuItem.php:17buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 27 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
2.65ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
2.2ms/app/NavMenuItem.php:97buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 28 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
1.2ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 2 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
2.13ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 4 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
1.27ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 3 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
1.43ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 29 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
1.22ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 1 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc
1.59ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
200
[]
[]
0 of 0array:17 [▶ "priority" => array:1 [▶ 0 => "u=0, i" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "host" => array:1 [▶ 0 => "staging.skyscrapercenter.xyz" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0array:40 [▶ "USER" => "forge" "HOME" => "/home/forge" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_HOST" => "staging.skyscrapercenter.xyz" "REDIRECT_STATUS" => "200" "HTTPS" => "on" "SERVER_NAME" => "staging.skyscrapercenter.xyz" "SERVER_PORT" => "443" "SERVER_ADDR" => "10.0.0.44" "REMOTE_PORT" => "6856" "REMOTE_ADDR" => "18.191.44.99" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/2.0" "DOCUMENT_ROOT" => "/home/forge/staging.skyscrapercenter.xyz/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/company/6935" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/forge/staging.skyscrapercenter.xyz/public/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744222178.692 "REQUEST_TIME" => 1744222178 ]
[]
0 of 0array:5 [▶ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 09 Apr 2025 18:09:39 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlphU1I5RGlWZXFQZmY2Y3oxTkpVSVE9PSIsInZhbHVlIjoiTU16azRmMjdVZmw4TXN0ZWZtVEhHY0NMWTl0alhyelFUcEZaUm5KQzdZdmlhcmhweXVaNXJHWkhld3YyUXBiNjJjU1BvTDVnOTZQcXlOdXJQdXJEMU9ZM2xNZ3FSMUZaUlliVjM4M2NqT2tQWGQ0S21qWEY2ajE5S2xvU1wvZzNVIiwibWFjIjoiMzgwNWYzNDg5NWZlZWFiZjlkMWRkY2Q3YjJkMDkyMGQyZjVkMzU5NzQ1MGMxZjExMDNmYjJmMWY4MWRiNmE1MCJ9; expires=Wed, 09-Apr-2025 20:09:39 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlphU1I5RGlWZXFQZmY2Y3oxTkpVSVE9PSIsInZhbHVlIjoiTU16azRmMjdVZmw4TXN0ZWZtVEhHY0NMWTl0alhyelFUcEZaUm5KQzdZdmlhcmhweXVaNXJHWkhld3YyUXBiNjJjU1BvT ▶" 1 => "skyscraper_center_session=eyJpdiI6IjNsNVwvTjNZUUxcL1ErMFo0eDFad1hCUT09IiwidmFsdWUiOiJUN20rV2hqcDVlWnc4enFWRXNMbUZSaVg0YzVIMlZaUU1SQUZoUWluOVp6SHRCa2dKNUZKSjU4RVBcLzBwTDNVclhob09iaDhLTktWYkI4ZGZReFI4OUJBODZ2N0VEQkp0Wk9ETVwvYXpESjBXeWVud3h1TXhiZDJkeTNkcFRnbm92IiwibWFjIjoiMmY2Njk1MWEzODM5NmU0ZjRhYzQ4MWZkMDU2OTg2NDZmZDEzNTFlMmViNjA5MmI3ZWEyMTg5NjdlM2E1Njk1NSJ9; expires=Wed, 09-Apr-2025 20:09:39 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjNsNVwvTjNZUUxcL1ErMFo0eDFad1hCUT09IiwidmFsdWUiOiJUN20rV2hqcDVlWnc4enFWRXNMbUZSaVg0YzVIMlZaUU1SQUZoUWluOVp6SHRCa2dKNUZKSjU4RV ▶" 2 => "visit_counter=eyJpdiI6InFrZTlOenR1R1haRnJtSXZvNjFST0E9PSIsInZhbHVlIjoiWFVGRUwycUVBWUdxbGxGendHOGxpaXhBXC9hbXZTZ3FcL1BRMzVaY0RUYXdXK0VEOHoxUEtkNzl3Z3JIT3h3NUpLIiwibWFjIjoiMDVjNDQxYTBmOWNkYmE5ZTUzNjlmNDk1ZjdiZTcwN2ZlMmFlNzM1YzY5ZjllNmZiNWI4MzBiOGZmMWMwYWY5ZCJ9; expires=Fri, 09-May-2025 18:09:38 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6InFrZTlOenR1R1haRnJtSXZvNjFST0E9PSIsInZhbHVlIjoiWFVGRUwycUVBWUdxbGxGendHOGxpaXhBXC9hbXZTZ3FcL1BRMzVaY0RUYXdXK0VEOHoxUEtkNzl3Z3JIT3h3NUpLIi ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlphU1I5RGlWZXFQZmY2Y3oxTkpVSVE9PSIsInZhbHVlIjoiTU16azRmMjdVZmw4TXN0ZWZtVEhHY0NMWTl0alhyelFUcEZaUm5KQzdZdmlhcmhweXVaNXJHWkhld3YyUXBiNjJjU1BvTDVnOTZQcXlOdXJQdXJEMU9ZM2xNZ3FSMUZaUlliVjM4M2NqT2tQWGQ0S21qWEY2ajE5S2xvU1wvZzNVIiwibWFjIjoiMzgwNWYzNDg5NWZlZWFiZjlkMWRkY2Q3YjJkMDkyMGQyZjVkMzU5NzQ1MGMxZjExMDNmYjJmMWY4MWRiNmE1MCJ9; expires=Wed, 09-Apr-2025 20:09:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlphU1I5RGlWZXFQZmY2Y3oxTkpVSVE9PSIsInZhbHVlIjoiTU16azRmMjdVZmw4TXN0ZWZtVEhHY0NMWTl0alhyelFUcEZaUm5KQzdZdmlhcmhweXVaNXJHWkhld3YyUXBiNjJjU1BvT ▶" 1 => "skyscraper_center_session=eyJpdiI6IjNsNVwvTjNZUUxcL1ErMFo0eDFad1hCUT09IiwidmFsdWUiOiJUN20rV2hqcDVlWnc4enFWRXNMbUZSaVg0YzVIMlZaUU1SQUZoUWluOVp6SHRCa2dKNUZKSjU4RVBcLzBwTDNVclhob09iaDhLTktWYkI4ZGZReFI4OUJBODZ2N0VEQkp0Wk9ETVwvYXpESjBXeWVud3h1TXhiZDJkeTNkcFRnbm92IiwibWFjIjoiMmY2Njk1MWEzODM5NmU0ZjRhYzQ4MWZkMDU2OTg2NDZmZDEzNTFlMmViNjA5MmI3ZWEyMTg5NjdlM2E1Njk1NSJ9; expires=Wed, 09-Apr-2025 20:09:39 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjNsNVwvTjNZUUxcL1ErMFo0eDFad1hCUT09IiwidmFsdWUiOiJUN20rV2hqcDVlWnc4enFWRXNMbUZSaVg0YzVIMlZaUU1SQUZoUWluOVp6SHRCa2dKNUZKSjU4RV ▶" 2 => "visit_counter=eyJpdiI6InFrZTlOenR1R1haRnJtSXZvNjFST0E9PSIsInZhbHVlIjoiWFVGRUwycUVBWUdxbGxGendHOGxpaXhBXC9hbXZTZ3FcL1BRMzVaY0RUYXdXK0VEOHoxUEtkNzl3Z3JIT3h3NUpLIiwibWFjIjoiMDVjNDQxYTBmOWNkYmE5ZTUzNjlmNDk1ZjdiZTcwN2ZlMmFlNzM1YzY5ZjllNmZiNWI4MzBiOGZmMWMwYWY5ZCJ9; expires=Fri, 09-May-2025 18:09:38 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InFrZTlOenR1R1haRnJtSXZvNjFST0E9PSIsInZhbHVlIjoiWFVGRUwycUVBWUdxbGxGendHOGxpaXhBXC9hbXZTZ3FcL1BRMzVaY0RUYXdXK0VEOHoxUEtkNzl3Z3JIT3h3NUpLIi ▶" ] ]
0 of 0array:4 [▶ "_token" => "Sf6VDBAv26iNqjuDiomZzuwfl1MoJy3lk2WLXU4Z" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/company/6935" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]