Miami

Rank	Name	Height
1	Panorama Tower	251.9 m / 827 ft
2	Aston Martin Residences	249 m / 817 ft
3	Four Seasons Hotel & Tower	240.4 m / 789 ft
4	Southeast Financial Center	232.8 m / 764 ft
5	Brickell Flatiron	224.3 m / 736 ft
6	830 Brickell	223.1 m / 732 ft
7	Marquis	214 m / 702 ft
8	One Thousand Museum	213.1 m / 699 ft
9	Paramount Miami Worldcenter	213.1 m / 699 ft
10	Wells Fargo Tower	199.5 m / 655 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
Langan Engineering	London	Platinum	92	CIV • LAND • ENVE • GEO • SEIS
RWDI	Guelph	Gold	265	WIND • ENVE • ENGO
CBRE Group, Inc.	Miami	Silver	65	FIN • PROP
Crescent Heights	Miami	Silver	4	INTR • DEV • PROP

Messages Timeline Exceptions Views23 Route Queries59 Models594 Mails Gate Session Request

7.3.331.98s16MBGET city/{slug}

Booting (7.72ms)
Application (1.97s)
1 x Application (99.61%)
1.97s
1 x Booting (0.39%)
7.72ms

23 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`

common-redesign.element.building-research-grid (resources/views/common-redesign/element/building-research-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`

common-redesign.element.building-research-grid (resources/views/common-redesign/element/building-research-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

59 statements were executed, 10 of which were duplicated, 49 unique1.85s

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

Metadata
Bindings	0. miami
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 (163)1.49ms/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 (2)4.82ms/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 (1632) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

371ms/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 (1632)5.57ms/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 (1632) order by `start_date` desc

3.02ms/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 (795, 1539, 1632, 1657, 2482, 2996)2ms/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 (1632) order by `type` asc, `date` desc

3.25ms/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 (1632)7.38ms/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 (800, 3082, 3083, 3085, 3086, 3087, 3088, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3393, 3395, 3500, 3670, 4070, 4081, 4082, 4083, 4256, 6518, 6542, 6547, 6914, 7179, 8179, 10074, 10963, 18089, 40647) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

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

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

Metadata
Bindings	0. 1632 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` = 192 and `ctbuh_company`.`deleted_at` is null

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

Metadata
Bindings	0. 192
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` = 277 and `ctbuh_company`.`deleted_at` is null

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

Metadata
Bindings	0. 277
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` = 65 and `ctbuh_company`.`deleted_at` is null

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

Metadata
Bindings	0. 65
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` = 899 and `ctbuh_company`.`deleted_at` is null

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

Metadata
Bindings	0. 899
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'1.3ms/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_categories` where `type` = 'Video'1.09ms/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_categories` where `type` = 'Video'1.09ms/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` = 41 limit 11.3ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 41
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 * from `v2_resource_categories` where `type` = 'Video'1.35ms/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` = 41 limit 11.58ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 41
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 * from `v2_resource_categories` where `type` = 'Video'2.56ms/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_categories` where `type` = 'Video'1.96ms/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` = 41 limit 11.18ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 41
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 * from `v2_resource_categories` where `type` = 'Video'1.22ms/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` = 43 limit 11.23ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 43
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` = 1632 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc

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

Metadata
Bindings	0. 1632
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` = 1632 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-12 16:37:39' and `deleted_at` is null order by `published_at` desc

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

Metadata
Bindings	0. 1632 1. 2025-04-12 16:37:39
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` = 163 limit 11.24ms/app/Http/Controllers/Controller.php:423buldingdb

Metadata
Bindings	0. 163
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 = '1632'
ORDER BY height_architecture DESC
LIMIT 1

14.88ms/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

14.81ms/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 country_id = '163'
ORDER BY num_buildings DESC, name

6.7ms/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 = '1632'
AND completed != 0
AND status IN('COM')
AND height_architecture >= 150

124ms/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` asc2.07ms/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` = 1632 order by `position` asc

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

Metadata
Bindings	0. 1632
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` = 1632 and `ctbuh_building`.`deleted_at` is null

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

Metadata
Bindings	0. 1 1. Renovated 2. building 3. COM 4. UC 5. STO 6. UCT 7. 150 8. 1632
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` = 1632 and `ctbuh_building`.`deleted_at` is null

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

Metadata
Bindings	0. 1 1. Renovated 2. building 3. COM 4. UC 5. STO 6. UCT 7. 150 8. 1632
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` = 192 order by `headquarters` desc, `contact` desc, `name` asc

2.2ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 192
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(2094) 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(2094))
)

175ms/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` = 192 order by `display_order` asc, `field` asc

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

Metadata
Bindings	0. 192
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` = 277 order by `headquarters` desc, `contact` desc, `name` asc

1.77ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 277
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(3928) 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(3928))
)

190ms/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` = 277 order by `display_order` asc, `field` asc

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

Metadata
Bindings	0. 277
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` = 65 order by `headquarters` desc, `contact` desc, `name` asc

1.78ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 65
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(5753,6639) 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(5753,6639))
)

99.71ms/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` = 65 order by `display_order` asc, `field` asc

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

Metadata
Bindings	0. 65
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` = 899 order by `headquarters` desc, `contact` desc, `name` asc

2.48ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 899
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(4273) 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(4273))
)

135ms/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` = 899 order by `display_order` asc, `field` asc

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

Metadata
Bindings	0. 899
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 `v2_ctbuh_company_person` where `person_id` = 3103 order by `current_company` desc, `company_name` asc13.62ms/app/Person.php:85buldingdb

Metadata
Bindings	0. 3103
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Person.php:85 13. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 14. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 15. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 16. /app/Person.php:86

select * from `nav_menu_items` where `parent_id` is null1.36ms/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.44ms/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.65ms/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.22ms/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

2.06ms/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.18ms/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.42ms/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.28ms/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.1ms/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: 54
App\CtbuhCompany: 5
App\Member: 4
App\Role: 16
App\Person: 38
App\Initiative: 26
App\Building: 390
App\Region: 1
App\Country: 2
App\City: 21

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

path_info

/city/miami

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" => "57280"
  "REMOTE_ADDR" => "18.218.140.12"
  "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/miami"
  "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" => 1744475859.3751
  "REQUEST_TIME" => 1744475859
]

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 => "Sat, 12 Apr 2025 16:37:40 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikp3eWZZQW5jT2tYckNUNVNXT3V5THc9PSIsInZhbHVlIjoiQXowXC8zVmJrRVwvYVBZRTczRUcxRm9wOTg3eHBEZWdZelFIbExTcUExS0MwYWtWQWtRVElpRTB2akJydVplM3huNjVHbXhqVVcwQnN3TEc1WGh6XC9leU9VU2RBNWtoSXRNM3pLdnlqMGdlR0kwak9EbzVVQWQrMGJsYjFyVXk4NFIiLCJtYWMiOiJjMGE1YTZlYzdlOTU2MmY0ZWE1ZGM3YjMxOTAwYzgzMDYzYzI5YjhmM2FlOGU0NmNmODJkNzEyMWI2ZmE1MmEwIn0%3D; expires=Sat, 12-Apr-2025 18:37:41 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikp3eWZZQW5jT2tYckNUNVNXT3V5THc9PSIsInZhbHVlIjoiQXowXC8zVmJrRVwvYVBZRTczRUcxRm9wOTg3eHBEZWdZelFIbExTcUExS0MwYWtWQWtRVElpRTB2akJydVplM3huNjVHb ▶"
    1 => "skyscraper_center_session=eyJpdiI6InRFTDRacVUyVGtHdXZpQTk2Y25yQ3c9PSIsInZhbHVlIjoiQUFFK0hZdnpFaHdQWFY0RHM5RUVMaXVjMlhodGdCYzMzakZXQ0NldFVEeTNWZTA5NGpzaXFGVTNFdEFcL3h3aHpFU2NyQ1hIUWlINnZtcVFzaUI1aXB6bDZXRDRcL0pjN3pQTHM1SVpxcVwvTnowUEFwQW1NRUlwTmtXSFlLV0pOTE0iLCJtYWMiOiIzYmVlNWRlZjFkNzliMzBlNDM3NDA1ZmMyMmE1NDBiNzE2MzczMjI0ZDgwMGRlODFhOWMzMjg2ZGY5MWJhOGU3In0%3D; expires=Sat, 12-Apr-2025 18:37:41 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InRFTDRacVUyVGtHdXZpQTk2Y25yQ3c9PSIsInZhbHVlIjoiQUFFK0hZdnpFaHdQWFY0RHM5RUVMaXVjMlhodGdCYzMzakZXQ0NldFVEeTNWZTA5NGpzaXFGVTNFdE ▶"
    2 => "visit_counter=eyJpdiI6IkEwdHpOVGlOekdzRE5cL1JONHpGZHNnPT0iLCJ2YWx1ZSI6Im11WU9cL29GSytidDM2QzBVbWUxeUtNdWZ6eXBkMlYxMGJ4MDNIOFhqSXZrMldIdDhcL05wRWQ4MCtJMkR2YWNHNiIsIm1hYyI6IjZhOTJmOTVmM2M2ODkyMmUwNjMxYjkxNjFmM2I1ZTM1MmRkYWVkMzg1OWFiZjM4NzE0N2VlMmYwOTZkNDE5MDMifQ%3D%3D; expires=Mon, 12-May-2025 16:37:39 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6IkEwdHpOVGlOekdzRE5cL1JONHpGZHNnPT0iLCJ2YWx1ZSI6Im11WU9cL29GSytidDM2QzBVbWUxeUtNdWZ6eXBkMlYxMGJ4MDNIOFhqSXZrMldIdDhcL05wRWQ4MCtJMkR2YWNHNi ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikp3eWZZQW5jT2tYckNUNVNXT3V5THc9PSIsInZhbHVlIjoiQXowXC8zVmJrRVwvYVBZRTczRUcxRm9wOTg3eHBEZWdZelFIbExTcUExS0MwYWtWQWtRVElpRTB2akJydVplM3huNjVHbXhqVVcwQnN3TEc1WGh6XC9leU9VU2RBNWtoSXRNM3pLdnlqMGdlR0kwak9EbzVVQWQrMGJsYjFyVXk4NFIiLCJtYWMiOiJjMGE1YTZlYzdlOTU2MmY0ZWE1ZGM3YjMxOTAwYzgzMDYzYzI5YjhmM2FlOGU0NmNmODJkNzEyMWI2ZmE1MmEwIn0%3D; expires=Sat, 12-Apr-2025 18:37:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikp3eWZZQW5jT2tYckNUNVNXT3V5THc9PSIsInZhbHVlIjoiQXowXC8zVmJrRVwvYVBZRTczRUcxRm9wOTg3eHBEZWdZelFIbExTcUExS0MwYWtWQWtRVElpRTB2akJydVplM3huNjVHb ▶"
    1 => "skyscraper_center_session=eyJpdiI6InRFTDRacVUyVGtHdXZpQTk2Y25yQ3c9PSIsInZhbHVlIjoiQUFFK0hZdnpFaHdQWFY0RHM5RUVMaXVjMlhodGdCYzMzakZXQ0NldFVEeTNWZTA5NGpzaXFGVTNFdEFcL3h3aHpFU2NyQ1hIUWlINnZtcVFzaUI1aXB6bDZXRDRcL0pjN3pQTHM1SVpxcVwvTnowUEFwQW1NRUlwTmtXSFlLV0pOTE0iLCJtYWMiOiIzYmVlNWRlZjFkNzliMzBlNDM3NDA1ZmMyMmE1NDBiNzE2MzczMjI0ZDgwMGRlODFhOWMzMjg2ZGY5MWJhOGU3In0%3D; expires=Sat, 12-Apr-2025 18:37:41 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InRFTDRacVUyVGtHdXZpQTk2Y25yQ3c9PSIsInZhbHVlIjoiQUFFK0hZdnpFaHdQWFY0RHM5RUVMaXVjMlhodGdCYzMzakZXQ0NldFVEeTNWZTA5NGpzaXFGVTNFdE ▶"
    2 => "visit_counter=eyJpdiI6IkEwdHpOVGlOekdzRE5cL1JONHpGZHNnPT0iLCJ2YWx1ZSI6Im11WU9cL29GSytidDM2QzBVbWUxeUtNdWZ6eXBkMlYxMGJ4MDNIOFhqSXZrMldIdDhcL05wRWQ4MCtJMkR2YWNHNiIsIm1hYyI6IjZhOTJmOTVmM2M2ODkyMmUwNjMxYjkxNjFmM2I1ZTM1MmRkYWVkMzg1OWFiZjM4NzE0N2VlMmYwOTZkNDE5MDMifQ%3D%3D; expires=Mon, 12-May-2025 16:37:39 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IkEwdHpOVGlOekdzRE5cL1JONHpGZHNnPT0iLCJ2YWx1ZSI6Im11WU9cL29GSytidDM2QzBVbWUxeUtNdWZ6eXBkMlYxMGJ4MDNIOFhqSXZrMldIdDhcL05wRWQ4MCtJMkR2YWNHNi ▶"
  ]
]

session_attributes

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

Facts

Rankings

24

4

3

Buildings

Building Completions Timeline

Miami CTBUH Members

CTBUH People & Events

Videos

Research

Research

1 x Application (99.61%)	1.97s
1 x Booting (0.39%)	7.72ms

View all results

Miami

Facts

Rankings

24

4

3

Buildings

Building Completions Timeline

Miami CTBUH Members

CTBUH People & Events

Videos

Research

Research