TFP Farrells

Farrells is a member of the CTBUH at the Silver level.

Renamed to:

Farrells

Buildings

Rank	Name	City	Completion	Height
1	Kingkey Jingdou	Shenzhen	-	600 m / 1,969 ft
2	Landmark Tower	Hong Kong	-	580 m / 1,903 ft
3	CITIC Tower	Beijing	2018	528 m / 1,731 ft
4	Jinan IFC Landmark Tower	Jinan	-	518 m / 1,699 ft
5	KK100	Shenzhen	2011	442 m / 1,449 ft
6	Z8	Beijing	-	330 m / 1,083 ft
7	Nanshan Business & Cultural Centre	Shenzhen	-	308 m / 1,010 ft
8	One Excellence Tower 1	Shenzhen	2019	284 m / 931 ft
9	Beijing Guanghuali Masterplan Tower 3	Beijing	-	280 m / 919 ft
9	Beijing Guanghuali Masterplan Tower 4	Beijing	-	280 m / 919 ft
11	Centralcon Special Zone Daily	Shenzhen	-	250 m / 820 ft
12	Wuxi TV Tower	Wuxi	-	240 m / 787 ft
13	Beijing Guanghuali Masterplan Tower 1	Beijing	-	230 m / 755 ft
13	Beijing Guanghuali Masterplan Tower 6	Beijing	-	230 m / 755 ft
15	One Excellence Tower 3	Shenzhen	2019	200 m / 658 ft
16	Centralcon Group Tower	Shenzhen	2016	200 m / 656 ft
17	Zhuhai Hengqin Landmark Commercial Complex - Tower B	Zhuhai	-	200 m / 656 ft
18	BEA Financial Tower	Shanghai	2009	198 m / 649 ft
19	Walton Plaza	Shanghai	2004	196 m / 643 ft
20	Noble Tower	Shenzhen	2005	193 m / 634 ft
21	Vattanac Capital	Phnom Penh	2014	185 m / 606 ft
22	Beijing Guanghuali Masterplan Tower 2	Beijing	-	180 m / 591 ft
22	Beijing Guanghuali Masterplan Tower 5	Beijing	-	180 m / 591 ft
24	One Excellence Tower 7	Shenzhen	2018	178 m / 585 ft
24	One Excellence Tower 8	Shenzhen	2018	178 m / 585 ft
26	Hengqin Zhuhai Landmark Commercial Complex - Tower A	Zhuhai	-	170 m / 558 ft
27	Shangri-La Wind Valley Wing Hotel	Ulaanbaatar	2016	120 m / 394 ft
28	Shangri-La Office Tower	Ulaanbaatar	2016	120 m / 394 ft
29	Emperor Group Centre	Beijing	2016	120 m / 394 ft
30	Art Tamani Offices	Dubai	-	100 m / 328 ft
31	2E31 Shanghai Shipyard (Pudong) (Tower 2)	Shanghai	2016	100 m / 328 ft
32	One Excellence Tower 4	Shenzhen	2018	96 m / 315 ft
33	M+	Hong Kong	2020	94 m / 310 ft
34	China National Petroleum Corporation Headquarters	Beijing	2007	90 m / 295 ft
35	2E31 Shanghai Shipyard (Pudong) (Tower 1)	Shanghai	2016	50 m / 164 ft
36	Convoy`s Wharf Tower 1	London	-	- m / - ft
37	Bishopsgate Goodsyard Tower G	London	2021	- m / - ft
38	Convoy`s Wharf Tower 2	London	-	- m / - ft
39	Bishopsgate Goodsyard Tower C1	London	2021	- m / - ft
40	Bishopsgate Goodsyard Tower C2	London	2021	- m / - ft
40	Convoy`s Wharf Tower 3	London	-	- m / - ft
42	Xiamen Cross Strait Financial Centre 1	Xiamen	-	- m / - ft
42	Xiamen Cross Strait Financial Centre 2	Xiamen	-	- m / - ft
42	Xiamen Cross Strait Financial Centre 3	Xiamen	-	- m / - ft

Buildings per page:

Messages Timeline Exceptions Views12 Route Queries27 Models315 Mails Gate Session Request

7.3.33392ms9MBGET company/{id}

Booting (11.1ms)
Application (381ms)
1 x Application (97.14%)
380.69ms
1 x Booting (2.83%)
11.10ms

12 templates were rendered

companies.partials.display-non-member (resources/views/companies/partials/display-non-member.blade.php)8blade
Params
0
company
1
parentMember
2
associatedCompanies
3
buildings
4
statuses
5
title
6
allBuildingStatuses
7
accessLevel

Params
0	`company`
1	`parentMember`
2	`associatedCompanies`
3	`buildings`
4	`statuses`
5	`title`
6	`allBuildingStatuses`
7	`accessLevel`

companies.partials.element.nonMemberItems (resources/views/companies/partials/element/nonMemberItems.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

companies.partials.element.displayBuildingsTable (resources/views/companies/partials/element/displayBuildingsTable.blade.php)23blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
tableId
paginate
search
displayComplexTable
maxItems
displayFull

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`tableId`
18	`paginate`
19	`search`
20	`displayComplexTable`
21	`maxItems`
22	`displayFull`

layouts.SSC-standard (resources/views/layouts/SSC-standard.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

layouts.SSC (resources/views/layouts/SSC.blade.php)17blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`

common.header (resources/views/common/header.blade.php)19blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)19php


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`

common.algoliaSearch (resources/views/common/algoliaSearch.php)21php


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
nav
item
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`nav`
19	`item`
20	`child`

common.footer (resources/views/common/footer.blade.php)18blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

common.footer-call-to-subscribe (resources/views/common/footer-call-to-subscribe.blade.php)18blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`

cookieConsent::index (vendor/spatie/laravel-cookie-consent/resources/views/index.blade.php)20blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

cookieConsent::dialogContents (vendor/spatie/laravel-cookie-consent/resources/views/dialogContents.blade.php)20blade


obLevel
__env
app
errors
lucky_50
company
parentMember
associatedCompanies
buildings
statuses
title
allBuildingStatuses
accessLevel
__currentLoopData
companies
key
loop
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`company`
6	`parentMember`
7	`associatedCompanies`
8	`buildings`
9	`statuses`
10	`title`
11	`allBuildingStatuses`
12	`accessLevel`
13	`__currentLoopData`
14	`companies`
15	`key`
16	`loop`
17	`data`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

uri: GET company/{id}
middleware: web
controller: App\Http\Controllers\CtbuhCompanyController@display
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/CtbuhCompanyController.php:27-708

27 statements were executed, 6 of which were duplicated, 21 unique324ms

select * from `ctbuh_company` where `ctbuh_company`.`id` = '381' limit 120.54ms/app/Http/Controllers/CtbuhCompanyController.php:33buldingdb

Metadata
Bindings	0. 381
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 = '381' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name

1.7ms/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 * from `ctbuh_company` where `ctbuh_company`.`id` = 6995 and `ctbuh_company`.`deleted_at` is null limit 11.44ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23buldingdb

Metadata
Bindings	0. 6995
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 18. /app/CtbuhCompany.php:142 19. /app/CtbuhCompany.php:223 20. /app/Http/Controllers/CtbuhCompanyController.php:47 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

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 = '6995' AND c2.name IS NOT NULL AND c2.active = '1' ORDER BY c1.status, c2.name

1.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:143 12. /app/CtbuhCompany.php:223 13. /app/Http/Controllers/CtbuhCompanyController.php:47

SELECT id, name, status, new_company, new_company_year FROM ctbuh_company WHERE new_company = '381' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

125ms/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 = '381' AND status IN('renamed', 'merged', 'subsidiary') AND active = '1' ORDER BY status, name

101ms/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` = 'TFP Farrells' and `active` = '1'3.85ms/app/CtbuhCompany.php:305buldingdb

Metadata
Bindings	0. TFP Farrells 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 (381, 381)2.51ms/app/CtbuhCompany.php:328buldingdb

Metadata
Bindings	0. 381 1. 381
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 (16536, 16535, 16534, 17600, 18105, 18115, 18116, 18853, 18843, 18865, 18884, 18883, 18825, 18852, 18928, 19108, 19109, 19110, 19111, 19112, 19113, 15025, 19402, 9239, 1877, 22442, 22443, 22444, 23031, 25838, 25980, 14900, 18114, 16309, 16311, 17601, 18882, 18824, 8813, 173, 1821, 18857, 20029, 17436, 17437, 11116) and `ctbuh_building`.`deleted_at` is null order by `height_architecture` desc, `floors_above` desc, `name_intl` asc

4.25ms/app/CtbuhCompany.php:336buldingdb

Metadata
Bindings	0. 1 1. Renovated 2. 16536 3. 16535 4. 16534 5. 17600 6. 18105 7. 18115 8. 18116 9. 18853 10. 18843 11. 18865 12. 18884 13. 18883 14. 18825 15. 18852 16. 18928 17. 19108 18. 19109 19. 19110 20. 19111 21. 19112 22. 19113 23. 15025 24. 19402 25. 9239 26. 1877 27. 22442 28. 22443 29. 22444 30. 23031 31. 25838 32. 25980 33. 14900 34. 18114 35. 16309 36. 16311 37. 17601 38. 18882 39. 18824 40. 8813 41. 173 42. 1821 43. 18857 44. 20029 45. 17436 46. 17437 47. 11116
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 (630, 745, 766, 795, 803, 805, 814, 815, 829, 942, 1054, 1101)2.83ms/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 (2, 34, 56, 84, 105)1.52ms/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 (2, 34, 56, 84, 105)1.39ms/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 (173, 1821, 1877, 8813, 9239, 11116, 14900, 15025, 16309, 16311, 16534, 16535, 16536, 17436, 17437, 17601, 18105, 18114, 18115, 18116, 18824, 18825, 18843, 18852, 18853, 18857, 18865, 18882, 18883, 18884, 18928, 19108, 19109, 19110, 19111, 19112, 19113, 19402, 20029, 22442, 22443, 22444, 25838, 25980) order by `position` asc

3.66ms/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.33ms/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` = 381 and `v2_members`.`deleted_at` is null

4.66ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 381
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/Http/Controllers/CtbuhCompanyController.php:172 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219

select * from `ctbuh_company` where `ctbuh_company`.`id` = 6995 and `ctbuh_company`.`deleted_at` is null limit 16.83ms/app/CtbuhCompany.php:287buldingdb

Metadata
Bindings	0. 6995
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/CtbuhCompany.php:287 21. /app/Http/Controllers/CtbuhCompanyController.php:696 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

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` = 6995 and `v2_members`.`deleted_at` is null

7.36ms/app/CtbuhCompany.php:91buldingdb

Metadata
Bindings	0. 6995
Backtrace	19. /app/CtbuhCompany.php:91 20. /app/CtbuhCompany.php:96 21. /app/CtbuhCompany.php:288 22. /app/Http/Controllers/CtbuhCompanyController.php:696 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

select * from `v2_membership_levels` where `v2_membership_levels`.`id` = 15 limit 16.38msview::companies.partials.display-non-member:14buldingdb

Metadata
Bindings	0. 15
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. view::companies.partials.display-non-member:14 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36 24. /vendor/laravel/framework/src/Illuminate/View/View.php:143 25. /vendor/laravel/framework/src/Illuminate/View/View.php:126

select * from `nav_menu_items` where `parent_id` is null2.35ms/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` asc

3.83ms/app/NavMenuItem.php:110buldingdb

Metadata
Bindings	0. 27
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/NavMenuItem.php:110 20. /app/NavMenuItem.php:115 21. view::common.header:85 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:36

select * from `pages` where `pages`.`id` = 88 limit 12.91ms/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` asc

6.54ms/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` asc

6.1ms/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` asc

1.72ms/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` asc

1.33ms/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` asc

1.42ms/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` asc

1.3ms/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\MembershipLevel: 1
App\Member: 2
App\Image: 206
App\Country: 10
App\City: 12
App\Building: 44
App\CtbuhCompany: 3

_token: YQ0trf9UEbI8wFXhfjxhFpoo66s0NMWbXQ98l3pC
_previous: array:1 [ "url" => "https://staging.skyscrapercenter.xyz/company/381" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/company/381

status_code

status_text

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" => "11890"
  "REMOTE_ADDR" => "3.142.53.80"
  "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/381"
  "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" => 1744506869.6939
  "REQUEST_TIME" => 1744506869
]

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 => "Sun, 13 Apr 2025 01:14:30 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlQ4QzlQbTQyaTJlVm9kY1dRMFVqeFE9PSIsInZhbHVlIjoiK3FTNlwvZm0yTmpwcTFoQjhMQVhsQ29PS1licE5ub2dSQXFTUU9PdjlRTzR1Q0pRQ0xHOCtMbDZaNmlGMjRaemZpQ0gybk1yZXkrbE9sZmRQSlJGZmJLQnZpWnV1YzR1aDJ6NllOYkQ2Z0FYYzZFeXpobSt5eG8yZmV5Q0Fuak53IiwibWFjIjoiYmU1YmFhMDRjY2IxNzA5ZTZmN2MwNjA1ZGYzMTY1YjUxYzA2YmU0NWZiNjMyNDY3MTU2NDhiMjNjNWNkOTI1MCJ9; expires=Sun, 13-Apr-2025 03:14:30 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlQ4QzlQbTQyaTJlVm9kY1dRMFVqeFE9PSIsInZhbHVlIjoiK3FTNlwvZm0yTmpwcTFoQjhMQVhsQ29PS1licE5ub2dSQXFTUU9PdjlRTzR1Q0pRQ0xHOCtMbDZaNmlGMjRaemZpQ0gyb ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImlzYVU4aTZXRVpmNXkwRFhMbUlOc2c9PSIsInZhbHVlIjoiUHpQNFRlTHBmNENmM2haQlZRRWJwUzFwcXNTaXZmN25YYWRManVKdGljRUgyaktzTGoxT0hSREQ0dDFoSWNYNnBnallqXC9PMUVuOFoyWUQ2M1NkcjI0MGJHSEl1N2ZlK2FlNURwZ2o4VCtyb2F2RlNqamZNc3E3TEJwZGlsdGtQIiwibWFjIjoiMzk5ZGY5MDBmNTJmMjA1ZjQ1MDYyZDdkOWUwMWM4YWMwM2M2MTUxNGU5MzQ4MmZlYWNhZGIzYWZmYzZjY2Y5NiJ9; expires=Sun, 13-Apr-2025 03:14:30 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImlzYVU4aTZXRVpmNXkwRFhMbUlOc2c9PSIsInZhbHVlIjoiUHpQNFRlTHBmNENmM2haQlZRRWJwUzFwcXNTaXZmN25YYWRManVKdGljRUgyaktzTGoxT0hSREQ0dD ▶"
    2 => "visit_counter=eyJpdiI6IjZyRjhcL3hWSDRLVjhXcUJBSGNId3dRPT0iLCJ2YWx1ZSI6IlFuclpTNFVoNXJvbXJ5RjB6N2J0OHRzanNwZzJiMW9kM1NJVUNLcUdKUk52cVwveHNwOTQwQVFOY2c3K1c3a3U1IiwibWFjIjoiM2E1NmYxNDk1ZTgyODllNGFiNGEyZTk3ZDgzMzIzMThmZmYwNTBiYWFlZGZhZTgzMjA5NDNmN2QxODVlZjVlYyJ9; expires=Tue, 13-May-2025 01:14:29 GMT; Max-Age=2591999; path=/; httponly ◀visit_counter=eyJpdiI6IjZyRjhcL3hWSDRLVjhXcUJBSGNId3dRPT0iLCJ2YWx1ZSI6IlFuclpTNFVoNXJvbXJ5RjB6N2J0OHRzanNwZzJiMW9kM1NJVUNLcUdKUk52cVwveHNwOTQwQVFOY2c3K1c3a3U1Ii ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlQ4QzlQbTQyaTJlVm9kY1dRMFVqeFE9PSIsInZhbHVlIjoiK3FTNlwvZm0yTmpwcTFoQjhMQVhsQ29PS1licE5ub2dSQXFTUU9PdjlRTzR1Q0pRQ0xHOCtMbDZaNmlGMjRaemZpQ0gybk1yZXkrbE9sZmRQSlJGZmJLQnZpWnV1YzR1aDJ6NllOYkQ2Z0FYYzZFeXpobSt5eG8yZmV5Q0Fuak53IiwibWFjIjoiYmU1YmFhMDRjY2IxNzA5ZTZmN2MwNjA1ZGYzMTY1YjUxYzA2YmU0NWZiNjMyNDY3MTU2NDhiMjNjNWNkOTI1MCJ9; expires=Sun, 13-Apr-2025 03:14:30 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlQ4QzlQbTQyaTJlVm9kY1dRMFVqeFE9PSIsInZhbHVlIjoiK3FTNlwvZm0yTmpwcTFoQjhMQVhsQ29PS1licE5ub2dSQXFTUU9PdjlRTzR1Q0pRQ0xHOCtMbDZaNmlGMjRaemZpQ0gyb ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImlzYVU4aTZXRVpmNXkwRFhMbUlOc2c9PSIsInZhbHVlIjoiUHpQNFRlTHBmNENmM2haQlZRRWJwUzFwcXNTaXZmN25YYWRManVKdGljRUgyaktzTGoxT0hSREQ0dDFoSWNYNnBnallqXC9PMUVuOFoyWUQ2M1NkcjI0MGJHSEl1N2ZlK2FlNURwZ2o4VCtyb2F2RlNqamZNc3E3TEJwZGlsdGtQIiwibWFjIjoiMzk5ZGY5MDBmNTJmMjA1ZjQ1MDYyZDdkOWUwMWM4YWMwM2M2MTUxNGU5MzQ4MmZlYWNhZGIzYWZmYzZjY2Y5NiJ9; expires=Sun, 13-Apr-2025 03:14:30 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImlzYVU4aTZXRVpmNXkwRFhMbUlOc2c9PSIsInZhbHVlIjoiUHpQNFRlTHBmNENmM2haQlZRRWJwUzFwcXNTaXZmN25YYWRManVKdGljRUgyaktzTGoxT0hSREQ0dD ▶"
    2 => "visit_counter=eyJpdiI6IjZyRjhcL3hWSDRLVjhXcUJBSGNId3dRPT0iLCJ2YWx1ZSI6IlFuclpTNFVoNXJvbXJ5RjB6N2J0OHRzanNwZzJiMW9kM1NJVUNLcUdKUk52cVwveHNwOTQwQVFOY2c3K1c3a3U1IiwibWFjIjoiM2E1NmYxNDk1ZTgyODllNGFiNGEyZTk3ZDgzMzIzMThmZmYwNTBiYWFlZGZhZTgzMjA5NDNmN2QxODVlZjVlYyJ9; expires=Tue, 13-May-2025 01:14:29 GMT; path=/; httponly ◀visit_counter=eyJpdiI6IjZyRjhcL3hWSDRLVjhXcUJBSGNId3dRPT0iLCJ2YWx1ZSI6IlFuclpTNFVoNXJvbXJ5RjB6N2J0OHRzanNwZzJiMW9kM1NJVUNLcUdKUk52cVwveHNwOTQwQVFOY2c3K1c3a3U1Ii ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "YQ0trf9UEbI8wFXhfjxhFpoo66s0NMWbXQ98l3pC"
  "_previous" => array:1 [▶
    "url" => "https://staging.skyscrapercenter.xyz/company/381"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (97.14%)	380.69ms
1 x Booting (2.83%)	11.10ms

View all results

TFP Farrells

Farrells is a member of the CTBUH at the Silver level.

Renamed to:

Farrells

Buildings