Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Ngô Quang Phát

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

13

Căn Hộ 1 PN Cô Giang Q1 Hiện Đại - cần cho thuê

9.5 triệu/tháng 40m² 1 pn 1 wc

Quận 1, Hồ Chí Minh

Căn hộ siêu đẹp nằm ngay quận 1 Vị Trí : Cô Giang Q1 Gần trường Đại Học Văn Lang , Cầu Ông Lãnh , Coopmart , Phố Bùi Viện …. Không gian sống tiện nghi , hiện đại Giờ giấc tự do Nội thất đầy đủ Gửi xe : free Giá thuê:…

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

Phòng Ngủ Siêu Rộng Ngay Q5 gần đường Võ Văn Kiệt, trường ĐH Sư Phạm, cầu Nguyễn Văn Cừ

7.5 triệu/tháng 25m² 1 pn 1 wc

Quận 5, Hồ Chí Minh

Phòng Ngủ Siêu Rộng Ngay Q5 gần đường Võ Văn Kiệt , trường ĐH Sư Phạm , cầu Nguyễn Văn Cừ.... ️Phòng 4,5 người ở và 2,3 xe / phòng Giá cho thuê: 7.5 triệu/tháng ️Có nội thất đầy đủ ️Có camera ️Có thang máy ️Có ban…

Đăng 4 tháng trước

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

https://thuecanho.lbkdev.com/0382396924

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

Queries57 Models224

Request history5MB

57 statements were executed, 28 of which were duplicates, 29 unique. Show only duplicated38.58ms

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

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

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

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

1.22mstch123_dev_2020UserController.php#39

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

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

2.27mstch123_dev_2020UserController.php#39

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

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: 2
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)420μ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 (0) and `tch_projects`.`deleted_at` is null440μ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: `` (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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180215988, 180216046)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_details` (SIMPLE)21
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: 2
Extra: Using index condition

select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180215988, 180216046)1.07mstch123_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)21
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: 2
Extra: Using index condition

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

660μstch123_dev_2020User.php#256

Bindings	0: 12305
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)21
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: 2
Extra: Using where; Using index

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

1.38mstch123_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 1400μ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_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 1370μ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` = 17 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: 17 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_districts` where `tch_districts`.`id` = 17 limit 1380μstch123_dev_2020post-item.blade.php#89

Bindings	0: 17
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	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 1330μ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 1350μ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` = 12305 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

360μstch123_dev_2020User.php#256

Bindings	0: 12305
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)21
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: 2
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` = 12305 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` = 12305 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)

2.27mstch123_dev_2020BaseClipboard.php#101

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

Bindings	0: 0 1: roles 2: App\Models\User 3: 12305 4: 0 5: App\Models\User 6: 12305 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 1700μ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)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_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)360μ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 null460μ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)490μ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

2.23mstch123_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)400μ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)

470μ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)450μ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 1500μ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)380μ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)360μ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 null430μstch123_dev_2020PageHelper.php#23

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

1.02mstch123_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)340μ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)

450μ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)370μ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 1550μ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)350μ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)320μ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 null340μ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)320μ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

650μ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)290μstch123_dev_2020Page.php#245

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	20. app/Models/Page.php:245 21. view::_desktop.main.includes.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)310μ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)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: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-12' and date(`date_end`) >= '2025-04-12' order by `priority` desc limit 1

510μstch123_dev_2020header_user_not_login.blade.php#3

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

380μstch123_dev_2020LocationHelper.php#266

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

500μ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 1420μ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

350μstch123_dev_2020LocationHelper.php#266

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	22. app/Helpers/LocationHelper.php:266 23. app/Helpers/LocationHelper.php:185 24. app/Helpers/Khelper.php:2797 25. view::_desktop.main.includes.filter_box:3 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

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

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

440μstch123_dev_2020Province.php#28

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

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

select * from `tch_global_option` where `name` = 'address' limit 1390μ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: 153District.php#?
App\Models\Page: 48Page.php#?
App\Models\Province: 10Province.php#?
App\Models\Estate: 6Estate.php#?
App\Models\User: 2User.php#?
App\Models\PostCanHoDetail: 2PostCanHoDetail.php#?
App\Models\PostCanHoExpand: 2PostCanHoExpand.php#?
App\Models\Package: 1Package.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-12 16:38:57	GET	/0382396924	57 224

Căn Hộ 1 PN Cô Giang Q1 Hiện Đại - cần cho thuê

Phòng Ngủ Siêu Rộng Ngay Q5 gần đường Võ Văn Kiệt, trường ĐH Sư Phạm, cầu Nguyễn Văn Cừ