The Wharf (Holdings) Limited

Subsidiary companies:

Suzhou Gao Long Property Development Co., Ltd. | Wharf China Development Limited

Buildings

Rank	Name	City	Completion	Height
1	Changsha IFS Tower T1	Changsha	2018	452 m / 1,483 ft
2	Suzhou IFS	Suzhou	2019	450 m / 1,476 ft
3	Gateway III, Kowloon	Hong Kong	-	405 m / 1,329 ft
4	Wuxi International Finance Square	Wuxi	2014	339 m / 1,112 ft
5	Chongqing IFS T1	Chongqing	2016	316 m / 1,038 ft
6	Changsha IFS Tower T2	Changsha	2018	308 m / 1,010 ft
7	International Commerce Center Tower 1	Chengdu	2021	280 m / 919 ft
7	International Commerce Center Tower 2	Chengdu	-	280 m / 919 ft
9	Shanghai Wheelock Square	Shanghai	2010	271 m / 887 ft
10	Sorrento 1	Hong Kong	2003	256 m / 841 ft
11	Chengdu International Finance Square Tower 1	Chengdu	2014	247 m / 810 ft
11	Chengdu International Finance Square Tower 2	Chengdu	2014	247 m / 810 ft
13	Sorrento 2	Hong Kong	2003	236 m / 773 ft
14	Sorrento 3	Hong Kong	2003	218 m / 715 ft
15	Sorrento 5	Hong Kong	2003	212 m / 696 ft
16	Wuhan Times Square Tower 1	Wuhan	2007	208 m / 682 ft
17	Sorrento 6	Hong Kong	2003	206 m / 676 ft
18	Bellagio Tower 1-5	Hong Kong	2005	206 m / 676 ft
19	Bellagio Tower 6-9	Hong Kong	2002	198 m / 650 ft
20	Chengdu International Finance Square Tower 4	Chengdu	2015	198 m / 650 ft
21	NatWest Tower, Times Square	Hong Kong	1993	194 m / 636 ft
22	Chengdu International Finance Square Tower 3	Chengdu	2015	188 m / 617 ft
23	Tianfu Times Tower 1	Chengdu	2010	172 m / 564 ft
23	Tianfu Times Tower 8	Chengdu	2010	172 m / 564 ft
25	Chongqing IFS T2	Chongqing	2015	171 m / 562 ft
26	Chongqing IFS T6	Chongqing	2015	170 m / 558 ft
27	Shell Tower, Times Square	Hong Kong	1993	169 m / 554 ft
28	Galaxia Tower 2	Hong Kong	1998	158 m / 519 ft
28	Galaxia Tower 3	Hong Kong	1998	158 m / 519 ft
28	Galaxia Tower 5	Hong Kong	1998	158 m / 519 ft
31	Galaxia Tower 1	Hong Kong	1998	155 m / 509 ft
31	Galaxia Tower 6	Hong Kong	1998	155 m / 509 ft
33	Chongqing IFS T3	Chongqing	2015	105 m / 344 ft
33	Chongqing IFS T5	Chongqing	2015	105 m / 344 ft

Buildings per page:

Messages Timeline Exceptions Views12 Route Queries25 Models306 Mails Gate Session Request

7.3.33330ms9MBGET company/{id}

Booting (12.85ms)
Application (317ms)
1 x Application (96.08%)
316.96ms
1 x Booting (3.9%)
12.85ms

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

25 statements were executed, 2 of which were duplicated, 23 unique260ms

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

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

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

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

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/CtbuhCompany.php:172 11. /app/CtbuhCompany.php:207 12. /app/CtbuhCompany.php:254 13. /app/Http/Controllers/CtbuhCompanyController.php:47

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

Metadata
Bindings	0. 20624
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/CtbuhCompany.php:176 19. /app/CtbuhCompany.php:207 20. /app/CtbuhCompany.php:254 21. /app/Http/Controllers/CtbuhCompanyController.php:47

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

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

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/CtbuhCompany.php:172 11. /app/CtbuhCompany.php:177 12. /app/CtbuhCompany.php:207 13. /app/CtbuhCompany.php:254

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

Metadata
Bindings	0. 24651
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/CtbuhCompany.php:176 19. /app/CtbuhCompany.php:207 20. /app/CtbuhCompany.php:254 21. /app/Http/Controllers/CtbuhCompanyController.php:47

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

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

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/CtbuhCompany.php:172 11. /app/CtbuhCompany.php:177 12. /app/CtbuhCompany.php:207 13. /app/CtbuhCompany.php:254

select `id` from `ctbuh_company` where `name` = 'The Wharf (Holdings) Limited' and `active` = '1'1.84ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. The Wharf (Holdings) Limited 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 (20624, 24651, 562)5.07ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 20624 1. 24651 2. 562
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 (9252, 9253, 9254, 9255, 1870, 15426, 15426, 16843, 16843, 16844, 16844, 15427, 15427, 9252, 9253, 9254, 9255, 542, 542, 13516, 13516, 18477, 18478, 356, 356, 1406, 1406, 1284, 1284, 1041, 1041, 800, 800, 1560, 1560, 5216, 11087, 15662, 1507, 3640, 3441, 3442, 3443, 3641, 1746, 2822, 214, 13145, 13145, 196, 196, 13144, 13144, 13145, 13145, 196) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

2.97ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 9252 3. 9253 4. 9254 5. 9255 6. 1870 7. 15426 8. 15426 9. 16843 10. 16843 11. 16844 12. 16844 13. 15427 14. 15427 15. 9252 16. 9253 17. 9254 18. 9255 19. 542 20. 542 21. 13516 22. 13516 23. 18477 24. 18478 25. 356 26. 356 27. 1406 28. 1406 29. 1284 30. 1284 31. 1041 32. 1041 33. 800 34. 800 35. 1560 36. 1560 37. 5216 38. 11087 39. 15662 40. 1507 41. 3640 42. 3441 43. 3442 44. 3443 45. 3641 46. 1746 47. 2822 48. 214 49. 13145 50. 13145 51. 196 52. 196 53. 13144 54. 13144 55. 13145 56. 13145 57. 196
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 (750, 751, 752, 766, 795, 802, 813, 814)1.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.19ms/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.35ms/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 (196, 214, 356, 542, 800, 1041, 1284, 1406, 1507, 1560, 1746, 1870, 2822, 3441, 3442, 3443, 3640, 3641, 5216, 9252, 9253, 9254, 9255, 11087, 13144, 13145, 13516, 15426, 15427, 15662, 16843, 16844, 18477, 18478) order by `position` asc

5.22ms/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.3ms/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` = 562 and `v2_members`.`deleted_at` is null

2.29ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 562
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 `nav_menu_items` where `parent_id` is null5.2ms/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

7.12ms/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.28ms/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.21ms/app/NavMenuItem.php:110buldingdb

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

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

1.21ms/app/NavMenuItem.php:110buldingdb

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

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

1.2ms/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.22ms/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.39ms/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.25ms/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\Image: 222
App\Country: 2
App\City: 8
App\Building: 34
App\CtbuhCompany: 3

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

path_info

/company/562

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" => "15512"
  "REMOTE_ADDR" => "3.128.188.223"
  "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/562"
  "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" => 1744983056.0239
  "REQUEST_TIME" => 1744983056
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 13:30:56 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InptakxidkxzdG9ZWkFRR2FYTDJta0E9PSIsInZhbHVlIjoiU3BzMmhPTGsrZ1NiVzhhcG80aVhCZUFLc2R4Rm5wODV5NmorXC9vUGZBNE8wb1pkSjJQK28zTStWWDRiS1ZjNUE5aUVNSTc4MklTZjJoV0J1NlZwVWtXUm45XC8yOGNSa3p3aktXMEYwQk5qT3hISTBKTldmbHlFRHZPcnJsSGJteiIsIm1hYyI6ImM2MDFmZjliMzQxODlhNGRmNzUxNDEwMDJjYmViNDgyMzNkODg2MjI2Yjc4ZmRlNjE3YTU0NTE1NjU3YzliYmUifQ%3D%3D; expires=Fri, 18-Apr-2025 15:30:56 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InptakxidkxzdG9ZWkFRR2FYTDJta0E9PSIsInZhbHVlIjoiU3BzMmhPTGsrZ1NiVzhhcG80aVhCZUFLc2R4Rm5wODV5NmorXC9vUGZBNE8wb1pkSjJQK28zTStWWDRiS1ZjNUE5aUVNS ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlQxQlNqUXZWbjU2TzdUSnhBOFZla2c9PSIsInZhbHVlIjoiNXhcL256UVNsRlJqRjZKUUxGbDJWQ210VDZBaG13RXVNaElkZXlHWUd6Q3R2MGhcLzNkV24rRWJcL3I3UW9uVktQT3MrQjhTbHhYQ0Z5UEhvR0NaU3d2dnlSZ2J1ZmhRQnltQ2RZMkNVdWZSdmhoMzFYQkZkbHFPanlvTXRMTEF1cmEiLCJtYWMiOiJjNzRhNGY5MGU2OTVmNjA5ZjYzNThmYTU4YTA5ZTE2Y2I1MDRmZDJhMDIwYWY0NmE0YTEwZGVhYjc1ZGEyOTI3In0%3D; expires=Fri, 18-Apr-2025 15:30:56 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlQxQlNqUXZWbjU2TzdUSnhBOFZla2c9PSIsInZhbHVlIjoiNXhcL256UVNsRlJqRjZKUUxGbDJWQ210VDZBaG13RXVNaElkZXlHWUd6Q3R2MGhcLzNkV24rRWJcL3 ▶"
    2 => "visit_counter=eyJpdiI6Iks2dlRLXC8yaG5FTm8xd2QzUFZkbWdBPT0iLCJ2YWx1ZSI6IlRPaTVMT0I4RVo0cVZwdGlMWUE0ZGI4NTRCdFwvbVFDWkhzdXZPeTVIR0Q3VTczV3pOZXJPRnB5RWhwZGMzN2NQIiwibWFjIjoiNzEyMWU5NTFkZmExYWRjY2ZkYWNiMmE1MDk5MzA4MTBkZDJiNTVjZmE1ZTVhNGM0MzkyMjNiZjQ2MDIyYmI5YyJ9; expires=Sun, 18-May-2025 13:30:56 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6Iks2dlRLXC8yaG5FTm8xd2QzUFZkbWdBPT0iLCJ2YWx1ZSI6IlRPaTVMT0I4RVo0cVZwdGlMWUE0ZGI4NTRCdFwvbVFDWkhzdXZPeTVIR0Q3VTczV3pOZXJPRnB5RWhwZGMzN2NQIi ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InptakxidkxzdG9ZWkFRR2FYTDJta0E9PSIsInZhbHVlIjoiU3BzMmhPTGsrZ1NiVzhhcG80aVhCZUFLc2R4Rm5wODV5NmorXC9vUGZBNE8wb1pkSjJQK28zTStWWDRiS1ZjNUE5aUVNSTc4MklTZjJoV0J1NlZwVWtXUm45XC8yOGNSa3p3aktXMEYwQk5qT3hISTBKTldmbHlFRHZPcnJsSGJteiIsIm1hYyI6ImM2MDFmZjliMzQxODlhNGRmNzUxNDEwMDJjYmViNDgyMzNkODg2MjI2Yjc4ZmRlNjE3YTU0NTE1NjU3YzliYmUifQ%3D%3D; expires=Fri, 18-Apr-2025 15:30:56 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InptakxidkxzdG9ZWkFRR2FYTDJta0E9PSIsInZhbHVlIjoiU3BzMmhPTGsrZ1NiVzhhcG80aVhCZUFLc2R4Rm5wODV5NmorXC9vUGZBNE8wb1pkSjJQK28zTStWWDRiS1ZjNUE5aUVNS ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlQxQlNqUXZWbjU2TzdUSnhBOFZla2c9PSIsInZhbHVlIjoiNXhcL256UVNsRlJqRjZKUUxGbDJWQ210VDZBaG13RXVNaElkZXlHWUd6Q3R2MGhcLzNkV24rRWJcL3I3UW9uVktQT3MrQjhTbHhYQ0Z5UEhvR0NaU3d2dnlSZ2J1ZmhRQnltQ2RZMkNVdWZSdmhoMzFYQkZkbHFPanlvTXRMTEF1cmEiLCJtYWMiOiJjNzRhNGY5MGU2OTVmNjA5ZjYzNThmYTU4YTA5ZTE2Y2I1MDRmZDJhMDIwYWY0NmE0YTEwZGVhYjc1ZGEyOTI3In0%3D; expires=Fri, 18-Apr-2025 15:30:56 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlQxQlNqUXZWbjU2TzdUSnhBOFZla2c9PSIsInZhbHVlIjoiNXhcL256UVNsRlJqRjZKUUxGbDJWQ210VDZBaG13RXVNaElkZXlHWUd6Q3R2MGhcLzNkV24rRWJcL3 ▶"
    2 => "visit_counter=eyJpdiI6Iks2dlRLXC8yaG5FTm8xd2QzUFZkbWdBPT0iLCJ2YWx1ZSI6IlRPaTVMT0I4RVo0cVZwdGlMWUE0ZGI4NTRCdFwvbVFDWkhzdXZPeTVIR0Q3VTczV3pOZXJPRnB5RWhwZGMzN2NQIiwibWFjIjoiNzEyMWU5NTFkZmExYWRjY2ZkYWNiMmE1MDk5MzA4MTBkZDJiNTVjZmE1ZTVhNGM0MzkyMjNiZjQ2MDIyYmI5YyJ9; expires=Sun, 18-May-2025 13:30:56 GMT; path=/; httponly ◀visit_counter=eyJpdiI6Iks2dlRLXC8yaG5FTm8xd2QzUFZkbWdBPT0iLCJ2YWx1ZSI6IlRPaTVMT0I4RVo0cVZwdGlMWUE0ZGI4NTRCdFwvbVFDWkhzdXZPeTVIR0Q3VTczV3pOZXJPRnB5RWhwZGMzN2NQIi ▶"
  ]
]

session_attributes

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

1 x Application (96.08%)	316.96ms
1 x Booting (3.9%)	12.85ms

View all results