San Francisco

Rank	Name	Height
1	Salesforce Tower	326.1 m / 1,070 ft
2	Oceanwide Center Tower 1	277.4 m / 910 ft
3	Transamerica Pyramid Center	260 m / 853 ft
4	181 Fremont	246.9 m / 810 ft
5	555 California Street	237.4 m / 779 ft
6	345 California Center	211.8 m / 695 ft
7	Millennium Tower	196.6 m / 645 ft
8	The Avery	188.4 m / 618 ft
9	Park Tower at Transbay	184.5 m / 605 ft
10	One Rincon Hill South Tower	184.4 m / 605 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
Skidmore, Owings & Merrill	Chicago	Platinum	314	CIV • INTR • LAND • STRC • URB • ARCH • ENVE • MRKT • MEP • TRAN
WSP	New York City	Platinum	63	CIV • INTR • STRC • URB • ENVP • PMNG • COMP • ENGO • FAC • FIRE • GEO • MEP • TRAN
Gensler	Chicago	Gold	95	INTR • URB • ARCH • COST • MRKT
ARK Studio Inc.	San Francisco	Silver	7	INTR • URB • ARCH
Autodesk	San Francisco	Silver	0	COMP
CB Engineers	San Francisco	Silver	4	COMP • COST • FIRE • MEP
Degenkolb Engineers	San Francisco	Silver	1	SEIS
Glumac	San Francisco	Silver	2	ENGO • MEP
Hathaway Dinwiddie Construction Company	San Francisco	Silver	2	CON
Heller Manus Architects	San Francisco	Silver	4	URB • ARCH • TRAN
Jay Paul Company	San Francisco	Silver	1	DEV • OWN
MEYERS+ ENGINEERS	San Francisco	Silver	0	ARCH • ENGO • MEP
Studio Gang Architects	Chicago	Silver	4	INTR • URB • ARCH
Swinerton	San Francisco	Silver	0	CON
Syska Hennessy Group	San Francisco	Silver	17	MEP • SEC • VERC

Messages Timeline Exceptions Views23 Route Queries120 Models686 Mails Gate Session Request

7.3.332.52s17MBGET city/{slug}

Booting (23.93ms)
Application (2.5s)
1 x Application (99.05%)
2.50s
1 x Booting (0.95%)
23.93ms

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

120 statements were executed, 20 of which were duplicated, 100 unique2.23s

select * from `v2_cities` where `slug` = 'san-francisco' limit 113.01ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Bindings	0. san-francisco
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.45ms/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)1.3ms/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 (1683) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

211ms/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 (1683)2.4ms/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 (1683) order by `start_date` desc

3.43ms/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 (745, 1539, 1683, 2996)1.66ms/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 (1683) order by `type` asc, `date` desc

3.65ms/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 (1683)9.74ms/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 (79, 261, 278, 284, 431, 524, 543, 561, 655, 665, 677, 701, 803, 812, 823, 824, 825, 826, 827, 835, 836, 837, 838, 895, 913, 924, 944, 945, 958, 1010, 1052, 1095, 1132, 1153, 1480, 1481, 1482, 1483, 1484, 1485, 1486, 1487, 1540, 1639, 1644, 1647, 1655, 1738, 1770, 1777, 1802, 1975, 2205, 2799, 2800, 2801, 3006, 3130, 3212, 3233, 3374, 3375, 3412, 3414, 3459, 3584, 3586, 3646, 3690, 3770, 3830, 3884, 4459, 4543, 4660, 6220, 6249, 6522, 6544, 6661, 6674, 6675, 6751, 6903, 6906, 6924, 6930, 7013, 7023, 7055, 7073, 7333, 8885, 8888, 8892, 8893, 8944, 8945, 8967, 8980, 8984, 9137, 9751, 10212, 10537, 10638, 10645, 10854, 11210, 11451, 11452, 11453, 11894, 25785, 35946, 40371, 40389, 40602) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

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

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

Metadata
Bindings	0. 1683 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

2.07ms/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` = 300 and `ctbuh_company`.`deleted_at` is null

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 316
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.27ms/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.16ms/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.34ms/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.29ms/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.18ms/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.29ms/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.33ms/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.25ms/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` = 52 limit 11.62ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 52
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.41ms/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` = 47 limit 11.33ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 47
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.16ms/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.11ms/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 * from `v2_resource_categories` where `type` = 'Video'1.14ms/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.45ms/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` = 42 limit 11.16ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 42
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` = 41 limit 11.33ms/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.11ms/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.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` = 36 limit 11.16ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 36
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.13ms/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` = 25 limit 11.38ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 25
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.14ms/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` = 25 limit 11.12ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 25
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.06ms/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` = 14 limit 11.17ms/app/Http/Controllers/CityController.php:803buldingdb

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

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

Metadata
Bindings	0. 1683
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` = 1683 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-06 07:19:42' and `deleted_at` is null order by `published_at` desc

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

Metadata
Bindings	0. 1683 1. 2025-04-06 07:19:42
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.27ms/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 = '1683'
ORDER BY height_architecture DESC
LIMIT 1

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

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

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

54.28ms/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.54ms/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` = 1683 order by `position` asc

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

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

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

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

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

Metadata
Bindings	0. 1 1. Renovated 2. building 3. COM 4. UC 5. STO 6. UCT 7. 150 8. 1683
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.11ms/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 `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.73msview::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` = 300 order by `headquarters` desc, `contact` desc, `name` asc

2.29ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 300
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(354) 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(354))
)

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

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

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

2.12ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 364
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 `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` = 364 order by `display_order` asc, `field` asc

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

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

1.6ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 126
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(156) 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(156))
)

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

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

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

1.69ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 933
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(13947) 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(13947))
)

92.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/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` = 933 order by `display_order` asc, `field` asc

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

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

1.48ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 612
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(8190) 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(8190))
)

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

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

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

1.51ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 64
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(1915) 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(1915))
)

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

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

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

1.88ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1542
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(21914) 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(21914))
)

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

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

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

1.4ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 853
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(2929) 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(2929))
)

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

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

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

1.49ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 718
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(2940) 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(2940))
)

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

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

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

1.37ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 147
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(186) 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(186))
)

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

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

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

1.5ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1547
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(6832) 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(6832))
)

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

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

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

1.47ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 826
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(10838) 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(10838))
)

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

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

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

1.7ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 313
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 `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` = 313 order by `display_order` asc, `field` asc

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

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

1.52ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1656
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(3556) 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(3556))
)

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

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

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

1.75ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 316
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(1888) 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(1888))
)

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

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

Metadata
Bindings	0. 316
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_members` where `v2_members`.`id` = 126 and `v2_members`.`deleted_at` is null limit 13.09ms/app/Person.php:110buldingdb

Metadata
Bindings	0. 126
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/Person.php:110 21. /app/Person.php:116 22. view::cities.sections.people-events:39 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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

2.27ms/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.33ms/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.23ms/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.89ms/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.16ms/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.11ms/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.16ms/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.07ms/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: 101
App\CtbuhCompany: 16
App\Member: 17
App\Role: 97
App\Person: 120
App\Initiative: 12
App\Building: 233
App\Region: 1
App\Country: 2
App\City: 50

_token: o2PbxOBlxj7yReXaqzfj0VY3yC7DyFPnpC1LWljI
_previous: array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/san-francisco" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/city/san-francisco

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" => "36355"
  "REMOTE_ADDR" => "18.222.112.64"
  "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/san-francisco"
  "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" => 1743923981.9294
  "REQUEST_TIME" => 1743923981
]

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 => "Sun, 06 Apr 2025 07:19:42 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBEelhmWEJIUVdxV3p1UTNMU1FEWlE9PSIsInZhbHVlIjoiZHErYjQxOFNIbHBnQThJRGphOUJtZytxMzVvZ0ZkSXp2TE5SbUpWbmFPaEdTS1lNTktVM21oZEhjVHlPdjNiNHp1N1NMenBPWkVjN2NqUE16UzRQbTF6UFY2YkNKU09vV3ZjUnBtckhmRjlQZXZwdHEyVGNqUjYzVEZXdkhXZDAiLCJtYWMiOiI4MzI5OTRjMzM3ZGY4YjEyYjA5ZjUwZjcxODA0NGMyYjVmNjZkNTRjMzk1MWUwNDZhNTZmMjk0NTQ1ZTEzZGE5In0%3D; expires=Sun, 06-Apr-2025 09:19:44 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBEelhmWEJIUVdxV3p1UTNMU1FEWlE9PSIsInZhbHVlIjoiZHErYjQxOFNIbHBnQThJRGphOUJtZytxMzVvZ0ZkSXp2TE5SbUpWbmFPaEdTS1lNTktVM21oZEhjVHlPdjNiNHp1N1NMe ▶"
    1 => "skyscraper_center_session=eyJpdiI6InVWakF6NXBCQW9BQVwvdkp1MVJ1YnBnPT0iLCJ2YWx1ZSI6IkRFSmxXaWFSQjBMWjUzS2dIaVhFcEFJdUo3SDl4UDlDZWRDWnNvM2d4KzY1dDJ5YVh0a2hYRVwvWXJzajlONWRjVFNEQmh2MlZrQXIwU001K3NGd2h3RVlLNXp0STdcL1RPcFppdHFZZE1uY3JBTEdZeWEyWjNTbElDZ3JKbU9SOFkiLCJtYWMiOiI3NjkwZWMzNWFiZDFlMDExMTkwNDFhMWI2ZjlkYzczZDUyZGQ5MzNhZDk3NDE2MzI3ZGU1MWQ0YjkyMTk2NGYyIn0%3D; expires=Sun, 06-Apr-2025 09:19:44 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InVWakF6NXBCQW9BQVwvdkp1MVJ1YnBnPT0iLCJ2YWx1ZSI6IkRFSmxXaWFSQjBMWjUzS2dIaVhFcEFJdUo3SDl4UDlDZWRDWnNvM2d4KzY1dDJ5YVh0a2hYRVwvWX ▶"
    2 => "visit_counter=eyJpdiI6IlpxcGFTSktseFdVUmo5akc4cWxLelE9PSIsInZhbHVlIjoiTDg5UnpLK1RXWW13MFlnZ0UyaVwvR0Y0bnB2MjQyNXBiWGx0VHMwRXc2WlFObVQ2akdQN05NWFUzRkxGZWZvRXUiLCJtYWMiOiJjY2RlNzA3ZjM1ZjM0NTcxNzc4Y2IxN2Y0MzM2MzY1NWU5ZDFkNjYwZTc0NjAxYjE4M2U2Y2UzODA5NzFiNmY2In0%3D; expires=Tue, 06-May-2025 07:19:41 GMT; Max-Age=2591997; path=/; httponly ◀visit_counter=eyJpdiI6IlpxcGFTSktseFdVUmo5akc4cWxLelE9PSIsInZhbHVlIjoiTDg5UnpLK1RXWW13MFlnZ0UyaVwvR0Y0bnB2MjQyNXBiWGx0VHMwRXc2WlFObVQ2akdQN05NWFUzRkxGZWZvRXUiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBEelhmWEJIUVdxV3p1UTNMU1FEWlE9PSIsInZhbHVlIjoiZHErYjQxOFNIbHBnQThJRGphOUJtZytxMzVvZ0ZkSXp2TE5SbUpWbmFPaEdTS1lNTktVM21oZEhjVHlPdjNiNHp1N1NMenBPWkVjN2NqUE16UzRQbTF6UFY2YkNKU09vV3ZjUnBtckhmRjlQZXZwdHEyVGNqUjYzVEZXdkhXZDAiLCJtYWMiOiI4MzI5OTRjMzM3ZGY4YjEyYjA5ZjUwZjcxODA0NGMyYjVmNjZkNTRjMzk1MWUwNDZhNTZmMjk0NTQ1ZTEzZGE5In0%3D; expires=Sun, 06-Apr-2025 09:19:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBEelhmWEJIUVdxV3p1UTNMU1FEWlE9PSIsInZhbHVlIjoiZHErYjQxOFNIbHBnQThJRGphOUJtZytxMzVvZ0ZkSXp2TE5SbUpWbmFPaEdTS1lNTktVM21oZEhjVHlPdjNiNHp1N1NMe ▶"
    1 => "skyscraper_center_session=eyJpdiI6InVWakF6NXBCQW9BQVwvdkp1MVJ1YnBnPT0iLCJ2YWx1ZSI6IkRFSmxXaWFSQjBMWjUzS2dIaVhFcEFJdUo3SDl4UDlDZWRDWnNvM2d4KzY1dDJ5YVh0a2hYRVwvWXJzajlONWRjVFNEQmh2MlZrQXIwU001K3NGd2h3RVlLNXp0STdcL1RPcFppdHFZZE1uY3JBTEdZeWEyWjNTbElDZ3JKbU9SOFkiLCJtYWMiOiI3NjkwZWMzNWFiZDFlMDExMTkwNDFhMWI2ZjlkYzczZDUyZGQ5MzNhZDk3NDE2MzI3ZGU1MWQ0YjkyMTk2NGYyIn0%3D; expires=Sun, 06-Apr-2025 09:19:44 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InVWakF6NXBCQW9BQVwvdkp1MVJ1YnBnPT0iLCJ2YWx1ZSI6IkRFSmxXaWFSQjBMWjUzS2dIaVhFcEFJdUo3SDl4UDlDZWRDWnNvM2d4KzY1dDJ5YVh0a2hYRVwvWX ▶"
    2 => "visit_counter=eyJpdiI6IlpxcGFTSktseFdVUmo5akc4cWxLelE9PSIsInZhbHVlIjoiTDg5UnpLK1RXWW13MFlnZ0UyaVwvR0Y0bnB2MjQyNXBiWGx0VHMwRXc2WlFObVQ2akdQN05NWFUzRkxGZWZvRXUiLCJtYWMiOiJjY2RlNzA3ZjM1ZjM0NTcxNzc4Y2IxN2Y0MzM2MzY1NWU5ZDFkNjYwZTc0NjAxYjE4M2U2Y2UzODA5NzFiNmY2In0%3D; expires=Tue, 06-May-2025 07:19:41 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IlpxcGFTSktseFdVUmo5akc4cWxLelE9PSIsInZhbHVlIjoiTDg5UnpLK1RXWW13MFlnZ0UyaVwvR0Y0bnB2MjQyNXBiWGx0VHMwRXc2WlFObVQ2akdQN05NWFUzRkxGZWZvRXUiLC ▶"
  ]
]

session_attributes

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

Facts

Rankings

47

7

6

Buildings

Building Completions Timeline

San Francisco CTBUH Members

CTBUH People & Events

Videos

Research

Research

1 x Application (99.05%)	2.50s
1 x Booting (0.95%)	23.93ms

View all results

San Francisco

Facts

Rankings

47

7

6

Buildings

Building Completions Timeline

San Francisco CTBUH Members

CTBUH People & Events

Videos

Research

Research