Countries

View information on countries around the world using the list below. To see detailed information on a country, click its name to view its country page.

					Number of Buildings
Rank	Country	Population Source: United Nations	Area Source: United Nations	Density	150m+	200m+	300m+	Tallest City Based on Aggregate Building Height (150m+)
1	China	1,353,821,000	9,706,961 M km² 3,747,861 M mi²	139 people per km² 361 people per mi²	2,395	823	95	Hong Kong
2	United States	317,518,000	9,833,517 M km² 3,796,725 M mi²	32 people per km² 84 people per mi²	825	220	28	New York City
3	United Arab Emirates	5,473,972	83,600 M km² 32,278 M mi²	65 people per km² 170 people per mi²	268	129	31	Dubai
4	Japan	127,103,388	364,500 M km² 140,734 M mi²	349 people per km² 903 people per mi²	261	44	1	Tokyo
5	South Korea	50,219,669	100,339 M km² 38,741 M mi²	500 people per km² 1,296 people per mi²	233	74	7	Seoul
6	Australia	23,836,540	7,692,024 M km² 2,969,893 M mi²	3 people per km² 8 people per mi²	122	39	2	Melbourne
7	Canada	33,476,688	9,984,670 M km² 3,855,085 M mi²	3 people per km² 9 people per mi²	112	32	0	Toronto
8	Thailand	67,070,000	510,890 M km² 197,255 M mi²	131 people per km² 340 people per mi²	108	26	3	Bangkok
9	Indonesia	237,556,363	1,910,931 M km² 737,811 M mi²	124 people per km² 322 people per mi²	105	42	0	Jakarta
10	Malaysia	30,073,353	328,550 M km² 126,853 M mi²	92 people per km² 237 people per mi²	97	44	5	Kuala Lumpur
11	Singapore	5,076,700	723 M km² 279 M mi²	7,022 people per km² 18,186 people per mi²	94	33	0	Singapore
12	Philippines	94,013,200	300,000 M km² 115,830 M mi²	313 people per km² 812 people per mi²	92	34	0	Makati
13	India	1,192,280,000	3,287,263 M km² 1,269,214 M mi²	363 people per km² 939 people per mi²	73	16	0	Mumbai
14	Turkey	81,619,392	769,630 M km² 297,154 M mi²	106 people per km² 275 people per mi²	66	11	0	Istanbul
15	Panama	3,405,813	75,320 M km² 29,081 M mi²	45 people per km² 117 people per mi²	54	23	0	Panama City
16	Russia	141,927,297	17,098,240 M km² 6,601,637 M mi²	8 people per km² 21 people per mi²	49	19	7	Moscow
17	Brazil	201,032,714	8,515,767 M km² 3,287,941 M mi²	24 people per km² 61 people per mi²	44	1	0	Balneario Camboriu
18	Mexico	112,322,757	1,964,375 M km² 758,446 M mi²	57 people per km² 148 people per mi²	43	10	1	Mexico City
19	Qatar	1,696,563	11,627 M km² 4,489 M mi²	146 people per km² 378 people per mi²	36	22	1	Doha
20	Saudi Arabia	29,195,895	2,206,714 M km² 852,013 M mi²	13 people per km² 34 people per mi²	34	21	3	Riyadh
21	Vietnam	93,421,835	310,070 M km² 119,718 M mi²	301 people per km² 780 people per mi²	29	7	2	Ho Chi Minh City
22	United Kingdom	63,181,775	242,495 M km² 93,627 M mi²	261 people per km² 675 people per mi²	28	10	1	London
23	Colombia	45,785,000	1,141,748 M km² 440,829 M mi²	40 people per km² 104 people per mi²	23	3	0	Bogota
24	France	65,447,374	551,500 M km² 212,934 M mi²	119 people per km² 307 people per mi²	23	3	0	Courbevoie
25	Israel	8,051,200	22,072 M km² 8,522 M mi²	365 people per km² 945 people per mi²	22	3	0	Tel Aviv
26	Germany	80,585,700	357,168 M km² 137,903 M mi²	226 people per km² 584 people per mi²	18	5	0	Frankfurt am Main
27	Kuwait	3,051,000	17,818 M km² 6,880 M mi²	171 people per km² 443 people per mi²	17	9	3	Kuwait City
28	North Korea	24,052,231	120,538 M km² 46,540 M mi²	200 people per km² 517 people per mi²	15	5	0	Pyongyang
29	Bahrain	807,000	778 M km² 300 M mi²	1,037 people per km² 2,687 people per mi²	13	5	0	Manama
30	Argentina	40,091,359	2,796,427 M km² 1,079,702 M mi²	14 people per km² 37 people per mi²	11	1	0	Buenos Aires
31	Spain	47,737,941	505,987 M km² 195,362 M mi²	94 people per km² 244 people per mi²	11	4	0	Madrid
32	Poland	38,092,000	312,685 M km² 120,728 M mi²	122 people per km² 316 people per mi²	10	3	0	Warsaw
33	Sri Lanka	20,410,000	65,610 M km² 25,332 M mi²	311 people per km² 806 people per mi²	10	2	0	Colombo
34	Netherlands	16,877,351	33,670 M km² 13,000 M mi²	501 people per km² 1,298 people per mi²	6	0	0	Rotterdam
35	Italy	59,685,227	302,069 M km² 116,629 M mi²	198 people per km² 512 people per mi²	5	2	0	Milan
36	South Africa	49,991,300	1,221,037 M km² 471,443 M mi²	41 people per km² 106 people per mi²	5	2	0	Johannesburg
37	Azerbaijan	8,997,400	86,600 M km² 33,436 M mi²	104 people per km² 269 people per mi²	4	0	0	Baku
38	Kazakhstan	16,396,000	2,724,900 M km² 1,052,085 M mi²	6 people per km² 16 people per mi²	4	0	0	Nur-Sultan
39	New Zealand	4,394,400	268,107 M km² 103,516 M mi²	16 people per km² 42 people per mi²	4	0	0	Auckland
40	Venezuela	29,058,000	929,690 M km² 358,954 M mi²	31 people per km² 81 people per mi²	4	2	0	Caracas
41	Austria	8,396,760	83,878 M km² 32,385 M mi²	100 people per km² 259 people per mi²	3	2	0	Vienna
42	Lebanon	4,255,000	10,452 M km² 4,036 M mi²	407 people per km² 1,054 people per mi²	3	0	0	Beirut
43	Tanzania	44,928,923	947,303 M km² 365,754 M mi²	47 people per km² 123 people per mi²	3	0	0	Dar es Salaam
44	Chile	17,363,894	743,532 M km² 287,078 M mi²	23 people per km² 60 people per mi²	2	1	1	Santiago
45	Dominican Republic	9,884,371	48,671 M km² 18,792 M mi²	203 people per km² 526 people per mi²	2	0	0	Santo Domingo
46	Georgia	4,436,000	69,700 M km² 26,911 M mi²	64 people per km² 165 people per mi²	2	1	0	Batumi
47	Kenya	38,610,097	591,958 M km² 228,555 M mi²	65 people per km² 169 people per mi²	2	1	0	Nairobi
48	Algeria	35,600,000	2,381,741 M km² 919,591 M mi²	15 people per km² 39 people per mi²	1	1	0	Algiers
49	Bangladesh	149,804,000	147,570 M km² 56,977 M mi²	1,015 people per km² 2,629 people per mi²	1	0	0	Dhaka
50	Cambodia	13,395,682	181,035 M km² 69,898 M mi²	74 people per km² 192 people per mi²	1	0	0	Phnom Penh

1 2

Countries per page:

Messages Timeline Exceptions Views11 Route Queries70 Models1848 Mails Gate Session Request

7.3.33304ms16MBGET countries

Booting (21.12ms)
Application (283ms)
1 x Application (93.01%)
282.52ms
1 x Booting (6.95%)
21.12ms

11 templates were rendered

countries.list-redesign (resources/views/countries/list-redesign.blade.php)5blade
Params
0
countries
1
listTypes
2
selectedType
3
title
4
accessLevel

Params
0	`countries`
1	`listTypes`
2	`selectedType`
3	`title`
4	`accessLevel`

common-redesign.login-message (resources/views/common-redesign/login-message.blade.php)16blade


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
directionRight
noRightMargin

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`directionRight`
15	`noRightMargin`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`
16	`nav`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data
nav

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`
16	`nav`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data
nav
item
child

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`
16	`nav`
17	`item`
18	`child`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`
16	`alreadyConsentedWithCookies`
17	`cookieConsentConfig`

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


obLevel
__env
app
errors
lucky_50
countries
listTypes
selectedType
title
accessLevel
__currentLoopData
listTypeData
listType
loop
country
data
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lucky_50`
5	`countries`
6	`listTypes`
7	`selectedType`
8	`title`
9	`accessLevel`
10	`__currentLoopData`
11	`listTypeData`
12	`listType`
13	`loop`
14	`country`
15	`data`
16	`alreadyConsentedWithCookies`
17	`cookieConsentConfig`

uri: GET countries
middleware: web
controller: App\Http\Controllers\CountryController@countryList
namespace: App\Http\Controllers
prefix
where
as: countries
file: app/Http/Controllers/CountryController.php:99-180

70 statements were executed170ms

select * from `v2_countries` where `num_buildings_150` > 0 order by `num_buildings_150` desc, `num_buildings_150` desc, `name` asc limit 200

9.49ms/app/Http/Controllers/CountryController.php:156buldingdb

Metadata
Bindings	0. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Http/Controllers/CountryController.php:156 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:383 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:378 17. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 18. /app/Http/Controllers/CountryController.php:157

select * from `v2_cities` where `v2_cities`.`country_id` = 34 and `v2_cities`.`country_id` is not null order by `name` asc

6.14ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 34
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 163 and `v2_cities`.`country_id` is not null order by `name` asc

10.35ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 163
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 2 and `v2_cities`.`country_id` is not null order by `name` asc

1.7ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 82 and `v2_cities`.`country_id` is not null order by `name` asc

2.45ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 82
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 85 and `v2_cities`.`country_id` is not null order by `name` asc

1.74ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 85
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 11 and `v2_cities`.`country_id` is not null order by `name` asc

1.93ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 11
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 27 and `v2_cities`.`country_id` is not null order by `name` asc

2.61ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 27
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 153 and `v2_cities`.`country_id` is not null order by `name` asc

1.82ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 153
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 72 and `v2_cities`.`country_id` is not null order by `name` asc

2.17ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 72
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 112 and `v2_cities`.`country_id` is not null order by `name` asc

1.88ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 112
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 140 and `v2_cities`.`country_id` is not null order by `name` asc

2.41ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 140
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 127 and `v2_cities`.`country_id` is not null order by `name` asc

1.76ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 127
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 75 and `v2_cities`.`country_id` is not null order by `name` asc

3.47ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 75
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 158 and `v2_cities`.`country_id` is not null order by `name` asc

1.94ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 158
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 123 and `v2_cities`.`country_id` is not null order by `name` asc

2.33ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 123
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 135 and `v2_cities`.`country_id` is not null order by `name` asc

3.38ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 135
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 22 and `v2_cities`.`country_id` is not null order by `name` asc

3.74ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 22
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 111 and `v2_cities`.`country_id` is not null order by `name` asc

2.37ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 111
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 133 and `v2_cities`.`country_id` is not null order by `name` asc

2.84ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 133
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 137 and `v2_cities`.`country_id` is not null order by `name` asc

1.84ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 137
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 168 and `v2_cities`.`country_id` is not null order by `name` asc

1.72ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 56 and `v2_cities`.`country_id` is not null order by `name` asc

4.29ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 56
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 35 and `v2_cities`.`country_id` is not null order by `name` asc

1.77ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 35
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 55 and `v2_cities`.`country_id` is not null order by `name` asc

2.21ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 55
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 74 and `v2_cities`.`country_id` is not null order by `name` asc

1.95ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 74
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 41 and `v2_cities`.`country_id` is not null order by `name` asc

2.64ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 41
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 86 and `v2_cities`.`country_id` is not null order by `name` asc

1.76ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 86
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 176 and `v2_cities`.`country_id` is not null order by `name` asc

2.19ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 176
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 18 and `v2_cities`.`country_id` is not null order by `name` asc

1.49ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 18
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 9 and `v2_cities`.`country_id` is not null order by `name` asc

1.53ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 9
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 51 and `v2_cities`.`country_id` is not null order by `name` asc

1.86ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 51
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 129 and `v2_cities`.`country_id` is not null order by `name` asc

1.77ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 129
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 91 and `v2_cities`.`country_id` is not null order by `name` asc

1.59ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 91
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 118 and `v2_cities`.`country_id` is not null order by `name` asc

6.42ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 118
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 79 and `v2_cities`.`country_id` is not null order by `name` asc

2.45ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 79
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 172 and `v2_cities`.`country_id` is not null order by `name` asc

2.14ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 172
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 13 and `v2_cities`.`country_id` is not null order by `name` asc

1.47ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 13
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 88 and `v2_cities`.`country_id` is not null order by `name` asc

1.76ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 88
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 121 and `v2_cities`.`country_id` is not null order by `name` asc

1.43ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 121
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 167 and `v2_cities`.`country_id` is not null order by `name` asc

1.53ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 167
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 10 and `v2_cities`.`country_id` is not null order by `name` asc

1.51ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 10
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 89 and `v2_cities`.`country_id` is not null order by `name` asc

1.36ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 89
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 160 and `v2_cities`.`country_id` is not null order by `name` asc

1.76ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 160
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 32 and `v2_cities`.`country_id` is not null order by `name` asc

4.34ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 32
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 45 and `v2_cities`.`country_id` is not null order by `name` asc

1.41ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 45
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 58 and `v2_cities`.`country_id` is not null order by `name` asc

1.52ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 58
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 83 and `v2_cities`.`country_id` is not null order by `name` asc

1.49ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 83
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 46 and `v2_cities`.`country_id` is not null order by `name` asc

1.38ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 46
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 19 and `v2_cities`.`country_id` is not null order by `name` asc

1.55ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 19
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 84 and `v2_cities`.`country_id` is not null order by `name` asc

3.33ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 84
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 77 and `v2_cities`.`country_id` is not null order by `name` asc

1.53ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 77
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 76 and `v2_cities`.`country_id` is not null order by `name` asc

2.32ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 76
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 81 and `v2_cities`.`country_id` is not null order by `name` asc

1.36ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 81
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 99 and `v2_cities`.`country_id` is not null order by `name` asc

1.39ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 99
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 116 and `v2_cities`.`country_id` is not null order by `name` asc

1.65ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 116
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 139 and `v2_cities`.`country_id` is not null order by `name` asc

1.77ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 139
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 31 and `v2_cities`.`country_id` is not null order by `name` asc

1.73ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 31
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 155 and `v2_cities`.`country_id` is not null order by `name` asc

1.48ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 155
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 161 and `v2_cities`.`country_id` is not null order by `name` asc

2.33ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 161
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `v2_cities` where `v2_cities`.`country_id` = 164 and `v2_cities`.`country_id` is not null order by `name` asc

1.4ms/app/Country.php:124buldingdb

Metadata
Bindings	0. 164
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /app/Country.php:124 20. view::countries.list-redesign:186 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

select * from `nav_menu_items` where `parent_id` is null1.28ms/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

1.29ms/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.34ms/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

8.16ms/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

1.44ms/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.44ms/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.51ms/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.62ms/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

3.15ms/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\City: 1751
App\Country: 60

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

path_info

/countries

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" => "27851"
  "REMOTE_ADDR" => "3.145.63.63"
  "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" => "/countries"
  "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" => 1743894192.5215
  "REQUEST_TIME" => 1743894192
]

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 => "Sat, 05 Apr 2025 23:03:12 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlwvSm1cL0VicUpmYlBaRlhqOWtEaGJZQT09IiwidmFsdWUiOiJkSHpFOGp3eWVSWEh5NkxNRmRzRSt2ZG4xMzRrR0xUcTNUTTZsU2VKTFZEK3dqU0RzOElqU1MxSG9tRkpxYzZCdWRrR2J0ZUdlYjU3SnJGdEZWRlwvT091V1BCNWV6b1lDQVMzXC92NWRvYU9FdmR4QWxlN3BFTlhTdE9mNWxxUTVHIiwibWFjIjoiYzlkYzQxZDQyYWNiNTcyNjI5NDNiZjE0NTZmMTVhOTMyN2U4NjU3NWZkMzc5OTNhYWViOWE5YjkzMWIzN2UwOSJ9; expires=Sun, 06-Apr-2025 01:03:12 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvSm1cL0VicUpmYlBaRlhqOWtEaGJZQT09IiwidmFsdWUiOiJkSHpFOGp3eWVSWEh5NkxNRmRzRSt2ZG4xMzRrR0xUcTNUTTZsU2VKTFZEK3dqU0RzOElqU1MxSG9tRkpxYzZCdWRrR ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImRDSjFtTXd0eXozT1Jqa29JaUVFc1E9PSIsInZhbHVlIjoiTVJveXFXT1l4N2FkaG1HN2F1WTJySkFRTDZWeXBWU3lpS0k3YVhcL09VdkFWcmdtNzIzUFYzUmF5MGxCXC9RU3pRb0EwT2JCSlhBQWpFa2NXUjhrMGU1cTdkdjF1NDZSN2w2b0czTjZNcEJMd0xUc0drMlNsbk9VY1FScE9cL0hVTkYiLCJtYWMiOiJkNDgyNTY1ZGU3Yjk3YmZlODc4YzM3ZTM3MmVkNmUzZGIzYTUyM2ExY2MxNmIyYjc3MDcxODQxNmRiODJhYjZkIn0%3D; expires=Sun, 06-Apr-2025 01:03:12 GMT; Max-Age=7200; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImRDSjFtTXd0eXozT1Jqa29JaUVFc1E9PSIsInZhbHVlIjoiTVJveXFXT1l4N2FkaG1HN2F1WTJySkFRTDZWeXBWU3lpS0k3YVhcL09VdkFWcmdtNzIzUFYzUmF5MG ▶"
    2 => "visit_counter=eyJpdiI6ImtaVGVOUGg1VUdPOFFGRXNNSUdDNnc9PSIsInZhbHVlIjoibmc2YndBMGpXK1VtYVhYN0tUNWZlemI2ejg0azhUQVpzY0Z5ajdaNldhZVI2b3JJNGlUTEtDNDhpVndLYktyWiIsIm1hYyI6ImFjNWQ2ZTZmYWVlMTQ5ZjdjZDJlMzM0MDFjZWMyOGQyMDk3ZmU3YzQ1YmUwNjlkNzIyZWYxOWZkMTc3YTJiZmQifQ%3D%3D; expires=Mon, 05-May-2025 23:03:12 GMT; Max-Age=2592000; path=/; httponly ◀visit_counter=eyJpdiI6ImtaVGVOUGg1VUdPOFFGRXNNSUdDNnc9PSIsInZhbHVlIjoibmc2YndBMGpXK1VtYVhYN0tUNWZlemI2ejg0azhUQVpzY0Z5ajdaNldhZVI2b3JJNGlUTEtDNDhpVndLYktyWiIsIm ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlwvSm1cL0VicUpmYlBaRlhqOWtEaGJZQT09IiwidmFsdWUiOiJkSHpFOGp3eWVSWEh5NkxNRmRzRSt2ZG4xMzRrR0xUcTNUTTZsU2VKTFZEK3dqU0RzOElqU1MxSG9tRkpxYzZCdWRrR2J0ZUdlYjU3SnJGdEZWRlwvT091V1BCNWV6b1lDQVMzXC92NWRvYU9FdmR4QWxlN3BFTlhTdE9mNWxxUTVHIiwibWFjIjoiYzlkYzQxZDQyYWNiNTcyNjI5NDNiZjE0NTZmMTVhOTMyN2U4NjU3NWZkMzc5OTNhYWViOWE5YjkzMWIzN2UwOSJ9; expires=Sun, 06-Apr-2025 01:03:12 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlwvSm1cL0VicUpmYlBaRlhqOWtEaGJZQT09IiwidmFsdWUiOiJkSHpFOGp3eWVSWEh5NkxNRmRzRSt2ZG4xMzRrR0xUcTNUTTZsU2VKTFZEK3dqU0RzOElqU1MxSG9tRkpxYzZCdWRrR ▶"
    1 => "skyscraper_center_session=eyJpdiI6ImRDSjFtTXd0eXozT1Jqa29JaUVFc1E9PSIsInZhbHVlIjoiTVJveXFXT1l4N2FkaG1HN2F1WTJySkFRTDZWeXBWU3lpS0k3YVhcL09VdkFWcmdtNzIzUFYzUmF5MGxCXC9RU3pRb0EwT2JCSlhBQWpFa2NXUjhrMGU1cTdkdjF1NDZSN2w2b0czTjZNcEJMd0xUc0drMlNsbk9VY1FScE9cL0hVTkYiLCJtYWMiOiJkNDgyNTY1ZGU3Yjk3YmZlODc4YzM3ZTM3MmVkNmUzZGIzYTUyM2ExY2MxNmIyYjc3MDcxODQxNmRiODJhYjZkIn0%3D; expires=Sun, 06-Apr-2025 01:03:12 GMT; path=/; httponly ◀skyscraper_center_session=eyJpdiI6ImRDSjFtTXd0eXozT1Jqa29JaUVFc1E9PSIsInZhbHVlIjoiTVJveXFXT1l4N2FkaG1HN2F1WTJySkFRTDZWeXBWU3lpS0k3YVhcL09VdkFWcmdtNzIzUFYzUmF5MG ▶"
    2 => "visit_counter=eyJpdiI6ImtaVGVOUGg1VUdPOFFGRXNNSUdDNnc9PSIsInZhbHVlIjoibmc2YndBMGpXK1VtYVhYN0tUNWZlemI2ejg0azhUQVpzY0Z5ajdaNldhZVI2b3JJNGlUTEtDNDhpVndLYktyWiIsIm1hYyI6ImFjNWQ2ZTZmYWVlMTQ5ZjdjZDJlMzM0MDFjZWMyOGQyMDk3ZmU3YzQ1YmUwNjlkNzIyZWYxOWZkMTc3YTJiZmQifQ%3D%3D; expires=Mon, 05-May-2025 23:03:12 GMT; path=/; httponly ◀visit_counter=eyJpdiI6ImtaVGVOUGg1VUdPOFFGRXNNSUdDNnc9PSIsInZhbHVlIjoibmc2YndBMGpXK1VtYVhYN0tUNWZlemI2ejg0azhUQVpzY0Z5ajdaNldhZVI2b3JJNGlUTEtDNDhpVndLYktyWiIsIm ▶"
  ]
]

session_attributes

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

1 x Application (93.01%)	282.52ms
1 x Booting (6.95%)	21.12ms

View all results

Countries