Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Cho thuê căn hộ chung cư Quận Nam Từ Liêm Giá từ 3 - 5 triệu đồng T4/2025

Hiện có 1 căn hộ cho thuê

Đề xuất Mới đăng Có video

12

Căn hộ 1 ngủ - 2 ngủ- 3 ngủ - Studio VH Smart City giá siêu tốt mùa dịch

4 triệu/tháng 90m² 3 pn 2 wc

Vinhomes Smart City Nam Từ Liêm, Hà Nội

Ban quản lý Vinhomes Smart City Tây Mỗ - Đại Mỗ. Giới thiệu đến khách hàng nhiều căn hộ mới nhận bàn giao. Quỹ căn hộ cho thuê giá rẻ: * Căn hộ 75m2 3PN, 2WC 7 triệu/tháng. Thiết kế 3 PN và 1 phòng làm việc. Căn góc các phòng đều…

Đăng 4 tháng trước

Toàn quốc
Hồ Chí Minh
Hà Nội
Bình Dương
Đà Nẵng
Hải Phòng
Long An
Bà Rịa Vũng Tàu
An Giang
Bắc Giang
Bắc Kạn
Bạc Liêu
Bắc Ninh
Bến Tre
Bình Định
Bình Phước
Bình Thuận
Cà Mau
Cần Thơ
Cao Bằng
Đắk Lắk
Đắk Nông
Điện Biên
Đồng Nai
Đồng Tháp
Gia Lai
Hà Giang
Hà Nam
Hà Tĩnh
Hải Dương
Hậu Giang
Hòa Bình
Hưng Yên
Khánh Hòa
Kiên Giang
Kon Tum
Lai Châu
Lâm Đồng
Lạng Sơn
Lào Cai
Nam Định
Nghệ An
Ninh Bình
Ninh Thuận
Phú Thọ
Phú Yên
Quảng Bình
Quảng Nam
Quảng Ngãi
Quảng Ninh
Quảng Trị
Sóc Trăng
Sơn La
Tây Ninh
Thái Bình
Thái Nguyên
Thanh Hóa
Thừa Thiên Huế
Tiền Giang
Trà Vinh
Tuyên Quang
Vĩnh Long
Vĩnh Phúc
Yên Bái

Tất cả
Ba Đình
Bắc Từ Liêm
Cầu Giấy
Hà Đông
Đống Đa
Hai Bà Trưng
Hoàn Kiếm
Hoàng Mai
Long Biên
Nam Từ Liêm
Tây Hồ
Thanh Xuân
Đông Anh
Gia Lâm
Ba Vì
Chương Mỹ
Đan Phượng
Hoài Đức
Mê Linh
Mỹ Đức
Phú Xuyên
Phúc Thọ
Quốc Oai
Sơn Tây
Thạch Thất
Thanh Oai
Thanh Trì
Thường Tín
Ứng Hòa
Sóc Sơn

Tất cả
Xã Mễ Trì
Xã Phú Đô
Xã Tây Mỗ
Xã Trung Văn
Xã Đại Mỗ
Thị trấn Cầu Diễn
Phường Mỹ Đình 1
Phường Mỹ Đình 2
Phường Phương Canh
Xã Xuân Phương

Tất cả
Dưới 5 triệu
5 - 7 triệu
7 - 10 triệu
10 - 15 triệu
15 - 20 triệu
20 - 30 triệu
30 - 50 triệu
50 - 100 triệu
Trên 100 triệu

Tất cả
Dưới 20m²
20m² - 30m²
30m² - 50m²
50m² - 70m²
70m² - 90m²
90m² - 120m²
120m² - 200m²
200m² - 500m²
Trên 500m²

Tất cả
1 phòng ngủ
2 phòng ngủ
3 phòng ngủ
4+ phòng ngủ

Tất cả
1 toilet
2 toilet
3 toilet
4+ toilet

Tất cả
Đông
Tây
Nam
Bắc
Đông Nam
Đông Bắc
Tây Nam
Tây Bắc

Queries149 Models463

Request history7MB

149 statements were executed, 106 of which were duplicates, 43 unique. Show only duplicated157ms

Connection Establishedtch123_dev_2020Khelper.php#2679

Backtrace

15. app/Helpers/Khelper.php:2679
16. app/Http/Middleware/RedirectTrailingSlash.php:26
17. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
18. vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:75
19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

select * from `tch_redirects` where `status` = 1 and `url` = '/ha-noi/quan-nam-tu-liem.html' limit 11.35mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /ha-noi/quan-nam-tu-liem.html
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/Khelper.php:2679 17. app/Http/Middleware/RedirectTrailingSlash.php:26 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 19. vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:75 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183

- EXPLAIN # 1: `tch_redirects` (SIMPLE)18161
Params
id: 1
select_type: SIMPLE
table: tch_redirects
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 1816
Extra: Using where

select * from `tch_pages` where `tch_pages`.`id` = 1 limit 1500μstch123_dev_2020PageHelper.php#58

Bindings	0: 1
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. app/Helpers/PageHelper.php:58 21. app/Helpers/Khelper.php:256 22. middleware::page.hook:14 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 24. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `slug` = 'ha-noi/quan-nam-tu-liem' limit 1370μstch123_dev_2020PageHelper.php#100

Bindings	0: ha-noi/quan-nam-tu-liem
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:100 17. app/Helpers/Khelper.php:279 18. middleware::page.hook:16 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 20. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: slug_deleted_at
key: slug_deleted_at
key_len: 767
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (2)390μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. middleware::page.hook:16 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 25. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (42)370μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. middleware::page.hook:16 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 25. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `tch_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null360μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. middleware::page.hook:16 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 25. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)350μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. middleware::page.hook:16 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 25. app/Http/Middleware/LastUserActivity.php:25

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `slug` = 'ha-noi/quan-nam-tu-liem' limit 1360μstch123_dev_2020PageHelper.php#100

Bindings	0: ha-noi/quan-nam-tu-liem
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:100 17. app/Helpers/Khelper.php:279 18. app/Http/Controllers/PageController.php:37 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: slug_deleted_at
key: slug_deleted_at
key_len: 767
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (2)260μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. app/Http/Controllers/PageController.php:37 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (42)250μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. app/Http/Controllers/PageController.php:37 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

- EXPLAIN # 1: `tch_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. app/Http/Controllers/PageController.php:37 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)240μstch123_dev_2020PageHelper.php#100

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:100 22. app/Helpers/Khelper.php:279 23. app/Http/Controllers/PageController.php:37 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc310μstch123_dev_2020LocationHelper.php#24

Hints	0: The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	15. app/Helpers/LocationHelper.php:24 16. app/Helpers/Khelper.php:1972 17. app/Services/Page/PageService.php:377 18. app/Services/Page/PageService.php:32 19. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `tch_provinces` (SIMPLE)631
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 63
Extra: Using filesort

select * from `tch_global_option` where `name` = 'post_paging' limit 1290μstch123_dev_2020Setting.php#23

Bindings	0: post_paging
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	14. app/Helpers/Setting.php:23 15. app/Helpers/Khelper.php:363 16. app/Services/Page/PageService.php:362 17. app/Services/Page/PageService.php:425 18. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_global_option` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_global_option
type: const
possible_keys: name
key: name
key_len: 302
ref: const
rows: 1
Extra:

select count(*) as aggregate from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `so_phong_ngu` = '3' and `tch_post_apartment_details`.`original_price` >= '3000000' and `tch_post_apartment_details`.`original_price` <= '5000000' and `district_id` = 42 and `province_id` = 2 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null

47.26mstch123_dev_2020PageService.php#365

Bindings	0: 3 1: 3000000 2: 5000000 3: 42 4: 2 5: approved 6: 1 7: 0
Backtrace	16. app/Services/Page/PageService.php:365 17. app/Services/Page/PageService.php:425 18. app/Services/Page/PageService.php:32 19. app/Http/Controllers/PageController.php:42 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_posts` (SIMPLE)9621

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: index_merge
possible_keys: PRIMARY,out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at,district_id_published_status_out_of_service_deleted_at
key: out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at
key_len: 6,317
ref:
rows: 962
Extra: Using intersect(out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at); Using where

- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11

Params

id: 1
select_type: SIMPLE
table: tch_post_apartment_details
type: ref
possible_keys: post_id
key: post_id
key_len: 4
ref: tch123_dev_2020.tch_posts.id
rows: 1
Extra: Using index condition; Using where

select `tch_posts`.* from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `so_phong_ngu` = '3' and `tch_post_apartment_details`.`original_price` >= '3000000' and `tch_post_apartment_details`.`original_price` <= '5000000' and `district_id` = 42 and `province_id` = 2 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null order by `tch_posts`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 0

40.83mstch123_dev_2020PageService.php#365

Bindings	0: 3 1: 3000000 2: 5000000 3: 42 4: 2 5: approved 6: 1 7: 0
Backtrace	16. app/Services/Page/PageService.php:365 17. app/Services/Page/PageService.php:425 18. app/Services/Page/PageService.php:32 19. app/Http/Controllers/PageController.php:42 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_posts` (SIMPLE)9621

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: index_merge
possible_keys: PRIMARY,out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at,district_id_published_status_out_of_service_deleted_at
key: out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at
key_len: 6,317
ref:
rows: 962
Extra: Using intersect(out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at); Using where; Using filesort

- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11

Params

id: 1
select_type: SIMPLE
table: tch_post_apartment_details
type: ref
possible_keys: post_id
key: post_id
key_len: 4
ref: tch123_dev_2020.tch_posts.id
rows: 1
Extra: Using index condition; Using where

select * from `tch_packages` where `tch_packages`.`id` in (31)360μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_packages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_packages
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180130846)440μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_post_apartment_details
type: ref
possible_keys: post_id
key: post_id
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180130846)780μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_post_apartment_expands
type: ref
possible_keys: post_id
key: post_id
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_projects` where `tch_projects`.`id` in (1752) and `tch_projects`.`deleted_at` is null360μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_projects` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (1752)21.36mstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 1752
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_provinces` where `tch_provinces`.`id` in (2)330μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

410μstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_districts` where `tch_districts`.`id` in (42)280μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (42)

360μstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 42
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_users` where `tch_users`.`id` in (1539) and `tch_users`.`deleted_at` is null500μstch123_dev_2020PageService.php#365

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Services/Page/PageService.php:365 22. app/Services/Page/PageService.php:425 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_users` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_users
type: const
possible_keys: PRIMARY,deleted_at
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_provinces` where `tch_provinces`.`id` = 2 limit 1300μstch123_dev_2020LocationHelper.php#266

Bindings	0: 2
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. app/Helpers/LocationHelper.php:266 18. app/Helpers/Khelper.php:195 19. app/Services/Page/PageService.php:427 20. app/Services/Page/PageService.php:32 21. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id_province` in (2) order by `ordering` asc, `id_province` asc, `name` asc

370μstch123_dev_2020LocationHelper.php#266

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	22. app/Helpers/LocationHelper.php:266 23. app/Helpers/Khelper.php:195 24. app/Services/Page/PageService.php:427 25. app/Services/Page/PageService.php:32 26. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `tch_districts` (SIMPLE)301
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: ref
possible_keys: id_province
key: id_province
key_len: 4
ref: const
rows: 30
Extra: Using where; Using filesort

select * from `tch_districts` where `tch_districts`.`id_province` = 2 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc

360μstch123_dev_2020Province.php#28

Bindings	0: 2
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	16. app/Models/Province.php:28 17. app/Services/Page/PageService.php:427 18. app/Services/Page/PageService.php:32 19. app/Http/Controllers/PageController.php:42 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_districts` (SIMPLE)301
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: ref
possible_keys: id_province
key: id_province
key_len: 4
ref: const
rows: 30
Extra: Using index condition; Using where; Using filesort

select * from `tch_districts` where `tch_districts`.`id` = 42 limit 1280μstch123_dev_2020LocationHelper.php#322

Bindings	0: 42
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	20. app/Helpers/LocationHelper.php:322 21. app/Helpers/Khelper.php:207 22. app/Services/Page/PageService.php:430 23. app/Services/Page/PageService.php:32 24. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `tch_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select `id`, CONCAT(pre," ",name) as text, CONCAT(pre," ",name) as name from `tch_wards` where `tch_wards`.`id_district` = 42 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc

580μstch123_dev_2020District.php#34

Bindings	0: 42
Backtrace	16. app/Models/District.php:34 17. app/Services/Page/PageService.php:430 18. app/Services/Page/PageService.php:32 19. app/Http/Controllers/PageController.php:42 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- EXPLAIN # 1: `tch_wards` (SIMPLE)101
Params
id: 1
select_type: SIMPLE
table: tch_wards
type: ref
possible_keys: id_district
key: id_district
key_len: 4
ref: const
rows: 10
Extra: Using index condition; Using where; Using filesort

select * from `tch_pages` where `indexed` = 5 limit 1320μstch123_dev_2020PageHelper.php#23

Bindings	0: 5
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:23 17. app/Models/Page.php:183 18. app/Helpers/Khelper.php:2292 19. app/Services/Page/PageService.php:448 20. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: indexed_deleted_at
key: indexed_deleted_at
key_len: 768
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (0)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:183 23. app/Helpers/Khelper.php:2292 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_districts` where `tch_districts`.`id` in (0)190μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:183 23. app/Helpers/Khelper.php:2292 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null220μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:183 23. app/Helpers/Khelper.php:2292 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:183 23. app/Helpers/Khelper.php:2292 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `indexed` = '5_2' limit 1300μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_2
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:23 17. app/Models/Page.php:189 18. app/Helpers/Khelper.php:2306 19. app/Services/Page/PageService.php:448 20. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: indexed_deleted_at
key: indexed_deleted_at
key_len: 768
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (2)210μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:189 23. app/Helpers/Khelper.php:2306 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (0)190μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:189 23. app/Helpers/Khelper.php:2306 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null220μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:189 23. app/Helpers/Khelper.php:2306 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:189 23. app/Helpers/Khelper.php:2306 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `indexed` = '5_2_42' limit 1300μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_2_42
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:23 17. app/Models/Page.php:216 18. app/Helpers/Khelper.php:2307 19. app/Services/Page/PageService.php:448 20. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: indexed_deleted_at
key: indexed_deleted_at
key_len: 768
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (2)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:216 23. app/Helpers/Khelper.php:2307 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (42)190μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:216 23. app/Helpers/Khelper.php:2307 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null220μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:216 23. app/Helpers/Khelper.php:2307 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Models/Page.php:216 23. app/Helpers/Khelper.php:2307 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. app/Helpers/Khelper.php:2346 23. app/Services/Page/PageService.php:448 24. app/Services/Page/PageService.php:32 25. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1210μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. app/Helpers/Khelper.php:2387 23. app/Services/Page/PageService.php:448 24. app/Services/Page/PageService.php:32 25. app/Http/Controllers/PageController.php:42

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_pages` where `indexed` = '5_2' limit 1430μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_2
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:23 17. app/Helpers/Khelper.php:890 18. view::_desktop.main.includes.khuvuc:4 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `tch_pages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ref
possible_keys: indexed_deleted_at
key: indexed_deleted_at
key_len: 768
ref: const
rows: 1
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` in (2)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.khuvuc:4 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (0)180μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.khuvuc:4 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null220μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.khuvuc:4 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_estates` where `tch_estates`.`id` in (5)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.khuvuc:4 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `estate_id` = 5 and `province_id` = 2 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc

670μstch123_dev_2020Page.php#245

Bindings	0: 5 1: 2 2: 0 3: 0 4: 0 5: 0 6: 1 7: 0
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. app/Models/Page.php:245 16. view::_desktop.main.includes.khuvuc:5 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_pages` (SIMPLE)11791

Params

id: 1
select_type: SIMPLE
table: tch_pages
type: range
possible_keys: estate_id_deleted_at,estate_id_province_id_deleted_at,estate_id_province_id_district_id_deleted_at,count_deleted_at,published_deleted_at,estate_id_project_id_deleted_at
key: estate_id_province_id_district_id_deleted_at
key_len: 15
ref:
rows: 1179
Extra: Using index condition; Using where; Using filesort

select * from `tch_provinces` where `tch_provinces`.`id` in (2)200μstch123_dev_2020Page.php#245

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Models/Page.php:245 21. view::_desktop.main.includes.khuvuc:5 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_districts` where `tch_districts`.`id` in (25, 27, 28, 31, 32, 33, 34, 35, 36, 37, 38, 39, 42, 48, 51, 52)

240μstch123_dev_2020Page.php#245

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Models/Page.php:245 21. view::_desktop.main.includes.khuvuc:5 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_districts` (SIMPLE)161
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 16
Extra: Using where

select * from `tch_estates` where `tch_estates`.`id` in (5)250μstch123_dev_2020Page.php#245

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Models/Page.php:245 21. view::_desktop.main.includes.khuvuc:5 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_estates` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_estates
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1380μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. view::_desktop.main.includes.khuvuc:34 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1230μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. view::_desktop.main.includes.khuvuc:34 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1220μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. view::_desktop.main.includes.khuvuc:34 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1210μstch123_dev_2020Page.php#366

Bindings	0: 0
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	21. app/Models/Page.php:366 22. view::_desktop.main.includes.khuvuc:34 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `` (SIMPLE)1
Params
id: 1
select_type: SIMPLE
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE noticed after reading const tables