Madrid

Spain

Facts

Density

0 people per km²

0 people per mi²

# of 150m+ buildings

5 Completed • 1 Under Construction

First 150m+ Building

Tallest Building

Most Common Function*

Office (67%)

Most Common Material*

Concrete (60%)

Rankings

by no. of 150m+ completed buildings

#

125

Tallest City in

the World
#

9

Tallest City in

Europe
#

1

Tallest City in

Spain

Buildings

CTBUH People & Events

CTBUH Spain to Host Panel Discussion on Tall Buildings

12 January 2018

CTBUH Spain: New Material Opportunities

30 November 2016

Videos

18 October 2016

What’s Next?: How Do We Make Vertical Urban Design?

It seems sometimes as if the further away from the ground we rise, the more architectonic and less urban our buildings become. Skyscrapers have always...

View all

Research

17 October 2016

What’s Next?: How Do We Make Vertical Urban Design?

It seems sometimes as if the further away from the ground we rise, the more architectonic and less urban our buildings become. Skyscrapers have always...

View all

Research

17 October 2016

A Smart Real-Time Monitoring GNSS System for High-Rise Buildings

This paper analyzes and develops a real-time GNSS monitoring system to evaluate the lateral and torsional displacement and wind-induced response of a high-rise building. The...

View all
7.3.33PHP Version1.32sRequest Duration11MBMemory UsageGET city/{slug}Route
    • Booting (21.09ms)
    • Application (1.29s)
    • 1 x Application (98.38%)
      1.29s
      1 x Booting (1.6%)
      21.09ms
      23 templates were rendered
      • cities.tabs.overview (resources/views/cities/tabs/overview.blade.php)28blade
        Params
        0
        geo
        1
        title
        2
        buildings
        3
        allBuildingStatuses
        4
        buildings_150
        5
        showFactsSection
        6
        tallestBuilding
        7
        rankingWorld
        8
        rankingRegion
        9
        rankingCountry
        10
        firstSkyscraper
        11
        statuses
        12
        timelineYears
        13
        minHeight
        14
        maxHeight
        15
        timelineMinYear
        16
        members
        17
        memberLevels
        18
        filter_values
        19
        fields
        20
        committeeTitles
        21
        initiatives
        22
        news
        23
        videos
        24
        videoCategories
        25
        research
        26
        tabsData
        27
        accessLevel
      • cities.sections.facts (resources/views/cities/sections/facts.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
      • cities.sections.rankings (resources/views/cities/sections/rankings.blade.php)34blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        header
        36
        tableId
        37
        maxItems
        38
        displayFull
      • common-redesign.login-message (resources/views/common-redesign/login-message.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        directionRight
        36
        noBottomMargin
        37
        centerMobile
      • charts.timeline-company (resources/views/charts/timeline-company.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        header
        36
        chartId
        37
        minDisplayHeight
      • cities.sections.companies-table (resources/views/cities/sections/companies-table.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        header
        36
        tableId
        37
        paginate
      • cities.sections.people-events (resources/views/cities/sections/people-events.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • common-redesign.grouped-elements (resources/views/common-redesign/grouped-elements.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • common-redesign.element.building-video-grid (resources/views/common-redesign/element/building-video-grid.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        displayedItems
        36
        __currentLoopData
        37
        video
        38
        loop
      • common-redesign.element.building-research-grid (resources/views/common-redesign/element/building-research-grid.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        displayedItems
        36
        __currentLoopData
        37
        video
        38
        loop
      • common-redesign.element.building-research-grid (resources/views/common-redesign/element/building-research-grid.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        displayedItems
        36
        __currentLoopData
        37
        video
        38
        loop
      • cities.layout (resources/views/cities/layout.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • layouts.SSC (resources/views/layouts/SSC.blade.php)35blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
      • common.header (resources/views/common/header.blade.php)37blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
        36
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)37php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
        36
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)41php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
        36
        nav
        37
        __currentLoopData
        38
        item
        39
        loop
        40
        child
      • common.footer (resources/views/common/footer.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)36blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
        36
        alreadyConsentedWithCookies
        37
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        buildings
        9
        allBuildingStatuses
        10
        buildings_150
        11
        showFactsSection
        12
        tallestBuilding
        13
        rankingWorld
        14
        rankingRegion
        15
        rankingCountry
        16
        firstSkyscraper
        17
        statuses
        18
        timelineYears
        19
        minHeight
        20
        maxHeight
        21
        timelineMinYear
        22
        members
        23
        memberLevels
        24
        filter_values
        25
        fields
        26
        committeeTitles
        27
        initiatives
        28
        news
        29
        videos
        30
        videoCategories
        31
        research
        32
        tabsData
        33
        accessLevel
        34
        filteredBuildings
        35
        data
        36
        alreadyConsentedWithCookies
        37
        cookieConsentConfig
      uri
      GET city/{slug}
      middleware
      web
      controller
      App\Http\Controllers\CityController@display
      namespace
      App\Http\Controllers
      prefix
      where
      as
      city-home
      file
      app/Http/Controllers/CityController.php:19-246
      44 statements were executed, 5 of which were duplicated, 39 unique1.12s
      • select * from `v2_cities` where `slug` = 'madrid' limit 115.04ms/app/Http/Controllers/CityController.php:29buldingdb
        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:29
        • 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.33ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:29
        • 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.06ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:29
        • 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` asc390ms/app/Http/Controllers/CityController.php:29buldingdb
        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:29
        • 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.41ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 26. /app/Http/Controllers/CityController.php:29
        • 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` desc6.71ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:29
        • 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)2.21ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:29
        • 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` desc5.8ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:29
        • 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)6.9ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:29
        • 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.83ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:29
        • 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` asc6.37ms/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:31
        • 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 null4.41ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 111
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:31
        • 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 null6.24ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 376
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:31
        • 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'3.95ms/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:31
        • 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.54ms/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:31
        • 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.56ms/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:31
        • 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.38ms/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:31
        • 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.59ms/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:31
        • 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.37ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 903
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:896
        • 20. /app/Http/Controllers/CityController.php:31
        • 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-04-09 13:08:01' and `deleted_at` is null order by `published_at` desc1.69ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 903
        • 1. 2025-04-09 13:08:01
        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:31
        • 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 14.32ms/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:31
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT id, name_intl, height_architecture FROM ctbuh_building b WHERE b.active = 1 AND b.structure_type = 'building' AND b.status IN('COM') AND b.height_architecture >= 150 AND b.city_id = '903' ORDER BY height_architecture DESC LIMIT 122.68ms/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/Http/Controllers/CityController.php:52
        • 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 num_buildings_150 AS num_buildings, code AS city_locode, id FROM v2_cities ORDER BY num_buildings DESC, name17.8ms/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/Http/Controllers/CityController.php:66
        • 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 num_buildings_150 AS num_buildings, code AS city_locode, id FROM v2_cities WHERE country_id = '51' ORDER BY num_buildings DESC, name1.63ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/Http/Controllers/CityController.php:103
        • 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 ROUND(AVG(Year(CURDATE()) - completed), 0) AS age FROM ctbuh_building WHERE active = 1 AND structure_type = 'building' AND city_id = '903' AND completed != 0 AND status IN('COM') AND height_architecture >= 15067.45ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/Http/Controllers/CityController.php:147
        • 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 * from `v2_fields` order by `id` asc3.7ms/app/Http/Controllers/CityController.php:202buldingdb
        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:202
        • 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 `v3_images`.*, `v3_city_image`.`city_id` as `pivot_city_id`, `v3_city_image`.`image_id` as `pivot_image_id`, `v3_city_image`.`position` as `pivot_position`, `v3_city_image`.`created_at` as `pivot_created_at`, `v3_city_image`.`updated_at` as `pivot_updated_at` from `v3_images` inner join `v3_city_image` on `v3_images`.`id` = `v3_city_image`.`image_id` where `v3_city_image`.`city_id` = 903 order by `position` asc2.95msview::cities.tabs.overview:9buldingdb
        Metadata
        Bindings
        • 0. 903
        Backtrace
        • 19. view::cities.tabs.overview:9
        • 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 `main_use_01`, `main_use_02` from `ctbuh_building` where `active` = 1 and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `structure_type` = 'building' and `status` in ('COM', 'UC', 'STO', 'UCT') and `height_architecture` >= 150 and `city_id` = 903 and `ctbuh_building`.`deleted_at` is null164ms/app/Domain/CityFacts.php:71buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. building
        • 3. COM
        • 4. UC
        • 5. STO
        • 6. UCT
        • 7. 150
        • 8. 903
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 14. /app/Domain/CityFacts.php:71
        • 15. /app/Domain/CityFacts.php:104
        • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383
        • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378
        • 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
      • select `structural_material` from `ctbuh_building` where `active` = 1 and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `structure_type` = 'building' and `status` in ('COM', 'UC', 'STO', 'UCT') and `height_architecture` >= 150 and `city_id` = 903 and `ctbuh_building`.`deleted_at` is null118ms/app/Domain/CityFacts.php:116buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. building
        • 3. COM
        • 4. UC
        • 5. STO
        • 6. UCT
        • 7. 150
        • 8. 903
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 14. /app/Domain/CityFacts.php:116
        • 15. /app/Domain/CityFacts.php:149
        • 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383
        • 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378
        • 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
      • 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` asc1.93ms/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)) )112ms/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` asc2.18msview::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` asc2.1ms/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)) )110ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/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` asc1.99msview::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.98ms/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.86ms/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.97ms/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` asc3.24ms/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.71ms/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.57ms/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.48ms/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` asc3.69ms/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` asc1.52ms/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
      47
      App\Region
      1
      App\Country
      2
      App\City
      5
          _token
          0y0AxDBhdRQRcICfv7deBNSiYrByqzKPpGX97BtB
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/madrid" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/madrid
          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" => "32222" "REMOTE_ADDR" => "18.216.0.219" "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" "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" => 1744204081.0561 "REQUEST_TIME" => 1744204081 ]
          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 => "Wed, 09 Apr 2025 13:08:01 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3ZlAxeWQrWHBJSU1NN0dlQ2UrVjloclwvODBpb0QyZDlSUHQrS3lWQ0ZwN0FyMEl4Y2F5WG9nRGU0SGJLUiIsIm1hYyI6IjM4MmM3OTVkYjQxMjAwZmQxNjRmNWU4NDYzYzMzNGU0NDI0MTM1YWJjMTM2OWQ3Yjg5YTY0ZjA3NjQ3ZDMwNjIifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3Z" 1 => "skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2o4a3Rxa0psdjhFWlZHSEhKZ1ZBUGh6TzlFeEY1b3czbjI4ZDdCd1d1XC9ZSEZCOTJDUWYwb0RPMTE3VHNkclo3am5UU3k3ciIsIm1hYyI6ImZkYjVjZjNiY2NhZjg1OTA3YTE3YTQxNTIzMWVhODE4NDdkM2E2YTVkZjg4Zjk4MzdhNmJhN2UwNGFjNDJkNTEifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2" 2 => "visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLCJtYWMiOiIwNjRhOGI3NDM2OTA2MTE0N2MxMzdkYzgxNmFmOWNmZmQ2NWZmMTA1OGRjMGU4NTVlMzQ3Nzg0ZTU2ZmE5OGY3In0%3D; expires=Fri, 09-May-2025 13:08:01 GMT; Max-Age=2591999; path=/; httponlyvisit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3ZlAxeWQrWHBJSU1NN0dlQ2UrVjloclwvODBpb0QyZDlSUHQrS3lWQ0ZwN0FyMEl4Y2F5WG9nRGU0SGJLUiIsIm1hYyI6IjM4MmM3OTVkYjQxMjAwZmQxNjRmNWU4NDYzYzMzNGU0NDI0MTM1YWJjMTM2OWQ3Yjg5YTY0ZjA3NjQ3ZDMwNjIifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; path=/XSRF-TOKEN=eyJpdiI6IlVoWnlvNFJTK1BoZXcrc2Jvd2FGVXc9PSIsInZhbHVlIjoickNEXC9NeHIzelEyRlRldUxhdXdNSDNjTlA2cVl3SGlPY3A4cmNyaHpoZFdoZ0U3aElpcHQ1VUhiN0tlSk5YNnM0Mmt3Z" 1 => "skyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2o4a3Rxa0psdjhFWlZHSEhKZ1ZBUGh6TzlFeEY1b3czbjI4ZDdCd1d1XC9ZSEZCOTJDUWYwb0RPMTE3VHNkclo3am5UU3k3ciIsIm1hYyI6ImZkYjVjZjNiY2NhZjg1OTA3YTE3YTQxNTIzMWVhODE4NDdkM2E2YTVkZjg4Zjk4MzdhNmJhN2UwNGFjNDJkNTEifQ%3D%3D; expires=Wed, 09-Apr-2025 15:08:02 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6InNXQjVqSWdaaTFYdnVWYWFBTVRhdVE9PSIsInZhbHVlIjoiSkllaUdzOWlSSzFtU2V1YjIxamZHTE9OY1p3TFdnXC9ra29wN1F2bjNOSVlkYVVlNGtNZ2ZUMkFHK2" 2 => "visit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLCJtYWMiOiIwNjRhOGI3NDM2OTA2MTE0N2MxMzdkYzgxNmFmOWNmZmQ2NWZmMTA1OGRjMGU4NTVlMzQ3Nzg0ZTU2ZmE5OGY3In0%3D; expires=Fri, 09-May-2025 13:08:01 GMT; path=/; httponlyvisit_counter=eyJpdiI6Ing3Tk5sT2U0dDk4WlZXMkFkRkZIQXc9PSIsInZhbHVlIjoieGM4Z2dvblF1WVZpUmlEUXo4OENwZFJHcVo1cjdoVjVxc1Nkd1RaT1ROR0poXC9EdkVCU1lHa0NHc1g5dUpQR3EiLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "0y0AxDBhdRQRcICfv7deBNSiYrByqzKPpGX97BtB" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/madrid" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]