Member Offices: Edinburgh
Website: http://www.rmjm.com/
RMJM is one of the World’s largest Architecture firms with nearly 2000 people, in 27 offices spread across 5 Continents.
Their range of services includes architecture, interior design, master planning, urban design, sustainable design, engineering, arts consultancy, landscape design, preservation architecture, environmental graphics and visualization.
RMJM offices can be found in Edinburgh & London in the UK, New York & Los Angeles in the US, Dubai & Abu Dhabi in the UAE, Shanghai & Shenzhen in China, Istanbul & Ankara in Turkey, Buenos Aires and Cordoba in Argentina, Nairobi & Mombasa in Kenya, Karachi in Pakistan, Riyadh in Saudi Arabia, La Paz in Bolivia, Monterrey in Mexico, Rome in Italy, Pretoria in South Africa, Kampala in Uganda, Juba in South Sudan, Dar es Salaam in Tanzania, Gaborone in Botswana and Hong Kong.
Architecture; Urban Design
Suning Plaza Tower 1, Zhenjiang
Shenzhen Bay Innovation and Technology Centre Tower 1, Shenzhen
Metropol Tower Istanbul, Istanbul
Shenzhen Bay Innovation and Technology Centre Tower 2, Shenzhen
Suning Plaza Tower 2, Zhenjiang
China Merchants Bank Mansion, Shanghai
Raemian Caelitus Tower A, Seoul
Varyap Meridian A Block, Istanbul
Varyap Meridian C Block, Istanbul
Varyap Meridian E Block, Istanbul
Trident Grand Residence, Dubai
The Peninsula Bangkok Hotel, Bangkok
William Donald Schaefer Tower, Baltimore
Shenzhen Bay Innovation and Technology Centre Tower 3, Shenzhen
Raemian Caelitus Tower B, Seoul
H Hotel & Convention Center Hotel Tower, Dubai
Shenzhen Bay Innovation and Technology Centre Tower 4, Shenzhen
Shenzhen Bay Innovation and Technology Centre Tower 5, Shenzhen
Doumen Observation Tower, Doumen
Varyap Meridian B Block, Istanbul
Varyap Meridian D Block, Istanbul
China Construction Bank Headquarters, Ningbo
Membership Level
Silver
Member Since
Member Offices
Edinburgh
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 |
2021 |
828 m / 2,717 ft |
|||
2 |
- |
384 m / 1,260 ft |
|||
3 |
2019 |
377 m / 1,237 ft |
|||
4 |
2018 |
338 m / 1,109 ft |
|||
5 |
2017 |
328.8 m / 1,079 ft |
|||
6 |
2020 |
320 m / 1,050 ft |
|||
7 |
2015 |
301.8 m / 990 ft |
|||
8 |
2017 |
280 m / 919 ft |
|||
9 |
2015 |
270 m / 886 ft |
|||
10 |
2020 |
246.6 m / 809 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 |
2021 | 828 m / 2,717 ft |
|||
2 |
- | 437 m / 1,432 ft |
|||
3 |
- | 396 m / 1,299 ft |
|||
4 |
- | 384 m / 1,260 ft |
|||
5 |
2019 | 377 m / 1,237 ft |
|||
6 |
2018 | 338 m / 1,109 ft |
|||
7 |
- | 335 m / 1,099 ft |
|||
8 |
2017 | 329 m / 1,079 ft |
|||
9 |
- | 322 m / 1,056 ft |
|||
10 |
2020 | 320 m / 1,050 ft |
|||
11 |
2015 | 302 m / 990 ft |
|||
12 |
- | 296 m / 970 ft |
|||
13 |
- | 293 m / 961 ft |
|||
14 |
2017 | 280 m / 919 ft |
|||
15 |
2015 | 270 m / 886 ft |
|||
16 |
2020 | 247 m / 809 ft |
|||
17 |
2015 | 246 m / 807 ft |
|||
18 |
2018 | 225 m / 738 ft |
|||
19 |
2021 | 209 m / 684 ft |
|||
20 |
2006 | 208 m / 684 ft |
|||
21 |
2013 | 208 m / 682 ft |
|||
22 |
2015 | 196 m / 643 ft |
|||
23 |
2011 | 194 m / 636 ft |
|||
24 |
2012 | 188 m / 618 ft |
|||
25 |
2013 | 180 m / 591 ft |
|||
26 |
2007 | 174 m / 569 ft |
|||
27 |
2008 | 168 m / 551 ft |
|||
28 |
2015 | 167 m / 546 ft |
|||
29 |
2011 | 165 m / 540 ft |
|||
30 |
2012 | 164 m / 538 ft |
|||
31 |
2011 | 153 m / 502 ft |
|||
32 |
2010 | 153 m / 502 ft |
|||
33 |
1998 | 151 m / 495 ft |
|||
34 |
1992 | 150 m / 493 ft |
|||
35 |
2020 | 150 m / 492 ft |
|||
36 |
2006 | 150 m / 492 ft |
|||
37 |
2007 | 150 m / 492 ft |
|||
37 |
2008 | 150 m / 492 ft |
|||
39 |
2015 | 147 m / 483 ft |
|||
40 |
2007 | 143 m / 468 ft |
|||
41 |
2015 | 133 m / 437 ft |
|||
42 |
2015 | 129 m / 424 ft |
|||
43 |
2010 | 121 m / 398 ft |
|||
44 |
2020 | 120 m / 394 ft |
|||
45 |
2020 | 106 m / 348 ft |
|||
46 |
- | 105 m / 344 ft |
|||
47 |
2018 | 105 m / 344 ft |
|||
48 |
- | 93 m / 305 ft |
|||
49 |
2012 | 82 m / 269 ft |
|||
49 |
2012 | 82 m / 269 ft |
17 January 2018
CTBUH Turkey held its inaugural chapter event at the Hilton Istanbul, where industry experts spoke with over 120 guests on topics relating to the theme "Tall & Green."
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.
01 May 2012
CTBUH Public Affairs Manager Kevin Brass chaired the Middle East Real Estate Summit, the annual event for the regional property industry.
01–02 September 2011
CTBUH Chairman Professor Sang Dae Kim held tall building lectures in Thailand, Vietnam, Indonesia and Russia with the dual purpose of promoting CTBUH and the 2011 Seoul Conference.
21 October 2009
Close to 60 attendees of the 2009 CTBUH Chicago Conference began their conference experience with a two-hour technical tour of the recently completed Aqua Tower.
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.25%) | 777.34ms |
1 x Booting (1.72%) | 13.65ms |
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 |
|
49 |
|
50 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
select * from `ctbuh_company` where `ctbuh_company`.`id` = '331' limit 1
11.36ms/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 = '331' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name
7.68ms/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 = '331' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
170ms/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 = '331' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name
119ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'RMJM' and `active` = '1'
2.12ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (331, 331)
1.44ms/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 (175, 175, 17069, 17066, 17068, 17067, 8895, 17181, 17181, 17511, 879, 14995, 11155, 11155, 11155, 19398, 3789, 3789, 3789, 14218, 14218, 14218, 17065, 20035, 20035, 20035, 20035, 20035, 20035, 20035, 9238, 9238, 9238, 14214, 14214, 14214, 11329, 11170, 236, 13894, 5232, 24453, 24452, 452, 9778, 9780, 9777, 499, 19725, 9549, 28774, 10666, 3290, 9779, 9776, 4032, 4031, 8881, 8883, 8882, 11169, 12057, 3984, 1505, 4020, 3928, 1499, 2876, 32672, 32680, 23572, 23572, 3172, 3172, 3172, 12575, 15284, 15283, 15282, 12575, 36684) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
9.62ms/app/CtbuhCompany.php:336buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 630, 750, 788, 795, 802, 803, 806, 825, 829, 942, 1072, 1398, 1428, 1438, 1439, 1450, 1452, 1471, 1478, 1514, 2203)
2.14ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 34, 56, 85, 127, 133, 135, 137, 153, 158, 163)
1.89ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (2, 34, 56, 85, 127, 133, 135, 137, 153, 158, 163)
1.86ms/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 (175, 236, 452, 499, 1499, 1505, 2876, 3172, 3290, 3789, 3928, 3984, 4020, 4031, 4032, 5232, 8881, 8882, 8883, 8895, 9238, 9549, 9776, 9777, 9778, 9779, 9780, 10666, 11155, 11169, 11170, 11329, 12057, 12575, 13894, 14214, 14218, 14995, 15282, 15283, 15284, 17065, 17066, 17067, 17068, 17069, 17181, 17511, 19398, 19725, 23572, 24452, 24453, 28774, 32672, 32680, 36684) order by `position` asc
13.26ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
2.18ms/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` = 331 and `v2_members`.`deleted_at` is null
6.25ms/app/CtbuhCompany.php:91buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `name`, `name_chinese` from `v2_membership_levels` where `id` = 15
1.73ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_awards` where (`building_id` in (23572, 175, 236, 32680, 12575, 11169, 9549, 11329, 452, 17065, 499, 12057, 5232, 13894, 11155, 17066, 19725, 11170, 19398, 1499, 1505, 15282, 8895, 9776, 9778, 3290, 2876, 9238, 3172, 9780, 3789, 14995, 3928, 3984, 17067, 4020, 4031, 4032, 15283, 10666, 14214, 15284, 14218, 17068, 17069, 28774, 17181, 17511, 9777, 9779, 36684, 32672, 24452, 24453, 8881, 8882, 8883) or `company_id` = 331) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc
3.33ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `ctbuh_building`.`id` in (11329, 12575, 12575, 12575, 12575, 12575, 19725) and `ctbuh_building`.`deleted_at` is null
2.25ms/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` = 908
1.53ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 908
1.34ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 908
1.18ms/app/Member.php:184buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
23572,175,236,32680,12575,11169,9549,11329,452,17065,499,12057,5232,13894,11155,17066,19725,11170,19398,1499,1505,15282,8895,9776,9778,3290,2876,9238,3172,9780,3789,14995,3928,3984,17067,4020,4031,4032,15283,10666,14214,15284,14218,17068,17069,28774,17181,17511,9777,9779,36684,32672,24452,24453,8881,8882,8883
)
AND id_company_type IN(13, 11)
AND id_company IN(
331
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
23572,175,236,32680,12575,11169,9549,11329,452,17065,499,12057,5232,13894,11155,17066,19725,11170,19398,1499,1505,15282,8895,9776,9778,3290,2876,9238,3172,9780,3789,14995,3928,3984,17067,4020,4031,4032,15283,10666,14214,15284,14218,17068,17069,28774,17181,17511,9777,9779,36684,32672,24452,24453,8881,8882,8883
)
AND category_id IN(1, 2)
AND company_id IN(
331
)
18.49ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('331')
3.76ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('331')
1.59ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resources` where `id` in (396, 684, 810, 337, 21, 3656) order by `date` desc
2.23ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 1438, 1539)
3.81ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 13 limit 1
6.13ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 13 limit 1
1.38ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 5 limit 1
1.49ms/app/Http/Controllers/CtbuhCompanyController.php:349buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_initiatives` where `id` in (254, 1120, 1432, 331, 531, 75) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1744176995) order by `start_date` desc
11.15ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (629, 1439, 1478, 1539)
3.44ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 908 and `v2_people`.`member_id` is not null
11.83ms/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 (10549, 14027, 14028, 18822, 19166, 20868, 32047, 38549) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
2.79ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdbMetadata | |
---|---|
Backtrace |
|
select `id` from `ctbuh_company` where `name` = 'RMJM' and `active` = '1'
2.37ms/app/CtbuhCompany.php:305buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `building_id` from `ctbuh_building_company_new` where `company_id` in (331, 331, 331)
1.81ms/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 (175, 175, 17069, 17066, 17068, 17067, 8895, 17181, 17181, 17511, 879, 14995, 11155, 11155, 11155, 19398, 3789, 3789, 3789, 14218, 14218, 14218, 17065, 20035, 20035, 20035, 20035, 20035, 20035, 20035, 9238, 9238, 9238, 14214, 14214, 14214, 11329, 11170, 236, 13894, 5232, 24453, 24452, 452, 9778, 9780, 9777, 499, 19725, 9549, 28774, 10666, 3290, 9779, 9776, 4032, 4031, 8881, 8883, 8882, 11169, 12057, 3984, 1505, 4020, 3928, 1499, 2876, 32672, 32680, 23572, 23572, 3172, 3172, 3172, 12575, 15284, 15283, 15282, 12575, 36684) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
6.29ms/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` = 23572 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.81ms/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` = 175 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.79ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 236 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.61ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 32680 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.66ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 12575 and `published_at` < '2025-04-09 05:36:35' 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` = 11169 and `published_at` < '2025-04-09 05:36:35' 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` = 9549 and `published_at` < '2025-04-09 05:36:35' 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` = 11329 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.47ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 452 and `published_at` < '2025-04-09 05:36:35' 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` = 17065 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.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` = 499 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.82ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 12057 and `published_at` < '2025-04-09 05:36:35' 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` = 5232 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
9.11ms/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` = 13894 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.84ms/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` = 11155 and `published_at` < '2025-04-09 05:36:35' 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` = 17066 and `published_at` < '2025-04-09 05:36:35' 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` = 19725 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.6ms/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` = 11170 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.67ms/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` = 19398 and `published_at` < '2025-04-09 05:36:35' 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` = 1499 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
8.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` = 1505 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.21ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 15282 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 8895 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.05ms/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` = 9776 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.04ms/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` = 9778 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.91ms/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` = 3290 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 2876 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
4.89ms/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` = 9238 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.85ms/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` = 3172 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.91ms/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` = 9780 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.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` = 3789 and `published_at` < '2025-04-09 05:36:35' 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` = 14995 and `published_at` < '2025-04-09 05:36:35' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.73ms/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` = 3928 and `published_at` < '2025-04-09 05:36:35' 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` = 3984 and `published_at` < '2025-04-09 05:36:35' 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` = 17067 and `published_at` < '2025-04-09 05:36:35' 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` = 4020 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.01ms/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` = 4031 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.79ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 4032 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.01ms/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` = 15283 and `published_at` < '2025-04-09 05:36:36' 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` = 10666 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.88ms/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` = 14214 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.72ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 15284 and `published_at` < '2025-04-09 05:36:36' 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` = 14218 and `published_at` < '2025-04-09 05:36:36' 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` = 17068 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.65ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 17069 and `published_at` < '2025-04-09 05:36:36' 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` = 28774 and `published_at` < '2025-04-09 05:36:36' 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` = 17181 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.52ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 17511 and `published_at` < '2025-04-09 05:36:36' 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` = 9777 and `published_at` < '2025-04-09 05:36:36' 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` = 9779 and `published_at` < '2025-04-09 05:36:36' 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` = 36684 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.6ms/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` = 32672 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
1.81ms/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` = 24452 and `published_at` < '2025-04-09 05:36:36' 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` = 24453 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
3.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` = 8881 and `published_at` < '2025-04-09 05:36:36' 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` = 8882 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.01ms/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` = 8883 and `published_at` < '2025-04-09 05:36:36' and `deleted_at` is null and `featured` = 1 order by `published_at` desc
2.76ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT
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 (23572, 175, 236, 32680, 12575, 11169, 9549, 11329, 452, 17065, 499, 12057, 5232, 13894, 11155, 17066, 19725, 11170, 19398, 1499, 1505, 15282, 8895, 9776, 9778, 3290, 2876, 9238, 3172, 9780, 3789, 14995, 3928, 3984, 17067, 4020, 4031, 4032, 15283, 10666, 14214, 15284, 14218, 17068, 17069, 28774, 17181, 17511, 9777, 9779, 36684, 32672, 24452, 24453, 8881, 8882, 8883) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC
3.32ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_people` where `v2_people`.`member_id` = 908 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1
2.41ms/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` = 908 order by `headquarters` desc, `contact` desc, `name` asc
1.82msview::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` = 908 order by `display_order` asc, `field` asc
2.74msview::companies.partials.display-overview:53buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
2.12ms/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.84ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.32ms/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.36ms/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.42ms/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.85ms/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.55ms/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.36ms/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.23ms/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" => "9913" "REMOTE_ADDR" => "3.21.41.164" "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/331" "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" => 1744176995.3272 "REQUEST_TIME" => 1744176995 ]
[]
0 of 0array:5 [▶ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 09 Apr 2025 05:36:36 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkptVFhOd1NXYU1ScnVoMGJSdDdOUnc9PSIsInZhbHVlIjoib21EVWpFdzhOWGRtdUkzVGtlNW5PN01CRVJjMVhxR3NwRW12TTFvS2xtTGpmS29nQ1BNYlZBNUhjamhudTFjeDJJdkpoNlhSOHNXM2kyejFxR3hCOTlpQTJNcWVzUDhIbWtjWmJ4WVhpMGxDTXVLcnJ6VTlDRnNuUU5zWWZlZEUiLCJtYWMiOiJiNzIwZWRlYTY5Nzg4YWU0NDU2MzEyMWI3MmVhYjhkN2FiYWI1MzZkMTVmNTZjNzM1MDNjMTUwMjZjYTMxZjU4In0%3D; expires=Wed, 09-Apr-2025 07:36:36 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkptVFhOd1NXYU1ScnVoMGJSdDdOUnc9PSIsInZhbHVlIjoib21EVWpFdzhOWGRtdUkzVGtlNW5PN01CRVJjMVhxR3NwRW12TTFvS2xtTGpmS29nQ1BNYlZBNUhjamhudTFjeDJJdkpoN ▶" 1 => "skyscraper_center_session=eyJpdiI6InhBOTRaZ0VxSzlGUG5UYmZoRDhRZ0E9PSIsInZhbHVlIjoiSmRmRWFMa3g2TWFnXC9oSkkrc1QrSFZjVUUyc3JcL0JrNTRPMGQwZkxTbW1jcXB5eVVwdTJFRTR1QWZlRDRycTJ5RjNKQUc5WngyU1NvMHNITlh4ZU56NVFNUUxrSzdSeHluckxuTzJWWEtPZXpmY3JuNjdlSHIwc2k1SGxtS2FcLzciLCJtYWMiOiJkMGQ3NmQ5MmQyN2FiZTdkNzUzYzE2ZTg3ZWJlMTRkODhlZmRmZjAyNmRhNjI1ZjA4YWE3YmU0ZmRmNzg2MDI2In0%3D; expires=Wed, 09-Apr-2025 07:36:36 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InhBOTRaZ0VxSzlGUG5UYmZoRDhRZ0E9PSIsInZhbHVlIjoiSmRmRWFMa3g2TWFnXC9oSkkrc1QrSFZjVUUyc3JcL0JrNTRPMGQwZkxTbW1jcXB5eVVwdTJFRTR1QW ▶" 2 => "visit_counter=eyJpdiI6IjY4WG1Pc05CWGtIdEg5b2VkTVp1N3c9PSIsInZhbHVlIjoiQXRRYlZjSXlWd1Z1SzlqbzltZ0VKNER3cHlGZ0x2U1Bha1JnRlB4ZVVlbjA3c1QyV1BocTNRZlFmbzMxUFI4ZiIsIm1hYyI6ImE2MDYyY2I5MDEzZDQyODRhZTZmYTYxODQ1YjBhNDhlYTczZDMyMTAxYjYzODM2ZjQ2NWNiMmZiYTAyM2RmODQifQ%3D%3D; expires=Fri, 09-May-2025 05:36:35 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IjY4WG1Pc05CWGtIdEg5b2VkTVp1N3c9PSIsInZhbHVlIjoiQXRRYlZjSXlWd1Z1SzlqbzltZ0VKNER3cHlGZ0x2U1Bha1JnRlB4ZVVlbjA3c1QyV1BocTNRZlFmbzMxUFI4ZiIsIm ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkptVFhOd1NXYU1ScnVoMGJSdDdOUnc9PSIsInZhbHVlIjoib21EVWpFdzhOWGRtdUkzVGtlNW5PN01CRVJjMVhxR3NwRW12TTFvS2xtTGpmS29nQ1BNYlZBNUhjamhudTFjeDJJdkpoNlhSOHNXM2kyejFxR3hCOTlpQTJNcWVzUDhIbWtjWmJ4WVhpMGxDTXVLcnJ6VTlDRnNuUU5zWWZlZEUiLCJtYWMiOiJiNzIwZWRlYTY5Nzg4YWU0NDU2MzEyMWI3MmVhYjhkN2FiYWI1MzZkMTVmNTZjNzM1MDNjMTUwMjZjYTMxZjU4In0%3D; expires=Wed, 09-Apr-2025 07:36:36 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkptVFhOd1NXYU1ScnVoMGJSdDdOUnc9PSIsInZhbHVlIjoib21EVWpFdzhOWGRtdUkzVGtlNW5PN01CRVJjMVhxR3NwRW12TTFvS2xtTGpmS29nQ1BNYlZBNUhjamhudTFjeDJJdkpoN ▶" 1 => "skyscraper_center_session=eyJpdiI6InhBOTRaZ0VxSzlGUG5UYmZoRDhRZ0E9PSIsInZhbHVlIjoiSmRmRWFMa3g2TWFnXC9oSkkrc1QrSFZjVUUyc3JcL0JrNTRPMGQwZkxTbW1jcXB5eVVwdTJFRTR1QWZlRDRycTJ5RjNKQUc5WngyU1NvMHNITlh4ZU56NVFNUUxrSzdSeHluckxuTzJWWEtPZXpmY3JuNjdlSHIwc2k1SGxtS2FcLzciLCJtYWMiOiJkMGQ3NmQ5MmQyN2FiZTdkNzUzYzE2ZTg3ZWJlMTRkODhlZmRmZjAyNmRhNjI1ZjA4YWE3YmU0ZmRmNzg2MDI2In0%3D; expires=Wed, 09-Apr-2025 07:36:36 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InhBOTRaZ0VxSzlGUG5UYmZoRDhRZ0E9PSIsInZhbHVlIjoiSmRmRWFMa3g2TWFnXC9oSkkrc1QrSFZjVUUyc3JcL0JrNTRPMGQwZkxTbW1jcXB5eVVwdTJFRTR1QW ▶" 2 => "visit_counter=eyJpdiI6IjY4WG1Pc05CWGtIdEg5b2VkTVp1N3c9PSIsInZhbHVlIjoiQXRRYlZjSXlWd1Z1SzlqbzltZ0VKNER3cHlGZ0x2U1Bha1JnRlB4ZVVlbjA3c1QyV1BocTNRZlFmbzMxUFI4ZiIsIm1hYyI6ImE2MDYyY2I5MDEzZDQyODRhZTZmYTYxODQ1YjBhNDhlYTczZDMyMTAxYjYzODM2ZjQ2NWNiMmZiYTAyM2RmODQifQ%3D%3D; expires=Fri, 09-May-2025 05:36:35 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjY4WG1Pc05CWGtIdEg5b2VkTVp1N3c9PSIsInZhbHVlIjoiQXRRYlZjSXlWd1Z1SzlqbzltZ0VKNER3cHlGZ0x2U1Bha1JnRlB4ZVVlbjA3c1QyV1BocTNRZlFmbzMxUFI4ZiIsIm ▶" ] ]
0 of 0array:4 [▶ "_token" => "ULwgbHJaQTSujtKmF9xo9FQr2X4N9BNbxSpKaSCm" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/company/331" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]