Density
0 people per km²
0 people per mi²
# of 150m+ buildings
4 Completed • 2 Under Construction
First 150m+ Building
Tallest Building
Most Common Function*
Mixed-use (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 |
187 m / 614 ft |
||
2 |
180.1 m / 591 ft |
||
3 |
178 m / 584 ft |
||
4 |
170 m / 558 ft |
||
5 |
160 m / 525 ft |
||
6 |
155 m / 509 ft |
||
7 |
143 m / 469 ft |
||
8 |
135 m / 443 ft |
||
9 |
130 m / 427 ft |
||
10 |
130 m / 427 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 |
20 |
CIV • LAND • STRC • URB • ARCH • ENVP • ENVE • PMNG • COMP • COST • ENGO • FIRE • GEO • INSU • MEP • SEC • SEIS • SURV • TRAN • VERC |
||
![]() |
China State Construction Overseas Development Co., Ltd. |
Gold |
0 |
DEV • CON • ENGM |
|
![]() |
Silver |
1 |
OWN • PROP |
||
![]() |
Silver |
0 |
PMNG |
2019 Global Walking Tour: 50 Forward | 50 Back
27 Jun-09 August 2019
Join the CTBUH Urban Habitat / Urban Design…
CTBUH 2019 Global Walking Tour: 50 Forward | 50 Back
27 June 2019
The CTBUH Urban Habitat / Urban Design Committee…
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.79%) | 1.44s |
1 x Booting (1.2%) | 17.40ms |
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 |
|
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` = 'auckland' limit 1
19.46ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (121)
4.88ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_regions` where `v2_regions`.`id` in (8)
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 (1387) 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 (1387)
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 (1387) order by `start_date` desc
2.83ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (723, 1539)
1.91ms/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 (1387) order by `type` asc, `date` desc
2.34ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_people` where `v2_people`.`city_id` in (1387)
5.82ms/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 (255, 411, 768, 786, 3462, 4308, 6493, 6614, 8594, 10911, 12086, 26222, 31417, 40590) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
1.82ms/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` = 1387 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc
2.89ms/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` = 34 and `ctbuh_company`.`deleted_at` is null
3.38ms/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` = 1192 and `ctbuh_company`.`deleted_at` is null
1.43ms/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` = 1251 and `ctbuh_company`.`deleted_at` is null
3.72ms/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` = 1441 and `ctbuh_company`.`deleted_at` is null
9.51ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
1.69ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
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` = 1387 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc
2.04ms/app/Http/Controllers/CityController.php:896buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `global_news_posts` where `global_news_posts`.`city_id` = 1387 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-10 08:17:16' and `deleted_at` is null order by `published_at` desc
1.7ms/app/Http/Controllers/CityController.php:904buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` = 121 limit 1
1.56ms/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 = '1387'
ORDER BY height_architecture DESC
LIMIT 1
42.73ms/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
22.98ms/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 = '121'
ORDER BY num_buildings DESC, name
5.75ms/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 = '1387'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150
92.42ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_fields` order by `id` asc
2.67ms/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` = 1387 order by `position` asc
1.54msview::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` = 1387 and `ctbuh_building`.`deleted_at` is null
162ms/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` = 1387 and `ctbuh_building`.`deleted_at` is null
117ms/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` = 34 order by `headquarters` desc, `contact` desc, `name` asc
1.79ms/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(3086) 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(3086))
)
103ms/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` = 34 order by `display_order` asc, `field` asc
1.88msview::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` = 1192 order by `headquarters` desc, `contact` desc, `name` asc
1.75ms/app/Member.php:49buldingdbMetadata | |
---|---|
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` = 1192 order by `display_order` asc, `field` asc
1.41msview::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` = 1251 order by `headquarters` desc, `contact` desc, `name` asc
1.63ms/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(13791) 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(13791))
)
136ms/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` = 1251 order by `display_order` asc, `field` asc
1.71msview::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` = 1441 order by `headquarters` desc, `contact` desc, `name` asc
1.84ms/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(22491) 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(22491))
)
97.46ms/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` = 1441 order by `display_order` asc, `field` asc
1.48msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.23ms/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.29ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.33ms/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.31ms/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.24ms/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.32ms/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.25ms/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.19ms/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" => "20150" "REMOTE_ADDR" => "3.141.244.160" "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/auckland" "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" => 1744273035.7848 "REQUEST_TIME" => 1744273035 ]
[]
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 => "Thu, 10 Apr 2025 08:17:16 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjlIc2lxcmdMZzlYS0ZrV2ZidnVUWnc9PSIsInZhbHVlIjoiclZPUGpTQm84UjdBRUt6MmlBS1VzYTFNQVFQTDJrUG90U1FQYVgzUXl1UmUyZzJ1eHFTS3pZc3NYMUFyQ1pWQlJEd3FLRm5rOEVKdWtcL0dlR2JKSVZKcDlTUHpBUTNkWjNhMVp5bVR4bHFGWmJObklVbUZMaHlBZW4yNUtVRHpEIiwibWFjIjoiOTEzNzljYzY4OTE4YTQ2Y2U2YjcxNjhmMWU2Y2FlYzNmMTZkMTkzYTAzYjlmMjc1YjM4YzJmZmMxMTQ4NDU4NiJ9; expires=Thu, 10-Apr-2025 10:17:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlIc2lxcmdMZzlYS0ZrV2ZidnVUWnc9PSIsInZhbHVlIjoiclZPUGpTQm84UjdBRUt6MmlBS1VzYTFNQVFQTDJrUG90U1FQYVgzUXl1UmUyZzJ1eHFTS3pZc3NYMUFyQ1pWQlJEd3FLR ▶" 1 => "skyscraper_center_session=eyJpdiI6IlZmazNRUGFtdU5WbWF0eDJZejd3Znc9PSIsInZhbHVlIjoic1JudXl6UFFyZGl2UUprQUhzTW1EemlxaEJDK1M3NXpXeUhzTW5WWHlZWnZrU2dBMEg1V1VkUFZPVHJLSG04YktEaDFEM0d5NklpMDNhb3YwRG9lSE1BQ0lRM2lXZHBlRU00RVFadFU2aTQ5d3RjYksxbEpwYVVwdm1mWVlLck8iLCJtYWMiOiJiZTYwMTdjNjRkZGI2MmQ1ZGJkNmJlMjVlMWMwNzE2ZDI0MjU0NGQ3MTk4ZGE2MmE5M2VmOGFhODljNjZkNzRlIn0%3D; expires=Thu, 10-Apr-2025 10:17:17 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlZmazNRUGFtdU5WbWF0eDJZejd3Znc9PSIsInZhbHVlIjoic1JudXl6UFFyZGl2UUprQUhzTW1EemlxaEJDK1M3NXpXeUhzTW5WWHlZWnZrU2dBMEg1V1VkUFZPVH ▶" 2 => "visit_counter=eyJpdiI6IjhnSUNobjRDcmkzZXhDaGMxMG43cmc9PSIsInZhbHVlIjoiS0dpNzR5UURLZU5cL2RGa3F2V0d1V3pmbHJTUVRhZTJrbnpwUElaQ1BSU0xRNTROWXJ4ek9vUDJsVnY2M2N0c1YiLCJtYWMiOiIxYThmMjU2NTdkYjk3NDZlYTFlZWRkMDA2ZTFkNDg0NzE5YzZkNzYzYmMyMWY0OWI4YTlmZDM3ZDY4M2U5MTM3In0%3D; expires=Sat, 10-May-2025 08:17:15 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6IjhnSUNobjRDcmkzZXhDaGMxMG43cmc9PSIsInZhbHVlIjoiS0dpNzR5UURLZU5cL2RGa3F2V0d1V3pmbHJTUVRhZTJrbnpwUElaQ1BSU0xRNTROWXJ4ek9vUDJsVnY2M2N0c1YiLC ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjlIc2lxcmdMZzlYS0ZrV2ZidnVUWnc9PSIsInZhbHVlIjoiclZPUGpTQm84UjdBRUt6MmlBS1VzYTFNQVFQTDJrUG90U1FQYVgzUXl1UmUyZzJ1eHFTS3pZc3NYMUFyQ1pWQlJEd3FLRm5rOEVKdWtcL0dlR2JKSVZKcDlTUHpBUTNkWjNhMVp5bVR4bHFGWmJObklVbUZMaHlBZW4yNUtVRHpEIiwibWFjIjoiOTEzNzljYzY4OTE4YTQ2Y2U2YjcxNjhmMWU2Y2FlYzNmMTZkMTkzYTAzYjlmMjc1YjM4YzJmZmMxMTQ4NDU4NiJ9; expires=Thu, 10-Apr-2025 10:17:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjlIc2lxcmdMZzlYS0ZrV2ZidnVUWnc9PSIsInZhbHVlIjoiclZPUGpTQm84UjdBRUt6MmlBS1VzYTFNQVFQTDJrUG90U1FQYVgzUXl1UmUyZzJ1eHFTS3pZc3NYMUFyQ1pWQlJEd3FLR ▶" 1 => "skyscraper_center_session=eyJpdiI6IlZmazNRUGFtdU5WbWF0eDJZejd3Znc9PSIsInZhbHVlIjoic1JudXl6UFFyZGl2UUprQUhzTW1EemlxaEJDK1M3NXpXeUhzTW5WWHlZWnZrU2dBMEg1V1VkUFZPVHJLSG04YktEaDFEM0d5NklpMDNhb3YwRG9lSE1BQ0lRM2lXZHBlRU00RVFadFU2aTQ5d3RjYksxbEpwYVVwdm1mWVlLck8iLCJtYWMiOiJiZTYwMTdjNjRkZGI2MmQ1ZGJkNmJlMjVlMWMwNzE2ZDI0MjU0NGQ3MTk4ZGE2MmE5M2VmOGFhODljNjZkNzRlIn0%3D; expires=Thu, 10-Apr-2025 10:17:17 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlZmazNRUGFtdU5WbWF0eDJZejd3Znc9PSIsInZhbHVlIjoic1JudXl6UFFyZGl2UUprQUhzTW1EemlxaEJDK1M3NXpXeUhzTW5WWHlZWnZrU2dBMEg1V1VkUFZPVH ▶" 2 => "visit_counter=eyJpdiI6IjhnSUNobjRDcmkzZXhDaGMxMG43cmc9PSIsInZhbHVlIjoiS0dpNzR5UURLZU5cL2RGa3F2V0d1V3pmbHJTUVRhZTJrbnpwUElaQ1BSU0xRNTROWXJ4ek9vUDJsVnY2M2N0c1YiLCJtYWMiOiIxYThmMjU2NTdkYjk3NDZlYTFlZWRkMDA2ZTFkNDg0NzE5YzZkNzYzYmMyMWY0OWI4YTlmZDM3ZDY4M2U5MTM3In0%3D; expires=Sat, 10-May-2025 08:17:15 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjhnSUNobjRDcmkzZXhDaGMxMG43cmc9PSIsInZhbHVlIjoiS0dpNzR5UURLZU5cL2RGa3F2V0d1V3pmbHJTUVRhZTJrbnpwUElaQ1BSU0xRNTROWXJ4ek9vUDJsVnY2M2N0c1YiLC ▶" ] ]
0 of 0array:4 [▶ "_token" => "j5zHv6s0nXhv4ZUDzPhlSvkaxzY5SO0l7lb19ZGM" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/city/auckland" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]