Tokyo

Japan

Facts

Population

Source: Ministry of Internal Affairs and Communications

13,185,502 (2011)

Area

2,188 km²

845 mi²

Density

6026.3 people per km²

15608 people per mi²

# of 150m+ buildings

160 Completed • 11 Under Construction

First 150m+ Building

Tallest Building

Most Common Function*

Office (39%)

Most Common Material*

Steel (54%)

Rankings

by no. of 150m+ completed buildings

#

6

Tallest City in

the World
#

4

Tallest City in

Asia
#

1

Tallest City in

Japan

Buildings

CTBUH People & Events

Vertical Transportation: Ascent & Acceleration

12 September 2017

2016 China-Japan-Korea Tall Building Forum

08 July 2016

Videos

17 October 2016

The Largest Megacity in the World: Assessing the Urbanization of the Pearl River Delta

With the world’s urban population expected to increase by roughly 2.5 billion people by 2050, developing an understanding of megalopolises is critical to understanding and...

View all

Research

28 October 2019

The Future of Sustainable Cities and How Tall Building Urbanism has Evolved

In the past 50 years, tall buildings and their relationship to streets and open spaces has evolved through various scales and typologies. As place-makers, how...

View all

Research

29 July 2019

Using AI to Simulate Urban Vertical Growth

This research explores the use of artificial intelligence to simulate how cities will grow vertically. By learning how cities have evolved in the recent past,...

View all
7.3.33PHP Version2.48sRequest Duration25MBMemory UsageGET city/{slug}Route
    • Booting (15.12ms)
    • Application (2.46s)
    • 1 x Application (99.38%)
      2.46s
      1 x Booting (0.61%)
      15.12ms
      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
      97 statements were executed, 15 of which were duplicated, 82 unique2.14s
      • select * from `v2_cities` where `slug` = 'tokyo' limit 112.45ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Bindings
        • 0. tokyo
        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 (82)1.42ms/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 (7)1.31ms/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 (1049) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc370ms/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 (1049)1.44ms/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 (1049) order by `start_date` desc1.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 (746, 1049, 1539)1.62ms/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 (1049) order by `type` asc, `date` desc5.62ms/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 (1049)15.7ms/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 (378, 472, 657, 738, 884, 885, 971, 972, 973, 974, 1034, 1100, 1112, 1113, 1114, 1161, 1162, 1163, 1164, 1216, 1217, 1218, 1238, 1239, 1275, 1296, 1297, 1298, 1299, 1303, 1304, 1305, 1306, 1307, 1308, 1309, 1310, 1311, 1334, 1335, 1336, 1337, 1350, 1394, 1395, 1396, 1397, 1470, 1471, 1472, 1529, 1530, 1531, 1572, 1573, 1574, 1575, 1646, 1705, 1706, 1707, 1843, 1876, 1877, 1878, 1879, 1880, 1881, 1907, 1908, 1912, 1949, 1950, 1966, 1967, 1968, 1992, 1993, 1994, 2011, 2013, 2018, 2022, 2023, 2024, 2025, 2028, 2029, 2030, 2031, 2036, 2037, 2038, 2047, 2060, 2065, 2066, 2069, 2070, 2071, 2080, 2109, 2110, 2120, 2130, 2159, 2163, 2187, 2188, 2189, 2195, 2255, 2258, 2265, 2280, 2282, 2296, 2332, 2339, 2355, 2367, 2368, 2380, 2381, 2382, 2499, 2867, 2868, 2869, 2870, 2871, 2872, 2873, 2874, 2875, 2881, 2944, 2980, 2988, 2989, 2990, 2991, 2992, 2993, 2994, 3050, 3051, 3052, 3146, 3176, 3228, 3247, 3259, 3285, 3376, 3434, 3435, 3485, 3580, 3619, 3938, 3939, 4532, 4767, 6062, 7163, 7186, 7190, 7191, 9090, 9122, 10849, 11040, 11044, 11052, 11062, 11063, 11064, 11430, 18010, 21467, 33831, 35652, 36242, 38534, 38535, 38537, 38538, 38545, 38999, 39218, 39249, 39250, 39295, 40076, 40209, 40210, 40874) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc3.3ms/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` = 1049 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc2.69ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 1049
        • 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` = 1702 and `ctbuh_company`.`deleted_at` is null2.05ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 1702
        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` = 874 and `ctbuh_company`.`deleted_at` is null7.43ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 874
        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` = 652 and `ctbuh_company`.`deleted_at` is null2.06ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 652
        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` = 781 and `ctbuh_company`.`deleted_at` is null10.11ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 781
        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` = 221 and `ctbuh_company`.`deleted_at` is null4.91ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 221
        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` = 232 and `ctbuh_company`.`deleted_at` is null2.22ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 232
        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` = 294 and `ctbuh_company`.`deleted_at` is null2.79ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 294
        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` = 319 and `ctbuh_company`.`deleted_at` is null2.92ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 319
        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` = 320 and `ctbuh_company`.`deleted_at` is null2.15ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 320
        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` = 644 and `ctbuh_company`.`deleted_at` is null3.18ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 644
        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` = 1709 and `ctbuh_company`.`deleted_at` is null2.38ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 1709
        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'15.51ms/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'3.93ms/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.64ms/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.6ms/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.27ms/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 17.47ms/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'4.83ms/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'2.02ms/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` = 38 limit 12.27ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 38
        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.37ms/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` = 36 limit 11.44ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 36
        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.49ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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` = 39 limit 11.8ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 39
        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.47ms/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` = 32 limit 11.4ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 32
        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'5.08ms/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` = 35 limit 15.96ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 35
        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'2.62ms/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 14.31ms/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 * from `v2_resource_categories` where `type` = 'Video'5.99ms/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` = 10 limit 16.16ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 10
        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.8ms/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` = 24 limit 13.78ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 24
        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` = 1049 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc4.22ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 1049
        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` = 1049 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-09 04:33:04' and `deleted_at` is null order by `published_at` desc2.77ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 1049
        • 1. 2025-04-09 04:33:04
        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` = 82 limit 11.67ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 82
        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 = '1049' ORDER BY height_architecture DESC LIMIT 115.96ms/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, name12.75ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/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 = '82' ORDER BY num_buildings DESC, name1.61ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/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 = '1049' AND completed != 0 AND status IN('COM') AND height_architecture >= 15071ms/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` asc2.66ms/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` = 1049 order by `position` asc7.76msview::cities.tabs.overview:9buldingdb
        Metadata
        Bindings
        • 0. 1049
        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` = 1049 and `ctbuh_building`.`deleted_at` is null122ms/app/Domain/CityFacts.php:71buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. building
        • 3. COM
        • 4. UC
        • 5. STO
        • 6. UCT
        • 7. 150
        • 8. 1049
        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` = 1049 and `ctbuh_building`.`deleted_at` is null156ms/app/Domain/CityFacts.php:116buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. building
        • 3. COM
        • 4. UC
        • 5. STO
        • 6. UCT
        • 7. 150
        • 8. 1049
        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` = 1702 order by `headquarters` desc, `contact` desc, `name` asc3.95ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 1702
        Backtrace
        • 19. /app/Member.php:49
        • 20. /app/Member.php:61
        • 21. view::cities.sections.companies-table:68
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 1702 order by `display_order` asc, `field` asc1.64msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 1702
        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` = 874 order by `headquarters` desc, `contact` desc, `name` asc1.6ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 874
        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(2830) 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(2830)) )94.05ms/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` = 874 order by `display_order` asc, `field` asc1.6msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 874
        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` = 652 order by `headquarters` desc, `contact` desc, `name` asc1.72ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 652
        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(7936) 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(7936)) )120ms/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` = 652 order by `display_order` asc, `field` asc1.72msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 652
        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` = 781 order by `headquarters` desc, `contact` desc, `name` asc4.6ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 781
        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(1695,3366,1016,498,1738,3244,6131) 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(1695,3366,1016,498,1738,3244,6131)) )194ms/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` = 781 order by `display_order` asc, `field` asc1.48msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 781
        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` = 221 order by `headquarters` desc, `contact` desc, `name` asc1.72ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 221
        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(273) 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(273)) )101ms/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` = 221 order by `display_order` asc, `field` asc5.17msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 221
        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` = 232 order by `headquarters` desc, `contact` desc, `name` asc2.19ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 232
        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(18056) 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(18056)) )135ms/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` = 232 order by `display_order` asc, `field` asc1.63msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 232
        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` = 294 order by `headquarters` desc, `contact` desc, `name` asc1.74ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 294
        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(350) 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(350)) )103ms/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` = 294 order by `display_order` asc, `field` asc2.05msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 294
        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` = 319 order by `headquarters` desc, `contact` desc, `name` asc3.36ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 319
        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(374) 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(374)) )102ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/Member.php:129
        • 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383
        • 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378
        • 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
      • select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 319 order by `display_order` asc, `field` asc1.42msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 319
        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` = 320 order by `headquarters` desc, `contact` desc, `name` asc2.22ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 320
        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(375) 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(375)) )90.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/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` = 320 order by `display_order` asc, `field` asc1.44msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 320
        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` = 644 order by `headquarters` desc, `contact` desc, `name` asc1.98ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 644
        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(9828) 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(9828)) )86.55ms/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` = 644 order by `display_order` asc, `field` asc6.98msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 644
        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` = 1709 order by `headquarters` desc, `contact` desc, `name` asc2.01ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 1709
        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(23755) 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(23755)) )107ms/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` = 1709 order by `display_order` asc, `field` asc1.44msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 1709
        Backtrace
        • 19. view::cities.sections.companies-table:93
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • select * from `nav_menu_items` where `parent_id` is null2.11ms/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.28ms/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.5ms/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.3ms/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.49ms/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` asc2.47ms/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.78ms/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` asc1.52ms/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.43ms/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
      81
      App\CtbuhCompany
      17
      App\Member
      11
      App\Role
      30
      App\Person
      198
      App\Initiative
      10
      App\Building
      832
      App\Region
      1
      App\Country
      2
      App\City
      20
          _token
          ieaWShs5LY1wyDRRUuwZalpRevgmjvGDhf9se6PD
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/tokyo" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/tokyo
          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" => "28920" "REMOTE_ADDR" => "13.58.64.128" "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/tokyo" "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" => 1744173183.6666 "REQUEST_TIME" => 1744173183 ]
          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 04:33:04 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRFRkpWOFQ5XC9kVHQ1MTIybnlPXC9wZz09IiwidmFsdWUiOiJJVHVpSm92a3ZSMDNQXC8zeGErUnVncDNHdzRXbXo3bUlcL0ZwK1J6VzZwU3JTU1VIS1Y1R09iUG8zdHEwdWpPTXhpamhyaUtpcEpxYjVwRmptWVwvWCt5NzJablAzTCtpSFNyZGpBbnZsaXRFN0pFRjJpbFhoUHBJVEp3RGF1K3NjdiIsIm1hYyI6IjRhMjhiOTc2OGVjNGE0ZmQyNjExMDgxY2U3ZTFjOGYwY2E4NWM5ZDExYjhkZmJjMTNjZjM5NmMxODE2YTU5NDgifQ%3D%3D; expires=Wed, 09-Apr-2025 06:33:06 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IlRFRkpWOFQ5XC9kVHQ1MTIybnlPXC9wZz09IiwidmFsdWUiOiJJVHVpSm92a3ZSMDNQXC8zeGErUnVncDNHdzRXbXo3bUlcL0ZwK1J6VzZwU3JTU1VIS1Y1R09iUG8zdHEwdWpPTXhpa" 1 => "skyscraper_center_session=eyJpdiI6InVUM0xpYnRUSzVaSElxaUpUcFwvS2pBPT0iLCJ2YWx1ZSI6IkZZbnZrV01SN2RaZWdTelREMkUya1NhTFRVV3dxd1ZPR3V1cUJsNUpGU29LT3dHMXhFS0Q2NWo3Qm1WZ1wvM3VWemtiTE0zQ0RGNDRINXh4cjhuVlZlUGNCSkhDUDZmNUx6bFFKZWlOUVN1QUpLTHpjNUNoanJZRFRJV3dSNk1zQyIsIm1hYyI6IjUwNGY1NGJmZmI1OTcxZTFmNDNmZjNlNTcwM2ViOWYxOGFhZGU3MWQ0NDY2YTg1NWRhNGRmOWJjMzRkZTY5ZWUifQ%3D%3D; expires=Wed, 09-Apr-2025 06:33:06 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6InVUM0xpYnRUSzVaSElxaUpUcFwvS2pBPT0iLCJ2YWx1ZSI6IkZZbnZrV01SN2RaZWdTelREMkUya1NhTFRVV3dxd1ZPR3V1cUJsNUpGU29LT3dHMXhFS0Q2NWo3Qm" 2 => "visit_counter=eyJpdiI6Imw3dHRDVEJoSmJwUzcwXC84RzQzdHJ3PT0iLCJ2YWx1ZSI6IlM4OTJiWEZYeGNENStrUTRsekVXMlJnVmxqalVxdzR0XC9VNFNVS1VRY2s3dWRcL0taV1lUTFdyck5jcklRdVZZMyIsIm1hYyI6IjFjODJkYWZiMjVjZmQ3YWE4OTg5NGNkYjc0OGQwMjA0ZmEyMjM1Y2VkNWExNzM0NmI4NmRlMTUyOTExMTdjZjEifQ%3D%3D; expires=Fri, 09-May-2025 04:33:03 GMT; Max-Age=2591997; path=/; httponlyvisit_counter=eyJpdiI6Imw3dHRDVEJoSmJwUzcwXC84RzQzdHJ3PT0iLCJ2YWx1ZSI6IlM4OTJiWEZYeGNENStrUTRsekVXMlJnVmxqalVxdzR0XC9VNFNVS1VRY2s3dWRcL0taV1lUTFdyck5jcklRdVZZMy" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IlRFRkpWOFQ5XC9kVHQ1MTIybnlPXC9wZz09IiwidmFsdWUiOiJJVHVpSm92a3ZSMDNQXC8zeGErUnVncDNHdzRXbXo3bUlcL0ZwK1J6VzZwU3JTU1VIS1Y1R09iUG8zdHEwdWpPTXhpamhyaUtpcEpxYjVwRmptWVwvWCt5NzJablAzTCtpSFNyZGpBbnZsaXRFN0pFRjJpbFhoUHBJVEp3RGF1K3NjdiIsIm1hYyI6IjRhMjhiOTc2OGVjNGE0ZmQyNjExMDgxY2U3ZTFjOGYwY2E4NWM5ZDExYjhkZmJjMTNjZjM5NmMxODE2YTU5NDgifQ%3D%3D; expires=Wed, 09-Apr-2025 06:33:06 GMT; path=/XSRF-TOKEN=eyJpdiI6IlRFRkpWOFQ5XC9kVHQ1MTIybnlPXC9wZz09IiwidmFsdWUiOiJJVHVpSm92a3ZSMDNQXC8zeGErUnVncDNHdzRXbXo3bUlcL0ZwK1J6VzZwU3JTU1VIS1Y1R09iUG8zdHEwdWpPTXhpa" 1 => "skyscraper_center_session=eyJpdiI6InVUM0xpYnRUSzVaSElxaUpUcFwvS2pBPT0iLCJ2YWx1ZSI6IkZZbnZrV01SN2RaZWdTelREMkUya1NhTFRVV3dxd1ZPR3V1cUJsNUpGU29LT3dHMXhFS0Q2NWo3Qm1WZ1wvM3VWemtiTE0zQ0RGNDRINXh4cjhuVlZlUGNCSkhDUDZmNUx6bFFKZWlOUVN1QUpLTHpjNUNoanJZRFRJV3dSNk1zQyIsIm1hYyI6IjUwNGY1NGJmZmI1OTcxZTFmNDNmZjNlNTcwM2ViOWYxOGFhZGU3MWQ0NDY2YTg1NWRhNGRmOWJjMzRkZTY5ZWUifQ%3D%3D; expires=Wed, 09-Apr-2025 06:33:06 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6InVUM0xpYnRUSzVaSElxaUpUcFwvS2pBPT0iLCJ2YWx1ZSI6IkZZbnZrV01SN2RaZWdTelREMkUya1NhTFRVV3dxd1ZPR3V1cUJsNUpGU29LT3dHMXhFS0Q2NWo3Qm" 2 => "visit_counter=eyJpdiI6Imw3dHRDVEJoSmJwUzcwXC84RzQzdHJ3PT0iLCJ2YWx1ZSI6IlM4OTJiWEZYeGNENStrUTRsekVXMlJnVmxqalVxdzR0XC9VNFNVS1VRY2s3dWRcL0taV1lUTFdyck5jcklRdVZZMyIsIm1hYyI6IjFjODJkYWZiMjVjZmQ3YWE4OTg5NGNkYjc0OGQwMjA0ZmEyMjM1Y2VkNWExNzM0NmI4NmRlMTUyOTExMTdjZjEifQ%3D%3D; expires=Fri, 09-May-2025 04:33:03 GMT; path=/; httponlyvisit_counter=eyJpdiI6Imw3dHRDVEJoSmJwUzcwXC84RzQzdHJ3PT0iLCJ2YWx1ZSI6IlM4OTJiWEZYeGNENStrUTRsekVXMlJnVmxqalVxdzR0XC9VNFNVS1VRY2s3dWRcL0taV1lUTFdyck5jcklRdVZZMy" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "ieaWShs5LY1wyDRRUuwZalpRevgmjvGDhf9se6PD" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/tokyo" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]