Heerim Architects & Planners

Rank	Name	City	Completion	Height
1	Busan Lotte Town Tower	Busan	-	510 m / 1,674 ft
2	Legacy Tower	Dhaka	-	465 m / 1,526 ft
3	Keangnam Hanoi Landmark Tower	Hanoi	2012	329 m / 1,078 ft
4	Liberation Tower	Dhaka	-	328 m / 1,076 ft
5	Northeast Asia Trade Tower	Incheon	2011	305 m / 1,001 ft
6	Language Tower	Dhaka	-	259 m / 850 ft
7	The Crescent City	Baku	2020	210 m / 689 ft
8	SOCAR Tower	Baku	2015	196 m / 643 ft
9	Cheongna Posco The Lake Park 2801	Incheon	2013	190 m / 623 ft
10	Cheongna Posco The Lake Park 2802	Incheon	2013	180 m / 591 ft
10	Cheongna Posco The Lake Park 2803	Incheon	2013	180 m / 591 ft
10	Cheongna Posco The Lake Park 2804	Incheon	2013	180 m / 591 ft
13	Kookman Bank Headquarters	Seoul	-	172 m / 563 ft
14	Full Moon Rising	Baku	-	159 m / 521 ft
15	Yongsan 2 District Tower 1	Seoul	-	158 m / 518 ft
16	Yongsan 2 District Tower 2	Seoul	-	155 m / 510 ft
17	Gangbuk 2 District Mixed-Use A	Seoul	-	154 m / 504 ft
17	Gangbuk 2 District Mixed-Use B	Seoul	-	154 m / 504 ft
19	Co-op Starclass Residential Complex Tower 1	Seoul	2010	150 m / 493 ft
20	Glostar Center Tower 1	Seoul	2010	148 m / 486 ft
20	Glostar Center Tower 2	Seoul	2010	148 m / 486 ft
22	EVN Headquarters Tower 1	Hanoi	2013	147 m / 482 ft
23	Co-op Starclass Residential Complex Tower 2	Seoul	2010	144 m / 472 ft
24	EVN Headquarters Tower 2	Hanoi	2013	126 m / 413 ft
25	Azersu Office Tower	Baku	2018	124 m / 407 ft
26	Sheraton Incheon Hotel	Incheon	2010	102 m / 333 ft

Messages Timeline Exceptions Views11 Route Queries22 Models129 Mails Gate Session Request

7.3.33333ms8MBGET company/{id}

Booting (7.5ms)
Application (326ms)
1 x Application (97.73%)
325.66ms
1 x Booting (2.25%)
7.50ms

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

22 statements were executed, 4 of which were duplicated, 18 unique290ms

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

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

8.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:138 11. /app/CtbuhCompany.php:223 12. /app/Http/Controllers/CtbuhCompanyController.php:47 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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

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

113ms/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` = 'Heerim Architects & Planners' and `active` = '1'4.69ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. Heerim Architects & Planners 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 (185, 185)1.75ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 185 1. 185
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 (16266, 16265, 109, 8853, 8854, 364, 27126, 475, 2606, 12422, 12996, 12995, 12835, 12834, 12833, 12832, 8850, 8851, 8844, 8843, 3487, 2656, 1609, 36194, 36195, 36196) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

6.3ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 16266 3. 16265 4. 109 5. 8853 6. 8854 7. 364 8. 27126 9. 475 10. 2606 11. 12422 12. 12996 13. 12995 14. 12835 15. 12834 16. 12833 17. 12832 18. 8850 19. 8851 20. 8844 21. 8843 22. 3487 23. 2656 24. 1609 25. 36194 26. 36195 27. 36196
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 (661, 665, 1067, 1071, 1072, 1738)4.11ms/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 (13, 19, 85, 168)1.5ms/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 (13, 19, 85, 168)1.61ms/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 (109, 364, 475, 1609, 2606, 2656, 3487, 8843, 8844, 8850, 8851, 8853, 8854, 12422, 12832, 12833, 12834, 12835, 12995, 12996, 16265, 16266, 27126, 36194, 36195, 36196) order by `position` asc

7.4ms/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.56ms/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` = 185 and `v2_members`.`deleted_at` is null

7.79ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 185
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 `nav_menu_items` where `parent_id` is null1.82ms/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

2.36ms/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.37ms/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.34ms/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.4ms/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.35ms/app/NavMenuItem.php:110buldingdb

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

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

1.32ms/app/NavMenuItem.php:110buldingdb

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

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

1.31ms/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.44ms/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\Member: 1
App\Image: 50
App\Country: 8
App\City: 6
App\Building: 26
App\CtbuhCompany: 1

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

path_info

/company/185

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" => "19414"
  "REMOTE_ADDR" => "18.190.158.237"
  "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/185"
  "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" => 1744480925.6224
  "REQUEST_TIME" => 1744480925
]

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 => "Sat, 12 Apr 2025 18:02:05 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktqVXFPamVqZVwvUHZpN0l5Q0tLcVJBPT0iLCJ2YWx1ZSI6Ikl5bXFVaFNLZFdyMkIzYlBYR0VYMHFNT0hmXC96RkdRQ2I4UlBTT3lLVmxVRnBtaHZaZXlBM1A0bVByb3hlaDNaZytqSlM2eHFTWUtNckFWakVNTkhTckNsVmFDVjdzZHF2RDhkOGpEVlBiUFYwRUVmSHZ6azl6d0pUdnNKa2htZiIsIm1hYyI6ImM5N2RhYWY1MmJiYTcwZjQzMjdmNjU2NzQxYjRkZWI5NDI0Y2I5ZGNhMmM3NjM4OTRlYjU5ZWUyOTE0YjQwMjkifQ%3D%3D; expires=Sat, 12-Apr-2025 20:02:05 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IktqVXFPamVqZVwvUHZpN0l5Q0tLcVJBPT0iLCJ2YWx1ZSI6Ikl5bXFVaFNLZFdyMkIzYlBYR0VYMHFNT0hmXC96RkdRQ2I4UlBTT3lLVmxVRnBtaHZaZXlBM1A0bVByb3hlaDNaZytqS ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlZWMkttcHQ0VXJRSFwvbGZhUEx2dE5RPT0iLCJ2YWx1ZSI6IktkdGdYUFN4aVNhd25iRHJFejR5TTNZbHVqMUx2bzRzNDI1bG9PVG9SV0pnbEFXNjY3Y1wvemNCK0NCU0JmSnNvT0RcL0o0WGpBbml1bEJwRlwvQzdlS3BjRVR4dk43RUIyQ3JSVVZHMjg1bVNoanZaVWJ6T3Q4RWtmb2xjN3gwSnpRIiwibWFjIjoiNWJjNWIzYjJiNjE4ZTc0ODY4MzYyZGQwZjY0NmRjOTAxYjEwY2Q5NmZmMWYzNTc5M2ViMTU4YzhjMWQyNzJlNCJ9; expires=Sat, 12-Apr-2025 20:02:05 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlZWMkttcHQ0VXJRSFwvbGZhUEx2dE5RPT0iLCJ2YWx1ZSI6IktkdGdYUFN4aVNhd25iRHJFejR5TTNZbHVqMUx2bzRzNDI1bG9PVG9SV0pnbEFXNjY3Y1wvemNCK0 ▶"
    2 => "visit_counter=eyJpdiI6IjI0UkdcL0NhWFQxdU90dHVJZDJramF3PT0iLCJ2YWx1ZSI6ImdCNVdXQUJQd25hcjI5QUQ1c0tiNjVCYWxOb0FFQUZvSmVsbmlaVUhnZExhSHhXZXRRTlZvekpscCttZmZYbWQiLCJtYWMiOiJhMGI1ZDRkZGI2MTI2NmUyMzgzZDU3ODY5YjFlMmRjMTU3NmI4ZmQ2YjQ1ZjNiZGIyYWVlMzQ5M2FhNDIwYTA3In0%3D; expires=Mon, 12-May-2025 18:02:05 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6IjI0UkdcL0NhWFQxdU90dHVJZDJramF3PT0iLCJ2YWx1ZSI6ImdCNVdXQUJQd25hcjI5QUQ1c0tiNjVCYWxOb0FFQUZvSmVsbmlaVUhnZExhSHhXZXRRTlZvekpscCttZmZYbWQiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IktqVXFPamVqZVwvUHZpN0l5Q0tLcVJBPT0iLCJ2YWx1ZSI6Ikl5bXFVaFNLZFdyMkIzYlBYR0VYMHFNT0hmXC96RkdRQ2I4UlBTT3lLVmxVRnBtaHZaZXlBM1A0bVByb3hlaDNaZytqSlM2eHFTWUtNckFWakVNTkhTckNsVmFDVjdzZHF2RDhkOGpEVlBiUFYwRUVmSHZ6azl6d0pUdnNKa2htZiIsIm1hYyI6ImM5N2RhYWY1MmJiYTcwZjQzMjdmNjU2NzQxYjRkZWI5NDI0Y2I5ZGNhMmM3NjM4OTRlYjU5ZWUyOTE0YjQwMjkifQ%3D%3D; expires=Sat, 12-Apr-2025 20:02:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IktqVXFPamVqZVwvUHZpN0l5Q0tLcVJBPT0iLCJ2YWx1ZSI6Ikl5bXFVaFNLZFdyMkIzYlBYR0VYMHFNT0hmXC96RkdRQ2I4UlBTT3lLVmxVRnBtaHZaZXlBM1A0bVByb3hlaDNaZytqS ▶"
    1 => "skyscraper_center_session=eyJpdiI6IlZWMkttcHQ0VXJRSFwvbGZhUEx2dE5RPT0iLCJ2YWx1ZSI6IktkdGdYUFN4aVNhd25iRHJFejR5TTNZbHVqMUx2bzRzNDI1bG9PVG9SV0pnbEFXNjY3Y1wvemNCK0NCU0JmSnNvT0RcL0o0WGpBbml1bEJwRlwvQzdlS3BjRVR4dk43RUIyQ3JSVVZHMjg1bVNoanZaVWJ6T3Q4RWtmb2xjN3gwSnpRIiwibWFjIjoiNWJjNWIzYjJiNjE4ZTc0ODY4MzYyZGQwZjY0NmRjOTAxYjEwY2Q5NmZmMWYzNTc5M2ViMTU4YzhjMWQyNzJlNCJ9; expires=Sat, 12-Apr-2025 20:02:05 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IlZWMkttcHQ0VXJRSFwvbGZhUEx2dE5RPT0iLCJ2YWx1ZSI6IktkdGdYUFN4aVNhd25iRHJFejR5TTNZbHVqMUx2bzRzNDI1bG9PVG9SV0pnbEFXNjY3Y1wvemNCK0 ▶"
    2 => "visit_counter=eyJpdiI6IjI0UkdcL0NhWFQxdU90dHVJZDJramF3PT0iLCJ2YWx1ZSI6ImdCNVdXQUJQd25hcjI5QUQ1c0tiNjVCYWxOb0FFQUZvSmVsbmlaVUhnZExhSHhXZXRRTlZvekpscCttZmZYbWQiLCJtYWMiOiJhMGI1ZDRkZGI2MTI2NmUyMzgzZDU3ODY5YjFlMmRjMTU3NmI4ZmQ2YjQ1ZjNiZGIyYWVlMzQ5M2FhNDIwYTA3In0%3D; expires=Mon, 12-May-2025 18:02:05 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjI0UkdcL0NhWFQxdU90dHVJZDJramF3PT0iLCJ2YWx1ZSI6ImdCNVdXQUJQd25hcjI5QUQ1c0tiNjVCYWxOb0FFQUZvSmVsbmlaVUhnZExhSHhXZXRRTlZvekpscCttZmZYbWQiLC ▶"
  ]
]

session_attributes

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

1 x Application (97.73%)	325.66ms
1 x Booting (2.25%)	7.50ms

View all results

Buildings