CS Associates, Inc.

Formerly Named:
 
Chris P. Stefanos & Associates

Buildings

7.3.33PHP Version362msRequest Duration10MBMemory UsageGET company/{id}Route
    • Booting (11.76ms)
    • Application (350ms)
    • 1 x Application (96.72%)
      350.32ms
      1 x Booting (3.25%)
      11.76ms
      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
      23 statements were executed, 2 of which were duplicated, 21 unique244ms
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = '2046' limit 110.53ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb
        Metadata
        Bindings
        • 0. 2046
        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 = '2046' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name6.43ms/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 = '2046' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name76.28ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/CtbuhCompany.php:172
        • 11. /app/CtbuhCompany.php:207
        • 12. /app/CtbuhCompany.php:254
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:47
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = 1790 and `ctbuh_company`.`deleted_at` is null limit 11.61ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb
        Metadata
        Bindings
        • 0. 1790
        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 = '1790' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name104ms/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` = 'CS Associates, Inc.' and `active` = '1'1.43ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. CS Associates, Inc.
        • 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 (1790, 2046)4.07ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 1790
        • 1. 2046
        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 (18120, 18079, 1160, 19394, 793, 30389, 15323, 28109, 21953, 9096, 9097, 9098, 9099, 9277, 9290, 9867, 9941, 9967, 10020, 13135, 9900, 9936, 887, 2586, 3878, 17513, 9853, 3879, 3647, 12514, 9316, 13870, 3558, 2088, 27770, 2522, 1809, 3507, 1897, 15632, 10035, 14595, 15371, 13131, 3102, 8745, 9857, 9856, 9959, 10309, 9868, 11097, 9292, 16553, 32582, 9940, 36885, 9855, 10744) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc5.01ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 18120
        • 3. 18079
        • 4. 1160
        • 5. 19394
        • 6. 793
        • 7. 30389
        • 8. 15323
        • 9. 28109
        • 10. 21953
        • 11. 9096
        • 12. 9097
        • 13. 9098
        • 14. 9099
        • 15. 9277
        • 16. 9290
        • 17. 9867
        • 18. 9941
        • 19. 9967
        • 20. 10020
        • 21. 13135
        • 22. 9900
        • 23. 9936
        • 24. 887
        • 25. 2586
        • 26. 3878
        • 27. 17513
        • 28. 9853
        • 29. 3879
        • 30. 3647
        • 31. 12514
        • 32. 9316
        • 33. 13870
        • 34. 3558
        • 35. 2088
        • 36. 27770
        • 37. 2522
        • 38. 1809
        • 39. 3507
        • 40. 1897
        • 41. 15632
        • 42. 10035
        • 43. 14595
        • 44. 15371
        • 45. 13131
        • 46. 3102
        • 47. 8745
        • 48. 9857
        • 49. 9856
        • 50. 9959
        • 51. 10309
        • 52. 9868
        • 53. 11097
        • 54. 9292
        • 55. 16553
        • 56. 32582
        • 57. 9940
        • 58. 36885
        • 59. 9855
        • 60. 10744
        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 (1539, 1627, 1628, 1634, 1657)1.56ms/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 (163)1.32ms/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 (163)1.47ms/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 (793, 887, 1160, 1809, 1897, 2088, 2522, 2586, 3102, 3507, 3558, 3647, 3878, 3879, 8745, 9096, 9097, 9098, 9099, 9277, 9290, 9292, 9316, 9853, 9855, 9856, 9857, 9867, 9868, 9900, 9936, 9940, 9941, 9959, 9967, 10020, 10035, 10309, 10744, 11097, 12514, 13131, 13135, 13870, 14595, 15323, 15371, 15632, 16553, 17513, 18079, 18120, 19394, 21953, 27770, 28109, 30389, 32582, 36885) order by `position` asc11.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.46ms/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` = 2046 and `v2_members`.`deleted_at` is null1.7ms/app/CtbuhCompany.php:91buldingdb
        Metadata
        Bindings
        • 0. 2046
        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 null3.7ms/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.06ms/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 12.12ms/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.34ms/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.3ms/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.35ms/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.36ms/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.28ms/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.2ms/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
      315
      App\Country
      2
      App\City
      5
      App\Building
      59
      App\CtbuhCompany
      2
          _token
          8qJhFTrw2OJf9uEZyAo9rUQh37lDUWdrQJWlYrxg
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/2046" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /company/2046
          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" => "35370" "REMOTE_ADDR" => "3.145.177.180" "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/2046" "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" => 1744993627.9576 "REQUEST_TIME" => 1744993627 ]
          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 16:27:08 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6InFsRXkwVUNpRXB1anp3SHV2SzBpNEE9PSIsInZhbHVlIjoiSHc2YURhb3hpb1wvY280NzVPYThWdXl0bDlwY2FVXC9RY1FGK0lHeG5aTWV1XC91emh2amhDaVNrWGZHWlBTU29cL1ZGckVwTFBzdmRPNEZWNmNoeHpsdFBYaXk2cG1OMzY2d09YZUViQWRjVmZCYjA1TGlIbzlMMERoelJ0MXVRdEQ0IiwibWFjIjoiYjAwZjQ2YmE2NDRjMWVhMzE0MTI4Yzk3MjllMTlkZjExYzJkMGU0MjlkMDVhZDFlOTQzMmZlZWExNTNjMjE4NCJ9; expires=Fri, 18-Apr-2025 18:27:08 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6InFsRXkwVUNpRXB1anp3SHV2SzBpNEE9PSIsInZhbHVlIjoiSHc2YURhb3hpb1wvY280NzVPYThWdXl0bDlwY2FVXC9RY1FGK0lHeG5aTWV1XC91emh2amhDaVNrWGZHWlBTU29cL1ZGc" 1 => "skyscraper_center_session=eyJpdiI6Ilg2bjljZEZRV3oxRXNaWUxJbk1ucUE9PSIsInZhbHVlIjoiZSt2bFU3U1RNSlJjTjNvWnJWM3lGdGdVNE42cnZDWG9pTW5OUEllK01LeHBvazU0U1o3RVM4Z0liaHR5cUZqT3hVQkJpYm1POGNpNEFJdzRDN0ZVd1V1Y3VLVVIrVGlBQk9FVU5EWG5VNmZjOU5ybkdkWXRDVHFXSjNjNllrNUEiLCJtYWMiOiIzYjBmMjJkMWQ3ZDYxNGQyYmM3NzlmOWI5OTgyZmExOTQ3ODMxYTM3ZmYwNTgwZmU0OGE3MWFkYTY4MTU2N2VlIn0%3D; expires=Fri, 18-Apr-2025 18:27:08 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6Ilg2bjljZEZRV3oxRXNaWUxJbk1ucUE9PSIsInZhbHVlIjoiZSt2bFU3U1RNSlJjTjNvWnJWM3lGdGdVNE42cnZDWG9pTW5OUEllK01LeHBvazU0U1o3RVM4Z0liaH" 2 => "visit_counter=eyJpdiI6ImY4aktsVkw0cmkxeUQ3QVM2ZzRES0E9PSIsInZhbHVlIjoieGNPbTYrVTVyVjI4VzJ5TW8zNjQ4UDUyR3VCQkhxNjlqRTVLV3dLelBBZEpBSnQzSHBHTmo4dUdmbHQ1SXU3WiIsIm1hYyI6ImY5ZmIzNDNkOTYzY2Y5NDJkZjIyMWZhMDk2OGJlNjhlNzY4MDBjNjYwOGIxYjhjNGI2NTk5NGFjM2Q1MjIzNjUifQ%3D%3D; expires=Sun, 18-May-2025 16:27:08 GMT; Max-Age=2592000; path=/; httponlyvisit_counter=eyJpdiI6ImY4aktsVkw0cmkxeUQ3QVM2ZzRES0E9PSIsInZhbHVlIjoieGNPbTYrVTVyVjI4VzJ5TW8zNjQ4UDUyR3VCQkhxNjlqRTVLV3dLelBBZEpBSnQzSHBHTmo4dUdmbHQ1SXU3WiIsIm" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6InFsRXkwVUNpRXB1anp3SHV2SzBpNEE9PSIsInZhbHVlIjoiSHc2YURhb3hpb1wvY280NzVPYThWdXl0bDlwY2FVXC9RY1FGK0lHeG5aTWV1XC91emh2amhDaVNrWGZHWlBTU29cL1ZGckVwTFBzdmRPNEZWNmNoeHpsdFBYaXk2cG1OMzY2d09YZUViQWRjVmZCYjA1TGlIbzlMMERoelJ0MXVRdEQ0IiwibWFjIjoiYjAwZjQ2YmE2NDRjMWVhMzE0MTI4Yzk3MjllMTlkZjExYzJkMGU0MjlkMDVhZDFlOTQzMmZlZWExNTNjMjE4NCJ9; expires=Fri, 18-Apr-2025 18:27:08 GMT; path=/XSRF-TOKEN=eyJpdiI6InFsRXkwVUNpRXB1anp3SHV2SzBpNEE9PSIsInZhbHVlIjoiSHc2YURhb3hpb1wvY280NzVPYThWdXl0bDlwY2FVXC9RY1FGK0lHeG5aTWV1XC91emh2amhDaVNrWGZHWlBTU29cL1ZGc" 1 => "skyscraper_center_session=eyJpdiI6Ilg2bjljZEZRV3oxRXNaWUxJbk1ucUE9PSIsInZhbHVlIjoiZSt2bFU3U1RNSlJjTjNvWnJWM3lGdGdVNE42cnZDWG9pTW5OUEllK01LeHBvazU0U1o3RVM4Z0liaHR5cUZqT3hVQkJpYm1POGNpNEFJdzRDN0ZVd1V1Y3VLVVIrVGlBQk9FVU5EWG5VNmZjOU5ybkdkWXRDVHFXSjNjNllrNUEiLCJtYWMiOiIzYjBmMjJkMWQ3ZDYxNGQyYmM3NzlmOWI5OTgyZmExOTQ3ODMxYTM3ZmYwNTgwZmU0OGE3MWFkYTY4MTU2N2VlIn0%3D; expires=Fri, 18-Apr-2025 18:27:08 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6Ilg2bjljZEZRV3oxRXNaWUxJbk1ucUE9PSIsInZhbHVlIjoiZSt2bFU3U1RNSlJjTjNvWnJWM3lGdGdVNE42cnZDWG9pTW5OUEllK01LeHBvazU0U1o3RVM4Z0liaH" 2 => "visit_counter=eyJpdiI6ImY4aktsVkw0cmkxeUQ3QVM2ZzRES0E9PSIsInZhbHVlIjoieGNPbTYrVTVyVjI4VzJ5TW8zNjQ4UDUyR3VCQkhxNjlqRTVLV3dLelBBZEpBSnQzSHBHTmo4dUdmbHQ1SXU3WiIsIm1hYyI6ImY5ZmIzNDNkOTYzY2Y5NDJkZjIyMWZhMDk2OGJlNjhlNzY4MDBjNjYwOGIxYjhjNGI2NTk5NGFjM2Q1MjIzNjUifQ%3D%3D; expires=Sun, 18-May-2025 16:27:08 GMT; path=/; httponlyvisit_counter=eyJpdiI6ImY4aktsVkw0cmkxeUQ3QVM2ZzRES0E9PSIsInZhbHVlIjoieGNPbTYrVTVyVjI4VzJ5TW8zNjQ4UDUyR3VCQkhxNjlqRTVLV3dLelBBZEpBSnQzSHBHTmo4dUdmbHQ1SXU3WiIsIm" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "8qJhFTrw2OJf9uEZyAo9rUQh37lDUWdrQJWlYrxg" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/2046" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]