Salas O’Brien is an employee-owned firm providing building and facility solutions to clients across the United States. Our team of engaged experts focuses on achieving high quality, great relationships, and a sustainable future.
We help clients in a variety of industries by providing mechanical and electrical engineering as well as consulting for district utilities, site planning, technology, fire protection, industrial process engineering, architecture, and more. Our specialized experience includes design for data centers, healthcare, science and technology, high-rise buildings, clean energy, education, and other building types.
Mechanical, Electrical & Plumbing
Trump International Hotel & Tower, Chicago
Doosan Haeundae We've the Zenith Tower A, Busan
One Chicago Square East Tower, Chicago
Doosan Haeundae We've the Zenith Tower B, Busan
Doosan Haeundae We've the Zenith Tower C, Busan
The Legacy at Millennium Park, Chicago
One Chicago Square West Tower, Chicago
The Ritz-Carlton Residences, Chicago
Roosevelt University Academic, Student Life Residence Center, Chicago
The Fairbanks at Cityfront Plaza, Chicago
Hilton Garden Inn Chicago North Loop, Chicago
Ronald McDonald House, Chicago
GEMS World Academy - Chicago, Lower School, Chicago
Membership Level
Silver
Member Since
2018
Member Offices
Chicago
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 |
2009 |
423.2 m / 1,389 ft |
|||
2 |
2011 |
300 m / 984 ft |
|||
3 |
2022 |
295.8 m / 971 ft |
|||
4 |
2011 |
281.5 m / 924 ft |
|||
5 |
2011 |
265 m / 869 ft |
|||
6 |
2018 |
255.2 m / 837 ft |
|||
7 |
2010 |
249.3 m / 818 ft |
|||
8 |
2009 |
239.1 m / 785 ft |
|||
9 |
2001 |
196.3 m / 644 ft |
|||
10 |
2003 |
185.9 m / 610 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 |
2009 | 423 m / 1,389 ft |
|||
2 |
2011 | 300 m / 984 ft |
|||
3 |
2022 | 296 m / 971 ft |
|||
4 |
2011 | 282 m / 924 ft |
|||
5 |
2011 | 265 m / 869 ft |
|||
6 |
2018 | 255 m / 837 ft |
|||
7 |
2010 | 249 m / 818 ft |
|||
8 |
2009 | 239 m / 785 ft |
|||
9 |
2001 | 196 m / 644 ft |
|||
10 |
2003 | 186 m / 610 ft |
|||
11 |
2009 | 180 m / 589 ft |
|||
12 |
2013 | 178 m / 583 ft |
|||
13 |
2021 | 175 m / 574 ft |
|||
14 |
2021 | 171 m / 562 ft |
|||
15 |
2007 | 157 m / 514 ft |
|||
16 |
2018 | 151 m / 495 ft |
|||
17 |
2012 | 151 m / 495 ft |
|||
18 |
2018 | 150 m / 491 ft |
|||
19 |
Roosevelt University Academic, Student Life Residence Center |
2012 | 143 m / 469 ft |
||
20 |
2006 | 129 m / 425 ft |
|||
21 |
2003 | 128 m / 421 ft |
|||
22 |
2021 | 123 m / 403 ft |
|||
23 |
2008 | 118 m / 387 ft |
|||
24 |
2005 | 116 m / 380 ft |
|||
25 |
2015 | 112 m / 369 ft |
|||
26 |
2016 | 103 m / 338 ft |
|||
27 |
2018 | 98 m / 321 ft |
|||
28 |
2010 | 94 m / 308 ft |
|||
29 |
2018 | 89 m / 293 ft |
|||
30 |
2018 | 87 m / 286 ft |
|||
31 |
2015 | 77 m / 254 ft |
|||
32 |
2018 | 67 m / 221 ft |
|||
33 |
2004 | 66 m / 215 ft |
|||
34 |
2017 | 65 m / 213 ft |
|||
35 |
2015 | 61 m / 201 ft |
|||
36 |
2012 | 60 m / 198 ft |
|||
37 |
2020 | 59 m / 193 ft |
|||
38 |
2020 | 57 m / 186 ft |
|||
39 |
2014 | 56 m / 182 ft |
|||
40 |
2016 | 52 m / 172 ft |
|||
41 |
2014 | 47 m / 156 ft |
13 October 2016
The Council is pleased to announce the Top Company Rankings for numerous disciplines as derived from the list of projects appearing in 100 of the World’s Tallest Buildings.
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 (98.27%) | 633.14ms |
1 x Booting (1.71%) | 11.03ms |
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 |
|
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` = '1903' limit 1
10.63ms/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 = '1903' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name
1.17ms/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 = '1903' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
243ms/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 = '1903' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
118ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'WMA Consulting Engineers' and `active` = '1'
2.38ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (1903, 1903)
1.63ms/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 (16097, 9277, 9967, 18350, 14135, 5195, 5199, 23423, 23423, 14683, 14683, 13869, 2374, 5192, 9171, 24560, 24560, 16637, 3558, 13359, 2088, 27770, 1809, 21604, 20785, 22658, 19748, 17214, 8745, 31297, 31296, 203, 9969, 16519, 16519, 10751, 31356, 31356, 31356, 31357, 31357, 31357, 12095, 33408, 27135, 21604, 23426, 23426, 1009, 1009, 30504, 30503, 30503, 30503, 887) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
4.84ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1071, 1539, 1634, 2210)
2.21ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (85, 163)
1.45ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (85, 163)
1.47ms/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 (203, 887, 1009, 1809, 2088, 2374, 3558, 5192, 5195, 5199, 8745, 9171, 9277, 9967, 9969, 10751, 12095, 13359, 13869, 14135, 14683, 16097, 16519, 16637, 17214, 19748, 20785, 21604, 22658, 23423, 23426, 24560, 27135, 27770, 30503, 30504, 31296, 31297, 31356, 31357, 33408) order by `position` asc
7.73ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.6ms/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` = 1903 and `v2_members`.`deleted_at` is null
2.5ms/app/CtbuhCompany.php:91buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `name`, `name_chinese` from `v2_membership_levels` where `id` = 15
1.36ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_awards` where (`building_id` in (203, 5192, 31296, 5195, 5199, 17214, 887, 1009, 1809, 2088, 2374, 14135, 31297, 30504, 3558, 12095, 8745, 20785, 9171, 9967, 9969, 30503, 10751, 9277, 14683, 23423, 22658, 13359, 21604, 27135, 16637, 24560, 27770, 23426, 33408, 13869, 31356, 31357, 16097, 16519, 19748) or `company_id` = 1903) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc
3.11ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `ctbuh_building`.`id` in (23423, 203) and `ctbuh_building`.`deleted_at` is null
2.27ms/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` = 1440
1.26ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 1440
1.94ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 1440
1.4ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
203,5192,31296,5195,5199,17214,887,1009,1809,2088,2374,14135,31297,30504,3558,12095,8745,20785,9171,9967,9969,30503,10751,9277,14683,23423,22658,13359,21604,27135,16637,24560,27770,23426,33408,13869,31356,31357,16097,16519,19748
)
AND id_company_type IN(13, 11)
AND id_company IN(
1903
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
203,5192,31296,5195,5199,17214,887,1009,1809,2088,2374,14135,31297,30504,3558,12095,8745,20785,9171,9967,9969,30503,10751,9277,14683,23423,22658,13359,21604,27135,16637,24560,27770,23426,33408,13869,31356,31357,16097,16519,19748
)
AND category_id IN(1, 2)
AND company_id IN(
1903
)
14.92ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('1903')
1.36ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('1903')
1.23ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_initiatives` where `id` in (1120) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1744552915) order by `start_date` desc
2.62ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1539)
1.3ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 1440 and `v2_people`.`member_id` is not null
2.05ms/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 (7063, 7105, 7106, 36646) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.39ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'WMA Consulting Engineers' and `active` = '1'
2.41ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (1903, 1903, 1903)
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 (16097, 9277, 9967, 18350, 14135, 5195, 5199, 23423, 23423, 14683, 14683, 13869, 2374, 5192, 9171, 24560, 24560, 16637, 3558, 13359, 2088, 27770, 1809, 21604, 20785, 22658, 19748, 17214, 8745, 31297, 31296, 203, 9969, 16519, 16519, 10751, 31356, 31356, 31356, 31357, 31357, 31357, 12095, 33408, 27135, 21604, 23426, 23426, 1009, 1009, 30504, 30503, 30503, 30503, 887) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
3.41ms/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` = 203 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.51ms/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` = 5192 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2ms/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` = 31296 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.51ms/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` = 5195 and `published_at` < '2025-04-13 14:01:55' 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 `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` = 5199 and `published_at` < '2025-04-13 14:01:55' 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` = 17214 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.23ms/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` = 887 and `published_at` < '2025-04-13 14:01:55' 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` = 1009 and `published_at` < '2025-04-13 14:01:55' 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` = 1809 and `published_at` < '2025-04-13 14:01:55' 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` = 2088 and `published_at` < '2025-04-13 14:01:55' 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` = 2374 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.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` = 14135 and `published_at` < '2025-04-13 14:01:55' 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` = 31297 and `published_at` < '2025-04-13 14:01:55' 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` = 30504 and `published_at` < '2025-04-13 14:01:55' 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` = 3558 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.18ms/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` = 12095 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.19ms/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` = 8745 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.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` = 20785 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.23ms/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` = 9171 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.47ms/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` = 9967 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
9.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` = 9969 and `published_at` < '2025-04-13 14:01:55' 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` = 30503 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.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` = 10751 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.76ms/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` = 9277 and `published_at` < '2025-04-13 14:01:55' 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` = 14683 and `published_at` < '2025-04-13 14:01:55' 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` = 23423 and `published_at` < '2025-04-13 14:01:55' 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` = 22658 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.99ms/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` = 13359 and `published_at` < '2025-04-13 14:01:55' 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` = 21604 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.45ms/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` = 27135 and `published_at` < '2025-04-13 14:01:55' 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` = 16637 and `published_at` < '2025-04-13 14:01:55' 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` = 24560 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.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` = 27770 and `published_at` < '2025-04-13 14:01:55' 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` = 23426 and `published_at` < '2025-04-13 14:01:55' 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` = 33408 and `published_at` < '2025-04-13 14:01:55' 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` = 13869 and `published_at` < '2025-04-13 14:01:55' 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` = 31356 and `published_at` < '2025-04-13 14:01:55' 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` = 31357 and `published_at` < '2025-04-13 14:01:55' 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` = 16097 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.64ms/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` = 16519 and `published_at` < '2025-04-13 14:01:55' 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` = 19748 and `published_at` < '2025-04-13 14:01:55' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.45ms/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 (203, 5192, 31296, 5195, 5199, 17214, 887, 1009, 1809, 2088, 2374, 14135, 31297, 30504, 3558, 12095, 8745, 20785, 9171, 9967, 9969, 30503, 10751, 9277, 14683, 23423, 22658, 13359, 21604, 27135, 16637, 24560, 27770, 23426, 33408, 13869, 31356, 31357, 16097, 16519, 19748) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC
4.8ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 1440 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1
1.95ms/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` = 1440 order by `headquarters` desc, `contact` desc, `name` asc
1.55msview::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` = 1440 order by `display_order` asc, `field` asc
1.54msview::companies.partials.display-overview:53buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.15ms/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.61ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.89ms/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.57ms/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.19ms/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.26ms/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.38ms/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.27ms/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.66ms/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" => "30462" "REMOTE_ADDR" => "18.221.150.61" "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/1903" "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" => 1744552915.3119 "REQUEST_TIME" => 1744552915 ]
[]
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 => "Sun, 13 Apr 2025 14:01:55 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVmZzN2QXFIXC9LdEE4Vm8rd25GdzN3PT0iLCJ2YWx1ZSI6Ikx4am5jN2tEendUNUx2d0J5QWVxQU41dTZHSWdXVXFNRThyb2RsRVQ1NU9LTEtma3V4TmxMN0R0dkxVZUNhT0lPclA0aGFndjZCZGRoWUtwTmI0MFR6aU1pVlJMaFZVd3FnT3FjOStuT2xUNzZLcHcrREFuZ2x3K284WUgxbExNIiwibWFjIjoiM2Q5ZDUwOWQ1ZDgzZDc5ZDY0NjJmYTYzZmUxODZlODI4YzJmYWI4M2M1NjgzMThmZGEzMDEyMzk5MTI1YmVhNCJ9; expires=Sun, 13-Apr-2025 16:01:55 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVmZzN2QXFIXC9LdEE4Vm8rd25GdzN3PT0iLCJ2YWx1ZSI6Ikx4am5jN2tEendUNUx2d0J5QWVxQU41dTZHSWdXVXFNRThyb2RsRVQ1NU9LTEtma3V4TmxMN0R0dkxVZUNhT0lPclA0a ▶" 1 => "skyscraper_center_session=eyJpdiI6IlpSMGI1ZmdZXC9aYTJ3RFwvVVd6b1Bxdz09IiwidmFsdWUiOiJRbDNlY0ZIck05TmtSeXFLbis1bzVcL2FGdVl3VjVvVWJRZVk4VWkzaCtOQVdyMkx2ZFBHY1VuckxtMzN4TVRRTHpJUnc4VXRsTzFjWElZdE8rUDNlMjRYY1ZWbXAwaU83R1FSQVNGM0hKd2FoOXVGdk1OMWxuRFNZZG1hRGlVN3QiLCJtYWMiOiJhNDg0ZGJiMDRiM2U2YWI5Mjg3N2NkNjZkZGU1MzhlOGQ1NGE4MWYyMmYxZmNkZDM2OWRhZTExY2Y2MTg0ZDliIn0%3D; expires=Sun, 13-Apr-2025 16:01:55 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlpSMGI1ZmdZXC9aYTJ3RFwvVVd6b1Bxdz09IiwidmFsdWUiOiJRbDNlY0ZIck05TmtSeXFLbis1bzVcL2FGdVl3VjVvVWJRZVk4VWkzaCtOQVdyMkx2ZFBHY1Vuck ▶" 2 => "visit_counter=eyJpdiI6IjNrdUtVdkdcL2FkdzdFXC83U016aTRzQT09IiwidmFsdWUiOiJYXC8rYm5LYUFiZGZSbk9SNFBNNmtNM2tXaUlmQWRWVmpGdTdsMmFEcUM2RU10a0dlT3NFbEdIMmpKUEhacHRGeCIsIm1hYyI6ImYwZDBhMGRiMGUxZDZjYjg1MDQ4MjFlMWRiZTExNWZjZjliZDg5YWUyNDA2MjBhZjBiMmYxYjkzOWVlNDAwOTQifQ%3D%3D; expires=Tue, 13-May-2025 14:01:55 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IjNrdUtVdkdcL2FkdzdFXC83U016aTRzQT09IiwidmFsdWUiOiJYXC8rYm5LYUFiZGZSbk9SNFBNNmtNM2tXaUlmQWRWVmpGdTdsMmFEcUM2RU10a0dlT3NFbEdIMmpKUEhacHRGeC ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVmZzN2QXFIXC9LdEE4Vm8rd25GdzN3PT0iLCJ2YWx1ZSI6Ikx4am5jN2tEendUNUx2d0J5QWVxQU41dTZHSWdXVXFNRThyb2RsRVQ1NU9LTEtma3V4TmxMN0R0dkxVZUNhT0lPclA0aGFndjZCZGRoWUtwTmI0MFR6aU1pVlJMaFZVd3FnT3FjOStuT2xUNzZLcHcrREFuZ2x3K284WUgxbExNIiwibWFjIjoiM2Q5ZDUwOWQ1ZDgzZDc5ZDY0NjJmYTYzZmUxODZlODI4YzJmYWI4M2M1NjgzMThmZGEzMDEyMzk5MTI1YmVhNCJ9; expires=Sun, 13-Apr-2025 16:01:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVmZzN2QXFIXC9LdEE4Vm8rd25GdzN3PT0iLCJ2YWx1ZSI6Ikx4am5jN2tEendUNUx2d0J5QWVxQU41dTZHSWdXVXFNRThyb2RsRVQ1NU9LTEtma3V4TmxMN0R0dkxVZUNhT0lPclA0a ▶" 1 => "skyscraper_center_session=eyJpdiI6IlpSMGI1ZmdZXC9aYTJ3RFwvVVd6b1Bxdz09IiwidmFsdWUiOiJRbDNlY0ZIck05TmtSeXFLbis1bzVcL2FGdVl3VjVvVWJRZVk4VWkzaCtOQVdyMkx2ZFBHY1VuckxtMzN4TVRRTHpJUnc4VXRsTzFjWElZdE8rUDNlMjRYY1ZWbXAwaU83R1FSQVNGM0hKd2FoOXVGdk1OMWxuRFNZZG1hRGlVN3QiLCJtYWMiOiJhNDg0ZGJiMDRiM2U2YWI5Mjg3N2NkNjZkZGU1MzhlOGQ1NGE4MWYyMmYxZmNkZDM2OWRhZTExY2Y2MTg0ZDliIn0%3D; expires=Sun, 13-Apr-2025 16:01:55 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlpSMGI1ZmdZXC9aYTJ3RFwvVVd6b1Bxdz09IiwidmFsdWUiOiJRbDNlY0ZIck05TmtSeXFLbis1bzVcL2FGdVl3VjVvVWJRZVk4VWkzaCtOQVdyMkx2ZFBHY1Vuck ▶" 2 => "visit_counter=eyJpdiI6IjNrdUtVdkdcL2FkdzdFXC83U016aTRzQT09IiwidmFsdWUiOiJYXC8rYm5LYUFiZGZSbk9SNFBNNmtNM2tXaUlmQWRWVmpGdTdsMmFEcUM2RU10a0dlT3NFbEdIMmpKUEhacHRGeCIsIm1hYyI6ImYwZDBhMGRiMGUxZDZjYjg1MDQ4MjFlMWRiZTExNWZjZjliZDg5YWUyNDA2MjBhZjBiMmYxYjkzOWVlNDAwOTQifQ%3D%3D; expires=Tue, 13-May-2025 14:01:55 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjNrdUtVdkdcL2FkdzdFXC83U016aTRzQT09IiwidmFsdWUiOiJYXC8rYm5LYUFiZGZSbk9SNFBNNmtNM2tXaUlmQWRWVmpGdTdsMmFEcUM2RU10a0dlT3NFbEdIMmpKUEhacHRGeC ▶" ] ]
0 of 0array:4 [▶ "_token" => "kBoBgPweif1iYqDXrmryUZMdK6vi0u4bbtfDjQw9" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/company/1903" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]