OFR Consultants - The Skyscraper Center

Rank	Name	City	Completion	Height
1	Vision Apartments	Melbourne	2016	229 m / 751 ft
2	Gravity Tower	Melbourne	2017	98.6 m / 323 ft
3	Flinders Lodge	Melbourne	2016	92 m / 302 ft
4	Adina Grand Hotel	Sydney	2020	89.9 m / 295 ft
5	Iglu South Yarra	Melbourne	-	74.4 m / 244 ft

Rank	Name	City	Completion	Height
1	Vision Apartments	Melbourne	2016	229 m / 751 ft
2	Gravity Tower	Melbourne	2017	99 m / 323 ft
3	Flinders Lodge	Melbourne	2016	92 m / 302 ft
4	Adina Grand Hotel	Sydney	2020	90 m / 295 ft
5	Iglu South Yarra	Melbourne	-	74 m / 244 ft

Messages Timeline Exceptions Views27 Route Queries53 Models128 Mails Gate Session Request

7.3.33592ms10MBGET company/{id}

Booting (11.69ms)
Application (580ms)
1 x Application (98%)
579.66ms
1 x Booting (1.98%)
11.69ms

27 templates were rendered

companies.display-redesign (resources/views/companies/display-redesign.blade.php)32blade


tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel

Params
0	`tabs`
1	`company`
2	`associatedCompanies`
3	`member`
4	`designatedExperts`
5	`memberLevel`
6	`buildings`
7	`buildingsRaw`
8	`buildings_com_uc`
9	`awards`
10	`statuses`
11	`title`
12	`tallest100`
13	`videos`
14	`research`
15	`news`
16	`forPdf`
17	`timelineYears`
18	`minHeight`
19	`maxHeight`
20	`timelineMinYear`
21	`videoCategories`
22	`initiatives`
23	`people`
24	`tallBuildingCounts`
25	`buildingsByFunction`
26	`buildingsByMaterial`
27	`averageAge`
28	`vanityHeights`
29	`constructionData`
30	`allBuildingStatuses`
31	`accessLevel`

companies.partials.display-overview (resources/views/companies/partials/display-overview.blade.php)38blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`

companies.partials.element.displayBuildingImages (resources/views/companies/partials/element/displayBuildingImages.blade.php)44blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`

companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
displayedImg
__currentLoopData
building
loop
fullSizePath

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`displayedImg`
45	`__currentLoopData`
46	`building`
47	`loop`
48	`fullSizePath`

companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
displayedImg
__currentLoopData
building
loop
fullSizePath

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`displayedImg`
45	`__currentLoopData`
46	`building`
47	`loop`
48	`fullSizePath`

companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
displayedImg
__currentLoopData
building
loop
fullSizePath

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`displayedImg`
45	`__currentLoopData`
46	`building`
47	`loop`
48	`fullSizePath`

companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
displayedImg
__currentLoopData
building
loop
fullSizePath

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`displayedImg`
45	`__currentLoopData`
46	`building`
47	`loop`
48	`fullSizePath`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
__currentLoopData
loop
filteredBuildings
header
tableId
maxItems
displayFull

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`__currentLoopData`
45	`loop`
46	`filteredBuildings`
47	`header`
48	`tableId`
49	`maxItems`
50	`displayFull`

companies.partials.element.displayAssociatedCompanies (resources/views/companies/partials/element/displayAssociatedCompanies.blade.php)47blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
__currentLoopData
loop
filteredBuildings

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`__currentLoopData`
45	`loop`
46	`filteredBuildings`

companies.partials.element.displayMobileAssociated (resources/views/companies/partials/element/displayMobileAssociated.blade.php)53blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
__currentLoopData
loop
filteredBuildings
isActiveTab
companies
key
item
panelTitle
type

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`__currentLoopData`
45	`loop`
46	`filteredBuildings`
47	`isActiveTab`
48	`companies`
49	`key`
50	`item`
51	`panelTitle`
52	`type`

companies.partials.element.displayMobileAssociated (resources/views/companies/partials/element/displayMobileAssociated.blade.php)53blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
memberOffices
sep
city
fieldsArray
fieldsOfExpertise
field
__currentLoopData
loop
filteredBuildings
isActiveTab
companies
key
item
panelTitle
type

www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
Params
0
id
1
active
2
slot

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`memberOffices`
39	`sep`
40	`city`
41	`fieldsArray`
42	`fieldsOfExpertise`
43	`field`
44	`__currentLoopData`
45	`loop`
46	`filteredBuildings`
47	`isActiveTab`
48	`companies`
49	`key`
50	`item`
51	`panelTitle`
52	`type`

Params
0	`id`
1	`active`
2	`slot`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
tableId
displayComplexTable
search
columnFilter
paginate
maxItems
displayFull

www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
Params
0
id
1
active
2
slot

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`tableId`
39	`displayComplexTable`
40	`search`
41	`columnFilter`
42	`paginate`
43	`maxItems`
44	`displayFull`

Params
0	`id`
1	`active`
2	`slot`

common-redesign.displayInitiatives (resources/views/common-redesign/displayInitiatives.blade.php)39blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
header

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`header`

companies.partials.element.displayMemberPeople (resources/views/companies/partials/element/displayMemberPeople.blade.php)38blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite

www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
Params
0
id
1
active
2
slot

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`

Params
0	`id`
1	`active`
2	`slot`

layouts.SSC-tabs (resources/views/layouts/SSC-tabs.blade.php)38blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`

www.partials.tab-menu (resources/views/www/partials/tab-menu.blade.php)38blade


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`
39	`nav`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`
39	`nav`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data
nav
__currentLoopData
item
loop
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`
39	`nav`
40	`__currentLoopData`
41	`item`
42	`loop`
43	`child`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`
39	`alreadyConsentedWithCookies`
40	`cookieConsentConfig`

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


obLevel
__env
app
errors
lucky_50
tabs
company
associatedCompanies
member
designatedExperts
memberLevel
buildings
buildingsRaw
buildings_com_uc
awards
statuses
title
tallest100
videos
research
news
forPdf
timelineYears
minHeight
maxHeight
timelineMinYear
videoCategories
initiatives
people
tallBuildingCounts
buildingsByFunction
buildingsByMaterial
averageAge
vanityHeights
constructionData
allBuildingStatuses
accessLevel
companyWebsite
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`tabs`
6	`company`
7	`associatedCompanies`
8	`member`
9	`designatedExperts`
10	`memberLevel`
11	`buildings`
12	`buildingsRaw`
13	`buildings_com_uc`
14	`awards`
15	`statuses`
16	`title`
17	`tallest100`
18	`videos`
19	`research`
20	`news`
21	`forPdf`
22	`timelineYears`
23	`minHeight`
24	`maxHeight`
25	`timelineMinYear`
26	`videoCategories`
27	`initiatives`
28	`people`
29	`tallBuildingCounts`
30	`buildingsByFunction`
31	`buildingsByMaterial`
32	`averageAge`
33	`vanityHeights`
34	`constructionData`
35	`allBuildingStatuses`
36	`accessLevel`
37	`companyWebsite`
38	`data`
39	`alreadyConsentedWithCookies`
40	`cookieConsentConfig`

uri: GET company/{id}
middleware: web
controller: App\Http\Controllers\CtbuhCompanyController@display
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/CtbuhCompanyController.php:27-708

53 statements were executed, 9 of which were duplicated, 44 unique516ms

select * from `ctbuh_company` where `ctbuh_company`.`id` = '21250' limit 117.85ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb

Metadata
Bindings	0. 21250
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	17. /app/Http/Controllers/CtbuhCompanyController.php:33 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

SELECT c1.status, c2.id AS new_id, c2.name AS new_name, c2.status AS new_status, c1.new_company_year FROM ctbuh_company c1 LEFT JOIN ctbuh_company c2 ON c1.new_company = c2.id WHERE c1.id = '21250' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name

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

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/CtbuhCompany.php:138 11. /app/CtbuhCompany.php:223 12. /app/Http/Controllers/CtbuhCompanyController.php:47 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `ctbuh_company` where `ctbuh_company`.`id` = 1941 and `ctbuh_company`.`deleted_at` is null limit 12.17ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

Metadata
Bindings	0. 1941
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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/CtbuhCompany.php:142 19. /app/CtbuhCompany.php:223 20. /app/Http/Controllers/CtbuhCompanyController.php:47 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

SELECT c1.status, c2.id AS new_id, c2.name AS new_name, c2.status AS new_status, c1.new_company_year FROM ctbuh_company c1 LEFT JOIN ctbuh_company c2 ON c1.new_company = c2.id WHERE c1.id = '1941' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name

2.19ms/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/CtbuhCompany.php:138 11. /app/CtbuhCompany.php:143 12. /app/CtbuhCompany.php:223 13. /app/Http/Controllers/CtbuhCompanyController.php:47

SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '21250' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

285ms/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/CtbuhCompany.php:172 11. /app/CtbuhCompany.php:207 12. /app/CtbuhCompany.php:254 13. /app/Http/Controllers/CtbuhCompanyController.php:47

select * from `ctbuh_company` where `ctbuh_company`.`id` = 14890 and `ctbuh_company`.`deleted_at` is null limit 11.32ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

Metadata
Bindings	0. 14890
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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/CtbuhCompany.php:176 19. /app/CtbuhCompany.php:207 20. /app/CtbuhCompany.php:254 21. /app/Http/Controllers/CtbuhCompanyController.php:47

SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '14890' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

73.51ms/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/CtbuhCompany.php:172 11. /app/CtbuhCompany.php:177 12. /app/CtbuhCompany.php:207 13. /app/CtbuhCompany.php:254

select `id` from `ctbuh_company` where `name` = 'OFR Consultants' and `active` = '1'1.46ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. OFR Consultants 1. 1
Backtrace	12. /app/CtbuhCompany.php:305 13. /app/CtbuhCompany.php:318 14. /app/Http/Controllers/CtbuhCompanyController.php:52 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `building_id` from `ctbuh_building_company_new` where `company_id` in (14890, 21250)1.39ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 14890 1. 21250
Backtrace	12. /app/CtbuhCompany.php:328 13. /app/Http/Controllers/CtbuhCompanyController.php:52 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 `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (26097, 13449, 22418, 32758, 22470) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

2.13ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 26097 3. 13449 4. 22418 5. 32758 6. 22470
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/CtbuhCompany.php:336 15. /app/Http/Controllers/CtbuhCompanyController.php:52 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_cities` where `v2_cities`.`id` in (653, 658)1.64ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11)1.28ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11)1.47ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select `v3_images`.*, `v3_building_image`.`building_id` as `pivot_building_id`, `v3_building_image`.`image_id` as `pivot_image_id`, `v3_building_image`.`position` as `pivot_position` from `v3_images` inner join `v3_building_image` on `v3_images`.`id` = `v3_building_image`.`image_id` where `v3_building_image`.`building_id` in (13449, 22418, 22470, 26097, 32758) order by `position` asc

1.61ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

Metadata
Backtrace	18. /app/Http/Controllers/CtbuhCompanyController.php:57 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_resource_categories` where `type` = 'Video'1.24ms/app/Http/Controllers/CtbuhCompanyController.php:59buldingdb

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

select `v2_members`.*, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id`, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id` from `v2_members` inner join `v2_ctbuh_company_member` on `v2_members`.`id` = `v2_ctbuh_company_member`.`member_id` where `v2_ctbuh_company_member`.`ctbuh_company_id` = 21250 and `v2_members`.`deleted_at` is null

1.72ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 21250
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/Http/Controllers/CtbuhCompanyController.php:172 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 `name`, `name_chinese` from `v2_membership_levels` where `id` = 151.18ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdb

Metadata
Bindings	0. 15
Backtrace	12. /app/Http/Controllers/CtbuhCompanyController.php:181 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_awards` where (`building_id` in (13449, 22418, 26097, 22470, 32758) or `company_id` = 21250) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc

2.14ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdb

Metadata
Bindings	0. 13449 1. 22418 2. 26097 3. 22470 4. 32758 5. 21250
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/CtbuhCompanyController.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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 10251.2ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 1025
Backtrace	12. /app/Member.php:184 13. /app/Http/Controllers/CtbuhCompanyController.php:250 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 10251.2ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 1025
Backtrace	12. /app/Member.php:184 13. /app/Http/Controllers/CtbuhCompanyController.php:251 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 10251.41ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 1025
Backtrace	12. /app/Member.php:184 13. /app/Http/Controllers/CtbuhCompanyController.php:260 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 DISTINCT id_building AS building_id FROM ctbuh_building_company
WHERE id_building IN(
13449,22418,26097,22470,32758
)
AND id_company_type IN(13, 11)
AND id_company IN(
21250
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
13449,22418,26097,22470,32758
)
AND category_id IN(1, 2)
AND company_id IN(
21250
)

2.66ms/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/CtbuhCompanyController.php:286 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 `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('21250', 14890)2.42ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdb

Metadata
Bindings	0. 21250 1. 14890
Backtrace	12. /app/Http/Controllers/CtbuhCompanyController.php:306 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('21250', 14890)2.32ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdb

Metadata
Bindings	0. 21250 1. 14890
Backtrace	12. /app/Http/Controllers/CtbuhCompanyController.php:311 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_resources` where `id` in (3001, 3169, 3621, 3449, 3826, 3376, 3391, 3411, 4028) order by `date` desc2.01ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdb

Metadata
Bindings	0. 3001 1. 3169 2. 3621 3. 3449 4. 3826 5. 3376 6. 3391 7. 3411 8. 4028
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/CtbuhCompanyController.php:325 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 * from `v2_cities` where `v2_cities`.`id` in (630, 658, 942, 943, 1539)1.68ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdb

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

select * from `v2_resource_categories` where `type` = 'Video' and `id` = 19 limit 11.4ms/app/Http/Controllers/CtbuhCompanyController.php:366buldingdb

Metadata
Bindings	0. Video 1. 19
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/CtbuhCompanyController.php:366 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 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_initiatives` where `id` in (1246, 1282, 1295, 1311, 1281, 1361, 1377, 1393, 1414, 1399, 1317, 1589) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1745013939) order by `start_date` desc

3.24ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdb

Metadata
Bindings	0. 1246 1. 1282 2. 1295 3. 1311 4. 1281 5. 1361 6. 1377 7. 1393 8. 1414 9. 1399 10. 1317 11. 1589 12. Non-CTBUH 13. Invite 14. 1745013939
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/Http/Controllers/CtbuhCompanyController.php:403 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 * from `v2_cities` where `v2_cities`.`id` in (658, 942, 943, 1026, 1539)1.54ms/app/Http/Controllers/CtbuhCompanyController.php:403buldingdb

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

select * from `v2_people` where `v2_people`.`member_id` = 1025 and `v2_people`.`member_id` is not null3.2ms/app/Http/Controllers/CtbuhCompanyController.php:423buldingdb

Metadata
Bindings	0. 1025
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/CtbuhCompanyController.php:423 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 23. /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 (389, 12827, 12828, 14872, 36338, 36339, 36341, 36342, 36343, 40433) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

6.51ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdb

Metadata
Backtrace	18. /app/Http/Controllers/CtbuhCompanyController.php:426 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `id` from `ctbuh_company` where `name` = 'OFR Consultants' and `active` = '1'9.08ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. OFR Consultants 1. 1
Backtrace	12. /app/CtbuhCompany.php:305 13. /app/CtbuhCompany.php:318 14. /app/Http/Controllers/CtbuhCompanyController.php:498 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `building_id` from `ctbuh_building_company_new` where `company_id` in (14890, 21250, 21250)7.47ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 14890 1. 21250 2. 21250
Backtrace	12. /app/CtbuhCompany.php:328 13. /app/Http/Controllers/CtbuhCompanyController.php:498 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 `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (26097, 13449, 22418, 32758, 22470) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

7.96ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 26097 3. 13449 4. 22418 5. 32758 6. 22470
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/CtbuhCompany.php:336 15. /app/Http/Controllers/CtbuhCompanyController.php:498 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 13449 and `published_at` < '2025-04-18 22:05:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

4.51ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb

Metadata
Bindings	0. 13449 1. 2025-04-18 22:05:39 2. 1
Backtrace	19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625 24. /app/Http/Controllers/CtbuhCompanyController.php:498 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 22418 and `published_at` < '2025-04-18 22:05:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

5.28ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb

Metadata
Bindings	0. 22418 1. 2025-04-18 22:05:39 2. 1
Backtrace	19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625 24. /app/Http/Controllers/CtbuhCompanyController.php:498 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 26097 and `published_at` < '2025-04-18 22:05:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

7.29ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb

Metadata
Bindings	0. 26097 1. 2025-04-18 22:05:39 2. 1
Backtrace	19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625 24. /app/Http/Controllers/CtbuhCompanyController.php:498 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 22470 and `published_at` < '2025-04-18 22:05:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

5.29ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb

Metadata
Bindings	0. 22470 1. 2025-04-18 22:05:39 2. 1
Backtrace	19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625 24. /app/Http/Controllers/CtbuhCompanyController.php:498 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 32758 and `published_at` < '2025-04-18 22:05:39' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

5.52ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb

Metadata
Bindings	0. 32758 1. 2025-04-18 22:05:39 2. 1
Backtrace	19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625 24. /app/Http/Controllers/CtbuhCompanyController.php:498 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

SELECT
ctbuh_building.id,
name_intl,
status,
(height_architecture - height_floor) AS vanity_height,
((height_architecture - height_floor) / height_architecture) AS vanity_height_pct,
floors_above,
completed,
height_architecture,
height_floor
FROM ctbuh_building
WHERE
height_floor != 0 AND
completed > 0 AND
active = 1 AND structure_type IN('building') AND ctbuh_building.id in (13449, 22418, 26097, 22470, 32758) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC

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

Metadata
Hints	The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/CtbuhCompanyController.php:551 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_people` where `v2_people`.`member_id` = 1025 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1

3.67ms/app/Member.php:28buldingdb

Metadata
Bindings	0. 1025 1. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Member.php:28 16. /app/Http/Controllers/CtbuhCompanyController.php:659 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

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

1.62msview::companies.partials.display-overview:17buldingdb

Metadata
Bindings	0. 1025
Backtrace	19. view::companies.partials.display-overview:17 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_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` = 1025 order by `display_order` asc, `field` asc

1.43msview::companies.partials.display-overview:53buldingdb

Metadata
Bindings	0. 1025
Backtrace	19. view::companies.partials.display-overview:53 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `v2_cities` where `v2_cities`.`id` = 943 limit 11.61msview::companies.partials.element.displayMemberPeople:28buldingdb

Metadata
Bindings	0. 943
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. view::companies.partials.element.displayMemberPeople:28 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 25. /vendor/laravel/framework/src/Illuminate/View/View.php:143 26. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null1.33ms/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.38ms/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.39ms/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.43ms/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.4ms/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.25ms/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

2.15ms/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.54ms/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.46ms/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: 1
App\Role: 20
App\Person: 12
App\Initiative: 9
App\Member: 1
App\Image: 19
App\Country: 2
App\City: 14
App\Building: 10
App\CtbuhCompany: 3

_token: sWRvk4I5SaJkMJxKTnQkITItsXPhjnlNf5AbPn9s
_previous: array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/21250" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/company/21250

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" => "61253"
  "REMOTE_ADDR" => "18.191.187.115"
  "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" => "/company/21250"
  "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" => 1745013938.9938
  "REQUEST_TIME" => 1745013938
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 22:05:39 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjBDOEphSUM1WDZmUzJZdHQwZ2YrMnc9PSIsInZhbHVlIjoidUNuVEpSZFBaY0ZaQWRzZEw1K3plUG5OSkR3a0g2SCtMRTZWcUMwZGNlMVpWRUVTRGxpenRVdnlZT1NSZTBPaElNT2lJVnoxZUtmS1BkNW9xeDlaRG1GMU5xa2RHa0VpUWowbkxId0twOERqZFwvWkppbVhNZHhiWnBDNGFMcjlDIiwibWFjIjoiNmRiNjE0YTY5ZjZkYmEyMTMzZTNmZjM5MjcxYjAwOGJjYmUxYWUxYzY3OWFiODIyZTViZWYzYTRiYjdmYzI4MCJ9; expires=Sat, 19-Apr-2025 00:05:39 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBDOEphSUM1WDZmUzJZdHQwZ2YrMnc9PSIsInZhbHVlIjoidUNuVEpSZFBaY0ZaQWRzZEw1K3plUG5OSkR3a0g2SCtMRTZWcUMwZGNlMVpWRUVTRGxpenRVdnlZT1NSZTBPaElNT2lJV ▶"
    1 => "skyscraper_center_session=eyJpdiI6InB0cUFTRnEwV1ltSHlpQ214dTlsRWc9PSIsInZhbHVlIjoiaXBNZE9BY3cydytkVDRTTGR6MlNqS3FrYVFnQVpJVWpYbUdjaUFMam5HYlROZGUxZlo0K3NVMFV4OW5tUFV3TGE0OVFwWkxiSmc5cmFhZ1dwSnI3b2pOUkFXNHEyK2JEUzhEeitsRHNodjlSSEtNQ09UVFExVUM2SVhENGREY28iLCJtYWMiOiIxY2I4MTIyZDZjOGZiYzAwYmEyZTQ1NDllMmEwMjliZjE5ZTEzY2JjYzExMDA2ZTAxOGQ3MWM1ZmUxZTE4MDBmIn0%3D; expires=Sat, 19-Apr-2025 00:05:39 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InB0cUFTRnEwV1ltSHlpQ214dTlsRWc9PSIsInZhbHVlIjoiaXBNZE9BY3cydytkVDRTTGR6MlNqS3FrYVFnQVpJVWpYbUdjaUFMam5HYlROZGUxZlo0K3NVMFV4OW ▶"
    2 => "visit_counter=eyJpdiI6IlNqTENPRkZNS0FhbHJvQTZNTFBkK2c9PSIsInZhbHVlIjoiTUo0eXJkU1wvMEs5SVwva294S09FZlVMcVVPVVlTSlJTS2xHRm1ibDIrbkJzMVY2blRNbnhPQ3F4dzB6ZUtNQlArIiwibWFjIjoiNjk0NDNhMTk2MzY0ZmViYmFlOWJjMzUxMzBlMWYwNTZhOWM5Y2ZkZTIyNDUwMmQzYzVlM2Y3ODA4ODA0MDQ5NyJ9; expires=Sun, 18-May-2025 22:05:39 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IlNqTENPRkZNS0FhbHJvQTZNTFBkK2c9PSIsInZhbHVlIjoiTUo0eXJkU1wvMEs5SVwva294S09FZlVMcVVPVVlTSlJTS2xHRm1ibDIrbkJzMVY2blRNbnhPQ3F4dzB6ZUtNQlArIi ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjBDOEphSUM1WDZmUzJZdHQwZ2YrMnc9PSIsInZhbHVlIjoidUNuVEpSZFBaY0ZaQWRzZEw1K3plUG5OSkR3a0g2SCtMRTZWcUMwZGNlMVpWRUVTRGxpenRVdnlZT1NSZTBPaElNT2lJVnoxZUtmS1BkNW9xeDlaRG1GMU5xa2RHa0VpUWowbkxId0twOERqZFwvWkppbVhNZHhiWnBDNGFMcjlDIiwibWFjIjoiNmRiNjE0YTY5ZjZkYmEyMTMzZTNmZjM5MjcxYjAwOGJjYmUxYWUxYzY3OWFiODIyZTViZWYzYTRiYjdmYzI4MCJ9; expires=Sat, 19-Apr-2025 00:05:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjBDOEphSUM1WDZmUzJZdHQwZ2YrMnc9PSIsInZhbHVlIjoidUNuVEpSZFBaY0ZaQWRzZEw1K3plUG5OSkR3a0g2SCtMRTZWcUMwZGNlMVpWRUVTRGxpenRVdnlZT1NSZTBPaElNT2lJV ▶"
    1 => "skyscraper_center_session=eyJpdiI6InB0cUFTRnEwV1ltSHlpQ214dTlsRWc9PSIsInZhbHVlIjoiaXBNZE9BY3cydytkVDRTTGR6MlNqS3FrYVFnQVpJVWpYbUdjaUFMam5HYlROZGUxZlo0K3NVMFV4OW5tUFV3TGE0OVFwWkxiSmc5cmFhZ1dwSnI3b2pOUkFXNHEyK2JEUzhEeitsRHNodjlSSEtNQ09UVFExVUM2SVhENGREY28iLCJtYWMiOiIxY2I4MTIyZDZjOGZiYzAwYmEyZTQ1NDllMmEwMjliZjE5ZTEzY2JjYzExMDA2ZTAxOGQ3MWM1ZmUxZTE4MDBmIn0%3D; expires=Sat, 19-Apr-2025 00:05:39 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InB0cUFTRnEwV1ltSHlpQ214dTlsRWc9PSIsInZhbHVlIjoiaXBNZE9BY3cydytkVDRTTGR6MlNqS3FrYVFnQVpJVWpYbUdjaUFMam5HYlROZGUxZlo0K3NVMFV4OW ▶"
    2 => "visit_counter=eyJpdiI6IlNqTENPRkZNS0FhbHJvQTZNTFBkK2c9PSIsInZhbHVlIjoiTUo0eXJkU1wvMEs5SVwva294S09FZlVMcVVPVVlTSlJTS2xHRm1ibDIrbkJzMVY2blRNbnhPQ3F4dzB6ZUtNQlArIiwibWFjIjoiNjk0NDNhMTk2MzY0ZmViYmFlOWJjMzUxMzBlMWYwNTZhOWM5Y2ZkZTIyNDUwMmQzYzVlM2Y3ODA4ODA0MDQ5NyJ9; expires=Sun, 18-May-2025 22:05:39 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IlNqTENPRkZNS0FhbHJvQTZNTFBkK2c9PSIsInZhbHVlIjoiTUo0eXJkU1wvMEs5SVwva294S09FZlVMcVVPVVlTSlJTS2xHRm1ibDIrbkJzMVY2blRNbnhPQ3F4dzB6ZUtNQlArIi ▶"
  ]
]

session_attributes

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

CTBUH Silver Member

OFR Consultants Limited

About

Fields of Expertise

Membership details

Buildings

Associated companies

CTBUH Initiatives Involving OFR Consultants

2017 Research Seed Funding Results Released

Future Forty Emerging Technology Hackathon

CTBUH Façade Fire Performance Workshop at University of Sydney

CTBUH Leaders Connect at 2017 Conference

Senior Fire Engineer Wins Research Seed Funding

CTBUH UK: Manchester Urban Housing Debate

CTBUH Releases Initial Statement on Grenfell House Fire in London

Second CAF-CTBUH Event Examines Tall Building Safety

CTBUH UK & ZHA: Tall Towers as Catalysts for Social Interaction

Ctbuh Leaders At OFR Consultants Limited

Simon Lay

1 x Application (98%)	579.66ms
1 x Booting (1.98%)	11.69ms

View all results

CTBUH Silver Member

OFR Consultants Limited

About

Fields of Expertise

Membership details

Buildings

Associated companies

CTBUH Initiatives Involving OFR Consultants

2017 Research Seed Funding Results Released

Future Forty Emerging Technology Hackathon

CTBUH Façade Fire Performance Workshop at University of Sydney

CTBUH Leaders Connect at 2017 Conference

Senior Fire Engineer Wins Research Seed Funding

CTBUH UK: Manchester Urban Housing Debate

CTBUH Releases Initial Statement on Grenfell House Fire in London

Second CAF-CTBUH Event Examines Tall Building Safety

CTBUH UK & ZHA: Tall Towers as Catalysts for Social Interaction

Ctbuh Leaders At OFR Consultants Limited

Simon Lay