CTBUH Silver Member

Coughlin Porter Lundeen

About

Member Since: 2017

Member Offices: Seattle

Website: http://cplinc.com/

More than twenty years ago, Coughlin Porter Lundeen began with the vision to exceed the level of service being provided by other firms in the state of Washington. Our founding principals built the firm on the premise that at the root of every successful project is an unwavering and genuine investment in the design, a vast knowledge base of expertise, and exceptional client service. We consistently exceed the scope of traditional engineers, holistically involving ourselves with all the major building components. Our firm is successful in part because we choose our projects carefully; ones that deliver innovative design solutions that our employees are truly excited about.

Fields of Expertise

Civil Engineering; Seismic Design; Structural Engineering

The Mark, Seattle

Membership details

Membership Level

Silver

Member Since

2017

Member Offices

  • Seattle

Buildings

We use cookies to improve your experience on our website. Review our Privacy Policy for more information.
MessagesTimelineExceptionsViews23RouteQueries44Models131MailsGateSessionRequest
7.3.33PHP Version404msRequest Duration9MBMemory UsageGET company/{id}Route
    • Booting (7.11ms)
    • Application (397ms)
    • 1 x Application (98.22%)
      396.98ms
      1 x Booting (1.76%)
      7.11ms
      23 templates were rendered
      • companies.display-redesign (resources/views/companies/display-redesign.blade.php)32blade
        Params
        0
        tabs
        1
        company
        2
        associatedCompanies
        3
        member
        4
        designatedExperts
        5
        memberLevel
        6
        buildings
        7
        buildingsRaw
        8
        buildings_com_uc
        9
        awards
        10
        statuses
        11
        title
        12
        tallest100
        13
        videos
        14
        research
        15
        news
        16
        forPdf
        17
        timelineYears
        18
        minHeight
        19
        maxHeight
        20
        timelineMinYear
        21
        videoCategories
        22
        initiatives
        23
        people
        24
        tallBuildingCounts
        25
        buildingsByFunction
        26
        buildingsByMaterial
        27
        averageAge
        28
        vanityHeights
        29
        constructionData
        30
        allBuildingStatuses
        31
        accessLevel
      • companies.partials.display-overview (resources/views/companies/partials/display-overview.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • companies.partials.element.displayBuildingImages (resources/views/companies/partials/element/displayBuildingImages.blade.php)44blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.buildingImage (resources/views/companies/partials/element/buildingImage.blade.php)49blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        displayedImg
        45
        __currentLoopData
        46
        building
        47
        loop
        48
        fullSizePath
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)51blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        __currentLoopData
        45
        loop
        46
        filteredBuildings
        47
        header
        48
        tableId
        49
        maxItems
        50
        displayFull
      • companies.partials.element.displayAssociatedCompanies (resources/views/companies/partials/element/displayAssociatedCompanies.blade.php)47blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        memberOffices
        39
        sep
        40
        city
        41
        fieldsArray
        42
        fieldsOfExpertise
        43
        field
        44
        __currentLoopData
        45
        loop
        46
        filteredBuildings
      • www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
        Params
        0
        id
        1
        active
        2
        slot
      • companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)45blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        tableId
        39
        displayComplexTable
        40
        search
        41
        columnFilter
        42
        paginate
        43
        maxItems
        44
        displayFull
      • www.partials.tab-body (resources/views/www/partials/tab-body.blade.php)3blade
        Params
        0
        id
        1
        active
        2
        slot
      • layouts.SSC-tabs (resources/views/layouts/SSC-tabs.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • www.partials.tab-menu (resources/views/www/partials/tab-menu.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • layouts.SSC (resources/views/layouts/SSC.blade.php)38blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
      • common.header (resources/views/common/header.blade.php)40blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)40php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
      • common.algoliaSearch (resources/views/common/algoliaSearch.php)44php
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        nav
        40
        __currentLoopData
        41
        item
        42
        loop
        43
        child
      • common.footer (resources/views/common/footer.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
      • common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)39blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
      • cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        alreadyConsentedWithCookies
        40
        cookieConsentConfig
      • cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)41blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        lucky_50
        5
        tabs
        6
        company
        7
        associatedCompanies
        8
        member
        9
        designatedExperts
        10
        memberLevel
        11
        buildings
        12
        buildingsRaw
        13
        buildings_com_uc
        14
        awards
        15
        statuses
        16
        title
        17
        tallest100
        18
        videos
        19
        research
        20
        news
        21
        forPdf
        22
        timelineYears
        23
        minHeight
        24
        maxHeight
        25
        timelineMinYear
        26
        videoCategories
        27
        initiatives
        28
        people
        29
        tallBuildingCounts
        30
        buildingsByFunction
        31
        buildingsByMaterial
        32
        averageAge
        33
        vanityHeights
        34
        constructionData
        35
        allBuildingStatuses
        36
        accessLevel
        37
        companyWebsite
        38
        data
        39
        alreadyConsentedWithCookies
        40
        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
      44 statements were executed, 11 of which were duplicated, 33 unique348ms
      buldingdb
      • select * from `ctbuh_company` where `ctbuh_company`.`id` = '18621' limit 110.97ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb
        Metadata
        Bindings
        • 0. 18621
        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 = '18621' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name6.2ms/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 = '18621' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name127ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/CtbuhCompany.php:172
        • 11. /app/CtbuhCompany.php:207
        • 12. /app/CtbuhCompany.php:254
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:47
      • SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '18621' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name115ms/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/Http/Controllers/CtbuhCompanyController.php:48
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `id` from `ctbuh_company` where `name` = 'Coughlin Porter Lundeen' and `active` = '1'1.2ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. Coughlin Porter Lundeen
        • 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 (18621, 18621)2.33ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 18621
        • 1. 18621
        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 (9676, 1796, 31916, 22497, 22150) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc1.98ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 9676
        • 3. 1796
        • 4. 31916
        • 5. 22497
        • 6. 22150
        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 (1532, 1680)3.19ms/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.34ms/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.24ms/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 (1796, 9676, 22150, 22497, 31916) order by `position` asc3.09ms/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.38ms/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` = 18621 and `v2_members`.`deleted_at` is null2.18ms/app/CtbuhCompany.php:91buldingdb
        Metadata
        Bindings
        • 0. 18621
        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 `name`, `name_chinese` from `v2_membership_levels` where `id` = 151.25ms/app/Http/Controllers/CtbuhCompanyController.php:181buldingdb
        Metadata
        Bindings
        • 0. 15
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:181
        • 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 * from `v2_awards` where (`building_id` in (1796, 31916, 9676, 22497, 22150) or `company_id` = 18621) and `deleted_at` is null group by `id` order by `year` desc, `type` desc, `display_order` asc2.02ms/app/Http/Controllers/CtbuhCompanyController.php:202buldingdb
        Metadata
        Bindings
        • 0. 1796
        • 1. 31916
        • 2. 9676
        • 3. 22497
        • 4. 22150
        • 5. 18621
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 14. /app/Http/Controllers/CtbuhCompanyController.php:202
        • 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
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
      • select `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12111.29ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1211
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:250
        • 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12111.27ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1211
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:251
        • 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 `ctbuh_company_id` from `v2_ctbuh_company_member` where `member_id` = 12112.23ms/app/Member.php:184buldingdb
        Metadata
        Bindings
        • 0. 1211
        Backtrace
        • 12. /app/Member.php:184
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:260
        • 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 DISTINCT id_building AS building_id FROM ctbuh_building_company WHERE id_building IN( 1796,31916,9676,22497,22150 ) AND id_company_type IN(13, 11) AND id_company IN( 18621 ) UNION DISTINCT SELECT DISTINCT building_id FROM ctbuh_building_company_new WHERE building_id IN( 1796,31916,9676,22497,22150 ) AND category_id IN(1, 2) AND company_id IN( 18621 )2.02ms/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/Http/Controllers/CtbuhCompanyController.php:286
        • 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383
        • 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378
        • 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
      • select `resource_id` from `v2_ctbuh_company_resource` where `ctbuh_company_id` in ('18621')1.2ms/app/Http/Controllers/CtbuhCompanyController.php:306buldingdb
        Metadata
        Bindings
        • 0. 18621
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:306
        • 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 `initiative_id` from `v2_ctbuh_company_initiative` where `ctbuh_company_id` in ('18621')4.06ms/app/Http/Controllers/CtbuhCompanyController.php:311buldingdb
        Metadata
        Bindings
        • 0. 18621
        Backtrace
        • 12. /app/Http/Controllers/CtbuhCompanyController.php:311
        • 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 * from `v2_people` where `v2_people`.`member_id` = 1211 and `v2_people`.`member_id` is not null6.61ms/app/Http/Controllers/CtbuhCompanyController.php:423buldingdb
        Metadata
        Bindings
        • 0. 1211
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 19. /app/Http/Controllers/CtbuhCompanyController.php:423
        • 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 `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 (7365, 12640, 25163, 28756) order by `display_order` asc, `name` asc, `pivot_title` asc, `pivot_year_start` asc5.44ms/app/Http/Controllers/CtbuhCompanyController.php:426buldingdb
        Metadata
        Backtrace
        • 18. /app/Http/Controllers/CtbuhCompanyController.php:426
        • 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 `id` from `ctbuh_company` where `name` = 'Coughlin Porter Lundeen' and `active` = '1'1.64ms/app/CtbuhCompany.php:305buldingdb
        Metadata
        Bindings
        • 0. Coughlin Porter Lundeen
        • 1. 1
        Backtrace
        • 12. /app/CtbuhCompany.php:305
        • 13. /app/CtbuhCompany.php:318
        • 14. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 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 (18621, 18621, 18621)1.3ms/app/CtbuhCompany.php:328buldingdb
        Metadata
        Bindings
        • 0. 18621
        • 1. 18621
        • 2. 18621
        Backtrace
        • 12. /app/CtbuhCompany.php:328
        • 13. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 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 (9676, 1796, 31916, 22497, 22150) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc1.91ms/app/CtbuhCompany.php:336buldingdb
        Metadata
        Bindings
        • 0. 1
        • 1. Renovated
        • 2. 9676
        • 3. 1796
        • 4. 31916
        • 5. 22497
        • 6. 22150
        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:498
        • 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 `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 1796 and `published_at` < '2025-04-18 22:41:20' and `deleted_at` is null and `featured` = 1 order by `published_at` desc1.54ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 1796
        • 1. 2025-04-18 22:41:20
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 31916 and `published_at` < '2025-04-18 22:41:20' and `deleted_at` is null and `featured` = 1 order by `published_at` desc1.58ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 31916
        • 1. 2025-04-18 22:41:20
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 9676 and `published_at` < '2025-04-18 22:41:20' and `deleted_at` is null and `featured` = 1 order by `published_at` desc1.66ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 9676
        • 1. 2025-04-18 22:41:20
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 22497 and `published_at` < '2025-04-18 22:41:20' and `deleted_at` is null and `featured` = 1 order by `published_at` desc7.13ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 22497
        • 1. 2025-04-18 22:41:20
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select `global_news_posts`.*, `building_post`.`building_id` as `pivot_building_id`, `building_post`.`post_id` as `pivot_post_id` from `global_news_posts` inner join `building_post` on `global_news_posts`.`id` = `building_post`.`post_id` where `building_post`.`building_id` = 22150 and `published_at` < '2025-04-18 22:41:20' and `deleted_at` is null and `featured` = 1 order by `published_at` desc1.76ms/vendor/laravel/framework/src/Illuminate/Support/Arr.php:148buldingdb
        Metadata
        Bindings
        • 0. 22150
        • 1. 2025-04-18 22:41:20
        • 2. 1
        Backtrace
        • 19. /vendor/laravel/framework/src/Illuminate/Support/Arr.php:148
        • 20. /vendor/laravel/framework/src/Illuminate/Support/helpers.php:162
        • 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:625
        • 24. /app/Http/Controllers/CtbuhCompanyController.php:498
        • 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT ctbuh_building.id, name_intl, status, (height_architecture - height_floor) AS vanity_height, ((height_architecture - height_floor) / height_architecture) AS vanity_height_pct, floors_above, completed, height_architecture, height_floor FROM ctbuh_building WHERE height_floor != 0 AND completed > 0 AND active = 1 AND structure_type IN('building') AND ctbuh_building.id in (1796, 31916, 9676, 22497, 22150) AND height_architecture > 0 HAVING vanity_height != 0 ORDER BY vanity_height_pct DESC1.56ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261buldingdb
        Metadata
        Hints
        • The != operator is not standard. Use the <> operator to test for inequality instead.
        Backtrace
        • 9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
        • 10. /app/Http/Controllers/CtbuhCompanyController.php:551
        • 11. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383
        • 12. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378
        • 13. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261
      • select * from `v2_people` where `v2_people`.`member_id` = 1211 and `v2_people`.`member_id` is not null and `is_designated_expert` = 11.96ms/app/Member.php:28buldingdb
        Metadata
        Bindings
        • 0. 1211
        • 1. 1
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 15. /app/Member.php:28
        • 16. /app/Http/Controllers/CtbuhCompanyController.php:659
        • 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
      • select `v2_cities`.*, `v2_city_member`.`member_id` as `pivot_member_id`, `v2_city_member`.`city_id` as `pivot_city_id`, `v2_city_member`.`headquarters` as `pivot_headquarters`, `v2_city_member`.`contact` as `pivot_contact` from `v2_cities` inner join `v2_city_member` on `v2_cities`.`id` = `v2_city_member`.`city_id` where `v2_city_member`.`member_id` = 1211 order by `headquarters` desc, `contact` desc, `name` asc1.79msview::companies.partials.display-overview:17buldingdb
        Metadata
        Bindings
        • 0. 1211
        Backtrace
        • 19. view::companies.partials.display-overview:17
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • select `v2_fields`.*, `v2_field_member`.`member_id` as `pivot_member_id`, `v2_field_member`.`field_id` as `pivot_field_id` from `v2_fields` inner join `v2_field_member` on `v2_fields`.`id` = `v2_field_member`.`field_id` where `v2_field_member`.`member_id` = 1211 order by `display_order` asc, `field` asc1.46msview::companies.partials.display-overview:53buldingdb
        Metadata
        Bindings
        • 0. 1211
        Backtrace
        • 19. view::companies.partials.display-overview:53
        • 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
        • 22. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36
        • 23. /vendor/laravel/framework/src/Illuminate/View/View.php:143
        • 24. /vendor/laravel/framework/src/Illuminate/View/View.php:126
      • select * from `nav_menu_items` where `parent_id` is null1.24ms/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.72ms/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.23ms/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.33ms/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.19ms/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.98ms/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` asc5.66ms/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` asc2.08ms/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.6ms/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\Field
      3
      App\Person
      5
      App\Member
      1
      App\Image
      69
      App\Country
      2
      App\City
      3
      App\Building
      10
      App\CtbuhCompany
      1
          _token
          ioTdnvfr1DGjlwuwpQsrILfX9IVQvfy2M6fogm3i
          _previous
          array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/18621" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /company/18621
          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" => "53347"
  "REMOTE_ADDR" => "18.119.139.161"
  "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/18621"
  "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" => 1745016079.9443
  "REQUEST_TIME" => 1745016079
]
          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 22:41:20 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlUrTmRmME03UVJQTjgwdW9aUExJVkE9PSIsInZhbHVlIjoiRUVQQkNzNjJqaE01bGlsK0F0czJ3cDZvRUZYNjdNS3RxSDdjbnVyNTRiMlQrZG9EcmVlUXRtUFwveTNPRTBhSHdNV0xMb1lOSGthR2JCZU5MQXRiOEZNXC9VSnU4V0xEYW1QaCtrSnlKRFJwNkJZcnQ2anN6SnJ4TWlJQUNndEZwcCIsIm1hYyI6IjdhNGIyZThlZGM3ZjQ0MGQ2ZDMwNzg0YjlkZjJlOGJlOTMyM2M4OWU4YzYzMzVlNjI4Njg5MmI1NWY2ZDhhYWQifQ%3D%3D; expires=Sat, 19-Apr-2025 00:41:20 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlUrTmRmME03UVJQTjgwdW9aUExJVkE9PSIsInZhbHVlIjoiRUVQQkNzNjJqaE01bGlsK0F0czJ3cDZvRUZYNjdNS3RxSDdjbnVyNTRiMlQrZG9EcmVlUXRtUFwveTNPRTBhSHdNV0xMb ▶"
    1 => "skyscraper_center_session=eyJpdiI6IndOWG5iMHZTVEdhdEU2cklKZ0FKQWc9PSIsInZhbHVlIjoibFZncjNhbkUrSlIzWG9vNjl4TkpcL3lwcVQyaW1tUzJteE0xQkNFWUR2Z2FSbllUUzJwZ25SZkNzV25wV1FIQ0E5RzlFVlpsTk5oc3hxQXBBd3RkcVJBQjM5YlNsZzQ0N1lDU2hEVytxNGRVa1lmREFEaUtpQjVSSWxPK0k1RVwvUSIsIm1hYyI6IjE5ZjZmNzEyZmQ5YjNkZjEwY2JiZDI5ODVjZTNlYWM2MmFkOTUwMGJjMzkwZmVlZTk0N2JlOTRlZjQ1NTM0MDcifQ%3D%3D; expires=Sat, 19-Apr-2025 00:41:20 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IndOWG5iMHZTVEdhdEU2cklKZ0FKQWc9PSIsInZhbHVlIjoibFZncjNhbkUrSlIzWG9vNjl4TkpcL3lwcVQyaW1tUzJteE0xQkNFWUR2Z2FSbllUUzJwZ25SZkNzV2 ▶"
    2 => "visit_counter=eyJpdiI6IkphZkxkNk5BcndqdllBbzN4OGhibWc9PSIsInZhbHVlIjoiUE5tR1Y1aHpCd29cL1lrM1pGR2loN2dsZndYbUdjY2RqRTRnNTB1UnVFMlJDN2wyTzFvTE9GNDRWTDQ0amo2bjgiLCJtYWMiOiJlMDVhNDlkNGJmNWVjYzRiZDk1MDExNWM5YmVkODdlNTY5MjAxZmQzMTM4NTMzZjBmNGJiMjk1ZTQyNDExZjhkIn0%3D; expires=Sun, 18-May-2025 22:41:19 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IkphZkxkNk5BcndqdllBbzN4OGhibWc9PSIsInZhbHVlIjoiUE5tR1Y1aHpCd29cL1lrM1pGR2loN2dsZndYbUdjY2RqRTRnNTB1UnVFMlJDN2wyTzFvTE9GNDRWTDQ0amo2bjgiLC ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlUrTmRmME03UVJQTjgwdW9aUExJVkE9PSIsInZhbHVlIjoiRUVQQkNzNjJqaE01bGlsK0F0czJ3cDZvRUZYNjdNS3RxSDdjbnVyNTRiMlQrZG9EcmVlUXRtUFwveTNPRTBhSHdNV0xMb1lOSGthR2JCZU5MQXRiOEZNXC9VSnU4V0xEYW1QaCtrSnlKRFJwNkJZcnQ2anN6SnJ4TWlJQUNndEZwcCIsIm1hYyI6IjdhNGIyZThlZGM3ZjQ0MGQ2ZDMwNzg0YjlkZjJlOGJlOTMyM2M4OWU4YzYzMzVlNjI4Njg5MmI1NWY2ZDhhYWQifQ%3D%3D; expires=Sat, 19-Apr-2025 00:41:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlUrTmRmME03UVJQTjgwdW9aUExJVkE9PSIsInZhbHVlIjoiRUVQQkNzNjJqaE01bGlsK0F0czJ3cDZvRUZYNjdNS3RxSDdjbnVyNTRiMlQrZG9EcmVlUXRtUFwveTNPRTBhSHdNV0xMb ▶"
    1 => "skyscraper_center_session=eyJpdiI6IndOWG5iMHZTVEdhdEU2cklKZ0FKQWc9PSIsInZhbHVlIjoibFZncjNhbkUrSlIzWG9vNjl4TkpcL3lwcVQyaW1tUzJteE0xQkNFWUR2Z2FSbllUUzJwZ25SZkNzV25wV1FIQ0E5RzlFVlpsTk5oc3hxQXBBd3RkcVJBQjM5YlNsZzQ0N1lDU2hEVytxNGRVa1lmREFEaUtpQjVSSWxPK0k1RVwvUSIsIm1hYyI6IjE5ZjZmNzEyZmQ5YjNkZjEwY2JiZDI5ODVjZTNlYWM2MmFkOTUwMGJjMzkwZmVlZTk0N2JlOTRlZjQ1NTM0MDcifQ%3D%3D; expires=Sat, 19-Apr-2025 00:41:20 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6IndOWG5iMHZTVEdhdEU2cklKZ0FKQWc9PSIsInZhbHVlIjoibFZncjNhbkUrSlIzWG9vNjl4TkpcL3lwcVQyaW1tUzJteE0xQkNFWUR2Z2FSbllUUzJwZ25SZkNzV2 ▶"
    2 => "visit_counter=eyJpdiI6IkphZkxkNk5BcndqdllBbzN4OGhibWc9PSIsInZhbHVlIjoiUE5tR1Y1aHpCd29cL1lrM1pGR2loN2dsZndYbUdjY2RqRTRnNTB1UnVFMlJDN2wyTzFvTE9GNDRWTDQ0amo2bjgiLCJtYWMiOiJlMDVhNDlkNGJmNWVjYzRiZDk1MDExNWM5YmVkODdlNTY5MjAxZmQzMTM4NTMzZjBmNGJiMjk1ZTQyNDExZjhkIn0%3D; expires=Sun, 18-May-2025 22:41:19 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IkphZkxkNk5BcndqdllBbzN4OGhibWc9PSIsInZhbHVlIjoiUE5tR1Y1aHpCd29cL1lrM1pGR2loN2dsZndYbUdjY2RqRTRnNTB1UnVFMlJDN2wyTzFvTE9GNDRWTDQ0amo2bjgiLC ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▶
  "_token" => "ioTdnvfr1DGjlwuwpQsrILfX9IVQvfy2M6fogm3i"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/company/18621"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]