Đă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ư Kosmo Tây Hồ Mới Nhất T4/2025

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

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

7

TÔI cần cho thuê CH Cao Cấp Kosmo Tây Hồ, 3PN, 2WC đủ nội thất, View Hồ Tây

Thỏa thuận 118m² 3 pn 2 wc

Kosmo Tây Hồ Bắc Từ Liêm, Hà Nội

TÔI cần cho thuê CH cao cấp Kosmo Tây Hồ Diện tích : 118m2 gồm 03 phòng ngủ 02 vệ sinh ban công và logia View Đông Nam, ôm trọn Hồ Tây Lộng gió… Vị trí đắc địa, an ninh, dân trí đỉnh, tiện ích bạt ngàn Full NT cao cấp, Deco sang…

Đăng 4 tháng trước
8

Chính chủ cần cho thuê căn hộ tại dự án chung cư cao cấp KosMo Tây Hồ tầng cao, Dt 119m2, 3pn, 2wc

Thỏa thuận 119m² 3 pn 2 wc

Kosmo Tây Hồ Bắc Từ Liêm, Hà Nội

Chính chủ cần cho thuê căn hộ tại dự án chung cư cao cấp KosMo- Tây Hồ Mã căn: novo - tầng cao view Hồ Tây Căn hộ rộng 119m2 rất rộng rãi và thông thoáng Được thiết kế gồm: 1 phòng khách, bếp, 3pn và 2wc Nhà trống, sạch sẽ khách…

Đăng 4 tháng trước
5

Cho thuê căn hộ 3 phòng ngủ, dt 102,1m2 tại toà Centro, Kosmo Tây Hồ 161 Xuân La

Thỏa thuận 102m² 2 pn

Kosmo Tây Hồ Bắc Từ Liêm, Hà Nội

Cho thuê căn hộ 3 phòng ngủ toà Centro, Kosmo Tây Hồ 161 Xuân La Diện tích : 102,1 m2 Căn hộ đầy đủ tiện nghi , ở ngay Tiện ích : Phòng Gym , Yoga , Bể bơi , Siêu thị , Bệnh viện Giao thông thuận tiện Giá thuê : Yêu thương ib…

Đăng 4 tháng trước
8

Cho thuê căn hộ chung cư Kosmo Tây hồ căn 2pn, 2wc, liên hệ để có giá ưu đãi 0812329668

Thỏa thuận 65m² 2 pn 2 wc

Kosmo Tây Hồ Bắc Từ Liêm, Hà Nội

Cho thuê căn hộ chung cư Kosmo Tây hồ - 161 Xuân La - Tây hồ - Hà Nội - Căn hộ full nội thất đầy đủ tiện nghi rọn nhà ở ngay - Số phòng ngủ : 02 - Số phòng khách : 01 - WC : 02 - Cửa Tây Bắc - Ban công Đông Nam view Hồ Tây lộng…

Đăng 4 tháng trước
9

Cho thuê căn hộ cao cấp 2 phòng ngủ, 2wc, diện tích 77,4m2 tại chung cư Kosmo Tây hồ

Thỏa thuận 77m² 2 pn 2 wc

Kosmo Tây Hồ Bắc Từ Liêm, Hà Nội

Em đang cho thuê căn hộ siêu đẹp tại Kosmo Tây hồ khách nào cần liên hệ em đến xem nhà ngay ạ: + Căn dtsd 77,4m2 không gian thiết kế rất sang trọng, rộng rãi sinh hoạt đủ tiện nghi và thoải mái + Kết cấu xây dựng gồm: 2 phòng ngủ,…

Đă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ã Minh Khai
Xã Tây Tựu
Phường Phú Diễn
Phường Xuân Tảo
Xã Liên Mạc
Phường Cầu Diễn
Phường Phúc Diễn
Phường Cổ Nhuế 1
Phường Cổ Nhuế 2
Xã Xuân Đỉnh
Xã Đông Ngạc
Phường Đức Thắng
Xã Thượng Cát
Xã Thụy Phương

Dự án nổi bật

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 Models446

Request history7MB

149 statements were executed, 104 of which were duplicates, 45 unique. Show only duplicated174ms

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` = '/cho-thue-can-ho-chung-cu-kosmo-tay-ho.html' limit 12.46mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /cho-thue-can-ho-chung-cu-kosmo-tay-ho.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 1330μ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` = 'cho-thue-can-ho-chung-cu-kosmo-tay-ho' limit 1770μstch123_dev_2020PageHelper.php#100

Bindings	0: cho-thue-can-ho-chung-cu-kosmo-tay-ho
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)420μ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 (27)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 (2514) and `tch_projects`.`deleted_at` is null710μ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_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_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` = 'cho-thue-can-ho-chung-cu-kosmo-tay-ho' limit 1370μstch123_dev_2020PageHelper.php#100

Bindings	0: cho-thue-can-ho-chung-cu-kosmo-tay-ho
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)220μ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 (27)230μ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 (2514) 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: `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_estates` where `tch_estates`.`id` in (5)270μ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` asc290μ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 1270μ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 `tch_post_apartment_details`.`original_price` <= '3000000' and `project_id` = 2514 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null

1.09mstch123_dev_2020PageService.php#365

Bindings	0: 3000000 1: 2514 2: approved 3: 1 4: 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)221

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
key: project_id_published_status_out_of_service_ordering_deleted_at
key_len: 312
ref: const,const,const,const
rows: 22
Extra: Using where; Using index

- 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 `tch_post_apartment_details`.`original_price` <= '3000000' and `project_id` = 2514 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

1.74mstch123_dev_2020PageService.php#365

Bindings	0: 3000000 1: 2514 2: approved 3: 1 4: 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)221

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
key: project_id_published_deleted_at
key_len: 13
ref: const,const,const
rows: 22
Extra: Using index condition; 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)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_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 (180132725, 180132779, 180138650, 180143603, 180209688)

490μ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)51
Params
id: 1
select_type: SIMPLE
table: tch_post_apartment_details
type: range
possible_keys: post_id
key: post_id
key_len: 4
ref:
rows: 5
Extra: Using index condition

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180132725, 180132779, 180138650, 180143603, 180209688)

750μ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)51
Params
id: 1
select_type: SIMPLE
table: tch_post_apartment_expands
type: range
possible_keys: post_id
key: post_id
key_len: 4
ref:
rows: 5
Extra: Using index condition

select * from `tch_projects` where `tch_projects`.`id` in (2514) and `tch_projects`.`deleted_at` is null320μ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 (2514)47.97mstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 2514
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)270μ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 (27)270μ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 (27)

40.43mstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 27
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 (1105, 1178) and `tch_users`.`deleted_at` is null1.19mstch123_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)21
Params
id: 1
select_type: SIMPLE
table: tch_users
type: range
possible_keys: PRIMARY,deleted_at
key: deleted_at
key_len: 9
ref:
rows: 2
Extra: Using index condition

select * from `tch_provinces` where `tch_provinces`.`id` = 2 limit 1540μ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

620μ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

610μ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` = 27 limit 1600μstch123_dev_2020LocationHelper.php#322

Bindings	0: 27
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` = 27 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc

1.21mstch123_dev_2020District.php#34

Bindings	0: 27
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)141
Params
id: 1
select_type: SIMPLE
table: tch_wards
type: ref
possible_keys: id_district
key: id_district
key_len: 4
ref: const
rows: 14
Extra: Using index condition; Using where; Using filesort

select * from `tch_pages` where `indexed` = 5 limit 1420μ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)410μ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)410μ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 null440μ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)400μ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 1510μ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)410μ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)360μ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 null420μ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)360μ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_27' limit 1680μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_2_27
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)380μ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 (27)340μ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 null380μ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)340μ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 1320μ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_pages` where `indexed` = '5_2_27_project_2514' limit 1600μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_2_27_project_2514
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:303 18. app/Helpers/Khelper.php:2350 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)280μ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:303 23. app/Helpers/Khelper.php:2350 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 (27)310μ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:303 23. app/Helpers/Khelper.php:2350 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 (2514) and `tch_projects`.`deleted_at` is null350μ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:303 23. app/Helpers/Khelper.php:2350 24. app/Services/Page/PageService.php:448 25. app/Services/Page/PageService.php:32

- 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_estates` where `tch_estates`.`id` in (5)290μ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:303 23. app/Helpers/Khelper.php:2350 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 1260μ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:2355 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 1350μ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)230μ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)230μ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 null280μ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)230μ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

590μ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)

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_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)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_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 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