Kuala Lumpur

Rank	Name	Height
1	Merdeka PNB118	644 m / 2,113 ft
2	Petronas Twin Tower 2	451.9 m / 1,483 ft
3	The Exchange 106	445.1 m / 1,460 ft
4	Fairmont Kuala Lumpur Tower 1	370 m / 1,214 ft
5	Four Seasons Place	342.5 m / 1,124 ft
6	Oxley Tower 1	341.2 m / 1,119 ft
7	IBN Bukit Bintang	330 m / 1,083 ft
8	M101 Skywheel	316.6 m / 1,039 ft
9	Menara TM	310 m / 1,017 ft
10	Kempinski Hotel & Residences	308 m / 1,010 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
KLCC Property Holdings Berhad	Kuala Lumpur	Gold	6	DEV • FIN • OWN • PROP
PNB Merdeka Ventures SDN Berhad	Kuala Lumpur	Gold	2	DEV • OWN • PROP
Akitek Jururancang Malaysia	Kuala Lumpur	Silver	0	ARCH
Perunding Kos T & K Sdn Bhd	Kuala Lumpur	Silver	7	COST
Selangor Properties Berhad	Kuala Lumpur	Silver	0	DEV

Messages Timeline Exceptions Views23 Route Queries97 Models423 Mails Gate Session Request

7.3.331.31s16MBGET city/{slug}

Booting (13.37ms)
Application (1.3s)
1 x Application (98.97%)
1.30s
1 x Booting (1.02%)
13.37ms

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

97 statements were executed, 41 of which were duplicated, 56 unique1.15s

select * from `v2_cities` where `slug` = 'kuala-lumpur' limit 112.66ms/app/Http/Controllers/CityController.php:29buldingdb

Metadata
Bindings	0. kuala-lumpur
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 (112)1.39ms/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 (7)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 (1118) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

382ms/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 (1118)1.9ms/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 (1118) order by `start_date` desc

2.77ms/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 (658, 795, 803, 1118, 1461, 1539)2.74ms/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 (1118) order by `type` asc, `date` desc

5.29ms/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 (1118)2.79ms/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 (234, 576, 1820, 1844, 2044, 2045, 2048, 2485, 3341, 3654, 3760, 3990, 4025, 4233, 6655, 6690, 6757, 6772, 6976, 7034, 10277, 10872, 17015, 27566, 35751, 35752, 36357, 36487, 36510, 38539, 39797, 40166, 40167, 40503, 40504) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

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

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 1149
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.21ms/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.32ms/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.31ms/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.42ms/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.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.92ms/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.24ms/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.2ms/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.36ms/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.61ms/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.21ms/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` = 45 limit 11.19ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 45
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.4ms/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'2.17ms/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.75ms/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.48ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

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

select * from `v2_resource_categories` where `type` = 'Video'1.15ms/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.47ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

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

select * 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` = 41 limit 11.2ms/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.1ms/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.13ms/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'5.81ms/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 12.05ms/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.4ms/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_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` = 41 limit 11.28ms/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.44ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

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

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

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

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

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

select * 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` = 39 limit 11.24ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 39
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'3.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_subcategories` where `type` = 'Video' and `id` = 36 limit 11.84ms/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.17ms/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` = 35 limit 11.25ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 35
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.09ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

Metadata
Bindings	0. Video 1. 22
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.56ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

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

Metadata
Bindings	0. Video 1. 8
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.09ms/app/Http/Controllers/CityController.php:794buldingdb

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

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

Metadata
Bindings	0. Video 1. 9
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'4.76ms/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.92ms/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` = 1118 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc

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

Metadata
Bindings	0. 1118
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` = 1118 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-07 20:00:30' and `deleted_at` is null order by `published_at` desc

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

Metadata
Bindings	0. 1118 1. 2025-04-07 20:00:30
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` = 112 limit 11.95ms/app/Http/Controllers/Controller.php:423buldingdb

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

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

11.56ms/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 * 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` = 1118 order by `position` asc

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

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

2.17ms/app/Member.php:49buldingdb

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

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

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

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

1.75ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 674
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(4932) 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(4932))
)

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

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

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

7.7ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1649
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(23315) 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(23315))
)

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

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

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

1.57ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1123
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(17233) 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(17233))
)

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

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

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

1.74ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1149
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(17744) 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(17744))
)

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

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

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

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

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

select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 27 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc

1.48ms/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.46ms/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.62ms/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.21ms/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.29ms/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.14ms/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.21ms/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.15ms/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: 51
App\CtbuhCompany: 5
App\Member: 5
App\Role: 22
App\Person: 35
App\Initiative: 16
App\Building: 236
App\Region: 1
App\Country: 2
App\City: 13

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

path_info

/city/kuala-lumpur

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" => "60645"
  "REMOTE_ADDR" => "18.220.129.8"
  "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/kuala-lumpur"
  "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" => 1744056029.7974
  "REQUEST_TIME" => 1744056029
]

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 => "Mon, 07 Apr 2025 20:00:30 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlVOUlpjd0VNSzc5dDZcLzd0azRWTE1nPT0iLCJ2YWx1ZSI6IlhKY2NrXC9TcHA2K080S0M4UXBveElpRzFMeDBqc2k4enFpXC9KOEI2NmswdnlMM2ZYNk9qc0pXQlJUN1hpU2llWUEwQVRFOENZUUlUVUJvWVpSeVJcL0ZCZUpaaXhwXC9kZjhcLytPdms4Vlc0bW1OQnBUem9lbkM0QWFyZzB0SU9GcEciLCJtYWMiOiI4OTY1N2E5YjA5YTY4ZGFjNWNjNGI3MDg3YTMzYzg1MzRiOTcwNGMyZTdmOTRiMzU2YWI2OGI3Njg5MDg3MTAxIn0%3D; expires=Mon, 07-Apr-2025 22:00:31 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlVOUlpjd0VNSzc5dDZcLzd0azRWTE1nPT0iLCJ2YWx1ZSI6IlhKY2NrXC9TcHA2K080S0M4UXBveElpRzFMeDBqc2k4enFpXC9KOEI2NmswdnlMM2ZYNk9qc0pXQlJUN1hpU2llWUEwQ ▶"
    1 => "skyscraper_center_session=eyJpdiI6IjRoQ1ZaTEJEZjNZMTV4QWJXU25cL3ZnPT0iLCJ2YWx1ZSI6ImZZXC85YzRYUnJRVUNxZzRxRUtZaGUzcW5RbHZYcVBVeHlTWXRXdmJsaUpQSkE0SHFEZ3RQQ1wvcjh2YkZ4VnhWYld1XC9jWGowQkRXWm5mRkJcL0Y4R0ZqcmhDYVNHcVhHNlZGREdYQjd2cHBwZHdtdk5KQis5TmtpRHdkNWFvTGJNdyIsIm1hYyI6ImNkNjhhODAxODZiODA0YmM5NDY3YTFjNDRmOTg5MmU5ZWQyZjE2YTNjZmU3MDk4NmRiOGIzNjBjNDc0ZmY5MDQifQ%3D%3D; expires=Mon, 07-Apr-2025 22:00:31 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjRoQ1ZaTEJEZjNZMTV4QWJXU25cL3ZnPT0iLCJ2YWx1ZSI6ImZZXC85YzRYUnJRVUNxZzRxRUtZaGUzcW5RbHZYcVBVeHlTWXRXdmJsaUpQSkE0SHFEZ3RQQ1wvcj ▶"
    2 => "visit_counter=eyJpdiI6InlcL3gyMlI0SUJ5VzR3Tnh1QTU3QVpRPT0iLCJ2YWx1ZSI6IjNpVTFFWFlYcnNRWTFzM0tRNXgySUlxXC9rb0ZnXC9QdHJJM0tQOGVHdVJqdkRseEd2dExGVmVBaVZ1MStWUjk1SiIsIm1hYyI6IjcwNGMwNTM2YjM2NGM0NDczMmNjNWQ2Yjk1ZDAyY2JjZGJkOGYwYWFjYjhmM2E4Yzg3M2RhN2VlMWI0MzBkNWYifQ%3D%3D; expires=Wed, 07-May-2025 20:00:29 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6InlcL3gyMlI0SUJ5VzR3Tnh1QTU3QVpRPT0iLCJ2YWx1ZSI6IjNpVTFFWFlYcnNRWTFzM0tRNXgySUlxXC9rb0ZnXC9QdHJJM0tQOGVHdVJqdkRseEd2dExGVmVBaVZ1MStWUjk1Si ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlVOUlpjd0VNSzc5dDZcLzd0azRWTE1nPT0iLCJ2YWx1ZSI6IlhKY2NrXC9TcHA2K080S0M4UXBveElpRzFMeDBqc2k4enFpXC9KOEI2NmswdnlMM2ZYNk9qc0pXQlJUN1hpU2llWUEwQVRFOENZUUlUVUJvWVpSeVJcL0ZCZUpaaXhwXC9kZjhcLytPdms4Vlc0bW1OQnBUem9lbkM0QWFyZzB0SU9GcEciLCJtYWMiOiI4OTY1N2E5YjA5YTY4ZGFjNWNjNGI3MDg3YTMzYzg1MzRiOTcwNGMyZTdmOTRiMzU2YWI2OGI3Njg5MDg3MTAxIn0%3D; expires=Mon, 07-Apr-2025 22:00:31 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlVOUlpjd0VNSzc5dDZcLzd0azRWTE1nPT0iLCJ2YWx1ZSI6IlhKY2NrXC9TcHA2K080S0M4UXBveElpRzFMeDBqc2k4enFpXC9KOEI2NmswdnlMM2ZYNk9qc0pXQlJUN1hpU2llWUEwQ ▶"
    1 => "skyscraper_center_session=eyJpdiI6IjRoQ1ZaTEJEZjNZMTV4QWJXU25cL3ZnPT0iLCJ2YWx1ZSI6ImZZXC85YzRYUnJRVUNxZzRxRUtZaGUzcW5RbHZYcVBVeHlTWXRXdmJsaUpQSkE0SHFEZ3RQQ1wvcjh2YkZ4VnhWYld1XC9jWGowQkRXWm5mRkJcL0Y4R0ZqcmhDYVNHcVhHNlZGREdYQjd2cHBwZHdtdk5KQis5TmtpRHdkNWFvTGJNdyIsIm1hYyI6ImNkNjhhODAxODZiODA0YmM5NDY3YTFjNDRmOTg5MmU5ZWQyZjE2YTNjZmU3MDk4NmRiOGIzNjBjNDc0ZmY5MDQifQ%3D%3D; expires=Mon, 07-Apr-2025 22:00:31 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjRoQ1ZaTEJEZjNZMTV4QWJXU25cL3ZnPT0iLCJ2YWx1ZSI6ImZZXC85YzRYUnJRVUNxZzRxRUtZaGUzcW5RbHZYcVBVeHlTWXRXdmJsaUpQSkE0SHFEZ3RQQ1wvcj ▶"
    2 => "visit_counter=eyJpdiI6InlcL3gyMlI0SUJ5VzR3Tnh1QTU3QVpRPT0iLCJ2YWx1ZSI6IjNpVTFFWFlYcnNRWTFzM0tRNXgySUlxXC9rb0ZnXC9QdHJJM0tQOGVHdVJqdkRseEd2dExGVmVBaVZ1MStWUjk1SiIsIm1hYyI6IjcwNGMwNTM2YjM2NGM0NDczMmNjNWQ2Yjk1ZDAyY2JjZGJkOGYwYWFjYjhmM2E4Yzg3M2RhN2VlMWI0MzBkNWYifQ%3D%3D; expires=Wed, 07-May-2025 20:00:29 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InlcL3gyMlI0SUJ5VzR3Tnh1QTU3QVpRPT0iLCJ2YWx1ZSI6IjNpVTFFWFlYcnNRWTFzM0tRNXgySUlxXC9rb0ZnXC9QdHJJM0tQOGVHdVJqdkRseEd2dExGVmVBaVZ1MStWUjk1Si ▶"
  ]
]

session_attributes

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

Facts

Rankings

15

12

1

Buildings

Building Completions Timeline

Kuala Lumpur CTBUH Members

CTBUH People & Events

Videos

Research

Research

1 x Application (98.97%)	1.30s
1 x Booting (1.02%)	13.37ms

View all results

Kuala Lumpur

Facts

Rankings

15

12

1

Buildings

Building Completions Timeline

Kuala Lumpur CTBUH Members

CTBUH People & Events

Videos

Research

Research