Đă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ư Topaz City Mới Nhất T4/2025

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

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

9

Căn hộ cho thuê full nội thất sang xịn, giá rẻ. Hổ trợ phí quản lý

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

Topaz City Quận 8, Hồ Chí Minh

Em cần cho thuê căn hộ mới siêu đẹp block B1 dự án chung cư Topaz City - Hướng: Đông Nam - view quận 1 mát mẻ (không sợ nắng chiều). - Diện Tích: 70m2 - 2PN 2WC. - Nội thất: Full 100% nội thất (cam kết hài lòng khi xem nhà). - Nhà ở…

Đă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ả
Quận 1
Quận 2
Quận 3
Quận 4
Quận 5
Quận 6
Quận 7
Quận 8
Quận 9
Quận 10
Quận 11
Quận 12
Bình Tân
Bình Thạnh
Gò Vấp
Phú Nhuận
Tân Bình
Tân Phú
Thủ Đức
Bình Chánh
Cần Giờ
Củ Chi
Hóc Môn
Nhà Bè

Tất cả
Phường 1
Phường 2
Phường 3
Phường 4
Phường 5
Phường 6
Phường 7
Phường 8
Phường 9
Phường 10
Phường 11
Phường 12
Phường 13
Phường 14
Phường 15
Phường 16

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

Queries151 Models451

Request history6MB

151 statements were executed, 106 of which were duplicates, 45 unique. Show only duplicated97.46ms

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-topaz-city.html' limit 13.7mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /cho-thue-can-ho-topaz-city.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 1490μ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-topaz-city' limit 1760μstch123_dev_2020PageHelper.php#100

Bindings	0: cho-thue-can-ho-topaz-city
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 (1)400μ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 (20)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_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 (750) and `tch_projects`.`deleted_at` is null620μ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)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_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-topaz-city' limit 1650μstch123_dev_2020PageHelper.php#100

Bindings	0: cho-thue-can-ho-topaz-city
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 (1)310μ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 (20)290μ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 (750) and `tch_projects`.`deleted_at` is null350μ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)290μ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` asc350μ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 1310μ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` = 750 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.66mstch123_dev_2020PageService.php#365

Bindings	0: 3000000 1: 750 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)681

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: 68
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` = 750 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

2.48mstch123_dev_2020PageService.php#365

Bindings	0: 3000000 1: 750 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)681

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: 68
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)420μ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 (180129272)530μ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 (180129272)650μ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 (750) and `tch_projects`.`deleted_at` is null310μ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 (750)30.13mstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 750
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 (1)340μ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 (1)

460μstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 0 4: 1
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 (20)310μ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 (20)

420μstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 20
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) and `tch_users`.`deleted_at` is null400μ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` = 1 limit 1330μstch123_dev_2020LocationHelper.php#266

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	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 (1) order by `ordering` asc, `id_province` asc, `name` asc

380μ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)241
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: ref
possible_keys: id_province
key: id_province
key_len: 4
ref: const
rows: 24
Extra: Using where; Using filesort

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

400μstch123_dev_2020Province.php#28

Bindings	0: 1
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)241
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: ref
possible_keys: id_province
key: id_province
key_len: 4
ref: const
rows: 24
Extra: Using index condition; Using where; Using filesort

select * from `tch_districts` where `tch_districts`.`id` = 20 limit 1290μstch123_dev_2020LocationHelper.php#322

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

430μstch123_dev_2020District.php#34

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

select * from `tch_pages` where `indexed` = 5 limit 1460μ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)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/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)220μ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 null310μ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)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/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_1' limit 1320μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_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	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 (1)220μ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)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_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_1_20' limit 1430μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_1_20
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 (1)300μ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 (20)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: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 null260μ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)220μ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 1400μ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_1_20_project_750' limit 1500μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_1_20_project_750
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 (1)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: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 (20)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: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 (750) and `tch_projects`.`deleted_at` is null390μ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)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_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 1240μ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_1' limit 1310μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_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	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 (1)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/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 null360μ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)240μ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` = 1 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

930μstch123_dev_2020Page.php#245

Bindings	0: 5 1: 1 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)10991

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: 1099
Extra: Using index condition; Using where; Using filesort

select * from `tch_provinces` where `tch_provinces`.`id` in (1)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_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 (1, 2, 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)

390μ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)221
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 22
Extra: Using where

select * from `tch_estates` where `tch_estates`.`id` in (5)390μ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 1400μ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 1300μ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 1300μ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 1250μ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 1300μ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 1240μ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 1280μ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 1310μ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 1310μ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 1250μ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 1290μ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 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. 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 1300μ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 1300μ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 1290μ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