Sun Hung Kai (A&E) Ltd.

Rank	Name	City	Completion	Height
1	Century Gateway 1	Hong Kong	2014	158 m / 517 ft
2	Century Gateway 5	Hong Kong	2014	157 m / 516 ft
3	Century Gateway 2	Hong Kong	2014	153 m / 502 ft
4	Century Gateway 6	Hong Kong	2014	151 m / 496 ft
5	Century Gateway 3	Hong Kong	2014	147 m / 483 ft
6	Century Gateway 7	Hong Kong	2014	145 m / 477 ft
7	Century Gateway 8	Hong Kong	2014	139 m / 457 ft

Messages Timeline Exceptions Views12 Route Queries27 Models54 Mails Gate Session Request

7.3.33324ms8MBGET company/{id}

Booting (10.68ms)
Application (313ms)
1 x Application (96.66%)
312.92ms
1 x Booting (3.3%)
10.68ms

12 templates were rendered

companies.partials.display-non-member (resources/views/companies/partials/display-non-member.blade.php)8blade
Params
0
company
1
parentMember
2
associatedCompanies
3
buildings
4
statuses
5
title
6
allBuildingStatuses
7
accessLevel

Params
0	`company`
1	`parentMember`
2	`associatedCompanies`
3	`buildings`
4	`statuses`
5	`title`
6	`allBuildingStatuses`
7	`accessLevel`

companies.partials.element.nonMemberItems (resources/views/companies/partials/element/nonMemberItems.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
tableId
paginate
search
displayComplexTable
maxItems
displayFull

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`tableId`
18	`paginate`
19	`search`
20	`displayComplexTable`
21	`maxItems`
22	`displayFull`

layouts.SSC-standard (resources/views/layouts/SSC-standard.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav
item
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`
19	`item`
20	`child`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

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


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`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

27 statements were executed, 6 of which were duplicated, 21 unique277ms

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

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

1.41ms/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` = 539 and `ctbuh_company`.`deleted_at` is null limit 11.33ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

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

1.24ms/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 = '9303' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

80.55ms/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 = '9303' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

99.95ms/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` = 'Sun Hung Kai (A&E) Ltd.' and `active` = '1'6.58ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Sun Hung Kai (A&E) Ltd. 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 (9303, 9303)4.48ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 9303 1. 9303
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 (17482, 17477, 17471, 17478, 17479, 17480, 17481) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

6.79ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 17482 3. 17477 4. 17471 5. 17478 6. 17479 7. 17480 8. 17481
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)6.5ms/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.51ms/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)9.4ms/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 (17471, 17477, 17478, 17479, 17480, 17481, 17482) order by `position` asc

7.03ms/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'7.06ms/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` = 9303 and `v2_members`.`deleted_at` is null

8.03ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 9303
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 * from `ctbuh_company` where `ctbuh_company`.`id` = 539 and `ctbuh_company`.`deleted_at` is null limit 17.18ms/app/CtbuhCompany.php:287buldingdb

Metadata
Bindings	0. 539
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/CtbuhCompany.php:287 21. /app/Http/Controllers/CtbuhCompanyController.php:696 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

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` = 539 and `v2_members`.`deleted_at` is null

4.25ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 539
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/CtbuhCompany.php:96 21. /app/CtbuhCompany.php:288 22. /app/Http/Controllers/CtbuhCompanyController.php:696 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `v2_membership_levels` where `v2_membership_levels`.`id` = 13 limit 12.21msview::companies.partials.display-non-member:14buldingdb

Metadata
Bindings	0. 13
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. view::companies.partials.display-non-member:14 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 24. /vendor/laravel/framework/src/Illuminate/View/View.php:143 25. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null1.81ms/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.72ms/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.67ms/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.35ms/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.24ms/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.48ms/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.42ms/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\MembershipLevel: 1
App\Member: 1
App\Image: 2
App\Country: 2
App\City: 1
App\Building: 7
App\CtbuhCompany: 3

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

path_info

/company/9303

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▶
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9oT2Yxb1pmZ3oyZ3ZEKzNFT2M4T1E9PSIsInZhbHVlIjoiXC9jNDJPU3Y1TDYwZUFua3pWTFdEWDB2M2FaRks1dmJSMGtwV3RrTHdyME5xUGlWZWwyeTFmMGpMU0o5MysxZmlWdnZuT3ZUQnF5QlVCb1JwMTBwNDZCcXNNZXJsZHhkeVNpRFVvXC9xd1hhQWtvd2FsZXlSNytEMUNtUm1VMjRJNCIsIm1hYyI6ImU5ODRkNmZiYzZjOWM1OTM2NDk5ZTU4ODg0ZTJjZWU4OGZiOTQxMGM2MGE1MzVlMjBjYjFjY2RkYzQ1NjcxZTcifQ%3D%3D; skyscraper_center_session=eyJpdiI6IklNZDg1RmJuOWFzeUZXWndSRThrSUE9PSIsInZhbHVlIjoiOUhQRXVONzVjZnViWEtRMWlBZEFcL1wvMGRYdGtBOFwvNktxZm9PY0MxVnRzdHJyN0hkQm9XTk9WNkQweFF2R0pLd0NJdFphdE5hVEN4OVBNN1pCdmxnSzVLTWpPWnluSENQWDY4RDEyblVYeHBIRXhBR1ptMTFFNmNIVkpyZFMwUFwvIiwibWFjIjoiZWI5MDIwMGNlZWIwZjU1MWE5YmFhMTcwOGY1NWMyNDBiOWNiNjIzZWI5OWU4YzcwMzc5ZWZjM2E0YmM2OTY1MCJ9; visit_counter=eyJpdiI6IjJSTjZwNlc0UElQOVFjSWl5QkNhcEE9PSIsInZhbHVlIjoid1ZQa21wdFNaZDdIbXhzdEhienRNNUtIcVBSWlplNWpEaXJjMlNrS1pEWk85dldaWFhBZDRFZEM2dTJ5MU1cL3AiLCJtYWMiOiIwYTg5ZmU4MmUxMTk3NjQzNjYxN2MxMWFlOGM5ZjY2N2FjYjg4YTlhYTk1MzJhOTRjOGVjOGUyNTAxYjQ3MTI1In0%3D ◀XSRF-TOKEN=eyJpdiI6Im9oT2Yxb1pmZ3oyZ3ZEKzNFT2M4T1E9PSIsInZhbHVlIjoiXC9jNDJPU3Y1TDYwZUFua3pWTFdEWDB2M2FaRks1dmJSMGtwV3RrTHdyME5xUGlWZWwyeTFmMGpMU0o5MysxZmlWdnZuT ▶"
  ]
  "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:41 [▶
  "USER" => "forge"
  "HOME" => "/home/forge"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6Im9oT2Yxb1pmZ3oyZ3ZEKzNFT2M4T1E9PSIsInZhbHVlIjoiXC9jNDJPU3Y1TDYwZUFua3pWTFdEWDB2M2FaRks1dmJSMGtwV3RrTHdyME5xUGlWZWwyeTFmMGpMU0o5MysxZmlWdnZuT3ZUQnF5QlVCb1JwMTBwNDZCcXNNZXJsZHhkeVNpRFVvXC9xd1hhQWtvd2FsZXlSNytEMUNtUm1VMjRJNCIsIm1hYyI6ImU5ODRkNmZiYzZjOWM1OTM2NDk5ZTU4ODg0ZTJjZWU4OGZiOTQxMGM2MGE1MzVlMjBjYjFjY2RkYzQ1NjcxZTcifQ%3D%3D; skyscraper_center_session=eyJpdiI6IklNZDg1RmJuOWFzeUZXWndSRThrSUE9PSIsInZhbHVlIjoiOUhQRXVONzVjZnViWEtRMWlBZEFcL1wvMGRYdGtBOFwvNktxZm9PY0MxVnRzdHJyN0hkQm9XTk9WNkQweFF2R0pLd0NJdFphdE5hVEN4OVBNN1pCdmxnSzVLTWpPWnluSENQWDY4RDEyblVYeHBIRXhBR1ptMTFFNmNIVkpyZFMwUFwvIiwibWFjIjoiZWI5MDIwMGNlZWIwZjU1MWE5YmFhMTcwOGY1NWMyNDBiOWNiNjIzZWI5OWU4YzcwMzc5ZWZjM2E0YmM2OTY1MCJ9; visit_counter=eyJpdiI6IjJSTjZwNlc0UElQOVFjSWl5QkNhcEE9PSIsInZhbHVlIjoid1ZQa21wdFNaZDdIbXhzdEhienRNNUtIcVBSWlplNWpEaXJjMlNrS1pEWk85dldaWFhBZDRFZEM2dTJ5MU1cL3AiLCJtYWMiOiIwYTg5ZmU4MmUxMTk3NjQzNjYxN2MxMWFlOGM5ZjY2N2FjYjg4YTlhYTk1MzJhOTRjOGVjOGUyNTAxYjQ3MTI1In0%3D ◀XSRF-TOKEN=eyJpdiI6Im9oT2Yxb1pmZ3oyZ3ZEKzNFT2M4T1E9PSIsInZhbHVlIjoiXC9jNDJPU3Y1TDYwZUFua3pWTFdEWDB2M2FaRks1dmJSMGtwV3RrTHdyME5xUGlWZWwyeTFmMGpMU0o5MysxZmlWdnZuT ▶"
  "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" => "19664"
  "REMOTE_ADDR" => "3.22.71.103"
  "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/9303"
  "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" => 1744761374.2006
  "REQUEST_TIME" => 1744761374
]

request_cookies

  0 of 0   
array:3 [▶
  "XSRF-TOKEN" => "P6Ek7CHmhSGbgtGLRhDsiHVEoBhZzSJCe9ej87xB"
  "skyscraper_center_session" => "BPau8DrgVy6TWuBG4kQqYnCTXTBkwvYmCah9kgTU"
  "visit_counter" => "2"
]

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 => "Tue, 15 Apr 2025 23:56:14 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InEyb2dtY0dFb0gyMEZ1b2dRYzM5NHc9PSIsInZhbHVlIjoibEp6ajBJVVo0algrOFwvWTRsN0NIZDJ0WUM3dTROcUxRb3FDT3paYWRSTkFiKzNqelBFbkoyNHBnQmlKVGhPaVlHVjJ1QVk1dkNHRzliTVwvQXZQUDVoODN3ZzRYWll1ZmRSc0VVUStUSEpSeTRycXQrZWYzQlwvVjFrVGFqVlR2cHYiLCJtYWMiOiI4OTk2ZWM2NjU0MzA0MjFjYjZhZjAyNDFlYjM5ZTY1MDY1ZGM0NDgyY2MzMTViOTJjNDYwMjY0OTA4MWNkOWMwIn0%3D; expires=Wed, 16-Apr-2025 01:56:14 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InEyb2dtY0dFb0gyMEZ1b2dRYzM5NHc9PSIsInZhbHVlIjoibEp6ajBJVVo0algrOFwvWTRsN0NIZDJ0WUM3dTROcUxRb3FDT3paYWRSTkFiKzNqelBFbkoyNHBnQmlKVGhPaVlHVjJ1Q ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkFZVjd1dktoaHRzdjhIRzRpK1lcLzdBPT0iLCJ2YWx1ZSI6IlwvVEV4RVwvUzU0Rm93aU54N1hwbm4ya0JnQzl5cUJhc1I0Y05WQzNlb0pZVXJCUnZDSjU1NHF3UGlCdm1vS1ZIWVl4SXBNQmUxY3EyRU40c2RQOTZNZlU0ZU9DVEFVMzhXcDFOY05lTHRBR3ZNVkNoaVdxb2x6TU9VUWNUVHZPckMiLCJtYWMiOiJkNDVlNTViMmU4NDRiOGVhNGZlYjg2MWMzNDRhMzA3YjJmYTNiZTdkODRkNGNhNzJkNDUzZDNlZWYyMmEyNGUzIn0%3D; expires=Wed, 16-Apr-2025 01:56:14 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkFZVjd1dktoaHRzdjhIRzRpK1lcLzdBPT0iLCJ2YWx1ZSI6IlwvVEV4RVwvUzU0Rm93aU54N1hwbm4ya0JnQzl5cUJhc1I0Y05WQzNlb0pZVXJCUnZDSjU1NHF3UG ▶"
    2 => "visit_counter=eyJpdiI6IjlWcm5ER2piS1NLdVRqc3hVUmpRZEE9PSIsInZhbHVlIjoidFdLeURKXC9yNDdPTVFpN2hJcTE5Nmp2MkJzTFNzUTM1M1FVZUpQNUNabDhFelJiVE1rN0hQOEIxUnJHVEU2UFIiLCJtYWMiOiI2OWQ0MWY1MTVhN2E3NTUzMzI2ZWQxMjM3OTJiMTMzNDljMTY2MTRiMmJlZmRiMjI3MTFiMmE1YzhmYzQwYzhhIn0%3D; expires=Thu, 15-May-2025 23:56:14 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IjlWcm5ER2piS1NLdVRqc3hVUmpRZEE9PSIsInZhbHVlIjoidFdLeURKXC9yNDdPTVFpN2hJcTE5Nmp2MkJzTFNzUTM1M1FVZUpQNUNabDhFelJiVE1rN0hQOEIxUnJHVEU2UFIiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InEyb2dtY0dFb0gyMEZ1b2dRYzM5NHc9PSIsInZhbHVlIjoibEp6ajBJVVo0algrOFwvWTRsN0NIZDJ0WUM3dTROcUxRb3FDT3paYWRSTkFiKzNqelBFbkoyNHBnQmlKVGhPaVlHVjJ1QVk1dkNHRzliTVwvQXZQUDVoODN3ZzRYWll1ZmRSc0VVUStUSEpSeTRycXQrZWYzQlwvVjFrVGFqVlR2cHYiLCJtYWMiOiI4OTk2ZWM2NjU0MzA0MjFjYjZhZjAyNDFlYjM5ZTY1MDY1ZGM0NDgyY2MzMTViOTJjNDYwMjY0OTA4MWNkOWMwIn0%3D; expires=Wed, 16-Apr-2025 01:56:14 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InEyb2dtY0dFb0gyMEZ1b2dRYzM5NHc9PSIsInZhbHVlIjoibEp6ajBJVVo0algrOFwvWTRsN0NIZDJ0WUM3dTROcUxRb3FDT3paYWRSTkFiKzNqelBFbkoyNHBnQmlKVGhPaVlHVjJ1Q ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkFZVjd1dktoaHRzdjhIRzRpK1lcLzdBPT0iLCJ2YWx1ZSI6IlwvVEV4RVwvUzU0Rm93aU54N1hwbm4ya0JnQzl5cUJhc1I0Y05WQzNlb0pZVXJCUnZDSjU1NHF3UGlCdm1vS1ZIWVl4SXBNQmUxY3EyRU40c2RQOTZNZlU0ZU9DVEFVMzhXcDFOY05lTHRBR3ZNVkNoaVdxb2x6TU9VUWNUVHZPckMiLCJtYWMiOiJkNDVlNTViMmU4NDRiOGVhNGZlYjg2MWMzNDRhMzA3YjJmYTNiZTdkODRkNGNhNzJkNDUzZDNlZWYyMmEyNGUzIn0%3D; expires=Wed, 16-Apr-2025 01:56:14 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkFZVjd1dktoaHRzdjhIRzRpK1lcLzdBPT0iLCJ2YWx1ZSI6IlwvVEV4RVwvUzU0Rm93aU54N1hwbm4ya0JnQzl5cUJhc1I0Y05WQzNlb0pZVXJCUnZDSjU1NHF3UG ▶"
    2 => "visit_counter=eyJpdiI6IjlWcm5ER2piS1NLdVRqc3hVUmpRZEE9PSIsInZhbHVlIjoidFdLeURKXC9yNDdPTVFpN2hJcTE5Nmp2MkJzTFNzUTM1M1FVZUpQNUNabDhFelJiVE1rN0hQOEIxUnJHVEU2UFIiLCJtYWMiOiI2OWQ0MWY1MTVhN2E3NTUzMzI2ZWQxMjM3OTJiMTMzNDljMTY2MTRiMmJlZmRiMjI3MTFiMmE1YzhmYzQwYzhhIn0%3D; expires=Thu, 15-May-2025 23:56:14 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjlWcm5ER2piS1NLdVRqc3hVUmpRZEE9PSIsInZhbHVlIjoidFdLeURKXC9yNDdPTVFpN2hJcTE5Nmp2MkJzTFNzUTM1M1FVZUpQNUNabDhFelJiVE1rN0hQOEIxUnJHVEU2UFIiLC ▶"
  ]
]

session_attributes

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

Sun Hung Kai Properties Limited is a member of the CTBUH at the Platinum level.

Subsidiary of:

Sun Hung Kai Properties Limited

Buildings

1 x Application (96.66%)	312.92ms
1 x Booting (3.3%)	10.68ms

View all results