Hanoi

Vietnam

Videos

Filter by

03 March 2008

Sustainable Design in South Korea and Vietnam

Matthias A. Olt & James P. Rothwell of Callison, discussed two high-rise towers in South Korea and Vietnam at the CTBUH 8th World Congress in...

We use cookies to improve your experience on our website. Review our Privacy Policy for more information.
MessagesTimelineExceptionsViews16RouteQueries28Models138MailsGateSessionRequest
7.3.33PHP Version417msRequest Duration10MBMemory UsageGET city/{slug}/videosRoute
    • Booting (7.25ms)
    • Application (410ms)
    • 1 x Application (98.24%)
      409.66ms
      1 x Booting (1.74%)
      7.25ms
      16 templates were rendered
      • cities.tabs.videos (resources/views/cities/tabs/videos.blade.php)6blade
        Params
        0
        geo
        1
        title
        2
        videos
        3
        videoCategories
        4
        tabsData
        5
        accessLevel
      • buildings.partials.videos (resources/views/buildings/partials/videos.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
      • buildings.partials.elements.video-list (resources/views/buildings/partials/elements/video-list.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        __currentLoopData
        13
        category
        14
        index
        15
        loop
        16
        video
      • buildings.partials.elements.video-grid (resources/views/buildings/partials/elements/video-grid.blade.php)17blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        __currentLoopData
        13
        category
        14
        index
        15
        loop
        16
        video
      • buildings.partials.elements.pagination (resources/views/buildings/partials/elements/pagination.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        __currentLoopData
        13
        category
        14
        index
        15
        loop
        16
        video
        17
        entities
        18
        elementsToShow
      • cities.layout (resources/views/cities/layout.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
      • layouts.SSC (resources/views/layouts/SSC.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
      • common.header (resources/views/common/header.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
        13
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)14php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
        13
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)18php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
        13
        nav
        14
        __currentLoopData
        15
        item
        16
        loop
        17
        child
      • common.footer (resources/views/common/footer.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
        13
        alreadyConsentedWithCookies
        14
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)15blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        videos
        9
        videoCategories
        10
        tabsData
        11
        accessLevel
        12
        data
        13
        alreadyConsentedWithCookies
        14
        cookieConsentConfig
      uri
      GET city/{slug}/videos
      middleware
      web
      controller
      App\Http\Controllers\CityController@videos
      namespace
      App\Http\Controllers
      prefix
      where
      as
      city-videos
      file
      app/Http/Controllers/CityController.php:668-694
      28 statements were executed, 2 of which were duplicated, 26 unique360ms
      buldingdb
      • select * from `v2_cities` where `slug` = 'hanoi' limit 19.24ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Bindings
        • 0. hanoi
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. /app/Http/Controllers/CityController.php:678
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_countries` where `v2_countries`.`id` in (168)1.26ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:678
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_regions` where `v2_regions`.`id` in (7)1.25ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:678
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `ctbuh_building` where `active` = '1' and `structure_type` = 'building' and (`linked_building_status` is null or `linked_building_status` not in ('COM', 'UC', 'STO', 'UCT')) and `ctbuh_building`.`city_id` in (1738) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc300ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. building
        • 2. COM
        • 3. UC
        • 4. STO
        • 5. UCT
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:678
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_cities` where `v2_cities`.`id` in (1738)1.76ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 26. /app/Http/Controllers/CityController.php:678
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v2_initiatives`.*, `v2_city_initiative`.`city_id` as `pivot_city_id`, `v2_city_initiative`.`initiative_id` as `pivot_initiative_id` from `v2_initiatives` inner join `v2_city_initiative` on `v2_initiatives`.`id` = `v2_city_initiative`.`initiative_id` where `v2_city_initiative`.`city_id` in (1738) order by `start_date` desc1.71ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:678
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_cities` where `v2_cities`.`id` in (1738)1.55ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:678
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v2_resources`.*, `v2_city_resource`.`city_id` as `pivot_city_id`, `v2_city_resource`.`resource_id` as `pivot_resource_id` from `v2_resources` inner join `v2_city_resource` on `v2_resources`.`id` = `v2_city_resource`.`resource_id` where `v2_city_resource`.`city_id` in (1738) order by `type` asc, `date` desc6.89ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:678
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select * from `v2_people` where `v2_people`.`city_id` in (1738)3.05ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:678
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v2_roles`.*, `v2_person_role`.`person_id` as `pivot_person_id`, `v2_person_role`.`role_id` as `pivot_role_id`, `v2_person_role`.`year_start` as `pivot_year_start`, `v2_person_role`.`year_end` as `pivot_year_end`, `v2_person_role`.`title` as `pivot_title`, `v2_person_role`.`link` as `pivot_link`, `v2_person_role`.`display_order` as `pivot_display_order`, `v2_person_role`.`hide_in_lists` as `pivot_hide_in_lists` from `v2_roles` inner join `v2_person_role` on `v2_roles`.`id` = `v2_person_role`.`role_id` where `v2_person_role`.`person_id` in (450, 6619, 6988) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc2.09ms/app/Http/Controllers/CityController.php:678buldingdb
        Metadata
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:678
        • 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
        • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `v2_members`.*, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_members` inner join `v2_city_member` on `v2_members`.`id` = `v2_city_member`.`member_id` where `v2_city_member`.`city_id` = 1738 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc4.02ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 1738
        • 1. 0
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:756
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 415 and `ctbuh_company`.`deleted_at` is null2.16ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 415
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 989 and `ctbuh_company`.`deleted_at` is null2.19ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 989
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select `ctbuh_company`.*, `v2_ctbuh_company_member`.`member_id` as `pivot_member_id`, `v2_ctbuh_company_member`.`ctbuh_company_id` as `pivot_ctbuh_company_id` from `ctbuh_company` inner join `v2_ctbuh_company_member` on `ctbuh_company`.`id` = `v2_ctbuh_company_member`.`ctbuh_company_id` where `v2_ctbuh_company_member`.`member_id` = 990 and `ctbuh_company`.`deleted_at` is null1.84ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 990
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_categories` where `type` = 'Video'1.53ms/app/Http/Controllers/CityController.php:794buldingdb
        Metadata
        Bindings
        • 0. Video
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/CityController.php:794
        • 13. /app/Http/Controllers/CityController.php:680
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_resource_subcategories` where `type` = 'Video' and `id` = 14 limit 11.42ms/app/Http/Controllers/CityController.php:803buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 14
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 13. /app/Http/Controllers/CityController.php:803
        • 14. /app/Http/Controllers/CityController.php:680
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select `v2_people`.*, `v2_city_person`.`city_id` as `pivot_city_id`, `v2_city_person`.`person_id` as `pivot_person_id`, `v2_city_person`.`year_start` as `pivot_year_start`, `v2_city_person`.`year_end` as `pivot_year_end`, `v2_city_person`.`title` as `pivot_title`, `v2_city_person`.`display_order` as `pivot_display_order` from `v2_people` inner join `v2_city_person` on `v2_people`.`id` = `v2_city_person`.`person_id` where `v2_city_person`.`city_id` = 1738 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc1.83ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 1738
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:896
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `global_news_posts` where `global_news_posts`.`city_id` = 1738 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-16 04:01:37' and `deleted_at` is null order by `published_at` desc1.46ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 1738
        • 1. 2025-04-16 04:01:37
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:904
        • 20. /app/Http/Controllers/CityController.php:680
        • 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
      • select * from `v2_countries` where `v2_countries`.`id` = 168 limit 11.41ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 168
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. /app/Http/Controllers/Controller.php:423
        • 22. /app/Http/Controllers/CityController.php:950
        • 23. /app/Http/Controllers/CityController.php:680
        • 24. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • select * from `nav_menu_items` where `parent_id` is null1.36ms/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.57ms/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.56ms/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.41ms/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.62ms/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.43ms/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.49ms/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\CtbuhCompany
      3
      App\Member
      3
      App\Role
      1
      App\Person
      3
      App\Initiative
      1
      App\Building
      84
      App\Region
      1
      App\Country
      2
      App\City
      3
          _token
          Ju81p7S8HEjHw73IyT9v970HDYwpg173VtBEmqpA
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/hanoi/videos" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/hanoi/videos
          status_code
          200
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          request_request
          []
          request_headers
            0 of 0   
          array:18 [▶
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InZFT2xrTzN3UkNFNGswM0lqcTVIT0E9PSIsInZhbHVlIjoiTGw5bFNPNmVUMU9HbEVWWVdpelRzbmRjMm9CVTZvOTFOeTlaR2RFcCtiVUdOTTE3bjBSUWxGS21FbXcyR1NXMnZraU1hS0Z2dEp6anpyZ3Y2alBwM3lObDNHc0hiN0pJdm0yYTVQbURtemVxSHpGXC8xXC9JYldtOEtqRlU4eEM1TCIsIm1hYyI6IjU2Mzc0ZTBiYmE1ZGE0ZDA5YWQ1YzM5NjM3OTczNDVmZWExMDZlMTBhZDM2NTljMWU5ZjIxY2U0NDk1ZTljNTcifQ%3D%3D; skyscraper_center_session=eyJpdiI6ImRFejgyT09YYitwMTFKVGRNbzB1N1E9PSIsInZhbHVlIjoieW5ISjl1WjcrNHVwMkpURW1odUdzeE1CWThjbEpicWhrN1lLZlI5eFlcLzU1VDEyQ3Y2XC9QZ2dTRzlON0xxM0djZUxCeDF3SlV3YUhzUk1ZWG5NNEJnOUxyNFNidFhuZWdkbmFEellWQW4zZzRydGRibjdySUQxU0Q1bEh2UGJqTSIsIm1hYyI6IjQ2MmIzY2ZlOWNiMTdkNGMxNzE0MmUxOWQ4ZDI3ZTY1NzY3MmZlM2U4N2U3NzIzYjVlNmVhMzhlYmM5MTJmYTQifQ%3D%3D; visit_counter=eyJpdiI6Ino1cUZPY1cybWVTRit2UUJnTmxiMmc9PSIsInZhbHVlIjoiTVJRVXhFN2FGS1k3WXdwZFpmNkZiZCsrUTBHTUxuZHdsekEyVGlFRzViXC9ZbTk2dEh5b2dqRXVsd3N1blVmbTQiLCJtYWMiOiIwMDlkYWIwMGRkMDdkOGE1YThkZGJjZmJkMmRhYTJjZmZhYzc2YWE5ODc0Yzk2ZGI5ZmI3MzFjNGFmM2VlZjIzIn0%3D ◀XSRF-TOKEN=eyJpdiI6InZFT2xrTzN3UkNFNGswM0lqcTVIT0E9PSIsInZhbHVlIjoiTGw5bFNPNmVUMU9HbEVWWVdpelRzbmRjMm9CVTZvOTFOeTlaR2RFcCtiVUdOTTE3bjBSUWxGS21FbXcyR1NXMnZraU1hS ▶"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "staging.skyscrapercenter.xyz"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]
          request_server
            0 of 0   
          array:41 [▶
  "USER" => "forge"
  "HOME" => "/home/forge"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6InZFT2xrTzN3UkNFNGswM0lqcTVIT0E9PSIsInZhbHVlIjoiTGw5bFNPNmVUMU9HbEVWWVdpelRzbmRjMm9CVTZvOTFOeTlaR2RFcCtiVUdOTTE3bjBSUWxGS21FbXcyR1NXMnZraU1hS0Z2dEp6anpyZ3Y2alBwM3lObDNHc0hiN0pJdm0yYTVQbURtemVxSHpGXC8xXC9JYldtOEtqRlU4eEM1TCIsIm1hYyI6IjU2Mzc0ZTBiYmE1ZGE0ZDA5YWQ1YzM5NjM3OTczNDVmZWExMDZlMTBhZDM2NTljMWU5ZjIxY2U0NDk1ZTljNTcifQ%3D%3D; skyscraper_center_session=eyJpdiI6ImRFejgyT09YYitwMTFKVGRNbzB1N1E9PSIsInZhbHVlIjoieW5ISjl1WjcrNHVwMkpURW1odUdzeE1CWThjbEpicWhrN1lLZlI5eFlcLzU1VDEyQ3Y2XC9QZ2dTRzlON0xxM0djZUxCeDF3SlV3YUhzUk1ZWG5NNEJnOUxyNFNidFhuZWdkbmFEellWQW4zZzRydGRibjdySUQxU0Q1bEh2UGJqTSIsIm1hYyI6IjQ2MmIzY2ZlOWNiMTdkNGMxNzE0MmUxOWQ4ZDI3ZTY1NzY3MmZlM2U4N2U3NzIzYjVlNmVhMzhlYmM5MTJmYTQifQ%3D%3D; visit_counter=eyJpdiI6Ino1cUZPY1cybWVTRit2UUJnTmxiMmc9PSIsInZhbHVlIjoiTVJRVXhFN2FGS1k3WXdwZFpmNkZiZCsrUTBHTUxuZHdsekEyVGlFRzViXC9ZbTk2dEh5b2dqRXVsd3N1blVmbTQiLCJtYWMiOiIwMDlkYWIwMGRkMDdkOGE1YThkZGJjZmJkMmRhYTJjZmZhYzc2YWE5ODc0Yzk2ZGI5ZmI3MzFjNGFmM2VlZjIzIn0%3D ◀XSRF-TOKEN=eyJpdiI6InZFT2xrTzN3UkNFNGswM0lqcTVIT0E9PSIsInZhbHVlIjoiTGw5bFNPNmVUMU9HbEVWWVdpelRzbmRjMm9CVTZvOTFOeTlaR2RFcCtiVUdOTTE3bjBSUWxGS21FbXcyR1NXMnZraU1hS ▶"
  "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" => "1473"
  "REMOTE_ADDR" => "18.119.156.220"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/home/forge/staging.skyscrapercenter.xyz/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/city/hanoi/videos"
  "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" => 1744776096.7554
  "REQUEST_TIME" => 1744776096
]
          request_cookies
            0 of 0   
          array:3 [▶
  "XSRF-TOKEN" => "Ju81p7S8HEjHw73IyT9v970HDYwpg173VtBEmqpA"
  "skyscraper_center_session" => "OeX1zTTdWbhpsILtfMekU3umJPgRtWlKbr5JOtjC"
  "visit_counter" => "2"
]
          response_headers
            0 of 0   
          array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 16 Apr 2025 04:01:37 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBKdVZvKzJTUFMrUlVxVnNoSXM0Snc9PSIsInZhbHVlIjoiYXdxeDJvUFR4SE9xWlZBcVRFSzJVV2JCVzNDdzB3U2ZcL0JVeXJxa2J5dldodklLd08xa2taVXVvY1FSSU9CXC9yK2pndFdqRFIxejhRbDl5RFBZMnNTSkdyeDFSV1RcL1A3YlFPNnhERm5vc1ZXYUxvVzR3WFFoUmZORlVwTWVYaVUiLCJtYWMiOiIwNmRhMDI1NTdlNTNkNWE2NTNkZjUwYzk4YjJiMGYzMDI4ZDNiMTkyZTEyOTc3YmRiZjgzYWViZDUyMTkxM2RmIn0%3D; expires=Wed, 16-Apr-2025 06:01:37 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBKdVZvKzJTUFMrUlVxVnNoSXM0Snc9PSIsInZhbHVlIjoiYXdxeDJvUFR4SE9xWlZBcVRFSzJVV2JCVzNDdzB3U2ZcL0JVeXJxa2J5dldodklLd08xa2taVXVvY1FSSU9CXC9yK2pnd ▶"
    1 => "skyscraper_center_session=eyJpdiI6InVrVCtHSHlWYTZ6UFBPZjdIWUlTMUE9PSIsInZhbHVlIjoiM2NnK0VQQ01vTjJFcnEyenVcL3RQWmVSNjdheE81bm1rY0d4eVhXbUJENkJjQTQ3YXlLZWhBcVJIS2pxSVhrM0dXWXViNnk1RWlHK3ZHUVBMT0NtUXVuZzRodlR4TldRRzBPZW9sVXNJQWN2QUJzT1hhenJDYTQ5XC9vZ3c5RmtDbiIsIm1hYyI6ImNhMDFlZDhlYzczODQyNDMwMzAyYWFiOGNjNDBkZmQ4OGUyZGI4Y2Q4NjZhZjM5NGU1OWI1OTUwMTBkZTI5NzgifQ%3D%3D; expires=Wed, 16-Apr-2025 06:01:37 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InVrVCtHSHlWYTZ6UFBPZjdIWUlTMUE9PSIsInZhbHVlIjoiM2NnK0VQQ01vTjJFcnEyenVcL3RQWmVSNjdheE81bm1rY0d4eVhXbUJENkJjQTQ3YXlLZWhBcVJIS2 ▶"
    2 => "visit_counter=eyJpdiI6ImpyU29TRVA5eEczTUFXYW5zMk1USlE9PSIsInZhbHVlIjoiUDhnU25HZ1BnSDl6U3d5QjNHYjZDSEdoY0FhMmh3WkFSMDk0NjBBcElpZHpPQ0dWZjVHTHJJaDNweUFIMGZtRyIsIm1hYyI6IjNhZmJkNjUyYTEyODI3Mzc3OWUyOTcyMDUxNDUyZTI3ZGQzYmY2ZjdiNmQ2NTZkODQ4MDMzYTVkYzUzYzYyZDUifQ%3D%3D; expires=Fri, 16-May-2025 04:01:36 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6ImpyU29TRVA5eEczTUFXYW5zMk1USlE9PSIsInZhbHVlIjoiUDhnU25HZ1BnSDl6U3d5QjNHYjZDSEdoY0FhMmh3WkFSMDk0NjBBcElpZHpPQ0dWZjVHTHJJaDNweUFIMGZtRyIsIm ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlBKdVZvKzJTUFMrUlVxVnNoSXM0Snc9PSIsInZhbHVlIjoiYXdxeDJvUFR4SE9xWlZBcVRFSzJVV2JCVzNDdzB3U2ZcL0JVeXJxa2J5dldodklLd08xa2taVXVvY1FSSU9CXC9yK2pndFdqRFIxejhRbDl5RFBZMnNTSkdyeDFSV1RcL1A3YlFPNnhERm5vc1ZXYUxvVzR3WFFoUmZORlVwTWVYaVUiLCJtYWMiOiIwNmRhMDI1NTdlNTNkNWE2NTNkZjUwYzk4YjJiMGYzMDI4ZDNiMTkyZTEyOTc3YmRiZjgzYWViZDUyMTkxM2RmIn0%3D; expires=Wed, 16-Apr-2025 06:01:37 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBKdVZvKzJTUFMrUlVxVnNoSXM0Snc9PSIsInZhbHVlIjoiYXdxeDJvUFR4SE9xWlZBcVRFSzJVV2JCVzNDdzB3U2ZcL0JVeXJxa2J5dldodklLd08xa2taVXVvY1FSSU9CXC9yK2pnd ▶"
    1 => "skyscraper_center_session=eyJpdiI6InVrVCtHSHlWYTZ6UFBPZjdIWUlTMUE9PSIsInZhbHVlIjoiM2NnK0VQQ01vTjJFcnEyenVcL3RQWmVSNjdheE81bm1rY0d4eVhXbUJENkJjQTQ3YXlLZWhBcVJIS2pxSVhrM0dXWXViNnk1RWlHK3ZHUVBMT0NtUXVuZzRodlR4TldRRzBPZW9sVXNJQWN2QUJzT1hhenJDYTQ5XC9vZ3c5RmtDbiIsIm1hYyI6ImNhMDFlZDhlYzczODQyNDMwMzAyYWFiOGNjNDBkZmQ4OGUyZGI4Y2Q4NjZhZjM5NGU1OWI1OTUwMTBkZTI5NzgifQ%3D%3D; expires=Wed, 16-Apr-2025 06:01:37 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6InVrVCtHSHlWYTZ6UFBPZjdIWUlTMUE9PSIsInZhbHVlIjoiM2NnK0VQQ01vTjJFcnEyenVcL3RQWmVSNjdheE81bm1rY0d4eVhXbUJENkJjQTQ3YXlLZWhBcVJIS2 ▶"
    2 => "visit_counter=eyJpdiI6ImpyU29TRVA5eEczTUFXYW5zMk1USlE9PSIsInZhbHVlIjoiUDhnU25HZ1BnSDl6U3d5QjNHYjZDSEdoY0FhMmh3WkFSMDk0NjBBcElpZHpPQ0dWZjVHTHJJaDNweUFIMGZtRyIsIm1hYyI6IjNhZmJkNjUyYTEyODI3Mzc3OWUyOTcyMDUxNDUyZTI3ZGQzYmY2ZjdiNmQ2NTZkODQ4MDMzYTVkYzUzYzYyZDUifQ%3D%3D; expires=Fri, 16-May-2025 04:01:36 GMT; path=/; httponly ◀visit_counter=eyJpdiI6ImpyU29TRVA5eEczTUFXYW5zMk1USlE9PSIsInZhbHVlIjoiUDhnU25HZ1BnSDl6U3d5QjNHYjZDSEdoY0FhMmh3WkFSMDk0NjBBcElpZHpPQ0dWZjVHTHJJaDNweUFIMGZtRyIsIm ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▶
  "_token" => "Ju81p7S8HEjHw73IyT9v970HDYwpg173VtBEmqpA"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/city/hanoi/videos"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]