Maunsell AECOM Group

AECOM is a member of the CTBUH at the Platinum level.

Acquired by:

AECOM

Buildings

Rank	Name	City	Completion	Height
1	CITIC Plaza	Guangzhou	1996	390 m / 1,280 ft
2	Shun Hing Square	Shenzhen	1996	384 m / 1,260 ft
3	The Center	Hong Kong	1998	346 m / 1,135 ft
4	66 Tower 1	Shanghai	2005	262 m / 859 ft
4	66 Tower 2	Shanghai	2005	262 m / 859 ft
6	Shanghai IFC North Tower	Shanghai	2010	260 m / 853 ft
7	Shanghai IFC South Tower	Shanghai	2009	250 m / 820 ft
8	The Summit	Hong Kong	2002	220 m / 721 ft
9	Victoria Towers I	Hong Kong	2003	213 m / 699 ft
9	Victoria Towers II	Hong Kong	2003	213 m / 699 ft
9	Victoria Towers III	Hong Kong	2003	213 m / 699 ft
12	Sky Towers	Kiev	-	210 m / 688 ft
13	Jing Guang Center	Beijing	1990	208 m / 682 ft
14	Tseung Kwan O Plaza 1	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 2	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 3	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 3A	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 5	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 6	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 7	Hong Kong	2004	190 m / 623 ft
14	Tseung Kwan O Plaza 8	Hong Kong	2004	190 m / 623 ft
22	The Centrium	Hong Kong	2001	189 m / 620 ft
23	Suntec Tower 1	Singapore	1995	181 m / 593 ft
23	Suntec Tower 2	Singapore	1995	181 m / 593 ft
23	Suntec Tower 3	Singapore	1995	181 m / 593 ft
23	Suntec Tower 4	Singapore	1995	181 m / 593 ft
27	Central Plaza One	Brisbane	1988	174 m / 571 ft
28	The ONE	Hong Kong	2010	172 m / 565 ft
29	Coastal Skyline 1-3,5-6, Tung Chung	Hong Kong	2002	161 m / 528 ft
29	Coastal Skyline 7-8, Tung Chung	Hong Kong	2004	161 m / 528 ft
31	Metro City I Tower 3	Hong Kong	1996	154 m / 505 ft
31	Metro City I Tower 4	Hong Kong	1996	154 m / 505 ft
31	Metro City I Tower 5	Hong Kong	1996	154 m / 505 ft
31	Metro City I Tower 6	Hong Kong	1996	154 m / 505 ft
35	Metro City I Tower 1	Hong Kong	1996	154 m / 505 ft
35	Metro City I Tower 2	Hong Kong	1996	154 m / 505 ft
37	York Place	Hong Kong	2009	153 m / 500 ft
38	The Ritz-Carlton	Hong Kong	1993	142 m / 465 ft

Buildings per page:

Messages Timeline Exceptions Views12 Route Queries27 Models249 Mails Gate Session Request

7.3.33336ms9MBGET company/{id}

Booting (14.12ms)
Application (322ms)
1 x Application (95.76%)
321.60ms
1 x Booting (4.2%)
14.12ms

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 unique251ms

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

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

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

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

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

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

1.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: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 = '600' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

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

85.74ms/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` = 'Maunsell AECOM Group' and `active` = '1'2.18ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Maunsell AECOM Group 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 (600, 600)1.8ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 600 1. 600
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 (763, 12184, 1267, 1387, 1388, 1389, 242, 258, 1466, 867, 742, 743, 1519, 5372, 3727, 3725, 3724, 3726, 3729, 3728, 3262, 3263, 2014, 10240, 10239, 10238, 10237, 10236, 10235, 10234, 10233, 343, 2274, 2275, 2276, 2277, 2574, 8915) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

8.26ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 763 3. 12184 4. 1267 5. 1387 6. 1388 7. 1389 8. 242 9. 258 10. 1466 11. 867 12. 742 13. 743 14. 1519 15. 5372 16. 3727 17. 3725 18. 3724 19. 3726 20. 3729 21. 3728 22. 3262 23. 3263 24. 2014 25. 10240 26. 10239 27. 10238 28. 10237 29. 10236 30. 10235 31. 10234 32. 10233 33. 343 34. 2274 35. 2275 36. 2276 37. 2277 38. 2574 39. 8915
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 (648, 745, 746, 766, 795, 803, 1461, 1493)8.76ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11, 34, 140, 161)7.3ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11, 34, 140, 161)2.65ms/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 (242, 258, 343, 742, 743, 763, 867, 1267, 1387, 1388, 1389, 1466, 1519, 2014, 2274, 2275, 2276, 2277, 2574, 3262, 3263, 3724, 3725, 3726, 3727, 3728, 3729, 5372, 8915, 10233, 10234, 10235, 10236, 10237, 10238, 10239, 10240, 12184) order by `position` asc

4.98ms/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.55ms/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` = 600 and `v2_members`.`deleted_at` is null

2.76ms/app/CtbuhCompany.php:91buldingdb

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

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

1.87ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 4206
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 11.73msview::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.68ms/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.53ms/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.37ms/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.29ms/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.49ms/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.39ms/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.64ms/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.29ms/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: 153
App\Country: 8
App\City: 8
App\Building: 38
App\CtbuhCompany: 3

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

path_info

/company/600

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" => "49156"
  "REMOTE_ADDR" => "3.133.130.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/600"
  "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" => 1744985303.7053
  "REQUEST_TIME" => 1744985303
]

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 14:08:24 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxBYWFEbklcL3M3RTdDTEhMRlFGajFRPT0iLCJ2YWx1ZSI6IkVIYzdSM1ArdmIrZ3B3TFVBNVFMTitNMEMxbUFPdnA2UVFDWVJNYWUwMFwvbEZGWDc5VmdPSTRcL3pmeE9vMElqOXY5VStqclNkMWJGZlJlSmRrVG1WSFZDeThUZnFydUdsZDZJWTdPVU5Ic3ZwTGt5NWhUbWpsQnoxUThBYzIrTUgiLCJtYWMiOiI0Y2NjMGVkNWM0OWYzOTJjYjcyMmNiMjg0ZTlhNzQ0ZDZkZTg5M2Y2MDhmZDdhNjE5NjhhNWVlOTZjY2Q4N2ZjIn0%3D; expires=Fri, 18-Apr-2025 16:08:24 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxBYWFEbklcL3M3RTdDTEhMRlFGajFRPT0iLCJ2YWx1ZSI6IkVIYzdSM1ArdmIrZ3B3TFVBNVFMTitNMEMxbUFPdnA2UVFDWVJNYWUwMFwvbEZGWDc5VmdPSTRcL3pmeE9vMElqOXY5V ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImRLdGxjdkpHZUtjRVd4bktFdlJkNkE9PSIsInZhbHVlIjoiWVZhazlIdDBzeGYrNkpoaU9oZ0lxUU9Jbmg0OUt3UjlDSkNyRzI1NWs4TUhjZEg2azNISGthaHA3OVptNzhzcWJmZXFkTHJVN3FGTGFwOEowZE1WRVI5cEwzV25Zb0JhNVpYQmx5UXpscktaZjR6MkgyUEpwUmpva0xqN0t0WGsiLCJtYWMiOiJlMDJmYmU2NTM0ODM0OWRjNTlkZDkxZmFkOGE4NTdkYmM2MjljNTYxNWY4MjZmMzNjN2IwOTNkYTA3YWFhZmRiIn0%3D; expires=Fri, 18-Apr-2025 16:08:24 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImRLdGxjdkpHZUtjRVd4bktFdlJkNkE9PSIsInZhbHVlIjoiWVZhazlIdDBzeGYrNkpoaU9oZ0lxUU9Jbmg0OUt3UjlDSkNyRzI1NWs4TUhjZEg2azNISGthaHA3OV ▶"
    2 => "visit_counter=eyJpdiI6IlhNV0d2TUdod3pVa283NVBkY0tZZFE9PSIsInZhbHVlIjoiRXI3S2dYUEM4ODZHZU5odzFNZDJjem1rTmtyTW1zRXFRdWV5bkNkWXQ5SUlYSHlCQVNvbnBRQk5ZQWN4SDRwaSIsIm1hYyI6IjM2ZTkzNmUxMzNkMThlMjRmMmU1ZjFjYTU0MDdiMTFiZjllYThjMWY1YzIxNTU5MjBkMjkxNDA3MWY2ZjdiYjkifQ%3D%3D; expires=Sun, 18-May-2025 14:08:23 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IlhNV0d2TUdod3pVa283NVBkY0tZZFE9PSIsInZhbHVlIjoiRXI3S2dYUEM4ODZHZU5odzFNZDJjem1rTmtyTW1zRXFRdWV5bkNkWXQ5SUlYSHlCQVNvbnBRQk5ZQWN4SDRwaSIsIm ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxBYWFEbklcL3M3RTdDTEhMRlFGajFRPT0iLCJ2YWx1ZSI6IkVIYzdSM1ArdmIrZ3B3TFVBNVFMTitNMEMxbUFPdnA2UVFDWVJNYWUwMFwvbEZGWDc5VmdPSTRcL3pmeE9vMElqOXY5VStqclNkMWJGZlJlSmRrVG1WSFZDeThUZnFydUdsZDZJWTdPVU5Ic3ZwTGt5NWhUbWpsQnoxUThBYzIrTUgiLCJtYWMiOiI0Y2NjMGVkNWM0OWYzOTJjYjcyMmNiMjg0ZTlhNzQ0ZDZkZTg5M2Y2MDhmZDdhNjE5NjhhNWVlOTZjY2Q4N2ZjIn0%3D; expires=Fri, 18-Apr-2025 16:08:24 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxBYWFEbklcL3M3RTdDTEhMRlFGajFRPT0iLCJ2YWx1ZSI6IkVIYzdSM1ArdmIrZ3B3TFVBNVFMTitNMEMxbUFPdnA2UVFDWVJNYWUwMFwvbEZGWDc5VmdPSTRcL3pmeE9vMElqOXY5V ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImRLdGxjdkpHZUtjRVd4bktFdlJkNkE9PSIsInZhbHVlIjoiWVZhazlIdDBzeGYrNkpoaU9oZ0lxUU9Jbmg0OUt3UjlDSkNyRzI1NWs4TUhjZEg2azNISGthaHA3OVptNzhzcWJmZXFkTHJVN3FGTGFwOEowZE1WRVI5cEwzV25Zb0JhNVpYQmx5UXpscktaZjR6MkgyUEpwUmpva0xqN0t0WGsiLCJtYWMiOiJlMDJmYmU2NTM0ODM0OWRjNTlkZDkxZmFkOGE4NTdkYmM2MjljNTYxNWY4MjZmMzNjN2IwOTNkYTA3YWFhZmRiIn0%3D; expires=Fri, 18-Apr-2025 16:08:24 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImRLdGxjdkpHZUtjRVd4bktFdlJkNkE9PSIsInZhbHVlIjoiWVZhazlIdDBzeGYrNkpoaU9oZ0lxUU9Jbmg0OUt3UjlDSkNyRzI1NWs4TUhjZEg2azNISGthaHA3OV ▶"
    2 => "visit_counter=eyJpdiI6IlhNV0d2TUdod3pVa283NVBkY0tZZFE9PSIsInZhbHVlIjoiRXI3S2dYUEM4ODZHZU5odzFNZDJjem1rTmtyTW1zRXFRdWV5bkNkWXQ5SUlYSHlCQVNvbnBRQk5ZQWN4SDRwaSIsIm1hYyI6IjM2ZTkzNmUxMzNkMThlMjRmMmU1ZjFjYTU0MDdiMTFiZjllYThjMWY1YzIxNTU5MjBkMjkxNDA3MWY2ZjdiYjkifQ%3D%3D; expires=Sun, 18-May-2025 14:08:23 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IlhNV0d2TUdod3pVa283NVBkY0tZZFE9PSIsInZhbHVlIjoiRXI3S2dYUEM4ODZHZU5odzFNZDJjem1rTmtyTW1zRXFRdWV5bkNkWXQ5SUlYSHlCQVNvbnBRQk5ZQWN4SDRwaSIsIm ▶"
  ]
]

session_attributes

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

1 x Application (95.76%)	321.60ms
1 x Booting (4.2%)	14.12ms

View all results