Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Cao Đình Toản

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

16

Cho thuê căn hộ Masteri Millennium, Quận 4. DT 110m2, 3PN, giá 23 triệu, nhà đẹp

23 triệu/tháng 110m² 3 pn 2 wc

Masteri Millennium Quận 4, Hồ Chí Minh

Tòa nhà Millennium tọa lạc tại số 132 Bến Vân Đồn, góc đường với Nguyễn Hữu Hào, phường 6, quận 4. .- Thiết kế: 3 phòng ngủ, 2 nhà vệ sinh. - View: Thành phố. - Tình trạng: Full nội thất cao cấp - không đăng tin giá ảo. - Liên…

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

Quỹ căn hộ cho thuê tại tòa International, nằm ngay trung tâm quận 1, giá cực rẻ

13 triệu/tháng 50m² 1 pn 1 wc

International Plaza Quận 1, Hồ Chí Minh

Quỹ căn 1 ngủ cho thuê gấp căn hộ tại tòa nhà International Plaza, 343 Phạm Ngũ Lão, Quận 1. Chi tiết căn hộ: - Căn hộ 1 ngủ, 1 vs, diện tích 50m², full đồ. - Giá 13 triệu/ tháng. * Giá thuê đã bao gồm thuế và phí quản lý Vị trí…

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

Cho thuê căn hộ giá rẻ ngay tại trung tâm Quận 1

20 triệu/tháng 102m² 2 pn 2 wc

International Plaza Quận 1, Hồ Chí Minh

Cho thuê căn hộ tại toà nhà International Plaza, số 343 đường Phạm Ngũ Lão, phường Phạm Ngũ Lão, quận 1, Thành Phố Hồ Chí Minh. International Plaza Building tọa lạc tại vị trí đắc địa ngay trung tâm quận 1, đối diện với công viên 23/9,…

Đăng 4 tháng trước

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

https://thuecanho.lbkdev.com/0898323343

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

Queries64 Models234

Request history5MB

64 statements were executed, 35 of which were duplicates, 29 unique. Show only duplicated44.95ms

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

Bindings	0: 1 1: /0898323343
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` = '0898323343' and `tch_users`.`deleted_at` is null limit 11.26mstch123_dev_2020UserHelper.php#20

Bindings	0: 0898323343
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` = '0898323343' and `tch_users`.`deleted_at` is null limit 1450μstch123_dev_2020UserHelper.php#20

Bindings	0: 0898323343
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` = 12380 and `tch_posts`.`deleted_at` is null

1.24mstch123_dev_2020UserController.php#39

Bindings	0: approved 1: 1 2: 0 3: 12380
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)31

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: 3
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` = 12380 and `tch_posts`.`deleted_at` is null order by `tch_packages`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 0

2.28mstch123_dev_2020UserController.php#39

Bindings	0: approved 1: 1 2: 0 3: 12380
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)31

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: 3
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)410μ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 (278, 512) and `tch_projects`.`deleted_at` is null820μ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)21
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: range
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref:
rows: 2
Extra: Using where

select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180216314, 180216316, 180217340)

700μ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)31
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: 3
Extra: Using index condition

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180216314, 180216316, 180217340)

1.05mstch123_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)31
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: 3
Extra: Using index condition

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

730μstch123_dev_2020User.php#256

Bindings	0: 12380
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)41
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: 4
Extra: Using where; Using index

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

550μstch123_dev_2020post-item.blade.php#21

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

4.41mstch123_dev_2020post-item.blade.php#84

Bindings	0: 512 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_districts` where `tch_districts`.`id` = 16 limit 1390μstch123_dev_2020post-item.blade.php#89

Bindings	0: 16
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:89 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_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_provinces` where `tch_provinces`.`id` = 1 limit 1410μstch123_dev_2020post-item.blade.php#89

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. view::_desktop.main.post.post-item:89 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_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `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

490μ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_global_option` where `name` = 'using_google_cached_image' limit 1360μ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` = 278 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

6.61mstch123_dev_2020post-item.blade.php#84

Bindings	0: 278 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_districts` where `tch_districts`.`id` = 10 limit 1390μstch123_dev_2020post-item.blade.php#89

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. view::_desktop.main.post.post-item:89 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_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_provinces` where `tch_provinces`.`id` = 1 limit 1270μstch123_dev_2020post-item.blade.php#89

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. view::_desktop.main.post.post-item:89 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_provinces` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_provinces
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `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

420μ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_global_option` where `name` = 'using_google_cached_image' limit 1340μ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` = 278 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

410μstch123_dev_2020post-item.blade.php#84

Bindings	0: 278 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_districts` where `tch_districts`.`id` = 10 limit 1270μstch123_dev_2020post-item.blade.php#89

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. view::_desktop.main.post.post-item:89 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_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_provinces` where `tch_provinces`.`id` = 1 limit 1290μstch123_dev_2020post-item.blade.php#89

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. view::_desktop.main.post.post-item:89 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_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_global_option` where `name` = 'use_avatar_social' limit 1410μ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` = 12380 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

320μstch123_dev_2020User.php#256

Bindings	0: 12380
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)41
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: 4
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` = 12380 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` = 12380 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.92mstch123_dev_2020BaseClipboard.php#101

Bindings	0: 1 1: roles 2: App\Models\User 3: 12380 4: 1 5: App\Models\User 6: 12380 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` = 12380 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` = 12380 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.41mstch123_dev_2020BaseClipboard.php#101

Bindings	0: 0 1: roles 2: App\Models\User 3: 12380 4: 0 5: App\Models\User 6: 12380 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 1450μ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)250μstch123_dev_2020PageHelper.php#23

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

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

1.28mstch123_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)

360μ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)300μ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 1370μ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)250μstch123_dev_2020PageHelper.php#23

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

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

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: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)300μ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 1380μ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)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)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: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 null250μ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)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_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

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

320μstch123_dev_2020header_user_not_login.blade.php#3

Bindings	0: 1 1: 2025-04-26 2: 2025-04-26
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 1290μ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

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

370μ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 1430μ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

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

480μ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 1290μ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:49 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: 154District.php#?
App\Models\Page: 52Page.php#?
App\Models\Province: 11Province.php#?
App\Models\Estate: 6Estate.php#?
App\Models\PostCanHoDetail: 3PostCanHoDetail.php#?
App\Models\PostCanHoExpand: 3PostCanHoExpand.php#?
App\Models\User: 2User.php#?
App\Models\Project: 2Project.php#?
App\Models\Package: 1Package.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-26 08:10:54	GET	/0898323343	64 234

Cho thuê căn hộ Masteri Millennium, Quận 4. DT 110m2, 3PN, giá 23 triệu, nhà đẹp

Quỹ căn hộ cho thuê tại tòa International, nằm ngay trung tâm quận 1, giá cực rẻ

Cho thuê căn hộ giá rẻ ngay tại trung tâm Quận 1