Shui On Construction & Materials - The Skyscraper Center

Rank	Name	Height
1	J.W. Marriott and The Upper House	164.5 m / 540 ft
2	One Pacific Place	161.8 m / 531 ft
3	Manulife Tower	150 m / 492 ft
4	Yau Lai Estate Cheuk Lai House	128.8 m / 423 ft
5	Yau Lai Estate Yung Lai House	128.8 m / 423 ft
6	Shui On Centre	118.5 m / 389 ft
7	ICAC Headquarters Building	83 m / 272 ft
8	The Jockey Club Innovation Tower	71.2 m / 234 ft

Rank	Name	City	Completion	Height
1	J.W. Marriott and The Upper House	Hong Kong	1988	165 m / 540 ft
2	One Pacific Place	Hong Kong	1988	162 m / 531 ft
3	Manulife Tower	Hong Kong	1990	150 m / 492 ft
4	Yau Lai Estate Cheuk Lai House	Hong Kong	2011	129 m / 423 ft
4	Yau Lai Estate Yung Lai House	Hong Kong	2011	129 m / 423 ft
6	Shui On Centre	Hong Kong	1987	119 m / 389 ft
7	ICAC Headquarters Building	Hong Kong	2007	83 m / 272 ft
8	The Jockey Club Innovation Tower	Hong Kong	2013	71 m / 234 ft

Messages Timeline Exceptions Views28 Route Queries54 Models101 Mails Gate Session Request

7.3.33492ms9MBGET company/{id}

Booting (13.58ms)
Application (478ms)
1 x Application (97.21%)
478.26ms
1 x Booting (2.76%)
13.58ms

28 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.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.display-awards (resources/views/companies/partials/element/display-awards.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.overview-leaders (resources/views/companies/partials/element/overview-leaders.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.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

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`

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

54 statements were executed, 11 of which were duplicated, 43 unique420ms

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

Metadata
Bindings	0. 2905
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 = '2905' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name

1.96ms/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 id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '2905' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

178ms/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 id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '2905' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

130ms/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/Http/Controllers/CtbuhCompanyController.php:48 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select `id` from `ctbuh_company` where `name` = 'Shui On Construction & Materials' and `active` = '1'2.65ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Shui On Construction & Materials 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 (2905, 2905)1.17ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 2905 1. 2905
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 (15985, 17724, 17786, 3222, 3100, 15355, 15354, 3993) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

1.99ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 15985 3. 17724 4. 17786 5. 3222 6. 3100 7. 15355 8. 15354 9. 3993
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 (766)1.28ms/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 (34)1.23ms/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 (34)1.25ms/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 (3100, 3222, 3993, 15354, 15355, 15985, 17724, 17786) order by `position` asc

2.59ms/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.29ms/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` = 2905 and `v2_members`.`deleted_at` is null

2.79ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 2905
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 (3100, 3222, 3993, 15355, 15354, 17786, 17724, 15985) or `company_id` = 2905) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc

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

Metadata
Bindings	0. 3100 1. 3222 2. 3993 3. 15355 4. 15354 5. 17786 6. 17724 7. 15985 8. 2905
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 * from `ctbuh_building` where `ctbuh_building`.`id` in (15985) and `ctbuh_building`.`deleted_at` is null1.77ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

Metadata
Bindings	0. 15985
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/Http/Controllers/CtbuhCompanyController.php:213 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

select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 8171.24ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 817
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` = 8171.09ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 817
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` = 8171.07ms/app/Member.php:184buldingdb

Metadata
Bindings	0. 817
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(
3100,3222,3993,15355,15354,17786,17724,15985
)
AND id_company_type IN(13, 11)
AND id_company IN(
2905, 3108
)
UNION DISTINCT
SELECT DISTINCT building_id FROM ctbuh_building_company_new
WHERE building_id IN(
3100,3222,3993,15355,15354,17786,17724,15985
)
AND category_id IN(1, 2)
AND company_id IN(
2905, 3108
)

8.49ms/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_building_resource` where `building_id` in (3993, 17786)1.3ms/app/Http/Controllers/CtbuhCompanyController.php:297buldingdb

Metadata
Bindings	0. 3993 1. 17786
Backtrace	12. /app/Http/Controllers/CtbuhCompanyController.php:297 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 `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('2905', '3108')1.73ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdb

Metadata
Bindings	0. 2905 1. 3108
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 ('2905', '3108')1.33ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdb

Metadata
Bindings	0. 2905 1. 3108
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 (3244, 2880) order by `date` desc2ms/app/Http/Controllers/CtbuhCompanyController.php:325buldingdb

Metadata
Bindings	0. 3244 1. 2880
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 (795)1.18ms/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_initiatives` where `id` in (1120, 453) and `status` != 'Non-CTBUH' and `deleted_at` is null and (`status` != 'Invite' or `start_date` > 1744574754) order by `start_date` desc

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

Metadata
Bindings	0. 1120 1. 453 2. Non-CTBUH 3. Invite 4. 1744574754
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 (1539)1.21ms/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` = 817 and `v2_people`.`member_id` is not null6.73ms/app/Http/Controllers/CtbuhCompanyController.php:423buldingdb

Metadata
Bindings	0. 817
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 (3131, 9086, 19600, 22642, 22673, 28597, 28598, 31428, 36858) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

1.67ms/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` = 'Shui On Construction & Materials' and `active` = '1'1.18ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Shui On Construction & Materials 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 (2905, 2905, 2905)1.12ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 2905 1. 2905 2. 2905
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 (15985, 17724, 17786, 3222, 3100, 15355, 15354, 3993) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

2.03ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 15985 3. 17724 4. 17786 5. 3222 6. 3100 7. 15355 8. 15354 9. 3993
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` = 3100 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 3100 1. 2025-04-13 20:05:54 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` = 3222 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 3222 1. 2025-04-13 20:05:54 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` = 3993 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 3993 1. 2025-04-13 20:05:54 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` = 15355 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 15355 1. 2025-04-13 20:05:54 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` = 15354 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 15354 1. 2025-04-13 20:05:54 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` = 17786 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 17786 1. 2025-04-13 20:05:54 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` = 17724 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 17724 1. 2025-04-13 20:05:54 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` = 15985 and `published_at` < '2025-04-13 20:05:54' and `deleted_at` is null and `featured` = 1 order by `published_at` desc

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

Metadata
Bindings	0. 15985 1. 2025-04-13 20:05:54 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 (3100, 3222, 3993, 15355, 15354, 17786, 17724, 15985) AND height_architecture > 0
HAVING vanity_height != 0
ORDER BY vanity_height_pct DESC

2.45ms/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` = 817 and `v2_people`.`member_id` is not null and `is_designated_expert` = 1

2.3ms/app/Member.php:28buldingdb

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

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

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

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

Metadata
Bindings	0. 817
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` = 795 limit 11.38msview::companies.partials.element.overview-leaders:23buldingdb

Metadata
Bindings	0. 795
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.overview-leaders:23 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.46ms/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.43ms/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.22ms/app/NavMenuItem.php:97buldingdb

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

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

1.25ms/app/NavMenuItem.php:110buldingdb

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

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

3.46ms/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.37ms/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.25ms/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.19ms/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.35ms/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: 2
App\Role: 5
App\Person: 10
App\Initiative: 2
App\Award: 1
App\Member: 1
App\Image: 17
App\Country: 2
App\City: 6
App\Building: 17
App\CtbuhCompany: 1

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

path_info

/company/2905

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" => "32022"
  "REMOTE_ADDR" => "3.16.78.138"
  "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/2905"
  "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" => 1744574754.1038
  "REQUEST_TIME" => 1744574754
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 13 Apr 2025 20:05:54 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjIwdmcxK2NJN1RRZGFSTllYbW5sUGc9PSIsInZhbHVlIjoidjdGSGVjNEhyYlJ2Ujg3aHFEVnF1bXRZd0R6R09cLzVJVGptNWlxQjdIV3pkWHJMNTk5ZzhiZ3h1ZU5hQXZXSTZiZXE5NENSUlwvMmhITzRNR1ppc2krd2pPb2NMS3Z2SGJyWVJidTErSkpFcnFRdExEcGVsVFZqd2tSclpBRmpzNSIsIm1hYyI6IjAwZGQ3OGRmNWRlZGFjYTAwZTY3ZTY3OTJhZDE3NTdmYTM1OThhZTlhOWQwMGQ5NjE0NWU3NjIzZmRlOTcwZWQifQ%3D%3D; expires=Sun, 13-Apr-2025 22:05:54 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjIwdmcxK2NJN1RRZGFSTllYbW5sUGc9PSIsInZhbHVlIjoidjdGSGVjNEhyYlJ2Ujg3aHFEVnF1bXRZd0R6R09cLzVJVGptNWlxQjdIV3pkWHJMNTk5ZzhiZ3h1ZU5hQXZXSTZiZXE5N ▶"
    1 => "skyscraper_center_session=eyJpdiI6IjU2cUFyT0hSdXVGQTBNWUx3dGYzTnc9PSIsInZhbHVlIjoiSGlwSExQaE5ZblZnNXh2dkppakVcL0lmV0txUndXQVE5YStrUERoTlQwUFJqU1dXZEtMbHBKK3BxRHpNbDYwOWtTZ2pkUzUzREpUR3FIMUxpcWI5eTRXSDJwNVBPbSs0ZzlibTRzRWFyWXpRekJDdCtEMlRcL244Ymd0TWF4a1RVZyIsIm1hYyI6IjZhOGY3ZmRhOTdiYjJhMzMyMjkyMjg3MGI1YjMxODVkOWIwZDMyYjRmOGRhN2UwOGY0NDk1ZDc5ODk1M2RlMDIifQ%3D%3D; expires=Sun, 13-Apr-2025 22:05:54 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjU2cUFyT0hSdXVGQTBNWUx3dGYzTnc9PSIsInZhbHVlIjoiSGlwSExQaE5ZblZnNXh2dkppakVcL0lmV0txUndXQVE5YStrUERoTlQwUFJqU1dXZEtMbHBKK3BxRH ▶"
    2 => "visit_counter=eyJpdiI6InV4VklvbWlaaVk3QVllbWtQemlxdVE9PSIsInZhbHVlIjoiUlZDWEJPcDVYdTdLSThuOUoyRFlWTFlPVnpneG50dkRWNFQ0Mk03MVE5TlhwWmprMHhabFwvcEhVcSttMVJGR0QiLCJtYWMiOiIyNTI4MDVjNDVjZjFkNTE3ZDY1M2Y0NDhkZTcyYTM0YzJhNDU1MWNiZjgxOTlkMDVlNzg1NmM2YWYyZDJlODA2In0%3D; expires=Tue, 13-May-2025 20:05:54 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6InV4VklvbWlaaVk3QVllbWtQemlxdVE9PSIsInZhbHVlIjoiUlZDWEJPcDVYdTdLSThuOUoyRFlWTFlPVnpneG50dkRWNFQ0Mk03MVE5TlhwWmprMHhabFwvcEhVcSttMVJGR0QiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjIwdmcxK2NJN1RRZGFSTllYbW5sUGc9PSIsInZhbHVlIjoidjdGSGVjNEhyYlJ2Ujg3aHFEVnF1bXRZd0R6R09cLzVJVGptNWlxQjdIV3pkWHJMNTk5ZzhiZ3h1ZU5hQXZXSTZiZXE5NENSUlwvMmhITzRNR1ppc2krd2pPb2NMS3Z2SGJyWVJidTErSkpFcnFRdExEcGVsVFZqd2tSclpBRmpzNSIsIm1hYyI6IjAwZGQ3OGRmNWRlZGFjYTAwZTY3ZTY3OTJhZDE3NTdmYTM1OThhZTlhOWQwMGQ5NjE0NWU3NjIzZmRlOTcwZWQifQ%3D%3D; expires=Sun, 13-Apr-2025 22:05:54 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjIwdmcxK2NJN1RRZGFSTllYbW5sUGc9PSIsInZhbHVlIjoidjdGSGVjNEhyYlJ2Ujg3aHFEVnF1bXRZd0R6R09cLzVJVGptNWlxQjdIV3pkWHJMNTk5ZzhiZ3h1ZU5hQXZXSTZiZXE5N ▶"
    1 => "skyscraper_center_session=eyJpdiI6IjU2cUFyT0hSdXVGQTBNWUx3dGYzTnc9PSIsInZhbHVlIjoiSGlwSExQaE5ZblZnNXh2dkppakVcL0lmV0txUndXQVE5YStrUERoTlQwUFJqU1dXZEtMbHBKK3BxRHpNbDYwOWtTZ2pkUzUzREpUR3FIMUxpcWI5eTRXSDJwNVBPbSs0ZzlibTRzRWFyWXpRekJDdCtEMlRcL244Ymd0TWF4a1RVZyIsIm1hYyI6IjZhOGY3ZmRhOTdiYjJhMzMyMjkyMjg3MGI1YjMxODVkOWIwZDMyYjRmOGRhN2UwOGY0NDk1ZDc5ODk1M2RlMDIifQ%3D%3D; expires=Sun, 13-Apr-2025 22:05:54 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IjU2cUFyT0hSdXVGQTBNWUx3dGYzTnc9PSIsInZhbHVlIjoiSGlwSExQaE5ZblZnNXh2dkppakVcL0lmV0txUndXQVE5YStrUERoTlQwUFJqU1dXZEtMbHBKK3BxRH ▶"
    2 => "visit_counter=eyJpdiI6InV4VklvbWlaaVk3QVllbWtQemlxdVE9PSIsInZhbHVlIjoiUlZDWEJPcDVYdTdLSThuOUoyRFlWTFlPVnpneG50dkRWNFQ0Mk03MVE5TlhwWmprMHhabFwvcEhVcSttMVJGR0QiLCJtYWMiOiIyNTI4MDVjNDVjZjFkNTE3ZDY1M2Y0NDhkZTcyYTM0YzJhNDU1MWNiZjgxOTlkMDVlNzg1NmM2YWYyZDJlODA2In0%3D; expires=Tue, 13-May-2025 20:05:54 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InV4VklvbWlaaVk3QVllbWtQemlxdVE9PSIsInZhbHVlIjoiUlZDWEJPcDVYdTdLSThuOUoyRFlWTFlPVnpneG50dkRWNFQ0Mk03MVE5TlhwWmprMHhabFwvcEhVcSttMVJGR0QiLC ▶"
  ]
]

session_attributes

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

CTBUH Silver Member

Shui On Management Limited

About

Fields of Expertise

Membership details

Buildings

Awards

Ctbuh Leaders

CTBUH Initiatives Involving Shui On Construction & Materials

Top Company Rankings: The World’s 100 Tallest Buildings

Whirlwind Tour Stirs Up More Interest in Shanghai Conference

Ctbuh Leaders At Shui On Management Limited

Albert Chan

1 x Application (97.21%)	478.26ms
1 x Booting (2.76%)	13.58ms

View all results

CTBUH Silver Member

Shui On Management Limited

About

Fields of Expertise

Membership details

Buildings

Awards

Ctbuh Leaders

CTBUH Initiatives Involving Shui On Construction & Materials

Top Company Rankings: The World’s 100 Tallest Buildings

Whirlwind Tour Stirs Up More Interest in Shanghai Conference

Ctbuh Leaders At Shui On Management Limited

Albert Chan