Manchester

United Kingdom

Manchester CTBUH Members

7.3.33PHP Version408msRequest Duration10MBMemory UsageGET city/{slug}/membersRoute
    • Booting (13.85ms)
    • Application (394ms)
    • 1 x Application (96.57%)
      393.71ms
      1 x Booting (3.4%)
      13.85ms
      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
      • cities.sections.companies-table (resources/views/cities/sections/companies-table.blade.php)19blade
        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
        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
      • 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
      • layouts.SSC (resources/views/layouts/SSC.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
      • common.header (resources/views/common/header.blade.php)16blade
        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
        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
        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
        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
      • 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
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)17blade
        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
        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
      36 statements were executed, 6 of which were duplicated, 30 unique326ms
      • select * from `v2_cities` where `slug` = 'manchester' limit 111.16ms/app/Http/Controllers/CityController.php:639buldingdb
        Metadata
        Bindings
        • 0. manchester
        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 (56)1.53ms/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.4ms/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 (943) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc204ms/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 (943)1.56ms/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 (943) order by `start_date` desc1.83ms/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 (943)1.49ms/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 (943) order by `type` asc, `date` desc2.05ms/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 (943)2.01ms/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 (142, 389, 2087, 2116, 2117, 2263, 4303, 7139, 9838, 9839, 11807, 35794) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc3.52ms/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` = 943 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc2.13ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 943
        • 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` = 1025 and `ctbuh_company`.`deleted_at` is null6ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 1025
        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` = 725 and `ctbuh_company`.`deleted_at` is null11.49ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 725
        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'1.49ms/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' and `id` = 19 limit 11.28ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 19
        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:817
        • 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.56ms/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.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` = 20 limit 11.23ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 20
        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.14ms/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 `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` = 943 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc2.06ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 943
        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` = 943 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-21 23:26:27' and `deleted_at` is null order by `published_at` desc2.73ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 943
        • 1. 2025-04-21 23:26:27
        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` = 56 limit 16.72ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 56
        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.5ms/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` = 1025 order by `headquarters` desc, `contact` desc, `name` asc1.8ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 1025
        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 `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` = 1025 order by `display_order` asc, `field` asc1.46msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 1025
        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` = 725 order by `headquarters` desc, `contact` desc, `name` asc1.75ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 725
        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 `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` = 725 order by `display_order` asc, `field` asc1.47msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 725
        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 null1.21ms/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` asc1.7ms/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 12.04ms/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` asc5.54ms/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` asc7.36ms/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` asc5.65ms/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` asc9.12ms/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` asc7.57ms/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` asc8.03ms/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
      43
      App\CtbuhCompany
      2
      App\Member
      2
      App\Role
      23
      App\Person
      13
      App\Initiative
      4
      App\Building
      71
      App\Region
      1
      App\Country
      2
      App\City
      5
          _token
          Ryw8iJikMpByswR6CevDcSxUYoGuerUIO8bsz8z4
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/manchester/members" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/manchester/members
          status_code
          200
          
          status_text
          OK
          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" => "38203" "REMOTE_ADDR" => "3.135.236.134" "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/manchester/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" => 1745277987.2548 "REQUEST_TIME" => 1745277987 ]
          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 => "Mon, 21 Apr 2025 23:26:27 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlluczZBVlN1RWNVQVM3ajdUZEVsM3c9PSIsInZhbHVlIjoiSHRRczFSOFwvTkVxdndJRDFVR3lnMmFGZERkTVlwYlpwdVlRT0pEOXNhTng4bU16V25jcU1IZm1mQUh2XC9XSzVPRHdpeDZGOU5xOHJMYUdmUkJnYlhcL3dWeFwvNHlWMlYxSDlTTmljZ3phSUFpWitRS0llUjY1aktkTHZGSStVRjdaIiwibWFjIjoiZWQ0ZGJmYjBmY2JhY2VjNTA0YzdlZmM4MTQwMmUxZDE0YmZiMjRjODJmOTUxZmQ2NjRmZTUzOWQzNGM4ZjFmNSJ9; expires=Tue, 22-Apr-2025 01:26:27 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlluczZBVlN1RWNVQVM3ajdUZEVsM3c9PSIsInZhbHVlIjoiSHRRczFSOFwvTkVxdndJRDFVR3lnMmFGZERkTVlwYlpwdVlRT0pEOXNhTng4bU16V25jcU1IZm1mQUh2XC9XSzVPRHdpe" 1 => "skyscraper_center_session=eyJpdiI6IjNtaG1pYWF1dzV6VmZOeTRrQ2RMdnc9PSIsInZhbHVlIjoidW5maTVRNFwvbGg4blBjNVZvUnZ4N3l6QTJKNURqQW93U05nQ3c1WXZoQXNOQXVYbkN2S1NGaXJMb3NkYitRblJyNjZ1dVc1XC9DczVQaVZ3SDRGaGRqZnVqWkpuNDk4am9qbk9IVUViTmtyZHdaVk40R1JUcmFNRXJma0JPOXdzUSIsIm1hYyI6IjQ2MjYwNjcyZGE1ZWRiYWEyYmMwOTgxOTZlNmVhMmQzNWE1NmEzM2Y5MGUyZGE5M2I2ZDhkYWUyMTU5NDg4ZTQifQ%3D%3D; expires=Tue, 22-Apr-2025 01:26:27 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6IjNtaG1pYWF1dzV6VmZOeTRrQ2RMdnc9PSIsInZhbHVlIjoidW5maTVRNFwvbGg4blBjNVZvUnZ4N3l6QTJKNURqQW93U05nQ3c1WXZoQXNOQXVYbkN2S1NGaXJMb3" 2 => "visit_counter=eyJpdiI6IlQyMnZwUWpUcVgzYkhldUxtZm4rMlE9PSIsInZhbHVlIjoiZWFka29BWFRpWmVVUTkxUnlsdHBHNDZTdWJyQW9teWQzelNsN0Z6bWlWdWo2OTlsWmVcL2ErK2dKVmU4NzFPQUEiLCJtYWMiOiI2OWE5MDQzNjYyN2VkMjBhZTQwNGU5NjFlMzJhNTA0N2JmZGUyMjIxNTVhYWE5YjZhNTg5YThiMjU2NmVjNWE4In0%3D; expires=Wed, 21-May-2025 23:26:27 GMT; Max-Age=2592000; path=/; httponlyvisit_counter=eyJpdiI6IlQyMnZwUWpUcVgzYkhldUxtZm4rMlE9PSIsInZhbHVlIjoiZWFka29BWFRpWmVVUTkxUnlsdHBHNDZTdWJyQW9teWQzelNsN0Z6bWlWdWo2OTlsWmVcL2ErK2dKVmU4NzFPQUEiLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlluczZBVlN1RWNVQVM3ajdUZEVsM3c9PSIsInZhbHVlIjoiSHRRczFSOFwvTkVxdndJRDFVR3lnMmFGZERkTVlwYlpwdVlRT0pEOXNhTng4bU16V25jcU1IZm1mQUh2XC9XSzVPRHdpeDZGOU5xOHJMYUdmUkJnYlhcL3dWeFwvNHlWMlYxSDlTTmljZ3phSUFpWitRS0llUjY1aktkTHZGSStVRjdaIiwibWFjIjoiZWQ0ZGJmYjBmY2JhY2VjNTA0YzdlZmM4MTQwMmUxZDE0YmZiMjRjODJmOTUxZmQ2NjRmZTUzOWQzNGM4ZjFmNSJ9; expires=Tue, 22-Apr-2025 01:26:27 GMT; path=/XSRF-TOKEN=eyJpdiI6IlluczZBVlN1RWNVQVM3ajdUZEVsM3c9PSIsInZhbHVlIjoiSHRRczFSOFwvTkVxdndJRDFVR3lnMmFGZERkTVlwYlpwdVlRT0pEOXNhTng4bU16V25jcU1IZm1mQUh2XC9XSzVPRHdpe" 1 => "skyscraper_center_session=eyJpdiI6IjNtaG1pYWF1dzV6VmZOeTRrQ2RMdnc9PSIsInZhbHVlIjoidW5maTVRNFwvbGg4blBjNVZvUnZ4N3l6QTJKNURqQW93U05nQ3c1WXZoQXNOQXVYbkN2S1NGaXJMb3NkYitRblJyNjZ1dVc1XC9DczVQaVZ3SDRGaGRqZnVqWkpuNDk4am9qbk9IVUViTmtyZHdaVk40R1JUcmFNRXJma0JPOXdzUSIsIm1hYyI6IjQ2MjYwNjcyZGE1ZWRiYWEyYmMwOTgxOTZlNmVhMmQzNWE1NmEzM2Y5MGUyZGE5M2I2ZDhkYWUyMTU5NDg4ZTQifQ%3D%3D; expires=Tue, 22-Apr-2025 01:26:27 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6IjNtaG1pYWF1dzV6VmZOeTRrQ2RMdnc9PSIsInZhbHVlIjoidW5maTVRNFwvbGg4blBjNVZvUnZ4N3l6QTJKNURqQW93U05nQ3c1WXZoQXNOQXVYbkN2S1NGaXJMb3" 2 => "visit_counter=eyJpdiI6IlQyMnZwUWpUcVgzYkhldUxtZm4rMlE9PSIsInZhbHVlIjoiZWFka29BWFRpWmVVUTkxUnlsdHBHNDZTdWJyQW9teWQzelNsN0Z6bWlWdWo2OTlsWmVcL2ErK2dKVmU4NzFPQUEiLCJtYWMiOiI2OWE5MDQzNjYyN2VkMjBhZTQwNGU5NjFlMzJhNTA0N2JmZGUyMjIxNTVhYWE5YjZhNTg5YThiMjU2NmVjNWE4In0%3D; expires=Wed, 21-May-2025 23:26:27 GMT; path=/; httponlyvisit_counter=eyJpdiI6IlQyMnZwUWpUcVgzYkhldUxtZm4rMlE9PSIsInZhbHVlIjoiZWFka29BWFRpWmVVUTkxUnlsdHBHNDZTdWJyQW9teWQzelNsN0Z6bWlWdWo2OTlsWmVcL2ErK2dKVmU4NzFPQUEiLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "Ryw8iJikMpByswR6CevDcSxUYoGuerUIO8bsz8z4" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/manchester/members" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]