Density
0 people per km²
0 people per mi²
# of 150m+ buildings
4 Completed • 0 Under Construction
First 150m+ Building
Tallest Building
Most Common Function*
Office (50%)
Most Common Material*
Concrete (100%)
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 |
227.9 m / 748 ft |
||
2 |
201.2 m / 660 ft |
||
3 |
172.8 m / 567 ft |
||
4 |
152.1 m / 499 ft |
||
5 |
140 m / 459 ft |
||
6 |
140 m / 459 ft |
||
7 |
140 m / 459 ft |
||
8 |
140 m / 459 ft |
||
9 |
139 m / 456 ft |
||
10 |
138 m / 453 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 |
0 |
INTR • URB • ARCH |
||
![]() |
Silver |
0 |
PMNG |
Twisting Tall Buildings
18 August 2016
CTBUH has released a study that looks at the…
Founding of CTBUH Chapter in South Africa
01 April 2010
In its move to expand tall building knowledge &…
17 October 2016
The rise of the megacity presents unprecedented opportunities to understand the human urbanization phenomenon, and to observe the effects of multicore, polycentric cities growing together...
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 (97.82%) | 1.10s |
1 x Booting (2.17%) | 24.30ms |
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 |
|
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` = 'johannesburg' limit 1
20.39ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` in (172)
1.24ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_regions` where `v2_regions`.`id` in (5)
1.97ms/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 (1746) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc
336ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1746)
4.57ms/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 (1746) order by `start_date` desc
2.23ms/app/Http/Controllers/CityController.php:29buldingdbMetadata | |
---|---|
Backtrace |
|
select * from `v2_cities` where `v2_cities`.`id` in (1539, 1746)
1.38ms/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 (1746) 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 (1746)
8.18ms/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 (2793, 2794, 2808, 6865, 24757) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc
3.26ms/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` = 1746 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc
5.87ms/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` = 998 and `ctbuh_company`.`deleted_at` is null
7.35ms/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` = 259 and `ctbuh_company`.`deleted_at` is null
2.31ms/app/Http/Controllers/CityController.php:763buldingdbMetadata | |
---|---|
Bindings |
|
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` = 1746 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc
4.41ms/app/Http/Controllers/CityController.php:896buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `global_news_posts` where `global_news_posts`.`city_id` = 1746 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-10 22:04:46' and `deleted_at` is null order by `published_at` desc
1.73ms/app/Http/Controllers/CityController.php:904buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `v2_countries` where `v2_countries`.`id` = 172 limit 1
2.29ms/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 = '1746'
ORDER BY height_architecture DESC
LIMIT 1
17.42ms/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
16.07ms/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 region_id = '5'
ORDER BY num_buildings DESC, name
1.88ms/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
1.86ms/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 = '1746'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150
51.9ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdbMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `v2_fields` order by `id` asc
5.12ms/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` = 1746 order by `position` asc
4.51msview::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` = 1746 and `ctbuh_building`.`deleted_at` is null
121ms/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` = 1746 and `ctbuh_building`.`deleted_at` is null
119ms/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` = 998 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(10163) 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(10163))
)
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` = 998 order by `display_order` asc, `field` asc
8.05msview::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` = 259 order by `headquarters` desc, `contact` desc, `name` asc
3.23ms/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(8971) 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(8971))
)
82.99ms/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` = 259 order by `display_order` asc, `field` asc
1.54msview::cities.sections.companies-table:93buldingdbMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `nav_menu_items` where `parent_id` is null
1.84ms/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.55ms/app/NavMenuItem.php:110buldingdbMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `pages` where `pages`.`id` = 88 limit 1
1.35ms/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.23ms/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.15ms/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.11ms/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.17ms/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.29ms/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.38ms/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" => "60676" "REMOTE_ADDR" => "3.144.33.74" "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/johannesburg" "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" => 1744322685.9859 "REQUEST_TIME" => 1744322685 ]
[]
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 22:04:46 GMT" ] "set-cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlR1UFpaWnJYTlM2enlMVVBWVXQ2dHc9PSIsInZhbHVlIjoiN1daWDREZUtZdXk3cXFNK3RcL1ZLY1RpTDhTMGZLSGt0d2xwbnZQSldCNGZjdzJXT0g0MDBSdzZWSlE0bkk0aFAwM0VoRTc5Mlo3VnpoUjV2bmtqWVVRUjF4aUpFbERwQWU4dXNNeEFUY1gwNFZBTXRNWFwvck9iK1hzS1wvMlpiTDUiLCJtYWMiOiJmMDYzMDkwNmZhMTBhZjdjOTlhN2Q3MmNjZjQ4ODhkNDJiMzBkNDZmNzA5NmQ2NTQ0Njg5NjIzMWQ5OTJmN2IzIn0%3D; expires=Fri, 11-Apr-2025 00:04:47 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlR1UFpaWnJYTlM2enlMVVBWVXQ2dHc9PSIsInZhbHVlIjoiN1daWDREZUtZdXk3cXFNK3RcL1ZLY1RpTDhTMGZLSGt0d2xwbnZQSldCNGZjdzJXT0g0MDBSdzZWSlE0bkk0aFAwM0VoR ▶" 1 => "skyscraper_center_session=eyJpdiI6InozVFFTbGphV0t6YVZKVEdsRmZQY1E9PSIsInZhbHVlIjoiN055aDhvN3lLdUhKVk9yXC9SS2NzeW1UNWZxU1FvV0dYaE5kekp5cEZMYlBNZG5vTnE0VFVPSkU3bXFrZ2JYNUNOb0FCS0lvOGlSUGNWSFJXb1lBVllsbHJuRW02ZkpzaWM4ZHVQWUVaK056bmxhTW93MThZRHlnd1JXWEtmT0VTIiwibWFjIjoiMGU2OWE5MzQwYTI0OWI3NGJmNmNkYjBjZGMwZDc1MTdkYTRjNGE1Y2RlMzI1MWM2MzZhMzBjZWFjMjk2NjhhMSJ9; expires=Fri, 11-Apr-2025 00:04:47 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InozVFFTbGphV0t6YVZKVEdsRmZQY1E9PSIsInZhbHVlIjoiN055aDhvN3lLdUhKVk9yXC9SS2NzeW1UNWZxU1FvV0dYaE5kekp5cEZMYlBNZG5vTnE0VFVPSkU3bX ▶" 2 => "visit_counter=eyJpdiI6IlwvcURETzRNSVVMYTFSc0pPZ0RFN2J3PT0iLCJ2YWx1ZSI6InM2YUlhVDZSR2ZSc2l1WVU5U3RDMWdSajRtUlRsK2c3M2ZcL1dLT0FzWEYydDBXbG5va2hXcGFVMWc5cXFnQWcxIiwibWFjIjoiMGQ2NmI4N2E0YmI5ZmVmZTFlN2MyYzdkYTE5MGQ1ZmM4YWUzZTIzOGU3NWU4ODlhN2JlMDYwNDA5YzU1OWZhNCJ9; expires=Sat, 10-May-2025 22:04:46 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IlwvcURETzRNSVVMYTFSc0pPZ0RFN2J3PT0iLCJ2YWx1ZSI6InM2YUlhVDZSR2ZSc2l1WVU5U3RDMWdSajRtUlRsK2c3M2ZcL1dLT0FzWEYydDBXbG5va2hXcGFVMWc5cXFnQWcxIi ▶" ] "Set-Cookie" => array:3 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlR1UFpaWnJYTlM2enlMVVBWVXQ2dHc9PSIsInZhbHVlIjoiN1daWDREZUtZdXk3cXFNK3RcL1ZLY1RpTDhTMGZLSGt0d2xwbnZQSldCNGZjdzJXT0g0MDBSdzZWSlE0bkk0aFAwM0VoRTc5Mlo3VnpoUjV2bmtqWVVRUjF4aUpFbERwQWU4dXNNeEFUY1gwNFZBTXRNWFwvck9iK1hzS1wvMlpiTDUiLCJtYWMiOiJmMDYzMDkwNmZhMTBhZjdjOTlhN2Q3MmNjZjQ4ODhkNDJiMzBkNDZmNzA5NmQ2NTQ0Njg5NjIzMWQ5OTJmN2IzIn0%3D; expires=Fri, 11-Apr-2025 00:04:47 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlR1UFpaWnJYTlM2enlMVVBWVXQ2dHc9PSIsInZhbHVlIjoiN1daWDREZUtZdXk3cXFNK3RcL1ZLY1RpTDhTMGZLSGt0d2xwbnZQSldCNGZjdzJXT0g0MDBSdzZWSlE0bkk0aFAwM0VoR ▶" 1 => "skyscraper_center_session=eyJpdiI6InozVFFTbGphV0t6YVZKVEdsRmZQY1E9PSIsInZhbHVlIjoiN055aDhvN3lLdUhKVk9yXC9SS2NzeW1UNWZxU1FvV0dYaE5kekp5cEZMYlBNZG5vTnE0VFVPSkU3bXFrZ2JYNUNOb0FCS0lvOGlSUGNWSFJXb1lBVllsbHJuRW02ZkpzaWM4ZHVQWUVaK056bmxhTW93MThZRHlnd1JXWEtmT0VTIiwibWFjIjoiMGU2OWE5MzQwYTI0OWI3NGJmNmNkYjBjZGMwZDc1MTdkYTRjNGE1Y2RlMzI1MWM2MzZhMzBjZWFjMjk2NjhhMSJ9; expires=Fri, 11-Apr-2025 00:04:47 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InozVFFTbGphV0t6YVZKVEdsRmZQY1E9PSIsInZhbHVlIjoiN055aDhvN3lLdUhKVk9yXC9SS2NzeW1UNWZxU1FvV0dYaE5kekp5cEZMYlBNZG5vTnE0VFVPSkU3bX ▶" 2 => "visit_counter=eyJpdiI6IlwvcURETzRNSVVMYTFSc0pPZ0RFN2J3PT0iLCJ2YWx1ZSI6InM2YUlhVDZSR2ZSc2l1WVU5U3RDMWdSajRtUlRsK2c3M2ZcL1dLT0FzWEYydDBXbG5va2hXcGFVMWc5cXFnQWcxIiwibWFjIjoiMGQ2NmI4N2E0YmI5ZmVmZTFlN2MyYzdkYTE5MGQ1ZmM4YWUzZTIzOGU3NWU4ODlhN2JlMDYwNDA5YzU1OWZhNCJ9; expires=Sat, 10-May-2025 22:04:46 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IlwvcURETzRNSVVMYTFSc0pPZ0RFN2J3PT0iLCJ2YWx1ZSI6InM2YUlhVDZSR2ZSc2l1WVU5U3RDMWdSajRtUlRsK2c3M2ZcL1dLT0FzWEYydDBXbG5va2hXcGFVMWc5cXFnQWcxIi ▶" ] ]
0 of 0array:4 [▶ "_token" => "WXDTUoX6U6gg06eK3KpRNSnWUsANOeXf5KHKcDIQ" "_previous" => array:1 [▶ "url" => "https://staging.skyscrapercenter.xyz/city/johannesburg" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]