Mirvac Developments

Mirvac Construction is a member of the CTBUH at the Silver level.

Subsidiary of:

Mirvac Group

Buildings

Rank	Name	City	Completion	Height
1	Olderfleet	Melbourne	2020	165 m / 541 ft
2	Harbourside	Sydney	-	163 m / 535 ft
3	The EY Centre	Sydney	2016	155 m / 509 ft
4	David Malcolm Justice Centre	Perth	2015	149 m / 489 ft
5	80 Ann Street	Brisbane	2022	143 m / 468 ft
6	Quay West Apartments	Sydney	1991	142 m / 466 ft
7	8 Chifley	Sydney	2013	141 m / 461 ft
8	Voyager	Melbourne	2021	138 m / 453 ft
9	Era	Sydney	2013	136 m / 446 ft
10	Yarra's Edge 5	Melbourne	2005	134 m / 440 ft
11	St Leonards Square (The Jackson)	Sydney	2019	133 m / 436 ft
12	St Martins Tower	Sydney	1975	133 m / 436 ft
13	Sofitel Sydney Darling Harbour	Sydney	2017	132 m / 433 ft
14	Pavilions	Sydney	2020	120 m / 394 ft
15	Optus Plaza	Sydney	1992	120 m / 394 ft
16	Macquarie Bank	Sydney	1977	118 m / 387 ft
17	Forge Apartments	Melbourne	2017	100 m / 328 ft
18	Lucid	Brisbane	2018	99 m / 324 ft
19	St Leonards Square (The William)	Sydney	2019	98 m / 322 ft
20	Ovo	Sydney	2018	96 m / 315 ft
21	Epica	Sydney	2005	96 m / 315 ft
22	Yarra's Edge 1	Melbourne	2002	96 m / 315 ft
23	Yarra Point	Melbourne	2013	96 m / 315 ft
24	The Sebel	Brisbane	1999	94 m / 308 ft
25	472 Pacific Highway Tower 2	Sydney	-	91 m / 299 ft
26	Grosvenor Apartments	Brisbane	1998	90 m / 295 ft
27	The Pinnacle	Sydney	2013	88 m / 289 ft
28	Arthouse	Brisbane	2017	87 m / 286 ft
29	377-495 Botany Road (Tower 8C)	Sydney	-	87 m / 285 ft
30	Channel 10 Tower	Melbourne	1988	83 m / 272 ft
31	377-495 Botany Road (Tower 19A)	Sydney	-	77 m / 251 ft
32	Altura	Sydney	2003	75 m / 246 ft
33	Macquarie Apartments	Sydney	2000	71 m / 233 ft
34	Encore	Sydney	2003	65 m / 213 ft
35	71-79 Macquarie Street	Sydney	-	64 m / 210 ft
36	Century Plaza	Sydney	1980	62 m / 203 ft
37	McCaffery Apartments	Newcastle	2011	53 m / 174 ft
38	60 Marcus Clarke Street	Canberra	1988	52 m / 171 ft
39	The Eastbourne	Melbourne	2017	50 m / 164 ft
40	Tower 10	Melbourne	-	- m / - ft
41	Shore Stage 1	Brisbane	-	- m / - ft
42	Evelyn Tower 1	Brisbane	-	- m / - ft
43	Shore Stage 2	Brisbane	-	- m / - ft
44	Evelyn Tower 2	Brisbane	-	- m / - ft

Buildings per page:

Messages Timeline Exceptions Views12 Route Queries27 Models428 Mails Gate Session Request

7.3.33294ms10MBGET company/{id}

Booting (7.54ms)
Application (286ms)
1 x Application (97.4%)
286.05ms
1 x Booting (2.57%)
7.54ms

12 templates were rendered

companies.partials.display-non-member (resources/views/companies/partials/display-non-member.blade.php)8blade
Params
0
company
1
parentMember
2
associatedCompanies
3
buildings
4
statuses
5
title
6
allBuildingStatuses
7
accessLevel

Params
0	`company`
1	`parentMember`
2	`associatedCompanies`
3	`buildings`
4	`statuses`
5	`title`
6	`allBuildingStatuses`
7	`accessLevel`

companies.partials.element.nonMemberItems (resources/views/companies/partials/element/nonMemberItems.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)23blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
tableId
paginate
search
displayComplexTable
maxItems
displayFull

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`tableId`
18	`paginate`
19	`search`
20	`displayComplexTable`
21	`maxItems`
22	`displayFull`

layouts.SSC-standard (resources/views/layouts/SSC-standard.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

layouts.SSC (resources/views/layouts/SSC.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

common.header (resources/views/common/header.blade.php)19blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)19php


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)21php


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav
item
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`
19	`item`
20	`child`

common.footer (resources/views/common/footer.blade.php)18blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)18blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)20blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)20blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

uri: GET company/{id}
middleware: web
controller: App\Http\Controllers\CtbuhCompanyController@display
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/CtbuhCompanyController.php:27-708

27 statements were executed, 6 of which were duplicated, 21 unique236ms

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

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

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

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

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

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

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

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

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

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

select `id` from `ctbuh_company` where `name` = 'Mirvac Developments' and `active` = '1'1.29ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Mirvac Developments 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 (3110, 3110)1.53ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 3110 1. 3110
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 (19315, 19317, 19316, 19516, 17579, 19893, 16551, 22423, 13394, 24595, 13404, 13404, 19882, 13491, 19794, 25965, 25973, 17338, 26980, 13649, 1890, 1890, 28301, 22422, 16550, 28616, 28617, 13487, 28917, 14211, 30664, 30669, 30670, 15533, 28631, 22821, 4243, 13345, 13342, 32369, 25052, 27864, 27865, 28415, 25505, 33022, 13290, 13290, 34600, 19355, 28410, 22821) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

3.66ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 19315 3. 19317 4. 19316 5. 19516 6. 17579 7. 19893 8. 16551 9. 22423 10. 13394 11. 24595 12. 13404 13. 13404 14. 19882 15. 13491 16. 19794 17. 25965 18. 25973 19. 17338 20. 26980 21. 13649 22. 1890 23. 1890 24. 28301 25. 22422 26. 16550 27. 28616 28. 28617 29. 13487 30. 28917 31. 14211 32. 30664 33. 30669 34. 30670 35. 15533 36. 28631 37. 22821 38. 4243 39. 13345 40. 13342 41. 32369 42. 25052 43. 27864 44. 27865 45. 28415 46. 25505 47. 33022 48. 13290 49. 13290 50. 34600 51. 19355 52. 28410 53. 22821
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	14. /app/CtbuhCompany.php:336 15. /app/Http/Controllers/CtbuhCompanyController.php:52 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_cities` where `v2_cities`.`id` in (648, 649, 653, 656, 658, 2364)1.37ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11)1.38ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb

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

select * from `v2_countries` where `v2_countries`.`id` in (11)1.26ms/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 (1890, 4243, 13290, 13342, 13345, 13394, 13404, 13487, 13491, 13649, 14211, 15533, 16550, 16551, 17338, 19316, 19355, 19516, 19794, 19882, 19893, 22422, 22423, 22821, 24595, 25052, 25505, 25965, 25973, 26980, 27864, 27865, 28410, 28415, 28616, 28617, 28631, 28917, 30664, 30669, 30670, 32369, 33022, 34600) order by `position` asc

10.22ms/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.48ms/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` = 3110 and `v2_members`.`deleted_at` is null

3.57ms/app/CtbuhCompany.php:91buldingdb

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

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

1.9ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 19477
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.57msview::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.63ms/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.47ms/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.3ms/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.36ms/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.3ms/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.18ms/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.19ms/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.33ms/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.28ms/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: 334
App\Country: 2
App\City: 6
App\Building: 44
App\CtbuhCompany: 3

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

path_info

/company/3110

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/3110"
  "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.7379
  "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:17 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkozMkZqbDlrUnVVMjZoYVl2aUFzaEE9PSIsInZhbHVlIjoiY0ZkUXVVaU1mVmhBRGlQU21zS29mM21weFh6ZFFOSXh5aTZhenZvRjFleGZRM2t1RVBjZXNYK0h6U0U4N3lIUmtmaEg4azd3UmptdjVxa21xT3o2STJcL2c2WUdPRkVrejFMOWdCNTVVTEJZaStaVTVkZ0RWSlwvTmptcStZdktHbyIsIm1hYyI6ImQ3ODU4YjhjNmIwNDc4NjYxZjhhYWE4M2Y4ZjAxOTNhODQ5MTczMTk3NzI4NzViODQzOWZhZDI5YTkyODM0NzEifQ%3D%3D; expires=Fri, 18-Apr-2025 18:50:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IkozMkZqbDlrUnVVMjZoYVl2aUFzaEE9PSIsInZhbHVlIjoiY0ZkUXVVaU1mVmhBRGlQU21zS29mM21weFh6ZFFOSXh5aTZhenZvRjFleGZRM2t1RVBjZXNYK0h6U0U4N3lIUmtmaEg4a ▶"
    1 => "skyscraper_center_session=eyJpdiI6IllxM0NEWGZDOGZkWGJlMUp4WGdmRnc9PSIsInZhbHVlIjoidGNTeVlaNDh4WitaME1wRDhFXC9QVU9kOThZZ1RkWE9vdVV1eWM0a2J3cTFmazhUQUx5U25xejUyTDFydmdIZm12aHlBNDl1SmN5UnJXRnVJUmJEXC9RVWpKNlpGOWtTQUk4K3ZGOWM3S2c1XC94YlhFSEdOZkpyVlN3YnlJN2ZZQWciLCJtYWMiOiI3NTJjZjc3NGM1NjFkYzViMTk5YzU3ZGNiYjU3N2UxNGY3ODdiZGY3OTkwODU3YTQ0MzY1ZDhlOTI3MjFjOGMyIn0%3D; expires=Fri, 18-Apr-2025 18:50:17 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IllxM0NEWGZDOGZkWGJlMUp4WGdmRnc9PSIsInZhbHVlIjoidGNTeVlaNDh4WitaME1wRDhFXC9QVU9kOThZZ1RkWE9vdVV1eWM0a2J3cTFmazhUQUx5U25xejUyTD ▶"
    2 => "visit_counter=eyJpdiI6InAwdTF1UHFWQmc4bXhOYjZ3RnJkRnc9PSIsInZhbHVlIjoiUTRSVWU2MW1ic1Y3V3JyXC9xMWkrdlZjakx3c1FcL2wySTFiWXA4UVl4Wk1NM3U3OHBVV09YS2xSbmJHQURDV1k1IiwibWFjIjoiOGZiNGRiNTEwN2U2YzNhOTRhNmI1ODdlNDdlNjk0MGJjZjIwMjA0M2Q2ODBiZWZmMjJmYjQ1ZGRkMWFkODA1OCJ9; expires=Sun, 18-May-2025 16:50:16 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6InAwdTF1UHFWQmc4bXhOYjZ3RnJkRnc9PSIsInZhbHVlIjoiUTRSVWU2MW1ic1Y3V3JyXC9xMWkrdlZjakx3c1FcL2wySTFiWXA4UVl4Wk1NM3U3OHBVV09YS2xSbmJHQURDV1k1Ii ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkozMkZqbDlrUnVVMjZoYVl2aUFzaEE9PSIsInZhbHVlIjoiY0ZkUXVVaU1mVmhBRGlQU21zS29mM21weFh6ZFFOSXh5aTZhenZvRjFleGZRM2t1RVBjZXNYK0h6U0U4N3lIUmtmaEg4azd3UmptdjVxa21xT3o2STJcL2c2WUdPRkVrejFMOWdCNTVVTEJZaStaVTVkZ0RWSlwvTmptcStZdktHbyIsIm1hYyI6ImQ3ODU4YjhjNmIwNDc4NjYxZjhhYWE4M2Y4ZjAxOTNhODQ5MTczMTk3NzI4NzViODQzOWZhZDI5YTkyODM0NzEifQ%3D%3D; expires=Fri, 18-Apr-2025 18:50:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkozMkZqbDlrUnVVMjZoYVl2aUFzaEE9PSIsInZhbHVlIjoiY0ZkUXVVaU1mVmhBRGlQU21zS29mM21weFh6ZFFOSXh5aTZhenZvRjFleGZRM2t1RVBjZXNYK0h6U0U4N3lIUmtmaEg4a ▶"
    1 => "skyscraper_center_session=eyJpdiI6IllxM0NEWGZDOGZkWGJlMUp4WGdmRnc9PSIsInZhbHVlIjoidGNTeVlaNDh4WitaME1wRDhFXC9QVU9kOThZZ1RkWE9vdVV1eWM0a2J3cTFmazhUQUx5U25xejUyTDFydmdIZm12aHlBNDl1SmN5UnJXRnVJUmJEXC9RVWpKNlpGOWtTQUk4K3ZGOWM3S2c1XC94YlhFSEdOZkpyVlN3YnlJN2ZZQWciLCJtYWMiOiI3NTJjZjc3NGM1NjFkYzViMTk5YzU3ZGNiYjU3N2UxNGY3ODdiZGY3OTkwODU3YTQ0MzY1ZDhlOTI3MjFjOGMyIn0%3D; expires=Fri, 18-Apr-2025 18:50:17 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IllxM0NEWGZDOGZkWGJlMUp4WGdmRnc9PSIsInZhbHVlIjoidGNTeVlaNDh4WitaME1wRDhFXC9QVU9kOThZZ1RkWE9vdVV1eWM0a2J3cTFmazhUQUx5U25xejUyTD ▶"
    2 => "visit_counter=eyJpdiI6InAwdTF1UHFWQmc4bXhOYjZ3RnJkRnc9PSIsInZhbHVlIjoiUTRSVWU2MW1ic1Y3V3JyXC9xMWkrdlZjakx3c1FcL2wySTFiWXA4UVl4Wk1NM3U3OHBVV09YS2xSbmJHQURDV1k1IiwibWFjIjoiOGZiNGRiNTEwN2U2YzNhOTRhNmI1ODdlNDdlNjk0MGJjZjIwMjA0M2Q2ODBiZWZmMjJmYjQ1ZGRkMWFkODA1OCJ9; expires=Sun, 18-May-2025 16:50:16 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InAwdTF1UHFWQmc4bXhOYjZ3RnJkRnc9PSIsInZhbHVlIjoiUTRSVWU2MW1ic1Y3V3JyXC9xMWkrdlZjakx3c1FcL2wySTFiWXA4UVl4Wk1NM3U3OHBVV09YS2xSbmJHQURDV1k1Ii ▶"
  ]
]

session_attributes

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

1 x Application (97.4%)	286.05ms
1 x Booting (2.57%)	7.54ms

View all results