CTBUH Silver Member

SLR Consulting Australia Pty Ltd

About

Member Since: 2017

Member Offices: Sydney

Website: https://slrconsulting.com

SLR has been advising clients for over 20 years. Starting as a UK business, we now operate as a global company with more than 1100 people delivering client solutions across five regions. Global environmental and advisory solutions for Oil & Gas, Built Environment, Mining & Minerals, Infrastructure, Industry and Power sector clients. We deliver advice and support on a wide range of strategic and project-specific issues to a diverse and growing base of business, regulatory and government clients from a network of offices in Europe, North America, Asia-Pacific and Africa. SLR offers a wide range of advisory and environmental consulting services.

Fields of Expertise

Environmental Engineering; Environmental Protection

Membership details

Membership Level

Silver

Member Since

2017

Member Offices

  • Sydney

Buildings

7.3.33PHP Version255msRequest Duration9MBMemory UsageGET company/{id}Route
    • Booting (10.88ms)
    • Application (244ms)
    • 1 x Application (95.69%)
      244.36ms
      1 x Booting (4.26%)
      10.88ms
      19 templates were rendered
      • companies.display-redesign (resources/views/companies/display-redesign.blade.php)32blade
        Params
        0
        tabs
        1
        company
        2
        associatedCompanies
        3
        member
        4
        designatedExperts
        5
        memberLevel
        6
        buildings
        7
        buildingsRaw
        8
        buildings_com_uc
        9
        awards
        10
        statuses
        11
        title
        12
        tallest100
        13
        videos
        14
        research
        15
        news
        16
        forPdf
        17
        timelineYears
        18
        minHeight
        19
        maxHeight
        20
        timelineMinYear
        21
        videoCategories
        22
        initiatives
        23
        people
        24
        tallBuildingCounts
        25
        buildingsByFunction
        26
        buildingsByMaterial
        27
        averageAge
        28
        vanityHeights
        29
        constructionData
        30
        allBuildingStatuses
        31
        accessLevel
      • companies.partials.display-overview (resources/views/companies/partials/display-overview.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • companies.partials.element.displayBuildingImages (resources/views/companies/partials/element/displayBuildingImages.blade.php)44blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)51blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        __currentLoopData
        45
        loop
        46
        filteredBuildings
        47
        header
        48
        tableId
        49
        maxItems
        50
        displayFull
      • companies.partials.element.displayAssociatedCompanies (resources/views/companies/partials/element/displayAssociatedCompanies.blade.php)47blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        __currentLoopData
        45
        loop
        46
        filteredBuildings
      • www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
        Params
        0
        id
        1
        active
        2
        slot
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)45blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        tableId
        39
        displayComplexTable
        40
        search
        41
        columnFilter
        42
        paginate
        43
        maxItems
        44
        displayFull
      • www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
        Params
        0
        id
        1
        active
        2
        slot
      • layouts.SSC-tabs (resources/views/layouts/SSC-tabs.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • www.partials.tab-menu (resources/views/www/partials/tab-menu.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • layouts.SSC (resources/views/layouts/SSC.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • common.header (resources/views/common/header.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)40php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)44php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
        40
        __currentLoopData
        41
        item
        42
        loop
        43
        child
      • common.footer (resources/views/common/footer.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        alreadyConsentedWithCookies
        40
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        alreadyConsentedWithCookies
        40
        cookieConsentConfig
      uri
      GET company/{id}
      middleware
      web
      controller
      App\Http\Controllers\CtbuhCompanyController@display
      namespace
      App\Http\Controllers
      prefix
      where
      file
      app/Http/Controllers/CtbuhCompanyController.php:27-708
      40 statements were executed, 11 of which were duplicated, 29 unique200ms
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = '14357' limit 18.19ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb
        Metadata
        Bindings
        • 0. 14357
        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
        • 17. /app/Http/Controllers/CtbuhCompanyController.php:33
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • SELECT c1.status, c2.id AS new_id, c2.name AS new_name, c2.status AS new_status, c1.new_company_year FROM ctbuh_company c1 LEFT JOIN ctbuh_company c2 ON c1.new_company = c2.id WHERE c1.id = '14357' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name1.3ms/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/CtbuhCompany.php:138
        • 11. /app/CtbuhCompany.php:223
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:47
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '14357' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name64.07ms/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/CtbuhCompany.php:172
        • 11. /app/CtbuhCompany.php:207
        • 12. /app/CtbuhCompany.php:254
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '14357' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name64.28ms/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/CtbuhCompany.php:172
        • 11. /app/CtbuhCompany.php:207
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:48
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `id` from `ctbuh_company` where `name` = 'SLR Consulting Australia Pty Ltd' and `active` = '1'1.44ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. SLR Consulting Australia Pty Ltd
        • 1. 1
        Backtrace
        • 12. /app/CtbuhCompany.php:305
        • 13. /app/CtbuhCompany.php:318
        • 14. /app/Http/Controllers/CtbuhCompanyController.php:52
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `building_id` from `ctbuh_building_company_new` where `company_id` in (14357, 14357)1.25ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 14357
        • 1. 14357
        Backtrace
        • 12. /app/CtbuhCompany.php:328
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:52
        • 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 `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (13371) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc1.88ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 13371
        Hints
        • Use SELECT * only if you need all columns from table
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 14. /app/CtbuhCompany.php:336
        • 15. /app/Http/Controllers/CtbuhCompanyController.php:52
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_cities` where `v2_cities`.`id` in (2817)1.31ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/CtbuhCompanyController.php:57
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_countries` where `v2_countries`.`id` in (11)1.46ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:57
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_countries` where `v2_countries`.`id` in (11)1.84ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/CtbuhCompanyController.php:57
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v3_images`.*, `v3_building_image`.`building_id` as `pivot_building_id`, `v3_building_image`.`image_id` as `pivot_image_id`, `v3_building_image`.`position` as `pivot_position` from `v3_images` inner join `v3_building_image` on `v3_images`.`id` = `v3_building_image`.`image_id` where `v3_building_image`.`building_id` in (13371) order by `position` asc1.53ms/app/Http/Controllers/CtbuhCompanyController.php:57buldingdb
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/CtbuhCompanyController.php:57
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_resource_categories` where `type` = 'Video'1.91ms/app/Http/Controllers/CtbuhCompanyController.php:59buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:59
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v2_members`.*, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id`, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id` from `v2_members` inner join `v2_ctbuh_company_member` on `v2_members`.`id` = `v2_ctbuh_company_member`.`member_id` where `v2_ctbuh_company_member`.`ctbuh_company_id` = 14357 and `v2_members`.`deleted_at` is null3.94ms/app/CtbuhCompany.php:91buldingdb
        Metadata
        Bindings
        • 0. 14357
        Backtrace
        • 19. /app/CtbuhCompany.php:91
        • 20. /app/Http/Controllers/CtbuhCompanyController.php:172
        • 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 `name`, `name_chinese` from `v2_membership_levels` where `id` = 152.99ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdb
        Metadata
        Bindings
        • 0. 15
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:181
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_awards` where (`building_id` in (13371) or `company_id` = 14357) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc2.21ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdb
        Metadata
        Bindings
        • 0. 13371
        • 1. 14357
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/CtbuhCompanyController.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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12001.32ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1200
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:250
        • 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12001.17ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1200
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:251
        • 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12001.29ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1200
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:260
        • 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 DISTINCT id_building AS building_id FROM ctbuh_building_company WHERE id_building IN( 13371 ) AND id_company_type IN(13, 11) AND id_company IN( 14357, 14353 ) UNION DISTINCT SELECT DISTINCT building_id FROM ctbuh_building_company_new WHERE building_id IN( 13371 ) AND category_id IN(1, 2) AND company_id IN( 14357, 14353 )2.01ms/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/CtbuhCompanyController.php:286
        • 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 `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('14357', '14353')1.46ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdb
        Metadata
        Bindings
        • 0. 14357
        • 1. 14353
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:306
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('14357', '14353')1.27ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdb
        Metadata
        Bindings
        • 0. 14357
        • 1. 14353
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:311
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_people` where `v2_people`.`member_id` = 1200 and `v2_people`.`member_id` is not null2.38ms/app/Http/Controllers/CtbuhCompanyController.php:423buldingdb
        Metadata
        Bindings
        • 0. 1200
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/CtbuhCompanyController.php:423
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 23. /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 (7737) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc1.41ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdb
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/CtbuhCompanyController.php:426
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `id` from `ctbuh_company` where `name` = 'SLR Consulting Australia Pty Ltd' and `active` = '1'1.3ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. SLR Consulting Australia Pty Ltd
        • 1. 1
        Backtrace
        • 12. /app/CtbuhCompany.php:305
        • 13. /app/CtbuhCompany.php:318
        • 14. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select `building_id` from `ctbuh_building_company_new` where `company_id` in (14357, 14357, 14357)1.24ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 14357
        • 1. 14357
        • 2. 14357
        Backtrace
        • 12. /app/CtbuhCompany.php:328
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 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 `ctbuh_building` where `active` = '1' and (`linked_building_status` != 'Renovated' or `linked_building_status` is null) and `id` in (13371) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc1.7ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 13371
        Hints
        • Use SELECT * only if you need all columns from table
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 14. /app/CtbuhCompany.php:336
        • 15. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 13371 and `published_at` < '2025-07-31 03:49:04' and `deleted_at` is null and `featured` = 1 order by `published_at` desc1.61ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 13371
        • 1. 2025-07-31 03:49:04
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT ctbuh_building.id, name_intl, status, (height_architecture - height_floor) AS vanity_height, ((height_architecture - height_floor) / height_architecture) AS vanity_height_pct, floors_above, completed, height_architecture, height_floor FROM ctbuh_building WHERE height_floor != 0 AND completed > 0 AND active = 1 AND structure_type IN('building') AND ctbuh_building.id in (13371) AND height_architecture > 0 HAVING vanity_height != 0 ORDER BY vanity_height_pct DESC1.37ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/Http/Controllers/CtbuhCompanyController.php:551
        • 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_people` where `v2_people`.`member_id` = 1200 and `v2_people`.`member_id` is not null and `is_designated_expert` = 11.83ms/app/Member.php:28buldingdb
        Metadata
        Bindings
        • 0. 1200
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 15. /app/Member.php:28
        • 16. /app/Http/Controllers/CtbuhCompanyController.php:659
        • 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
      • 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` = 1200 order by `headquarters` desc, `contact` desc, `name` asc1.71msview::companies.partials.display-overview:17buldingdb
        Metadata
        Bindings
        • 0. 1200
        Backtrace
        • 19. view::companies.partials.display-overview:17
        • 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_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` = 1200 order by `display_order` asc, `field` asc1.41msview::companies.partials.display-overview:53buldingdb
        Metadata
        Bindings
        • 0. 1200
        Backtrace
        • 19. view::companies.partials.display-overview:53
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • select * from `nav_menu_items` where `parent_id` is null1.42ms/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.5ms/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 14.21ms/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.51ms/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.47ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 2
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 4 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.49ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 4
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 3 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.34ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 3
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 29 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.73ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 29
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 1 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.5ms/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
      2
      App\Person
      1
      App\Member
      1
      App\Image
      13
      App\Country
      2
      App\City
      2
      App\Building
      2
      App\CtbuhCompany
      1
          _token
          aMdWwwJSLGUpVXnwh4Cu8JSKMexwbRe9F8kSuXaV
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/14357" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /company/14357
          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=eyJpdiI6IkZITG80aUtCSjRJRVFLXC9KaEtzbG5RPT0iLCJ2YWx1ZSI6Im5FXC9hZnFScTR0eFdFYTc5Q1hjUkd6TktLbFpHQ3UxZHBsMlJibEFDTGhIMXJjTnl6SzZsZHVyVWRCK2RsenhHN0RPd0dhWjJNbE5DOUF2czdmMUJXT0oxbGJuWmxpaEFYVzlDS1l3SmFjY0VxOTM3c2hPMFRXMGc4aVJ6RTFmKyIsIm1hYyI6IjYyYWMzNDMxNjBjNGY5ODA4NTc4ZmNhY2U5NWMzYjhlZjg0ZDNmMWNkMTAwNTE1ZjYxYmQ3ODEyZjk2MGZlZmQifQ%3D%3D; skyscraper_center_session=eyJpdiI6IlhrT2o3WHU5cUpyXC81enZOYzBLRjFBPT0iLCJ2YWx1ZSI6Ik9KbGZvVlJ5SW95Tm1CdERlbk1MN1E0aEc5MENaUVVMNUJaekZZVVFpckRjbnFqNTY2dmVEenpaV1F5NzdQM1ZaOXpIbFZuQ3hnRElCZUp3Z25McEhiXC9YOGY4VVRGNThKVVdoMDlybFFVd2lVYzFZMW1tZWZIeEp6TGFZcTZpQSIsIm1hYyI6ImEyYWU1ZmVkYjI0NTE5ZDI0MTcyZGQxN2MxYWNiZmFlOGQ2YTk3M2QyZTI1YmYyYmQ4MjI1ZmRlNWM4ZGM1Y2IifQ%3D%3D; visit_counter=eyJpdiI6IklTSjBsVEZRXC8xZ25seWtmRXhuQ2hnPT0iLCJ2YWx1ZSI6InFuN1p2c3VDVG4yODlySitWVW9MVmJBT3p2MzhDZ0Z6WkJSanNjUjgxVzlvYTk4WXFTQ3NIMm1PNGJPK3orQk8iLCJtYWMiOiJjMmQ0ODljMDQwNGRkZWUzMTk1ODkyNDQwNjExOGMwNjBlZmRkYjM4MGRmNTYzYmQ4NzFmMmU5MGJlMWY2ZWJiIn0%3DXSRF-TOKEN=eyJpdiI6IkZITG80aUtCSjRJRVFLXC9KaEtzbG5RPT0iLCJ2YWx1ZSI6Im5FXC9hZnFScTR0eFdFYTc5Q1hjUkd6TktLbFpHQ3UxZHBsMlJibEFDTGhIMXJjTnl6SzZsZHVyVWRCK2RsenhHN0RPd" ] "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "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=eyJpdiI6IkZITG80aUtCSjRJRVFLXC9KaEtzbG5RPT0iLCJ2YWx1ZSI6Im5FXC9hZnFScTR0eFdFYTc5Q1hjUkd6TktLbFpHQ3UxZHBsMlJibEFDTGhIMXJjTnl6SzZsZHVyVWRCK2RsenhHN0RPd0dhWjJNbE5DOUF2czdmMUJXT0oxbGJuWmxpaEFYVzlDS1l3SmFjY0VxOTM3c2hPMFRXMGc4aVJ6RTFmKyIsIm1hYyI6IjYyYWMzNDMxNjBjNGY5ODA4NTc4ZmNhY2U5NWMzYjhlZjg0ZDNmMWNkMTAwNTE1ZjYxYmQ3ODEyZjk2MGZlZmQifQ%3D%3D; skyscraper_center_session=eyJpdiI6IlhrT2o3WHU5cUpyXC81enZOYzBLRjFBPT0iLCJ2YWx1ZSI6Ik9KbGZvVlJ5SW95Tm1CdERlbk1MN1E0aEc5MENaUVVMNUJaekZZVVFpckRjbnFqNTY2dmVEenpaV1F5NzdQM1ZaOXpIbFZuQ3hnRElCZUp3Z25McEhiXC9YOGY4VVRGNThKVVdoMDlybFFVd2lVYzFZMW1tZWZIeEp6TGFZcTZpQSIsIm1hYyI6ImEyYWU1ZmVkYjI0NTE5ZDI0MTcyZGQxN2MxYWNiZmFlOGQ2YTk3M2QyZTI1YmYyYmQ4MjI1ZmRlNWM4ZGM1Y2IifQ%3D%3D; visit_counter=eyJpdiI6IklTSjBsVEZRXC8xZ25seWtmRXhuQ2hnPT0iLCJ2YWx1ZSI6InFuN1p2c3VDVG4yODlySitWVW9MVmJBT3p2MzhDZ0Z6WkJSanNjUjgxVzlvYTk4WXFTQ3NIMm1PNGJPK3orQk8iLCJtYWMiOiJjMmQ0ODljMDQwNGRkZWUzMTk1ODkyNDQwNjExOGMwNjBlZmRkYjM4MGRmNTYzYmQ4NzFmMmU5MGJlMWY2ZWJiIn0%3DXSRF-TOKEN=eyJpdiI6IkZITG80aUtCSjRJRVFLXC9KaEtzbG5RPT0iLCJ2YWx1ZSI6Im5FXC9hZnFScTR0eFdFYTc5Q1hjUkd6TktLbFpHQ3UxZHBsMlJibEFDTGhIMXJjTnl6SzZsZHVyVWRCK2RsenhHN0RPd" "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "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" => "14717" "REMOTE_ADDR" => "216.73.216.168" "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" => "/company/14357" "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" => 1753933744.6346 "REQUEST_TIME" => 1753933744 ]
          request_cookies
          0 of 0
          array:3 [ "XSRF-TOKEN" => "aMdWwwJSLGUpVXnwh4Cu8JSKMexwbRe9F8kSuXaV" "skyscraper_center_session" => "S2lDv3kBGRi7hIAJjGBO0PRw49KVyNiWitRvqflR" "visit_counter" => "4" ]
          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 => "Thu, 31 Jul 2025 03:49:04 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IldGQ0Z0NmhpcDlydlhrWEhlRGlvWGc9PSIsInZhbHVlIjoid0dHOW9MWHlxSHRsS3NjbHNJNkl5b2RMYmNEY0VNWVNWandcL3R2Rk13VUVvSmE2M1dRTzFXMXcyNnlDR3V5S3pZQlk1SlE1VDJDNWlDU1J5dWpjek1CalQ5SjNid0lKWWo5Q29PUVZGTjkxY3VnYjhuMk1icGpKVXRxT3M2dlRsIiwibWFjIjoiYzk4YmRhM2VkYmY1YjcxNTg0OTE0ZjFjOTA0NTkyNTUyNDk3MGU0NzQyY2E1NDg1MWQwYmZlZDUwYWZkMTU3OSJ9; expires=Thu, 31-Jul-2025 05:49:04 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6IldGQ0Z0NmhpcDlydlhrWEhlRGlvWGc9PSIsInZhbHVlIjoid0dHOW9MWHlxSHRsS3NjbHNJNkl5b2RMYmNEY0VNWVNWandcL3R2Rk13VUVvSmE2M1dRTzFXMXcyNnlDR3V5S3pZQlk1S" 1 => "skyscraper_center_session=eyJpdiI6InM2YVRreDZkYTdwb0lUb3pQVXlLa1E9PSIsInZhbHVlIjoiUjZiSjlQNlFcL3gwUVwvN2poNjFVQXhcL2grN29TSkJ3eUVuXC9XakRoVWRTalFMdWRMQXE4SUh3UnJaVkN1cVUzQTUydFBXcGFMQ3JmNUNMcVFoSG83TWI3c01nTHdtZzZlUHpnRzZsK0xXOFpMUjdrSzRkTitESk5oek50d214aVRIIiwibWFjIjoiMDZiMmM2NGU2YTMwNjZhZGFlOTAwNWFmYTRiMzYzNGNkYzE2NDMwMTRjZmJmZWYyZTMwMDhkMTIzZjllOWVkZCJ9; expires=Thu, 31-Jul-2025 05:49:04 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6InM2YVRreDZkYTdwb0lUb3pQVXlLa1E9PSIsInZhbHVlIjoiUjZiSjlQNlFcL3gwUVwvN2poNjFVQXhcL2grN29TSkJ3eUVuXC9XakRoVWRTalFMdWRMQXE4SUh3Un" 2 => "visit_counter=eyJpdiI6ImNCWkh0dmpSZXNtZitnV0ErelVIY2c9PSIsInZhbHVlIjoiYXZwM210OFJqQTJcL3ZJdFwvbW9FbW5CNDgwQTl1Wm1jR0M1OVwvbTUyNVIrUlU2eG5RNGlBODZBS0QyTHpOSUNYUSIsIm1hYyI6IjJiNDIxMmU0NjI2NzA2OTU1MzY1MTI5YzIyMjdlOWIwODlmYjVlYTU4MDFhODY3YTk2MzJlNGFlNzg4Nzc3MDcifQ%3D%3D; expires=Sat, 30-Aug-2025 03:49:04 GMT; Max-Age=2592000; path=/; httponlyvisit_counter=eyJpdiI6ImNCWkh0dmpSZXNtZitnV0ErelVIY2c9PSIsInZhbHVlIjoiYXZwM210OFJqQTJcL3ZJdFwvbW9FbW5CNDgwQTl1Wm1jR0M1OVwvbTUyNVIrUlU2eG5RNGlBODZBS0QyTHpOSUNYUS" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6IldGQ0Z0NmhpcDlydlhrWEhlRGlvWGc9PSIsInZhbHVlIjoid0dHOW9MWHlxSHRsS3NjbHNJNkl5b2RMYmNEY0VNWVNWandcL3R2Rk13VUVvSmE2M1dRTzFXMXcyNnlDR3V5S3pZQlk1SlE1VDJDNWlDU1J5dWpjek1CalQ5SjNid0lKWWo5Q29PUVZGTjkxY3VnYjhuMk1icGpKVXRxT3M2dlRsIiwibWFjIjoiYzk4YmRhM2VkYmY1YjcxNTg0OTE0ZjFjOTA0NTkyNTUyNDk3MGU0NzQyY2E1NDg1MWQwYmZlZDUwYWZkMTU3OSJ9; expires=Thu, 31-Jul-2025 05:49:04 GMT; path=/XSRF-TOKEN=eyJpdiI6IldGQ0Z0NmhpcDlydlhrWEhlRGlvWGc9PSIsInZhbHVlIjoid0dHOW9MWHlxSHRsS3NjbHNJNkl5b2RMYmNEY0VNWVNWandcL3R2Rk13VUVvSmE2M1dRTzFXMXcyNnlDR3V5S3pZQlk1S" 1 => "skyscraper_center_session=eyJpdiI6InM2YVRreDZkYTdwb0lUb3pQVXlLa1E9PSIsInZhbHVlIjoiUjZiSjlQNlFcL3gwUVwvN2poNjFVQXhcL2grN29TSkJ3eUVuXC9XakRoVWRTalFMdWRMQXE4SUh3UnJaVkN1cVUzQTUydFBXcGFMQ3JmNUNMcVFoSG83TWI3c01nTHdtZzZlUHpnRzZsK0xXOFpMUjdrSzRkTitESk5oek50d214aVRIIiwibWFjIjoiMDZiMmM2NGU2YTMwNjZhZGFlOTAwNWFmYTRiMzYzNGNkYzE2NDMwMTRjZmJmZWYyZTMwMDhkMTIzZjllOWVkZCJ9; expires=Thu, 31-Jul-2025 05:49:04 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6InM2YVRreDZkYTdwb0lUb3pQVXlLa1E9PSIsInZhbHVlIjoiUjZiSjlQNlFcL3gwUVwvN2poNjFVQXhcL2grN29TSkJ3eUVuXC9XakRoVWRTalFMdWRMQXE4SUh3Un" 2 => "visit_counter=eyJpdiI6ImNCWkh0dmpSZXNtZitnV0ErelVIY2c9PSIsInZhbHVlIjoiYXZwM210OFJqQTJcL3ZJdFwvbW9FbW5CNDgwQTl1Wm1jR0M1OVwvbTUyNVIrUlU2eG5RNGlBODZBS0QyTHpOSUNYUSIsIm1hYyI6IjJiNDIxMmU0NjI2NzA2OTU1MzY1MTI5YzIyMjdlOWIwODlmYjVlYTU4MDFhODY3YTk2MzJlNGFlNzg4Nzc3MDcifQ%3D%3D; expires=Sat, 30-Aug-2025 03:49:04 GMT; path=/; httponlyvisit_counter=eyJpdiI6ImNCWkh0dmpSZXNtZitnV0ErelVIY2c9PSIsInZhbHVlIjoiYXZwM210OFJqQTJcL3ZJdFwvbW9FbW5CNDgwQTl1Wm1jR0M1OVwvbTUyNVIrUlU2eG5RNGlBODZBS0QyTHpOSUNYUS" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "aMdWwwJSLGUpVXnwh4Cu8JSKMexwbRe9F8kSuXaV" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/14357" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]