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 |
136.4 m / 448 ft |
||
2 |
129 m / 423 ft |
||
3 |
127 m / 417 ft |
||
4 |
119 m / 390 ft |
||
5 |
118 m / 387 ft |
||
6 |
118 m / 387 ft |
||
7 |
114 m / 374 ft |
||
8 |
113 m / 371 ft |
||
9 |
110 m / 361 ft |
||
10 |
101 m / 331 ft |
Not enough data. Please change your search criteria.
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
Filter by✕ + Select all |
---|---|---|---|---|---|
![]() |
Silver |
0 |
DEV |
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…
31 May 2018
A disused grain silo in Cape Town has been adapted to accommodate Africa’s first international museum dedicated to contemporary African art. A 33-meter-tall storage annex...
31 May 2018
Interview: Mark Noble & Mat Cash | Zeitz MOCAA
Mark Noble, Development Director of V&A Waterfront, and Mat Cash, Group Leader of Heatherwick Studio, are interviewed by Chris Bentley regarding the Best Tall Building...
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.88%) | 1.05s |
1 x Booting (1.11%) | 11.73ms |
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 |
|
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 |
|
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` = 'cape-town' limit 1
28.29ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (172)
5.14ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_regions` where `v2_regions`.`id` in (5)
7.27ms/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 (1744) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
291ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1744)
1.36ms/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 (1744) order by `start_date` desc
1.83ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1539)
2.81ms/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 (1744) order by `type` asc, `date` desc
1.7ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_people` where `v2_people`.`city_id` in (1744)
7.86ms/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 (93, 759, 4649, 6684, 6963) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
39.45ms/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` = 1744 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc
24.62ms/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` = 1313 and `ctbuh_company`.`deleted_at` is null
4.25ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
Bindings |
|
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` = 47 limit 1
1.31ms/app/Http/Controllers/CityController.php:803buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_categories` where `type` = 'Video'
4.92ms/app/Http/Controllers/CityController.php:794buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 52 limit 1
7.51ms/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` = 1744 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc
7.71ms/app/Http/Controllers/CityController.php:896buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `global_news_posts` where `global_news_posts`.`city_id` = 1744 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-19 08:02:47' and `deleted_at` is null order by `published_at` desc
6.93ms/app/Http/Controllers/CityController.php:904buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` = 172 limit 1
7.26ms/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 = '1744'
ORDER BY height_architecture DESC
LIMIT 1
59.53ms/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
26.81ms/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 = '172'
ORDER BY num_buildings DESC, name
5.65ms/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 = '1744'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150
128ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_fields` order by `id` asc
5.94ms/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` = 1744 order by `position` asc
6.11msview::cities.tabs.overview:9buldingdbMetadata | |
---|---|
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` = 1313 order by `headquarters` desc, `contact` desc, `name` asc
6.34ms/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(17933) 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(17933))
)
232ms/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` = 1313 order by `display_order` asc, `field` asc
16.24msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
7.64ms/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
6.81ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
3.3ms/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
7.34ms/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
2.92ms/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.35ms/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.72ms/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.33ms/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.34ms/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" => "40073" "REMOTE_ADDR" => "3.138.247.255" "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/cape-town" "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" => 1745049767.2811 "REQUEST_TIME" => 1745049767 ]
[]
0 of 0array:5 [▶ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 19 Apr 2025 08:02:48 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlwvRnErdDJybnZEaGR2ZzFSZ3ZvNzNRPT0iLCJ2YWx1ZSI6InJBME45ZmU4bStWZnpBdjFGN05mQWQrSzEzbllQaTRcL0VGK09IcXFyWUtJR1FpNjkzRzdINW43MGtXK284cGp4UnVQMWJtdTk3TlRHb3JwamswVWt6YzNTK3puSlRnanJ5WkFvNmlyU0Z4XC91bDJDQmZPXC9VVGhZYW1tWnJxM2g2IiwibWFjIjoiNzc0NDA2NGFmOWExNjEwYzU0ZWMxNzFkYmZmMTk2NTgwN2UxNTczOTIxMmZlYjg1YzljMzMwYTNhM2U4MjZlNyJ9; expires=Sat, 19-Apr-2025 10:02:48 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvRnErdDJybnZEaGR2ZzFSZ3ZvNzNRPT0iLCJ2YWx1ZSI6InJBME45ZmU4bStWZnpBdjFGN05mQWQrSzEzbllQaTRcL0VGK09IcXFyWUtJR1FpNjkzRzdINW43MGtXK284cGp4UnVQM ▶" 1 => "skyscraper_center_session=eyJpdiI6Ilp5VFhBb3Nyc096XC9MV0ljV0dqUEtRPT0iLCJ2YWx1ZSI6InI5b3Vnb2JnZjZGM1k2S0ExcHNxYTJcL1RNR1M5WFZrS3dTUnhYWkJsQ2hkaTRBc3piOGJcL2dMM0ZRNU1tSDErcnZNb3kzcG1RaTJKNCtOSG9HWVFrbCtoeVNiUTNpak9GWVpXZzNLNEZ0V1I2bWxJeW9ueVhnaVBCTkRBdDUrNlYiLCJtYWMiOiIzZmVlMTk1MDEwMmJkNDhiODI0MDFjNTQzMzMyMzc5MGFiNmUxZjMyOTBhOTg2NDc4MzkyZTNmNTY5YjhmMmYwIn0%3D; expires=Sat, 19-Apr-2025 10:02:48 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Ilp5VFhBb3Nyc096XC9MV0ljV0dqUEtRPT0iLCJ2YWx1ZSI6InI5b3Vnb2JnZjZGM1k2S0ExcHNxYTJcL1RNR1M5WFZrS3dTUnhYWkJsQ2hkaTRBc3piOGJcL2dMM0 ▶" 2 => "visit_counter=eyJpdiI6InhVd1htQzQrZVNITW5Id3R4bEJvWHc9PSIsInZhbHVlIjoiNDk1bE9FMWEwaEpLbkJONDNjN0xrWlhRdlN3UzRsUmxKVUFtS3VmY2I4REN0KzBocmZEMkUwMlRiVU9lK2RaZCIsIm1hYyI6ImE0ZDNhOWZlOGZhMTgwNDYxMDU5MDRmNGQ5ODQ1MmY3MWNmYjY5NDYxOWQ2YWVkM2U5Njk1MzdmZDZmNDM1ZGIifQ%3D%3D; expires=Mon, 19-May-2025 08:02:47 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6InhVd1htQzQrZVNITW5Id3R4bEJvWHc9PSIsInZhbHVlIjoiNDk1bE9FMWEwaEpLbkJONDNjN0xrWlhRdlN3UzRsUmxKVUFtS3VmY2I4REN0KzBocmZEMkUwMlRiVU9lK2RaZCIsIm ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlwvRnErdDJybnZEaGR2ZzFSZ3ZvNzNRPT0iLCJ2YWx1ZSI6InJBME45ZmU4bStWZnpBdjFGN05mQWQrSzEzbllQaTRcL0VGK09IcXFyWUtJR1FpNjkzRzdINW43MGtXK284cGp4UnVQMWJtdTk3TlRHb3JwamswVWt6YzNTK3puSlRnanJ5WkFvNmlyU0Z4XC91bDJDQmZPXC9VVGhZYW1tWnJxM2g2IiwibWFjIjoiNzc0NDA2NGFmOWExNjEwYzU0ZWMxNzFkYmZmMTk2NTgwN2UxNTczOTIxMmZlYjg1YzljMzMwYTNhM2U4MjZlNyJ9; expires=Sat, 19-Apr-2025 10:02:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvRnErdDJybnZEaGR2ZzFSZ3ZvNzNRPT0iLCJ2YWx1ZSI6InJBME45ZmU4bStWZnpBdjFGN05mQWQrSzEzbllQaTRcL0VGK09IcXFyWUtJR1FpNjkzRzdINW43MGtXK284cGp4UnVQM ▶" 1 => "skyscraper_center_session=eyJpdiI6Ilp5VFhBb3Nyc096XC9MV0ljV0dqUEtRPT0iLCJ2YWx1ZSI6InI5b3Vnb2JnZjZGM1k2S0ExcHNxYTJcL1RNR1M5WFZrS3dTUnhYWkJsQ2hkaTRBc3piOGJcL2dMM0ZRNU1tSDErcnZNb3kzcG1RaTJKNCtOSG9HWVFrbCtoeVNiUTNpak9GWVpXZzNLNEZ0V1I2bWxJeW9ueVhnaVBCTkRBdDUrNlYiLCJtYWMiOiIzZmVlMTk1MDEwMmJkNDhiODI0MDFjNTQzMzMyMzc5MGFiNmUxZjMyOTBhOTg2NDc4MzkyZTNmNTY5YjhmMmYwIn0%3D; expires=Sat, 19-Apr-2025 10:02:48 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Ilp5VFhBb3Nyc096XC9MV0ljV0dqUEtRPT0iLCJ2YWx1ZSI6InI5b3Vnb2JnZjZGM1k2S0ExcHNxYTJcL1RNR1M5WFZrS3dTUnhYWkJsQ2hkaTRBc3piOGJcL2dMM0 ▶" 2 => "visit_counter=eyJpdiI6InhVd1htQzQrZVNITW5Id3R4bEJvWHc9PSIsInZhbHVlIjoiNDk1bE9FMWEwaEpLbkJONDNjN0xrWlhRdlN3UzRsUmxKVUFtS3VmY2I4REN0KzBocmZEMkUwMlRiVU9lK2RaZCIsIm1hYyI6ImE0ZDNhOWZlOGZhMTgwNDYxMDU5MDRmNGQ5ODQ1MmY3MWNmYjY5NDYxOWQ2YWVkM2U5Njk1MzdmZDZmNDM1ZGIifQ%3D%3D; expires=Mon, 19-May-2025 08:02:47 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InhVd1htQzQrZVNITW5Id3R4bEJvWHc9PSIsInZhbHVlIjoiNDk1bE9FMWEwaEpLbkJONDNjN0xrWlhRdlN3UzRsUmxKVUFtS3VmY2I4REN0KzBocmZEMkUwMlRiVU9lK2RaZCIsIm ▶" ] ]
0 of 0array:4 [▶ "_token" => "WdTK87fZEE2Np94zkC32zjKcfdGoB1kGO3YmSZEa" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/city/cape-town" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]