Density
0 people per km²
0 people per mi²
# of 150m+ buildings
5 Completed • 1 Under Construction
First 150m+ Building
Tallest Building
Most Common Function*
Office (67%)
Most Common Material*
Concrete (60%)
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 |
249 m / 817 ft |
||
2 |
248.3 m / 815 ft |
||
3 |
236 m / 774 ft |
||
4 |
224.2 m / 735 ft |
||
5 |
181 m / 594 ft |
||
6 |
156.4 m / 513 ft |
||
7 |
142 m / 466 ft |
||
8 |
116.1 m / 381 ft |
||
9 |
113.8 m / 373 ft |
||
10 |
113.8 m / 373 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
|
---|---|---|---|---|---|
![]() |
Silver |
4 |
ENGO • FAC |
||
![]() |
Silver |
0 |
INTR • ARCH • HIST |
CTBUH Spain to Host Panel Discussion on Tall Buildings
12 January 2018
The purpose of this panel discussion is to focus…
CTBUH Spain: New Material Opportunities
30 November 2016
CTBUH Spain invites you to attend a panel…
18 October 2016
What’s Next?: How Do We Make Vertical Urban Design?
It seems sometimes as if the further away from the ground we rise, the more architectonic and less urban our buildings become. Skyscrapers have always...
17 October 2016
What’s Next?: How Do We Make Vertical Urban Design?
It seems sometimes as if the further away from the ground we rise, the more architectonic and less urban our buildings become. Skyscrapers have always...
17 October 2016
A Smart Real-Time Monitoring GNSS System for High-Rise Buildings
This paper analyzes and develops a real-time GNSS monitoring system to evaluate the lateral and torsional displacement and wind-induced response of a high-rise building. The...
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.38%) | 1.29s |
1 x Booting (1.6%) | 21.09ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
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` = 'madrid' limit 1
15.04ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (51)
1.33ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_regions` where `v2_regions`.`id` in (1)
1.06ms/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 (903) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
390ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (903)
2.41ms/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 (903) order by `start_date` desc
6.71ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (903)
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 (903) order by `type` asc, `date` desc
5.8ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_people` where `v2_people`.`city_id` in (903)
6.9ms/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 (26, 34, 115, 446, 959, 960, 2543, 2699, 2700, 2701, 3248, 3256, 3274, 3419, 3420, 6253, 6257, 6577, 6626, 6686, 6870, 7421, 7634, 8581, 36311) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
5.83ms/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` = 903 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc
6.37ms/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` = 111 and `ctbuh_company`.`deleted_at` is null
4.41ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
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` = 376 and `ctbuh_company`.`deleted_at` is null
6.24ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
3.95ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
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_subcategories` where `type` = 'Video' and `id` = 41 limit 1
1.56ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.38ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 25 limit 1
1.59ms/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` = 903 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc
2.37ms/app/Http/Controllers/CityController.php:896buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `global_news_posts` where `global_news_posts`.`city_id` = 903 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-09 13:08:01' and `deleted_at` is null order by `published_at` desc
1.69ms/app/Http/Controllers/CityController.php:904buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` = 51 limit 1
4.32ms/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 = '903'
ORDER BY height_architecture DESC
LIMIT 1
22.68ms/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
17.8ms/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 = '51'
ORDER BY num_buildings DESC, name
1.63ms/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 = '903'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150
67.45ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_fields` order by `id` asc
3.7ms/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` = 903 order by `position` asc
2.95msview::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` = 903 and `ctbuh_building`.`deleted_at` is null
164ms/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` = 903 and `ctbuh_building`.`deleted_at` is null
118ms/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` = 111 order by `headquarters` desc, `contact` desc, `name` asc
1.93ms/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(8863) 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(8863))
)
112ms/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` = 111 order by `display_order` asc, `field` asc
2.18msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
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` = 376 order by `headquarters` desc, `contact` desc, `name` asc
2.1ms/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(7195) 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(7195))
)
110ms/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` = 376 order by `display_order` asc, `field` asc
1.99msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.98ms/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.86ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
2.97ms/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
3.24ms/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.71ms/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.57ms/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.48ms/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
3.69ms/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.52ms/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" => "32222" "REMOTE_ADDR" => "18.216.0.219" "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/madrid" "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" => 1744204081.0561 "REQUEST_TIME" => 1744204081 ]
[]
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 13:08:01 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3ZlAxeWQrWHBJSU1NN0dlQ2UrVjloclwvODBpb0QyZDlSUHQrS3lWQ0ZwN0FyMEl4Y2F5WG9nRGU0SGJLUiIsIm1hYyI6IjM4MmM3OTVkYjQxMjAwZmQxNjRmNWU4NDYzYzMzNGU0NDI0MTM1YWJjMTM2OWQ3Yjg5YTY0ZjA3NjQ3ZDMwNjIifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3Z ▶" 1 => "skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2o4a3Rxa0psdjhFWlZHSEhKZ1ZBUGh6TzlFeEY1b3czbjI4ZDdCd1d1XC9ZSEZCOTJDUWYwb0RPMTE3VHNkclo3am5UU3k3ciIsIm1hYyI6ImZkYjVjZjNiY2NhZjg1OTA3YTE3YTQxNTIzMWVhODE4NDdkM2E2YTVkZjg4Zjk4MzdhNmJhN2UwNGFjNDJkNTEifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2 ▶" 2 => "visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLCJtYWMiOiIwNjRhOGI3NDM2OTA2MTE0N2MxMzdkYzgxNmFmOWNmZmQ2NWZmMTA1OGRjMGU4NTVlMzQ3Nzg0ZTU2ZmE5OGY3In0%3D; expires=Fri, 09-May-2025 13:08:01 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLC ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3ZlAxeWQrWHBJSU1NN0dlQ2UrVjloclwvODBpb0QyZDlSUHQrS3lWQ0ZwN0FyMEl4Y2F5WG9nRGU0SGJLUiIsIm1hYyI6IjM4MmM3OTVkYjQxMjAwZmQxNjRmNWU4NDYzYzMzNGU0NDI0MTM1YWJjMTM2OWQ3Yjg5YTY0ZjA3NjQ3ZDMwNjIifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3Z ▶" 1 => "skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2o4a3Rxa0psdjhFWlZHSEhKZ1ZBUGh6TzlFeEY1b3czbjI4ZDdCd1d1XC9ZSEZCOTJDUWYwb0RPMTE3VHNkclo3am5UU3k3ciIsIm1hYyI6ImZkYjVjZjNiY2NhZjg1OTA3YTE3YTQxNTIzMWVhODE4NDdkM2E2YTVkZjg4Zjk4MzdhNmJhN2UwNGFjNDJkNTEifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2 ▶" 2 => "visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLCJtYWMiOiIwNjRhOGI3NDM2OTA2MTE0N2MxMzdkYzgxNmFmOWNmZmQ2NWZmMTA1OGRjMGU4NTVlMzQ3Nzg0ZTU2ZmE5OGY3In0%3D; expires=Fri, 09-May-2025 13:08:01 GMT; path=/; httponly ◀visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLC ▶" ] ]
0 of 0array:4 [▶ "_token" => "0y0AxDBhdRQRcICfv7deBNSiYrByqzKPpGX97BtB" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/city/madrid" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]