Berlin

Name	City	Level	# of 150m+ buildings	Fields Of Expertise ACAD: Academic / University ARCH: Architecture BACS: Building Automation Control Systems BMNT: Building Maintenance CIV: Civil Engineering COMP: Computers / IT / Software CON: Construction / Contractor COST: Cost Consulting DEV: Developer ENGO: Engineering, Other ENVE: Environmental Engineering ENVP: Environmental Protection FAC: Façade Design / Engineering FIN: Financial Industry FIRE: Fire Engineering GEO: Geotechnic / Foundations HIST: Historical Preservation INSU: Insurance / Risk INTR: Interior Design LAND: Landscape Architecture LEGL: Legal MRKT: Marketing / Sales MATR: Materials / Products / Systems Supplier MEP: Mechanical, Electrical & Plumbing NONP: Non-Profit Org. / Assoc. / Gov't OWN: Owner (Buildings, Land) PMNG: Project Management PROP: Property Management RES: Research Institute SEC: Security Consultancy SEIS: Seismic Design STRC: Structural Engineering SURV: Surveying TRAN: Transportation / Urban Infrastructure URB: Urban Design VERC: Vertical Transportation Consultant WIND: Wind Engineering OTHR: Other FACS: Façade Systems VERS: Vertical Transportation Supplier ENGM: Engineering, Multi-discipline Filter by✕ + Select all ACAD ARCH BACS BMNT CIV COMP CON COST DEV ENGO ENVE ENVP FAC FIN FIRE GEO HIST INSU INTR LAND LEGL MRKT MATR MEP NONP OWN PMNG PROP RES SEC SEIS STRC SURV TRAN URB VERC WIND OTHR FACS VERS ENGM
GERB Vibration Control Systems	Berlin	Silver	18	MATR • SEIS
Henn GmbH	Berlin	Silver	6	ARCH
Lichtvision Design Limited	Berlin	Silver	15	OTHR
Priedemann Holding GmbH	Berlin	Silver	21	FAC • FACS
Sauerbruch Hutton	Berlin	Silver	0	INTR • URB • ARCH

Messages Timeline Exceptions Views13 Route Queries49 Models207 Mails Gate Session Request

7.3.33860ms10MBGET city/{slug}/members

Booting (9.35ms)
Application (851ms)
1 x Application (98.9%)
850.74ms
1 x Booting (1.09%)
9.35ms

13 templates were rendered

cities.tabs.members (resources/views/cities/tabs/members.blade.php)8blade
Params
0
geo
1
title
2
members
3
fields
4
memberLevels
5
filter_values
6
tabsData
7
accessLevel

Params
0	`geo`
1	`title`
2	`members`
3	`fields`
4	`memberLevels`
5	`filter_values`
6	`tabsData`
7	`accessLevel`

cities.sections.companies-table (resources/views/cities/sections/companies-table.blade.php)19blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
header
tableId
displayComplexTable
paginate
search

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`header`
15	`tableId`
16	`displayComplexTable`
17	`paginate`
18	`search`

cities.layout (resources/views/cities/layout.blade.php)14blade


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel

cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
lucky_50
5
dateFormats
6
geo
7
title
8
members
9
fields
10
memberLevels
11
filter_values
12
tabsData
13
accessLevel
cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
lucky_50
5
dateFormats
6
geo
7
title
8
members
9
fields
10
memberLevels
11
filter_values
12
tabsData
13
accessLevel

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`
15	`nav`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`
15	`nav`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data
nav
__currentLoopData
item
loop
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`
15	`nav`
16	`__currentLoopData`
17	`item`
18	`loop`
19	`child`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data

common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
errors
4
lucky_50
5
dateFormats
6
geo
7
title
8
members
9
fields
10
memberLevels
11
filter_values
12
tabsData
13
accessLevel
14
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`
15	`alreadyConsentedWithCookies`
16	`cookieConsentConfig`

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


obLevel
__env
app
errors
lucky_50
dateFormats
geo
title
members
fields
memberLevels
filter_values
tabsData
accessLevel
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`dateFormats`
6	`geo`
7	`title`
8	`members`
9	`fields`
10	`memberLevels`
11	`filter_values`
12	`tabsData`
13	`accessLevel`
14	`data`
15	`alreadyConsentedWithCookies`
16	`cookieConsentConfig`

uri: GET city/{slug}/members
middleware: web
controller: App\Http\Controllers\CityController@members
namespace: App\Http\Controllers
prefix
where
as: city-members
file: app/Http/Controllers/CityController.php:629-666

49 statements were executed, 3 of which were duplicated, 46 unique783ms

select * from `v2_cities` where `slug` = 'berlin' limit 113.71ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Bindings	0. berlin
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. /app/Http/Controllers/CityController.php:639 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_countries` where `v2_countries`.`id` in (41)1.3ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:639 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_regions` where `v2_regions`.`id` in (1)1.15ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:639 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `ctbuh_building` where `active` = '1' and `structure_type` = 'building' and (`linked_building_status` is null or `linked_building_status` not in ('COM', 'UC', 'STO', 'UCT')) and `ctbuh_building`.`city_id` in (844) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

229ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Bindings	0. 1 1. building 2. COM 3. UC 4. STO 5. UCT
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:639 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_cities` where `v2_cities`.`id` in (844)1.47ms/app/Http/Controllers/CityController.php:639buldingdb

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

select `v2_initiatives`.*, `v2_city_initiative`.`city_id` as `pivot_city_id`, `v2_city_initiative`.`initiative_id` as `pivot_initiative_id` from `v2_initiatives` inner join `v2_city_initiative` on `v2_initiatives`.`id` = `v2_city_initiative`.`initiative_id` where `v2_city_initiative`.`city_id` in (844) order by `start_date` desc

1.9ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Backtrace	20. /app/Http/Controllers/CityController.php:639 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 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_cities` where `v2_cities`.`id` in (745, 844)1.53ms/app/Http/Controllers/CityController.php:639buldingdb

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

select `v2_resources`.*, `v2_city_resource`.`city_id` as `pivot_city_id`, `v2_city_resource`.`resource_id` as `pivot_resource_id` from `v2_resources` inner join `v2_city_resource` on `v2_resources`.`id` = `v2_city_resource`.`resource_id` where `v2_city_resource`.`city_id` in (844) order by `type` asc, `date` desc

2.12ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Backtrace	20. /app/Http/Controllers/CityController.php:639 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 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `v2_people` where `v2_people`.`city_id` in (844)2.25ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	21. /app/Http/Controllers/CityController.php:639 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 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `v2_roles`.*, `v2_person_role`.`person_id` as `pivot_person_id`, `v2_person_role`.`role_id` as `pivot_role_id`, `v2_person_role`.`year_start` as `pivot_year_start`, `v2_person_role`.`year_end` as `pivot_year_end`, `v2_person_role`.`title` as `pivot_title`, `v2_person_role`.`link` as `pivot_link`, `v2_person_role`.`display_order` as `pivot_display_order`, `v2_person_role`.`hide_in_lists` as `pivot_hide_in_lists` from `v2_roles` inner join `v2_person_role` on `v2_roles`.`id` = `v2_person_role`.`role_id` where `v2_person_role`.`person_id` in (563, 857, 1189, 2510, 2589, 3070, 3094, 3365, 3366, 3761, 3844, 4606, 7090, 7706, 8922, 10109, 10150, 10515, 10970, 35680, 38777, 40469, 40478) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc

2.37ms/app/Http/Controllers/CityController.php:639buldingdb

Metadata
Backtrace	25. /app/Http/Controllers/CityController.php:639 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `v2_members`.*, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_members` inner join `v2_city_member` on `v2_members`.`id` = `v2_city_member`.`member_id` where `v2_city_member`.`city_id` = 844 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc

2.11ms/app/Http/Controllers/CityController.php:756buldingdb

Metadata
Bindings	0. 844 1. 0
Backtrace	19. /app/Http/Controllers/CityController.php:756 20. /app/Http/Controllers/CityController.php:641 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 `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 918 and `ctbuh_company`.`deleted_at` is null

2.12ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 918
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:641 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 `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 638 and `ctbuh_company`.`deleted_at` is null

2.99ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 638
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:641 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 `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 1657 and `ctbuh_company`.`deleted_at` is null

2.23ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 1657
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:641 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 `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 1445 and `ctbuh_company`.`deleted_at` is null

2.09ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 1445
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:641 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 `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 284 and `ctbuh_company`.`deleted_at` is null

2.15ms/app/Http/Controllers/CityController.php:763buldingdb

Metadata
Bindings	0. 284
Backtrace	19. /app/Http/Controllers/CityController.php:763 20. /app/Http/Controllers/CityController.php:641 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 `v2_resource_categories` where `type` = 'Video'2.61ms/app/Http/Controllers/CityController.php:794buldingdb

Metadata
Bindings	0. Video
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/CityController.php:794 13. /app/Http/Controllers/CityController.php:641 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 `v2_resource_categories` where `type` = 'Video'1.28ms/app/Http/Controllers/CityController.php:794buldingdb

Metadata
Bindings	0. Video
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/CityController.php:794 13. /app/Http/Controllers/CityController.php:641 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 `v2_resource_subcategories` where `type` = 'Video' and `id` = 8 limit 11.41ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 8
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	13. /app/Http/Controllers/CityController.php:803 14. /app/Http/Controllers/CityController.php:641 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `v2_resource_categories` where `type` = 'Video'1.25ms/app/Http/Controllers/CityController.php:794buldingdb

Metadata
Bindings	0. Video
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/CityController.php:794 13. /app/Http/Controllers/CityController.php:641 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 `v2_resource_subcategories` where `type` = 'Video' and `id` = 12 limit 11.39ms/app/Http/Controllers/CityController.php:803buldingdb

Metadata
Bindings	0. Video 1. 12
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	13. /app/Http/Controllers/CityController.php:803 14. /app/Http/Controllers/CityController.php:641 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select `v2_people`.*, `v2_city_person`.`city_id` as `pivot_city_id`, `v2_city_person`.`person_id` as `pivot_person_id`, `v2_city_person`.`year_start` as `pivot_year_start`, `v2_city_person`.`year_end` as `pivot_year_end`, `v2_city_person`.`title` as `pivot_title`, `v2_city_person`.`display_order` as `pivot_display_order` from `v2_people` inner join `v2_city_person` on `v2_people`.`id` = `v2_city_person`.`person_id` where `v2_city_person`.`city_id` = 844 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc

1.66ms/app/Http/Controllers/CityController.php:896buldingdb

Metadata
Bindings	0. 844
Backtrace	19. /app/Http/Controllers/CityController.php:896 20. /app/Http/Controllers/CityController.php:641 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 `global_news_posts` where `global_news_posts`.`city_id` = 844 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-16 04:52:25' and `deleted_at` is null order by `published_at` desc

1.53ms/app/Http/Controllers/CityController.php:904buldingdb

Metadata
Bindings	0. 844 1. 2025-04-16 04:52:25
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Http/Controllers/CityController.php:904 20. /app/Http/Controllers/CityController.php:641 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 `v2_countries` where `v2_countries`.`id` = 41 limit 11.27ms/app/Http/Controllers/Controller.php:423buldingdb

Metadata
Bindings	0. 41
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	21. /app/Http/Controllers/Controller.php:423 22. /app/Http/Controllers/CityController.php:950 23. /app/Http/Controllers/CityController.php:641 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `v2_fields` order by `id` asc1.34ms/app/Http/Controllers/CityController.php:643buldingdb

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/CityController.php:643 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 918 order by `headquarters` desc, `contact` desc, `name` asc

1.7ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 918
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(11228) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(11228))
)

96.75ms/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/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 918 order by `display_order` asc, `field` asc

3.19msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 918
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 638 order by `headquarters` desc, `contact` desc, `name` asc

1.72ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 638
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(3438) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(3438))
)

102ms/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/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 638 order by `display_order` asc, `field` asc

1.59msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 638
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 1657 order by `headquarters` desc, `contact` desc, `name` asc

1.76ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1657
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(14392) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(14392))
)

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

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 1657 order by `display_order` asc, `field` asc

1.37msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 1657
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 1445 order by `headquarters` desc, `contact` desc, `name` asc

1.71ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 1445
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(21065) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(21065))
)

79.59ms/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/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 1445 order by `display_order` asc, `field` asc

1.62msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 1445
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 284 order by `headquarters` desc, `contact` desc, `name` asc

1.79ms/app/Member.php:49buldingdb

Metadata
Bindings	0. 284
Backtrace	19. /app/Member.php:49 20. /app/Member.php:61 21. view::cities.sections.companies-table:68 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

SELECT
b.id,
CONVERT(CAST(CONVERT(b.name_intl USING latin1) AS BINARY) USING utf8) AS building_name,
b.height_architecture,
b.completed,
b.status,
b.structural_material,
b.main_use_01,
b.main_use_02,
b.new_companies_format
FROM ctbuh_building b
WHERE
b.active = 1
AND (
b.id IN(SELECT bc.id_building AS id FROM ctbuh_building_company bc LEFT JOIN ctbuh_building b ON bc.id_building = b.id WHERE bc.id_company IN(2887) AND b.new_companies_format = 0)
OR
b.id IN(SELECT building_id AS id FROM ctbuh_building_company_new WHERE subcategory_id NOT IN(5, 8) AND company_id IN(2887))
)

99.5ms/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/Member.php:129 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261

select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 284 order by `display_order` asc, `field` asc

2.14msview::cities.sections.companies-table:93buldingdb

Metadata
Bindings	0. 284
Backtrace	19. view::cities.sections.companies-table:93 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null2.87ms/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.74ms/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.48ms/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.33ms/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.48ms/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.55ms/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.68ms/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.61ms/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\Field: 50
App\CtbuhCompany: 5
App\Member: 5
App\Role: 16
App\Person: 23
App\Initiative: 7
App\Building: 51
App\Region: 1
App\Country: 2
App\City: 10

_token: bqoh9U7sV0MlLfY66ozdXFfQGNoQwkC3N9v0Ttfg
_previous: array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/berlin/members" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/city/berlin/members

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:18 [▶
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlA3cklEYkQ5M1daM3gyeW9HbklHb0E9PSIsInZhbHVlIjoiaTVmK21weWtrTFFBTUJWWWplMEdiY1l2NDdoY0Z5YWRON05Wd2xcL3J5MVRpT2dSak02Y09WSnJrOHJoWFBCakhtV21PelVUbjVQYnRCNUh1UG83bEptZTBCbEZtXC9iSVJmR1N5a2g3V082dnhQZGp3UEwxU0VQNWVNUVBoeWNweCIsIm1hYyI6IjI2YmE0ZWE3YzliZGMwMDNhZGRhNWRlYzY0OTdkMzQ2ODBjNDgxOGU1NDZmOTEzZDliNzI5MDBiZTEyYjViODIifQ%3D%3D; skyscraper_center_session=eyJpdiI6ImxzeWwraTNxakZKTWhcL1FiRllyMk1RPT0iLCJ2YWx1ZSI6InIyRWFOaGNycG9UaW9wTmRjWnZoTjBTQWpvOURGXC9QVTJTcTh2cGd2N0xZa29WK2NjUkJiY29EUU9jTXFUelVzMnVzY3p1cGhRQWxhaXJ0WGdUZFlpTTRpUkhyRzVDWW1xTEpISkxNM3JJME95clB4ZXN5b3p3Z1AzZkNuNDN3byIsIm1hYyI6IjEzNWVhYWEyZGE4M2E0NTIyOTAzZjAyNjg0ZGMwODczNDQ3OGQwYTY3ZGJjYjMzNzI2NjJjMWYzMzE3ZTA4OGMifQ%3D%3D; visit_counter=eyJpdiI6Ik5GREsxMGVTNGlRZE1oSkdcL0ZLTFh3PT0iLCJ2YWx1ZSI6ImZFQllcL0ZkVndYYjI1N1N4cDRPYTFiK1RwZTFXNGZ5aFI4SVFtTlFFdjlaSmlvMUkwYk9NancxZmE2OUxxTm1HIiwibWFjIjoiYTdlZjJiZDIzYTdkNTgyY2RlNDIzZDI0MDYyN2ZiZDA2NTJjMmU4ODYxZWJkMWU4YzU4NTM4ODA4ZGEyZmYyNiJ9 ◀XSRF-TOKEN=eyJpdiI6IlA3cklEYkQ5M1daM3gyeW9HbklHb0E9PSIsInZhbHVlIjoiaTVmK21weWtrTFFBTUJWWWplMEdiY1l2NDdoY0Z5YWRON05Wd2xcL3J5MVRpT2dSak02Y09WSnJrOHJoWFBCakhtV21Pe ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "staging.skyscrapercenter.xyz"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:41 [▶
  "USER" => "forge"
  "HOME" => "/home/forge"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlA3cklEYkQ5M1daM3gyeW9HbklHb0E9PSIsInZhbHVlIjoiaTVmK21weWtrTFFBTUJWWWplMEdiY1l2NDdoY0Z5YWRON05Wd2xcL3J5MVRpT2dSak02Y09WSnJrOHJoWFBCakhtV21PelVUbjVQYnRCNUh1UG83bEptZTBCbEZtXC9iSVJmR1N5a2g3V082dnhQZGp3UEwxU0VQNWVNUVBoeWNweCIsIm1hYyI6IjI2YmE0ZWE3YzliZGMwMDNhZGRhNWRlYzY0OTdkMzQ2ODBjNDgxOGU1NDZmOTEzZDliNzI5MDBiZTEyYjViODIifQ%3D%3D; skyscraper_center_session=eyJpdiI6ImxzeWwraTNxakZKTWhcL1FiRllyMk1RPT0iLCJ2YWx1ZSI6InIyRWFOaGNycG9UaW9wTmRjWnZoTjBTQWpvOURGXC9QVTJTcTh2cGd2N0xZa29WK2NjUkJiY29EUU9jTXFUelVzMnVzY3p1cGhRQWxhaXJ0WGdUZFlpTTRpUkhyRzVDWW1xTEpISkxNM3JJME95clB4ZXN5b3p3Z1AzZkNuNDN3byIsIm1hYyI6IjEzNWVhYWEyZGE4M2E0NTIyOTAzZjAyNjg0ZGMwODczNDQ3OGQwYTY3ZGJjYjMzNzI2NjJjMWYzMzE3ZTA4OGMifQ%3D%3D; visit_counter=eyJpdiI6Ik5GREsxMGVTNGlRZE1oSkdcL0ZLTFh3PT0iLCJ2YWx1ZSI6ImZFQllcL0ZkVndYYjI1N1N4cDRPYTFiK1RwZTFXNGZ5aFI4SVFtTlFFdjlaSmlvMUkwYk9NancxZmE2OUxxTm1HIiwibWFjIjoiYTdlZjJiZDIzYTdkNTgyY2RlNDIzZDI0MDYyN2ZiZDA2NTJjMmU4ODYxZWJkMWU4YzU4NTM4ODA4ZGEyZmYyNiJ9 ◀XSRF-TOKEN=eyJpdiI6IlA3cklEYkQ5M1daM3gyeW9HbklHb0E9PSIsInZhbHVlIjoiaTVmK21weWtrTFFBTUJWWWplMEdiY1l2NDdoY0Z5YWRON05Wd2xcL3J5MVRpT2dSak02Y09WSnJrOHJoWFBCakhtV21Pe ▶"
  "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" => "43845"
  "REMOTE_ADDR" => "18.217.228.61"
  "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" => "/city/berlin/members"
  "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" => 1744779145.5597
  "REQUEST_TIME" => 1744779145
]

request_cookies

  0 of 0   
array:3 [▶
  "XSRF-TOKEN" => "bqoh9U7sV0MlLfY66ozdXFfQGNoQwkC3N9v0Ttfg"
  "skyscraper_center_session" => "xwxRydDmdwwlXb3VayyUvo0JKBd5DJ8rNXlCwdRX"
  "visit_counter" => "1"
]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 16 Apr 2025 04:52:25 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRDVTg2RWhMS3YxeCtpVk0yV2hUcHc9PSIsInZhbHVlIjoiT0hxbDdzcGNjTFZWQ3JFRXhWZVVIWjVuTkRQekNtOElGWXY3ekFTZ054VlcwZjdhMHl0OStxbGMwOWNpcjQxZnEybDVKXC9yZFFXNFRMRFdCOFpXOGUrYzJ5ZjdUeGFpNk9lTm5WdGRIcytPNVlHbU1VUWptOFJxRUZmSmxld2taIiwibWFjIjoiZDg0MDg2ZjIxNjljZjkyYzc1YzFhNjVhMjU4OTE2M2ZiM2E4NjliM2Q2MWI1ZWU5ZmVkYzJmY2JmZDlhODA0YiJ9; expires=Wed, 16-Apr-2025 06:52:26 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRDVTg2RWhMS3YxeCtpVk0yV2hUcHc9PSIsInZhbHVlIjoiT0hxbDdzcGNjTFZWQ3JFRXhWZVVIWjVuTkRQekNtOElGWXY3ekFTZ054VlcwZjdhMHl0OStxbGMwOWNpcjQxZnEybDVKX ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkJuTm5mc0c2WW9IZTNcL0luOGl6U3dBPT0iLCJ2YWx1ZSI6InlJZWtyUHBLT3NCUlQ0clJONnVOeXJZZDFyM1dGWlhqdGFGQ3N4aWpLXC83WFduNHNyRVM2UFVTK21YSmJaQmloSmRvTjExd1I0NUI5SzJSOTR2V24xZ0NrNWlkRmhmTlRacngxSjJMaHRVN1VcL2VaZGpLeXFIcWpsQnZ6TnMwQkkiLCJtYWMiOiIxOTI0ZWNlMzQwNjQ3ZWQ5MGY0MTQxYWM5OGQ0MGNkMWRjNjRhOWZhYmY5MTQxMTA1MTMwZjcwMGQyMTZiOTk0In0%3D; expires=Wed, 16-Apr-2025 06:52:26 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkJuTm5mc0c2WW9IZTNcL0luOGl6U3dBPT0iLCJ2YWx1ZSI6InlJZWtyUHBLT3NCUlQ0clJONnVOeXJZZDFyM1dGWlhqdGFGQ3N4aWpLXC83WFduNHNyRVM2UFVTK2 ▶"
    2 => "visit_counter=eyJpdiI6Ik9tMXhveVo2ZjdmTUQyU011THpXUkE9PSIsInZhbHVlIjoiYVFPMTZ1clJra0huOTcreWEwbHRZcGU0Vm1iZkVORnZUMVJtbmEwdE84aDBnRXlEOTdLcjhwUldGXC9scCtKSzMiLCJtYWMiOiIxZTAyNmI2OTI0ZTRjMGE1YmI5MGIwNTVlNTViOGZkM2MyNjU3YTk3ODZkMWVhYTIxYWQ0MmE2NTY0MmI4M2E0In0%3D; expires=Fri, 16-May-2025 04:52:25 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6Ik9tMXhveVo2ZjdmTUQyU011THpXUkE9PSIsInZhbHVlIjoiYVFPMTZ1clJra0huOTcreWEwbHRZcGU0Vm1iZkVORnZUMVJtbmEwdE84aDBnRXlEOTdLcjhwUldGXC9scCtKSzMiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRDVTg2RWhMS3YxeCtpVk0yV2hUcHc9PSIsInZhbHVlIjoiT0hxbDdzcGNjTFZWQ3JFRXhWZVVIWjVuTkRQekNtOElGWXY3ekFTZ054VlcwZjdhMHl0OStxbGMwOWNpcjQxZnEybDVKXC9yZFFXNFRMRFdCOFpXOGUrYzJ5ZjdUeGFpNk9lTm5WdGRIcytPNVlHbU1VUWptOFJxRUZmSmxld2taIiwibWFjIjoiZDg0MDg2ZjIxNjljZjkyYzc1YzFhNjVhMjU4OTE2M2ZiM2E4NjliM2Q2MWI1ZWU5ZmVkYzJmY2JmZDlhODA0YiJ9; expires=Wed, 16-Apr-2025 06:52:26 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRDVTg2RWhMS3YxeCtpVk0yV2hUcHc9PSIsInZhbHVlIjoiT0hxbDdzcGNjTFZWQ3JFRXhWZVVIWjVuTkRQekNtOElGWXY3ekFTZ054VlcwZjdhMHl0OStxbGMwOWNpcjQxZnEybDVKX ▶"
    1 => "skyscraper_center_session=eyJpdiI6IkJuTm5mc0c2WW9IZTNcL0luOGl6U3dBPT0iLCJ2YWx1ZSI6InlJZWtyUHBLT3NCUlQ0clJONnVOeXJZZDFyM1dGWlhqdGFGQ3N4aWpLXC83WFduNHNyRVM2UFVTK21YSmJaQmloSmRvTjExd1I0NUI5SzJSOTR2V24xZ0NrNWlkRmhmTlRacngxSjJMaHRVN1VcL2VaZGpLeXFIcWpsQnZ6TnMwQkkiLCJtYWMiOiIxOTI0ZWNlMzQwNjQ3ZWQ5MGY0MTQxYWM5OGQ0MGNkMWRjNjRhOWZhYmY5MTQxMTA1MTMwZjcwMGQyMTZiOTk0In0%3D; expires=Wed, 16-Apr-2025 06:52:26 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IkJuTm5mc0c2WW9IZTNcL0luOGl6U3dBPT0iLCJ2YWx1ZSI6InlJZWtyUHBLT3NCUlQ0clJONnVOeXJZZDFyM1dGWlhqdGFGQ3N4aWpLXC83WFduNHNyRVM2UFVTK2 ▶"
    2 => "visit_counter=eyJpdiI6Ik9tMXhveVo2ZjdmTUQyU011THpXUkE9PSIsInZhbHVlIjoiYVFPMTZ1clJra0huOTcreWEwbHRZcGU0Vm1iZkVORnZUMVJtbmEwdE84aDBnRXlEOTdLcjhwUldGXC9scCtKSzMiLCJtYWMiOiIxZTAyNmI2OTI0ZTRjMGE1YmI5MGIwNTVlNTViOGZkM2MyNjU3YTk3ODZkMWVhYTIxYWQ0MmE2NTY0MmI4M2E0In0%3D; expires=Fri, 16-May-2025 04:52:25 GMT; path=/; httponly ◀visit_counter=eyJpdiI6Ik9tMXhveVo2ZjdmTUQyU011THpXUkE9PSIsInZhbHVlIjoiYVFPMTZ1clJra0huOTcreWEwbHRZcGU0Vm1iZkVORnZUMVJtbmEwdE84aDBnRXlEOTdLcjhwUldGXC9scCtKSzMiLC ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "bqoh9U7sV0MlLfY66ozdXFfQGNoQwkC3N9v0Ttfg"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/city/berlin/members"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (98.9%)	850.74ms
1 x Booting (1.09%)	9.35ms

View all results

Berlin CTBUH Members