Brisbane

Australia

Facts

Population

2,189,878 (2013)

Area

5,950 km²

2,297 mi²

Density

368 people per km²

953.2 people per mi²

# of 150m+ buildings

15 Completed • 4 Under Construction

First 150m+ Building

Tallest Building

Most Common Function*

Office (47%)

Most Common Material*

Concrete (84%)

Rankings

by no. of 150m+ completed buildings

#

69

Tallest City in

the World
#

3

Tallest City in

Oceania
#

3

Tallest City in

Australia

Buildings

CTBUH People & Events

Katrina Face

City Committee

Katrina Face

Destination Brisbane Consortium

2019 Global Walking Tour: 50 Forward | 50 Back

27 Jun-09 August 2019

CTBUH Brisbane Holds Successful Cities Seminar: QDesign

23 May 2019

Videos

23 May 2019

CTBUH Brisbane Successful Cities Seminar: QDesign

On Thursday, 23 May, the CTBUH Australia Chapter's Brisbane Committee hosted the second installment of its Successful Cities Seminar, discussing the QDesign Initiative.

View all

Research

30 April 2018

Brisbane's Subtropical Livability Goals and High-Rise Apartments: Vision and Reality

Climate-based design is very significant in the Brisbane planning context. Brisbane City Council’s Vision 2031 aspires to capitalize on the city’s enviable subtropical climate and...

View all

Research

30 October 2017

Shaping Australia’s Tall Tower Design And High Livability Standards

With nearly 90% of its population expected to live in its state-capital cities by 2053, Australia is on track to become one of the world’s...

View all
7.3.33PHP Version1.64sRequest Duration18MBMemory UsageGET city/{slug}Route
    • Booting (7.43ms)
    • Application (1.63s)
    • 1 x Application (99.54%)
      1.63s
      1 x Booting (0.45%)
      7.43ms
      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
      128 statements were executed, 66 of which were duplicated, 62 unique1.46s
      • select * from `v2_cities` where `slug` = 'brisbane' limit 17.57ms/app/Http/Controllers/CityController.php:29buldingdb
        Metadata
        Bindings
        • 0. brisbane
        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 (11)1.51ms/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 (8)1.87ms/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 (648) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc561ms/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 (648)8.11ms/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 (648) order by `start_date` desc6.01ms/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 (648, 658, 723, 1539)1.59ms/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 (648) order by `type` asc, `date` desc5ms/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 (648)10.71ms/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 (246, 683, 792, 793, 794, 882, 883, 1847, 2127, 2465, 2743, 3220, 3221, 3222, 3372, 3450, 3456, 3467, 3546, 3625, 3915, 4124, 4134, 4173, 4195, 4196, 4197, 4208, 4230, 4238, 4249, 4261, 4262, 4286, 4328, 4381, 4385, 4492, 4495, 4520, 4521, 4523, 4524, 6503, 6558, 6592, 6607, 6634, 6646, 6657, 6672, 6676, 6707, 6720, 6786, 6838, 6896, 6897, 6990, 7116, 8376, 8539, 8540, 8570, 8577, 8774, 8876, 9156, 9988, 10187, 10580, 13256, 34482, 35619, 35904, 35905, 39012) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc2.7ms/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` = 648 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc3.65ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 648
        • 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` = 25 and `ctbuh_company`.`deleted_at` is null1.57ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 25
        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` = 1022 and `ctbuh_company`.`deleted_at` is null1.43ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 1022
        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` = 626 and `ctbuh_company`.`deleted_at` is null1.68ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 626
        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` = 959 and `ctbuh_company`.`deleted_at` is null1.48ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 959
        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` = 884 and `ctbuh_company`.`deleted_at` is null1.36ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 884
        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` = 1451 and `ctbuh_company`.`deleted_at` is null1.37ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 1451
        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` = 619 and `ctbuh_company`.`deleted_at` is null1.87ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 619
        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` = 325 and `ctbuh_company`.`deleted_at` is null5.92ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 325
        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'7.25ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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' and `id` = 5 limit 17.41ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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'7.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_categories` where `type` = 'Video' and `id` = 5 limit 17.33ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.7ms/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' and `id` = 19 limit 12.86ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 19
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.17ms/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'8.36ms/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' and `id` = 5 limit 17.28ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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'7.52ms/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.87ms/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' and `id` = 5 limit 15ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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'7.56ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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` = 46 limit 13.5ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 46
        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'7.53ms/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'7.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` = 46 limit 17.42ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 46
        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'7.58ms/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'7.43ms/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` = 48 limit 17.39ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 48
        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.52ms/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' and `id` = 19 limit 11.2ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 19
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.34ms/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' and `id` = 5 limit 12.16ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.23ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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' and `id` = 5 limit 11.46ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.18ms/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' and `id` = 5 limit 11.3ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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_categories` where `type` = 'Video' and `id` = 5 limit 11.35ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.19ms/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' and `id` = 5 limit 11.16ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.5ms/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' and `id` = 5 limit 11.28ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.18ms/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.39ms/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.32ms/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' and `id` = 5 limit 11.24ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.23ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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' and `id` = 5 limit 11.17ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.22ms/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' and `id` = 5 limit 11.14ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.16ms/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' and `id` = 5 limit 11.34ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.24ms/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' and `id` = 5 limit 12.64ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.21ms/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' and `id` = 5 limit 11.14ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php:31
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_categories` where `type` = 'Video'1.38ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php:31
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_categories` where `type` = 'Video' and `id` = 5 limit 11.22ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.22ms/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' and `id` = 5 limit 11.16ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.28ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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' and `id` = 5 limit 11.13ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.33ms/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' and `id` = 5 limit 13.28ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.26ms/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' and `id` = 5 limit 11.21ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.24ms/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' and `id` = 5 limit 11.41ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php:31
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_categories` where `type` = 'Video'1.38ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php:31
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 25 limit 11.3ms/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'1.56ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php: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' and `id` = 5 limit 11.24ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.31ms/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 11.25ms/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 * from `v2_resource_categories` where `type` = 'Video'1.24ms/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' and `id` = 5 limit 11.43ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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.36ms/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' and `id` = 5 limit 11.28ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:817
        • 14. /app/Http/Controllers/CityController.php: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` = 648 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc4.2ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 648
        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` = 648 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-16 00:59:29' and `deleted_at` is null order by `published_at` desc1.61ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 648
        • 1. 2025-04-16 00:59:29
        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` = 11 limit 11.4ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 11
        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 = '648' ORDER BY height_architecture DESC LIMIT 117.65ms/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, name11.16ms/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 * from `v2_fields` order by `id` asc1.67ms/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` = 648 order by `position` asc1.71msview::cities.tabs.overview:9buldingdb
        Metadata
        Bindings
        • 0. 648
        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 `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` = 25 order by `headquarters` desc, `contact` desc, `name` asc1.68ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 25
        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(567) 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(567)) )115ms/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` = 25 order by `display_order` asc, `field` asc2.05msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 25
        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` = 1022 order by `headquarters` desc, `contact` desc, `name` asc1.73ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 1022
        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(24448) 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(24448)) )77.22ms/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` = 1022 order by `display_order` asc, `field` asc1.83msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 1022
        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` = 626 order by `headquarters` desc, `contact` desc, `name` asc1.87ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 626
        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(9975) 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(9975)) )77.13ms/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` = 626 order by `display_order` asc, `field` asc1.8msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 626
        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` = 959 order by `headquarters` desc, `contact` desc, `name` asc1.98ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 959
        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(91) 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(91)) )78.27ms/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` = 959 order by `display_order` asc, `field` asc1.93msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 959
        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` = 884 order by `headquarters` desc, `contact` desc, `name` asc1.6ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 884
        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(1941) 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(1941)) )116ms/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` = 884 order by `display_order` asc, `field` asc1.99msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 884
        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` = 1451 order by `headquarters` desc, `contact` desc, `name` asc2.25ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 1451
        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(21099) 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(21099)) )79.73ms/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` = 1451 order by `display_order` asc, `field` asc1.75msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 1451
        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` = 619 order by `headquarters` desc, `contact` desc, `name` asc1.88ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 619
        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` = 619 order by `display_order` asc, `field` asc1.66msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 619
        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` = 325 order by `headquarters` desc, `contact` desc, `name` asc1.81ms/app/Member.php:49buldingdb
        Metadata
        Bindings
        • 0. 325
        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` = 325 order by `display_order` asc, `field` asc1.61msview::cities.sections.companies-table:93buldingdb
        Metadata
        Bindings
        • 0. 325
        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 `v2_members` where `v2_members`.`id` = 3062 and `v2_members`.`deleted_at` is null limit 17.04ms/app/Person.php:110buldingdb
        Metadata
        Bindings
        • 0. 3062
        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/Person.php:110
        • 21. /app/Person.php:116
        • 22. view::cities.sections.people-events:39
        • 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `parent_id` is null1.31ms/app/NavMenuItem.php:17buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/NavMenuItem.php:17
        • 15. /app/Providers/AppServiceProvider.php:60
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:124
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 27 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.54ms/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.92ms/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.56ms/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.74ms/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.21ms/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` asc2.29ms/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` asc2.44ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 29
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 1 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc2.36ms/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
      75
      App\CtbuhCompany
      8
      App\Member
      9
      App\Role
      53
      App\Person
      83
      App\Initiative
      56
      App\Building
      244
      App\Region
      1
      App\Country
      2
      App\City
      24
          _token
          Jof6WPqbxFhTaRAX6IPsCavpxRfN4L4Hq8iEThxi
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/brisbane" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/brisbane
          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:18 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6IlZYam9vZW94cVdQUUxoV1RPQTU3dUE9PSIsInZhbHVlIjoiXC83NW13ZkdyOVM3aTl4VmpUUGZKUzIxOUxWQTdNTFFOYk9uSHNBN2xpYm5CcjhYbVRyeUc1SVpPd1BSb0JcL3MzNEE0XC9sUXlOK25TMHBDMjFJXC9Zd3dpWGNrVHpTaXMxc2tkMm9ldktFcitoZUhYZnMrRDNnOWxXc05ZTkpBckJLIiwibWFjIjoiNTcwY2E0ZTgwODE3YTkxY2IwNWYwMGI2NjRmYzEzMGRjYWRjNTVkODVlYzAzNjc5NThmZmZlNTMzNmVhNzg2ZCJ9; skyscraper_center_session=eyJpdiI6InU3K25BdDZ3SlVHT21hWlhkQldxTlE9PSIsInZhbHVlIjoieUwwWnJDcGNYUmtPeWpBXC9qUjlwMUNXd1BOMFlqUWhTY0dnRjhZSlBLWjJcL2d1bUk2SDNaZ3VEdnMyZU1HQmFYa2lCUHNMWEQ1OHN4dEozTDdBRFMwZ1lvU1UwXC9odTltdHBESkc3UFc1SWZJcDZ0YzZCbmhNRjlxQlE2SmtieWsiLCJtYWMiOiI4YjE3ODA2MjBkYWIxOTFjMGUyYjY3ZGFjYzQ3MThkNTcxMmQ5YzJiZGI1NDkwNjMxMzljMDUxMGYwZTdiOGRhIn0%3D; visit_counter=eyJpdiI6Ik9KVzJZc2s5d2VcL09yVHZJQkZ5MFBnPT0iLCJ2YWx1ZSI6IkRwbmxhdFduR0FtdUoyMkMrcjVnU1YyQUp0eDBxMldsaEJGbkxsTmk4b2NYcm1rUWtacHg3b2FySVJqakZCZG4iLCJtYWMiOiJlOTE1ODI0MDI0NTNkNDczNzYyMzllMzQ5NjY5MjIxNDA2OTBjZDNiZGM2MTQ1MjEyNjY3NWI1N2I1ODc2ODZlIn0%3DXSRF-TOKEN=eyJpdiI6IlZYam9vZW94cVdQUUxoV1RPQTU3dUE9PSIsInZhbHVlIjoiXC83NW13ZkdyOVM3aTl4VmpUUGZKUzIxOUxWQTdNTFFOYk9uSHNBN2xpYm5CcjhYbVRyeUc1SVpPd1BSb0JcL3MzNEE0X" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "host" => array:1 [ 0 => "staging.skyscrapercenter.xyz" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
          request_server
          0 of 0
          array:41 [ "USER" => "forge" "HOME" => "/home/forge" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlZYam9vZW94cVdQUUxoV1RPQTU3dUE9PSIsInZhbHVlIjoiXC83NW13ZkdyOVM3aTl4VmpUUGZKUzIxOUxWQTdNTFFOYk9uSHNBN2xpYm5CcjhYbVRyeUc1SVpPd1BSb0JcL3MzNEE0XC9sUXlOK25TMHBDMjFJXC9Zd3dpWGNrVHpTaXMxc2tkMm9ldktFcitoZUhYZnMrRDNnOWxXc05ZTkpBckJLIiwibWFjIjoiNTcwY2E0ZTgwODE3YTkxY2IwNWYwMGI2NjRmYzEzMGRjYWRjNTVkODVlYzAzNjc5NThmZmZlNTMzNmVhNzg2ZCJ9; skyscraper_center_session=eyJpdiI6InU3K25BdDZ3SlVHT21hWlhkQldxTlE9PSIsInZhbHVlIjoieUwwWnJDcGNYUmtPeWpBXC9qUjlwMUNXd1BOMFlqUWhTY0dnRjhZSlBLWjJcL2d1bUk2SDNaZ3VEdnMyZU1HQmFYa2lCUHNMWEQ1OHN4dEozTDdBRFMwZ1lvU1UwXC9odTltdHBESkc3UFc1SWZJcDZ0YzZCbmhNRjlxQlE2SmtieWsiLCJtYWMiOiI4YjE3ODA2MjBkYWIxOTFjMGUyYjY3ZGFjYzQ3MThkNTcxMmQ5YzJiZGI1NDkwNjMxMzljMDUxMGYwZTdiOGRhIn0%3D; visit_counter=eyJpdiI6Ik9KVzJZc2s5d2VcL09yVHZJQkZ5MFBnPT0iLCJ2YWx1ZSI6IkRwbmxhdFduR0FtdUoyMkMrcjVnU1YyQUp0eDBxMldsaEJGbkxsTmk4b2NYcm1rUWtacHg3b2FySVJqakZCZG4iLCJtYWMiOiJlOTE1ODI0MDI0NTNkNDczNzYyMzllMzQ5NjY5MjIxNDA2OTBjZDNiZGM2MTQ1MjEyNjY3NWI1N2I1ODc2ODZlIn0%3DXSRF-TOKEN=eyJpdiI6IlZYam9vZW94cVdQUUxoV1RPQTU3dUE9PSIsInZhbHVlIjoiXC83NW13ZkdyOVM3aTl4VmpUUGZKUzIxOUxWQTdNTFFOYk9uSHNBN2xpYm5CcjhYbVRyeUc1SVpPd1BSb0JcL3MzNEE0X" "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" => "28945" "REMOTE_ADDR" => "18.221.201.67" "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/brisbane" "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" => 1744765168.5687 "REQUEST_TIME" => 1744765168 ]
          request_cookies
          0 of 0
          array:3 [ "XSRF-TOKEN" => "Jof6WPqbxFhTaRAX6IPsCavpxRfN4L4Hq8iEThxi" "skyscraper_center_session" => "HcaUQXj9qVnxLXFQLFbnPGqp5ek8WlZtsHHazO3b" "visit_counter" => "1" ]
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Wed, 16 Apr 2025 00:59:29 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1aUjk3c3JkNzJxcEtTckJudEthN3c9PSIsInZhbHVlIjoiM1QxSzNKNnV1YlpiendLSHdlUVVRR0NKWk8rc2N6MzdaNThyWUFtU1NVd0d2aG5FTkJheVBaTUpCZ2hTRlVxdjVHUDFRQldHN3ZZU0wwK0JZT0EyY2l3dit1cmZpRmR2MFFFRXR2dzF1S29CTlczMXRNazFcL1pJRmxaUGJJMkpyIiwibWFjIjoiMWFmYTQzZTA5NjVlNDk2ZGQxMDhhNjA2MWMzNzljMjcxYmQ3YTdiNDMxNDk2YzQyNjQzYzkwZDc4ODBjNWM3YiJ9; expires=Wed, 16-Apr-2025 02:59:30 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Im1aUjk3c3JkNzJxcEtTckJudEthN3c9PSIsInZhbHVlIjoiM1QxSzNKNnV1YlpiendLSHdlUVVRR0NKWk8rc2N6MzdaNThyWUFtU1NVd0d2aG5FTkJheVBaTUpCZ2hTRlVxdjVHUDFRQ" 1 => "skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQndZNDhTVm9YM2xWTmtnaG4raVBmc3VLRjlqVnBUZXlmb0FmQ2hKNkllZ2JVc1pyWk9ibzltR2k2SzJGVzVhYkkyNmJRSnUiLCJtYWMiOiI3Y2IzZTBjMTcyOGRkOTMyNjJjNTMxZjY4NWYzZTA4OGRlNjdhMGI1YmRkMDMzZjkwZmE1NGY5YmEwZGNlZDk3In0%3D; expires=Wed, 16-Apr-2025 02:59:30 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQn" 2 => "visit_counter=eyJpdiI6IkE2Y1VCbURFVzdhaGtxZHRZK1JSMUE9PSIsInZhbHVlIjoicDhzakZjSGpIOExwOFQwMVwvR2JIQVRsTDJxVWZXWlFDQktIcjh0N1VxMXdqSXQxdjRKQjQ4SzZITHZYdDAxN3EiLCJtYWMiOiI5NDk2MzIwMTU4YWYzM2VhYTNhNTQzNTM5YTdmZjY1MzA4ZWRlMDI4ZjE5OTRjMjlmMmYxOTQxMWE3ZWI5Mzg4In0%3D; expires=Fri, 16-May-2025 00:59:28 GMT; Max-Age=2591998; path=/; httponlyvisit_counter=eyJpdiI6IkE2Y1VCbURFVzdhaGtxZHRZK1JSMUE9PSIsInZhbHVlIjoicDhzakZjSGpIOExwOFQwMVwvR2JIQVRsTDJxVWZXWlFDQktIcjh0N1VxMXdqSXQxdjRKQjQ4SzZITHZYdDAxN3EiLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Im1aUjk3c3JkNzJxcEtTckJudEthN3c9PSIsInZhbHVlIjoiM1QxSzNKNnV1YlpiendLSHdlUVVRR0NKWk8rc2N6MzdaNThyWUFtU1NVd0d2aG5FTkJheVBaTUpCZ2hTRlVxdjVHUDFRQldHN3ZZU0wwK0JZT0EyY2l3dit1cmZpRmR2MFFFRXR2dzF1S29CTlczMXRNazFcL1pJRmxaUGJJMkpyIiwibWFjIjoiMWFmYTQzZTA5NjVlNDk2ZGQxMDhhNjA2MWMzNzljMjcxYmQ3YTdiNDMxNDk2YzQyNjQzYzkwZDc4ODBjNWM3YiJ9; expires=Wed, 16-Apr-2025 02:59:30 GMT; path=/XSRF-TOKEN=eyJpdiI6Im1aUjk3c3JkNzJxcEtTckJudEthN3c9PSIsInZhbHVlIjoiM1QxSzNKNnV1YlpiendLSHdlUVVRR0NKWk8rc2N6MzdaNThyWUFtU1NVd0d2aG5FTkJheVBaTUpCZ2hTRlVxdjVHUDFRQ" 1 => "skyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQndZNDhTVm9YM2xWTmtnaG4raVBmc3VLRjlqVnBUZXlmb0FmQ2hKNkllZ2JVc1pyWk9ibzltR2k2SzJGVzVhYkkyNmJRSnUiLCJtYWMiOiI3Y2IzZTBjMTcyOGRkOTMyNjJjNTMxZjY4NWYzZTA4OGRlNjdhMGI1YmRkMDMzZjkwZmE1NGY5YmEwZGNlZDk3In0%3D; expires=Wed, 16-Apr-2025 02:59:30 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6IitYR2dkK0g5dkJ3SzMyOFFBVitzYUE9PSIsInZhbHVlIjoiVWlmbW1yQjZxdDdGOU1DdzhxaGw5MDRhTTQ3cjl2eHBFSTcraXFvU0U3SVpOejF0OTZmaFBMSCtUQn" 2 => "visit_counter=eyJpdiI6IkE2Y1VCbURFVzdhaGtxZHRZK1JSMUE9PSIsInZhbHVlIjoicDhzakZjSGpIOExwOFQwMVwvR2JIQVRsTDJxVWZXWlFDQktIcjh0N1VxMXdqSXQxdjRKQjQ4SzZITHZYdDAxN3EiLCJtYWMiOiI5NDk2MzIwMTU4YWYzM2VhYTNhNTQzNTM5YTdmZjY1MzA4ZWRlMDI4ZjE5OTRjMjlmMmYxOTQxMWE3ZWI5Mzg4In0%3D; expires=Fri, 16-May-2025 00:59:28 GMT; path=/; httponlyvisit_counter=eyJpdiI6IkE2Y1VCbURFVzdhaGtxZHRZK1JSMUE9PSIsInZhbHVlIjoicDhzakZjSGpIOExwOFQwMVwvR2JIQVRsTDJxVWZXWlFDQktIcjh0N1VxMXdqSXQxdjRKQjQ4SzZITHZYdDAxN3EiLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "Jof6WPqbxFhTaRAX6IPsCavpxRfN4L4Hq8iEThxi" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/brisbane" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]