WSP Group

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

Renamed to:

WSP | Parsons Brinckerhoff | WSP

Subsidiary companies:

WSP Architects | WSP Built Ecology | WSP Cantor Seinuk (2000) | WSP Flack + Kurtz | WSP Hong Kong Ltd. | WSP Lincolne Scott | WSP Middle East Limited | WSP Ng Pte Ltd

Buildings

Rank	Name	City	Completion	Height
1	Nakheel Tower	Dubai	-	1000 m / 3,281 ft
2	Phoenix Tower Feng	Wuhan	-	1000 m / 3,281 ft
3	India Tower	Mumbai	-	700 m / 2,296 ft
4	One World Trade Center	New York City	2014	541 m / 1,776 ft
5	Central Park Tower	New York City	2020	472 m / 1,550 ft
6	Petronas Twin Tower 1	Kuala Lumpur	1998	452 m / 1,483 ft
6	Petronas Twin Tower 2	Kuala Lumpur	1998	452 m / 1,483 ft
8	Nanning China Resources Tower	Nanning	-	445 m / 1,460 ft
9	Dongguan International Trade Center 1	Dongguan	2020	427 m / 1,401 ft
10	432 Park Avenue	New York City	2015	426 m / 1,397 ft
11	2 World Trade Center	New York City	-	411 m / 1,348 ft
12	2 World Trade Center	New York City	-	403 m / 1,323 ft
13	Nanning China Resources Tower	Nanning	2020	403 m / 1,321 ft
14	Nanjing Olympic Suning Tower	Nanjing	-	400 m / 1,312 ft
15	PIF Tower	Riyadh	2020	385 m / 1,263 ft
16	Shenzhen Center	Shenzhen	2020	376 m / 1,232 ft
17	Three Sixty West Tower B	Mumbai	-	361 m / 1,185 ft
18	Four Seasons Place	Kuala Lumpur	2018	343 m / 1,124 ft
19	ADNOC Headquarters	Abu Dhabi	2015	342 m / 1,122 ft
20	Tianjin World Financial Center	Tianjin	2011	337 m / 1,105 ft
21	3 World Trade Center	New York City	2018	329 m / 1,079 ft
22	The Index	Dubai	2010	326 m / 1,070 ft
23	Hermitage Plaza South Tower	Courbevoie	2024	320 m / 1,050 ft
24	Hermitage Plaza East Tower	Courbevoie	2024	320 m / 1,050 ft
25	New York Times Tower	New York City	2007	319 m / 1,046 ft
26	3 Hudson Boulevard	New York City	-	315 m / 1,034 ft
27	One57	New York City	2014	306 m / 1,004 ft
28	The Shard	London	2013	306 m / 1,004 ft
29	3 Hudson Boulevard	New York City	2023	301 m / 987 ft
30	Langham Hotel Tower	Dalian	-	300 m / 983 ft
31	Tour Phare	Puteaux	-	296 m / 971 ft
32	China Resources Qianhai Center Tower 1	Shenzhen	2020	292 m / 956 ft
33	I&M Tower	Dubai	-	290 m / 951 ft
34	1 Undershaft	London	-	290 m / 951 ft
35	One Liberty Place	Philadelphia	1987	288 m / 945 ft
36	30 Park Place	New York City	2016	282 m / 926 ft
37	15 Hudson Yards	New York City	2019	279 m / 914 ft
38	Torre Mitikah	Mexico City	2020	267 m / 877 ft
39	120 Collins Street	Melbourne	1991	267 m / 875 ft
40	Eight Spruce Street	New York City	2011	265 m / 870 ft
41	Trump World Tower	New York City	2001	262 m / 861 ft
42	425 Park Avenue	New York City	2020	262 m / 860 ft
43	Dongguan International Trade Center 2	Dongguan	2021	260 m / 853 ft
44	1 William Street	Brisbane	2016	260 m / 852 ft
45	Paddington Place	London	-	254 m / 833 ft
46	56 Leonard	New York City	2016	250 m / 821 ft
47	Skysuites @ Anson Enggor Street	Singapore	2014	250 m / 820 ft
48	4 Times Square	New York City	1999	247 m / 809 ft
49	Tencent Seafront Tower 1	Shenzhen	2017	246 m / 806 ft
50	Bloomberg Tower	New York City	2004	246 m / 806 ft

1 2 3 4 5 6 7

Buildings per page:

Messages Timeline Exceptions Views13 Route Queries46 Models3109 Mails Gate Session Request

7.3.331.41s26MBGET company/{id}

Booting (28.44ms)
Application (1.38s)
1 x Application (97.97%)
1.38s
1 x Booting (2.02%)
28.44ms

13 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.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

46 statements were executed, 6 of which were duplicated, 40 unique1.14s

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

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

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

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

1.26ms/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 * from `ctbuh_company` where `ctbuh_company`.`id` = 18265 and `ctbuh_company`.`deleted_at` is null limit 11.19ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

Metadata
Bindings	0. 18265
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:143 20. /app/CtbuhCompany.php:223 21. /app/Http/Controllers/CtbuhCompanyController.php:47

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

1.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:138 11. /app/CtbuhCompany.php:143 12. /app/CtbuhCompany.php:143 13. /app/CtbuhCompany.php:223

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

108ms/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` = 'WSP Group' and `active` = '1'1.48ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. WSP 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 (3987, 16349, 630, 1899, 2682, 1927, 1794, 11714, 631)

5.91ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 3987 1. 16349 2. 630 3. 1899 4. 2682 5. 1927 6. 1794 7. 11714 8. 631
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 (2026, 15083, 3579, 16291, 15894, 15895, 1125, 1109, 3557, 1731, 1732, 13519, 13520, 2834, 13230, 699, 3200, 3266, 18370, 2488, 18903, 2214, 1151, 1498, 2705, 9891, 9874, 11588, 2926, 570, 19729, 209, 19928, 14312, 20628, 11885, 2415, 1774, 3888, 14783, 2602, 15896, 9199, 24927, 24928, 24948, 22313, 22314, 11593, 2800, 14915, 3820, 3819, 13019, 2167, 9602, 2245, 29576, 1185, 1117, 16706, 907, 11884, 2381, 3581, 9909, 971, 3279, 987, 2588, 1611, 10486, 3483, 11886, 16217, 16215, 11382, 11381, 9979, 9893, 9887, 9886, 9806, 4147, 10567, 3791, 2900, 3983, 3026, 2652, 3621, 2686, 11376, 4593, 4133, 10489, 9839, 9894, 9903, 4550, 15576, 15577, 652, 9235, 844, 17158, 14864, 16292, 3989, 17851, 2435, 1124, 17197, 16191, 735, 11644, 3992, 16607, 3202, 11599, 2772, 16339, 28650, 15581, 14829, 11937, 3518, 9138, 13227, 14787, 2643, 273, 8969, 34986, 24506, 15944, 15945, 16268, 16322, 5367, 1082, 16968, 16969, 17181, 17181, 15971, 15971, 15971, 3268, 523, 12380, 18037, 10559, 1794, 14782, 14782, 15959, 15959, 4131, 4131, 11874, 19786, 19786, 1194, 15924, 16957, 16956, 17505, 17506, 9816, 8765, 8765, 4426, 21234, 21291, 21643, 21644, 21645, 21646, 21647, 21648, 21649, 21650, 16267, 19785, 19785, 22467, 10275, 10275, 16170, 23412, 24751, 24751, 24752, 24752, 532, 17374, 25661, 1, 26467, 24686, 5367, 15748, 15748, 19064, 22318, 16317, 14934, 387, 13028, 28006, 28012, 14622, 14622, 15943, 15327, 14816, 14816, 14816, 14816, 14816, 14816, 8763, 8763, 28453, 28454, 28455, 25970, 25970, 25970, 18223, 18041, 9786, 15593, 14588, 14587, 14586, 14585, 451, 451, 451, 451, 98, 12441, 14196, 8774, 9665, 14578, 14577, 14580, 14581, 14582, 14583, 14584, 3084, 3082, 11453, 31358, 31358, 16194, 26660, 16261, 24079, 15228, 13860, 13861, 18025, 14269, 18866, 18866, 33181, 8783, 33180, 24118, 24118, 13143, 13143, 13143, 13143, 581, 154, 15301, 3099, 9085, 11822, 17185, 11829, 12018, 396, 16424, 16424, 16422, 16422, 16427, 16427, 16426, 16426, 397, 3454, 11425, 2926, 19715, 16402, 2223, 938, 21059, 21060, 1384, 593, 2147, 15093, 2561, 3995, 17176, 360, 2606, 3358, 917, 2245, 15757, 1307, 9840, 11485, 2929, 25617, 9231, 9232, 149, 150, 8774, 2495, 1804, 3859, 1595, 3102, 14579, 2317, 9508, 2562, 16425, 16425, 15292, 652, 16849, 5211, 14829, 13227, 14787, 423, 11927, 3071, 3070, 9182, 9183, 1016, 19517, 1839, 1547, 3168, 1134, 4285, 19797, 19794, 25885, 25944, 25960, 25960, 10166, 1883, 13478, 13476, 717, 8965, 4009, 1612, 1082, 14403, 14403, 14403, 14403, 25838, 25980, 15327, 3386, 14444, 14443, 1390, 1391, 14198, 10498, 10497, 10496, 10503, 10502, 10501, 10500, 10499, 14083, 17338, 16849) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

21.04ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 2026 3. 15083 4. 3579 5. 16291 6. 15894 7. 15895 8. 1125 9. 1109 10. 3557 11. 1731 12. 1732 13. 13519 14. 13520 15. 2834 16. 13230 17. 699 18. 3200 19. 3266 20. 18370 21. 2488 22. 18903 23. 2214 24. 1151 25. 1498 26. 2705 27. 9891 28. 9874 29. 11588 30. 2926 31. 570 32. 19729 33. 209 34. 19928 35. 14312 36. 20628 37. 11885 38. 2415 39. 1774 40. 3888 41. 14783 42. 2602 43. 15896 44. 9199 45. 24927 46. 24928 47. 24948 48. 22313 49. 22314 50. 11593 51. 2800 52. 14915 53. 3820 54. 3819 55. 13019 56. 2167 57. 9602 58. 2245 59. 29576 60. 1185 61. 1117 62. 16706 63. 907 64. 11884 65. 2381 66. 3581 67. 9909 68. 971 69. 3279 70. 987 71. 2588 72. 1611 73. 10486 74. 3483 75. 11886 76. 16217 77. 16215 78. 11382 79. 11381 80. 9979 81. 9893 82. 9887 83. 9886 84. 9806 85. 4147 86. 10567 87. 3791 88. 2900 89. 3983 90. 3026 91. 2652 92. 3621 93. 2686 94. 11376 95. 4593 96. 4133 97. 10489 98. 9839 99. 9894 100. 9903 101. 4550 102. 15576 103. 15577 104. 652 105. 9235 106. 844 107. 17158 108. 14864 109. 16292 110. 3989 111. 17851 112. 2435 113. 1124 114. 17197 115. 16191 116. 735 117. 11644 118. 3992 119. 16607 120. 3202 121. 11599 122. 2772 123. 16339 124. 28650 125. 15581 126. 14829 127. 11937 128. 3518 129. 9138 130. 13227 131. 14787 132. 2643 133. 273 134. 8969 135. 34986 136. 24506 137. 15944 138. 15945 139. 16268 140. 16322 141. 5367 142. 1082 143. 16968 144. 16969 145. 17181 146. 17181 147. 15971 148. 15971 149. 15971 150. 3268 151. 523 152. 12380 153. 18037 154. 10559 155. 1794 156. 14782 157. 14782 158. 15959 159. 15959 160. 4131 161. 4131 162. 11874 163. 19786 164. 19786 165. 1194 166. 15924 167. 16957 168. 16956 169. 17505 170. 17506 171. 9816 172. 8765 173. 8765 174. 4426 175. 21234 176. 21291 177. 21643 178. 21644 179. 21645 180. 21646 181. 21647 182. 21648 183. 21649 184. 21650 185. 16267 186. 19785 187. 19785 188. 22467 189. 10275 190. 10275 191. 16170 192. 23412 193. 24751 194. 24751 195. 24752 196. 24752 197. 532 198. 17374 199. 25661 200. 1 201. 26467 202. 24686 203. 5367 204. 15748 205. 15748 206. 19064 207. 22318 208. 16317 209. 14934 210. 387 211. 13028 212. 28006 213. 28012 214. 14622 215. 14622 216. 15943 217. 15327 218. 14816 219. 14816 220. 14816 221. 14816 222. 14816 223. 14816 224. 8763 225. 8763 226. 28453 227. 28454 228. 28455 229. 25970 230. 25970 231. 25970 232. 18223 233. 18041 234. 9786 235. 15593 236. 14588 237. 14587 238. 14586 239. 14585 240. 451 241. 451 242. 451 243. 451 244. 98 245. 12441 246. 14196 247. 8774 248. 9665 249. 14578 250. 14577 251. 14580 252. 14581 253. 14582 254. 14583 255. 14584 256. 3084 257. 3082 258. 11453 259. 31358 260. 31358 261. 16194 262. 26660 263. 16261 264. 24079 265. 15228 266. 13860 267. 13861 268. 18025 269. 14269 270. 18866 271. 18866 272. 33181 273. 8783 274. 33180 275. 24118 276. 24118 277. 13143 278. 13143 279. 13143 280. 13143 281. 581 282. 154 283. 15301 284. 3099 285. 9085 286. 11822 287. 17185 288. 11829 289. 12018 290. 396 291. 16424 292. 16424 293. 16422 294. 16422 295. 16427 296. 16427 297. 16426 298. 16426 299. 397 300. 3454 301. 11425 302. 2926 303. 19715 304. 16402 305. 2223 306. 938 307. 21059 308. 21060 309. 1384 310. 593 311. 2147 312. 15093 313. 2561 314. 3995 315. 17176 316. 360 317. 2606 318. 3358 319. 917 320. 2245 321. 15757 322. 1307 323. 9840 324. 11485 325. 2929 326. 25617 327. 9231 328. 9232 329. 149 330. 150 331. 8774 332. 2495 333. 1804 334. 3859 335. 1595 336. 3102 337. 14579 338. 2317 339. 9508 340. 2562 341. 16425 342. 16425 343. 15292 344. 652 345. 16849 346. 5211 347. 14829 348. 13227 349. 14787 350. 423 351. 11927 352. 3071 353. 3070 354. 9182 355. 9183 356. 1016 357. 19517 358. 1839 359. 1547 360. 3168 361. 1134 362. 4285 363. 19797 364. 19794 365. 25885 366. 25944 367. 25960 368. 25960 369. 10166 370. 1883 371. 13478 372. 13476 373. 717 374. 8965 375. 4009 376. 1612 377. 1082 378. 14403 379. 14403 380. 14403 381. 14403 382. 25838 383. 25980 384. 15327 385. 3386 386. 14444 387. 14443 388. 1390 389. 1391 390. 14198 391. 10498 392. 10497 393. 10496 394. 10503 395. 10502 396. 10501 397. 10500 398. 10499 399. 14083 400. 17338 401. 16849
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 (629, 630, 639, 647, 648, 653, 658, 661, 700, 706, 715, 745, 746, 750, 752, 754, 755, 764, 766, 789, 790, 795, 803, 806, 813, 918, 926, 932, 942, 943, 989, 1072, 1079, 1101, 1110, 1118, 1398, 1400, 1428, 1436, 1450, 1452, 1461, 1471, 1524, 1543, 1556, 1592, 1593, 1605, 1610, 1623, 1627, 1632, 1641, 1657, 1683, 1714, 1740, 1744, 2078, 2502)

2.69ms/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 (2, 9, 11, 13, 22, 27, 34, 55, 56, 75, 85, 86, 105, 111, 112, 127, 133, 135, 137, 140, 153, 163, 168, 172)

1.79ms/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 (2, 9, 11, 13, 22, 27, 34, 55, 56, 75, 85, 86, 105, 111, 112, 127, 133, 135, 137, 140, 153, 163, 168, 172)

1.8ms/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 (1, 98, 149, 150, 154, 209, 273, 360, 387, 396, 397, 423, 451, 523, 532, 570, 581, 593, 652, 699, 717, 735, 844, 907, 917, 938, 971, 987, 1016, 1082, 1109, 1117, 1124, 1125, 1134, 1151, 1185, 1194, 1307, 1384, 1390, 1391, 1498, 1547, 1595, 1611, 1612, 1731, 1732, 1774, 1794, 1804, 1839, 1883, 2026, 2147, 2167, 2214, 2223, 2245, 2317, 2381, 2415, 2435, 2488, 2495, 2561, 2562, 2588, 2602, 2606, 2643, 2652, 2686, 2705, 2772, 2800, 2834, 2900, 2926, 2929, 3026, 3070, 3071, 3082, 3084, 3099, 3102, 3168, 3200, 3202, 3266, 3268, 3279, 3358, 3386, 3454, 3483, 3518, 3557, 3579, 3581, 3621, 3791, 3819, 3820, 3859, 3888, 3983, 3989, 3992, 3995, 4009, 4131, 4133, 4147, 4285, 4426, 4550, 4593, 5211, 5367, 8763, 8765, 8774, 8783, 8965, 8969, 9085, 9138, 9182, 9183, 9199, 9231, 9232, 9235, 9508, 9602, 9665, 9786, 9806, 9816, 9839, 9840, 9874, 9886, 9887, 9891, 9893, 9894, 9903, 9909, 9979, 10166, 10275, 10486, 10489, 10496, 10497, 10498, 10499, 10500, 10501, 10502, 10503, 10559, 10567, 11376, 11381, 11382, 11425, 11453, 11485, 11588, 11593, 11599, 11644, 11822, 11829, 11874, 11884, 11885, 11886, 11927, 11937, 12018, 12380, 13019, 13028, 13143, 13227, 13230, 13476, 13478, 13519, 13520, 13860, 13861, 14083, 14196, 14198, 14269, 14312, 14403, 14443, 14444, 14577, 14578, 14579, 14580, 14581, 14582, 14583, 14584, 14585, 14586, 14587, 14588, 14622, 14782, 14783, 14787, 14816, 14829, 14864, 14915, 14934, 15083, 15093, 15228, 15292, 15301, 15327, 15576, 15577, 15581, 15593, 15748, 15757, 15894, 15895, 15896, 15924, 15943, 15944, 15945, 15959, 15971, 16170, 16191, 16194, 16215, 16217, 16261, 16267, 16268, 16291, 16292, 16317, 16322, 16339, 16402, 16422, 16424, 16425, 16426, 16427, 16607, 16706, 16849, 16956, 16957, 16968, 16969, 17158, 17176, 17181, 17185, 17197, 17338, 17374, 17505, 17506, 17851, 18025, 18041, 18223, 18866, 18903, 19064, 19517, 19715, 19785, 19794, 19797, 19928, 20628, 21059, 21060, 21234, 21291, 21643, 21644, 21645, 21646, 21647, 21648, 21649, 21650, 22313, 22314, 22318, 22467, 23412, 24079, 24118, 24506, 24686, 24751, 24752, 24928, 24948, 25617, 25661, 25838, 25885, 25944, 25960, 25970, 25980, 26467, 26660, 28006, 28012, 28453, 28454, 28455, 28650, 29576, 31358, 33180, 33181, 34986) order by `position` asc

53.1ms/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'2.38ms/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` = 631 and `v2_members`.`deleted_at` is null

16.65ms/app/CtbuhCompany.php:91buldingdb

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

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

4.02ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 12669
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 `ctbuh_company` where `ctbuh_company`.`id` = 18265 and `ctbuh_company`.`deleted_at` is null limit 12.97ms/app/CtbuhCompany.php:287buldingdb

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

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

4.31ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 18265
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/CtbuhCompany.php:96 21. /app/CtbuhCompany.php:288 22. /app/CtbuhCompany.php:292 23. /app/Http/Controllers/CtbuhCompanyController.php:696

select * from `v2_membership_levels` where `v2_membership_levels`.`id` = 13 limit 15.58msview::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.78ms/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

6.65ms/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 15.05ms/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

2.56ms/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.66ms/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.28ms/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.32ms/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

2.36ms/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.22ms/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: 2604
App\Country: 48
App\City: 62
App\Building: 343
App\CtbuhCompany: 13

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

path_info

/company/631

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" => "64346"
  "REMOTE_ADDR" => "18.191.246.216"
  "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/631"
  "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" => 1744196743.4936
  "REQUEST_TIME" => 1744196743
]

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 => "Wed, 09 Apr 2025 11:05:44 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFNUXdtejFrOWt6aUpFQWRnbE9VZVE9PSIsInZhbHVlIjoia2tDOTRkSjNrTldRbnF5Tm5zTWVoTms4MHp4YjBVOHVxdHh2Umh3NllVcjAyenhOK2JPRmQ3SlhqbEVlZWxrdWxlQUVMbExvQXNHK0tBdlBONkdlTFwvVFl0U0ZFT09rSTAxOGd5WjN3RnQ3TE1NRFVScU8xcnNnalhGMGtBQjY0IiwibWFjIjoiZWM5N2FlZTkyMjVlOWI5MWMzNzQxMzE5MTY2YWUzZmVmNTVlM2Q0Mjk5MmI4YTBmNmY5MzhkYWI2Y2FmNjg4NiJ9; expires=Wed, 09-Apr-2025 13:05:44 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFNUXdtejFrOWt6aUpFQWRnbE9VZVE9PSIsInZhbHVlIjoia2tDOTRkSjNrTldRbnF5Tm5zTWVoTms4MHp4YjBVOHVxdHh2Umh3NllVcjAyenhOK2JPRmQ3SlhqbEVlZWxrdWxlQUVMb ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlV1V0hUYWpxRHlCUmZrT2w4SmZtSXc9PSIsInZhbHVlIjoiUTc3bHEzQXZ1ZWFOXC9UVjdoalZIYmNUdEx2bHlUVytlV2hPR1wvNlE4cjBhZ0lKOHN1M0ZRenBFT2ZBZnlHRyt3eWVLXC9PdDVPXC8zV0xabkdoRFR2WUlQckRoWXpuRWFZSHc3SVIxeEd2cGRMTnV0ckFYWE0xUkF5Q094dGpIY2VWIiwibWFjIjoiYjg3MDhkN2ExZGFlMDAzMTdkNDUyZTZlMWE5OWU2NjhmYWRlZDg0MjY1MTg5ODVlOTAzYmYxMzkyNWJhODg4NyJ9; expires=Wed, 09-Apr-2025 13:05:44 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlV1V0hUYWpxRHlCUmZrT2w4SmZtSXc9PSIsInZhbHVlIjoiUTc3bHEzQXZ1ZWFOXC9UVjdoalZIYmNUdEx2bHlUVytlV2hPR1wvNlE4cjBhZ0lKOHN1M0ZRenBFT2 ▶"
    2 => "visit_counter=eyJpdiI6IkVHWGFSQW85UnNNNEkxMmE1bnNBTEE9PSIsInZhbHVlIjoiNVJqK0FQRlh3dU5aOHc0VERDazdpQlplMWZySk9LTHpCM25wZmdmWlVySmNPelZcL0piRlVySXJsOUpBU2p0SjQiLCJtYWMiOiJjZGE2MDNlZDY4YWYwZGQ5MDM3YzNlYzE3NGY0OWNlMDFmM2VmZmViNWJlMjAxYTFiM2YzMmQzMzZhMGUzYWUwIn0%3D; expires=Fri, 09-May-2025 11:05:43 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IkVHWGFSQW85UnNNNEkxMmE1bnNBTEE9PSIsInZhbHVlIjoiNVJqK0FQRlh3dU5aOHc0VERDazdpQlplMWZySk9LTHpCM25wZmdmWlVySmNPelZcL0piRlVySXJsOUpBU2p0SjQiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFNUXdtejFrOWt6aUpFQWRnbE9VZVE9PSIsInZhbHVlIjoia2tDOTRkSjNrTldRbnF5Tm5zTWVoTms4MHp4YjBVOHVxdHh2Umh3NllVcjAyenhOK2JPRmQ3SlhqbEVlZWxrdWxlQUVMbExvQXNHK0tBdlBONkdlTFwvVFl0U0ZFT09rSTAxOGd5WjN3RnQ3TE1NRFVScU8xcnNnalhGMGtBQjY0IiwibWFjIjoiZWM5N2FlZTkyMjVlOWI5MWMzNzQxMzE5MTY2YWUzZmVmNTVlM2Q0Mjk5MmI4YTBmNmY5MzhkYWI2Y2FmNjg4NiJ9; expires=Wed, 09-Apr-2025 13:05:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFNUXdtejFrOWt6aUpFQWRnbE9VZVE9PSIsInZhbHVlIjoia2tDOTRkSjNrTldRbnF5Tm5zTWVoTms4MHp4YjBVOHVxdHh2Umh3NllVcjAyenhOK2JPRmQ3SlhqbEVlZWxrdWxlQUVMb ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlV1V0hUYWpxRHlCUmZrT2w4SmZtSXc9PSIsInZhbHVlIjoiUTc3bHEzQXZ1ZWFOXC9UVjdoalZIYmNUdEx2bHlUVytlV2hPR1wvNlE4cjBhZ0lKOHN1M0ZRenBFT2ZBZnlHRyt3eWVLXC9PdDVPXC8zV0xabkdoRFR2WUlQckRoWXpuRWFZSHc3SVIxeEd2cGRMTnV0ckFYWE0xUkF5Q094dGpIY2VWIiwibWFjIjoiYjg3MDhkN2ExZGFlMDAzMTdkNDUyZTZlMWE5OWU2NjhmYWRlZDg0MjY1MTg5ODVlOTAzYmYxMzkyNWJhODg4NyJ9; expires=Wed, 09-Apr-2025 13:05:44 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlV1V0hUYWpxRHlCUmZrT2w4SmZtSXc9PSIsInZhbHVlIjoiUTc3bHEzQXZ1ZWFOXC9UVjdoalZIYmNUdEx2bHlUVytlV2hPR1wvNlE4cjBhZ0lKOHN1M0ZRenBFT2 ▶"
    2 => "visit_counter=eyJpdiI6IkVHWGFSQW85UnNNNEkxMmE1bnNBTEE9PSIsInZhbHVlIjoiNVJqK0FQRlh3dU5aOHc0VERDazdpQlplMWZySk9LTHpCM25wZmdmWlVySmNPelZcL0piRlVySXJsOUpBU2p0SjQiLCJtYWMiOiJjZGE2MDNlZDY4YWYwZGQ5MDM3YzNlYzE3NGY0OWNlMDFmM2VmZmViNWJlMjAxYTFiM2YzMmQzMzZhMGUzYWUwIn0%3D; expires=Fri, 09-May-2025 11:05:43 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IkVHWGFSQW85UnNNNEkxMmE1bnNBTEE9PSIsInZhbHVlIjoiNVJqK0FQRlh3dU5aOHc0VERDazdpQlplMWZySk9LTHpCM25wZmdmWlVySmNPelZcL0piRlVySXJsOUpBU2p0SjQiLC ▶"
  ]
]

session_attributes

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

1 x Application (97.97%)	1.38s
1 x Booting (2.02%)	28.44ms