Đă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ư Phường 11, Quận 5 Mới Nhất T4/2025 | Trang 5

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

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

5

Cần cho thuê căn hộ Tản Đà Q5 3pn 14tr/th, lầu cao view hướng mát

13 triệu/tháng 105m² 3 pn 2 wc

Tản Đà Court Quận 5, Hồ Chí Minh

Căn hộ chung cư Tản Đà quận 5, cần cho thuê 3 phòng ngủ, 2wc, trang bị nội thất đầy đủ, lầu cao view hướng mát, gần nhiều tiện ích xung quanh, gần ĐHYD. Giá cho thuê 13tr/th, các bạn có nhu cầu gọi ngay cho Lam 0931870369 để biết thêm

Đăng 2 năm trước
1

Cho thuê căn hộ chung cư Tản Đà Court Q5. 100m, 3PN, đầy đủ nội thất, hướng mát,tầng…

14 triệu/tháng 100m² 3 pn 2 wc

Tản Đà Court Quận 5, Hồ Chí Minh

Cho thuê căn hộ chung cư Tản Đà Court Q5 Diện tích sử dụng 100m2, có 3PN, đầy đủ nội thất, hướng mát, tầng cao. Vị trí ngay góc đường tản đà với nguyễn trãi, có nhiều tiện ích xung quanh, giao thông thuận tiện. Giá thuê 14tr/th…

Đăng 2 năm trước
5

Căn hộ Tản Đà ngay ĐHYD, cần cho thuê, 3pn, ntdd, giá 13tr/th

13 triệu/tháng 100m² 3 pn 2 wc

Tản Đà Court Quận 5, Hồ Chí Minh

Cho thuê căn hộ chung cư Tản đà quận 5 mặt tiền đường Tản Đà Nguyễn Trãi, diện tích 100m2, thiết kế 3 phòng ngủ, 2wc, nội thất đầy đủ, view hướng mát. Gần rất nhiều tiện ích sinh hoạt, gần các trường ĐH, trong đó gần nhất…

Đăng 2 năm trước
1

Cho thuê Chung cư Sao Mai tại Quận 5 căn 85m2, 2 phòng ngủ, 2wc giá 12 Triệu/Tháng

12 triệu/tháng 85m² 2 pn 2 wc

Chung cư Sao Mai Quận 5, Hồ Chí Minh

Cho thuê Chung cư Sao Mai tọa lạc tại Đường Lương Nhữ Học, Phường 11, Quận 5 Diện tích sử dụng: 85m2 nhà rộng rãi sinh hoạt thoải mái Kết cấu gồm: 1pk, 1pb, 2pn 2wc Nhà đẹp sạch sẽ và có full nội thất mới tinh nên thích hợp cho…

Đăng 2 năm trước
3

Căn hộ ngay Đại Học Y Dược Q5 cho thuê 3 phòng ngủ 2wc, nội thất đầy đủ giá 13tr/th

13 triệu/tháng 100m² 3 pn 2 wc

Tản Đà Court Quận 5, Hồ Chí Minh

Căn hộ chung cư Tản Đà gần đại học y dược Q5 cần cho thuê -Diện tích 100m2, thiết kế 3 phòng ngủ, 2wc, view nhìn Tản Đà -Gần trường học, bệnh viện, trung tâm thương mai, chợ, 5-10’ đến Q1 3 6 10 11.. -Ngay tuyến đường trung tâm…

Đăng 3 năm trước
6

Căn hộ Tản Đà quận 5 cho thuê 3pn, có nội thất, giá chỉ 13tr/th

13 triệu/tháng 100m² 3 pn 2 wc

Tản Đà Court Quận 5, Hồ Chí Minh

Vừa hết hợp đồng nên cần cho thuê căn hộ Tản Đà ngay đại học y dược, góc Tản Đà Nguyễn Trãi, diện tích 3 phòng ngủ, 2wc, nội thất đầy đủ, tiện ích nội khu cũng như xung quanh rất thuận tiện, giao thông đi lại thông thoáng…

Đăng 3 năm trước
1

Cần cho thuê gấp căn hộ Sao Mai đường Lương Nhữ Học Quận 5. Diện tích 90m2, 2pn,2wc

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

Chung cư Sao Mai Quận 5, Hồ Chí Minh

Cần cho thuê gấp căn hộ Sao Mai đường Lương Nhữ Học Quận 5. Diện tích 90m2, 2pn,2wc ,lầu cao nhà đẹp, thoáng mát, cách trung tâm Quận 1 5 phút, thuận tiện đi lại. Giá 10 tr/th. LH : Nguyên 0888596063 - 0775788725.

Đăng 3 năm trước

« Trang trước
1
4
5
Trang sau »

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

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

Queries179 Models490

Request history7MB

179 statements were executed, 135 of which were duplicates, 44 unique. Show only duplicated171ms

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` = '/ho-chi-minh/quan-5/phuong-11.html' limit 12.52mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /ho-chi-minh/quan-5/phuong-11.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 1690μ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` = 'ho-chi-minh/quan-5/phuong-11' limit 1620μstch123_dev_2020PageHelper.php#100

Bindings	0: ho-chi-minh/quan-5/phuong-11
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)510μ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 (17)280μstch123_dev_2020PageHelper.php#100

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

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

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

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

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

select * from `tch_estates` where `tch_estates`.`id` in (5)740μ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` = 'ho-chi-minh/quan-5/phuong-11' limit 1280μstch123_dev_2020PageHelper.php#100

Bindings	0: ho-chi-minh/quan-5/phuong-11
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)240μstch123_dev_2020PageHelper.php#100

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

- EXPLAIN # 1: `tch_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 (17)240μstch123_dev_2020PageHelper.php#100

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

- EXPLAIN # 1: `tch_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 null270μstch123_dev_2020PageHelper.php#100

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

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

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

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

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

select `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc270μ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 1300μ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 `ward_id` = 223 and `district_id` = 17 and `province_id` = 1 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null

18.18mstch123_dev_2020PageService.php#365

Bindings	0: 223 1: 17 2: 1 3: approved 4: 1 5: 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)7081

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at,district_id_published_status_out_of_service_deleted_at
key: district_id_published_status_out_of_service_deleted_at
key_len: 317
ref: const,const,const,const,const
rows: 708
Extra: Using index condition; Using where

- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_post_apartment_details
type: ref
possible_keys: post_id
key: post_id
key_len: 4
ref: tch123_dev_2020.tch_posts.id
rows: 1
Extra: Using where; Using index

select `tch_posts`.* from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `ward_id` = 223 and `district_id` = 17 and `province_id` = 1 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 80

3.67mstch123_dev_2020PageService.php#365

Bindings	0: 223 1: 17 2: 1 3: approved 4: 1 5: 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)7081

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at,district_id_published_status_out_of_service_deleted_at
key: district_id_published_status_out_of_service_deleted_at
key_len: 317
ref: const,const,const,const,const
rows: 708
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 where; Using index

select * from `tch_packages` where `tch_packages`.`id` in (31)290μ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 (180130151, 180140616, 180143279, 180144682, 180147132, 180148673, 180151795)

510μ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)71
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: 7
Extra: Using index condition

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180130151, 180140616, 180143279, 180144682, 180147132, 180148673, 180151795)

2.17mstch123_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)71
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: 7
Extra: Using index condition

select * from `tch_projects` where `tch_projects`.`id` in (533, 534) and `tch_projects`.`deleted_at` is null900μ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)21
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 2
Extra: Using where

select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (533, 534)69.16mstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 533 3: 534
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)400μ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)

640μ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 (17)450μ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 (17)

590μstch123_dev_2020PageService.php#365

Bindings	0: 0 1: 0 2: 0 3: 17
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, 1237, 1395, 1909) and `tch_users`.`deleted_at` is null1.04mstch123_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)41
Params
id: 1
select_type: SIMPLE
table: tch_users
type: range
possible_keys: PRIMARY,deleted_at
key: deleted_at
key_len: 9
ref:
rows: 4
Extra: Using index condition

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

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

550μ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` = 17 limit 1440μstch123_dev_2020LocationHelper.php#322

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

470μstch123_dev_2020District.php#34

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

select * from `tch_pages` where `indexed` = 5 limit 1440μ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)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: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)270μ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 null430μ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)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: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 1430μ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)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: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)270μ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 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: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)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: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_17' limit 1480μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_1_17
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)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: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 (17)250μ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 null320μ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)260μ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_pages` where `indexed` = '5_1_17_ward_223' limit 1380μstch123_dev_2020PageHelper.php#23

Bindings	0: 5_1_17_ward_223
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:222 18. app/Helpers/Khelper.php:2308 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)270μ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:222 23. app/Helpers/Khelper.php:2308 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 (17)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:222 23. app/Helpers/Khelper.php:2308 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 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/Models/Page.php:222 23. app/Helpers/Khelper.php:2308 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)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/Models/Page.php:222 23. app/Helpers/Khelper.php:2308 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 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. app/Helpers/Khelper.php:2312 23. app/Services/Page/PageService.php:448 24. app/Services/Page/PageService.php:32 25. app/Http/Controllers/PageController.php:42

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

select * from `tch_wards` where `tch_wards`.`id` = 0 limit 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:2317 23. app/Services/Page/PageService.php:448 24. app/Services/Page/PageService.php:32 25. app/Http/Controllers/PageController.php:42

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

select * from `tch_wards` where `tch_wards`.`id` = 223 limit 1250μstch123_dev_2020Khelper.php#2337

Bindings	0: 223
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/Helpers/Khelper.php:2337 22. app/Services/Page/PageService.php:448 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_wards` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_wards
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_wards` where `tch_wards`.`id` = 223 limit 1240μstch123_dev_2020Page.php#366

Bindings	0: 223
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:2338 23. app/Services/Page/PageService.php:448 24. app/Services/Page/PageService.php:32 25. app/Http/Controllers/PageController.php:42

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

select * from `tch_pages` where `indexed` = '5_1' limit 1400μ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)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_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)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/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 null270μ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)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/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

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

290μ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)350μ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 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 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 1360μ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 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 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. 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