Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Tran Nam

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

19

Giá tốt 2pn 9-11tr, 3pn 11-19tr, full nội thất Skyline giá tốt cho thuê Quận 7

9 triệu/tháng 60m² 2 pn 1 wc

An Gia Skyline Quận 7, Hồ Chí Minh

CHO THUÊ CĂN HỘ SKYLINE QUẬN 7 - ĐẦY ĐỦ NỘI THẤT 2 phòng ngủ, 2 nhà vệ sinh, giá thuê 9-11 triệu, đã được trang bị đầy đủ nội thất. 3 phòng ngủ, giá thuê 11-19 triệu, cung cấp cả nội thất đầy đủ và có tùy chọn nội thất…

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

18-20tr 1PN Hado Centrosa Quận 10 cho thuê nhanh

19 triệu/tháng 61m² 1 pn 1 wc

Hado Centrosa Garden Quận 10, Hồ Chí Minh

- 1PN chỉ 18-20tr - 2PN 23-26tr Hado Centrosa giá tốt cho thuê nhanh Quận 10 - Thông tin chính Diện tích sử dụng: 61 m2 1PN - Nhà đẹp - Bao phí quản lý thương lượng cho khách xem sớm Dự án cao cấp: Hà Đô Centrosa, Kingdom 101, Sunshine Continental.

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

The Marq giá tốt 1 pn 2 pn nội thất chủ đầu tư 24 - 30tr, full nội thất 28 - 40tr, Quận 1 cho thuê

28 triệu/tháng 61m² 1 pn 1 wc

The Marq Quận 1, Hồ Chí Minh

- Thông tin The MARQ: 1PN 25-29tr giá tốt 2PN chỉ 35-45tr nội thất cao cấp 3PN nhà trống 50-55tr - Thông tin căn hộ: Diện tích sử dụng 60 m2 1 Phòng ngủ, 1 Nhà tắm - Giá tốt cho khách move in sớm - Bao phí cho khách xem sớm. Trung tâm Quận…

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

Giá tốt 3 pn 2 pn cho thuê nhanh - full nội thất 14 - 17tr, 11 - 14tr River Panorama Quận 7

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

River Panorama Quận 7, Hồ Chí Minh

River Panorama 2PN full 11.5-13tr, 3PN 14-17tr full nội thất thuê nhanh Quận 7 Địa chỉ: Hoàng Quốc Việt, Phường Phú Thuận, Quận 7, TPHCM - Thông tin chính Diện tích sử dụng: 90 m2 Phòng ngủ: 3 ; Nhà tắm 2 ; Pháp lý: Hợp đồng mua bán Phí…

Đăng 4 tháng trước

Sao chép đường dẫn tin đăng

https://thuecanho.lbkdev.com/0866089092

Lý do phản ánh:

Ảnh đại diện vi phạm

Thông tin cá nhân vi phạm

Người đăng tin có dấu hiệu lừa đảo

Lý do khác

Mô tả thêm

Thông tin liên hệ

Họ tên của bạn

Số điện thoại của bạn

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ả

Dự án nổi bật

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

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

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

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

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

Queries69 Models242

Request history6MB

69 statements were executed, 35 of which were duplicates, 34 unique. Show only duplicated49.73ms

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` = '/0866089092' limit 18.14mstch123_dev_2020Khelper.php#2679

Bindings	0: 1 1: /0866089092
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_users` where `phone` = '0866089092' and `tch_users`.`deleted_at` is null limit 11.74mstch123_dev_2020UserHelper.php#20

Bindings	0: 0866089092
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/UserHelper.php:20 17. app/Helpers/Khelper.php:1764 18. middleware::user.hook:11 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 20. app/Http/Middleware/LastUserActivity.php:25

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

select * from `tch_users` where `phone` = '0866089092' and `tch_users`.`deleted_at` is null limit 1460μstch123_dev_2020UserHelper.php#20

Bindings	0: 0866089092
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/UserHelper.php:20 17. app/Helpers/Khelper.php:1764 18. app/Http/Controllers/UserController.php:23 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43

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

select count(*) as aggregate from `tch_posts` left join `tch_packages` on `tch_posts`.`package_id` = `tch_packages`.`id` where `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `user_id` = 6376 and `tch_posts`.`deleted_at` is null

750μstch123_dev_2020UserController.php#39

Bindings	0: approved 1: 1 2: 0 3: 6376
Backtrace	16. app/Http/Controllers/UserController.php:39 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_posts` (SIMPLE)41

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: out_of_service_deleted_at,user_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at
key: user_id_published_deleted_at
key_len: 13
ref: const,const,const
rows: 4
Extra: Using index condition; Using where

select `tch_posts`.* from `tch_posts` left join `tch_packages` on `tch_posts`.`package_id` = `tch_packages`.`id` where `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `user_id` = 6376 and `tch_posts`.`deleted_at` is null order by `tch_packages`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 0

1.74mstch123_dev_2020UserController.php#39

Bindings	0: approved 1: 1 2: 0 3: 6376
Backtrace	16. app/Http/Controllers/UserController.php:39 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_posts` (SIMPLE)41

Params

id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: out_of_service_deleted_at,user_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at
key: user_id_published_deleted_at
key_len: 13
ref: const,const,const
rows: 4
Extra: Using index condition; Using where; Using temporary; Using filesort

- EXPLAIN # 1: `tch_packages` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_packages
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: tch123_dev_2020.tch_posts.package_id
rows: 1
Extra: Using where

select * from `tch_packages` where `tch_packages`.`id` in (31)500μstch123_dev_2020UserController.php#39

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Http/Controllers/UserController.php:39 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 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

- 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_projects` where `tch_projects`.`id` in (550, 2488, 2556, 2763) and `tch_projects`.`deleted_at` is null

690μstch123_dev_2020UserController.php#39

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Http/Controllers/UserController.php:39 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 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

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

select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180175113, 180175114, 180175116, 180175332)

460μstch123_dev_2020UserController.php#39

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Http/Controllers/UserController.php:39 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 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)41
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: 4
Extra: Using index condition

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180175113, 180175114, 180175116, 180175332)

740μstch123_dev_2020UserController.php#39

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Http/Controllers/UserController.php:39 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 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

- EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)41
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: 4
Extra: Using index condition

select count(*) as aggregate from `tch_posts` where `tch_posts`.`user_id` = 6376 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

1.11mstch123_dev_2020User.php#256

Bindings	0: 6376
Backtrace	19. app/Models/User.php:256 20. view::_desktop.main.user.profile:34 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_posts` (SIMPLE)61
Params
id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: user_id_published_deleted_at
key: user_id_published_deleted_at
key_len: 4
ref: const
rows: 6
Extra: Using where; Using index

select * from `tch_pages` where `tch_pages`.`district_id` = 19 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

520μstch123_dev_2020post-item.blade.php#21

Bindings	0: 19 1: 0 2: 0 3: 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. view::_desktop.main.post.post-item:21 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_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` = 1 limit 1320μstch123_dev_2020Khelper.php#989

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	21. app/Helpers/Khelper.php:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 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` = 19 limit 1300μstch123_dev_2020Khelper.php#989

Bindings	0: 19
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:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- 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_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:33 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 `tch_pages`.`project_id` = 550 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

3.13mstch123_dev_2020post-item.blade.php#84

Bindings	0: 550 1: 0 2: 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. view::_desktop.main.post.post-item:84 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_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_pages` where `tch_pages`.`district_id` = 11 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

420μstch123_dev_2020post-item.blade.php#21

Bindings	0: 11 1: 0 2: 0 3: 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. view::_desktop.main.post.post-item:21 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_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` = 1 limit 1300μstch123_dev_2020Khelper.php#989

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	21. app/Helpers/Khelper.php:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 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` = 11 limit 1270μstch123_dev_2020Khelper.php#989

Bindings	0: 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	21. app/Helpers/Khelper.php:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- 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_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:33 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 `tch_pages`.`project_id` = 2556 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

3.93mstch123_dev_2020post-item.blade.php#84

Bindings	0: 2556 1: 0 2: 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. view::_desktop.main.post.post-item:84 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_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_pages` where `tch_pages`.`district_id` = 10 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

380μstch123_dev_2020post-item.blade.php#21

Bindings	0: 10 1: 0 2: 0 3: 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. view::_desktop.main.post.post-item:21 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_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` = 1 limit 1270μstch123_dev_2020Khelper.php#989

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	21. app/Helpers/Khelper.php:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 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` = 10 limit 1270μstch123_dev_2020Khelper.php#989

Bindings	0: 10
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:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- 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_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:33 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 `tch_pages`.`project_id` = 2763 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

4.61mstch123_dev_2020post-item.blade.php#84

Bindings	0: 2763 1: 0 2: 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. view::_desktop.main.post.post-item:84 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_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_pages` where `tch_pages`.`district_id` = 19 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

660μstch123_dev_2020post-item.blade.php#21

Bindings	0: 19 1: 0 2: 0 3: 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. view::_desktop.main.post.post-item:21 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_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` = 1 limit 1300μstch123_dev_2020Khelper.php#989

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	21. app/Helpers/Khelper.php:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 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` = 19 limit 1250μstch123_dev_2020Khelper.php#989

Bindings	0: 19
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:989 22. app/Models/Post.php:276 23. view::_desktop.main.post.post-item:32 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

- 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_global_option` where `name` = 'using_google_cached_image' limit 1190μ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:33 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 `tch_pages`.`project_id` = 2488 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

3.41mstch123_dev_2020post-item.blade.php#84

Bindings	0: 2488 1: 0 2: 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. view::_desktop.main.post.post-item:84 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_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_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.user.profile:77 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 count(*) as aggregate from `tch_posts` where `tch_posts`.`user_id` = 6376 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

250μstch123_dev_2020User.php#256

Bindings	0: 6376
Backtrace	19. app/Models/User.php:256 20. view::_desktop.main.user.profile:80 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73

- EXPLAIN # 1: `tch_posts` (SIMPLE)61
Params
id: 1
select_type: SIMPLE
table: tch_posts
type: ref
possible_keys: user_id_published_deleted_at
key: user_id_published_deleted_at
key_len: 4
ref: const
rows: 6
Extra: Using where; Using index

select * from `tch_abilities` where (exists (select * from `tch_roles` inner join `tch_permissions` on `tch_roles`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `tch_permissions`.`entity_type` = 'roles' and (`tch_roles`.`scope` is null) and (`tch_permissions`.`scope` is null) and (exists (select * from `tch_users` inner join `tch_assigned_roles` on `tch_users`.`id` = `tch_assigned_roles`.`entity_id` where `tch_assigned_roles`.`role_id` = `tch_roles`.`id` and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 6376 and (`tch_roles`.`scope` is null) and (`tch_assigned_roles`.`scope` is null)))) or exists (select * from `tch_users` inner join `tch_permissions` on `tch_users`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `tch_permissions`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 6376 and (`tch_abilities`.`scope` is null) and (`tch_permissions`.`scope` is null)) or exists (select * from `tch_permissions` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `entity_id` is null and (`tch_permissions`.`scope` is null))) and (`tch_abilities`.`scope` is null)

1.32mstch123_dev_2020BaseClipboard.php#101

Bindings	0: 1 1: roles 2: App\Models\User 3: 6376 4: 1 5: App\Models\User 6: 6376 7: 1
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. vendor/silber/bouncer/src/BaseClipboard.php:101 16. vendor/silber/bouncer/src/CachedClipboard.php:213 17. vendor/silber/bouncer/src/CachedClipboard.php:198 18. vendor/silber/bouncer/src/BaseClipboard.php:111 19. vendor/silber/bouncer/src/CachedClipboard.php:77

- EXPLAIN # 1: `tch_abilities` (PRIMARY)211
Params
id: 1
select_type: PRIMARY
table: tch_abilities
type: ALL
possible_keys: abilities_scope_index
key:
key_len:
ref:
rows: 21
Extra: Using where
- EXPLAIN # 5: `` (MATERIALIZED)5
Params
id: 5
select_type: MATERIALIZED
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE
- EXPLAIN # 4: `tch_users` (DEPENDENT SUBQUERY)14
Params
id: 4
select_type: DEPENDENT SUBQUERY
table: tch_users
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra: Using index

- EXPLAIN # 4: `tch_permissions` (DEPENDENT SUBQUERY)14

Params

id: 4
select_type: DEPENDENT SUBQUERY
table: tch_permissions
type: ref
possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
key: permissions_entity_index
key_len: 461
ref: const,const,const
rows: 1
Extra: Using index condition; Using where

- EXPLAIN # 2: `tch_users` (MATERIALIZED)12
Params
id: 2
select_type: MATERIALIZED
table: tch_users
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra: Using index

- EXPLAIN # 2: `tch_assigned_roles` (MATERIALIZED)12

Params

id: 2
select_type: MATERIALIZED
table: tch_assigned_roles
type: ref
possible_keys: assigned_roles_entity_index,assigned_roles_role_id_index,assigned_roles_scope_index
key: assigned_roles_entity_index
key_len: 461
ref: const,const,const
rows: 1
Extra: Using index condition; Start temporary

- EXPLAIN # 2: `tch_roles` (MATERIALIZED)12

Params

id: 2
select_type: MATERIALIZED
table: tch_roles
type: eq_ref
possible_keys: PRIMARY,roles_name_unique,roles_scope_index
key: PRIMARY
key_len: 4
ref: tch123_dev_2020.tch_assigned_roles.role_id
rows: 1
Extra: Using where; End temporary

- EXPLAIN # 2: `tch_permissions` (MATERIALIZED)22

Params

id: 2
select_type: MATERIALIZED
table: tch_permissions
type: ref
possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
key: permissions_entity_index
key_len: 461
ref: tch123_dev_2020.tch_assigned_roles.role_id,const,const
rows: 2
Extra: Using index condition; Using where

select * from `tch_abilities` where (exists (select * from `tch_roles` inner join `tch_permissions` on `tch_roles`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `tch_permissions`.`entity_type` = 'roles' and (`tch_roles`.`scope` is null) and (`tch_permissions`.`scope` is null) and (exists (select * from `tch_users` inner join `tch_assigned_roles` on `tch_users`.`id` = `tch_assigned_roles`.`entity_id` where `tch_assigned_roles`.`role_id` = `tch_roles`.`id` and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 6376 and (`tch_roles`.`scope` is null) and (`tch_assigned_roles`.`scope` is null)))) or exists (select * from `tch_users` inner join `tch_permissions` on `tch_users`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `tch_permissions`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 6376 and (`tch_abilities`.`scope` is null) and (`tch_permissions`.`scope` is null)) or exists (select * from `tch_permissions` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `entity_id` is null and (`tch_permissions`.`scope` is null))) and (`tch_abilities`.`scope` is null)

1.02mstch123_dev_2020BaseClipboard.php#101

Bindings	0: 0 1: roles 2: App\Models\User 3: 6376 4: 0 5: App\Models\User 6: 6376 7: 0
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	15. vendor/silber/bouncer/src/BaseClipboard.php:101 16. vendor/silber/bouncer/src/CachedClipboard.php:213 17. vendor/silber/bouncer/src/CachedClipboard.php:198 18. vendor/silber/bouncer/src/CachedClipboard.php:85 19. vendor/silber/bouncer/src/Guard.php:172

- EXPLAIN # 1: `tch_abilities` (PRIMARY)211
Params
id: 1
select_type: PRIMARY
table: tch_abilities
type: ALL
possible_keys: abilities_scope_index
key:
key_len:
ref:
rows: 21
Extra: Using where
- EXPLAIN # 5: `` (MATERIALIZED)5
Params
id: 5
select_type: MATERIALIZED
table:
type:
possible_keys:
key:
key_len:
ref:
rows:
Extra: Impossible WHERE
- EXPLAIN # 4: `tch_users` (DEPENDENT SUBQUERY)14
Params
id: 4
select_type: DEPENDENT SUBQUERY
table: tch_users
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra: Using index

- EXPLAIN # 4: `tch_permissions` (DEPENDENT SUBQUERY)14

Params

id: 4
select_type: DEPENDENT SUBQUERY
table: tch_permissions
type: ref
possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
key: permissions_entity_index
key_len: 461
ref: const,const,const
rows: 1
Extra: Using index condition; Using where

- EXPLAIN # 2: `tch_users` (MATERIALIZED)12
Params
id: 2
select_type: MATERIALIZED
table: tch_users
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra: Using index

- EXPLAIN # 2: `tch_assigned_roles` (MATERIALIZED)12

Params

id: 2
select_type: MATERIALIZED
table: tch_assigned_roles
type: ref
possible_keys: assigned_roles_entity_index,assigned_roles_role_id_index,assigned_roles_scope_index
key: assigned_roles_entity_index
key_len: 461
ref: const,const,const
rows: 1
Extra: Using index condition; Start temporary

- EXPLAIN # 2: `tch_roles` (MATERIALIZED)12

Params

id: 2
select_type: MATERIALIZED
table: tch_roles
type: eq_ref
possible_keys: PRIMARY,roles_name_unique,roles_scope_index
key: PRIMARY
key_len: 4
ref: tch123_dev_2020.tch_assigned_roles.role_id
rows: 1
Extra: Using where; End temporary

- EXPLAIN # 2: `tch_permissions` (MATERIALIZED)22

Params

id: 2
select_type: MATERIALIZED
table: tch_permissions
type: ref
possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
key: permissions_entity_index
key_len: 461
ref: tch123_dev_2020.tch_assigned_roles.role_id,const,const
rows: 2
Extra: Using index condition; Using where

select * from `tch_pages` where `indexed` = '5_1' limit 1340μ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)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.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)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.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 null420μstch123_dev_2020PageHelper.php#23

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Helpers/PageHelper.php:23 22. app/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)420μ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

990μ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)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: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)

270μ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)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_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 1260μ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)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: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)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: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 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: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)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.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

550μ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)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: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)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: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 1280μstch123_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)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: `tch_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

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

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

380μ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)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: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)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_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)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: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-18' and date(`date_end`) >= '2025-04-18' order by `priority` desc limit 1

280μstch123_dev_2020header_user_not_login.blade.php#3

Bindings	0: 1 1: 2025-04-18 2: 2025-04-18
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

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

280μ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 1250μ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

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

360μstch123_dev_2020Province.php#28

Bindings	0: 2
Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	16. app/Models/Province.php:28 17. app/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 1230μ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: 155District.php#?
App\Models\Page: 54Page.php#?
App\Models\Province: 12Province.php#?
App\Models\Estate: 6Estate.php#?
App\Models\Project: 4Project.php#?
App\Models\PostCanHoDetail: 4PostCanHoDetail.php#?
App\Models\PostCanHoExpand: 4PostCanHoExpand.php#?
App\Models\User: 2User.php#?
App\Models\Package: 1Package.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-18 22:00:55	GET	/0866089092	69 242

Giá tốt 2pn 9-11tr, 3pn 11-19tr, full nội thất Skyline giá tốt cho thuê Quận 7

18-20tr 1PN Hado Centrosa Quận 10 cho thuê nhanh

The Marq giá tốt 1 pn 2 pn nội thất chủ đầu tư 24 - 30tr, full nội thất 28 - 40tr, Quận 1 cho thuê

Giá tốt 3 pn 2 pn cho thuê nhanh - full nội thất 14 - 17tr, 11 - 14tr River Panorama Quận 7