CoxGomyl is a leading global provider of facade access solutions. Present around the world with over 60 years of experience, CoxGomyl has the widest range of configurable building maintenance systems built on innovative, proven technologies which provide exceptional performance. Rising to the challenge, CoxGomyl are present around the world to provide a range of building maintenance systems and building access units to architects, consultants, developers, constructors and building owners. From design, manufacturing, installation and maintenance, CoxGomyl are leaders in facade access solutions.
CoxGomyl is owned by Alimak Group. Alimak Group has been a pioneer and industry leader for 70 years.
Building Maintenance; Façade Systems
Guangzhou CTF Finance Centre, Guangzhou
Tianjin CTF Finance Centre, Tianjin
Shanghai World Financial Center, Shanghai
Guangzhou International Finance Center, Guangzhou
Eton Place Dalian Tower 1, Dalian
Bank of China Tower, Hong Kong
Comcast Technology Center, Philadelphia
Jumeirah Nanjing Hotel & International Youth Cultural Centre Tower 2, Nanjing
Eton Place Dalian Tower 2, Dalian
Jumeirah Nanjing Hotel & International Youth Cultural Centre Tower 1, Nanjing
Federation Tower - Zapad Tower, Moscow
Alvear Tower Puerto Madero, Buenos Aires
Goldin Financial Global Centre, Hong Kong
The Résidence Palace, Brussels
Membership Level
Silver
Member Since
2016
Member Offices
Melbourne
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 |
2022 |
828 m / 2,717 ft |
|||
2 |
2016 |
530 m / 1,739 ft |
|||
3 |
2019 |
530 m / 1,739 ft |
|||
4 |
2018 |
527.7 m / 1,731 ft |
|||
5 |
2004 |
508 m / 1,667 ft |
|||
6 |
2008 |
492 m / 1,614 ft |
|||
7 |
2010 |
450 m / 1,476 ft |
|||
8 |
2010 |
438.6 m / 1,439 ft |
|||
9 |
2017 |
425 m / 1,394 ft |
|||
10 |
2016 |
383.2 m / 1,257 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 |
2022 | 828 m / 2,717 ft |
|||
2 |
2016 | 530 m / 1,739 ft |
|||
3 |
2019 | 530 m / 1,739 ft |
|||
4 |
2018 | 528 m / 1,731 ft |
|||
5 |
2004 | 508 m / 1,667 ft |
|||
6 |
2008 | 492 m / 1,614 ft |
|||
7 |
2010 | 480 m / 1,575 ft |
|||
8 |
2010 | 450 m / 1,476 ft |
|||
9 |
- | 442 m / 1,450 ft |
|||
10 |
2010 | 439 m / 1,439 ft |
|||
11 |
2017 | 425 m / 1,394 ft |
|||
12 |
2016 | 383 m / 1,257 ft |
|||
13 |
2016 | 374 m / 1,226 ft |
|||
14 |
1990 | 367 m / 1,205 ft |
|||
15 |
2018 | 359 m / 1,177 ft |
|||
16 |
2015 | 351 m / 1,150 ft |
|||
17 |
2015 | 342 m / 1,122 ft |
|||
18 |
2018 | 339 m / 1,112 ft |
|||
19 |
2013 | 339 m / 1,112 ft |
|||
20 |
2010 | 326 m / 1,070 ft |
|||
21 |
2019 | 320 m / 1,050 ft |
|||
22 |
Jumeirah Nanjing Hotel & International Youth Cultural Centre Tower 2 |
2015 | 315 m / 1,033 ft |
||
23 |
2013 | 309 m / 1,015 ft |
|||
24 |
2013 | 306 m / 1,004 ft |
|||
25 |
2012 | 303 m / 993 ft |
|||
26 |
2015 | 280 m / 917 ft |
|||
27 |
Jumeirah Nanjing Hotel & International Youth Cultural Centre Tower 1 |
2015 | 255 m / 837 ft |
||
28 |
2008 | 248 m / 815 ft |
|||
29 |
2008 | 243 m / 796 ft |
|||
30 |
2010 | 240 m / 786 ft |
|||
31 |
2018 | 235 m / 771 ft |
|||
32 |
2014 | 160 m / 525 ft |
|||
33 |
2018 | 158 m / 517 ft |
|||
34 |
2011 | 153 m / 502 ft |
|||
35 |
2016 | 150 m / 492 ft |
|||
36 |
2017 | 146 m / 478 ft |
|||
37 |
2016 | 126 m / 413 ft |
|||
38 |
2010 | 121 m / 398 ft |
|||
39 |
2015 | 120 m / 394 ft |
|||
40 |
2017 | 45 m / 148 ft |
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 (96.78%) | 733.55ms |
1 x Booting (2.97%) | 22.49ms |
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 |
|
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 |
|
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` = '14259' limit 1
9.56ms/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 = '14259' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name
5.83ms/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 = '14259' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
181ms/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 = '14259' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
133ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'CoxGomyl' and `active` = '1'
3.37ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (14259, 14259)
1.21ms/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 (1077, 492, 957, 414, 14401, 3, 131, 387, 454, 14402, 8763, 28665, 28664, 878, 30233, 15269, 3789, 14218, 11116, 451, 310, 16192, 137, 165, 174, 249, 644, 287, 16024, 9337, 207, 265, 176, 17541, 3350, 317, 118, 117, 13268, 36434, 36435, 15741) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
6.51ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 630, 639, 667, 745, 746, 755, 766, 789, 795, 796, 803, 806, 903, 942, 989, 1083, 1439, 1488, 1539, 1544, 1641, 1657)
2.56ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 9, 16, 34, 51, 56, 75, 88, 135, 163)
1.52ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 9, 16, 34, 51, 56, 75, 88, 135, 163)
1.76ms/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 (3, 117, 118, 131, 137, 165, 174, 176, 207, 249, 265, 287, 310, 317, 387, 414, 451, 454, 492, 644, 878, 957, 1077, 3350, 3789, 8763, 9337, 11116, 13268, 14218, 14401, 14402, 15269, 15741, 16024, 16192, 17541, 28664, 28665, 30233) order by `position` asc
27.79ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.69ms/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` = 14259 and `v2_members`.`deleted_at` is null
1.96ms/app/CtbuhCompany.php:91buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `name`, `name_chinese` from `v2_membership_levels` where `id` = 15
6.49ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_awards` where (`building_id` in (3, 176, 310, 11116, 117, 131, 137, 165, 9337, 174, 207, 249, 118, 287, 15741, 414, 8763, 16192, 265, 387, 317, 14401, 454, 451, 492, 644, 14402, 878, 957, 1077, 13268, 3350, 16024, 3789, 28664, 17541, 30233, 14218, 15269, 28665) or `company_id` = 14259) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc
3.84ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `ctbuh_building`.`id` in (174, 317, 16192, 310, 11116, 310, 310, 137, 3, 11116, 15741, 11116, 131, 117, 414, 15269, 3, 137, 451, 454, 387, 174, 137, 3, 3, 165, 131, 131) and `ctbuh_building`.`deleted_at` is null
3.06ms/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` = 1007
1.47ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 1007
1.54ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 1007
1.97ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
3,176,310,11116,117,131,137,165,9337,174,207,249,118,287,15741,414,8763,16192,265,387,317,14401,454,451,492,644,14402,878,957,1077,13268,3350,16024,3789,28664,17541,30233,14218,15269,28665
)
AND id_company_type IN(13, 11)
AND id_company IN(
14259
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
3,176,310,11116,117,131,137,165,9337,174,207,249,118,287,15741,414,8763,16192,265,387,317,14401,454,451,492,644,14402,878,957,1077,13268,3350,16024,3789,28664,17541,30233,14218,15269,28665
)
AND category_id IN(1, 2)
AND company_id IN(
14259
)
11.99ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('14259')
2.73ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('14259')
3.05ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resources` where `id` in (2765, 2767, 2766, 3265, 3269, 3270, 3266, 3355, 3353, 3354, 3267, 3268, 2835, 2834, 2833, 2832, 2831, 2830, 2829, 2828) order by `date` desc
4.35ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 630, 653, 667, 746, 766, 789, 942, 2125)
2.31ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.51ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.44ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.86ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.36ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.29ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.26ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 1
1.27ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 1007 and `v2_people`.`member_id` is not null
8.1ms/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 (9985, 16027, 17958, 22267, 24299, 24309, 24310, 24311, 24312, 24313, 24314, 24315, 24316, 24317, 26035, 32854) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.94ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'CoxGomyl' and `active` = '1'
1.47ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (14259, 14259, 14259)
1.91ms/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 (1077, 492, 957, 414, 14401, 3, 131, 387, 454, 14402, 8763, 28665, 28664, 878, 30233, 15269, 3789, 14218, 11116, 451, 310, 16192, 137, 165, 174, 249, 644, 287, 16024, 9337, 207, 265, 176, 17541, 3350, 317, 118, 117, 13268, 36434, 36435, 15741) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
11.62ms/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` = 3 and `published_at` < '2025-04-10 10:27:34' 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` = 176 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
6.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` = 310 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.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` = 11116 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.61ms/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` = 117 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.21ms/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` = 131 and `published_at` < '2025-04-10 10:27:34' 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` = 137 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.37ms/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-10 10:27:34' 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` = 9337 and `published_at` < '2025-04-10 10:27:34' 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` = 174 and `published_at` < '2025-04-10 10:27:34' 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` = 207 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.31ms/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` = 249 and `published_at` < '2025-04-10 10:27:34' 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` = 118 and `published_at` < '2025-04-10 10:27:34' 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` = 287 and `published_at` < '2025-04-10 10:27:34' 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` = 15741 and `published_at` < '2025-04-10 10:27:34' 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` = 414 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 8763 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.4ms/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` = 16192 and `published_at` < '2025-04-10 10:27:34' 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` = 265 and `published_at` < '2025-04-10 10:27:34' 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` = 387 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.33ms/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` = 317 and `published_at` < '2025-04-10 10:27:34' 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` = 14401 and `published_at` < '2025-04-10 10:27:34' 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` = 454 and `published_at` < '2025-04-10 10:27:34' 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` = 451 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.27ms/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` = 492 and `published_at` < '2025-04-10 10:27:34' 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` = 644 and `published_at` < '2025-04-10 10:27:34' 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` = 14402 and `published_at` < '2025-04-10 10:27:34' 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` = 878 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.33ms/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` = 957 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.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` = 1077 and `published_at` < '2025-04-10 10:27:34' 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` = 13268 and `published_at` < '2025-04-10 10:27:34' 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` = 3350 and `published_at` < '2025-04-10 10:27:34' 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` = 16024 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.92ms/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` = 3789 and `published_at` < '2025-04-10 10:27:34' 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` = 28664 and `published_at` < '2025-04-10 10:27:34' 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` = 17541 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.79ms/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` = 30233 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.26ms/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` = 14218 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.29ms/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` = 15269 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.37ms/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` = 28665 and `published_at` < '2025-04-10 10:27:34' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.28ms/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 (3, 176, 310, 11116, 117, 131, 137, 165, 9337, 174, 207, 249, 118, 287, 15741, 414, 8763, 16192, 265, 387, 317, 14401, 454, 451, 492, 644, 14402, 878, 957, 1077, 13268, 3350, 16024, 3789, 28664, 17541, 30233, 14218, 15269, 28665) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC
4.31ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 1007 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1
1.58ms/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` = 1007 order by `headquarters` desc, `contact` desc, `name` asc
3.33msview::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` = 1007 order by `display_order` asc, `field` asc
1.38msview::companies.partials.display-overview:53buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.2ms/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
1.43ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.33ms/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.45ms/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
1.26ms/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.34ms/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.31ms/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.47ms/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" => "9102" "REMOTE_ADDR" => "3.14.253.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/14259" "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" => 1744280853.8456 "REQUEST_TIME" => 1744280853 ]
[]
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 => "Thu, 10 Apr 2025 10:27:34 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjBFTjBGVVBvdlRRbnZ1YisrNEpnRVE9PSIsInZhbHVlIjoiRmtBTVN5VjNVWW9TTFBhSDJxQ0dJNWdNRmg0VzRUUHJlT2hwMXJaRlJDWXlJZ2UwN0xGUVhYd0VRVUt3Sm16WGx0OFwvUmJxUFN2bWY0WHBRMXY4RVpudWtPK04rVUgycmM0aExxcjNZVDNHMTljcENvRDNhNzBtdEJkRHJ0M1wvTyIsIm1hYyI6IjY0YTIyNmQ0OWM0MjhkZjRlN2MwYjljYzA5MzgyNTNjODhhOTAyYTA5ZGVjMDcwNDg0OTU3MmQzYzdmODFlYTEifQ%3D%3D; expires=Thu, 10-Apr-2025 12:27:34 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBFTjBGVVBvdlRRbnZ1YisrNEpnRVE9PSIsInZhbHVlIjoiRmtBTVN5VjNVWW9TTFBhSDJxQ0dJNWdNRmg0VzRUUHJlT2hwMXJaRlJDWXlJZ2UwN0xGUVhYd0VRVUt3Sm16WGx0OFwvU ▶" 1 => "skyscraper_center_session=eyJpdiI6IjJVV2x6WnQyZWppU0RlWkhna0NHa2c9PSIsInZhbHVlIjoib3hMeTN2OVVIWHpWRVZBekllWlh5aUxxUWFUZG5PMk9sZU44WXdScFRUUGlEdDZUdW5OWTAzazJzUVh4UlVIekI3ZGNcL1ZtNWJRMG00NFNZa3oyU05lT3hXNlI2YWl0QnFSUW9aZUxoVWJQTks5OUJBSEsrbmcwRGZcL0t1ZElUeiIsIm1hYyI6IjRhZWVlYjM1MzAwNThiMTM5NDk2MDc2ZmQxMTFkOWNhNjhlMWRlOGQxMTg2YzA5OTA5Y2M1ZjU0NWY0NWEwM2MifQ%3D%3D; expires=Thu, 10-Apr-2025 12:27:34 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjJVV2x6WnQyZWppU0RlWkhna0NHa2c9PSIsInZhbHVlIjoib3hMeTN2OVVIWHpWRVZBekllWlh5aUxxUWFUZG5PMk9sZU44WXdScFRUUGlEdDZUdW5OWTAzazJzUV ▶" 2 => "visit_counter=eyJpdiI6IkJGM29cL1BwVldMbnBSM2ZzMEhvamJnPT0iLCJ2YWx1ZSI6InZYTklKeHY1SEhzRWVmSkh2XC9HWUJRc3JIRTh2TVRSR3ZWOSswaHpzeVFRK3YwYUs2VlVqRGZ6ZmpZZkFYRTBsIiwibWFjIjoiMTk1OTc2MDAxMjUxMDFmMzNiZDA3ZWQ0NmQxNTE5MzVmMmE3OTMyYTU4ZGNlZjNjZGYyZTY2OWQxMzhmM2IwMCJ9; expires=Sat, 10-May-2025 10:27:33 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IkJGM29cL1BwVldMbnBSM2ZzMEhvamJnPT0iLCJ2YWx1ZSI6InZYTklKeHY1SEhzRWVmSkh2XC9HWUJRc3JIRTh2TVRSR3ZWOSswaHpzeVFRK3YwYUs2VlVqRGZ6ZmpZZkFYRTBsIi ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjBFTjBGVVBvdlRRbnZ1YisrNEpnRVE9PSIsInZhbHVlIjoiRmtBTVN5VjNVWW9TTFBhSDJxQ0dJNWdNRmg0VzRUUHJlT2hwMXJaRlJDWXlJZ2UwN0xGUVhYd0VRVUt3Sm16WGx0OFwvUmJxUFN2bWY0WHBRMXY4RVpudWtPK04rVUgycmM0aExxcjNZVDNHMTljcENvRDNhNzBtdEJkRHJ0M1wvTyIsIm1hYyI6IjY0YTIyNmQ0OWM0MjhkZjRlN2MwYjljYzA5MzgyNTNjODhhOTAyYTA5ZGVjMDcwNDg0OTU3MmQzYzdmODFlYTEifQ%3D%3D; expires=Thu, 10-Apr-2025 12:27:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBFTjBGVVBvdlRRbnZ1YisrNEpnRVE9PSIsInZhbHVlIjoiRmtBTVN5VjNVWW9TTFBhSDJxQ0dJNWdNRmg0VzRUUHJlT2hwMXJaRlJDWXlJZ2UwN0xGUVhYd0VRVUt3Sm16WGx0OFwvU ▶" 1 => "skyscraper_center_session=eyJpdiI6IjJVV2x6WnQyZWppU0RlWkhna0NHa2c9PSIsInZhbHVlIjoib3hMeTN2OVVIWHpWRVZBekllWlh5aUxxUWFUZG5PMk9sZU44WXdScFRUUGlEdDZUdW5OWTAzazJzUVh4UlVIekI3ZGNcL1ZtNWJRMG00NFNZa3oyU05lT3hXNlI2YWl0QnFSUW9aZUxoVWJQTks5OUJBSEsrbmcwRGZcL0t1ZElUeiIsIm1hYyI6IjRhZWVlYjM1MzAwNThiMTM5NDk2MDc2ZmQxMTFkOWNhNjhlMWRlOGQxMTg2YzA5OTA5Y2M1ZjU0NWY0NWEwM2MifQ%3D%3D; expires=Thu, 10-Apr-2025 12:27:34 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjJVV2x6WnQyZWppU0RlWkhna0NHa2c9PSIsInZhbHVlIjoib3hMeTN2OVVIWHpWRVZBekllWlh5aUxxUWFUZG5PMk9sZU44WXdScFRUUGlEdDZUdW5OWTAzazJzUV ▶" 2 => "visit_counter=eyJpdiI6IkJGM29cL1BwVldMbnBSM2ZzMEhvamJnPT0iLCJ2YWx1ZSI6InZYTklKeHY1SEhzRWVmSkh2XC9HWUJRc3JIRTh2TVRSR3ZWOSswaHpzeVFRK3YwYUs2VlVqRGZ6ZmpZZkFYRTBsIiwibWFjIjoiMTk1OTc2MDAxMjUxMDFmMzNiZDA3ZWQ0NmQxNTE5MzVmMmE3OTMyYTU4ZGNlZjNjZGYyZTY2OWQxMzhmM2IwMCJ9; expires=Sat, 10-May-2025 10:27:33 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IkJGM29cL1BwVldMbnBSM2ZzMEhvamJnPT0iLCJ2YWx1ZSI6InZYTklKeHY1SEhzRWVmSkh2XC9HWUJRc3JIRTh2TVRSR3ZWOSswaHpzeVFRK3YwYUs2VlVqRGZ6ZmpZZkFYRTBsIi ▶" ] ]
0 of 0array:4 [▶ "_token" => "ymGiLYVGkDLhi5WgA36qZG6besITyXd2mghhifYS" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/company/14259" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]