DBI Design Pty Ltd

DBI is a member of the CTBUH at the Silver level.

Renamed to:

Formerly Named:

Buildings

Rank	Name	City	Completion	Height
1	Etihad Towers T2	Abu Dhabi	2011	305 m / 1,002 ft
2	Spirit	Gold Coast	-	298 m / 979 ft
3	Etihad Towers T1	Abu Dhabi	2011	278 m / 911 ft
4	The One	Brisbane	2020	264 m / 866 ft
5	Etihad Towers T3	Abu Dhabi	2011	260 m / 854 ft
6	Infinity	Brisbane	2014	249 m / 817 ft
7	Soleil	Brisbane	2012	243 m / 797 ft
8	Soul	Gold Coast	2012	243 m / 796 ft
9	Etihad Towers T4	Abu Dhabi	2011	234 m / 768 ft
10	Sapphire	Gold Coast	-	218 m / 714 ft
11	Etihad Towers T5	Abu Dhabi	2011	218 m / 714 ft
12	Jewel Hotel	Gold Coast	2019	170 m / 558 ft
13	The Dorsett and Star Residences	Gold Coast	2022	167 m / 548 ft
14	The Oracle Beach Tower	Gold Coast	2011	165 m / 542 ft
15	Yihwa International Residential Tower A	Taipei	2014	160 m / 525 ft
15	Yihwa International Residential Tower B	Taipei	2014	160 m / 525 ft
17	Yihwa International Hotel	Taipei	2014	150 m / 492 ft
18	Cassia Northpoint (North Tower)	Gold Coast	-	148 m / 486 ft
19	Jewel North Tower	Gold Coast	2019	144 m / 472 ft
20	The Macrossan	Brisbane	-	140 m / 459 ft
21	The Oracle Hinterland Tower	Gold Coast	2010	134 m / 441 ft
22	Qube Broadbeach	Gold Coast	2019	131 m / 430 ft
23	The Mantra Sun City	Gold Coast	1992	130 m / 427 ft
24	Rhapsody Surfers North	Gold Coast	2016	129 m / 423 ft
25	Keola Lai	Honolulu	2008	128 m / 419 ft
26	W Brisbane	Brisbane	2018	126 m / 414 ft
27	Jewel Beach Tower	Gold Coast	2019	124 m / 407 ft
28	Cassia Northpoint (South Tower)	Gold Coast	-	123 m / 404 ft
29	Avani Broadbeach Residences	Gold Coast	2018	112 m / 367 ft
30	The Wave	Gold Coast	2006	111 m / 364 ft
31	Dai-ichi Hotel Tokyo	Tokyo	1993	107 m / 352 ft
32	18 Remembrance Drive	Gold Coast	-	107 m / 351 ft
33	Carmel by the Sea	Gold Coast	1996	105 m / 344 ft
33	Nine O Nine Kapiolani	Honolulu	2007	105 m / 344 ft
35	Marriott Hotel Resort	Gold Coast	1992	105 m / 344 ft
36	Sapphire Tower 2	Gold Coast	-	100 m / 328 ft
36	Ultra Broadbeach	Gold Coast	2006	100 m / 328 ft
38	Mantra Sierra Grand	Gold Coast	2008	98 m / 322 ft
39	152 Wharf Street	Brisbane	-	97 m / 317 ft
40	26 Vista Street	Gold Coast	-	96 m / 315 ft
41	The Pinnacle	Gold Coast	2003	95 m / 312 ft
42	Verve Broadbeach	Gold Coast	2006	90 m / 295 ft
43	301-305 Kent Street	Sydney	-	88 m / 289 ft
44	Royal Pines Resort	Gold Coast	1986	85 m / 279 ft
45	Boardwalk	Gold Coast	2018	65 m / 213 ft
46	Waterline	Gold Coast	2005	62 m / 204 ft
47	Vi Residences	Gold Coast	-	- m / - ft
48	South City Square Stage 4+5 Tower B	Brisbane	-	- m / - ft
49	South City Square Stage 4+5 Tower A	Brisbane	-	- m / - ft
50	South City Square Stage 2	Brisbane	-	- m / - ft

1 2

Buildings per page:

Messages Timeline Exceptions Views13 Route Queries28 Models307 Mails Gate Session Request

7.3.33377ms10MBGET company/{id}

Booting (14.58ms)
Application (363ms)
1 x Application (96.11%)
362.51ms
1 x Booting (3.87%)
14.58ms

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 unique305ms

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

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

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

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

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

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

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

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

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

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

select `id` from `ctbuh_company` where `name` = 'DBI Design Pty Ltd' and `active` = '1'2.04ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. DBI Design Pty Ltd 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 (10939, 3371)4.58ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 10939 1. 3371
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 (8762, 5194, 19206, 13640, 13641, 13642, 19327, 947, 14073, 14074, 14072, 19619, 19649, 19657, 5204, 5241, 5218, 5233, 21485, 9629, 22550, 22915, 22916, 19330, 23947, 23948, 23949, 23950, 23951, 23952, 23953, 3384, 19627, 16701, 19983, 19614, 19614, 19614, 28606, 20192, 29236, 4545, 4537, 948, 25957, 19606, 26723, 15956, 13307, 23636, 15955, 35821, 19620, 19992, 22123, 22677, 22677, 26119) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

4.39ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 8762 3. 5194 4. 19206 5. 13640 6. 13641 7. 13642 8. 19327 9. 947 10. 14073 11. 14074 12. 14072 13. 19619 14. 19649 15. 19657 16. 5204 17. 5241 18. 5218 19. 5233 20. 21485 21. 9629 22. 22550 23. 22915 24. 22916 25. 19330 26. 23947 27. 23948 28. 23949 29. 23950 30. 23951 31. 23952 32. 23953 33. 3384 34. 19627 35. 16701 36. 19983 37. 19614 38. 19614 39. 19614 40. 28606 41. 20192 42. 29236 43. 4545 44. 4537 45. 948 46. 25957 47. 19606 48. 26723 49. 15956 50. 13307 51. 23636 52. 15955 53. 35821 54. 19620 55. 19992 56. 22123 57. 22677 58. 22677 59. 26119
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, 648, 655, 658, 1049, 1488, 1592)1.69ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (2, 11, 34, 82, 163)1.39ms/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, 11, 34, 82, 163)1.57ms/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 (947, 948, 3384, 4537, 4545, 5194, 5204, 5218, 5233, 5241, 8762, 9629, 13307, 13640, 13641, 13642, 14072, 14073, 14074, 15955, 15956, 16701, 19206, 19327, 19330, 19606, 19614, 19619, 19620, 19627, 19649, 19657, 19983, 19992, 20192, 21485, 22123, 22550, 22677, 22915, 22916, 23636, 23947, 23948, 23949, 23950, 23951, 23952, 23953, 25957, 26119, 26723, 28606, 35821) order by `position` asc

6.45ms/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.51ms/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` = 3371 and `v2_members`.`deleted_at` is null

2.15ms/app/CtbuhCompany.php:91buldingdb

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

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

2.63ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 20626
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.66msview::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.26ms/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.31ms/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.43ms/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.3ms/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.42ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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

1.28ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

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

1.17ms/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

3.89ms/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.88ms/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: 193
App\Country: 10
App\City: 7
App\Building: 54
App\CtbuhCompany: 4

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

path_info

/company/3371

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" => "18057"
  "REMOTE_ADDR" => "18.191.241.222"
  "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/3371"
  "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" => 1744995016.3273
  "REQUEST_TIME" => 1744995016
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 16:50:16 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikx5OHRJSU96a3ZqdnBCRzBTVUZVUFE9PSIsInZhbHVlIjoidnBZUmk2YThcL1NsZzZQczRzTDB2enp2V1l5VDVyaUNqU2c0ZmZQbHIzS25MdUwyd1VwanBqa1NhWGk5ckdTOWxUekEwb0ZcL1NJWm1PRzQ2eU5PVW0zMXhuWWI0eTlrSW8zTWpOTEdqS2gyXC9lVm8yK3BnanR4MGRFV2pNQzQ5WFMiLCJtYWMiOiJkNDU1ODE2MTk5MGIxYjBlM2U4MDU0NWY3MzFiYjg0NGQyMDkyNDIyYjYzYjY1NjBlNWVkZDEzOTBkYTVhZjI2In0%3D; expires=Fri, 18-Apr-2025 18:50:16 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx5OHRJSU96a3ZqdnBCRzBTVUZVUFE9PSIsInZhbHVlIjoidnBZUmk2YThcL1NsZzZQczRzTDB2enp2V1l5VDVyaUNqU2c0ZmZQbHIzS25MdUwyd1VwanBqa1NhWGk5ckdTOWxUekEwb ▶"
    1 => "skyscraper_center_session=eyJpdiI6InA0NWplU29Qb2JWVHVsTkk4RkJqM3c9PSIsInZhbHVlIjoiUXB1WTRSU3VJTGVabmR2UmJcL21jMTJCYUtwbWlHV2lETlBlUG1CK0JydVFnazFCSWdZeTZLbjhpbnV2M1JMMXFBbzR1M0JXakIrTEN0cGRqeHpNdU9lNW92RWJZSkxIM0xLbGpvT2xzRElzeFJuK0dtWnA5OFJCRTVMbk9GWmQ3IiwibWFjIjoiYzZkODBiYjQ3MTAwMzYyYTg5NGJiN2Y2ZDdmYTlmNjdlMTE0ZjZjYmMwMWQwOWFmYmNmMzE2YWY1ZDFmMWZmOCJ9; expires=Fri, 18-Apr-2025 18:50:16 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InA0NWplU29Qb2JWVHVsTkk4RkJqM3c9PSIsInZhbHVlIjoiUXB1WTRSU3VJTGVabmR2UmJcL21jMTJCYUtwbWlHV2lETlBlUG1CK0JydVFnazFCSWdZeTZLbjhpbn ▶"
    2 => "visit_counter=eyJpdiI6IlYrRzhyd2ZhaEhidm1hMDFzMTIzOUE9PSIsInZhbHVlIjoiVWgrZ1BJUnRTNm1cL1lPV0I3NVFMNWNFYzJXUmZqcFwvZkZOeVNhOHJ4MHBtbElGbktFd2RZdFZjazRLQk56Qnl0IiwibWFjIjoiNTI3ZTU2NjVhYzFhNzRiNzU4M2IzMDg2NjJmOGQ1MzRlNTYwMmIwYjgxOTNjOTQwNDhkOWYzMzk2ODI4ZDkyYSJ9; expires=Sun, 18-May-2025 16:50:16 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IlYrRzhyd2ZhaEhidm1hMDFzMTIzOUE9PSIsInZhbHVlIjoiVWgrZ1BJUnRTNm1cL1lPV0I3NVFMNWNFYzJXUmZqcFwvZkZOeVNhOHJ4MHBtbElGbktFd2RZdFZjazRLQk56Qnl0Ii ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ikx5OHRJSU96a3ZqdnBCRzBTVUZVUFE9PSIsInZhbHVlIjoidnBZUmk2YThcL1NsZzZQczRzTDB2enp2V1l5VDVyaUNqU2c0ZmZQbHIzS25MdUwyd1VwanBqa1NhWGk5ckdTOWxUekEwb0ZcL1NJWm1PRzQ2eU5PVW0zMXhuWWI0eTlrSW8zTWpOTEdqS2gyXC9lVm8yK3BnanR4MGRFV2pNQzQ5WFMiLCJtYWMiOiJkNDU1ODE2MTk5MGIxYjBlM2U4MDU0NWY3MzFiYjg0NGQyMDkyNDIyYjYzYjY1NjBlNWVkZDEzOTBkYTVhZjI2In0%3D; expires=Fri, 18-Apr-2025 18:50:16 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx5OHRJSU96a3ZqdnBCRzBTVUZVUFE9PSIsInZhbHVlIjoidnBZUmk2YThcL1NsZzZQczRzTDB2enp2V1l5VDVyaUNqU2c0ZmZQbHIzS25MdUwyd1VwanBqa1NhWGk5ckdTOWxUekEwb ▶"
    1 => "skyscraper_center_session=eyJpdiI6InA0NWplU29Qb2JWVHVsTkk4RkJqM3c9PSIsInZhbHVlIjoiUXB1WTRSU3VJTGVabmR2UmJcL21jMTJCYUtwbWlHV2lETlBlUG1CK0JydVFnazFCSWdZeTZLbjhpbnV2M1JMMXFBbzR1M0JXakIrTEN0cGRqeHpNdU9lNW92RWJZSkxIM0xLbGpvT2xzRElzeFJuK0dtWnA5OFJCRTVMbk9GWmQ3IiwibWFjIjoiYzZkODBiYjQ3MTAwMzYyYTg5NGJiN2Y2ZDdmYTlmNjdlMTE0ZjZjYmMwMWQwOWFmYmNmMzE2YWY1ZDFmMWZmOCJ9; expires=Fri, 18-Apr-2025 18:50:16 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InA0NWplU29Qb2JWVHVsTkk4RkJqM3c9PSIsInZhbHVlIjoiUXB1WTRSU3VJTGVabmR2UmJcL21jMTJCYUtwbWlHV2lETlBlUG1CK0JydVFnazFCSWdZeTZLbjhpbn ▶"
    2 => "visit_counter=eyJpdiI6IlYrRzhyd2ZhaEhidm1hMDFzMTIzOUE9PSIsInZhbHVlIjoiVWgrZ1BJUnRTNm1cL1lPV0I3NVFMNWNFYzJXUmZqcFwvZkZOeVNhOHJ4MHBtbElGbktFd2RZdFZjazRLQk56Qnl0IiwibWFjIjoiNTI3ZTU2NjVhYzFhNzRiNzU4M2IzMDg2NjJmOGQ1MzRlNTYwMmIwYjgxOTNjOTQwNDhkOWYzMzk2ODI4ZDkyYSJ9; expires=Sun, 18-May-2025 16:50:16 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IlYrRzhyd2ZhaEhidm1hMDFzMTIzOUE9PSIsInZhbHVlIjoiVWgrZ1BJUnRTNm1cL1lPV0I3NVFMNWNFYzJXUmZqcFwvZkZOeVNhOHJ4MHBtbElGbktFd2RZdFZjazRLQk56Qnl0Ii ▶"
  ]
]

session_attributes

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

1 x Application (96.11%)	362.51ms
1 x Booting (3.87%)	14.58ms

View all results