Density
0 people per km²
0 people per mi²
# of 150m+ buildings
101 Completed • 36 Under Construction
First 150m+ Building
Tallest Building
Most Common Function*
Office (53%)
Most Common Material*
Concrete (58%)
by no. of 150m+ completed buildings
Tallest City in
Tallest City in
Tallest City in
Rank | Name |
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 | Height |
---|---|---|---|
1 |
438 m / 1,437 ft |
||
2 |
436 m / 1,430 ft |
||
3 |
339 m / 1,112 ft |
||
4 |
331 m / 1,086 ft |
||
5 |
330 m / 1,083 ft |
||
6 |
330 m / 1,083 ft |
||
7 |
283 m / 928 ft |
||
8 |
275.3 m / 903 ft |
||
9 |
273 m / 896 ft |
||
10 |
264.7 m / 868 ft |
Logo
|
Name
|
City
|
Level
|
# of 150m+ buildings
|
Fields Of Expertise
ACAD:
Academic / University
ARCH:
Architecture
BACS:
Building Automation Control Systems
BMNT:
Building Maintenance
CIV:
Civil Engineering
COMP:
Computers / IT / Software
CON:
Construction / Contractor
COST:
Cost Consulting
DEV:
Developer
ENGO:
Engineering, Other
ENVE:
Environmental Engineering
ENVP:
Environmental Protection
FAC:
Façade Design / Engineering
FIN:
Financial Industry
FIRE:
Fire Engineering
GEO:
Geotechnic / Foundations
HIST:
Historical Preservation
INSU:
Insurance / Risk
INTR:
Interior Design
LAND:
Landscape Architecture
LEGL:
Legal
MRKT:
Marketing / Sales
MATR:
Materials / Products / Systems Supplier
MEP:
Mechanical, Electrical & Plumbing
NONP:
Non-Profit Org. / Assoc. / Gov't
OWN:
Owner (Buildings, Land)
PMNG:
Project Management
PROP:
Property Management
RES:
Research Institute
SEC:
Security Consultancy
SEIS:
Seismic Design
STRC:
Structural Engineering
SURV:
Surveying
TRAN:
Transportation / Urban Infrastructure
URB:
Urban Design
VERC:
Vertical Transportation Consultant
WIND:
Wind Engineering
OTHR:
Other
FACS:
Façade Systems
VERS:
Vertical Transportation Supplier
ENGM:
Engineering, Multi-discipline
|
---|---|---|---|---|---|
![]() |
Gold |
14 |
INTR • LAND • FAC |
CTBUH China Participates in Urban Vision Summit
16 September 2018
CTBUH China participated in the 2018 Urban Vision…
Vertical Transportation: Ascent & Acceleration
12 September 2017
CTBUH partnered with Guinness World Records to…
31 May 2018
Breaking Through the Podium Mold to Enhance the Public Realm
The Greatwall Complex has been designed and delivered as an exemplary development in the financial center of Wuhan, China, providing a world-class workplace and retail...
12 December 2018
Year in Review: Tall Trends of 2018
The astronomical growth in tall building construction observed over the past decade continued in 2018, though the total number of completed buildings of 200 meters’...
01 February 2017
Fusing History and Height in Modern China
Albert Chan is the Director of Development Planning and Design at Shui On Land, based in Shanghai. Shui On Land is the developer of several...
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 (99.07%) | 1.43s |
1 x Booting (0.92%) | 13.21ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
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 |
|
select * from `v2_cities` where `slug` = 'wuhan' limit 1
8.89ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (34)
1.67ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_regions` where `v2_regions`.`id` in (7)
1.19ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `ctbuh_building` where `active` = '1' and `structure_type` = 'building' and (`linked_building_status` is null or `linked_building_status` not in ('COM', 'UC', 'STO', 'UCT')) and `ctbuh_building`.`city_id` in (813) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
406ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (813)
1.77ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select `v2_initiatives`.*, `v2_city_initiative`.`city_id` as `pivot_city_id`, `v2_city_initiative`.`initiative_id` as `pivot_initiative_id` from `v2_initiatives` inner join `v2_city_initiative` on `v2_initiatives`.`id` = `v2_city_initiative`.`initiative_id` where `v2_city_initiative`.`city_id` in (813) order by `start_date` desc
1.71ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (813, 1539)
2.21ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select `v2_resources`.*, `v2_city_resource`.`city_id` as `pivot_city_id`, `v2_city_resource`.`resource_id` as `pivot_resource_id` from `v2_resources` inner join `v2_city_resource` on `v2_resources`.`id` = `v2_city_resource`.`resource_id` where `v2_city_resource`.`city_id` in (813) order by `type` asc, `date` desc
7.49ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_people` where `v2_people`.`city_id` in (813)
4.72ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
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 (3824, 3825, 3827, 3828, 3932, 3933, 4694, 6098, 7192, 7193, 7194, 7195, 7196, 8779) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.69ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select `v2_members`.*, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_members` inner join `v2_city_member` on `v2_members`.`id` = `v2_city_member`.`member_id` where `v2_city_member`.`city_id` = 813 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc
2.01ms/app/Http/Controllers/CityController.php:756buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 1408 and `ctbuh_company`.`deleted_at` is null
1.67ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.62ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 47 limit 1
1.2ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.26ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 45 limit 1
1.32ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
10.11ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 44 limit 1
1.92ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.28ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 42 limit 1
2.54ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
2.69ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
3.55ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 43 limit 1
1.25ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.27ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 41 limit 1
1.33ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.25ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 41 limit 1
1.55ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.2ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 41 limit 1
1.24ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.54ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.96ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.19ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.31ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.3ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 9 limit 1
1.69ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `v2_people`.*, `v2_city_person`.`city_id` as `pivot_city_id`, `v2_city_person`.`person_id` as `pivot_person_id`, `v2_city_person`.`year_start` as `pivot_year_start`, `v2_city_person`.`year_end` as `pivot_year_end`, `v2_city_person`.`title` as `pivot_title`, `v2_city_person`.`display_order` as `pivot_display_order` from `v2_people` inner join `v2_city_person` on `v2_people`.`id` = `v2_city_person`.`person_id` where `v2_city_person`.`city_id` = 813 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc
4.91ms/app/Http/Controllers/CityController.php:896buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `global_news_posts` where `global_news_posts`.`city_id` = 813 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-07 08:10:56' and `deleted_at` is null order by `published_at` desc
1.76ms/app/Http/Controllers/CityController.php:904buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` = 34 limit 1
7.19ms/app/Http/Controllers/Controller.php:423buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
SELECT
id,
name_intl,
height_architecture
FROM ctbuh_building b
WHERE
b.active = 1
AND b.structure_type = 'building'
AND b.status IN('COM')
AND b.height_architecture >= 150
AND b.city_id = '813'
ORDER BY height_architecture DESC
LIMIT 1
3.85ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
SELECT
num_buildings_150 AS num_buildings,
code AS city_locode,
id
FROM v2_cities
ORDER BY num_buildings DESC, name
21.94ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
SELECT
num_buildings_150 AS num_buildings,
code AS city_locode,
id
FROM v2_cities
WHERE country_id = '34'
ORDER BY num_buildings DESC, name
1.88ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Backtrace |
|
SELECT
ROUND(AVG(Year(CURDATE()) - completed), 0) AS age
FROM ctbuh_building
WHERE
active = 1
AND structure_type = 'building'
AND city_id = '813'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150
62.64ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_fields` order by `id` asc
1.48ms/app/Http/Controllers/CityController.php:202buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select `v3_images`.*, `v3_city_image`.`city_id` as `pivot_city_id`, `v3_city_image`.`image_id` as `pivot_image_id`, `v3_city_image`.`position` as `pivot_position`, `v3_city_image`.`created_at` as `pivot_created_at`, `v3_city_image`.`updated_at` as `pivot_updated_at` from `v3_images` inner join `v3_city_image` on `v3_images`.`id` = `v3_city_image`.`image_id` where `v3_city_image`.`city_id` = 813 order by `position` asc
1.62msview::cities.tabs.overview:9buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `main_use_01`, `main_use_02` from `ctbuh_building` where `active` = 1 and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `structure_type` = 'building' and `status` in ('COM', 'UC', 'STO', 'UCT') and `height_architecture` >= 150 and `city_id` = 813 and `ctbuh_building`.`deleted_at` is null
234ms/app/Domain/CityFacts.php:71buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `structural_material` from `ctbuh_building` where `active` = 1 and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `structure_type` = 'building' and `status` in ('COM', 'UC', 'STO', 'UCT') and `height_architecture` >= 150 and `city_id` = 813 and `ctbuh_building`.`deleted_at` is null
242ms/app/Domain/CityFacts.php:116buldingdbMetadata | |
---|---|
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` = 1408 order by `headquarters` desc, `contact` desc, `name` asc
2.03ms/app/Member.php:49buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(20733) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(20733))
)
178ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
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` = 1408 order by `display_order` asc, `field` asc
2.46msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.53ms/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.67ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.44ms/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.42ms/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.21ms/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.45ms/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.22ms/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.42ms/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.28ms/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" => "50954" "REMOTE_ADDR" => "18.189.7.216" "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" => "/city/wuhan" "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" => 1744013456.3396 "REQUEST_TIME" => 1744013456 ]
[]
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 => "Mon, 07 Apr 2025 08:10:57 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVuQ08rZk9qaFYxS29kb0xVZUNwd1E9PSIsInZhbHVlIjoiRHUxb3NMTjhcLyswTTROSkJoNTc1VEx0eGozeDgzSXRwQ0Z1UG1KSldvTm9JMThqazZiM09PamxhbENUSUtuMk1UTzBqV01VV1JCaEs2enFvVEpjQUpTZGxqWnNIdHRmemZEVVpWc25EeFhKczlaNVRNZ2JEWVRsR2F4SU5pdlpWIiwibWFjIjoiZTVjZDcyZWQ3Zjg5YzcxMjg5ODgyMzk0MWNmODdhNzk3YTJjNTEwNDE1NWM4YWFiZTExMjk5OTUwOWNiZmRhYyJ9; expires=Mon, 07-Apr-2025 10:10:57 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVuQ08rZk9qaFYxS29kb0xVZUNwd1E9PSIsInZhbHVlIjoiRHUxb3NMTjhcLyswTTROSkJoNTc1VEx0eGozeDgzSXRwQ0Z1UG1KSldvTm9JMThqazZiM09PamxhbENUSUtuMk1UTzBqV ▶" 1 => "skyscraper_center_session=eyJpdiI6IktEamFibXVVVlJDUUxWa0oxRHhmUVE9PSIsInZhbHVlIjoiMHZsZHV2NE9NMWJHUXY3dTVtdHMyNkJjZ1R4Z3RVVFJTc1wvVWlSbnhlSkFpYVBVcEZDazVJXC9UUU5tKzVLMlwvWWowUU04ajBcLzZlMnRRSGZRWVBuOWlPeUNMMUV4bG9EdDBScmpudUtwb3ZDYWxqOFJqRnUxbkR6d2ErbGlQV2lrIiwibWFjIjoiNDI0MmQ5OWU4NzVmYzVkYTQ2Y2RkY2NjN2Q1ZTY2NzRhNDIwMjZkM2FjYmIwODQyY2IxYzRmMGIxNjVmYjk0YSJ9; expires=Mon, 07-Apr-2025 10:10:57 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IktEamFibXVVVlJDUUxWa0oxRHhmUVE9PSIsInZhbHVlIjoiMHZsZHV2NE9NMWJHUXY3dTVtdHMyNkJjZ1R4Z3RVVFJTc1wvVWlSbnhlSkFpYVBVcEZDazVJXC9UUU ▶" 2 => "visit_counter=eyJpdiI6Ijg0YXRtU1pvbUhNeDUwTmNET2lMZVE9PSIsInZhbHVlIjoiV3N2QTNZdjF3MjRYc25tQVlwQlczMUt1S1VtUFBDSkJ3bzVNZEdKMlpmT1NXNGNNNTJYaU5Mek9oemVYdHVFNyIsIm1hYyI6IjM4OTYxZmJkMzlhMjM1ZjQ1MjNmODFkZjVmM2I5MGZiZmFmODllYzY5NzU3ZDZhOWEwYjI4MDI1ZmU0YjljOGYifQ%3D%3D; expires=Wed, 07-May-2025 08:10:56 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6Ijg0YXRtU1pvbUhNeDUwTmNET2lMZVE9PSIsInZhbHVlIjoiV3N2QTNZdjF3MjRYc25tQVlwQlczMUt1S1VtUFBDSkJ3bzVNZEdKMlpmT1NXNGNNNTJYaU5Mek9oemVYdHVFNyIsIm ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImVuQ08rZk9qaFYxS29kb0xVZUNwd1E9PSIsInZhbHVlIjoiRHUxb3NMTjhcLyswTTROSkJoNTc1VEx0eGozeDgzSXRwQ0Z1UG1KSldvTm9JMThqazZiM09PamxhbENUSUtuMk1UTzBqV01VV1JCaEs2enFvVEpjQUpTZGxqWnNIdHRmemZEVVpWc25EeFhKczlaNVRNZ2JEWVRsR2F4SU5pdlpWIiwibWFjIjoiZTVjZDcyZWQ3Zjg5YzcxMjg5ODgyMzk0MWNmODdhNzk3YTJjNTEwNDE1NWM4YWFiZTExMjk5OTUwOWNiZmRhYyJ9; expires=Mon, 07-Apr-2025 10:10:57 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImVuQ08rZk9qaFYxS29kb0xVZUNwd1E9PSIsInZhbHVlIjoiRHUxb3NMTjhcLyswTTROSkJoNTc1VEx0eGozeDgzSXRwQ0Z1UG1KSldvTm9JMThqazZiM09PamxhbENUSUtuMk1UTzBqV ▶" 1 => "skyscraper_center_session=eyJpdiI6IktEamFibXVVVlJDUUxWa0oxRHhmUVE9PSIsInZhbHVlIjoiMHZsZHV2NE9NMWJHUXY3dTVtdHMyNkJjZ1R4Z3RVVFJTc1wvVWlSbnhlSkFpYVBVcEZDazVJXC9UUU5tKzVLMlwvWWowUU04ajBcLzZlMnRRSGZRWVBuOWlPeUNMMUV4bG9EdDBScmpudUtwb3ZDYWxqOFJqRnUxbkR6d2ErbGlQV2lrIiwibWFjIjoiNDI0MmQ5OWU4NzVmYzVkYTQ2Y2RkY2NjN2Q1ZTY2NzRhNDIwMjZkM2FjYmIwODQyY2IxYzRmMGIxNjVmYjk0YSJ9; expires=Mon, 07-Apr-2025 10:10:57 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IktEamFibXVVVlJDUUxWa0oxRHhmUVE9PSIsInZhbHVlIjoiMHZsZHV2NE9NMWJHUXY3dTVtdHMyNkJjZ1R4Z3RVVFJTc1wvVWlSbnhlSkFpYVBVcEZDazVJXC9UUU ▶" 2 => "visit_counter=eyJpdiI6Ijg0YXRtU1pvbUhNeDUwTmNET2lMZVE9PSIsInZhbHVlIjoiV3N2QTNZdjF3MjRYc25tQVlwQlczMUt1S1VtUFBDSkJ3bzVNZEdKMlpmT1NXNGNNNTJYaU5Mek9oemVYdHVFNyIsIm1hYyI6IjM4OTYxZmJkMzlhMjM1ZjQ1MjNmODFkZjVmM2I5MGZiZmFmODllYzY5NzU3ZDZhOWEwYjI4MDI1ZmU0YjljOGYifQ%3D%3D; expires=Wed, 07-May-2025 08:10:56 GMT; path=/; httponly ◀visit_counter=eyJpdiI6Ijg0YXRtU1pvbUhNeDUwTmNET2lMZVE9PSIsInZhbHVlIjoiV3N2QTNZdjF3MjRYc25tQVlwQlczMUt1S1VtUFBDSkJ3bzVNZEdKMlpmT1NXNGNNNTJYaU5Mek9oemVYdHVFNyIsIm ▶" ] ]
0 of 0array:4 [▶ "_token" => "EIddjj1UT4VVGceJVDm6VB1JnkldfzsUT0Osm2UM" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/city/wuhan" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]