CSCEC Group of Companies

Subsidiary companies:
 
China Construction Eighth Engineering Division | China Construction First Group Construction & Development Co., Ltd. | China Construction Second Engineering Bureau Ltd. | China Construction Sixth Engineering Division Corp, Ltd | China Construction Steel Structure Corporation | China State Construction Engineering Corporation | China State Construction Overseas Development Co., Ltd. | China State Construction Seventh Engineering Division Corporation Ltd. | Intelligent Technology Co., Ltd. of Chinese Construction Third Engineering Bureau | Beijing Architectural Design institute of China Construction Limited Company | China Construction Fourth Engineering Division Corp. Ltd. | China Construction Jingcheng Project Consultants | China State Construction Technical Center | China Overseas America, Inc.

Buildings

We use cookies to improve your experience on our website. Review our Privacy Policy for more information.
MessagesTimelineExceptionsViews12RouteQueries49Models3220MailsGateSessionRequest
7.3.33PHP Version2.17sRequest Duration28MBMemory UsageGET company/{id}Route
    • Booting (7.31ms)
    • Application (2.17s)
    • 1 x Application (99.66%)
      2.17s
      1 x Booting (0.34%)
      7.31ms
      12 templates were rendered
      • companies.partials.display-non-member (resources/views/companies/partials/display-non-member.blade.php)8blade
        Params
        0
        company
        1
        parentMember
        2
        associatedCompanies
        3
        buildings
        4
        statuses
        5
        title
        6
        allBuildingStatuses
        7
        accessLevel
      • companies.partials.element.nonMemberItems (resources/views/companies/partials/element/nonMemberItems.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)23blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        tableId
        18
        paginate
        19
        search
        20
        displayComplexTable
        21
        maxItems
        22
        displayFull
      • layouts.SSC-standard (resources/views/layouts/SSC-standard.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
      • layouts.SSC (resources/views/layouts/SSC.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
      • common.header (resources/views/common/header.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
        18
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)19php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
        18
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)21php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
        18
        nav
        19
        item
        20
        child
      • common.footer (resources/views/common/footer.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
        18
        alreadyConsentedWithCookies
        19
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)20blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        company
        6
        parentMember
        7
        associatedCompanies
        8
        buildings
        9
        statuses
        10
        title
        11
        allBuildingStatuses
        12
        accessLevel
        13
        __currentLoopData
        14
        companies
        15
        key
        16
        loop
        17
        data
        18
        alreadyConsentedWithCookies
        19
        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
      49 statements were executed, 2 of which were duplicated, 47 unique1.89s
      buldingdb
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = '17257' limit 18.71ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb
        Metadata
        Bindings
        • 0. 17257
        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 = '17257' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name1.24ms/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 = '17257' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name127ms/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 * from `ctbuh_company` where `ctbuh_company`.`id` = 5817 and `ctbuh_company`.`deleted_at` is null limit 18.91ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 5817
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '5817' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name99.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/CtbuhCompany.php:172
        • 11. /app/CtbuhCompany.php:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 3897 and `ctbuh_company`.`deleted_at` is null limit 17.87ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 3897
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '3897' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name179ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 4558 and `ctbuh_company`.`deleted_at` is null limit 11.58ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 4558
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '4558' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name140ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 10632 and `ctbuh_company`.`deleted_at` is null limit 18.53ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 10632
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '10632' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name137ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 10359 and `ctbuh_company`.`deleted_at` is null limit 11.48ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 10359
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '10359' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name128ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 5897 and `ctbuh_company`.`deleted_at` is null limit 11.57ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 5897
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '5897' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name83.9ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 22939 and `ctbuh_company`.`deleted_at` is null limit 11.79ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 22939
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:177
        • 20. /app/CtbuhCompany.php:207
        • 21. /app/CtbuhCompany.php:254
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '22939' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name70.51ms/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:177
        • 12. /app/CtbuhCompany.php:177
        • 13. /app/CtbuhCompany.php:207
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 4561 and `ctbuh_company`.`deleted_at` is null limit 11.43ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 4561
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:177
        • 20. /app/CtbuhCompany.php:207
        • 21. /app/CtbuhCompany.php:254
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '4561' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name106ms/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:177
        • 12. /app/CtbuhCompany.php:177
        • 13. /app/CtbuhCompany.php:207
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 21653 and `ctbuh_company`.`deleted_at` is null limit 11.45ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 21653
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:177
        • 20. /app/CtbuhCompany.php:207
        • 21. /app/CtbuhCompany.php:254
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '21653' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name129ms/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:177
        • 12. /app/CtbuhCompany.php:177
        • 13. /app/CtbuhCompany.php:207
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 15727 and `ctbuh_company`.`deleted_at` is null limit 17.81ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 15727
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:177
        • 20. /app/CtbuhCompany.php:207
        • 21. /app/CtbuhCompany.php:254
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '15727' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name159ms/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:177
        • 12. /app/CtbuhCompany.php:177
        • 13. /app/CtbuhCompany.php:207
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 9937 and `ctbuh_company`.`deleted_at` is null limit 11.35ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 9937
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '9937' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name97.81ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 17844 and `ctbuh_company`.`deleted_at` is null limit 11.26ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 17844
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:177
        • 20. /app/CtbuhCompany.php:207
        • 21. /app/CtbuhCompany.php:254
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '17844' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name97.62ms/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:177
        • 12. /app/CtbuhCompany.php:177
        • 13. /app/CtbuhCompany.php:207
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 19244 and `ctbuh_company`.`deleted_at` is null limit 11.29ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 19244
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '19244' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name87.18ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 17285 and `ctbuh_company`.`deleted_at` is null limit 11.37ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 17285
        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. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
        • 18. /app/CtbuhCompany.php:176
        • 19. /app/CtbuhCompany.php:207
        • 20. /app/CtbuhCompany.php:254
        • 21. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '17285' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name87.52ms/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:177
        • 12. /app/CtbuhCompany.php:207
        • 13. /app/CtbuhCompany.php:254
      • select `id` from `ctbuh_company` where `name` = 'CSCEC Group of Companies' and `active` = '1'2.5ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. CSCEC Group of Companies
        • 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 (5817, 3897, 4558, 10632, 10359, 5897, 9937, 19244, 17285, 22939, 4561, 21653, 15727, 17844, 17257)14.48ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 5817
        • 1. 3897
        • 2. 4558
        • 3. 10632
        • 4. 10359
        • 5. 5897
        • 6. 9937
        • 7. 19244
        • 8. 17285
        • 9. 22939
        • 10. 4561
        • 11. 21653
        • 12. 15727
        • 13. 17844
        • 14. 17257
        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 (8701, 367, 360, 10274, 54, 34348, 37062, 29371, 12183, 4141, 4139, 4140, 8911, 29355, 249, 644, 1190, 31925, 13860, 13861, 31288, 31289, 15022, 34441, 34442, 34443, 34444, 28165, 28164, 14295, 14296, 13144, 13145, 28247, 27519, 34489, 38022, 38032, 38033, 38438, 1427, 16911, 18299, 18300, 23669, 23670, 23671, 376, 23673, 23674, 23675, 23676, 23677, 23678, 23679, 23680, 23668, 8815, 173, 1137, 23614, 15741, 31566, 34847, 34848, 35363, 35646, 35647, 35648, 35921, 35962, 35963, 16565, 16566, 16670, 492, 9593, 9592, 12875, 15327, 583, 310, 9591, 249, 29702, 23585, 18451, 29046, 29047, 18450, 18449, 29704, 32146, 32145, 29697, 32149, 32144, 32147, 32148, 16709, 16710, 30091, 28232, 15636, 13610, 35347, 35348, 35349, 30120, 35429, 35431, 35432, 35433, 35436, 35421, 35422, 35423, 35424, 35425, 35426, 35427, 31927, 35419, 36505, 13611, 13612, 13613, 16846, 16845, 13614, 13615, 36588, 36589, 36590, 36591, 36592, 32086, 11130, 1083, 17727, 18215, 18215, 18215, 18218, 18218, 18218, 18225, 18225, 18225, 11155, 18938, 258, 14100, 2045, 16449, 15843, 15844, 15845, 15840, 15842, 15841, 23040, 23041, 23042, 23043, 23044, 23045, 23046, 23047, 14600, 23048, 13516, 15426, 16843, 16844, 15427, 14474, 5287, 23623, 23624, 23626, 23627, 23628, 23686, 23687, 23688, 23689, 8812, 21947, 9063, 9064, 15093, 14401, 1858, 24077, 24078, 24162, 24163, 24508, 24509, 13893, 15170, 491, 23404, 25503, 25504, 23406, 25771, 25772, 25773, 25774, 25775, 25776, 25777, 25983, 25983, 131, 10327, 17450, 10326, 13008, 8821, 17596, 17597, 26779, 22542, 14357, 23233, 22319, 13007, 379, 18560, 9054, 13146, 14402, 13006, 1068, 28536, 29603, 29608, 29609, 29610, 29958, 27433, 5224, 22857, 22858, 16674, 16676, 30707, 22715, 22716, 22717, 22718, 22719, 22720, 22721, 22722, 22723, 22724, 22725, 22726, 17540, 27415, 27416, 22205, 1612, 15030, 15031, 13950, 5303, 5297, 8823, 137, 174, 1258, 15462, 196, 2861, 16001, 16002, 17028, 16675, 16580, 16336, 176, 13896, 28601, 23715, 23716, 23717, 23718, 791, 17595, 14795, 20116, 20117, 24501, 24502, 14589, 118, 34027, 34166, 34152, 34157, 34158, 34153, 34159, 34154, 34155, 34160, 34156, 34161, 34162, 34163, 34164, 34167, 34168, 34169, 34170, 34171, 34172, 34173, 34174, 34175, 17080, 34420, 14448, 1002, 34771, 34772, 34773, 34774, 34775, 34776, 34777, 34778, 18101, 15218, 15219, 5207, 15899, 35491, 35492, 35852, 35851, 21984, 34464, 24971, 36684, 33779, 33780, 33090, 22729, 22728, 22727, 13516, 30574, 30576, 9692, 356, 12778, 8701, 14198, 3021, 14589, 196, 13144, 13145, 18552, 9124, 10293, 2778, 258, 1144, 595, 869, 2118, 4068, 14795, 852, 2105, 2104, 1505, 1527, 414, 9063, 9064, 9065, 174, 8823, 173, 176, 148, 1068, 137, 11116, 73, 9671, 131, 54, 33983, 23614, 15741, 35363, 37062, 19155, 14163, 29917, 1867, 36720, 18562, 18561, 18564, 18563, 11116, 35852, 35851) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc24.02ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 8701
        • 3. 367
        • 4. 360
        • 5. 10274
        • 6. 54
        • 7. 34348
        • 8. 37062
        • 9. 29371
        • 10. 12183
        • 11. 4141
        • 12. 4139
        • 13. 4140
        • 14. 8911
        • 15. 29355
        • 16. 249
        • 17. 644
        • 18. 1190
        • 19. 31925
        • 20. 13860
        • 21. 13861
        • 22. 31288
        • 23. 31289
        • 24. 15022
        • 25. 34441
        • 26. 34442
        • 27. 34443
        • 28. 34444
        • 29. 28165
        • 30. 28164
        • 31. 14295
        • 32. 14296
        • 33. 13144
        • 34. 13145
        • 35. 28247
        • 36. 27519
        • 37. 34489
        • 38. 38022
        • 39. 38032
        • 40. 38033
        • 41. 38438
        • 42. 1427
        • 43. 16911
        • 44. 18299
        • 45. 18300
        • 46. 23669
        • 47. 23670
        • 48. 23671
        • 49. 376
        • 50. 23673
        • 51. 23674
        • 52. 23675
        • 53. 23676
        • 54. 23677
        • 55. 23678
        • 56. 23679
        • 57. 23680
        • 58. 23668
        • 59. 8815
        • 60. 173
        • 61. 1137
        • 62. 23614
        • 63. 15741
        • 64. 31566
        • 65. 34847
        • 66. 34848
        • 67. 35363
        • 68. 35646
        • 69. 35647
        • 70. 35648
        • 71. 35921
        • 72. 35962
        • 73. 35963
        • 74. 16565
        • 75. 16566
        • 76. 16670
        • 77. 492
        • 78. 9593
        • 79. 9592
        • 80. 12875
        • 81. 15327
        • 82. 583
        • 83. 310
        • 84. 9591
        • 85. 249
        • 86. 29702
        • 87. 23585
        • 88. 18451
        • 89. 29046
        • 90. 29047
        • 91. 18450
        • 92. 18449
        • 93. 29704
        • 94. 32146
        • 95. 32145
        • 96. 29697
        • 97. 32149
        • 98. 32144
        • 99. 32147
        • 100. 32148
        • 101. 16709
        • 102. 16710
        • 103. 30091
        • 104. 28232
        • 105. 15636
        • 106. 13610
        • 107. 35347
        • 108. 35348
        • 109. 35349
        • 110. 30120
        • 111. 35429
        • 112. 35431
        • 113. 35432
        • 114. 35433
        • 115. 35436
        • 116. 35421
        • 117. 35422
        • 118. 35423
        • 119. 35424
        • 120. 35425
        • 121. 35426
        • 122. 35427
        • 123. 31927
        • 124. 35419
        • 125. 36505
        • 126. 13611
        • 127. 13612
        • 128. 13613
        • 129. 16846
        • 130. 16845
        • 131. 13614
        • 132. 13615
        • 133. 36588
        • 134. 36589
        • 135. 36590
        • 136. 36591
        • 137. 36592
        • 138. 32086
        • 139. 11130
        • 140. 1083
        • 141. 17727
        • 142. 18215
        • 143. 18215
        • 144. 18215
        • 145. 18218
        • 146. 18218
        • 147. 18218
        • 148. 18225
        • 149. 18225
        • 150. 18225
        • 151. 11155
        • 152. 18938
        • 153. 258
        • 154. 14100
        • 155. 2045
        • 156. 16449
        • 157. 15843
        • 158. 15844
        • 159. 15845
        • 160. 15840
        • 161. 15842
        • 162. 15841
        • 163. 23040
        • 164. 23041
        • 165. 23042
        • 166. 23043
        • 167. 23044
        • 168. 23045
        • 169. 23046
        • 170. 23047
        • 171. 14600
        • 172. 23048
        • 173. 13516
        • 174. 15426
        • 175. 16843
        • 176. 16844
        • 177. 15427
        • 178. 14474
        • 179. 5287
        • 180. 23623
        • 181. 23624
        • 182. 23626
        • 183. 23627
        • 184. 23628
        • 185. 23686
        • 186. 23687
        • 187. 23688
        • 188. 23689
        • 189. 8812
        • 190. 21947
        • 191. 9063
        • 192. 9064
        • 193. 15093
        • 194. 14401
        • 195. 1858
        • 196. 24077
        • 197. 24078
        • 198. 24162
        • 199. 24163
        • 200. 24508
        • 201. 24509
        • 202. 13893
        • 203. 15170
        • 204. 491
        • 205. 23404
        • 206. 25503
        • 207. 25504
        • 208. 23406
        • 209. 25771
        • 210. 25772
        • 211. 25773
        • 212. 25774
        • 213. 25775
        • 214. 25776
        • 215. 25777
        • 216. 25983
        • 217. 25983
        • 218. 131
        • 219. 10327
        • 220. 17450
        • 221. 10326
        • 222. 13008
        • 223. 8821
        • 224. 17596
        • 225. 17597
        • 226. 26779
        • 227. 22542
        • 228. 14357
        • 229. 23233
        • 230. 22319
        • 231. 13007
        • 232. 379
        • 233. 18560
        • 234. 9054
        • 235. 13146
        • 236. 14402
        • 237. 13006
        • 238. 1068
        • 239. 28536
        • 240. 29603
        • 241. 29608
        • 242. 29609
        • 243. 29610
        • 244. 29958
        • 245. 27433
        • 246. 5224
        • 247. 22857
        • 248. 22858
        • 249. 16674
        • 250. 16676
        • 251. 30707
        • 252. 22715
        • 253. 22716
        • 254. 22717
        • 255. 22718
        • 256. 22719
        • 257. 22720
        • 258. 22721
        • 259. 22722
        • 260. 22723
        • 261. 22724
        • 262. 22725
        • 263. 22726
        • 264. 17540
        • 265. 27415
        • 266. 27416
        • 267. 22205
        • 268. 1612
        • 269. 15030
        • 270. 15031
        • 271. 13950
        • 272. 5303
        • 273. 5297
        • 274. 8823
        • 275. 137
        • 276. 174
        • 277. 1258
        • 278. 15462
        • 279. 196
        • 280. 2861
        • 281. 16001
        • 282. 16002
        • 283. 17028
        • 284. 16675
        • 285. 16580
        • 286. 16336
        • 287. 176
        • 288. 13896
        • 289. 28601
        • 290. 23715
        • 291. 23716
        • 292. 23717
        • 293. 23718
        • 294. 791
        • 295. 17595
        • 296. 14795
        • 297. 20116
        • 298. 20117
        • 299. 24501
        • 300. 24502
        • 301. 14589
        • 302. 118
        • 303. 34027
        • 304. 34166
        • 305. 34152
        • 306. 34157
        • 307. 34158
        • 308. 34153
        • 309. 34159
        • 310. 34154
        • 311. 34155
        • 312. 34160
        • 313. 34156
        • 314. 34161
        • 315. 34162
        • 316. 34163
        • 317. 34164
        • 318. 34167
        • 319. 34168
        • 320. 34169
        • 321. 34170
        • 322. 34171
        • 323. 34172
        • 324. 34173
        • 325. 34174
        • 326. 34175
        • 327. 17080
        • 328. 34420
        • 329. 14448
        • 330. 1002
        • 331. 34771
        • 332. 34772
        • 333. 34773
        • 334. 34774
        • 335. 34775
        • 336. 34776
        • 337. 34777
        • 338. 34778
        • 339. 18101
        • 340. 15218
        • 341. 15219
        • 342. 5207
        • 343. 15899
        • 344. 35491
        • 345. 35492
        • 346. 35852
        • 347. 35851
        • 348. 21984
        • 349. 34464
        • 350. 24971
        • 351. 36684
        • 352. 33779
        • 353. 33780
        • 354. 33090
        • 355. 22729
        • 356. 22728
        • 357. 22727
        • 358. 13516
        • 359. 30574
        • 360. 30576
        • 361. 9692
        • 362. 356
        • 363. 12778
        • 364. 8701
        • 365. 14198
        • 366. 3021
        • 367. 14589
        • 368. 196
        • 369. 13144
        • 370. 13145
        • 371. 18552
        • 372. 9124
        • 373. 10293
        • 374. 2778
        • 375. 258
        • 376. 1144
        • 377. 595
        • 378. 869
        • 379. 2118
        • 380. 4068
        • 381. 14795
        • 382. 852
        • 383. 2105
        • 384. 2104
        • 385. 1505
        • 386. 1527
        • 387. 414
        • 388. 9063
        • 389. 9064
        • 390. 9065
        • 391. 174
        • 392. 8823
        • 393. 173
        • 394. 176
        • 395. 148
        • 396. 1068
        • 397. 137
        • 398. 11116
        • 399. 73
        • 400. 9671
        • 401. 131
        • 402. 54
        • 403. 33983
        • 404. 23614
        • 405. 15741
        • 406. 35363
        • 407. 37062
        • 408. 19155
        • 409. 14163
        • 410. 29917
        • 411. 1867
        • 412. 36720
        • 413. 18562
        • 414. 18561
        • 415. 18564
        • 416. 18563
        • 417. 11116
        • 418. 35852
        • 419. 35851
        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 (630, 681, 745, 746, 747, 750, 751, 752, 754, 755, 757, 758, 761, 762, 764, 765, 766, 768, 779, 784, 785, 788, 789, 790, 795, 796, 797, 798, 801, 802, 803, 804, 805, 806, 808, 812, 813, 814, 815, 889, 910, 1052, 1054, 1059, 1079, 1087, 1101, 1116, 1118, 1428, 1439, 1471, 1605, 1641, 2156, 2675, 2700, 2928)2.23ms/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 (2, 18, 34, 46, 49, 52, 83, 84, 85, 86, 91, 105, 112, 133, 135, 153, 163)1.63ms/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 (2, 18, 34, 46, 49, 52, 83, 84, 85, 86, 91, 105, 112, 133, 135, 153, 163)1.66ms/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 (54, 73, 118, 131, 137, 148, 173, 174, 176, 196, 249, 258, 310, 356, 360, 367, 376, 379, 414, 491, 492, 583, 595, 644, 791, 852, 869, 1002, 1068, 1083, 1137, 1144, 1190, 1258, 1427, 1505, 1527, 1612, 1858, 1867, 2045, 2104, 2105, 2118, 2778, 2861, 3021, 4068, 4139, 4140, 4141, 5207, 5224, 5287, 5297, 5303, 8701, 8812, 8815, 8821, 8823, 8911, 9054, 9063, 9064, 9065, 9124, 9591, 9592, 9593, 9671, 9692, 10274, 10293, 10326, 10327, 11116, 11130, 11155, 12183, 12778, 12875, 13006, 13007, 13008, 13144, 13145, 13146, 13516, 13610, 13611, 13612, 13613, 13614, 13615, 13860, 13861, 13893, 13896, 13950, 14100, 14163, 14198, 14295, 14296, 14357, 14401, 14402, 14448, 14474, 14589, 14600, 14795, 15022, 15030, 15031, 15093, 15170, 15218, 15219, 15327, 15426, 15427, 15462, 15636, 15741, 15840, 15841, 15842, 15843, 15844, 15845, 15899, 16001, 16002, 16336, 16449, 16565, 16566, 16580, 16670, 16674, 16675, 16676, 16709, 16710, 16843, 16844, 16845, 16846, 16911, 17028, 17080, 17450, 17540, 17595, 17596, 17597, 17727, 18101, 18218, 18225, 18299, 18300, 18449, 18450, 18451, 18552, 18560, 18561, 18562, 18563, 18564, 18938, 19155, 20116, 20117, 21947, 21984, 22205, 22319, 22542, 22715, 22716, 22717, 22718, 22719, 22720, 22721, 22722, 22723, 22724, 22725, 22726, 22727, 22728, 22729, 22857, 22858, 23040, 23041, 23042, 23043, 23044, 23045, 23046, 23047, 23048, 23233, 23404, 23406, 23585, 23614, 23623, 23624, 23626, 23627, 23628, 23668, 23669, 23670, 23671, 23673, 23674, 23675, 23676, 23677, 23678, 23679, 23680, 23686, 23687, 23688, 23689, 23715, 23716, 23717, 23718, 24077, 24078, 24162, 24163, 24501, 24502, 24508, 24509, 24971, 25503, 25504, 25771, 25772, 25773, 25774, 25775, 25776, 25777, 25983, 26779, 27415, 27416, 27433, 27519, 28164, 28165, 28232, 28247, 28536, 28601, 29046, 29047, 29355, 29371, 29603, 29608, 29610, 29697, 29702, 29704, 29917, 29958, 30091, 30120, 30574, 30576, 30707, 31288, 31289, 31566, 31925, 31927, 32086, 32144, 32145, 32146, 32147, 32148, 32149, 33090, 33779, 33780, 33983, 34027, 34152, 34153, 34154, 34155, 34156, 34157, 34158, 34159, 34160, 34161, 34162, 34163, 34164, 34166, 34167, 34168, 34169, 34170, 34171, 34172, 34173, 34174, 34175, 34348, 34420, 34441, 34442, 34443, 34444, 34464, 34489, 34771, 34772, 34773, 34774, 34775, 34776, 34777, 34778, 34847, 34848, 35347, 35348, 35349, 35363, 35419, 35421, 35422, 35423, 35424, 35425, 35426, 35427, 35429, 35431, 35432, 35433, 35436, 35491, 35492, 35646, 35647, 35648, 35851, 35852, 35921, 35962, 35963, 36505, 36588, 36589, 36590, 36591, 36592, 36684, 36720, 37062, 38022, 38032, 38033, 38438) order by `position` asc43.18ms/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.57ms/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` = 17257 and `v2_members`.`deleted_at` is null2.04ms/app/CtbuhCompany.php:91buldingdb
        Metadata
        Bindings
        • 0. 17257
        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 * from `nav_menu_items` where `parent_id` is null2.11ms/app/NavMenuItem.php:17buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/NavMenuItem.php:17
        • 15. /app/Providers/AppServiceProvider.php:60
        • 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 19. /vendor/laravel/framework/src/Illuminate/View/View.php:124
        • 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 27 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.74ms/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.44ms/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.4ms/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.39ms/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.43ms/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.53ms/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.55ms/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.53ms/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\Member
      1
      App\Image
      2692
      App\Country
      34
      App\City
      58
      App\Building
      383
      App\CtbuhCompany
      15
          _token
          X5meOmnmtfAzdARzn5MrpybqQocxyjIrUlqI9v1L
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/17257" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /company/17257
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array:17 [▶
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "staging.skyscrapercenter.xyz"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]
          request_server
            0 of 0   
          array:40 [▶
  "USER" => "forge"
  "HOME" => "/home/forge"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_HOST" => "staging.skyscrapercenter.xyz"
  "REDIRECT_STATUS" => "200"
  "HTTPS" => "on"
  "SERVER_NAME" => "staging.skyscrapercenter.xyz"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "10.0.0.44"
  "REMOTE_PORT" => "3802"
  "REMOTE_ADDR" => "18.191.255.240"
  "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/17257"
  "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" => 1745019309.0531
  "REQUEST_TIME" => 1745019309
]
          request_cookies
          []
          response_headers
            0 of 0   
          array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Fri, 18 Apr 2025 23:35:11 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZ4TjlzT2NaTklJcjFnMmJwa2RmUFE9PSIsInZhbHVlIjoiMEhWanJXODJSaW9Wc09zV3Q5WTVcLzVOZ25WUlo4QWRzdlZZejQ4THNuejM5VVBqYzhlZlppQnVVNnlLdU5WYUtheDZLYitmU2lUTnlyM3labFl5NlZreEk2U01HcmVxeDBKclBRSGd6XC9aVVRlNXVPd3BuUnM3YlVBcXR1N2lXaCIsIm1hYyI6IjA0YWUxMjM5MzEwMDJjZjM3ZDZmZjk1YjhkZTgyOTg1YjcwNmVjZjc2YTJhZmQwZGRjNzFlMTU5OWQxM2IyMjMifQ%3D%3D; expires=Sat, 19-Apr-2025 01:35:11 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InZ4TjlzT2NaTklJcjFnMmJwa2RmUFE9PSIsInZhbHVlIjoiMEhWanJXODJSaW9Wc09zV3Q5WTVcLzVOZ25WUlo4QWRzdlZZejQ4THNuejM5VVBqYzhlZlppQnVVNnlLdU5WYUtheDZLY ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImtDVDZmS1ladnBBdzd2XC9IeWFNam93PT0iLCJ2YWx1ZSI6IjFMRXlVcVVKTldjMlBiYjA4dUQ5S0ZRdzg3MXc3azNpdGxMcmZ1UnRaTnVWSzgzMXF4S0cyZWpZV2swd3V6SlZBczdYRlEwUWhyT3BHVlZBRTJ2eUd3a2ZMSWdFc0cwTlpwV1c4blNLMCtzMHJvTkpMczhKV2F1Z2NDcWxIVkNjIiwibWFjIjoiNzdkMTIxNzkxMGQ4YWI5MWJkZmFmOTU4OTVmNDM5YmM3OTlkM2I1ODQ3ZGE4NjY4ZjFjMTY2YTI4OTM0YTE1NyJ9; expires=Sat, 19-Apr-2025 01:35:11 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImtDVDZmS1ladnBBdzd2XC9IeWFNam93PT0iLCJ2YWx1ZSI6IjFMRXlVcVVKTldjMlBiYjA4dUQ5S0ZRdzg3MXc3azNpdGxMcmZ1UnRaTnVWSzgzMXF4S0cyZWpZV2 ▶"
    2 => "visit_counter=eyJpdiI6InpEU25WNTlUMnMrbUJTNkRheHBpUWc9PSIsInZhbHVlIjoieGNDcTVsNnFOWkJrRVVtUE13SUlQVEVIMGdhY3BhZThlQ2w2Z1MxVXozWHBLTXgxRVhuXC9mMVpPV1ZQZHBHQ1ciLCJtYWMiOiI0NWY4NGQyN2YxYjNhOThlZTVjZTgxMjE3YzkyOWQxZTBjODNiOGM5YzM3MTM1NTAwNmQzYzA5NDc4ZDFlMWM2In0%3D; expires=Sun, 18-May-2025 23:35:09 GMT; Max-Age=2591998; path=/; httponly ◀visit_counter=eyJpdiI6InpEU25WNTlUMnMrbUJTNkRheHBpUWc9PSIsInZhbHVlIjoieGNDcTVsNnFOWkJrRVVtUE13SUlQVEVIMGdhY3BhZThlQ2w2Z1MxVXozWHBLTXgxRVhuXC9mMVpPV1ZQZHBHQ1ciLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZ4TjlzT2NaTklJcjFnMmJwa2RmUFE9PSIsInZhbHVlIjoiMEhWanJXODJSaW9Wc09zV3Q5WTVcLzVOZ25WUlo4QWRzdlZZejQ4THNuejM5VVBqYzhlZlppQnVVNnlLdU5WYUtheDZLYitmU2lUTnlyM3labFl5NlZreEk2U01HcmVxeDBKclBRSGd6XC9aVVRlNXVPd3BuUnM3YlVBcXR1N2lXaCIsIm1hYyI6IjA0YWUxMjM5MzEwMDJjZjM3ZDZmZjk1YjhkZTgyOTg1YjcwNmVjZjc2YTJhZmQwZGRjNzFlMTU5OWQxM2IyMjMifQ%3D%3D; expires=Sat, 19-Apr-2025 01:35:11 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InZ4TjlzT2NaTklJcjFnMmJwa2RmUFE9PSIsInZhbHVlIjoiMEhWanJXODJSaW9Wc09zV3Q5WTVcLzVOZ25WUlo4QWRzdlZZejQ4THNuejM5VVBqYzhlZlppQnVVNnlLdU5WYUtheDZLY ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImtDVDZmS1ladnBBdzd2XC9IeWFNam93PT0iLCJ2YWx1ZSI6IjFMRXlVcVVKTldjMlBiYjA4dUQ5S0ZRdzg3MXc3azNpdGxMcmZ1UnRaTnVWSzgzMXF4S0cyZWpZV2swd3V6SlZBczdYRlEwUWhyT3BHVlZBRTJ2eUd3a2ZMSWdFc0cwTlpwV1c4blNLMCtzMHJvTkpMczhKV2F1Z2NDcWxIVkNjIiwibWFjIjoiNzdkMTIxNzkxMGQ4YWI5MWJkZmFmOTU4OTVmNDM5YmM3OTlkM2I1ODQ3ZGE4NjY4ZjFjMTY2YTI4OTM0YTE1NyJ9; expires=Sat, 19-Apr-2025 01:35:11 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImtDVDZmS1ladnBBdzd2XC9IeWFNam93PT0iLCJ2YWx1ZSI6IjFMRXlVcVVKTldjMlBiYjA4dUQ5S0ZRdzg3MXc3azNpdGxMcmZ1UnRaTnVWSzgzMXF4S0cyZWpZV2 ▶"
    2 => "visit_counter=eyJpdiI6InpEU25WNTlUMnMrbUJTNkRheHBpUWc9PSIsInZhbHVlIjoieGNDcTVsNnFOWkJrRVVtUE13SUlQVEVIMGdhY3BhZThlQ2w2Z1MxVXozWHBLTXgxRVhuXC9mMVpPV1ZQZHBHQ1ciLCJtYWMiOiI0NWY4NGQyN2YxYjNhOThlZTVjZTgxMjE3YzkyOWQxZTBjODNiOGM5YzM3MTM1NTAwNmQzYzA5NDc4ZDFlMWM2In0%3D; expires=Sun, 18-May-2025 23:35:09 GMT; path=/; httponly ◀visit_counter=eyJpdiI6InpEU25WNTlUMnMrbUJTNkRheHBpUWc9PSIsInZhbHVlIjoieGNDcTVsNnFOWkJrRVVtUE13SUlQVEVIMGdhY3BhZThlQ2w2Z1MxVXozWHBLTXgxRVhuXC9mMVpPV1ZQZHBHQ1ciLC ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▶
  "_token" => "X5meOmnmtfAzdARzn5MrpybqQocxyjIrUlqI9v1L"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/company/17257"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]