WSP

Rank	Name	City	Completion	Height
1	One Dubai Tower A	Dubai	-	1008 m / 3,307 ft
2	Nakheel Tower	Dubai	-	1000 m / 3,281 ft
3	Phoenix Tower Feng	Wuhan	-	1000 m / 3,281 ft
4	One Dubai Tower B	Dubai	-	874 m / 2,867 ft
5	Suzhou Zhongnan Center	Suzhou	-	729 m / 2,392 ft
6	India Tower	Mumbai	-	700 m / 2,296 ft
7	One Dubai Tower C	Dubai	-	685 m / 2,247 ft
8	Wuhan CTF Finance Center	Wuhan	-	648 m / 2,126 ft
9	Shenzhen Tower	Shenzhen	-	642 m / 2,106 ft
10	Wuhan Greenland Center	Wuhan	-	636 m / 2,087 ft
11	Shanghai Tower	Shanghai	2015	632 m / 2,073 ft
12	Russia Tower	Moscow	-	612 m / 2,008 ft
13	H700	Shenzhen	-	608 m / 1,995 ft
14	Goldin Finance 117	Tianjin	2021	597 m / 1,957 ft
15	Entisar Tower	Dubai	2022	570 m / 1,870 ft
16	Global Financial Center Tower 1	Shenyang	-	568 m / 1,864 ft
17	Lotte World Tower	Seoul	2017	555 m / 1,819 ft
18	One World Trade Center	New York City	2014	541 m / 1,776 ft
19	Guangzhou CTF Finance Centre	Guangzhou	2016	530 m / 1,739 ft
20	Evergrande International Financial Center T1	Hefei	-	518 m / 1,699 ft
21	Nina Tower	Hong Kong	-	518 m / 1,699 ft
22	Hengqin Headquarters Tower 2	Zhuhai	-	490 m / 1,608 ft
23	Wuhan Greenland Center	Wuhan	-	476 m / 1,560 ft
24	Central Park Tower	New York City	2020	472 m / 1,550 ft
25	Petronas Twin Tower 1	Kuala Lumpur	1998	452 m / 1,483 ft
25	Petronas Twin Tower 2	Kuala Lumpur	1998	452 m / 1,483 ft
27	Suzhou IFS	Suzhou	2019	450 m / 1,476 ft
28	Nanning China Resources Tower	Nanning	-	445 m / 1,460 ft
29	111 West 57th Street	New York City	2020	435 m / 1,428 ft
30	Haikou Tower 1	Haikou	-	428 m / 1,404 ft
31	Dongguan International Trade Center 1	Dongguan	2020	427 m / 1,401 ft
32	432 Park Avenue	New York City	2015	426 m / 1,397 ft
33	Al Hamra Tower	Kuwait City	2011	413 m / 1,354 ft
34	LCT The Sharp Landmark Tower	Busan	2019	412 m / 1,350 ft
35	2 World Trade Center	New York City	-	411 m / 1,348 ft
36	2 World Trade Center	New York City	-	403 m / 1,323 ft
37	Nanning China Resources Tower	Nanning	2020	403 m / 1,321 ft
38	Nanjing Olympic Suning Tower	Nanjing	-	400 m / 1,312 ft
39	Suning Xinjiekou Plaza	Nanjing	-	388 m / 1,273 ft
40	La Maison by HDS	Dubai	-	387 m / 1,268 ft
41	Waldorf=Astoria Hotel & Condominium Tower	Chicago	-	386 m / 1,265 ft
42	PIF Tower	Riyadh	2020	385 m / 1,263 ft
43	Forum 66 Tower 2	Shenyang	-	384 m / 1,260 ft
44	Eton Place Dalian Tower 1	Dalian	2016	383 m / 1,257 ft
45	Burj Mohammed Bin Rashid	Abu Dhabi	2014	381 m / 1,251 ft
46	Shenzhen Center	Shenzhen	2020	376 m / 1,232 ft
47	VietinBank Business Center Office Tower	Hanoi	-	363 m / 1,191 ft
48	Three Sixty West Tower B	Mumbai	-	361 m / 1,185 ft
49	Hanking Center	Shenzhen	2018	359 m / 1,177 ft
50	Sino Steel International Plaza T2	Tianjin	-	358 m / 1,175 ft

Messages Timeline Exceptions Views15 Route Queries54 Models5515 Mails Gate Session Request

7.3.331.78s41MBGET company/{id}

Booting (10.75ms)
Application (1.77s)
1 x Application (99.39%)
1.77s
1 x Booting (0.6%)
10.75ms

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

54 statements were executed, 4 of which were duplicated, 50 unique1.37s

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

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

1.38ms/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` = 18265 and `ctbuh_company`.`deleted_at` is null limit 11.31ms/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: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 = '18265' 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 = '12669' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

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

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

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

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

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

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

92.77ms/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` = 3987 and `ctbuh_company`.`deleted_at` is null limit 11.49ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

92.68ms/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:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 16349 and `ctbuh_company`.`deleted_at` is null limit 11.51ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

84.28ms/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:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 630 and `ctbuh_company`.`deleted_at` is null limit 11.58ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

86.13ms/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:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 1899 and `ctbuh_company`.`deleted_at` is null limit 11.41ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

76.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:177 12. /app/CtbuhCompany.php:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 2682 and `ctbuh_company`.`deleted_at` is null limit 11.54ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

65.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:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 1927 and `ctbuh_company`.`deleted_at` is null limit 11.41ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

64.99ms/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:177 13. /app/CtbuhCompany.php:207

select * from `ctbuh_company` where `ctbuh_company`.`id` = 1794 and `ctbuh_company`.`deleted_at` is null limit 11.45ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

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

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

select * from `ctbuh_company` where `ctbuh_company`.`id` = 11714 and `ctbuh_company`.`deleted_at` is null limit 11.77ms/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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

64.88ms/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:177 13. /app/CtbuhCompany.php:207

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

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

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

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

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

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

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

Metadata
Bindings	0. 1921
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:177 20. /app/CtbuhCompany.php:207 21. /app/CtbuhCompany.php:254

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

64.36ms/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:177 13. /app/CtbuhCompany.php:207

select `id` from `ctbuh_company` where `name` = 'WSP | Parsons Brinckerhoff' and `active` = '1'1.78ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. WSP \| Parsons Brinckerhoff 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 (589, 1968, 631, 11796, 14417, 3987, 16349, 630, 1899, 2682, 1927, 1794, 11714, 1921, 12669)

11.63ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 589 1. 1968 2. 631 3. 11796 4. 14417 5. 3987 6. 16349 7. 630 8. 1899 9. 2682 10. 1927 11. 1794 12. 11714 13. 1921 14. 12669
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 (16367, 14779, 3929, 10134, 10133, 259, 653, 12595, 810, 22300, 3138, 15729, 24023, 24825, 387, 61, 878, 26864, 29595, 233, 16563, 14291, 16637, 9087, 1484, 1484, 2580, 13165, 22145, 29518, 26413, 23424, 19748, 14780, 1546, 9078, 5178, 5177, 5179, 12015, 12016, 9945, 10505, 10745, 255, 31575, 14278, 30703, 12095, 29519, 19963, 15962, 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, 13509, 13506, 13506, 15487, 13467, 1570, 15185, 19481, 13448, 25884, 14622, 3276, 18178, 18178, 3095, 18025, 18172, 18172, 9182, 9183, 1016, 19517, 1839, 1547, 3168, 1134, 4285, 19797, 19794, 25885, 25944, 25960, 25960, 10166, 1883, 13478, 13476, 717, 8965, 4009, 1612, 15959, 561, 182, 14779, 14779, 5284, 11156, 11157, 11158, 17468, 17471, 17482, 17477, 17478, 17479, 17480, 17481, 763, 18037, 11863, 10196, 10197, 18214, 933, 797, 14782, 18686, 18687, 18688, 18736, 19155, 14163, 3069, 542, 8771, 15741, 15741, 257, 364, 4141, 414, 14243, 14243, 12894, 12140, 824, 8796, 11329, 4139, 4140, 618, 21984, 12141, 921, 23996, 370, 208, 23404, 25503, 25504, 23406, 838, 108, 235, 12160, 14076, 356, 309, 14847, 475, 9434, 867, 360, 379, 379, 18737, 2730, 8917, 8772, 9953, 19228, 18223, 18041, 19496, 30422, 14780, 590, 13871, 13872, 11168, 14588, 2240, 2239, 14587, 14586, 14585, 104, 17508, 10274, 950, 330, 73, 73, 12441, 12441, 15655, 15655, 14196, 8905, 249, 249, 644, 644, 9671, 196, 14578, 14577, 14579, 14580, 14581, 14582, 14583, 14584, 2104, 2105, 9189, 1190, 9188, 5291, 689, 1132, 9348, 9244, 9249, 9251, 9245, 16900, 15437, 15437, 14899, 343, 16336, 11159, 789, 852, 2151, 2152, 19227, 22175, 16709, 22586, 22586, 33181, 33181, 16710, 33180, 33180, 14251, 33983, 13245, 34380, 34383, 34381, 34382, 34384, 9247, 9248, 9246, 2731, 2732, 1082, 14403, 14403, 14403, 14403, 25838, 25980, 15327, 3386, 14444, 14443, 1390, 1391, 14198, 10498, 10497, 10496, 10503, 10502, 10501, 10500, 10499, 14083, 15644, 942, 15645, 17672, 15117, 15241, 15241, 23686, 23687, 23688, 23689, 24591, 24592, 24593, 24594, 25071, 56, 25727, 25727, 23988, 16952, 16952, 15966, 4122, 4728, 15288, 4994, 25746, 12609, 16870, 16870, 16871, 16871, 19555, 19555, 16926, 16926, 16926, 16926, 17975, 17975, 17975, 17975, 17975, 17975, 17975, 17975, 15289, 15289, 15419, 56, 27178, 27178, 27178, 27178, 27181, 27181, 27181, 27181, 27182, 27182, 27182, 27182, 27183, 27183, 27183, 27183, 27184, 27184, 27184, 27184, 27185, 27185, 27185, 27185, 8821, 12542, 11160, 14311, 8686, 8685, 8778, 8779, 8780, 8781, 8782, 1867, 18648, 18648, 18648, 18648, 18648, 18648, 18648, 18648, 14320, 625, 625, 27195, 29842, 13289, 13289, 13289, 13289, 13289, 12130, 16794, 451, 11163, 11163, 14435, 14435, 15631, 15631, 15631, 15631, 15631, 15631, 15631, 15631, 14198, 14198, 14198, 14198, 398, 398, 26461, 26461, 19538, 19538, 19539, 19539, 88, 88, 88, 12610, 176, 176, 27227, 14878, 14878, 14878, 27762, 36501, 36502, 36742, 14010, 17613, 13447, 16413, 16413, 19431, 19432, 27338, 17338, 16849) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

25.83ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 16367 3. 14779 4. 3929 5. 10134 6. 10133 7. 259 8. 653 9. 12595 10. 810 11. 22300 12. 3138 13. 15729 14. 24023 15. 24825 16. 387 17. 61 18. 878 19. 26864 20. 29595 21. 233 22. 16563 23. 14291 24. 16637 25. 9087 26. 1484 27. 1484 28. 2580 29. 13165 30. 22145 31. 29518 32. 26413 33. 23424 34. 19748 35. 14780 36. 1546 37. 9078 38. 5178 39. 5177 40. 5179 41. 12015 42. 12016 43. 9945 44. 10505 45. 10745 46. 255 47. 31575 48. 14278 49. 30703 50. 12095 51. 29519 52. 19963 53. 15962 54. 2026 55. 15083 56. 3579 57. 16291 58. 15894 59. 15895 60. 1125 61. 1109 62. 3557 63. 1731 64. 1732 65. 13519 66. 13520 67. 2834 68. 13230 69. 699 70. 3200 71. 3266 72. 18370 73. 2488 74. 18903 75. 2214 76. 1151 77. 1498 78. 2705 79. 9891 80. 9874 81. 11588 82. 2926 83. 570 84. 19729 85. 209 86. 19928 87. 14312 88. 20628 89. 11885 90. 2415 91. 1774 92. 3888 93. 14783 94. 2602 95. 15896 96. 9199 97. 24927 98. 24928 99. 24948 100. 22313 101. 22314 102. 11593 103. 2800 104. 14915 105. 3820 106. 3819 107. 13019 108. 2167 109. 9602 110. 2245 111. 29576 112. 1185 113. 1117 114. 16706 115. 907 116. 11884 117. 2381 118. 3581 119. 9909 120. 971 121. 3279 122. 987 123. 2588 124. 1611 125. 10486 126. 3483 127. 11886 128. 16217 129. 16215 130. 11382 131. 11381 132. 9979 133. 9893 134. 9887 135. 9886 136. 9806 137. 4147 138. 10567 139. 3791 140. 2900 141. 3983 142. 3026 143. 2652 144. 3621 145. 2686 146. 11376 147. 4593 148. 4133 149. 10489 150. 9839 151. 9894 152. 9903 153. 4550 154. 15576 155. 15577 156. 652 157. 9235 158. 844 159. 17158 160. 14864 161. 16292 162. 3989 163. 17851 164. 2435 165. 1124 166. 17197 167. 16191 168. 735 169. 11644 170. 3992 171. 16607 172. 3202 173. 11599 174. 2772 175. 16339 176. 28650 177. 15581 178. 14829 179. 11937 180. 3518 181. 9138 182. 13227 183. 14787 184. 2643 185. 273 186. 8969 187. 34986 188. 24506 189. 15944 190. 15945 191. 16268 192. 16322 193. 5367 194. 1082 195. 16968 196. 16969 197. 17181 198. 17181 199. 15971 200. 15971 201. 15971 202. 3268 203. 523 204. 12380 205. 18037 206. 10559 207. 1794 208. 14782 209. 14782 210. 15959 211. 15959 212. 4131 213. 4131 214. 11874 215. 19786 216. 19786 217. 1194 218. 15924 219. 16957 220. 16956 221. 17505 222. 17506 223. 9816 224. 8765 225. 8765 226. 4426 227. 21234 228. 21291 229. 21643 230. 21644 231. 21645 232. 21646 233. 21647 234. 21648 235. 21649 236. 21650 237. 16267 238. 19785 239. 19785 240. 22467 241. 10275 242. 10275 243. 16170 244. 23412 245. 24751 246. 24751 247. 24752 248. 24752 249. 532 250. 17374 251. 25661 252. 1 253. 26467 254. 24686 255. 5367 256. 15748 257. 15748 258. 19064 259. 22318 260. 16317 261. 14934 262. 387 263. 13028 264. 28006 265. 28012 266. 14622 267. 14622 268. 15943 269. 15327 270. 14816 271. 14816 272. 14816 273. 14816 274. 14816 275. 14816 276. 8763 277. 8763 278. 28453 279. 28454 280. 28455 281. 25970 282. 25970 283. 25970 284. 18223 285. 18041 286. 9786 287. 15593 288. 14588 289. 14587 290. 14586 291. 14585 292. 451 293. 451 294. 451 295. 451 296. 98 297. 12441 298. 14196 299. 8774 300. 9665 301. 14578 302. 14577 303. 14580 304. 14581 305. 14582 306. 14583 307. 14584 308. 3084 309. 3082 310. 11453 311. 31358 312. 31358 313. 16194 314. 26660 315. 16261 316. 24079 317. 15228 318. 13860 319. 13861 320. 18025 321. 14269 322. 18866 323. 18866 324. 33181 325. 8783 326. 33180 327. 24118 328. 24118 329. 13143 330. 13143 331. 13143 332. 13143 333. 581 334. 154 335. 15301 336. 3099 337. 9085 338. 11822 339. 17185 340. 11829 341. 12018 342. 396 343. 16424 344. 16424 345. 16422 346. 16422 347. 16427 348. 16427 349. 16426 350. 16426 351. 397 352. 3454 353. 11425 354. 2926 355. 19715 356. 16402 357. 2223 358. 938 359. 21059 360. 21060 361. 1384 362. 593 363. 2147 364. 15093 365. 2561 366. 3995 367. 17176 368. 360 369. 2606 370. 3358 371. 917 372. 2245 373. 15757 374. 1307 375. 9840 376. 11485 377. 2929 378. 25617 379. 9231 380. 9232 381. 149 382. 150 383. 8774 384. 2495 385. 1804 386. 3859 387. 1595 388. 3102 389. 14579 390. 2317 391. 9508 392. 2562 393. 16425 394. 16425 395. 15292 396. 652 397. 16849 398. 5211 399. 14829 400. 13227 401. 14787 402. 423 403. 11927 404. 3071 405. 3070 406. 13509 407. 13506 408. 13506 409. 15487 410. 13467 411. 1570 412. 15185 413. 19481 414. 13448 415. 25884 416. 14622 417. 3276 418. 18178 419. 18178 420. 3095 421. 18025 422. 18172 423. 18172 424. 9182 425. 9183 426. 1016 427. 19517 428. 1839 429. 1547 430. 3168 431. 1134 432. 4285 433. 19797 434. 19794 435. 25885 436. 25944 437. 25960 438. 25960 439. 10166 440. 1883 441. 13478 442. 13476 443. 717 444. 8965 445. 4009 446. 1612 447. 15959 448. 561 449. 182 450. 14779 451. 14779 452. 5284 453. 11156 454. 11157 455. 11158 456. 17468 457. 17471 458. 17482 459. 17477 460. 17478 461. 17479 462. 17480 463. 17481 464. 763 465. 18037 466. 11863 467. 10196 468. 10197 469. 18214 470. 933 471. 797 472. 14782 473. 18686 474. 18687 475. 18688 476. 18736 477. 19155 478. 14163 479. 3069 480. 542 481. 8771 482. 15741 483. 15741 484. 257 485. 364 486. 4141 487. 414 488. 14243 489. 14243 490. 12894 491. 12140 492. 824 493. 8796 494. 11329 495. 4139 496. 4140 497. 618 498. 21984 499. 12141 500. 921 501. 23996 502. 370 503. 208 504. 23404 505. 25503 506. 25504 507. 23406 508. 838 509. 108 510. 235 511. 12160 512. 14076 513. 356 514. 309 515. 14847 516. 475 517. 9434 518. 867 519. 360 520. 379 521. 379 522. 18737 523. 2730 524. 8917 525. 8772 526. 9953 527. 19228 528. 18223 529. 18041 530. 19496 531. 30422 532. 14780 533. 590 534. 13871 535. 13872 536. 11168 537. 14588 538. 2240 539. 2239 540. 14587 541. 14586 542. 14585 543. 104 544. 17508 545. 10274 546. 950 547. 330 548. 73 549. 73 550. 12441 551. 12441 552. 15655 553. 15655 554. 14196 555. 8905 556. 249 557. 249 558. 644 559. 644 560. 9671 561. 196 562. 14578 563. 14577 564. 14579 565. 14580 566. 14581 567. 14582 568. 14583 569. 14584 570. 2104 571. 2105 572. 9189 573. 1190 574. 9188 575. 5291 576. 689 577. 1132 578. 9348 579. 9244 580. 9249 581. 9251 582. 9245 583. 16900 584. 15437 585. 15437 586. 14899 587. 343 588. 16336 589. 11159 590. 789 591. 852 592. 2151 593. 2152 594. 19227 595. 22175 596. 16709 597. 22586 598. 22586 599. 33181 600. 33181 601. 16710 602. 33180 603. 33180 604. 14251 605. 33983 606. 13245 607. 34380 608. 34383 609. 34381 610. 34382 611. 34384 612. 9247 613. 9248 614. 9246 615. 2731 616. 2732 617. 1082 618. 14403 619. 14403 620. 14403 621. 14403 622. 25838 623. 25980 624. 15327 625. 3386 626. 14444 627. 14443 628. 1390 629. 1391 630. 14198 631. 10498 632. 10497 633. 10496 634. 10503 635. 10502 636. 10501 637. 10500 638. 10499 639. 14083 640. 15644 641. 942 642. 15645 643. 17672 644. 15117 645. 15241 646. 15241 647. 23686 648. 23687 649. 23688 650. 23689 651. 24591 652. 24592 653. 24593 654. 24594 655. 25071 656. 56 657. 25727 658. 25727 659. 23988 660. 16952 661. 16952 662. 15966 663. 4122 664. 4728 665. 15288 666. 4994 667. 25746 668. 12609 669. 16870 670. 16870 671. 16871 672. 16871 673. 19555 674. 19555 675. 16926 676. 16926 677. 16926 678. 16926 679. 17975 680. 17975 681. 17975 682. 17975 683. 17975 684. 17975 685. 17975 686. 17975 687. 15289 688. 15289 689. 15419 690. 56 691. 27178 692. 27178 693. 27178 694. 27178 695. 27181 696. 27181 697. 27181 698. 27181 699. 27182 700. 27182 701. 27182 702. 27182 703. 27183 704. 27183 705. 27183 706. 27183 707. 27184 708. 27184 709. 27184 710. 27184 711. 27185 712. 27185 713. 27185 714. 27185 715. 8821 716. 12542 717. 11160 718. 14311 719. 8686 720. 8685 721. 8778 722. 8779 723. 8780 724. 8781 725. 8782 726. 1867 727. 18648 728. 18648 729. 18648 730. 18648 731. 18648 732. 18648 733. 18648 734. 18648 735. 14320 736. 625 737. 625 738. 27195 739. 29842 740. 13289 741. 13289 742. 13289 743. 13289 744. 13289 745. 12130 746. 16794 747. 451 748. 11163 749. 11163 750. 14435 751. 14435 752. 15631 753. 15631 754. 15631 755. 15631 756. 15631 757. 15631 758. 15631 759. 15631 760. 14198 761. 14198 762. 14198 763. 14198 764. 398 765. 398 766. 26461 767. 26461 768. 19538 769. 19538 770. 19539 771. 19539 772. 88 773. 88 774. 88 775. 12610 776. 176 777. 176 778. 27227 779. 14878 780. 14878 781. 14878 782. 27762 783. 36501 784. 36502 785. 36742 786. 14010 787. 17613 788. 13447 789. 16413 790. 16413 791. 19431 792. 19432 793. 27338 794. 17338 795. 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, 656, 658, 661, 700, 706, 715, 723, 745, 746, 747, 750, 752, 754, 755, 758, 762, 764, 766, 785, 789, 790, 795, 796, 801, 802, 803, 804, 806, 812, 813, 814, 815, 818, 822, 829, 903, 918, 926, 932, 942, 943, 989, 992, 1067, 1071, 1072, 1079, 1101, 1110, 1118, 1398, 1400, 1407, 1428, 1436, 1439, 1450, 1452, 1459, 1461, 1471, 1488, 1524, 1539, 1543, 1556, 1592, 1593, 1605, 1610, 1623, 1627, 1632, 1633, 1640, 1641, 1657, 1683, 1714, 1738, 1740, 1744, 1973, 2078, 2144, 2502, 2817)

2.72ms/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, 51, 55, 56, 75, 85, 86, 105, 111, 112, 127, 128, 133, 135, 137, 139, 140, 153, 163, 168, 172)

1.76ms/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, 51, 55, 56, 75, 85, 86, 105, 111, 112, 127, 128, 133, 135, 137, 139, 140, 153, 163, 168, 172)

1.87ms/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, 56, 61, 73, 88, 98, 104, 108, 149, 150, 154, 176, 196, 208, 209, 233, 235, 249, 255, 257, 259, 273, 309, 330, 343, 356, 360, 364, 370, 379, 387, 396, 397, 398, 414, 423, 451, 475, 523, 532, 542, 570, 581, 590, 593, 618, 625, 644, 652, 653, 689, 699, 717, 735, 763, 789, 797, 810, 824, 838, 844, 852, 867, 878, 907, 917, 921, 933, 938, 942, 950, 971, 987, 1016, 1082, 1109, 1117, 1124, 1125, 1132, 1134, 1151, 1185, 1190, 1194, 1307, 1384, 1390, 1391, 1484, 1498, 1546, 1547, 1570, 1595, 1611, 1612, 1731, 1732, 1774, 1794, 1804, 1839, 1867, 1883, 2026, 2104, 2105, 2147, 2151, 2152, 2167, 2214, 2223, 2239, 2240, 2245, 2317, 2381, 2415, 2435, 2488, 2495, 2561, 2562, 2580, 2588, 2602, 2606, 2643, 2652, 2686, 2705, 2730, 2731, 2732, 2772, 2800, 2834, 2900, 2926, 2929, 3026, 3069, 3070, 3071, 3082, 3084, 3095, 3099, 3102, 3138, 3168, 3200, 3202, 3266, 3268, 3276, 3279, 3358, 3386, 3454, 3483, 3518, 3557, 3579, 3581, 3621, 3791, 3819, 3820, 3859, 3888, 3929, 3983, 3989, 3992, 3995, 4009, 4122, 4131, 4133, 4139, 4140, 4141, 4147, 4285, 4426, 4550, 4593, 4728, 4994, 5177, 5178, 5179, 5211, 5284, 5291, 5367, 8685, 8686, 8763, 8765, 8771, 8772, 8774, 8778, 8779, 8780, 8781, 8782, 8783, 8796, 8821, 8905, 8917, 8965, 8969, 9078, 9085, 9087, 9138, 9182, 9183, 9188, 9189, 9199, 9231, 9232, 9235, 9244, 9245, 9246, 9247, 9248, 9249, 9251, 9348, 9434, 9508, 9602, 9665, 9671, 9786, 9806, 9816, 9839, 9840, 9874, 9886, 9887, 9891, 9893, 9894, 9903, 9909, 9945, 9953, 9979, 10133, 10134, 10166, 10196, 10197, 10274, 10275, 10486, 10489, 10496, 10497, 10498, 10499, 10500, 10501, 10502, 10503, 10505, 10559, 10567, 10745, 11156, 11157, 11158, 11159, 11160, 11163, 11168, 11329, 11376, 11381, 11382, 11425, 11453, 11485, 11588, 11593, 11599, 11644, 11822, 11829, 11874, 11884, 11885, 11886, 11927, 11937, 12015, 12016, 12018, 12095, 12130, 12140, 12141, 12160, 12380, 12542, 12595, 12609, 12610, 12894, 13019, 13028, 13143, 13165, 13227, 13230, 13245, 13289, 13447, 13448, 13467, 13476, 13478, 13506, 13509, 13519, 13520, 13860, 13861, 13871, 13872, 14010, 14076, 14083, 14163, 14196, 14198, 14243, 14251, 14269, 14278, 14291, 14311, 14312, 14320, 14403, 14435, 14443, 14444, 14577, 14578, 14579, 14580, 14581, 14582, 14583, 14584, 14585, 14586, 14587, 14588, 14622, 14779, 14780, 14782, 14783, 14787, 14816, 14829, 14847, 14864, 14878, 14899, 14915, 14934, 15083, 15093, 15117, 15185, 15228, 15241, 15288, 15289, 15292, 15301, 15327, 15419, 15437, 15487, 15576, 15577, 15581, 15593, 15631, 15644, 15645, 15655, 15729, 15741, 15748, 15757, 15894, 15895, 15896, 15924, 15943, 15944, 15945, 15959, 15962, 15966, 15971, 16170, 16191, 16194, 16215, 16217, 16261, 16267, 16268, 16291, 16292, 16317, 16322, 16336, 16339, 16367, 16402, 16413, 16422, 16424, 16425, 16426, 16427, 16563, 16607, 16637, 16706, 16709, 16710, 16794, 16849, 16870, 16871, 16900, 16926, 16952, 16956, 16957, 16968, 16969, 17158, 17176, 17181, 17185, 17197, 17338, 17374, 17468, 17471, 17477, 17478, 17479, 17480, 17481, 17482, 17505, 17506, 17508, 17613, 17672, 17851, 17975, 18025, 18041, 18172, 18178, 18214, 18223, 18648, 18688, 18736, 18737, 18866, 18903, 19064, 19155, 19227, 19228, 19431, 19432, 19481, 19496, 19517, 19538, 19539, 19555, 19715, 19748, 19785, 19794, 19797, 19928, 19963, 20628, 21059, 21060, 21234, 21291, 21643, 21644, 21645, 21646, 21647, 21648, 21649, 21650, 21984, 22145, 22175, 22300, 22313, 22314, 22318, 22467, 22586, 23404, 23406, 23412, 23424, 23686, 23687, 23688, 23689, 23988, 23996, 24023, 24079, 24118, 24506, 24591, 24592, 24593, 24594, 24686, 24751, 24752, 24825, 24928, 24948, 25071, 25503, 25504, 25617, 25661, 25727, 25746, 25838, 25884, 25885, 25944, 25960, 25970, 25980, 26413, 26461, 26467, 26660, 26864, 27178, 27181, 27182, 27183, 27184, 27185, 27195, 27227, 27338, 27762, 28006, 28012, 28453, 28454, 28455, 28650, 29518, 29519, 29576, 29595, 29842, 30422, 30703, 31358, 31575, 33180, 33181, 33983, 34380, 34381, 34382, 34383, 34384, 34986, 36501, 36502, 36742) order by `position` asc

156ms/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.74ms/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` = 12669 and `v2_members`.`deleted_at` is null

2.25ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 12669
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` = 18265 and `ctbuh_company`.`deleted_at` is null limit 11.67ms/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/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` = 18265 and `v2_members`.`deleted_at` is null

2.16ms/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/Http/Controllers/CtbuhCompanyController.php:696 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `v2_membership_levels` where `v2_membership_levels`.`id` = 13 limit 12.22msview::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.59ms/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.57ms/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.42ms/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.52ms/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.26ms/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.21ms/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.29ms/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.32ms/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: 4696
App\Country: 54
App\City: 93
App\Building: 616
App\CtbuhCompany: 17

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

path_info

/company/12669

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 => "skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQndZNDhTVm9YM2xWTmtnaG4raVBmc3VLRjlqVnBUZXlmb0FmQ2hKNkllZ2JVc1pyWk9ibzltR2k2SzJGVzVhYkkyNmJRSnUiLCJtYWMiOiI3Y2IzZTBjMTcyOGRkOTMyNjJjNTMxZjY4NWYzZTA4OGRlNjdhMGI1YmRkMDMzZjkwZmE1NGY5YmEwZGNlZDk3In0%3D; XSRF-TOKEN=eyJpdiI6Im5DR010ODNrN0NqOGExWHZoaXRiWEE9PSIsInZhbHVlIjoidjRuOGhkZElQbjNcL0JKdExKUVljZWJcL2czUXlPZ0FBYnF2ZFUwNnNHMWppNmNvczJ3aXNGb2ZCZDJGaXZvczlqaGs2eWZsUjZJc1RcL0NvUkUrYUVKWXdTajVadTJZd0tWTlM5UW5PenV2R2NVa2t6cjhpU1V4YnJnR29kVkFOOVAiLCJtYWMiOiI3YWJhM2FlMjU4ZDNmNWQ1M2UxZWMxZjczZjYyYjY0NGQ5Njc2NGE4YzMyOGU0ZjA3NTNlNDg2NjExZDkyMGE2In0%3D; visit_counter=eyJpdiI6ImZ1bDg3eDVvblZla2hDUFhuaFl1c1E9PSIsInZhbHVlIjoiWkw4UGpKMm5wem81WW5vbHRFenU3MUdSMllvdVpKekJxampYZDFqOG9BVTlMMnZRUWdPRVwvVDRIVWNONm1ZQXUiLCJtYWMiOiI2MWY1MzZjMTk3ODk3NjljYTI3MmMxMTQ4MDVlN2E4M2NlYjE3OWQyN2ViOWI1MWU3NzlmMGVhNjkxY2Y3NmI2In0%3D ◀skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQn ▶"
  ]
  "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" => "skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQndZNDhTVm9YM2xWTmtnaG4raVBmc3VLRjlqVnBUZXlmb0FmQ2hKNkllZ2JVc1pyWk9ibzltR2k2SzJGVzVhYkkyNmJRSnUiLCJtYWMiOiI3Y2IzZTBjMTcyOGRkOTMyNjJjNTMxZjY4NWYzZTA4OGRlNjdhMGI1YmRkMDMzZjkwZmE1NGY5YmEwZGNlZDk3In0%3D; XSRF-TOKEN=eyJpdiI6Im5DR010ODNrN0NqOGExWHZoaXRiWEE9PSIsInZhbHVlIjoidjRuOGhkZElQbjNcL0JKdExKUVljZWJcL2czUXlPZ0FBYnF2ZFUwNnNHMWppNmNvczJ3aXNGb2ZCZDJGaXZvczlqaGs2eWZsUjZJc1RcL0NvUkUrYUVKWXdTajVadTJZd0tWTlM5UW5PenV2R2NVa2t6cjhpU1V4YnJnR29kVkFOOVAiLCJtYWMiOiI3YWJhM2FlMjU4ZDNmNWQ1M2UxZWMxZjczZjYyYjY0NGQ5Njc2NGE4YzMyOGU0ZjA3NTNlNDg2NjExZDkyMGE2In0%3D; visit_counter=eyJpdiI6ImZ1bDg3eDVvblZla2hDUFhuaFl1c1E9PSIsInZhbHVlIjoiWkw4UGpKMm5wem81WW5vbHRFenU3MUdSMllvdVpKekJxampYZDFqOG9BVTlMMnZRUWdPRVwvVDRIVWNONm1ZQXUiLCJtYWMiOiI2MWY1MzZjMTk3ODk3NjljYTI3MmMxMTQ4MDVlN2E4M2NlYjE3OWQyN2ViOWI1MWU3NzlmMGVhNjkxY2Y3NmI2In0%3D ◀skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQn ▶"
  "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" => "28945"
  "REMOTE_ADDR" => "18.221.201.67"
  "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/12669"
  "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" => 1744765171.6636
  "REQUEST_TIME" => 1744765171
]

request_cookies

  0 of 0   
array:3 [▶
  "skyscraper_center_session" => "HcaUQXj9qVnxLXFQLFbnPGqp5ek8WlZtsHHazO3b"
  "XSRF-TOKEN" => "Jof6WPqbxFhTaRAX6IPsCavpxRfN4L4Hq8iEThxi"
  "visit_counter" => "3"
]

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, 16 Apr 2025 00:59:33 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZBUDZDRDF2UEo5b1pGVUdyWHJmNHc9PSIsInZhbHVlIjoiQmtcL0NPTmY0NFFuOHRNckltenlYdmMrZkpKT1wvZVY4eVVDR1c4UTFcL3dcL0g2dUVIRmlpbjVlSm5lbU1mU1F3XC9cL3M1QXBEK3RZaWtJZ2RaXC9Ed29cL2x1XC9EeTY0aEJPb3R4NWlJMktGa1BnNHd0bENrUmpHeitKOHVuVFhiVjhqbHkiLCJtYWMiOiIzNmQ3ODFjMTdmMjA5M2I2OWVkMTJlOGMzZmY2Njg0MmMxODM3ODhjYjhhZTdmN2UwOWY0YTRkMjA5MDRkNzg1In0%3D; expires=Wed, 16-Apr-2025 02:59:33 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZBUDZDRDF2UEo5b1pGVUdyWHJmNHc9PSIsInZhbHVlIjoiQmtcL0NPTmY0NFFuOHRNckltenlYdmMrZkpKT1wvZVY4eVVDR1c4UTFcL3dcL0g2dUVIRmlpbjVlSm5lbU1mU1F3XC9cL ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlVOUVhSeGRJUEJrQzQ3NjgxTE9hXC9nPT0iLCJ2YWx1ZSI6IkszTnV4VnVIUDJyb2x6WldZS0MxMThLNXdyZXdPY0w3azUzNzcxOHcxRjhYTGE4Qk9SOGFsbURHU3V2UGtDcmp0OEZmOHl0NW1MOVJRMlwvK2t0UXVVVzN3MUtQXC9XQU5TMWxBSEIxXC90RDVwanNKMWxBOU50VG1TTjZXRjRXUU5aIiwibWFjIjoiOGI2ODkyMGQ1MWQ3NWJhMjJmYmE2NjllYjRmZDhlYWEwNDI5NDQ4OTBhYWM1NWE3MDMzMzM2ZjI5MTllZDk1NyJ9; expires=Wed, 16-Apr-2025 02:59:33 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlVOUVhSeGRJUEJrQzQ3NjgxTE9hXC9nPT0iLCJ2YWx1ZSI6IkszTnV4VnVIUDJyb2x6WldZS0MxMThLNXdyZXdPY0w3azUzNzcxOHcxRjhYTGE4Qk9SOGFsbURHU3 ▶"
    2 => "visit_counter=eyJpdiI6IjRjVm5oM01FWExnZlwvTDBxQkVEODdRPT0iLCJ2YWx1ZSI6IlhkY0Rka1JqMWozMG9uNXRnSVZsQU1tcE5FQjRmcmtBYm1pR3JRNkxwNkdBbXRkRDREd1k1U1R4NHRHQUk5XC82IiwibWFjIjoiMzdkZjI5NGNjNGMzNDJkZThhNDljYmFhOGExZDlkYzExMDc4MTI5NGI2NDczYTAyYmEyMTdhYjRjMDVmYTk0NCJ9; expires=Fri, 16-May-2025 00:59:31 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6IjRjVm5oM01FWExnZlwvTDBxQkVEODdRPT0iLCJ2YWx1ZSI6IlhkY0Rka1JqMWozMG9uNXRnSVZsQU1tcE5FQjRmcmtBYm1pR3JRNkxwNkdBbXRkRDREd1k1U1R4NHRHQUk5XC82Ii ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZBUDZDRDF2UEo5b1pGVUdyWHJmNHc9PSIsInZhbHVlIjoiQmtcL0NPTmY0NFFuOHRNckltenlYdmMrZkpKT1wvZVY4eVVDR1c4UTFcL3dcL0g2dUVIRmlpbjVlSm5lbU1mU1F3XC9cL3M1QXBEK3RZaWtJZ2RaXC9Ed29cL2x1XC9EeTY0aEJPb3R4NWlJMktGa1BnNHd0bENrUmpHeitKOHVuVFhiVjhqbHkiLCJtYWMiOiIzNmQ3ODFjMTdmMjA5M2I2OWVkMTJlOGMzZmY2Njg0MmMxODM3ODhjYjhhZTdmN2UwOWY0YTRkMjA5MDRkNzg1In0%3D; expires=Wed, 16-Apr-2025 02:59:33 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlZBUDZDRDF2UEo5b1pGVUdyWHJmNHc9PSIsInZhbHVlIjoiQmtcL0NPTmY0NFFuOHRNckltenlYdmMrZkpKT1wvZVY4eVVDR1c4UTFcL3dcL0g2dUVIRmlpbjVlSm5lbU1mU1F3XC9cL ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlVOUVhSeGRJUEJrQzQ3NjgxTE9hXC9nPT0iLCJ2YWx1ZSI6IkszTnV4VnVIUDJyb2x6WldZS0MxMThLNXdyZXdPY0w3azUzNzcxOHcxRjhYTGE4Qk9SOGFsbURHU3V2UGtDcmp0OEZmOHl0NW1MOVJRMlwvK2t0UXVVVzN3MUtQXC9XQU5TMWxBSEIxXC90RDVwanNKMWxBOU50VG1TTjZXRjRXUU5aIiwibWFjIjoiOGI2ODkyMGQ1MWQ3NWJhMjJmYmE2NjllYjRmZDhlYWEwNDI5NDQ4OTBhYWM1NWE3MDMzMzM2ZjI5MTllZDk1NyJ9; expires=Wed, 16-Apr-2025 02:59:33 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlVOUVhSeGRJUEJrQzQ3NjgxTE9hXC9nPT0iLCJ2YWx1ZSI6IkszTnV4VnVIUDJyb2x6WldZS0MxMThLNXdyZXdPY0w3azUzNzcxOHcxRjhYTGE4Qk9SOGFsbURHU3 ▶"
    2 => "visit_counter=eyJpdiI6IjRjVm5oM01FWExnZlwvTDBxQkVEODdRPT0iLCJ2YWx1ZSI6IlhkY0Rka1JqMWozMG9uNXRnSVZsQU1tcE5FQjRmcmtBYm1pR3JRNkxwNkdBbXRkRDREd1k1U1R4NHRHQUk5XC82IiwibWFjIjoiMzdkZjI5NGNjNGMzNDJkZThhNDljYmFhOGExZDlkYzExMDc4MTI5NGI2NDczYTAyYmEyMTdhYjRjMDVmYTk0NCJ9; expires=Fri, 16-May-2025 00:59:31 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjRjVm5oM01FWExnZlwvTDBxQkVEODdRPT0iLCJ2YWx1ZSI6IlhkY0Rka1JqMWozMG9uNXRnSVZsQU1tcE5FQjRmcmtBYm1pR3JRNkxwNkdBbXRkRDREd1k1U1R4NHRHQUk5XC82Ii ▶"
  ]
]

session_attributes

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

WSP | Parsons Brinckerhoff

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

Renamed to:

Acquired companies:

Halvorson and Partners (2016) | Parsons Brinckerhoff Consultants Private Limited

Subsidiary companies:

Diseño Integral y Tecnología Aplicada SA de CV (2016) | WSP Structures | 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

Formerly Named:

WSP Group | Winward Structures

Buildings

1 x Application (99.39%)	1.77s
1 x Booting (0.6%)	10.75ms

View all results

WSP | Parsons Brinckerhoff

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

Renamed to:

WSP

Acquired companies:

Halvorson and Partners (2016) | Parsons Brinckerhoff Consultants Private Limited

Subsidiary companies:

Diseño Integral y Tecnología Aplicada SA de CV (2016) | WSP Structures | 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

Formerly Named:

WSP Group | Winward Structures

Buildings