Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Nguyên Luân

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

3

Cho thuê CT7 Booyoung, Hà Đông, 3 ngủ 2wc, full đồ giá 16tr có fix

16 triệu/tháng 95m² 3 pn 2 wc

Booyoung Vina Mỗ Lao Hà Đông, Hà Nội

Cho thuê căn hộ chung cư Booyoung Hà Đông Vị trí tòa nhà dễ kết nối với các tuyến đường lớn. Đi vào trung tâm hay ngoại thành đều thuận tiện. Căn hộ thiết kế đẹp, chất lượng xây dựng tốt, nội thất ngoại nhâp chất…

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

Siêu hấp dẫn. Cho thuê VinSmart City S203, 2PN-2VS, Full Đồ, 70m2, giá chỉ 13tr

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

Vinhomes Smart City Nam Từ Liêm, Hà Nội

Căn hộ được chủ đầu tư chất lượng. Nội thất tối giản, gọn gàng nhưng vẫn đủ tiện nghi. Tivi, sofa, bếp, tủ lạnh, bàn ăn, giường tủ, thiết bị vệ sinh đẹp như hình. Diện tích: 70m2 2 Phòng ngủ, 2 nhà vệ sinh View…

Đăng 4 tháng trước

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

https://thuecanho.lbkdev.com/0962421441

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

Queries59 Models228

Request history6MB

59 statements were executed, 27 of which were duplicates, 32 unique. Show only duplicated34.84ms

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

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

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

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

980μstch123_dev_2020UserController.php#39

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

2.32mstch123_dev_2020UserController.php#39

Bindings	0: approved 1: 1 2: 0 3: 11280
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)400μ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 (1752, 2553) and `tch_projects`.`deleted_at` is null810μ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 (180210652, 180210943)730μ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 (180210652, 180210943)930μstch123_dev_2020UserController.php#39

Hints	0: Use `SELECT *` only if you need all columns from table
Backtrace	21. app/Http/Controllers/UserController.php:39 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:208

- EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)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` = 11280 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

630μstch123_dev_2020User.php#256

Bindings	0: 11280
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` = 34 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

1.21mstch123_dev_2020post-item.blade.php#21

Bindings	0: 34 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 1410μ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` = 2553 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

480μstch123_dev_2020post-item.blade.php#84

Bindings	0: 2553 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` = 34 limit 1400μstch123_dev_2020post-item.blade.php#89

Bindings	0: 34
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` = 2 limit 1400μstch123_dev_2020post-item.blade.php#89

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	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` = 42 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1

1.11mstch123_dev_2020post-item.blade.php#21

Bindings	0: 42 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 1320μ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` = 1752 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1

450μstch123_dev_2020post-item.blade.php#84

Bindings	0: 1752 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` = 42 limit 1280μstch123_dev_2020post-item.blade.php#89

Bindings	0: 42
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` = 2 limit 1260μstch123_dev_2020post-item.blade.php#89

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	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 1340μ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` = 11280 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null

320μstch123_dev_2020User.php#256

Bindings	0: 11280
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` = 11280 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` = 11280 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.67mstch123_dev_2020BaseClipboard.php#101

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

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

Bindings	0: 5_1
Hints	0: Use `SELECT *` only if you need all columns from table 1: `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. app/Helpers/PageHelper.php:23 17. app/Helpers/Khelper.php:890 18. view::_desktop.main.includes.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)270μstch123_dev_2020PageHelper.php#23

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

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

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

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

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

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

940μ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)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)

280μ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)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: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 1540μ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)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: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)370μ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 null410μ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)370μ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

620μ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)320μ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)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: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)350μstch123_dev_2020Page.php#245

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

350μstch123_dev_2020header_user_not_login.blade.php#3

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

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

420μ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 1320μ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

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

410μ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 1270μ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: 50Page.php#?
App\Models\Province: 10Province.php#?
App\Models\Estate: 6Estate.php#?
App\Models\User: 2User.php#?
App\Models\Project: 2Project.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-22 08:15:58	GET	/0962421441	59 228

Cho thuê CT7 Booyoung, Hà Đông, 3 ngủ 2wc, full đồ giá 16tr có fix

Siêu hấp dẫn. Cho thuê VinSmart City S203, 2PN-2VS, Full Đồ, 70m2, giá chỉ 13tr