Perth

Rank	Name	Height
1	Central Park Tower	249 m / 817 ft
2	Brookfield Place	234.4 m / 769 ft
3	BankWest Tower	214 m / 702 ft
4	Elizabeth Quay Towers	180 m / 591 ft
5	QV1 Tower	162.6 m / 533 ft
6	David Malcolm Justice Centre	149 m / 489 ft
7	Exchange Plaza	146 m / 479 ft
8	Kings Square VI Tower B	144 m / 472 ft
9	St. Martins Tower	140 m / 459 ft
10	Woodside Plaza	137 m / 449 ft

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
Webber Design	Melbourne	Gold	1	STRC
Hera Engineering Pty Ltd	Perth	Silver	5	STRC • CON • ENGO • FAC • FIRE • GEO • SEIS
Philip Chun Group	Perth	Silver	1	FIRE
Plus Architecture	Melbourne	Silver	4	INTR • URB • ARCH • FAC
Woods Bagot	Perth	Silver	58	INTR • URB • ARCH

Messages Timeline Exceptions Views21 Route Queries54 Models288 Mails Gate Session Request

7.3.331.61s13MBGET city/{slug}

Booting (8.14ms)
Application (1.6s)
1 x Application (99.49%)
1.60s
1 x Booting (0.51%)
8.14ms

21 templates were rendered

cities.tabs.overview (resources/views/cities/tabs/overview.blade.php)28blade


geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel

Params
0	`geo`
1	`title`
2	`buildings`
3	`allBuildingStatuses`
4	`buildings_150`
5	`showFactsSection`
6	`tallestBuilding`
7	`rankingWorld`
8	`rankingRegion`
9	`rankingCountry`
10	`firstSkyscraper`
11	`statuses`
12	`timelineYears`
13	`minHeight`
14	`maxHeight`
15	`timelineMinYear`
16	`members`
17	`memberLevels`
18	`filter_values`
19	`fields`
20	`committeeTitles`
21	`initiatives`
22	`news`
23	`videos`
24	`videoCategories`
25	`research`
26	`tabsData`
27	`accessLevel`

cities.sections.facts (resources/views/cities/sections/facts.blade.php)34blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`

cities.sections.rankings (resources/views/cities/sections/rankings.blade.php)34blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`

companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)39blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
header
tableId
maxItems
displayFull

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`header`
36	`tableId`
37	`maxItems`
38	`displayFull`

common-redesign.login-message (resources/views/common-redesign/login-message.blade.php)38blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
directionRight
noBottomMargin
centerMobile

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`directionRight`
36	`noBottomMargin`
37	`centerMobile`

charts.timeline-company (resources/views/charts/timeline-company.blade.php)38blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
header
chartId
minDisplayHeight

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`header`
36	`chartId`
37	`minDisplayHeight`

cities.sections.companies-table (resources/views/cities/sections/companies-table.blade.php)38blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
header
tableId
paginate

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`header`
36	`tableId`
37	`paginate`

cities.sections.people-events (resources/views/cities/sections/people-events.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

common-redesign.grouped-elements (resources/views/common-redesign/grouped-elements.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

common-redesign.element.building-video-grid (resources/views/common-redesign/element/building-video-grid.blade.php)39blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
displayedItems
__currentLoopData
video
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`displayedItems`
36	`__currentLoopData`
37	`video`
38	`loop`

cities.layout (resources/views/cities/layout.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

layouts.SSC (resources/views/layouts/SSC.blade.php)35blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`

common.header (resources/views/common/header.blade.php)37blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`
36	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)37php


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`
36	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)41php


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data
nav
__currentLoopData
item
loop
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`
36	`nav`
37	`__currentLoopData`
38	`item`
39	`loop`
40	`child`

common.footer (resources/views/common/footer.blade.php)36blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`

common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)36blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`

cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)38blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`
36	`alreadyConsentedWithCookies`
37	`cookieConsentConfig`

cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)38blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
buildings
allBuildingStatuses
buildings_150
showFactsSection
tallestBuilding
rankingWorld
rankingRegion
rankingCountry
firstSkyscraper
statuses
timelineYears
minHeight
maxHeight
timelineMinYear
members
memberLevels
filter_values
fields
committeeTitles
initiatives
news
videos
videoCategories
research
tabsData
accessLevel
filteredBuildings
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`buildings`
9	`allBuildingStatuses`
10	`buildings_150`
11	`showFactsSection`
12	`tallestBuilding`
13	`rankingWorld`
14	`rankingRegion`
15	`rankingCountry`
16	`firstSkyscraper`
17	`statuses`
18	`timelineYears`
19	`minHeight`
20	`maxHeight`
21	`timelineMinYear`
22	`members`
23	`memberLevels`
24	`filter_values`
25	`fields`
26	`committeeTitles`
27	`initiatives`
28	`news`
29	`videos`
30	`videoCategories`
31	`research`
32	`tabsData`
33	`accessLevel`
34	`filteredBuildings`
35	`data`
36	`alreadyConsentedWithCookies`
37	`cookieConsentConfig`

uri: GET city/{slug}
middleware: web
controller: App\Http\Controllers\CityController@display
namespace: App\Http\Controllers
prefix
where
as: city-home
file: app/Http/Controllers/CityController.php:19-246

54 statements were executed1.46s

select * from `v2_cities` where `slug` = 'perth' limit 17.19ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Bindings	0. perth
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Http/Controllers/CityController.php:29 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_countries` where `v2_countries`.`id` in (11)1.2ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:29 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_regions` where `v2_regions`.`id` in (8)2.26ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:29 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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 (656) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

411ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Bindings	0. 1 1. building 2. COM 3. UC 4. STO 5. UCT
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:29 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_cities` where `v2_cities`.`id` in (656)1.48ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	26. /app/Http/Controllers/CityController.php:29 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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 (656) order by `start_date` desc

2.51ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Backtrace	20. /app/Http/Controllers/CityController.php:29 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_cities` where `v2_cities`.`id` in (648)2.94ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /app/Http/Controllers/CityController.php:29 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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 (656) order by `type` asc, `date` desc

1.87ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Backtrace	20. /app/Http/Controllers/CityController.php:29 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_people` where `v2_people`.`city_id` in (656)28.92ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:29 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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 (569, 3475, 4485, 6226, 6549, 6566, 6987, 40955) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

13.67ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Backtrace	25. /app/Http/Controllers/CityController.php:29 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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` = 656 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc

12.91ms/app/Http/Controllers/CityController.php:756buldingdb

Metadata
Bindings	0. 656 1. 0
Backtrace	19. /app/Http/Controllers/CityController.php:756 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 1595 and `ctbuh_company`.`deleted_at` is null

4.28ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 1595
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 1238 and `ctbuh_company`.`deleted_at` is null

2.33ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 1238
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 253 and `ctbuh_company`.`deleted_at` is null

2.3ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 253
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 619 and `ctbuh_company`.`deleted_at` is null

9.46ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 619
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 361 and `ctbuh_company`.`deleted_at` is null

9.36ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 361
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_resource_categories` where `type` = 'Video'5.78ms/app/Http/Controllers/CityController.php:794buldingdb

Metadata
Bindings	0. Video
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/CityController.php:794 13. /app/Http/Controllers/CityController.php:31 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 48 limit 11.36ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 48
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Http/Controllers/CityController.php:803 14. /app/Http/Controllers/CityController.php:31 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 656 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc

7.5ms/app/Http/Controllers/CityController.php:896buldingdb

Metadata
Bindings	0. 656
Backtrace	19. /app/Http/Controllers/CityController.php:896 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `global_news_posts` where `global_news_posts`.`city_id` = 656 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-18 10:28:04' and `deleted_at` is null order by `published_at` desc

6.9ms/app/Http/Controllers/CityController.php:904buldingdb

Metadata
Bindings	0. 656 1. 2025-04-18 10:28:04
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/CityController.php:904 20. /app/Http/Controllers/CityController.php:31 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_countries` where `v2_countries`.`id` = 11 limit 18.8ms/app/Http/Controllers/Controller.php:423buldingdb

Metadata
Bindings	0. 11
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. /app/Http/Controllers/Controller.php:423 22. /app/Http/Controllers/CityController.php:950 23. /app/Http/Controllers/CityController.php:31 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

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 = '656'
ORDER BY height_architecture DESC
LIMIT 1

11.99ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CityController.php:52 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

SELECT
num_buildings_150 AS num_buildings,
code AS city_locode,
id
FROM v2_cities
ORDER BY num_buildings DESC, name

15.92ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CityController.php:66 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

SELECT
num_buildings_150 AS num_buildings,
code AS city_locode,
id
FROM v2_cities
WHERE region_id = '8'
ORDER BY num_buildings DESC, name

5.31ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CityController.php:84 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

SELECT
num_buildings_150 AS num_buildings,
code AS city_locode,
id
FROM v2_cities
WHERE country_id = '11'
ORDER BY num_buildings DESC, name

7.58ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CityController.php:103 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

SELECT
ROUND(AVG(Year(CURDATE()) - completed), 0) AS age
FROM ctbuh_building
WHERE
active = 1
AND structure_type = 'building'
AND city_id = '656'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150

133ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CityController.php:147 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select * from `v2_fields` order by `id` asc1.43ms/app/Http/Controllers/CityController.php:202buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/CityController.php:202 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

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` = 656 order by `position` asc

1.34msview::cities.tabs.overview:9buldingdb

Metadata
Bindings	0. 656
Backtrace	19. view::cities.tabs.overview:9 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

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` = 656 and `ctbuh_building`.`deleted_at` is null

161ms/app/Domain/CityFacts.php:71buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. building 3. COM 4. UC 5. STO 6. UCT 7. 150 8. 656
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Domain/CityFacts.php:71 15. /app/Domain/CityFacts.php:104 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 656 and `ctbuh_building`.`deleted_at` is null

101ms/app/Domain/CityFacts.php:116buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. building 3. COM 4. UC 5. STO 6. UCT 7. 150 8. 656
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Domain/CityFacts.php:116 15. /app/Domain/CityFacts.php:149 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 1595 order by `headquarters` desc, `contact` desc, `name` asc

1.9ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1595
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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(11557) 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(11557))
)

91.17ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 1595 order by `display_order` asc, `field` asc

2.85msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 1595
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

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` = 1238 order by `headquarters` desc, `contact` desc, `name` asc

1.67ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1238
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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(19280) 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(19280))
)

79.57ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 1238 order by `display_order` asc, `field` asc

1.62msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 1238
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

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` = 253 order by `headquarters` desc, `contact` desc, `name` asc

1.65ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 253
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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(8877) 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(8877))
)

80.41ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 253 order by `display_order` asc, `field` asc

1.88msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 253
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

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` = 619 order by `headquarters` desc, `contact` desc, `name` asc

1.98ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 619
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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(9638) 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(9638))
)

80.46ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 619 order by `display_order` asc, `field` asc

1.67msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 619
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

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` = 361 order by `headquarters` desc, `contact` desc, `name` asc

1.5ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 361
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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(411) 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(411))
)

110ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

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` = 361 order by `display_order` asc, `field` asc

2.94msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 361
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null1.47ms/app/NavMenuItem.php:17buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/NavMenuItem.php:17 15. /app/Providers/AppServiceProvider.php:60 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:124 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91

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:110buldingdb

Metadata
Bindings	0. 27
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

select * from `pages` where `pages`.`id` = 88 limit 11.27ms/app/NavMenuItem.php:97buldingdb

Metadata
Bindings	0. 88
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. /app/NavMenuItem.php:97 21. /app/NavMenuItem.php:78 22. /app/NavMenuItem.php:89 23. view::common.header:91 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59

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.25ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 28
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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.61ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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.43ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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.39ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 3
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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.3ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 29
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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.23ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

App\Page: 1
App\NavMenuItem: 36
App\Field: 57
App\CtbuhCompany: 5
App\Member: 5
App\Role: 7
App\Person: 8
App\Initiative: 1
App\Building: 150
App\Region: 1
App\Country: 2
App\City: 15

_token: 1seIIxNzbScYAwIDrcz24ffrdkb0c1evaEkL9Mtb
_previous: array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/perth" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/city/perth

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array: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 => ""
  ]
]

request_server

  0 of 0   
array: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" => "25738"
  "REMOTE_ADDR" => "18.220.137.93"
  "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/perth"
  "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" => 1744972083.5071
  "REQUEST_TIME" => 1744972083
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 10:28:04 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InhneHFZdDNaRzVxSitxZDk0NmdoNkE9PSIsInZhbHVlIjoiOVhYeDMyT1haODdicnhNZEhSdzAwbUdOb0d5MnJ3NnlMRFJueUZFNGQzZGNSaGVFczRwNXhIMFhCZllkRlBsTTNvclRXek1GMWJya2hcL2x3eUJBbTFVaEJ4eTJMKytFa3NwdG5wT3VCWGZVNjhmZzJYNVhlZ3o3bDV3WmtqeHU1IiwibWFjIjoiNmZiZDQ1NTJlOGU3NDAyMDI3OTUyOGFmZDc4ZDA4MzE2MzlhNmVhMjE4NzlkOWJmMTgxNDgxZjAyODNjZmJmZCJ9; expires=Fri, 18-Apr-2025 12:28:05 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InhneHFZdDNaRzVxSitxZDk0NmdoNkE9PSIsInZhbHVlIjoiOVhYeDMyT1haODdicnhNZEhSdzAwbUdOb0d5MnJ3NnlMRFJueUZFNGQzZGNSaGVFczRwNXhIMFhCZllkRlBsTTNvclRXe ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImR1Sm5DZE9sWHlkS0krKzVtOWxGUWc9PSIsInZhbHVlIjoiZGl0UVwvVVdhRlFpUDMrN2NidDNnWmlPYkRGQTg5cGlEV0RQXC9XcTVhODM4Rm90cjIwb3d4MlEzRDlTVm52TTZSNVltTE10ZFNPeGJtbksySUpmaWw4UzQ1MElzMms4TWRDTU1sUFdWVFBHQWFVSXlMR1I0SFZIWmRCTFRZQ2U5MiIsIm1hYyI6IjY2YjljYWE0ZDJmNmYxNzU5ZDlmMmYxODk1YjNlZDQ5ODQ2N2UwYWU5YjFjMGU5ZTM0NGNiYzc0NjJiZDM4MzcifQ%3D%3D; expires=Fri, 18-Apr-2025 12:28:05 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImR1Sm5DZE9sWHlkS0krKzVtOWxGUWc9PSIsInZhbHVlIjoiZGl0UVwvVVdhRlFpUDMrN2NidDNnWmlPYkRGQTg5cGlEV0RQXC9XcTVhODM4Rm90cjIwb3d4MlEzRD ▶"
    2 => "visit_counter=eyJpdiI6Ikg2TlRRV2FIYnM2UWVuSjJaQ2pZNWc9PSIsInZhbHVlIjoiU0VqdnFndllnZmJUT1M3bjZGTG1tVU1NbjNDZnE5MXdMS3d1QzZiVFlUcUJ4VDZMSEZaTzdXK1J2K0c5VG56XC8iLCJtYWMiOiIwMDhkYzEyYzE1MWY5MmU0NmU3YTViMzMwMmU4ZGMwNmQwNWMwMGI0ZWVjZjY1NDY2NzdjN2QwMjg3MDYxMmIwIn0%3D; expires=Sun, 18-May-2025 10:28:03 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6Ikg2TlRRV2FIYnM2UWVuSjJaQ2pZNWc9PSIsInZhbHVlIjoiU0VqdnFndllnZmJUT1M3bjZGTG1tVU1NbjNDZnE5MXdMS3d1QzZiVFlUcUJ4VDZMSEZaTzdXK1J2K0c5VG56XC8iLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InhneHFZdDNaRzVxSitxZDk0NmdoNkE9PSIsInZhbHVlIjoiOVhYeDMyT1haODdicnhNZEhSdzAwbUdOb0d5MnJ3NnlMRFJueUZFNGQzZGNSaGVFczRwNXhIMFhCZllkRlBsTTNvclRXek1GMWJya2hcL2x3eUJBbTFVaEJ4eTJMKytFa3NwdG5wT3VCWGZVNjhmZzJYNVhlZ3o3bDV3WmtqeHU1IiwibWFjIjoiNmZiZDQ1NTJlOGU3NDAyMDI3OTUyOGFmZDc4ZDA4MzE2MzlhNmVhMjE4NzlkOWJmMTgxNDgxZjAyODNjZmJmZCJ9; expires=Fri, 18-Apr-2025 12:28:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InhneHFZdDNaRzVxSitxZDk0NmdoNkE9PSIsInZhbHVlIjoiOVhYeDMyT1haODdicnhNZEhSdzAwbUdOb0d5MnJ3NnlMRFJueUZFNGQzZGNSaGVFczRwNXhIMFhCZllkRlBsTTNvclRXe ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImR1Sm5DZE9sWHlkS0krKzVtOWxGUWc9PSIsInZhbHVlIjoiZGl0UVwvVVdhRlFpUDMrN2NidDNnWmlPYkRGQTg5cGlEV0RQXC9XcTVhODM4Rm90cjIwb3d4MlEzRDlTVm52TTZSNVltTE10ZFNPeGJtbksySUpmaWw4UzQ1MElzMms4TWRDTU1sUFdWVFBHQWFVSXlMR1I0SFZIWmRCTFRZQ2U5MiIsIm1hYyI6IjY2YjljYWE0ZDJmNmYxNzU5ZDlmMmYxODk1YjNlZDQ5ODQ2N2UwYWU5YjFjMGU5ZTM0NGNiYzc0NjJiZDM4MzcifQ%3D%3D; expires=Fri, 18-Apr-2025 12:28:05 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImR1Sm5DZE9sWHlkS0krKzVtOWxGUWc9PSIsInZhbHVlIjoiZGl0UVwvVVdhRlFpUDMrN2NidDNnWmlPYkRGQTg5cGlEV0RQXC9XcTVhODM4Rm90cjIwb3d4MlEzRD ▶"
    2 => "visit_counter=eyJpdiI6Ikg2TlRRV2FIYnM2UWVuSjJaQ2pZNWc9PSIsInZhbHVlIjoiU0VqdnFndllnZmJUT1M3bjZGTG1tVU1NbjNDZnE5MXdMS3d1QzZiVFlUcUJ4VDZMSEZaTzdXK1J2K0c5VG56XC8iLCJtYWMiOiIwMDhkYzEyYzE1MWY5MmU0NmU3YTViMzMwMmU4ZGMwNmQwNWMwMGI0ZWVjZjY1NDY2NzdjN2QwMjg3MDYxMmIwIn0%3D; expires=Sun, 18-May-2025 10:28:03 GMT; path=/; httponly ◀visit_counter=eyJpdiI6Ikg2TlRRV2FIYnM2UWVuSjJaQ2pZNWc9PSIsInZhbHVlIjoiU0VqdnFndllnZmJUT1M3bjZGTG1tVU1NbjNDZnE5MXdMS3d1QzZiVFlUcUJ4VDZMSEZaTzdXK1J2K0c5VG56XC8iLC ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "1seIIxNzbScYAwIDrcz24ffrdkb0c1evaEkL9Mtb"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/city/perth"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Facts

Rankings

141

5

5

Buildings

Building Completions Timeline

Perth CTBUH Members

CTBUH People & Events

Videos

1 x Application (99.49%)	1.60s
1 x Booting (0.51%)	8.14ms

View all results