Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Thuê chung cư một tháng bao nhiêu tiền? Gợi ý các dự án TPHCM - Hà Nội giá rẻ

Được đăng bởi Nguyễn Hà Thu

Cập nhật lúc: Thứ năm, 16:31 19/10/2023

Khoảng 96.800.000 kết quả trả về trong 0,39 giây từ công cụ tìm kiếm Google liên quan đến từ khóa “thuê chung cư một tháng bao nhiêu tiền”. Đúng vậy, không ít người mong muốn chuyển đổi chỗ ở mới, nhất là sang loại hình căn hộ, nhưng còn ái ngại nhiều với chuyện chi phí. Vậy hôm nay hãy cùng theo dõi bài viết dưới đây của Thuecanho123 - kênh cho thuê căn hộ chung cư số 1 Việt Nam hiện nay, để biết chính xác từng khu vực có những khung giá thuê ra sao nhé.

Mục lục

Thuê căn hộ bao nhiêu tiền 1 tháng?
Gợi ý các dự án giá rẻ nên thuê ở Hà Nội và TPHCM
- 3 căn hộ cho thuê giá rẻ tại TPHCM
- 3 chung cư cho thuê giá rẻ tại Hà Nội

Thuê căn hộ bao nhiêu tiền 1 tháng?

Tùy theo từng khu vực mà giá thuê căn hộ 1 tháng sẽ tiêu tốn khác nhau, nhưng giá trung bình hiện nay là từ 6 - 15 triệu đồng/tháng. Để cụ thể hơn cho từng khu vực, mời bạn xem cập nhật giá thuê mới nhất dưới đây.

1. Giá cho thuê căn hộ tại TPHCM

Khu vực TPHCM, có đến hàng triệu lao động đang sinh sống và làm việc tại đây, chính vì thế nhu cầu về nơi lưu trú luôn trong mức cao, giá thuê căn hộ tại đây cũng được đánh giá là cao. Cụ thể:

- Giá thuê căn hộ tại trung tâm TPHCM: 10 - 30 triệu/tháng

- Giá thuê căn hộ tại ngoại thành TPHCM: 4 - 15 triệu/tháng

Tại TPHCM để thuê căn hộ giá rẻ, khách hàng có thể tham khảo các khu vực quận gồm: Thủ Đức, Bình Tân, Tân Bình, Bình Chánh, Tân Phú, Quận 12, Quận 9. Cần thuê căn hộ trung tâm để tiện sinh sống và làm việc có thể tham khảo: Bình Thạnh, Phú Nhuận, Quận 1, Quận 2, Quận 3, Quận 10.

2. Giá cho thuê chung cư tại Hà Nội

Tương tự TPHCM, Hà Nội cũng là một trong những khu vực thu hút hàng triệu lao động đến sinh sống. Vì thế giá thuê chung cư Hà Nội mỗi tháng cũng duy trì ở mức cao.

- Giá thuê chung cư trung tâm Hà Nội: 9 - 25 triệu/tháng

- Giá thuê chung cư ngoại thành Hà Nội: 3.8 - 12 triệu/tháng

Có thể thấy ngay, giá cho thuê chung cư ở Hà Nội thấp hơn từ 2 - 3 triệu đồng/tháng so với khu vực TPHCM. Tuy nhiên nhìn chung hai thành phố lớn này đều duy trì mức giá cho thuê căn hộ mỗi tháng ở mức khá cao, trừ các khu vực vùng ven, các khu vực huyện.

3. Giá cho thuê chung cư khu vực miền Trung

Đối với khu vực miền Trung sẽ chủ yếu chia ra hai loại hình, một là căn hộ cao cấp, phục vụ nhu cầu ngắn hạn nghỉ dưỡng cho khách du lịch, khách vãng lai công tác ngắn ngày. Hai là căn hộ thường là dự án NOXH (Nhà ở xã hội) phục vụ cho nhu cầu ở thực của các lao động trong tỉnh cũng như ngoài tỉnh đến thuê sống lâu dài. Giá cụ thể như sau:

- Giá thuê căn hộ cao cấp khu vực miền Trung: 7 - 20 triệu/tháng

- Giá thuê căn hộ bình dân khu vực miền Trung: 3.5 - 8 triệu/tháng

Mức chênh này thường khá cao, nhất là các tỉnh thành phát triển du lịch biển. Những căn hộ hạng sang ven biển có giá thuê mỗi đêm vài triệu đồng, chính vì thế cho thuê dài hạn theo tháng cũng luôn ở mức cao. Các tỉnh thành như Đà Nẵng, Phú Yên, Quảng Ngãi thì mức chênh của hai loại này khá lớn.

Gợi ý các dự án giá rẻ nên thuê ở Hà Nội và TPHCM

Nếu bạn đang có ý định chuyển sang thuê căn hộ để sống, sau khi biết được giá thuê chung cư một tháng bao nhiêu tiền, thì Thuecanho123.com tiếp tục mang đến cho bạn những gợi ý về dự án có giá thuê rẻ hiện nay ở hai khu vực là TPHCM và Hà Nội.

3 căn hộ cho thuê giá rẻ tại TPHCM

1. Dự án Vinhomes Grand Park - Quận 9

- Địa chỉ: đường Nguyễn Xiển, phường Long Thạch Mỹ, thành phố Thủ Đức (Quận 9 cũ), thành phố Hồ Chí Minh.

- Giá thuê trung bình: 4 - 10 triệu/tháng.

- Phí quản lý và gửi xe (xe máy): 8.800 đồng/m2 | 150.000 nghìn đồng/chiếc.

- Tiện ích: TTTM, bệnh viện, trường học các cấp, hồ bơi, công viên, biển nhân tạo, sân tập thể thao đa các môn phối hợp đến riêng lẻ…

Xem chi tiết dự án Vinhomes Grand Park cho thuê tại: https://thuecanho123.com/cho-thue-can-ho-chung-cu-vinhomes-grand-park-quan-9-gia-re-chinh-chu.html

2. Dự án West Gate Park - Bình Chánh

- Địa chỉ: trung tâm hành chính Tây Sài Gòn – mặt tiền đường 349 đường Tân Túc, thị trấn Tân Túc, huyện Bình Chánh, TP Hồ Chí Minh

- Giá thuê trung bình: 5.5 - 14 triệu/tháng

- Phí quản lý và gửi xe (xe máy): 12.000 đồng/m2 | 110.000 nghìn đồng/chiếc.

- Tiện ích: hồ bơi, phòng gym, yoga, sân tennis, phòng golf giả lập, công viên…

Xem chi tiết dự án West Gate Park cho thuê tại: https://thuecanho123.com/cho-thue-can-ho-chung-cu-west-gate-park.html

3. Dự án Akari City - Bình Tân

- Địa chỉ: 77 đường Võ Văn Kiệt, phường An Lạc, quận Bình Tân, thành phố Hồ Chí Minh.

- Giá thuê trung bình: 6 - 12 triệu/tháng.

- Phí quản lý và gửi xe (xe máy): 15.000 đồng/m2 | 120.000 nghìn đồng/chiếc.

- Tiện ích: hồ bơi, siêu thị, khu vui chơi giải trí, Gym…

Xem chi tiết dự án Akari City tại: https://thuecanho123.com/cho-thue-can-ho-chung-cu-akari-city.html

3 chung cư cho thuê giá rẻ tại Hà Nội

1. Dự án Vinhomes Ocean Park - Gia Lâm

- Địa chỉ: xã Đa Tốn, xã Kiêu Kỵ, xã Dương Xá và một phần thị trấn Trâu Quỳ thuộc huyện Gia Lâm, Hà Nội

- Giá thuê trung bình: 4 - 10 triệu/tháng

- Phí quản lý và gửi xe (xe máy): 11 - 18 nghìn đồng/m2 | 45.000 nghìn đồng/chiếc.

- Tiện ích: Vui chơi biển hồ, đa loại sân thể thao: Cầu lông, bóng rổ, tennis, bóng chuyền, câu cá, công viên Gym, TTTM Vincom Mega Mall, trường các cấp bao gồm cả đại học…

Xem chi tiết dự án Vinhomes Ocean Park: https://thuecanho123.com/cho-thue-can-ho-chung-cu-vinhomes-ocean-park-huyen-gia-lam-gia-re-chinh-chu.html

2. Dự án Rose Town - Hoàng Mai

- Địa chỉ: Số 79 đường Ngọc Hồi, quận Hoàng Mai, Hà Nội

- Giá thuê trung bình: 5 - 10 triệu/tháng

- Phí quản lý và gửi xe (xe máy): 7.000 đồng/m2 | 80.000 nghìn đồng/chiếc.

- Tiện ích: TTTM, bể bơi, nhà hàng, công viên, GYM&SPA…

Xem chi tiết dự án Rose Town cho thuê tại: https://thuecanho123.com/cho-thue-can-ho-chung-cu-rose-town.html

3. Dự án THT New City - Hoài Đức

- Địa chỉ: thôn Lai Xá, xã Kim Chung, huyện Hoài Đức, Hà Nội

- Giá thuê trung bình: 5 - 9 triệu/tháng

- Phí quản lý và gửi xe (xe máy): cập nhật

- Tiện ích: TTTM, Gym&Spa, ngân hàng, công viên, nhà trẻ…

Xem chi tiết dự án THT New City cho thuê tại: https://thuecanho123.com/cho-thue-can-ho-chung-cu-tht-new-city.html

Hy vọng thông qua bài viết “Thuê chung cư một tháng bao nhiêu tiền? Gợi ý các dự án TPHCM - Hà Nội giá rẻ”, bạn đọc đã có cho mình nhiều thông tin hữu ích, và những gợi ý liên quan đến các dự án căn hộ cho thuê hiện nay.

Bài viết xem nhiều

Tin đăng mới cập nhật

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ả

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

Queries61 Models247

Request history8MB

61 statements were executed, 28 of which were duplicates, 33 unique. Show only duplicated52.17ms

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` = '/thue-chung-cu-mot-thang-bao-nhieu-tien-goi-y-cac-du-an-tphcm-ha-noi-gia-re-post738.html' limit 1

2.12mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /thue-chung-cu-mot-thang-bao-nhieu-tien-goi-y-cac-du-an-tphcm-ha-noi-gia-re-post738.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_articles` where `tch_articles`.`id` = '738' and `tch_articles`.`deleted_at` is null limit 1830μstch123_dev_2020ArticleHelper.php#24

Bindings	0: 738
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/ArticleHelper.php:24 21. app/Helpers/Khelper.php:236 22. middleware::article.hook:14 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 24. app/Http/Middleware/LastUserActivity.php:25

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

select * from `tch_articles` where `slug` = 'thue-chung-cu-mot-thang-bao-nhieu-tien-goi-y-cac-du-an-tphcm-ha-noi-gia-re' and `tch_articles`.`deleted_at` is null limit 1

570μstch123_dev_2020ArticleController.php#13

Bindings	0: thue-chung-cu-mot-thang-bao-nhieu-tien-goi-y-cac-du-an-tphcm-ha-noi-gia-re
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/Http/Controllers/ArticleController.php:13 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

- EXPLAIN # 1: `tch_articles` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_articles
type: ref
possible_keys: slug,deleted_at
key: slug
key_len: 767
ref: const
rows: 1
Extra: Using index condition; Using where

update `tch_articles` set `views` = 796 where `id` = 738890μstch123_dev_2020ArticleController.php#24

Bindings	0: 796 1: 738
Backtrace	14. app/Http/Controllers/ArticleController.php:24 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

select * from `tch_pages` where `tch_pages`.`id` = 372213 limit 1570μstch123_dev_2020PageHelper.php#58

Bindings	0: 372213
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. app/Observers/ArticleObserver.php:28 29. app/Http/Controllers/ArticleController.php:24 30. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54

- 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:

update `tch_pages` set `tch_pages`.`updated_at` = '2025-04-07 23:01:04' where `id` = 37221317.9mstch123_dev_2020ArticleObserver.php#30

Bindings	0: 2025-04-07 23:01:04 1: 372213
Backtrace	14. app/Observers/ArticleObserver.php:30 21. app/Http/Controllers/ArticleController.php:24 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `tch_articles` where `category_id` = 13 and `published` = 1 and `tch_articles`.`id` <> 738 and `tch_articles`.`deleted_at` is null limit 6

920μstch123_dev_2020ArticleHelper.php#122

Bindings	0: 13 1: 1 2: 738
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	15. app/Helpers/ArticleHelper.php:122 16. app/Http/Controllers/ArticleController.php:29 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

- EXPLAIN # 1: `tch_articles` (SIMPLE)6641

Params

id: 1
select_type: SIMPLE
table: tch_articles
type: ref
possible_keys: PRIMARY,published_deleted_at,category_id,deleted_at
key: category_id
key_len: 4
ref: const
rows: 664
Extra: Using index condition; Using where

select * from `tch_users` where `tch_users`.`id` = 2750 and `tch_users`.`deleted_at` is null limit 1860μstch123_dev_2020article.blade.php#10

Bindings	0: 2750
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. view::_desktop.main.article.article:10 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 26. vendor/laravel/framework/src/Illuminate/View/View.php:208

- 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_global_option` where `name` = 'use_avatar_social' limit 1360μstch123_dev_2020Setting.php#23

Bindings	0: use_avatar_social
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/Models/User.php:169 17. view::_desktop.main.article.article:31 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'use_replace_highlight' limit 1360μstch123_dev_2020Setting.php#23

Bindings	0: use_replace_highlight
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/Helpers/Khelper.php:1505 17. view::_desktop.main.article.article:53 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_articles` where `published` = 1 and `is_most_viewed` = 1 and `tch_articles`.`deleted_at` is null order by `created_at` desc limit 5

3.99mstch123_dev_2020ArticleHelper.php#173

Bindings	0: 1 1: 1
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. app/Helpers/ArticleHelper.php:173 16. app/Helpers/ArticleHelper.php:182 17. view::_desktop.main.article.article:73 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- EXPLAIN # 1: `tch_articles` (SIMPLE)6641

Params

id: 1
select_type: SIMPLE
table: tch_articles
type: ref
possible_keys: published_deleted_at,deleted_at
key: deleted_at
key_len: 5
ref: const
rows: 664
Extra: Using index condition; Using where; Using filesort

select `tch_posts`.* from `tch_posts` where not exists (select * from `tch_promote_post_histories` where `tch_posts`.`id` = `tch_promote_post_histories`.`post_id` and `type` = 'RECREATEPOST' and `tch_promote_post_histories`.`deleted_at` is null) and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`status` = 'approved' and `tch_posts`.`deleted_at` is null order by `tch_posts`.`created_at` desc limit 10

560μstch123_dev_2020PostHelper.php#621

Bindings	0: RECREATEPOST 1: 1 2: 0 3: approved
Backtrace	15. app/Helpers/PostHelper.php:621 16. view::_desktop.main.post.post-tin-moi-dang:3 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_posts` (PRIMARY)201

Params

id: 1
select_type: PRIMARY
table: tch_posts
type: index
possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at
key: created_at
key_len: 5
ref:
rows: 20
Extra: Using where

- EXPLAIN # 2: `tch_promote_post_histories` (MATERIALIZED)3435592
Params
id: 2
select_type: MATERIALIZED
table: tch_promote_post_histories
type: ALL
possible_keys: post_id,type,deleted_at
key:
key_len:
ref:
rows: 343559
Extra: Using where

select * from `tch_packages` where `tch_packages`.`id` in (31, 33, 34, 37)380μstch123_dev_2020PostHelper.php#621

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Helpers/PostHelper.php:621 21. view::_desktop.main.post.post-tin-moi-dang:3 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_packages` (SIMPLE)71
Params
id: 1
select_type: SIMPLE
table: tch_packages
type: ALL
possible_keys: PRIMARY
key:
key_len:
ref:
rows: 7
Extra: Using where

select * from `tch_provinces` where `tch_provinces`.`id` in (1, 2)340μstch123_dev_2020PostHelper.php#621

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Helpers/PostHelper.php:621 21. view::_desktop.main.post.post-tin-moi-dang:3 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)21
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 2
Extra: Using where

select * from `tch_districts` where `tch_districts`.`id` in (9, 11, 14, 21, 27)330μstch123_dev_2020PostHelper.php#621

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Helpers/PostHelper.php:621 21. view::_desktop.main.post.post-tin-moi-dang:3 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)51
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 5
Extra: Using where

select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223418, 180223419, 180223420, 180223421, 180223423, 180223424, 180223425, 180223429, 180223432, 180223433)

330μstch123_dev_2020PostHelper.php#621

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Helpers/PostHelper.php:621 21. view::_desktop.main.post.post-tin-moi-dang:3 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_post_apartment_details` (SIMPLE)101
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: 10
Extra: Using index condition

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

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1270μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1270μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1280μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1270μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1260μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1250μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1270μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1250μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23

Bindings	0: using_google_cached_image
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/Models/Post.php:197 17. view::_desktop.main.post.post-item-aside:15 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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 * from `tch_pages` where `indexed` = '5_1' limit 1330μ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.main_menu:3 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)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/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:3 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)200μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:3 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.main_menu:3 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)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/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:3 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

880μ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.main_menu:4 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.main_menu:4 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)

330μ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.main_menu:4 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)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.main_menu:4 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_pages` where `indexed` = '5_2' limit 1300μstch123_dev_2020PageHelper.php#23

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

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

select * from `tch_provinces` where `tch_provinces`.`id` in (2)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/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:6 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)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/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:6 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

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

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:6 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)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/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:6 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

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

530μstch123_dev_2020Page.php#245

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

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

Params

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

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

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

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

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

220μ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.main_menu:7 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

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

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

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Models/Page.php:245 21. view::_desktop.main.includes.main_menu:7 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_pages` where `indexed` = '5_3' limit 17.85mstch123_dev_2020PageHelper.php#23

Bindings	0: 5_3
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.main_menu:9 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 (3)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.main_menu:9 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.main_menu:9 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

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

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

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

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

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

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/Helpers/Khelper.php:890 23. view::_desktop.main.includes.main_menu:9 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` = 3 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

420μstch123_dev_2020Page.php#245

Bindings	0: 5 1: 3 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.main_menu:10 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)2221

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

select * from `tch_provinces` where `tch_provinces`.`id` in (3)210μ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.main_menu:10 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 (56, 58, 60, 61, 62)220μ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.main_menu:10 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)51
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 5
Extra: Using where

select * from `tch_estates` where `tch_estates`.`id` in (5)220μ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.main_menu:10 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_promotions` where `published` = 1 and date(`date_begin`) <= '2025-04-07' and date(`date_end`) >= '2025-04-07' order by `priority` desc limit 1

240μstch123_dev_2020header_user_not_login.blade.php#3

Bindings	0: 1 1: 2025-04-07 2: 2025-04-07
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	16. view::_desktop.main.includes.header_user_not_login:3 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 21. vendor/laravel/framework/src/Illuminate/View/View.php:208

- EXPLAIN # 1: `tch_promotions` (SIMPLE)121
Params
id: 1
select_type: SIMPLE
table: tch_promotions
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12
Extra: Using where; Using filesort

select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1270μ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/LocationHelper.php:185 19. app/Helpers/Khelper.php:2797 20. view::_desktop.main.includes.filter_box:2 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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

460μ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/LocationHelper.php:185 24. app/Helpers/Khelper.php:2797 25. view::_desktop.main.includes.filter_box:2 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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

470μ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/Helpers/LocationHelper.php:186 18. app/Helpers/Khelper.php:2797 19. view::_desktop.main.includes.filter_box:2 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

- 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_provinces` where `tch_provinces`.`id` = 2 limit 1390μstch123_dev_2020LocationHelper.php#266

Bindings	0: 2
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. app/Helpers/LocationHelper.php:266 18. app/Helpers/LocationHelper.php:185 19. app/Helpers/Khelper.php:2797 20. view::_desktop.main.includes.filter_box:3 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

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

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

460μ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/LocationHelper.php:185 24. app/Helpers/Khelper.php:2797 25. view::_desktop.main.includes.filter_box:3 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

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

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

440μstch123_dev_2020Province.php#28

Bindings	0: 2
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	16. app/Models/Province.php:28 17. app/Helpers/LocationHelper.php:186 18. app/Helpers/Khelper.php:2797 19. view::_desktop.main.includes.filter_box:3 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

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

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

Bindings	0: address
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. view::_desktop.main.includes.footer:50 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- 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:

App\Models\District: 156District.php#?
App\Models\Page: 47Page.php#?
App\Models\Article: 13Article.php#?
App\Models\Province: 10Province.php#?
App\Models\PostCanHoDetail: 10PostCanHoDetail.php#?
App\Models\Estate: 6Estate.php#?
App\Models\Package: 4Package.php#?
App\Models\User: 1User.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-07 23:01:04	GET	/thue-chung-cu-mot-thang-bao-nhieu-tien-goi-y-cac-du-an-tphcm-ha-noi-gia-re-post738.html	61 247