Gold Coast

Australia

01 February 2018

The Global Tall Building Picture: Impact of 2017

CTBUH Staff, CTBUH

In 2017, 144 buildings of 200 meters’ height or greater were completed. This is the fourth record-breaking year in a row, and it brings the...

16 October 2005

Two Examples of Urban Renewal: Melbourne and Coolangatta, Australia

Omiros Emmanouilides, Omiros One Architecture

The proposed paper will examine and compare two recent and totally different examples of urban renewal in these two Australian cities. The area to be...

7.3.33PHP Version583msRequest Duration13MBMemory UsageGET city/{slug}/researchRoute
    • Booting (7ms)
    • Application (576ms)
    • 1 x Application (98.79%)
      576.42ms
      1 x Booting (1.2%)
      7.00ms
      18 templates were rendered
      • cities.tabs.research (resources/views/cities/tabs/research.blade.php)5blade
        Params
        0
        geo
        1
        title
        2
        research
        3
        tabsData
        4
        accessLevel
      • buildings.partials.research (resources/views/buildings/partials/research.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
      • buildings.partials.elements.research-list (resources/views/buildings/partials/elements/research-list.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
        12
        __currentLoopData
        13
        paper
        14
        index
        15
        loop
      • buildings.partials.elements.research-list (resources/views/buildings/partials/elements/research-list.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
        12
        __currentLoopData
        13
        paper
        14
        index
        15
        loop
      • buildings.partials.elements.research-grid (resources/views/buildings/partials/elements/research-grid.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
        12
        __currentLoopData
        13
        paper
        14
        index
        15
        loop
      • buildings.partials.elements.research-grid (resources/views/buildings/partials/elements/research-grid.blade.php)16blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
        12
        __currentLoopData
        13
        paper
        14
        index
        15
        loop
      • buildings.partials.elements.pagination (resources/views/buildings/partials/elements/pagination.blade.php)18blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        papers
        12
        __currentLoopData
        13
        paper
        14
        index
        15
        loop
        16
        entities
        17
        elementsToShow
      • cities.layout (resources/views/cities/layout.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
      • cities.partials.mobile-nav (resources/views/cities/partials/mobile-nav.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
      • layouts.SSC (resources/views/layouts/SSC.blade.php)11blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
      • common.header (resources/views/common/header.blade.php)13blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
        12
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)13php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
        12
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)17php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
        12
        nav
        13
        __currentLoopData
        14
        item
        15
        loop
        16
        child
      • common.footer (resources/views/common/footer.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)12blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
        12
        alreadyConsentedWithCookies
        13
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)14blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        dateFormats
        6
        geo
        7
        title
        8
        research
        9
        tabsData
        10
        accessLevel
        11
        data
        12
        alreadyConsentedWithCookies
        13
        cookieConsentConfig
      uri
      GET city/{slug}/research
      middleware
      web
      controller
      App\Http\Controllers\CityController@research
      namespace
      App\Http\Controllers
      prefix
      where
      as
      city-research
      file
      app/Http/Controllers/CityController.php:696-721
      32 statements were executed, 6 of which were duplicated, 26 unique481ms
      • select * from `v2_cities` where `slug` = 'gold-coast' limit 126.05ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Bindings
        • 0. gold-coast
        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:706
        • 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 (11)1.76ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:706
        • 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 (8)3.23ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:706
        • 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 (655) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc397ms/app/Http/Controllers/CityController.php:706buldingdb
        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:706
        • 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 (655)1.37ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 26. /app/Http/Controllers/CityController.php:706
        • 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 (655) order by `start_date` desc2.39ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:706
        • 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 (648, 653, 1539)1.38ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:706
        • 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 (655) order by `type` asc, `date` desc1.94ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Backtrace
        • 20. /app/Http/Controllers/CityController.php:706
        • 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 (655)1.85ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 21. /app/Http/Controllers/CityController.php:706
        • 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 (6671, 6799, 7140, 7227) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc1.48ms/app/Http/Controllers/CityController.php:706buldingdb
        Metadata
        Backtrace
        • 25. /app/Http/Controllers/CityController.php:706
        • 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` = 655 and `level` > 0 and `v2_members`.`deleted_at` is null order by `level` asc, `name` asc1.89ms/app/Http/Controllers/CityController.php:756buldingdb
        Metadata
        Bindings
        • 0. 655
        • 1. 0
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:756
        • 20. /app/Http/Controllers/CityController.php:708
        • 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` = 132 and `ctbuh_company`.`deleted_at` is null2.28ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 132
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:708
        • 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` = 89 and `ctbuh_company`.`deleted_at` is null1.82ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 89
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:708
        • 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` = 619 and `ctbuh_company`.`deleted_at` is null2.08ms/app/Http/Controllers/CityController.php:763buldingdb
        Metadata
        Bindings
        • 0. 619
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:763
        • 20. /app/Http/Controllers/CityController.php:708
        • 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.21ms/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:708
        • 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_categories` where `type` = 'Video' and `id` = 5 limit 11.49ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        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:817
        • 14. /app/Http/Controllers/CityController.php:708
        • 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 * from `v2_resource_categories` where `type` = 'Video'1.26ms/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:708
        • 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_categories` where `type` = 'Video' and `id` = 5 limit 12.13ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        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:817
        • 14. /app/Http/Controllers/CityController.php:708
        • 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 * from `v2_resource_categories` where `type` = 'Video'1.84ms/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:708
        • 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_categories` where `type` = 'Video' and `id` = 5 limit 14.89ms/app/Http/Controllers/CityController.php:817buldingdb
        Metadata
        Bindings
        • 0. Video
        • 1. 5
        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:817
        • 14. /app/Http/Controllers/CityController.php:708
        • 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` = 655 order by `pivot_year_end` asc, `display_order` asc, `title` asc, `last_name` asc1.9ms/app/Http/Controllers/CityController.php:896buldingdb
        Metadata
        Bindings
        • 0. 655
        Backtrace
        • 19. /app/Http/Controllers/CityController.php:896
        • 20. /app/Http/Controllers/CityController.php:708
        • 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` = 655 and `global_news_posts`.`city_id` is not null and `published_at` < '2025-04-22 04:25:18' and `deleted_at` is null order by `published_at` desc1.53ms/app/Http/Controllers/CityController.php:904buldingdb
        Metadata
        Bindings
        • 0. 655
        • 1. 2025-04-22 04:25:18
        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:708
        • 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` = 11 limit 11.5ms/app/Http/Controllers/Controller.php:423buldingdb
        Metadata
        Bindings
        • 0. 11
        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:708
        • 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.85ms/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.86ms/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 13.31ms/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.37ms/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.18ms/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.47ms/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.52ms/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.44ms/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.65ms/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
      3
      App\Person
      4
      App\Initiative
      3
      App\Building
      214
      App\Region
      1
      App\Country
      2
      App\City
      5
          _token
          4yg2DFiNQiNBp9Kwiy02Q7wzQdDCpLQ1goodzLtU
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/gold-coast/research" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /city/gold-coast/research
          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" => "5525" "REMOTE_ADDR" => "3.147.76.86" "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/gold-coast/research" "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" => 1745295917.749 "REQUEST_TIME" => 1745295917 ]
          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 => "Tue, 22 Apr 2025 04:25:18 GMT" ] "set-cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImNaNmJaajdFXC96XC8zNzhxYWZ5bTZ5UT09IiwidmFsdWUiOiI3K3l2WVcybkFDTFZOXC94dlwvOXFTeHZpSmpZMzVwMVNGVWUra1FyTnZOU3c1YlJ3c0dYMnFjVnRXTGlyK1hTMjl1ZmNSWld5TUpqNVQ5RUdiZ1pYNWtFREtXTlNQTkVGV2ExK0RpR21GYlVTUzd5YmtuTUVJNTJCdjV4RXU5ZkgrIiwibWFjIjoiOTYzZDgxNzc3ZDM4NDg1ZTM3NWIyZTFkNTgxMTI2MDkxYzk3MmUxYzdmZmRmYTMxODRkMmYyMWZlNmEyZDRkOSJ9; expires=Tue, 22-Apr-2025 06:25:18 GMT; Max-Age=7200; path=/XSRF-TOKEN=eyJpdiI6ImNaNmJaajdFXC96XC8zNzhxYWZ5bTZ5UT09IiwidmFsdWUiOiI3K3l2WVcybkFDTFZOXC94dlwvOXFTeHZpSmpZMzVwMVNGVWUra1FyTnZOU3c1YlJ3c0dYMnFjVnRXTGlyK1hTMjl1Z" 1 => "skyscraper_center_session=eyJpdiI6Imptd0pjOHRBdXFUcVBVV1BNa1BWT0E9PSIsInZhbHVlIjoiM01ra1dtS1Q2STVkQ285VkpNMTdhOUxWeER0QzQ5ajdCVSs4QkxCS2Zia2szNklwV293d205TzljRWpoenltZlNDODVZbENJU0g5dWhCVjFDVld1SUVINTVHTFZhQ3k1UHVFc3N2cDlxSmo2enRkcUx1aHI0aTJITExrK2tkekkiLCJtYWMiOiI3YTgyODk3NWVhMjEzNWE5OGNjY2M1ZjAyZmY4ZGFhNzMyYmIwNGIzOWE0OGRhZDYzYmIzMzdjM2Q3ZmI5MWJhIn0%3D; expires=Tue, 22-Apr-2025 06:25:18 GMT; Max-Age=7200; path=/; httponlyskyscraper_center_session=eyJpdiI6Imptd0pjOHRBdXFUcVBVV1BNa1BWT0E9PSIsInZhbHVlIjoiM01ra1dtS1Q2STVkQ285VkpNMTdhOUxWeER0QzQ5ajdCVSs4QkxCS2Zia2szNklwV293d205TzljRW" 2 => "visit_counter=eyJpdiI6ImtuY0lcL015S0NDM2tYbzJ4N0pEYldBPT0iLCJ2YWx1ZSI6ImR6d1RyZ0NjNlVtenpkR05oRHBCM2VSdkhFVlNjdmVtNWFqcWNnVUhxQjFPd3U2S3hsamVkM2JKM2ZDbkVKMkoiLCJtYWMiOiI4OTRlYTc5N2ViYWU3OGVlYjJhMDY5ZGY1Y2Q5N2JlNGYyMzIyMGNmNzFhYjI0OTJiNDZiNjIzNjY5ODU1ZjRhIn0%3D; expires=Thu, 22-May-2025 04:25:17 GMT; Max-Age=2591999; path=/; httponlyvisit_counter=eyJpdiI6ImtuY0lcL015S0NDM2tYbzJ4N0pEYldBPT0iLCJ2YWx1ZSI6ImR6d1RyZ0NjNlVtenpkR05oRHBCM2VSdkhFVlNjdmVtNWFqcWNnVUhxQjFPd3U2S3hsamVkM2JKM2ZDbkVKMkoiLC" ] "Set-Cookie" => array:3 [ 0 => "XSRF-TOKEN=eyJpdiI6ImNaNmJaajdFXC96XC8zNzhxYWZ5bTZ5UT09IiwidmFsdWUiOiI3K3l2WVcybkFDTFZOXC94dlwvOXFTeHZpSmpZMzVwMVNGVWUra1FyTnZOU3c1YlJ3c0dYMnFjVnRXTGlyK1hTMjl1ZmNSWld5TUpqNVQ5RUdiZ1pYNWtFREtXTlNQTkVGV2ExK0RpR21GYlVTUzd5YmtuTUVJNTJCdjV4RXU5ZkgrIiwibWFjIjoiOTYzZDgxNzc3ZDM4NDg1ZTM3NWIyZTFkNTgxMTI2MDkxYzk3MmUxYzdmZmRmYTMxODRkMmYyMWZlNmEyZDRkOSJ9; expires=Tue, 22-Apr-2025 06:25:18 GMT; path=/XSRF-TOKEN=eyJpdiI6ImNaNmJaajdFXC96XC8zNzhxYWZ5bTZ5UT09IiwidmFsdWUiOiI3K3l2WVcybkFDTFZOXC94dlwvOXFTeHZpSmpZMzVwMVNGVWUra1FyTnZOU3c1YlJ3c0dYMnFjVnRXTGlyK1hTMjl1Z" 1 => "skyscraper_center_session=eyJpdiI6Imptd0pjOHRBdXFUcVBVV1BNa1BWT0E9PSIsInZhbHVlIjoiM01ra1dtS1Q2STVkQ285VkpNMTdhOUxWeER0QzQ5ajdCVSs4QkxCS2Zia2szNklwV293d205TzljRWpoenltZlNDODVZbENJU0g5dWhCVjFDVld1SUVINTVHTFZhQ3k1UHVFc3N2cDlxSmo2enRkcUx1aHI0aTJITExrK2tkekkiLCJtYWMiOiI3YTgyODk3NWVhMjEzNWE5OGNjY2M1ZjAyZmY4ZGFhNzMyYmIwNGIzOWE0OGRhZDYzYmIzMzdjM2Q3ZmI5MWJhIn0%3D; expires=Tue, 22-Apr-2025 06:25:18 GMT; path=/; httponlyskyscraper_center_session=eyJpdiI6Imptd0pjOHRBdXFUcVBVV1BNa1BWT0E9PSIsInZhbHVlIjoiM01ra1dtS1Q2STVkQ285VkpNMTdhOUxWeER0QzQ5ajdCVSs4QkxCS2Zia2szNklwV293d205TzljRW" 2 => "visit_counter=eyJpdiI6ImtuY0lcL015S0NDM2tYbzJ4N0pEYldBPT0iLCJ2YWx1ZSI6ImR6d1RyZ0NjNlVtenpkR05oRHBCM2VSdkhFVlNjdmVtNWFqcWNnVUhxQjFPd3U2S3hsamVkM2JKM2ZDbkVKMkoiLCJtYWMiOiI4OTRlYTc5N2ViYWU3OGVlYjJhMDY5ZGY1Y2Q5N2JlNGYyMzIyMGNmNzFhYjI0OTJiNDZiNjIzNjY5ODU1ZjRhIn0%3D; expires=Thu, 22-May-2025 04:25:17 GMT; path=/; httponlyvisit_counter=eyJpdiI6ImtuY0lcL015S0NDM2tYbzJ4N0pEYldBPT0iLCJ2YWx1ZSI6ImR6d1RyZ0NjNlVtenpkR05oRHBCM2VSdkhFVlNjdmVtNWFqcWNnVUhxQjFPd3U2S3hsamVkM2JKM2ZDbkVKMkoiLC" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "4yg2DFiNQiNBp9Kwiy02Q7wzQdDCpLQ1goodzLtU" "_previous" => array:1 [ "url" => "https://staging.skyscrapercenter.xyz/city/gold-coast/research" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]