Kênh thông tin cho thuê căn hộ số 1 Việt Nam
Đăng tin
Toàn quốc
Dự án
Chọn giá
Diện tích
Số phòng ngủ
Số toilet
Hướng chính

Tuan

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

Chia sẻ

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

https://thuecanho.lbkdev.com/0918860304
Sao chép
Phản ánh người dùng

Lý do phản ánh:

Thông tin liên hệ

Chọn khu vực
  • Toàn quốc
  • Hồ Chí Minh
  • Hà Nội
  • Bình Dương
  • Đà Nẵng
  • Hải Phòng
  • Long An
  • Bà Rịa Vũng Tàu
  • An Giang
  • Bắc Giang
  • Bắc Kạn
  • Bạc Liêu
  • Bắc Ninh
  • Bến Tre
  • Bình Định
  • Bình Phước
  • Bình Thuận
  • Cà Mau
  • Cần Thơ
  • Cao Bằng
  • Đắk Lắk
  • Đắk Nông
  • Điện Biên
  • Đồng Nai
  • Đồng Tháp
  • Gia Lai
  • Hà Giang
  • Hà Nam
  • Hà Tĩnh
  • Hải Dương
  • Hậu Giang
  • Hòa Bình
  • Hưng Yên
  • Khánh Hòa
  • Kiên Giang
  • Kon Tum
  • Lai Châu
  • Lâm Đồng
  • Lạng Sơn
  • Lào Cai
  • Nam Định
  • Nghệ An
  • Ninh Bình
  • Ninh Thuận
  • Phú Thọ
  • Phú Yên
  • Quảng Bình
  • Quảng Nam
  • Quảng Ngãi
  • Quảng Ninh
  • Quảng Trị
  • Sóc Trăng
  • Sơn La
  • Tây Ninh
  • Thái Bình
  • Thái Nguyên
  • Thanh Hóa
  • Thừa Thiên Huế
  • Tiền Giang
  • Trà Vinh
  • Tuyên Quang
  • Vĩnh Long
  • Vĩnh Phúc
  • Yên Bái
Chọn quận huyện
  • Tất cả
Chọn phường xã
Chọn khoảng giá
  • Tất cả
  • Dưới 5 triệu
  • 5 - 7 triệu
  • 7 - 10 triệu
  • 10 - 15 triệu
  • 15 - 20 triệu
  • 20 - 30 triệu
  • 30 - 50 triệu
  • 50 - 100 triệu
  • Trên 100 triệu
Hủy
Áp dụng
Chọn diện tích
  • Tất cả
  • Dưới 20m2
  • 20m2 - 30m2
  • 30m2 - 50m2
  • 50m2 - 70m2
  • 70m2 - 90m2
  • 90m2 - 120m2
  • 120m2 - 200m2
  • 200m2 - 500m2
  • Trên 500m2
Hủy
Áp dụng
Số phòng ngủ
  • Tất cả
  • 1 phòng ngủ
  • 2 phòng ngủ
  • 3 phòng ngủ
  • 4+ phòng ngủ
Hủy
Áp dụng
Số toilet
  • Tất cả
  • 1 toilet
  • 2 toilet
  • 3 toilet
  • 4+ toilet
Hủy
Áp dụng
Hướng chính
  • Tất cả
  • Đông
  • Tây
  • Nam
  • Bắc
  • Đông Nam
  • Đông Bắc
  • Tây Nam
  • Tây Bắc
Hủy
Áp dụng
Hỗ trợ chủ nhà
Ms.Huỳnh Hương
0903.007.123
Hỗ trợ ngoài giờ
Thuecanho123
Bảng giá dịch vụ Hướng dẫn đăng tin Yêu cầu hỗ trợ
Queries149Models348
Request history7MBMemory Usage
149 statements were executed, 111 of which were duplicates, 38 unique. Show only duplicated155ms
  • 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` = '/0918860304' limit 13.79mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /0918860304
    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` = '0918860304' and `tch_users`.`deleted_at` is null limit 1990μstch123_dev_2020UserHelper.php#20
    Bindings
    • 0: 0918860304
    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` = '0918860304' and `tch_users`.`deleted_at` is null limit 1470μstch123_dev_2020UserHelper.php#20
    Bindings
    • 0: 0918860304
    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` = 1039 and `tch_posts`.`deleted_at` is null3.11mstch123_dev_2020UserController.php#39
    Bindings
    • 0: approved
    • 1: 1
    • 2: 0
    • 3: 1039
    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)4121
    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: 412
    • 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` = 1039 and `tch_posts`.`deleted_at` is null order by `tch_packages`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 09.99mstch123_dev_2020UserController.php#39
    Bindings
    • 0: approved
    • 1: 1
    • 2: 0
    • 3: 1039
    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)4121
    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: 412
    • 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)350μ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 (374, 389, 405, 411, 417, 420, 422, 426, 427, 429, 452, 2450, 2608, 3129) and `tch_projects`.`deleted_at` is null1.28mstch123_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)141
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 14
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180125094, 180125097, 180126254, 180126255, 180126256, 180126257, 180126259, 180126260, 180127522, 180127526, 180127534, 180127536, 180127538, 180128431, 180130294, 180130295, 180130296, 180130297, 180130298, 180130299)910μ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)201
    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: 20
    • Extra: Using index condition
  • select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180125094, 180125097, 180126254, 180126255, 180126256, 180126257, 180126259, 180126260, 180127522, 180127526, 180127534, 180127536, 180127538, 180128431, 180130294, 180130295, 180130296, 180130297, 180130298, 180130299)1.83mstch123_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)201
    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: 20
    • Extra: Using index condition
  • select count(*) as aggregate from `tch_posts` where `tch_posts`.`user_id` = 1039 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null810μstch123_dev_2020User.php#256
    Bindings
    • 0: 1039
    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)4521
    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: 452
    • Extra: Using where; Using index
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1500μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1360μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1360μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1330μ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` = 427 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.59mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 427
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1480μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1410μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1280μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1250μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `tch_pages`.`project_id` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 15.57mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1550μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1320μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1290μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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` = 389 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.3mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 389
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1450μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1260μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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_pages` where `tch_pages`.`project_id` = 422 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.12mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 422
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1490μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1280μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1310μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1330μ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` = 3129 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 131.9mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 3129
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1520μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1380μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1300μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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` = 426 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.48mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 426
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1490μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1460μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1300μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1350μ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` = 2608 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 16.19mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 2608
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1600μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1370μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1410μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1580μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1270μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1300μ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` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1410μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1460μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1360μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1260μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1300μ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` = 2450 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 14.94mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 2450
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1410μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1310μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1250μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item: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` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1500μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1400μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1320μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1250μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1220μ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` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1470μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1520μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1360μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μ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` = 452 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.26mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 452
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1450μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1260μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μ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` = 422 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1410μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 422
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1570μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1250μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μ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` = 420 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.1mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 420
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1430μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1340μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1240μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1350μ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` = 405 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 12.93mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 405
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1510μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1280μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1230μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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` = 374 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.42mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 374
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1600μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1420μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1230μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1220μ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` = 411 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 15.74mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 411
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1700μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1310μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1260μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1330μ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` = 429 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 13.11mstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 429
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1610μstch123_dev_2020post-item.blade.php#21
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:21
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1260μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1250μstch123_dev_2020Khelper.php#989
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Helpers/Khelper.php:989
    • 22. app/Models/Post.php:276
    • 23. view::_desktop.main.post.post-item:32
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μ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` = 417 and `tch_pages`.`project_id` is not null and `district_id` > 0 and `project_id` > 0 limit 1500μstch123_dev_2020post-item.blade.php#84
    Bindings
    • 0: 417
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item:84
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'use_avatar_social' limit 1310μ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` = 1039 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null330μstch123_dev_2020User.php#256
    Bindings
    • 0: 1039
    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)4521
    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: 452
    • 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` = 1039 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` = 1039 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.04mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 1
    • 1: roles
    • 2: App\Models\User
    • 3: 1039
    • 4: 1
    • 5: App\Models\User
    • 6: 1039
    • 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` = 1039 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` = 1039 and (`tch_abilities`.`scope` is null) and (`tch_permissions`.`scope` is null)) or exists (select * from `tch_permissions` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `entity_id` is null and (`tch_permissions`.`scope` is null))) and (`tch_abilities`.`scope` is null)1.41mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 0
    • 1: roles
    • 2: App\Models\User
    • 3: 1039
    • 4: 0
    • 5: App\Models\User
    • 6: 1039
    • 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 1650μ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)280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)240μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)300μ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` asc1.2mstch123_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)300μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)390μ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 1460μ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)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:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is 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: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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_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` asc630μ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)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:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)161
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 16
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)300μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `indexed` = '5_3' limit 1450μ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)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: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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)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: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` asc450μ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)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:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (56, 58, 60, 61, 62)250μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 5
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)260μ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-23' and date(`date_end`) >= '2025-04-23' order by `priority` desc limit 1340μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-23
    • 2: 2025-04-23
    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 1310μ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` asc280μ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` asc350μ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 1410μ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` asc290μ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` asc380μ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 1320μ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
171District.php#?
App\Models\Page
86Page.php#?
App\Models\Province
28Province.php#?
App\Models\PostCanHoDetail
20PostCanHoDetail.php#?
App\Models\PostCanHoExpand
20PostCanHoExpand.php#?
App\Models\Project
14Project.php#?
App\Models\Estate
6Estate.php#?
App\Models\User
2User.php#?
App\Models\Package
1Package.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-23 00:51:15GET/0918860304149348