Richard Rogers Partnership

Rank	Name	City	Completion	Height
1	Transbay Transit Center and Tower	San Francisco	-	391 m / 1,283 ft
2	Chongqing Centre T1	Chongqing	-	388 m / 1,273 ft
3	Parc1 Tower A	Seoul	2020	338 m / 1,109 ft
4	Chongqing Centre T4	Chongqing	-	291 m / 955 ft
5	Parc1 Tower B	Seoul	2020	261 m / 855 ft
6	Riverside South, South Tower	London	-	236 m / 773 ft
7	Heron Quays West	London	-	198 m / 649 ft
8	Nippon Television Tower	Tokyo	2003	193 m / 633 ft
9	Chongqing Centre T2	Chongqing	2020	187 m / 614 ft
9	Chongqing Centre T3	Chongqing	2020	187 m / 614 ft
9	Chongqing Centre T5	Chongqing	-	187 m / 614 ft
12	Riverside South, North Tower	London	-	186 m / 610 ft
13	Silvercup West II	New York City	-	179 m / 587 ft
14	SBS Broadcasting Center	Seoul	2003	167 m / 548 ft
15	Silvercup West I	New York City	-	160 m / 525 ft
16	Grand Union Building	London	-	158 m / 518 ft
17	Silvercup West III	New York City	-	154 m / 505 ft
18	La Muratella	Rome	-	150 m / 492 ft
19	Hesperia Tower	L'Hospitalet de Llobregat	2006	105 m / 344 ft
20	The Lloyd's Building	London	1986	95 m / 312 ft

Messages Timeline Exceptions Views12 Route Queries27 Models158 Mails Gate Session Request

7.3.33230ms8MBGET company/{id}

Booting (10.16ms)
Application (220ms)
1 x Application (95.54%)
219.69ms
1 x Booting (4.42%)
10.16ms

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 unique180ms

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

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

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

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

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

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

65.1ms/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` = 'Richard Rogers Partnership' and `active` = '1'2.75ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Richard Rogers Partnership 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 (329, 329)2.34ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 329 1. 329
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 (672, 3293, 2380, 3709, 1889, 18307, 18308, 18309, 18310, 18311, 2935, 4059, 5010, 366, 2023, 1042, 1374, 3109, 243, 9575) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

2.49ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 672 3. 3293 4. 2380 5. 3709 6. 1889 7. 18307 8. 18308 9. 18309 10. 18310 11. 18311 12. 2935 13. 4059 14. 5010 15. 366 16. 2023 17. 1042 18. 1374 19. 3109 20. 243 21. 9575
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, 900, 942, 1024, 1049, 1072, 1641, 1683)1.42ms/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, 51, 56, 79, 82, 85, 163)2.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, 51, 56, 79, 82, 85, 163)3.1ms/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 (243, 366, 672, 1042, 1374, 1889, 2023, 2380, 2935, 3109, 3293, 3709, 4059, 5010, 9575, 18307, 18308, 18309, 18310, 18311) order by `position` asc

3.66ms/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.31ms/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` = 329 and `v2_members`.`deleted_at` is null

2.67ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 329
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` = 335 and `ctbuh_company`.`deleted_at` is null limit 11.38ms/app/CtbuhCompany.php:287buldingdb

Metadata
Bindings	0. 335
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` = 335 and `v2_members`.`deleted_at` is null

1.84ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 335
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` = 15 limit 11.35msview::companies.partials.display-non-member:14buldingdb

Metadata
Bindings	0. 15
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.33ms/app/NavMenuItem.php:17buldingdb

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

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

1.56ms/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.27ms/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.44ms/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.58ms/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.39ms/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.42ms/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.31ms/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.37ms/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: 74
App\Country: 14
App\City: 8
App\Building: 20
App\CtbuhCompany: 3

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

path_info

/company/329

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=eyJpdiI6Im4rXC9WcTdmNWF4amRuMG9hajlVcjVnPT0iLCJ2YWx1ZSI6IlwvNzZHNFU2NWlQRlZoNFwvWTk5YzZwOFREUkw3cDFBVXYwMVhYVkRcL1AxdEw2OTVOZzVKNzNcL2FZSWR5WVwvaDBqcFRwcGdvU1wvV3Q0cjBacVN4Y3ZtTU9sYnBRWVJ5UzA4UEZ6S1REU0RmTHM2R0FRSkQ0ZlFka004UHg0bXFRT2NSIiwibWFjIjoiNGZmYTdjNDRjOWMxMTc2ZmQ1MWY1YWYyNzAwMjc2M2IyOGZmNDhkM2MxZDBhODBhZGM5YzlkNThlNmJmN2M1MiJ9; skyscraper_center_session=eyJpdiI6Im5JR01NbEFPNmpxZFwvRjh1V01ncnVnPT0iLCJ2YWx1ZSI6Ik16ZnRlUWFXMktPaFROeFRhQmJnUGN1VGVYSWlkT09FdEFJWE9cLzlcL1Z3cUZXNUhTNVwvaCtTN1BvZFdUVjczM1g3NVBZWHZQamtWR0xiTms3QUJjRVU0XC9LNENaaHFKWTRZUnRVMktUdTBIdG13UEU3RFlOdXhiZXBhdWRKem1oWSIsIm1hYyI6IjRkOTAxMjIwZWE0MGMyNzcwN2M1M2ExNTQ3YzNjY2QwMWZiNmQ5ZjM5M2U3ZGQ2Njk5N2U1ODZkZGViOTM3OTUifQ%3D%3D; visit_counter=eyJpdiI6IjVZVUQ0cFIwVVhTZ3BjNW1pSHpUOEE9PSIsInZhbHVlIjoiU3FaTTMwMXEwcXNaM1JOK2VZalwvK1UyaURMZE1mUFI0QTBGXC9cL2xQc1VJb2tnWjFBRUxzTUFmUHJsdGluU1BpUiIsIm1hYyI6IjEwNzFjNmU0YWFhZThkN2Y0MGVhMDFjYjdlNTZkNTg0OTJlNzQ3NDYxOTU4MzAxNGI2YmJlNGIxYTczY2QyMmUifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6Im4rXC9WcTdmNWF4amRuMG9hajlVcjVnPT0iLCJ2YWx1ZSI6IlwvNzZHNFU2NWlQRlZoNFwvWTk5YzZwOFREUkw3cDFBVXYwMVhYVkRcL1AxdEw2OTVOZzVKNzNcL2FZSWR5WVwvaDBqc ▶"
  ]
  "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=eyJpdiI6Im4rXC9WcTdmNWF4amRuMG9hajlVcjVnPT0iLCJ2YWx1ZSI6IlwvNzZHNFU2NWlQRlZoNFwvWTk5YzZwOFREUkw3cDFBVXYwMVhYVkRcL1AxdEw2OTVOZzVKNzNcL2FZSWR5WVwvaDBqcFRwcGdvU1wvV3Q0cjBacVN4Y3ZtTU9sYnBRWVJ5UzA4UEZ6S1REU0RmTHM2R0FRSkQ0ZlFka004UHg0bXFRT2NSIiwibWFjIjoiNGZmYTdjNDRjOWMxMTc2ZmQ1MWY1YWYyNzAwMjc2M2IyOGZmNDhkM2MxZDBhODBhZGM5YzlkNThlNmJmN2M1MiJ9; skyscraper_center_session=eyJpdiI6Im5JR01NbEFPNmpxZFwvRjh1V01ncnVnPT0iLCJ2YWx1ZSI6Ik16ZnRlUWFXMktPaFROeFRhQmJnUGN1VGVYSWlkT09FdEFJWE9cLzlcL1Z3cUZXNUhTNVwvaCtTN1BvZFdUVjczM1g3NVBZWHZQamtWR0xiTms3QUJjRVU0XC9LNENaaHFKWTRZUnRVMktUdTBIdG13UEU3RFlOdXhiZXBhdWRKem1oWSIsIm1hYyI6IjRkOTAxMjIwZWE0MGMyNzcwN2M1M2ExNTQ3YzNjY2QwMWZiNmQ5ZjM5M2U3ZGQ2Njk5N2U1ODZkZGViOTM3OTUifQ%3D%3D; visit_counter=eyJpdiI6IjVZVUQ0cFIwVVhTZ3BjNW1pSHpUOEE9PSIsInZhbHVlIjoiU3FaTTMwMXEwcXNaM1JOK2VZalwvK1UyaURMZE1mUFI0QTBGXC9cL2xQc1VJb2tnWjFBRUxzTUFmUHJsdGluU1BpUiIsIm1hYyI6IjEwNzFjNmU0YWFhZThkN2Y0MGVhMDFjYjdlNTZkNTg0OTJlNzQ3NDYxOTU4MzAxNGI2YmJlNGIxYTczY2QyMmUifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6Im4rXC9WcTdmNWF4amRuMG9hajlVcjVnPT0iLCJ2YWx1ZSI6IlwvNzZHNFU2NWlQRlZoNFwvWTk5YzZwOFREUkw3cDFBVXYwMVhYVkRcL1AxdEw2OTVOZzVKNzNcL2FZSWR5WVwvaDBqc ▶"
  "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" => "44642"
  "REMOTE_ADDR" => "18.218.183.7"
  "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/329"
  "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" => 1744760659.5027
  "REQUEST_TIME" => 1744760659
]

request_cookies

  0 of 0   
array:3 [▶
  "XSRF-TOKEN" => "sw42Hjt8riPHerpAQGxMzciMtsnALAiAifP10t7F"
  "skyscraper_center_session" => "q1u2YzGJxGa9kkxswzEo2DTYmzQCdl8j5vZ7dg4u"
  "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:44:19 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9Wa1NheFI1SktrdEhaXC80K2NPKzZ3PT0iLCJ2YWx1ZSI6Im8yOHZ4aGZLdXEzZlZzTmFnQnEzYXlxcFdkWDJhK20yYUJoa0hXbDVYRUxxVHZlUitJN0tzS1hxNDFubjBQM3F4R2p3YUtXQ3FYMXI0VDVQeW9Ob0QxRFdPVUVzSEwwamdXcmR5YlVFcWplYXJKNzN6WGFKWWczeUUzd1lkU0MzIiwibWFjIjoiNjNkYjk3NTQ0ZjhlZTI0MTg5ZmRmYmQzNjEzNWJkNzQ4YjcwZGJmYzEzM2NjZjc1ZDZmZDQ1ZjQxOTM1OTRhZSJ9; expires=Wed, 16-Apr-2025 01:44:19 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9Wa1NheFI1SktrdEhaXC80K2NPKzZ3PT0iLCJ2YWx1ZSI6Im8yOHZ4aGZLdXEzZlZzTmFnQnEzYXlxcFdkWDJhK20yYUJoa0hXbDVYRUxxVHZlUitJN0tzS1hxNDFubjBQM3F4R2p3Y ▶"
    1 => "skyscraper_center_session=eyJpdiI6Im9hbnpmT0lCZ0RJaExZNXlkWkdmQ2c9PSIsInZhbHVlIjoiV2VzcGI2UVJPTU5sazIrSERKT2RzZ1BsTlJ0dmdcL3BUYTUyNWRKbENXSmVlQ3JcL1RMdlE1d3hWSjArcUd2enVJbFwvXC9meWJcLzY3RnYxcHJzQXdpSk05RGk2VXNna2pzSE5qckludmgrOWloMnNVRWlwS1p4T1EwXC9aRDhGaTNhUk4iLCJtYWMiOiI0MWJiMWM5YjE0MzY1Yjc4MWJjMmVjYTVhMWI3YTgxYTRmZThmMTI5ZDZjNTExMzNlYWQwOTcwYjUzZTUzMTlkIn0%3D; expires=Wed, 16-Apr-2025 01:44:19 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Im9hbnpmT0lCZ0RJaExZNXlkWkdmQ2c9PSIsInZhbHVlIjoiV2VzcGI2UVJPTU5sazIrSERKT2RzZ1BsTlJ0dmdcL3BUYTUyNWRKbENXSmVlQ3JcL1RMdlE1d3hWSj ▶"
    2 => "visit_counter=eyJpdiI6IisyUnVYQndUY0xVK0JyQWJBUVh1Mnc9PSIsInZhbHVlIjoidGZZTmVhT20xTUJQdUp4YnY4OGRaT0VDeFJYQTcxY3NheUpHV0NMZ3lPS096OTBLamFtOUxJbEQ0K1BKXC9CV1wvIiwibWFjIjoiYmE2MDFlY2IwZTIzODA0Y2QxMmQzYTQ5YzI2YzBiMWRlODI1YjM1NjA3ZWI3Nzk4NzcxYzEzMDk2NjZmM2MxYiJ9; expires=Thu, 15-May-2025 23:44:19 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IisyUnVYQndUY0xVK0JyQWJBUVh1Mnc9PSIsInZhbHVlIjoidGZZTmVhT20xTUJQdUp4YnY4OGRaT0VDeFJYQTcxY3NheUpHV0NMZ3lPS096OTBLamFtOUxJbEQ0K1BKXC9CV1wvIi ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ik9Wa1NheFI1SktrdEhaXC80K2NPKzZ3PT0iLCJ2YWx1ZSI6Im8yOHZ4aGZLdXEzZlZzTmFnQnEzYXlxcFdkWDJhK20yYUJoa0hXbDVYRUxxVHZlUitJN0tzS1hxNDFubjBQM3F4R2p3YUtXQ3FYMXI0VDVQeW9Ob0QxRFdPVUVzSEwwamdXcmR5YlVFcWplYXJKNzN6WGFKWWczeUUzd1lkU0MzIiwibWFjIjoiNjNkYjk3NTQ0ZjhlZTI0MTg5ZmRmYmQzNjEzNWJkNzQ4YjcwZGJmYzEzM2NjZjc1ZDZmZDQ1ZjQxOTM1OTRhZSJ9; expires=Wed, 16-Apr-2025 01:44:19 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9Wa1NheFI1SktrdEhaXC80K2NPKzZ3PT0iLCJ2YWx1ZSI6Im8yOHZ4aGZLdXEzZlZzTmFnQnEzYXlxcFdkWDJhK20yYUJoa0hXbDVYRUxxVHZlUitJN0tzS1hxNDFubjBQM3F4R2p3Y ▶"
    1 => "skyscraper_center_session=eyJpdiI6Im9hbnpmT0lCZ0RJaExZNXlkWkdmQ2c9PSIsInZhbHVlIjoiV2VzcGI2UVJPTU5sazIrSERKT2RzZ1BsTlJ0dmdcL3BUYTUyNWRKbENXSmVlQ3JcL1RMdlE1d3hWSjArcUd2enVJbFwvXC9meWJcLzY3RnYxcHJzQXdpSk05RGk2VXNna2pzSE5qckludmgrOWloMnNVRWlwS1p4T1EwXC9aRDhGaTNhUk4iLCJtYWMiOiI0MWJiMWM5YjE0MzY1Yjc4MWJjMmVjYTVhMWI3YTgxYTRmZThmMTI5ZDZjNTExMzNlYWQwOTcwYjUzZTUzMTlkIn0%3D; expires=Wed, 16-Apr-2025 01:44:19 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6Im9hbnpmT0lCZ0RJaExZNXlkWkdmQ2c9PSIsInZhbHVlIjoiV2VzcGI2UVJPTU5sazIrSERKT2RzZ1BsTlJ0dmdcL3BUYTUyNWRKbENXSmVlQ3JcL1RMdlE1d3hWSj ▶"
    2 => "visit_counter=eyJpdiI6IisyUnVYQndUY0xVK0JyQWJBUVh1Mnc9PSIsInZhbHVlIjoidGZZTmVhT20xTUJQdUp4YnY4OGRaT0VDeFJYQTcxY3NheUpHV0NMZ3lPS096OTBLamFtOUxJbEQ0K1BKXC9CV1wvIiwibWFjIjoiYmE2MDFlY2IwZTIzODA0Y2QxMmQzYTQ5YzI2YzBiMWRlODI1YjM1NjA3ZWI3Nzk4NzcxYzEzMDk2NjZmM2MxYiJ9; expires=Thu, 15-May-2025 23:44:19 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IisyUnVYQndUY0xVK0JyQWJBUVh1Mnc9PSIsInZhbHVlIjoidGZZTmVhT20xTUJQdUp4YnY4OGRaT0VDeFJYQTcxY3NheUpHV0NMZ3lPS096OTBLamFtOUxJbEQ0K1BKXC9CV1wvIi ▶"
  ]
]

session_attributes

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

Rogers Stirk Harbour + Partners is a member of the CTBUH at the Silver level.

Renamed to:

Rogers Stirk Harbour + Partners

Buildings

1 x Application (95.54%)	219.69ms
1 x Booting (4.42%)	10.16ms

View all results