Rolf Jensen & Associates

Jensen Hughes is a member of the CTBUH at the Silver level.

Acquired by:

Subsidiary companies:

Buildings

Rank	Name	City	Completion	Height
1	Jeddah Tower	Jeddah	-	1000 m / 3,281 ft
2	Burj Khalifa	Dubai	2022	828 m / 2,717 ft
3	Suzhou Zhongnan Center	Suzhou	-	729 m / 2,392 ft
4	Wuhan Greenland Center	Wuhan	-	636 m / 2,087 ft
5	Shanghai Tower	Shanghai	2015	632 m / 2,073 ft
6	Shanghai World Financial Center	Shanghai	2008	492 m / 1,614 ft
7	Wuhan Greenland Center	Wuhan	-	476 m / 1,560 ft
8	Chengdu Greenland Tower	Chengdu	2022	468 m / 1,535 ft
9	R&F Guangdong Building	Tianjin	-	468 m / 1,535 ft
10	Petronas Twin Tower 1	Kuala Lumpur	1998	452 m / 1,483 ft
10	Petronas Twin Tower 2	Kuala Lumpur	1998	452 m / 1,483 ft
12	Zifeng Tower	Nanjing	2010	450 m / 1,476 ft
13	Jin Mao Tower	Shanghai	1999	421 m / 1,380 ft
14	Two International Finance Centre	Hong Kong	2003	412 m / 1,352 ft
15	Nanjing Olympic Suning Tower	Nanjing	-	400 m / 1,312 ft
16	PIF Tower	Riyadh	2020	385 m / 1,263 ft
17	Bank of China Tower	Hong Kong	1990	367 m / 1,205 ft
18	OKO - Residential Tower	Moscow	2015	354 m / 1,162 ft
19	Pearl River Tower	Guangzhou	2013	309 m / 1,015 ft
20	Cayan Tower	Dubai	2013	306 m / 1,005 ft
21	Jiangxi Nanchang Greenland Zifeng Tower	Nanchang	2015	268 m / 879 ft
22	FKI Tower	Seoul	2013	246 m / 805 ft
23	Global Harbor North Tower	Shanghai	2014	245 m / 804 ft
23	Global Harbor South Tower	Shanghai	2014	245 m / 804 ft
25	OKO - Office Tower	Moscow	2015	225 m / 736 ft
26	Shanghai Stock Exchange of Shanghai International Financial Center	Shanghai	2019	215 m / 705 ft
27	1322 Golden Empire Tower	Manila	2002	203 m / 666 ft
28	Oriental Financial Center	Shanghai	2014	199 m / 653 ft
29	SOCAR Tower	Baku	2015	196 m / 643 ft
30	China Financial Futures Exchange of Shanghai International Financial Center	Shanghai	2019	195 m / 640 ft
31	Chengdu Greenland Center Tower 2	Chengdu	2020	173 m / 568 ft
32	Chengdu Greenland Center Tower 3	Chengdu	2020	166 m / 545 ft
33	United Nations Secretariat Building	New York City	1953	154 m / 506 ft
34	China Securities Depository and Clearing Corporation of Shanghai International Financial Center	Shanghai	2019	152 m / 499 ft
35	The Collection	Honolulu	2016	129 m / 422 ft
36	Waihonua at Kewalo	Honolulu	2015	127 m / 418 ft
37	Three Nationwide Plaza	Columbus	1988	124 m / 408 ft
38	Northwestern Medicine 259 East Erie	Chicago	2014	118 m / 385 ft
39	W Atlanta-Midtown	Atlanta	1974	95 m / 310 ft
40	The John and Frances Angelos Law Center	Baltimore	2013	71 m / 231 ft
41	U.S. Embassy, London	London	2018	65 m / 214 ft
42	GEMS World Academy - Chicago, Lower School	Chicago	2014	47 m / 156 ft

Buildings per page:

Messages Timeline Exceptions Views13 Route Queries28 Models679 Mails Gate Session Request

7.3.33360ms11MBGET company/{id}

Booting (9.4ms)
Application (351ms)
1 x Application (97.36%)
350.89ms
1 x Booting (2.61%)
9.40ms

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

28 statements were executed, 4 of which were duplicated, 24 unique296ms

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

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

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

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

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

Metadata
Bindings	0. 7894
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 = '7894' 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 `id` from `ctbuh_company` where `name` = 'Rolf Jensen & Associates' and `active` = '1'2.04ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Rolf Jensen & Associates 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 (7894, 6934)1.84ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 7894 1. 6934
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 (154, 15944, 15945, 16906, 8829, 17463, 12629, 12875, 18245, 12845, 16679, 16680, 3737, 3737, 12845, 10293, 14243, 12692, 12693, 15707, 13773, 56, 3, 131, 464, 454, 15943, 2606, 19748, 2, 149, 150, 165, 189, 205, 8774, 287, 9671, 33983, 1601, 36434, 36435, 3, 363, 12025, 16359, 464, 15232, 24688) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

4.45ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 154 3. 15944 4. 15945 5. 16906 6. 8829 7. 17463 8. 12629 9. 12875 10. 18245 11. 12845 12. 16679 13. 16680 14. 3737 15. 3737 16. 12845 17. 10293 18. 14243 19. 12692 20. 12693 21. 15707 22. 13773 23. 56 24. 3 25. 131 26. 464 27. 454 28. 15943 29. 2606 30. 19748 31. 2 32. 149 33. 150 34. 165 35. 189 36. 205 37. 8774 38. 287 39. 9671 40. 33983 41. 1601 42. 36434 43. 36435 44. 3 45. 363 46. 12025 47. 16359 48. 464 49. 15232 50. 24688
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 (630, 661, 746, 752, 766, 776, 789, 795, 802, 806, 813, 942, 1072, 1118, 1399, 1439, 1450, 1452, 1509, 1514, 1539, 1545, 1592, 1641)

2.58ms/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, 13, 34, 56, 85, 112, 127, 135, 137, 163)1.34ms/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, 13, 34, 56, 85, 112, 127, 135, 137, 163)1.31ms/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 (2, 3, 56, 131, 149, 150, 154, 165, 189, 205, 287, 363, 454, 464, 1601, 2606, 3737, 8774, 8829, 9671, 10293, 12025, 12629, 12692, 12693, 12845, 12875, 13773, 14243, 15232, 15707, 15943, 15944, 15945, 16359, 16679, 16680, 16906, 17463, 19748, 24688, 33983) order by `position` asc

6ms/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.41ms/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` = 6934 and `v2_members`.`deleted_at` is null

1.6ms/app/CtbuhCompany.php:91buldingdb

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

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

2.62ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 10080
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/CtbuhCompany.php:96 21. /app/CtbuhCompany.php:288 22. /app/Http/Controllers/CtbuhCompanyController.php:696 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `v2_membership_levels` where `v2_membership_levels`.`id` = 15 limit 11.28msview::companies.partials.display-non-member:14buldingdb

Metadata
Bindings	0. 15
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. view::companies.partials.display-non-member:14 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 24. /vendor/laravel/framework/src/Illuminate/View/View.php:143 25. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null1.22ms/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.24ms/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.23ms/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.24ms/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.22ms/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.27ms/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.14ms/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.11ms/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: 550
App\Country: 20
App\City: 24
App\Building: 42
App\CtbuhCompany: 4

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

path_info

/company/6934

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" => "29364"
  "REMOTE_ADDR" => "3.141.46.110"
  "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/6934"
  "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" => 1744563927.6272
  "REQUEST_TIME" => 1744563927
]

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 => "Sun, 13 Apr 2025 17:05:27 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklncEVBUDY5cjUwMVB3bHpwV1dqOWc9PSIsInZhbHVlIjoiazJEODJLREd0RFQ5RTFVQ2w5Znl1WHBOOVVZK3haOE4yeUp1UmpkV3FmXC9LU0QyODVKQVlkUXp2enFFeXEwY3pJOEl5THptcjBLQVdCRVQxQVU1K3RoOXNoMTlVOEpBUHdMUVJaNEg2T0RwOW1MNXhFajY4QjZBNFZvVnZiWVwveCIsIm1hYyI6IjQxOGUyYjY0OTM0NTU2MjliMTQ3ZjAyM2I2NjIxNGI4MDhiM2RmNWE5MzhhMTcyN2FlYTc5NDM5MDYwMjM3OTIifQ%3D%3D; expires=Sun, 13-Apr-2025 19:05:27 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IklncEVBUDY5cjUwMVB3bHpwV1dqOWc9PSIsInZhbHVlIjoiazJEODJLREd0RFQ5RTFVQ2w5Znl1WHBOOVVZK3haOE4yeUp1UmpkV3FmXC9LU0QyODVKQVlkUXp2enFFeXEwY3pJOEl5T ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkpCUnM4SHVyYkdlSU1JQTJ6cUkrSHc9PSIsInZhbHVlIjoiMEFBeVVvZmE4a3FVNlRmZ2s0MXdjUHNBNHhaNWNLK2pRZndsNlVwWklzekw4bjhVNVk0bGlrYnlwaVZrR2hPVWdTSTFDZ0IzM0JkbmV3Slh4KzgyVkZCQTJuaFdnM0ZLS29Pb3RNVzJVR05IVWlMSmd1R2VTeVozUzJkQmxqaEMiLCJtYWMiOiIyZDQ3MDJkMTQwNDgzNTFjYWM3NmRhNjFiYmZjODlhOTY3MGJmZTIyZmQ3ODkwNDBmNzdmMjFmODVlOTlmYTYxIn0%3D; expires=Sun, 13-Apr-2025 19:05:27 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkpCUnM4SHVyYkdlSU1JQTJ6cUkrSHc9PSIsInZhbHVlIjoiMEFBeVVvZmE4a3FVNlRmZ2s0MXdjUHNBNHhaNWNLK2pRZndsNlVwWklzekw4bjhVNVk0bGlrYnlwaV ▶"
    2 => "visit_counter=eyJpdiI6ImFXMUFsa1B5T3p3QXhTQjlPdVRMTlE9PSIsInZhbHVlIjoiWGdMV1Y1dFRpck5vaHRjVWxzcU5qQzJzR0lnMlZ2bjNpdTBTWnQrNFJybit6a3ZLYXh5cW5YOUVLNW1rXC9SekkiLCJtYWMiOiJhMjBjYTUyOGRlN2Q3OTcyZTllZGFmNTRmYzhkZDcwN2U3MDc0OTZkZDU1YmZjZDNlZmM1NzVkMDNhNGVlOTU0In0%3D; expires=Tue, 13-May-2025 17:05:27 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6ImFXMUFsa1B5T3p3QXhTQjlPdVRMTlE9PSIsInZhbHVlIjoiWGdMV1Y1dFRpck5vaHRjVWxzcU5qQzJzR0lnMlZ2bjNpdTBTWnQrNFJybit6a3ZLYXh5cW5YOUVLNW1rXC9SekkiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IklncEVBUDY5cjUwMVB3bHpwV1dqOWc9PSIsInZhbHVlIjoiazJEODJLREd0RFQ5RTFVQ2w5Znl1WHBOOVVZK3haOE4yeUp1UmpkV3FmXC9LU0QyODVKQVlkUXp2enFFeXEwY3pJOEl5THptcjBLQVdCRVQxQVU1K3RoOXNoMTlVOEpBUHdMUVJaNEg2T0RwOW1MNXhFajY4QjZBNFZvVnZiWVwveCIsIm1hYyI6IjQxOGUyYjY0OTM0NTU2MjliMTQ3ZjAyM2I2NjIxNGI4MDhiM2RmNWE5MzhhMTcyN2FlYTc5NDM5MDYwMjM3OTIifQ%3D%3D; expires=Sun, 13-Apr-2025 19:05:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IklncEVBUDY5cjUwMVB3bHpwV1dqOWc9PSIsInZhbHVlIjoiazJEODJLREd0RFQ5RTFVQ2w5Znl1WHBOOVVZK3haOE4yeUp1UmpkV3FmXC9LU0QyODVKQVlkUXp2enFFeXEwY3pJOEl5T ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkpCUnM4SHVyYkdlSU1JQTJ6cUkrSHc9PSIsInZhbHVlIjoiMEFBeVVvZmE4a3FVNlRmZ2s0MXdjUHNBNHhaNWNLK2pRZndsNlVwWklzekw4bjhVNVk0bGlrYnlwaVZrR2hPVWdTSTFDZ0IzM0JkbmV3Slh4KzgyVkZCQTJuaFdnM0ZLS29Pb3RNVzJVR05IVWlMSmd1R2VTeVozUzJkQmxqaEMiLCJtYWMiOiIyZDQ3MDJkMTQwNDgzNTFjYWM3NmRhNjFiYmZjODlhOTY3MGJmZTIyZmQ3ODkwNDBmNzdmMjFmODVlOTlmYTYxIn0%3D; expires=Sun, 13-Apr-2025 19:05:27 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkpCUnM4SHVyYkdlSU1JQTJ6cUkrSHc9PSIsInZhbHVlIjoiMEFBeVVvZmE4a3FVNlRmZ2s0MXdjUHNBNHhaNWNLK2pRZndsNlVwWklzekw4bjhVNVk0bGlrYnlwaV ▶"
    2 => "visit_counter=eyJpdiI6ImFXMUFsa1B5T3p3QXhTQjlPdVRMTlE9PSIsInZhbHVlIjoiWGdMV1Y1dFRpck5vaHRjVWxzcU5qQzJzR0lnMlZ2bjNpdTBTWnQrNFJybit6a3ZLYXh5cW5YOUVLNW1rXC9SekkiLCJtYWMiOiJhMjBjYTUyOGRlN2Q3OTcyZTllZGFmNTRmYzhkZDcwN2U3MDc0OTZkZDU1YmZjZDNlZmM1NzVkMDNhNGVlOTU0In0%3D; expires=Tue, 13-May-2025 17:05:27 GMT; path=/; httponly ◀visit_counter=eyJpdiI6ImFXMUFsa1B5T3p3QXhTQjlPdVRMTlE9PSIsInZhbHVlIjoiWGdMV1Y1dFRpck5vaHRjVWxzcU5qQzJzR0lnMlZ2bjNpdTBTWnQrNFJybit6a3ZLYXh5cW5YOUVLNW1rXC9SekkiLC ▶"
  ]
]

session_attributes

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

1 x Application (97.36%)	350.89ms
1 x Booting (2.61%)	9.40ms

View all results