Ping An Life Insurance Company of China

Buildings

7.3.33PHP Version502msRequest Duration9MBMemory UsageGET company/{id}Route
    • Booting (21.82ms)
    • Application (480ms)
    • 1 x Application (95.62%)
      480.05ms
      1 x Booting (4.35%)
      21.82ms
      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
      25 statements were executed, 2 of which were duplicated, 23 unique436ms
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = '10247' limit 118.47ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb
        Metadata
        Bindings
        • 0. 10247
        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 = '10247' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name1.61ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/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 = '10247' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name135ms/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` = 4891 and `ctbuh_company`.`deleted_at` is null limit 13.88ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 4891
        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 = '4891' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name109ms/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` = 18118 and `ctbuh_company`.`deleted_at` is null limit 11.27ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 18118
        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 = '18118' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name112ms/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` = 'Ping An Life Insurance Company of China' and `active` = '1'5.46ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. Ping An Life Insurance Company of China
        • 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 (4891, 18118, 10247)7.69ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 4891
        • 1. 18118
        • 2. 10247
        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 (5207, 54, 54, 36418, 36419, 36443, 36444, 36448, 36449, 36450, 36455, 37062, 37062, 34348, 15542, 32086, 32087, 9575, 36399, 36418, 36419, 36443, 36444, 36448, 36449, 36450, 36455) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc4.2ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 5207
        • 3. 54
        • 4. 54
        • 5. 36418
        • 6. 36419
        • 7. 36443
        • 8. 36444
        • 9. 36448
        • 10. 36449
        • 11. 36450
        • 12. 36455
        • 13. 37062
        • 14. 37062
        • 15. 34348
        • 16. 15542
        • 17. 32086
        • 18. 32087
        • 19. 9575
        • 20. 36399
        • 21. 36418
        • 22. 36419
        • 23. 36443
        • 24. 36444
        • 25. 36448
        • 26. 36449
        • 27. 36450
        • 28. 36455
        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 (658, 745, 751, 765, 803, 805, 942)4.43ms/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, 34, 56)2.87ms/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, 34, 56)1.52ms/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, 5207, 9575, 15542, 32086, 32087, 34348, 36399, 36418, 36419, 36443, 36444, 36448, 36449, 36450, 37062) order by `position` asc6.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.51ms/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` = 10247 and `v2_members`.`deleted_at` is null2.05ms/app/CtbuhCompany.php:91buldingdb
        Metadata
        Bindings
        • 0. 10247
        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 null1.39ms/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` asc2.08ms/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.04ms/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.53ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 28
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 2 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.49ms/app/NavMenuItem.php:110buldingdb
        Metadata
        Bindings
        • 0. 2
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/NavMenuItem.php:110
        • 20. /app/NavMenuItem.php:115
        • 21. view::common.header:85
        • 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
      • select * from `nav_menu_items` where `nav_menu_items`.`parent_id` = 4 and `nav_menu_items`.`parent_id` is not null order by `display_order` asc1.78ms/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` asc3.06ms/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.94ms/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.55ms/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\Image
      159
      App\Country
      6
      App\City
      7
      App\Building
      16
      App\CtbuhCompany
      3
          _token
          ROVLew6OYQqyYDT5Ih9y1HT2XmvHJdBM7xp3tsjV
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/10247" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /company/10247
          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" => "58585" "REMOTE_ADDR" => "3.16.131.195" "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/10247" "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" => 1739482548.8064 "REQUEST_TIME" => 1739482548 ]
          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 => "Thu, 13 Feb 2025 21:35:49 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Imo1ZHU4cXk5WVBGaGFJNWNRRExyeXc9PSIsInZhbHVlIjoiNmVsNWJiWlNiclwvU0p4RjZCRFBBOEZHd3FZNEoxaHFMUktjODNjdjZZaEgzcWFLNlVLMVhXeFNWQzRMMXJcL25kYUlQTVVPVDRMMDlraFhZc2FGXC8xQzFESkRyQk1ORTFzTlpFclI0NVBFZ05qNWN6blpqMVB6Nm5nTUR1UEhPSjAiLCJtYWMiOiJjYmJmMzViYWE4NzlmMzk1ZjM0Y2Y2ZmIzNDdjY2I1NjgyMzg0OTU5NTg5ZWVlMGRkMzY1YzJhOTRlMTFkZGMzIn0%3D; expires=Thu, 13-Feb-2025 23:35:49 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6Imo1ZHU4cXk5WVBGaGFJNWNRRExyeXc9PSIsInZhbHVlIjoiNmVsNWJiWlNiclwvU0p4RjZCRFBBOEZHd3FZNEoxaHFMUktjODNjdjZZaEgzcWFLNlVLMVhXeFNWQzRMMXJcL25kYUlQT" 1 => "skyscraper_center_session=eyJpdiI6InludSs5M0Rha01mUFE3dVpXSjdIWFE9PSIsInZhbHVlIjoiQWJ0WUFkSlYzdmV1VER5SHhJZlNNaEhwM0ZkWkFUcDZTT2lzTzFDMzFFdWxsXC9vNFZKRXpxQ3A0UTZRNzQ5SVpBdGJQa1JqeDBqY216R3htUCs1ajFvYm5FdWs1S1U2Mko2M3NVRkRmaVkxZTZFMkZQUEthQTJta1JSSUJ5cnZPIiwibWFjIjoiZjIzYTFmZDQ0ZWNkMGQ2MTUwMjk1OGIzNmFhZjJhNzEwYzlmYTA2ZGUyYjQzYzAwYTEwMWIwOWE3NGE1YzRlMiJ9; expires=Thu, 13-Feb-2025 23:35:49 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6InludSs5M0Rha01mUFE3dVpXSjdIWFE9PSIsInZhbHVlIjoiQWJ0WUFkSlYzdmV1VER5SHhJZlNNaEhwM0ZkWkFUcDZTT2lzTzFDMzFFdWxsXC9vNFZKRXpxQ3A0UT" 2 => "visit_counter=eyJpdiI6IlF5Y2VHTVFxb3ZienJOckRhZFwvM21RPT0iLCJ2YWx1ZSI6ImVLeXByMG1qWEVsNmVmNWh1S3FuUXZ1WmVHRWp1SEVZbXFvSmh2S3dFRUFwTW1xZHNzak1XSG5DKzIzSW9IZ2giLCJtYWMiOiJjMjBiZjc2ZjEzZDFiNTk0NjM0OGVhNTkxN2NlZDMyMzFlMTFjZTgxMDAwZjk1Mjg3YTEzMjQ5YTA1YzA3ZWI5In0%3D; expires=Sat, 15-Mar-2025 21:35:48 GMT; Max-Age=2591999; path=/; httponlyvisit_counter=eyJpdiI6IlF5Y2VHTVFxb3ZienJOckRhZFwvM21RPT0iLCJ2YWx1ZSI6ImVLeXByMG1qWEVsNmVmNWh1S3FuUXZ1WmVHRWp1SEVZbXFvSmh2S3dFRUFwTW1xZHNzak1XSG5DKzIzSW9IZ2giLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6Imo1ZHU4cXk5WVBGaGFJNWNRRExyeXc9PSIsInZhbHVlIjoiNmVsNWJiWlNiclwvU0p4RjZCRFBBOEZHd3FZNEoxaHFMUktjODNjdjZZaEgzcWFLNlVLMVhXeFNWQzRMMXJcL25kYUlQTVVPVDRMMDlraFhZc2FGXC8xQzFESkRyQk1ORTFzTlpFclI0NVBFZ05qNWN6blpqMVB6Nm5nTUR1UEhPSjAiLCJtYWMiOiJjYmJmMzViYWE4NzlmMzk1ZjM0Y2Y2ZmIzNDdjY2I1NjgyMzg0OTU5NTg5ZWVlMGRkMzY1YzJhOTRlMTFkZGMzIn0%3D; expires=Thu, 13-Feb-2025 23:35:49 GMT; path=/XSRF-TOKEN=eyJpdiI6Imo1ZHU4cXk5WVBGaGFJNWNRRExyeXc9PSIsInZhbHVlIjoiNmVsNWJiWlNiclwvU0p4RjZCRFBBOEZHd3FZNEoxaHFMUktjODNjdjZZaEgzcWFLNlVLMVhXeFNWQzRMMXJcL25kYUlQT" 1 => "skyscraper_center_session=eyJpdiI6InludSs5M0Rha01mUFE3dVpXSjdIWFE9PSIsInZhbHVlIjoiQWJ0WUFkSlYzdmV1VER5SHhJZlNNaEhwM0ZkWkFUcDZTT2lzTzFDMzFFdWxsXC9vNFZKRXpxQ3A0UTZRNzQ5SVpBdGJQa1JqeDBqY216R3htUCs1ajFvYm5FdWs1S1U2Mko2M3NVRkRmaVkxZTZFMkZQUEthQTJta1JSSUJ5cnZPIiwibWFjIjoiZjIzYTFmZDQ0ZWNkMGQ2MTUwMjk1OGIzNmFhZjJhNzEwYzlmYTA2ZGUyYjQzYzAwYTEwMWIwOWE3NGE1YzRlMiJ9; expires=Thu, 13-Feb-2025 23:35:49 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6InludSs5M0Rha01mUFE3dVpXSjdIWFE9PSIsInZhbHVlIjoiQWJ0WUFkSlYzdmV1VER5SHhJZlNNaEhwM0ZkWkFUcDZTT2lzTzFDMzFFdWxsXC9vNFZKRXpxQ3A0UT" 2 => "visit_counter=eyJpdiI6IlF5Y2VHTVFxb3ZienJOckRhZFwvM21RPT0iLCJ2YWx1ZSI6ImVLeXByMG1qWEVsNmVmNWh1S3FuUXZ1WmVHRWp1SEVZbXFvSmh2S3dFRUFwTW1xZHNzak1XSG5DKzIzSW9IZ2giLCJtYWMiOiJjMjBiZjc2ZjEzZDFiNTk0NjM0OGVhNTkxN2NlZDMyMzFlMTFjZTgxMDAwZjk1Mjg3YTEzMjQ5YTA1YzA3ZWI5In0%3D; expires=Sat, 15-Mar-2025 21:35:48 GMT; path=/; httponlyvisit_counter=eyJpdiI6IlF5Y2VHTVFxb3ZienJOckRhZFwvM21RPT0iLCJ2YWx1ZSI6ImVLeXByMG1qWEVsNmVmNWh1S3FuUXZ1WmVHRWp1SEVZbXFvSmh2S3dFRUFwTW1xZHNzak1XSG5DKzIzSW9IZ2giLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "ROVLew6OYQqyYDT5Ih9y1HT2XmvHJdBM7xp3tsjV" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/10247" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]