Kênh thông tin cho thuê căn hộ số 1 Việt Nam
Đăng tin
Tân Phú, Hồ Chí Minh
Dự án
Chọn giá
100 - 500m2
Số phòng ngủ
Số toilet
Hướng chính
Đặt lại

Cho thuê căn hộ chung cư Âu Cơ Tower Diện tích từ 100m2 T4/2025

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

Đề xuất Mới đăng Có video
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
Hồ Chí Minh
  • Tất cả
  • Quận 1
  • Quận 2
  • Quận 3
  • Quận 4
  • Quận 5
  • Quận 6
  • Quận 7
  • Quận 8
  • Quận 9
  • Quận 10
  • Quận 11
  • Quận 12
  • Bình Tân
  • Bình Thạnh
  • Gò Vấp
  • Phú Nhuận
  • Tân Bình
  • Tân Phú
  • Thủ Đức
  • Bình Chánh
  • Cần Giờ
  • Củ Chi
  • Hóc Môn
  • Nhà Bè
Tân Phú
  • Tất cả
  • Phường Sơn Kỳ
  • Phường Tân Quý
  • Phường Phú Trung
  • Phường Hiệp Tân
  • Phường Tân Thành
  • Phường Hòa Thạnh
  • Phường Phú Thạnh
  • Phường Tây Thạnh
  • Phường Tân Sơn Nhì
  • Phường Phú Thọ Hòa
  • Phường Tân Thới Hòa
Chọn dự án
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ợ
Queries151Models446
Request history6MBMemory Usage
151 statements were executed, 106 of which were duplicates, 45 unique. Show only duplicated84.31ms
  • 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` = '/cho-thue-can-ho-chung-cu-au-co-tower.html' limit 12.44mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /cho-thue-can-ho-chung-cu-au-co-tower.html
    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_pages` where `tch_pages`.`id` = 1 limit 1320μstch123_dev_2020PageHelper.php#58
    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
    • 20. app/Helpers/PageHelper.php:58
    • 21. app/Helpers/Khelper.php:256
    • 22. middleware::page.hook:14
    • 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 24. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `slug` = 'cho-thue-can-ho-chung-cu-au-co-tower' limit 1460μstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-au-co-tower
    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:100
    • 17. app/Helpers/Khelper.php:279
    • 18. middleware::page.hook:16
    • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 20. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: slug_deleted_at
    • key: slug_deleted_at
    • key_len: 767
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)340μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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 (23)360μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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_projects` where `tch_projects`.`id` in (879) and `tch_projects`.`deleted_at` is null520μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)340μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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 `slug` = 'cho-thue-can-ho-chung-cu-au-co-tower' limit 1380μstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-au-co-tower
    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:100
    • 17. app/Helpers/Khelper.php:279
    • 18. app/Http/Controllers/PageController.php:37
    • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: slug_deleted_at
    • key: slug_deleted_at
    • key_len: 767
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)300μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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 (23)250μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_projects` where `tch_projects`.`id` in (879) and `tch_projects`.`deleted_at` is null290μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)240μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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 `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc430μstch123_dev_2020LocationHelper.php#24
    Hints
    • 0: The SELECT statement has no WHERE clause and could examine many more rows than intended
    Backtrace
    • 15. app/Helpers/LocationHelper.php:24
    • 16. app/Helpers/Khelper.php:1972
    • 17. app/Services/Page/PageService.php:377
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)631
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 63
    • Extra: Using filesort
  • select * from `tch_global_option` where `name` = 'post_paging' limit 1820μstch123_dev_2020Setting.php#23
    Bindings
    • 0: post_paging
    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/Services/Page/PageService.php:362
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
  • - 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` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `tch_post_apartment_details`.`dien_tich` >= 100 and `project_id` = 879 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null1.18mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 100
    • 1: 879
    • 2: approved
    • 3: 1
    • 4: 0
    Backtrace
    • 16. app/Services/Page/PageService.php:365
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)681
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
    • key: project_id_published_status_out_of_service_ordering_deleted_at
    • key_len: 312
    • ref: const,const,const,const
    • rows: 68
    • Extra: Using where; Using index
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: tch123_dev_2020.tch_posts.id
    • rows: 1
    • Extra: Using index condition; Using where
  • select `tch_posts`.* from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `tch_post_apartment_details`.`dien_tich` >= 100 and `project_id` = 879 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null order by `tch_posts`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 02.15mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 100
    • 1: 879
    • 2: approved
    • 3: 1
    • 4: 0
    Backtrace
    • 16. app/Services/Page/PageService.php:365
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)631
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
    • key: project_id_published_deleted_at
    • key_len: 13
    • ref: const,const,const
    • rows: 63
    • Extra: Using index condition; Using where; Using filesort
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: tch123_dev_2020.tch_posts.id
    • rows: 1
    • Extra: Using index condition; Using where
  • select * from `tch_packages` where `tch_packages`.`id` in (31)330μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - 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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180188490)440μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180188490)570μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_expands
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (879) and `tch_projects`.`deleted_at` is null300μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (879)27.63mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 879
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - 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` in (1)360μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)500μstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_districts` where `tch_districts`.`id` in (23)330μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - 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_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (23)490μstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - 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_users` where `tch_users`.`id` in (2398) and `tch_users`.`deleted_at` is null540μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1340μ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/Khelper.php:195
    • 19. app/Services/Page/PageService.php:427
    • 20. app/Services/Page/PageService.php:32
    • 21. app/Http/Controllers/PageController.php:42
  • - 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` asc400μ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/Khelper.php:195
    • 24. app/Services/Page/PageService.php:427
    • 25. app/Services/Page/PageService.php:32
    • 26. app/Http/Controllers/PageController.php:42
  • - 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` asc580μ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/Services/Page/PageService.php:427
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - 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_districts` where `tch_districts`.`id` = 23 limit 1320μstch123_dev_2020LocationHelper.php#322
    Bindings
    • 0: 23
    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
    • 20. app/Helpers/LocationHelper.php:322
    • 21. app/Helpers/Khelper.php:207
    • 22. app/Services/Page/PageService.php:430
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
  • - 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 `id`, CONCAT(pre," ",name) as text, CONCAT(pre," ",name) as name from `tch_wards` where `tch_wards`.`id_district` = 23 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc800μstch123_dev_2020District.php#34
    Bindings
    • 0: 23
    Backtrace
    • 16. app/Models/District.php:34
    • 17. app/Services/Page/PageService.php:430
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_wards` (SIMPLE)111
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_wards
    • type: ref
    • possible_keys: id_district
    • key: id_district
    • key_len: 4
    • ref: const
    • rows: 11
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_pages` where `indexed` = 5 limit 1370μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5
    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/Models/Page.php:183
    • 18. app/Helpers/Khelper.php:2292
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - 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 (0)250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_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/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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 null300μ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/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_1' limit 1380μ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/Models/Page.php:189
    • 18. app/Helpers/Khelper.php:2306
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - 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)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/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_1_23' limit 1340μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_23
    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/Models/Page.php:216
    • 18. app/Helpers/Khelper.php:2307
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - 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)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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 (23)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null230μ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/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1250μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. app/Helpers/Khelper.php:2346
    • 23. app/Services/Page/PageService.php:448
    • 24. app/Services/Page/PageService.php:32
    • 25. app/Http/Controllers/PageController.php:42
  • - 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_pages` where `indexed` = '5_1_23_project_879' limit 1460μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_23_project_879
    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/Models/Page.php:303
    • 18. app/Helpers/Khelper.php:2350
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - 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)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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 (23)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_projects` where `tch_projects`.`id` in (879) and `tch_projects`.`deleted_at` is null320μ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/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1250μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. app/Helpers/Khelper.php:2355
    • 23. app/Services/Page/PageService.php:448
    • 24. app/Services/Page/PageService.php:32
    • 25. app/Http/Controllers/PageController.php:42
  • - 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_pages` where `indexed` = '5_1' limit 1400μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Helpers/Khelper.php:890
    • 18. view::_desktop.main.includes.khuvuc:4
    • 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)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.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 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)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 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.42mstch123_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.khuvuc:5
    • 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)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.khuvuc:5
    • 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)330μ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.khuvuc:5
    • 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)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.khuvuc:5
    • 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_wards` where `tch_wards`.`id` = 0 limit 1260μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1220μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1210μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1220μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1210μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1290μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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_wards` where `tch_wards`.`id` = 0 limit 1200μstch123_dev_2020Page.php#366
    Bindings
    • 0: 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. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - 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`.`parent_id` = 879 and `tch_projects`.`parent_id` is not null and `tch_projects`.`deleted_at` is null3.43mstch123_dev_2020page_part_project_childs.blade.php#13
    Bindings
    • 0: 879
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. view::_desktop.main.page.page_part.page_part_project_childs:13
    • 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_projects` (SIMPLE)15401
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 1540
    • Extra: Using where
  • 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 project_id, COUNT(*) as total from `tch_posts` where `district_id` = 23 and `created_at` > '2025-02-10 00:00:00' and `project_id` > 0 and `tch_posts`.`deleted_at` is null group by `project_id` having COUNT(*) > 0 order by COUNT(*) DESC limit 20360μstch123_dev_2020ProjectHelper.php#255
    Bindings
    • 0: 23
    • 1: 2025-02-10 00:00:00
    • 2: 0
    • 3: 0
    Backtrace
    • 15. app/Helpers/ProjectHelper.php:255
    • 16. view::_desktop.main.page.page_part.page_part_project:8
    • 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_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: range
    • possible_keys: project_id_published_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at,district_id_published_status_out_of_service_deleted_at,created_at
    • key: created_at
    • key_len: 5
    • ref: 
    • rows: 1
    • Extra: Using index condition; Using where; Using temporary; Using filesort
  • select * from `tch_pages` where `project_id` > '0' and `province_id` = 1 and `count` > 0 and `district_id` = 23 order by `count` desc, `created_at` desc limit 15760μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 1
    • 2: 0
    • 3: 23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/PageHelper.php:208
    • 16. app/Helpers/Khelper.php:866
    • 17. view::_desktop.main.page.page_part.page_part_project:19
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)18271
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: range
    • possible_keys: count_deleted_at
    • key: count_deleted_at
    • key_len: 4
    • ref: 
    • rows: 1827
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)230μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 (23)270μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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_wards` where `tch_wards`.`id` in (0)200μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 (876, 878, 879, 880, 881, 883, 889, 892, 894, 895, 896, 898, 909, 2454, 2654) and `tch_projects`.`deleted_at` is null410μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)151
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 15
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)260μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 `project_id` > '0' and `district_id` = 23 and 1 = 1 order by `created_at` desc limit 5520μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/PageHelper.php:208
    • 16. app/Helpers/Khelper.php:866
    • 17. view::_desktop.main.page.page_part.page_part_project:20
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - 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; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)220μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 (23)200μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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_wards` where `tch_wards`.`id` in (0)200μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 (2634, 2654, 2699, 3000, 3064) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 5
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)200μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. 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 `tch_posts`.* from `tch_posts` where not exists (select * from `tch_promote_post_histories` where `tch_posts`.`id` = `tch_promote_post_histories`.`post_id` and `type` = 'RECREATEPOST' and `tch_promote_post_histories`.`deleted_at` is null) and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`status` = 'approved' and `tch_posts`.`deleted_at` is null order by `tch_posts`.`created_at` desc limit 10440μstch123_dev_2020PostHelper.php#621
    Bindings
    • 0: RECREATEPOST
    • 1: 1
    • 2: 0
    • 3: approved
    Backtrace
    • 15. app/Helpers/PostHelper.php:621
    • 16. view::_desktop.main.page.page_part.page_part_lastest_posts: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
  • - EXPLAIN # 1: `tch_posts` (PRIMARY)201
    Params
    • id: 1
    • select_type: PRIMARY
    • table: tch_posts
    • type: index
    • possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at
    • key: created_at
    • key_len: 5
    • ref: 
    • rows: 20
    • Extra: Using where
  • - EXPLAIN # 2: `tch_promote_post_histories` (MATERIALIZED)3435592
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_promote_post_histories
    • type: ALL
    • possible_keys: post_id,type,deleted_at
    • key: 
    • key_len: 
    • ref: 
    • rows: 343559
    • Extra: Using where
  • select * from `tch_packages` where `tch_packages`.`id` in (31, 33, 34, 37)270μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 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_packages` (SIMPLE)71
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: ALL
    • possible_keys: PRIMARY
    • key: 
    • key_len: 
    • ref: 
    • rows: 7
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1, 2)240μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 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)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using where
  • select * from `tch_districts` where `tch_districts`.`id` in (9, 11, 14, 21, 27)210μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223418, 180223419, 180223420, 180223421, 180223423, 180223424, 180223425, 180223429, 180223432, 180223433)280μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 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_post_apartment_details` (SIMPLE)101
    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: 10
    • Extra: Using index condition
  • 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-aside:15
    • 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_global_option` where `name` = 'using_google_cached_image' limit 1260μ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-aside:15
    • 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_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-aside:15
    • 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_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-aside:15
    • 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_global_option` where `name` = 'using_google_cached_image' limit 1390μ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-aside:15
    • 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_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-aside:15
    • 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_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-aside:15
    • 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_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-aside:15
    • 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_global_option` where `name` = 'using_google_cached_image' limit 1260μ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-aside:15
    • 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_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-aside:15
    • 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_articles` where `published` = 1 and `tch_articles`.`deleted_at` is null order by `created_at` desc limit 5640μstch123_dev_2020ArticleHelper.php#173
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/ArticleHelper.php:173
    • 16. app/Helpers/Khelper.php:2973
    • 17. view::_desktop.main.page.page_part.page_part_lastest_articles:22
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_articles` (SIMPLE)6641
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_articles
    • type: ref
    • possible_keys: published_deleted_at,deleted_at
    • key: deleted_at
    • key_len: 5
    • ref: const
    • rows: 664
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_pages` where `indexed` = '5_1' limit 1430μ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)400μ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)310μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (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 null380μ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)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: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.25mstch123_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)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_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)370μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu: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)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: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 1390μ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)330μ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)250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (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 null330μ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)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: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` asc790μ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)280μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)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_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)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu: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 1360μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_3
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Helpers/Khelper.php:890
    • 18. view::_desktop.main.includes.main_menu:9
    • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (3)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `estate_id` = 5 and `province_id` = 3 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc470μ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)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_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)230μ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)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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-11' and date(`date_end`) >= '2025-04-11' order by `priority` desc limit 1290μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-11
    • 2: 2025-04-11
    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` = 2 limit 1440μ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` asc320μ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` asc490μ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_provinces` where `tch_provinces`.`id` = 1 limit 1310μstch123_dev_2020DelegatesToResource.php#139
    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. vendor/laravel/framework/src/Illuminate/Http/Resources/DelegatesToResource.php:139
    • 22. app/Http/Resources/ProjectResource.php:17
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
    • 32. 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` = 23 limit 1210μstch123_dev_2020DelegatesToResource.php#139
    Bindings
    • 0: 23
    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. vendor/laravel/framework/src/Illuminate/Http/Resources/DelegatesToResource.php:139
    • 22. app/Http/Resources/ProjectResource.php:18
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
    • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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_wards` where `tch_wards`.`id` = 312 limit 1460μstch123_dev_2020LocationHelper.php#284
    Bindings
    • 0: 312
    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
    • 20. app/Helpers/LocationHelper.php:284
    • 21. app/Helpers/Khelper.php:199
    • 22. app/Http/Resources/ProjectResource.php:19
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
  • - EXPLAIN # 1: `tch_wards` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_wards
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_streets` where `tch_streets`.`id` = 3260 limit 1270μstch123_dev_2020LocationHelper.php#303
    Bindings
    • 0: 3260
    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
    • 20. app/Helpers/LocationHelper.php:303
    • 21. app/Helpers/Khelper.php:203
    • 22. app/Http/Resources/ProjectResource.php:20
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
  • - EXPLAIN # 1: `tch_streets` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_streets
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'address' limit 1260μ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
187District.php#?
App\Models\Page
99Page.php#?
App\Models\Province
84Province.php#?
App\Models\Project
24Project.php#?
App\Models\Estate
16Estate.php#?
App\Models\Ward
12Ward.php#?
App\Models\PostCanHoDetail
11PostCanHoDetail.php#?
App\Models\Package
5Package.php#?
App\Models\Article
5Article.php#?
App\Models\PostCanHoExpand
1PostCanHoExpand.php#?
App\Models\User
1User.php#?
App\Models\Street
1Street.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-11 22:45:38GET/cho-thue-can-ho-chung-cu-au-co-tower.html?dien_tich_tu=100151446