Madrid

Spain

Madrid CTBUH Members

7.3.33PHP Version706msRequest Duration10MBMemory UsageGET city/{slug}/membersRoute
    • Booting (15.84ms)
    • Application (690ms)
    • 1 x Application (97.74%)
      690.02ms
      1 x Booting (2.24%)
      15.84ms
      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
      37 statements were executed, 5 of which were duplicated, 32 unique628ms
      • select * from `v2_cities` where `slug` = 'madrid' limit 142.17ms/app/Http/Controllers/CityController.php:639buldingdb
        Metadata
        Bindings
        • 0. madrid
        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 (51)1.46ms/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)2.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 `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 (903) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc267ms/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 (903)2.65ms/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 (903) order by `start_date` desc8.63ms/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 (903)1.46ms/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 (903) order by `type` asc, `date` desc12.26ms/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 (903)12.62ms/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 (26, 34, 115, 446, 959, 960, 2543, 2699, 2700, 2701, 3248, 3256, 3274, 3419, 3420, 6253, 6257, 6577, 6626, 6686, 6870, 7421, 7634, 8581, 36311) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc5.79ms/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` = 903 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc11.52ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 903
        • 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` = 111 and `ctbuh_company`.`deleted_at` is null5.99ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 111
        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` = 376 and `ctbuh_company`.`deleted_at` is null2.77ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 376
        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.09ms/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.23ms/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` = 41 limit 11.38ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 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
        • 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.76ms/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` = 25 limit 11.23ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 25
        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` = 903 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc2.35ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 903
        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` = 903 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-02-17 15:52:47' and `deleted_at` is null order by `published_at` desc2.39ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 903
        • 1. 2025-02-17 15:52:47
        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` = 51 limit 11.93ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 51
        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` asc2.39ms/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` = 111 order by `headquarters` desc, `contact` desc, `name` asc2.2ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 111
        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(8863) 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(8863)) )114ms/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` = 111 order by `display_order` asc, `field` asc5.65msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 111
        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` = 376 order by `headquarters` desc, `contact` desc, `name` asc1.58ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 376
        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(7195) 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(7195)) )91.66ms/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` = 376 order by `display_order` asc, `field` asc2.66msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 376
        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.31ms/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.27ms/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.23ms/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` asc1.37ms/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` asc1.61ms/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` asc1.55ms/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` asc1.23ms/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` asc4.36ms/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` asc2.37ms/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
      46
      App\CtbuhCompany
      2
      App\Member
      2
      App\Role
      15
      App\Person
      25
      App\Initiative
      4
      App\Building
      35
      App\Region
      1
      App\Country
      2
      App\City
      5
          _token
          Oe8TKDMJv7eo6zTvNLv0y7GWbXuZz3pCdDbfio0C
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/madrid/members" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/madrid/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" => "35573" "REMOTE_ADDR" => "3.145.196.175" "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/madrid/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" => 1739807566.9506 "REQUEST_TIME" => 1739807566 ]
          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, 17 Feb 2025 15:52:47 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJldDd0M0YrSHZJNE54REluRHA5aHc9PSIsInZhbHVlIjoid2lMMDlGWUx4YlhXSmdTZ1NPZ3JRNlZUb3JGUVJma0QzSmNhaGUzV1UwUzZybzJyb2RzUGk4bVwvNVl1VUpWTnByc3pLdFc5NDlzZFUycGRldFwvU2pENFFOcjh3dlpPajVlT0tqQ01xWlNDZVZNZGZNUmtcL1lFckkrcmFRbE52RjciLCJtYWMiOiI1MGUyODYxYTk5MTA4MmE2MmJlZjFiYTA3ZWNhYjE3MTAwMzJhYjEwZmFiM2UzZjM3M2M2YzcxNGQyM2RhNDc1In0%3D; expires=Mon, 17-Feb-2025 17:52:47 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IjJldDd0M0YrSHZJNE54REluRHA5aHc9PSIsInZhbHVlIjoid2lMMDlGWUx4YlhXSmdTZ1NPZ3JRNlZUb3JGUVJma0QzSmNhaGUzV1UwUzZybzJyb2RzUGk4bVwvNVl1VUpWTnByc3pLd" 1 => "skyscraper_center_session=eyJpdiI6Imc2SldcLzlyd1wvMmpJazNXNlE2Q3R6Zz09IiwidmFsdWUiOiJUdHN4XC9sWEEwQW1RaHBIUUlSZ0U1NEpSWjR2cUpaVzc2cDhCd2h1OVwvSFFvcTFPOXlnZXJHRFVTRDJPWjZkaEo1VjZOdWVWTjRKZzFqRmtmcEI4MExvQ0ZJcGsrZVFhVkptSHc2RW11YVpcL1RSdWRYUGVTZjZseVlsUW1IZ3gwaCIsIm1hYyI6IjIwZTFmYTg0NDYxZjc3MjMxZjc1ODZhNTRkNjNjMzhmN2Y0NGEwNWNjOTljNjNmYzlhOGQzZDg4Yzg3NzA5ODQifQ%3D%3D; expires=Mon, 17-Feb-2025 17:52:47 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6Imc2SldcLzlyd1wvMmpJazNXNlE2Q3R6Zz09IiwidmFsdWUiOiJUdHN4XC9sWEEwQW1RaHBIUUlSZ0U1NEpSWjR2cUpaVzc2cDhCd2h1OVwvSFFvcTFPOXlnZXJHRF" 2 => "visit_counter=eyJpdiI6Im5KTlRxeTBCOHlNaTRMc1ZmRUxHMFE9PSIsInZhbHVlIjoiYlNPMWlISTExZWl4a1ZweTNGVDhWN25tY3ZOR2lndmJtUllRd3pUQ242N1wvdGIzS2w2NkVocmVsalNQYllFazUiLCJtYWMiOiI5NDNmZjRlMmQzZDcwZThhYzQwOGUzZTUwOTYyYmVmMDhmMjQzZDUxOGU4MDI5YTNlZTNjOWQzMjE2YzI0NWVhIn0%3D; expires=Wed, 19-Mar-2025 15:52:46 GMT; Max-Age=2591999; path=/; httponlyvisit_counter=eyJpdiI6Im5KTlRxeTBCOHlNaTRMc1ZmRUxHMFE9PSIsInZhbHVlIjoiYlNPMWlISTExZWl4a1ZweTNGVDhWN25tY3ZOR2lndmJtUllRd3pUQ242N1wvdGIzS2w2NkVocmVsalNQYllFazUiLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IjJldDd0M0YrSHZJNE54REluRHA5aHc9PSIsInZhbHVlIjoid2lMMDlGWUx4YlhXSmdTZ1NPZ3JRNlZUb3JGUVJma0QzSmNhaGUzV1UwUzZybzJyb2RzUGk4bVwvNVl1VUpWTnByc3pLdFc5NDlzZFUycGRldFwvU2pENFFOcjh3dlpPajVlT0tqQ01xWlNDZVZNZGZNUmtcL1lFckkrcmFRbE52RjciLCJtYWMiOiI1MGUyODYxYTk5MTA4MmE2MmJlZjFiYTA3ZWNhYjE3MTAwMzJhYjEwZmFiM2UzZjM3M2M2YzcxNGQyM2RhNDc1In0%3D; expires=Mon, 17-Feb-2025 17:52:47 GMT; path=/XSRF-TOKEN=eyJpdiI6IjJldDd0M0YrSHZJNE54REluRHA5aHc9PSIsInZhbHVlIjoid2lMMDlGWUx4YlhXSmdTZ1NPZ3JRNlZUb3JGUVJma0QzSmNhaGUzV1UwUzZybzJyb2RzUGk4bVwvNVl1VUpWTnByc3pLd" 1 => "skyscraper_center_session=eyJpdiI6Imc2SldcLzlyd1wvMmpJazNXNlE2Q3R6Zz09IiwidmFsdWUiOiJUdHN4XC9sWEEwQW1RaHBIUUlSZ0U1NEpSWjR2cUpaVzc2cDhCd2h1OVwvSFFvcTFPOXlnZXJHRFVTRDJPWjZkaEo1VjZOdWVWTjRKZzFqRmtmcEI4MExvQ0ZJcGsrZVFhVkptSHc2RW11YVpcL1RSdWRYUGVTZjZseVlsUW1IZ3gwaCIsIm1hYyI6IjIwZTFmYTg0NDYxZjc3MjMxZjc1ODZhNTRkNjNjMzhmN2Y0NGEwNWNjOTljNjNmYzlhOGQzZDg4Yzg3NzA5ODQifQ%3D%3D; expires=Mon, 17-Feb-2025 17:52:47 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6Imc2SldcLzlyd1wvMmpJazNXNlE2Q3R6Zz09IiwidmFsdWUiOiJUdHN4XC9sWEEwQW1RaHBIUUlSZ0U1NEpSWjR2cUpaVzc2cDhCd2h1OVwvSFFvcTFPOXlnZXJHRF" 2 => "visit_counter=eyJpdiI6Im5KTlRxeTBCOHlNaTRMc1ZmRUxHMFE9PSIsInZhbHVlIjoiYlNPMWlISTExZWl4a1ZweTNGVDhWN25tY3ZOR2lndmJtUllRd3pUQ242N1wvdGIzS2w2NkVocmVsalNQYllFazUiLCJtYWMiOiI5NDNmZjRlMmQzZDcwZThhYzQwOGUzZTUwOTYyYmVmMDhmMjQzZDUxOGU4MDI5YTNlZTNjOWQzMjE2YzI0NWVhIn0%3D; expires=Wed, 19-Mar-2025 15:52:46 GMT; path=/; httponlyvisit_counter=eyJpdiI6Im5KTlRxeTBCOHlNaTRMc1ZmRUxHMFE9PSIsInZhbHVlIjoiYlNPMWlISTExZWl4a1ZweTNGVDhWN25tY3ZOR2lndmJtUllRd3pUQ242N1wvdGIzS2w2NkVocmVsalNQYllFazUiLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "Oe8TKDMJv7eo6zTvNLv0y7GWbXuZz3pCdDbfio0C" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/madrid/members" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]