Rogers Stirk Harbour + Partners is an international architectural practice based in London. Over nearly four decades, RSHP has attracted critical acclaim and awards with built projects across Europe, the Americas, Asia and Australia.
The practice is experienced in designing a wide range of building types including: office, residential, transport, education, culture, leisure, retail, civic and healthcare. The quality of its designs has been recognised with some of architecture’s highest awards, including two RIBA Stirling Prizes, one in 2006 for Terminal 4, Madrid Barajas Airport and the other in 2009 for Maggie’s West London Centre.
Architecture; Interior Design; Urban Design
Chongqing Centre T1, Chongqing
3 World Trade Center, New York City
Chongqing Centre T4, Chongqing
Torre Madrid Nuevo Norte 1, Madrid
Torre Madrid Nuevo Norte 2, Madrid
The Leadenhall Building, London
International Towers Sydney Tower 1, Sydney
Torre Madrid Nuevo Norte 3, Madrid
Nippon Television Tower, Tokyo
Chongqing Centre T2, Chongqing
Chongqing Centre T3, Chongqing
Chongqing Centre T5, Chongqing
International Towers Sydney Tower 2, Sydney
International Towers Sydney Tower 3, Sydney
SBS Broadcasting Center, Seoul
One Park Taipei Tower 1, Taipei
Double Cove Block 1-2, Hong Kong
One Park Taipei Tower 2, Taipei
Double Cove Block 23, Hong Kong
Double Cove Block 25, Hong Kong
Double Cove Block 22, Hong Kong
Double Cove Block 3, Hong Kong
Double Cove Block 5, Hong Kong
Double Cove Block 6, Hong Kong
Double Cove Block 7, Hong Kong
International Quarter Site S4, London
Double Cove Block 8, Hong Kong
NEO Bankside Building C, London
Double Cove Block 9-10, Hong Kong
Kings Health Cancer Centre at Guys, London
Double Cove Block 11-15, Hong Kong
NEO Bankside Building B, London
NEO Bankside Building A, London
NEO Bankside Building D, London
Double Cove Block 16, Hong Kong
Double Cove Block 17, Hong Kong
Double Cove Block 18, Hong Kong
Double Cove Block 19, Hong Kong
Double Cove Block 20, Hong Kong
Double Cove Block 21, Hong Kong
Maryah Plaza Hotel Tower, Abu Dhabi
Maryah Plaza Residential Tower 1, Abu Dhabi
Maryah Plaza Residential Tower 2, Abu Dhabi
Maryah Plaza Residential Tower 3, Abu Dhabi
Membership Level
Silver
Member Since
2015
Member Offices
London
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 |
- |
388 m / 1,273 ft |
|||
2 |
2020 |
338 m / 1,109 ft |
|||
3 |
2018 |
328.9 m / 1,079 ft |
|||
4 |
2022 |
311.8 m / 1,023 ft |
|||
5 |
- |
291 m / 955 ft |
|||
6 |
2026 |
268 m / 879 ft |
|||
7 |
2020 |
260.6 m / 855 ft |
|||
8 |
- |
250 m / 820 ft |
|||
9 |
2015 |
234.9 m / 771 ft |
|||
10 |
- |
230 m / 755 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 |
- | 391 m / 1,283 ft |
|||
2 |
- | 388 m / 1,273 ft |
|||
3 |
2020 | 338 m / 1,109 ft |
|||
4 |
2018 | 329 m / 1,079 ft |
|||
5 |
2022 | 312 m / 1,023 ft |
|||
6 |
- | 291 m / 955 ft |
|||
7 |
2026 | 268 m / 879 ft |
|||
8 |
- | 261 m / 856 ft |
|||
9 |
2020 | 261 m / 855 ft |
|||
10 |
- | 250 m / 820 ft |
|||
11 |
- | 236 m / 773 ft |
|||
12 |
2015 | 235 m / 771 ft |
|||
13 |
- | 230 m / 755 ft |
|||
14 |
2014 | 224 m / 735 ft |
|||
15 |
2016 | 217 m / 712 ft |
|||
16 |
- | 210 m / 689 ft |
|||
17 |
2019 | 202 m / 661 ft |
|||
18 |
- | 198 m / 649 ft |
|||
19 |
2003 | 193 m / 633 ft |
|||
20 |
2020 | 187 m / 614 ft |
|||
20 |
2020 | 187 m / 614 ft |
|||
20 |
- | 187 m / 614 ft |
|||
23 |
- | 186 m / 610 ft |
|||
24 |
- | 179 m / 587 ft |
|||
25 |
2015 | 178 m / 584 ft |
|||
26 |
2016 | 169 m / 554 ft |
|||
27 |
2003 | 167 m / 548 ft |
|||
28 |
- | 160 m / 525 ft |
|||
29 |
- | 158 m / 518 ft |
|||
30 |
- | 154 m / 505 ft |
|||
31 |
2015 | 152 m / 499 ft |
|||
31 |
2020 | 152 m / 499 ft |
|||
33 |
- | 150 m / 492 ft |
|||
34 |
2018 | 149 m / 488 ft |
|||
35 |
2013 | 141 m / 461 ft |
|||
36 |
2018 | 140 m / 458 ft |
|||
37 |
2019 | 130 m / 427 ft |
|||
38 |
2017 | 126 m / 413 ft |
|||
39 |
2018 | 126 m / 413 ft |
|||
40 |
2017 | 125 m / 411 ft |
|||
40 |
2017 | 125 m / 411 ft |
|||
42 |
2017 | 118 m / 388 ft |
|||
43 |
2017 | 117 m / 384 ft |
|||
44 |
2017 | 111 m / 365 ft |
|||
45 |
2006 | 105 m / 344 ft |
|||
46 |
2020 | 102 m / 335 ft |
|||
47 |
2017 | 99 m / 325 ft |
|||
48 |
1986 | 95 m / 312 ft |
|||
49 |
2017 | 95 m / 312 ft |
|||
50 |
- | 91 m / 299 ft |
03–05 July 2017
CTBUH Singapore, in coordination with CTBUH Malaysia and CTBUH Thailand, hosted a multi-city seminar on sustainable design in Singapore, Kuala Lumpur, and Bangkok.
20 June 2017
Building up momentum for the CTBUH 2017 Conference in Australia, the CTBUH Canada Chapter held its most recent event at the University of Toronto Faculty Club.
07–09 March 2017
Executive Director Antony Wood delivered two well attended lectures in Sydney and Melbourne, organized by the respective local CTBUH committees.
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.
29 July 2015
CTBUH Sydney welcomed Ivan Harbour, of Roger Stirk Harbour + Partners, to share his thoughts and experiences with international design excellence competitions.
12 June 2013
The Leadenhall Building leans back to make way for views to St. Paul’s Cathedral and other historic sites in a crowded section of the City of London, but it also springs forward with an innovative structure and a dynamic street presence.
12 June 2013
See the highlights from the second day of the CTBUH 2013 London Conference including The Shard Networking Reception.
11 June 2013
See the highlights from the first day of the CTBUH 2013 London Conference including the Opening Plenary and Conference Dinner.
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.98%) | 711.61ms |
1 x Booting (1.01%) | 7.28ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
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 |
|
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 |
|
51 |
|
52 |
|
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` = '335' limit 1
7.97ms/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 = '335' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name
1.3ms/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 = '335' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
149ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `ctbuh_company` where `ctbuh_company`.`id` = 329 and `ctbuh_company`.`deleted_at` is null limit 1
1.4ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '329' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
114ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'Rogers Stirk Harbour + Partners' and `active` = '1'
6.91ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (329, 335)
2.72ms/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 (672, 3293, 2380, 3709, 1889, 18307, 18308, 18309, 18310, 18311, 2935, 4059, 5010, 366, 2023, 1042, 1374, 3109, 243, 9575, 15148, 15146, 15147, 15149, 17500, 18147, 18146, 18145, 18834, 1194, 17501, 17503, 11667, 26897, 16971, 19212, 27035, 17502, 27251, 18881, 1890, 750, 29265, 8713, 13281, 30583, 30584, 18880, 15596, 26896, 32493, 13280, 273, 33549, 33708, 33709, 33710, 34511, 34512, 34863, 34864, 34865, 35333, 35334, 35335, 35336, 35337, 35338, 35339, 35340, 35341, 35342, 35343, 35344, 35345, 35346) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
8.65ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 658, 723, 750, 766, 788, 831, 900, 903, 942, 1024, 1049, 1072, 1110, 1488, 1641, 1683)
2.94ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 11, 27, 34, 35, 51, 56, 79, 82, 85, 111, 163)
1.53ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 11, 27, 34, 35, 51, 56, 79, 82, 85, 111, 163)
2.19ms/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 (243, 273, 366, 672, 750, 1042, 1194, 1374, 1889, 1890, 2023, 2380, 2935, 3109, 3293, 3709, 4059, 5010, 8713, 9575, 11667, 13280, 13281, 15146, 15147, 15148, 15149, 15596, 16971, 17500, 17501, 17502, 17503, 18147, 18307, 18308, 18309, 18310, 18311, 18880, 18881, 19212, 26896, 26897, 27251, 29265, 30583, 30584, 32493, 33549, 33708, 33709, 33710, 34511, 34512, 34863, 34864, 34865, 35333, 35334, 35335, 35336, 35337, 35338, 35339, 35340, 35341, 35342, 35343, 35344, 35345, 35346) order by `position` asc
29.15ms/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` = 335 and `v2_members`.`deleted_at` is null
2.87ms/app/CtbuhCompany.php:91buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `name`, `name_chinese` from `v2_membership_levels` where `id` = 15
1.16ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_awards` where (`building_id` in (243, 18308, 366, 273, 32493, 18307, 18881, 750, 672, 33708, 1042, 8713, 33709, 1194, 13280, 33710, 18880, 1374, 1889, 18309, 18310, 18311, 2023, 2380, 11667, 13281, 2935, 3293, 3109, 3709, 30583, 30584, 4059, 15596, 1890, 34511, 18147, 35346, 34512, 34863, 34864, 34865, 35345, 35344, 5010, 33549, 35343, 9575, 35342, 29265, 26897, 35341, 26896, 16971, 15148, 35340, 27251, 35339, 19212, 15147, 15146, 15149, 35338, 35337, 35336, 35335, 35334, 35333, 17500, 17501, 17502, 17503) or `company_id` = 335) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc
2.48ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `ctbuh_building`.`id` in (34511, 13280, 13280, 1194, 1890, 15148, 1194, 15148) and `ctbuh_building`.`deleted_at` is null
1.76ms/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` = 909
1.11ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 909
1.04ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 909
1.25ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
243,18308,366,273,32493,18307,18881,750,672,33708,1042,8713,33709,1194,13280,33710,18880,1374,1889,18309,18310,18311,2023,2380,11667,13281,2935,3293,3109,3709,30583,30584,4059,15596,1890,34511,18147,35346,34512,34863,34864,34865,35345,35344,5010,33549,35343,9575,35342,29265,26897,35341,26896,16971,15148,35340,27251,35339,19212,15147,15146,15149,35338,35337,35336,35335,35334,35333,17500,17501,17502,17503
)
AND id_company_type IN(13, 11)
AND id_company IN(
335
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
243,18308,366,273,32493,18307,18881,750,672,33708,1042,8713,33709,1194,13280,33710,18880,1374,1889,18309,18310,18311,2023,2380,11667,13281,2935,3293,3109,3709,30583,30584,4059,15596,1890,34511,18147,35346,34512,34863,34864,34865,35345,35344,5010,33549,35343,9575,35342,29265,26897,35341,26896,16971,15148,35340,27251,35339,19212,15147,15146,15149,35338,35337,35336,35335,35334,35333,17500,17501,17502,17503
)
AND category_id IN(1, 2)
AND company_id IN(
335
)
13.63ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('335', 329)
1.92ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('335', 329)
2.44ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resources` where `id` in (485, 86, 19, 2378, 2379, 2993, 3157, 3525, 3526, 3505, 3786, 3737, 3746, 4113, 2524, 3411, 1972, 3759) order by `date` desc
13.35ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (658, 803, 942, 1539, 1641)
1.32ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 47 limit 1
1.17ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 21 limit 1
1.78ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 20 limit 1
1.36ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_initiatives` where `id` in (1310, 146, 209, 123, 207, 1068, 1120, 1268, 1327, 1213, 859, 208) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1744488645) order by `start_date` desc
4.52ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (658, 723, 942, 1539)
1.37ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 909 and `v2_people`.`member_id` is not null
5.73ms/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 (606, 3235, 3848, 6441, 7693, 36310, 36496, 40008, 40075) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.6ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'Rogers Stirk Harbour + Partners' and `active` = '1'
1.27ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (329, 335, 335)
1.37ms/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 (672, 3293, 2380, 3709, 1889, 18307, 18308, 18309, 18310, 18311, 2935, 4059, 5010, 366, 2023, 1042, 1374, 3109, 243, 9575, 15148, 15146, 15147, 15149, 17500, 18147, 18146, 18145, 18834, 1194, 17501, 17503, 11667, 26897, 16971, 19212, 27035, 17502, 27251, 18881, 1890, 750, 29265, 8713, 13281, 30583, 30584, 18880, 15596, 26896, 32493, 13280, 273, 33549, 33708, 33709, 33710, 34511, 34512, 34863, 34864, 34865, 35333, 35334, 35335, 35336, 35337, 35338, 35339, 35340, 35341, 35342, 35343, 35344, 35345, 35346) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
5.23ms/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` = 243 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.8ms/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` = 18308 and `published_at` < '2025-04-12 20:10:45' 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` = 366 and `published_at` < '2025-04-12 20:10:45' 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` = 273 and `published_at` < '2025-04-12 20:10:45' 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` = 32493 and `published_at` < '2025-04-12 20:10:45' 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` = 18307 and `published_at` < '2025-04-12 20:10:45' 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` = 18881 and `published_at` < '2025-04-12 20:10:45' 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` = 750 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.22ms/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` = 672 and `published_at` < '2025-04-12 20:10:45' 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` = 33708 and `published_at` < '2025-04-12 20:10:45' 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` = 1042 and `published_at` < '2025-04-12 20:10:45' 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` = 8713 and `published_at` < '2025-04-12 20:10:45' 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` = 33709 and `published_at` < '2025-04-12 20:10:45' 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` = 1194 and `published_at` < '2025-04-12 20:10:45' 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` = 13280 and `published_at` < '2025-04-12 20:10:45' 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` = 33710 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.22ms/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` = 18880 and `published_at` < '2025-04-12 20:10:45' 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` = 1374 and `published_at` < '2025-04-12 20:10:45' 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` = 1889 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.22ms/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` = 18309 and `published_at` < '2025-04-12 20:10:45' 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` = 18310 and `published_at` < '2025-04-12 20:10:45' 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` = 18311 and `published_at` < '2025-04-12 20:10:45' 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` = 2023 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.57ms/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` = 2380 and `published_at` < '2025-04-12 20:10:45' 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` = 11667 and `published_at` < '2025-04-12 20:10:45' 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` = 13281 and `published_at` < '2025-04-12 20:10:45' 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` = 2935 and `published_at` < '2025-04-12 20:10:45' 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` = 3293 and `published_at` < '2025-04-12 20:10:45' 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` = 3109 and `published_at` < '2025-04-12 20:10:45' 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` = 3709 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.87ms/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` = 30583 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.94ms/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` = 30584 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.97ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 4059 and `published_at` < '2025-04-12 20:10:45' 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` = 15596 and `published_at` < '2025-04-12 20:10:45' 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` = 1890 and `published_at` < '2025-04-12 20:10:45' 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` = 34511 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.68ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 18147 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
8.7ms/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` = 35346 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
5.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` = 34512 and `published_at` < '2025-04-12 20:10:45' 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` = 34863 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 34864 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.16ms/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` = 34865 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.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` = 35345 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.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` = 35344 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.63ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 5010 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 33549 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
5.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` = 35343 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.87ms/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` = 9575 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.1ms/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` = 35342 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
7.54ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 29265 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.15ms/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` = 26897 and `published_at` < '2025-04-12 20:10:45' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
6.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` = 35341 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.68ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 26896 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.95ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 16971 and `published_at` < '2025-04-12 20:10:46' 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` = 15148 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.69ms/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` = 35340 and `published_at` < '2025-04-12 20:10:46' 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` = 27251 and `published_at` < '2025-04-12 20:10:46' 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` = 35339 and `published_at` < '2025-04-12 20:10:46' 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` = 19212 and `published_at` < '2025-04-12 20:10:46' 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` = 15147 and `published_at` < '2025-04-12 20:10:46' 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` = 15146 and `published_at` < '2025-04-12 20:10:46' 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` = 15149 and `published_at` < '2025-04-12 20:10:46' 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` = 35338 and `published_at` < '2025-04-12 20:10:46' 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` = 35337 and `published_at` < '2025-04-12 20:10:46' 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` = 35336 and `published_at` < '2025-04-12 20:10:46' 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` = 35335 and `published_at` < '2025-04-12 20:10:46' 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` = 35334 and `published_at` < '2025-04-12 20:10:46' 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` = 35333 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.68ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 17500 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.62ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 17501 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 17502 and `published_at` < '2025-04-12 20:10:46' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.57ms/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` = 17503 and `published_at` < '2025-04-12 20:10:46' 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
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 (243, 18308, 366, 273, 32493, 18307, 18881, 750, 672, 33708, 1042, 8713, 33709, 1194, 13280, 33710, 18880, 1374, 1889, 18309, 18310, 18311, 2023, 2380, 11667, 13281, 2935, 3293, 3109, 3709, 30583, 30584, 4059, 15596, 1890, 34511, 18147, 35346, 34512, 34863, 34864, 34865, 35345, 35344, 5010, 33549, 35343, 9575, 35342, 29265, 26897, 35341, 26896, 16971, 15148, 35340, 27251, 35339, 19212, 15147, 15146, 15149, 35338, 35337, 35336, 35335, 35334, 35333, 17500, 17501, 17502, 17503) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC
8.47ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 909 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1
1.83ms/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` = 909 order by `headquarters` desc, `contact` desc, `name` asc
1.59msview::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` = 909 order by `display_order` asc, `field` asc
1.39msview::companies.partials.display-overview:53buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
2.18ms/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.47ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.36ms/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.44ms/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.17ms/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.15ms/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.32ms/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.28ms/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.31ms/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" => "52548" "REMOTE_ADDR" => "18.222.111.222" "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/335" "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" => 1744488645.386 "REQUEST_TIME" => 1744488645 ]
[]
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 => "Sat, 12 Apr 2025 20:10:46 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlQ0QURyMTl0dkxQdkIyYUZGNUZsMkE9PSIsInZhbHVlIjoibStzKzU4V3RZZXJyU0M4WXZsSWxTZjFtdWtta25cL0VJNUNTTENFYmNGc0xkYllPWEdQcGI5b05XeWw0RjdndDNoK0ZwRWFmTkNFRmxodlwvdFRMMG1md0ZYMkIwaHhGTWcxU3MydDR4NFBpTVwvNVNMRG1scCtWM0U0SVhcLzRldllJIiwibWFjIjoiM2I5YjcyM2JkMWI4YjRhZDhmM2Y4Zjk2N2IyODdlMmMxNDczY2UwMzA3NGNjNWRiZjY2MGZmN2I3NDcyYTNhYyJ9; expires=Sat, 12-Apr-2025 22:10:46 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlQ0QURyMTl0dkxQdkIyYUZGNUZsMkE9PSIsInZhbHVlIjoibStzKzU4V3RZZXJyU0M4WXZsSWxTZjFtdWtta25cL0VJNUNTTENFYmNGc0xkYllPWEdQcGI5b05XeWw0RjdndDNoK0ZwR ▶" 1 => "skyscraper_center_session=eyJpdiI6Im1pQUQrTkdWV0RFRG9wS3VCc3pmbUE9PSIsInZhbHVlIjoiMkZqU3orc0NRdkdhVkJpVE9mT2pVZTJ1bkErSVNRc09EKysyN0dcL3ZaZTZkU0dnWllwK1FMQVU2dDE2M1wvZkw2V0doUUpBN2VnSmlNK0NNY1NydFpYOWNVUE0zTExsU3pPNnBFTHZVVnVBc0x6UENWWDhBSFR2TUJZRjZ0RURlWSIsIm1hYyI6IjhmZDFlOWRmOTEwNTU4YzAyYzJmMmJkNDJhNjFkNzFkNWJlZTIzYjM4MjcwYTU0YTAxMzI4M2Y2NTBjZjFiMjMifQ%3D%3D; expires=Sat, 12-Apr-2025 22:10:46 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Im1pQUQrTkdWV0RFRG9wS3VCc3pmbUE9PSIsInZhbHVlIjoiMkZqU3orc0NRdkdhVkJpVE9mT2pVZTJ1bkErSVNRc09EKysyN0dcL3ZaZTZkU0dnWllwK1FMQVU2dD ▶" 2 => "visit_counter=eyJpdiI6ImhjcTZlMjl3VGxrTFpnektoaVpvb3c9PSIsInZhbHVlIjoiemtST2MxdGExRzA4OTdraG5VXC9qQmpHQkM2U3F0ZmlOcVBDbXc5aHoxZElEWFc2Z3htRllyK2NSdzFjNmJYVk4iLCJtYWMiOiJhNTQxOTk4MTZlZWMwMDIyZTE4ZDY3ZjM4YjlkZGM1MGE2MDBkYTk4M2YwNzhlYjJiZTQ3MjNmMWFjYjA3MDFhIn0%3D; expires=Mon, 12-May-2025 20:10:45 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6ImhjcTZlMjl3VGxrTFpnektoaVpvb3c9PSIsInZhbHVlIjoiemtST2MxdGExRzA4OTdraG5VXC9qQmpHQkM2U3F0ZmlOcVBDbXc5aHoxZElEWFc2Z3htRllyK2NSdzFjNmJYVk4iLC ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlQ0QURyMTl0dkxQdkIyYUZGNUZsMkE9PSIsInZhbHVlIjoibStzKzU4V3RZZXJyU0M4WXZsSWxTZjFtdWtta25cL0VJNUNTTENFYmNGc0xkYllPWEdQcGI5b05XeWw0RjdndDNoK0ZwRWFmTkNFRmxodlwvdFRMMG1md0ZYMkIwaHhGTWcxU3MydDR4NFBpTVwvNVNMRG1scCtWM0U0SVhcLzRldllJIiwibWFjIjoiM2I5YjcyM2JkMWI4YjRhZDhmM2Y4Zjk2N2IyODdlMmMxNDczY2UwMzA3NGNjNWRiZjY2MGZmN2I3NDcyYTNhYyJ9; expires=Sat, 12-Apr-2025 22:10:46 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlQ0QURyMTl0dkxQdkIyYUZGNUZsMkE9PSIsInZhbHVlIjoibStzKzU4V3RZZXJyU0M4WXZsSWxTZjFtdWtta25cL0VJNUNTTENFYmNGc0xkYllPWEdQcGI5b05XeWw0RjdndDNoK0ZwR ▶" 1 => "skyscraper_center_session=eyJpdiI6Im1pQUQrTkdWV0RFRG9wS3VCc3pmbUE9PSIsInZhbHVlIjoiMkZqU3orc0NRdkdhVkJpVE9mT2pVZTJ1bkErSVNRc09EKysyN0dcL3ZaZTZkU0dnWllwK1FMQVU2dDE2M1wvZkw2V0doUUpBN2VnSmlNK0NNY1NydFpYOWNVUE0zTExsU3pPNnBFTHZVVnVBc0x6UENWWDhBSFR2TUJZRjZ0RURlWSIsIm1hYyI6IjhmZDFlOWRmOTEwNTU4YzAyYzJmMmJkNDJhNjFkNzFkNWJlZTIzYjM4MjcwYTU0YTAxMzI4M2Y2NTBjZjFiMjMifQ%3D%3D; expires=Sat, 12-Apr-2025 22:10:46 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Im1pQUQrTkdWV0RFRG9wS3VCc3pmbUE9PSIsInZhbHVlIjoiMkZqU3orc0NRdkdhVkJpVE9mT2pVZTJ1bkErSVNRc09EKysyN0dcL3ZaZTZkU0dnWllwK1FMQVU2dD ▶" 2 => "visit_counter=eyJpdiI6ImhjcTZlMjl3VGxrTFpnektoaVpvb3c9PSIsInZhbHVlIjoiemtST2MxdGExRzA4OTdraG5VXC9qQmpHQkM2U3F0ZmlOcVBDbXc5aHoxZElEWFc2Z3htRllyK2NSdzFjNmJYVk4iLCJtYWMiOiJhNTQxOTk4MTZlZWMwMDIyZTE4ZDY3ZjM4YjlkZGM1MGE2MDBkYTk4M2YwNzhlYjJiZTQ3MjNmMWFjYjA3MDFhIn0%3D; expires=Mon, 12-May-2025 20:10:45 GMT; path=/; httponly ◀visit_counter=eyJpdiI6ImhjcTZlMjl3VGxrTFpnektoaVpvb3c9PSIsInZhbHVlIjoiemtST2MxdGExRzA4OTdraG5VXC9qQmpHQkM2U3F0ZmlOcVBDbXc5aHoxZElEWFc2Z3htRllyK2NSdzFjNmJYVk4iLC ▶" ] ]
0 of 0array:4 [▶ "_token" => "n0pBiZTYoBOszmOpJHgREOLobIVlCyd6IG1tRJdD" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/company/335" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]