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

Bạn đang xem tin cũ tại Thuecanho123.com, tin đăng này đã hết hạn.

180199145

Căn Hộ Ban Công View Landmark_Bồn Tắm_Full Nội Thất_Ngay Công Viên Văn Hoá Gò Vấp.

416 Đường Quảng Hàm, Phường 5, Gò Vấp, Hồ Chí Minh - Xem bản đồ
5.6 triệu/tháng
30 m2
1 phòng ngủ
1 toilet

Thông tin mô tả

Căn Hộ Ban Công_Bồn Tắm_Full Nội Thất_Ngay Công Viên Văn Hoá Gò Vấp.

Địa chỉ: 416 Dương Quảng Hàm, P5, Gò Vấp

* Nhà mới xây đẹp, phòng ốc THOÁNG MÁT, giường lớn, cửa sổ.

* TỦ ĐỒ LỚN tha hồ để đồ

* THANG MÁY CÓ MÁY LẠNH

* Full Nội Thất : bồn tắm nằm, giường nệm, máy lạnh, tủ lạnh, bàn ăn,….

* BAN CÔNG BỰ hướng ĐÔNG NAM bao mát

* VIEW ngắm LANDMARK 81

* Chỉ 5p qua Đại học Công Nghiệp, Văn Lang...

* Vị trí trung tâm quận Gò Vấp, thuận tiện di chuyển các quận trung tâm Bình Thạnh, Phú Nhuận, Tân Bình, Quận 12, Hóc Môn ... các điểm du lịch trong thành phố, TTTM, cafe, rạp chiếu phim, bệnh viện, siêu thị, cửa hàng tiện lợi

Phí: Điện 3.8k/kwh, nước 100k/ng

Dịch vụ 200k/phòng

Liên Hệ Ngay: 0375909415 (Hậu) để xem phòng và lựa chọn căn hộ ưng ý.

Vị trí & bản đồ

Địa chỉ: 416 Đường Quảng Hàm, Phường 5, Gò Vấp, Hồ Chí Minh Xem bản đồ lớn

Đặc điểm tin đăng

Mã tin: 180199145
Gói tin: Tin thường
Ngày đăng:
Ngày hết hạn:
Lưu ý

Tất cả tin rao vặt đều do người dùng đăng tải. Thuecanho123.com không chịu trách nhiệm về tính chính xác của thông tin. Chúng tôi khuyến khích bạn nên kiểm tra kỹ thông tin trước khi giao dịch. Nếu phát hiện nội dung sai phạm, vui lòng báo cáo tại đây hoặc qua hotline 0839202123 để được hỗ trợ nhanh chóng và kịp thời.

Tìm kiếm theo từ khóa

Tin đăng mới cập nhật

Dự án căn hộ cùng khu vực
Phản ánh tin đăng

Lý do phản ánh:

Thông tin liên hệ

Chia sẻ

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

https://thuecanho.lbkdev.com/ho-chi-minh/go-vap/180199145.html
Sao chép
Chọn khu vực
  • Toàn quốc
Chọn quận huyện
  • Tất cả
Chọn phường xã
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ợ
Queries184Models385
Request history8MBMemory Usage
184 statements were executed, 122 of which were duplicates, 62 unique. Show only duplicated292ms
  • 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` = '/ho-chi-minh/go-vap/180199145.html' limit 16.52mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /ho-chi-minh/go-vap/180199145.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_posts` where `code` = '180199145' and `tch_posts`.`deleted_at` is null limit 1199mstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 180199145
    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/PostHelper.php:45
    • 17. app/Helpers/Khelper.php:1120
    • 18. middleware::post.hook:16
    • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 20. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)896311
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 89631
    • Extra: Using where
  • select * from `tch_users` where `tch_users`.`id` in (2633) and `tch_users`.`deleted_at` is null600μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180199145)490μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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_packages` where `tch_packages`.`id` in (31)390μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null400μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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_provinces` where `tch_provinces`.`id` in (1)390μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.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 (6)360μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.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_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (6)490μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 6
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)470μstch123_dev_2020PostHelper.php#45
    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/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (0)360μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. middleware::post.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - 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_posts` where `code` = '180199145' and `tch_posts`.`deleted_at` is null limit 1620μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 180199145
    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/PostHelper.php:45
    • 17. app/Helpers/Khelper.php:1120
    • 18. app/Http/Controllers/PostController.php:16
    • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)896311
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 89631
    • Extra: Using where
  • select * from `tch_users` where `tch_users`.`id` in (2633) and `tch_users`.`deleted_at` is null380μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180199145)300μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_packages` where `tch_packages`.`id` in (31)320μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null320μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_provinces` where `tch_provinces`.`id` in (1)280μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 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 (6)280μstch123_dev_2020PostHelper.php#45
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 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_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (6)400μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 6
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)390μstch123_dev_2020PostHelper.php#45
    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/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (0)320μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PostHelper.php:45
    • 22. app/Helpers/Khelper.php:1120
    • 23. app/Http/Controllers/PostController.php:16
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1290μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/Khelper.php:195
    • 19. app/Http/Controllers/PostController.php:39
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 21. 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_province` in (1) order by `ordering` asc, `id_province` asc, `name` asc340μ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/Http/Controllers/PostController.php:39
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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 `tch_posts`.* from `tch_posts` where `estate_id` = 5 and `province_id` = 1 and `district_id` = 6 and `id` <> 180199145 and `project_id` <> 0 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 `created_at` desc limit 10 offset 027.78mstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 5
    • 1: 1
    • 2: 6
    • 3: 180199145
    • 4: 0
    • 5: 1
    • 6: 0
    • 7: approved
    Backtrace
    • 15. app/Helpers/PostHelper.php:169
    • 16. app/Helpers/Khelper.php:1733
    • 17. app/Http/Controllers/PostController.php:47
    • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)8411
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: index_merge
    • possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at,district_id_published_status_out_of_service_deleted_at
    • key: out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at
    • key_len: 6,317
    • ref: 
    • rows: 841
    • Extra: Using intersect(out_of_service_deleted_at,district_id_published_status_out_of_service_deleted_at); Using where; Using filesort
  • select * from `tch_packages` where `tch_packages`.`id` in (37)520μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (155, 158, 159, 169, 171, 172, 3157) and `tch_projects`.`deleted_at` is null550μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)71
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 7
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)340μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. 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 (6)340μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. 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_users` where `tch_users`.`id` in (13355, 17731, 17945, 17948, 18489, 18490, 18658) and `tch_users`.`deleted_at` is null490μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_users` (SIMPLE)71
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: range
    • possible_keys: PRIMARY,deleted_at
    • key: deleted_at
    • key_len: 9
    • ref: 
    • rows: 7
    • Extra: Using index condition
  • 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)470μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (6)450μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 6
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223013, 180223053, 180223056, 180223070, 180223268, 180223272, 180223277, 180223281, 180223318, 180223322)340μstch123_dev_2020PostHelper.php#170
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:170
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:47
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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 `tch_posts`.* from `tch_posts` where `district_id` = 6 and `package_id` in (34, 35, 36) and `id` <> 180199145 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 field(package_id,34,35,36), `ordering` desc, `published_at` desc limit 5 offset 0830μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 6
    • 1: 34
    • 2: 35
    • 3: 36
    • 4: 180199145
    • 5: 1
    • 6: 0
    • 7: approved
    • 8: 34
    • 9: 35
    • 10: 36
    Backtrace
    • 15. app/Helpers/PostHelper.php:169
    • 16. app/Helpers/Khelper.php:1733
    • 17. app/Http/Controllers/PostController.php:50
    • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)141
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: range
    • possible_keys: PRIMARY,out_of_service_deleted_at,package_id_deleted_at,status_published_out_of_service_ordering_deleted_at,district_id_published_status_out_of_service_deleted_at
    • key: package_id_deleted_at
    • key_len: 9
    • ref: 
    • rows: 14
    • Extra: Using index condition; Using where; Using filesort
  • select `tch_posts`.* from `tch_posts` where `province_id` = 1 and `package_id` in (34, 35, 36) and `id` <> 180199145 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 field(package_id,34,35,36), `ordering` desc, `published_at` desc limit 5 offset 0930μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 1
    • 1: 34
    • 2: 35
    • 3: 36
    • 4: 180199145
    • 5: 1
    • 6: 0
    • 7: approved
    • 8: 34
    • 9: 35
    • 10: 36
    Backtrace
    • 15. app/Helpers/PostHelper.php:169
    • 16. app/Helpers/Khelper.php:1733
    • 17. app/Http/Controllers/PostController.php:52
    • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)141
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: range
    • possible_keys: PRIMARY,out_of_service_deleted_at,package_id_deleted_at,status_published_out_of_service_ordering_deleted_at,province_id_published_status_ordering_out_of_deleted_at
    • key: package_id_deleted_at
    • key_len: 9
    • ref: 
    • rows: 14
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_packages` where `tch_packages`.`id` in (34)320μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0, 450, 2602) and `tch_projects`.`deleted_at` is null560μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)31
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 3
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. 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 (3, 14, 15, 20, 22)300μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_users` where `tch_users`.`id` in (25, 1002, 1024, 3817, 18363) and `tch_users`.`deleted_at` is null390μstch123_dev_2020PostHelper.php#169
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_users` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: range
    • possible_keys: PRIMARY,deleted_at
    • key: deleted_at
    • key_len: 9
    • ref: 
    • rows: 5
    • Extra: Using index condition
  • 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)360μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (3, 14, 15, 20, 22)490μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 3
    • 4: 14
    • 5: 15
    • 6: 20
    • 7: 22
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:169
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (118476, 180172984, 180218543, 180223141, 180223433)280μstch123_dev_2020PostHelper.php#170
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:170
    • 21. app/Helpers/Khelper.php:1733
    • 22. app/Http/Controllers/PostController.php:52
    • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)51
    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: 5
    • Extra: Using index condition
  • select * from `tch_pages` where `indexed` = 5 limit 1310μ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/Helpers/Khelper.php:890
    • 18. app/Models/Post.php:755
    • 19. app/Helpers/Khelper.php:2231
    • 20. app/Http/Controllers/PostController.php:62
  • - 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)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. app/Models/Post.php:755
    • 24. app/Helpers/Khelper.php:2231
    • 25. app/Http/Controllers/PostController.php:62
  • - 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)200μ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. app/Models/Post.php:755
    • 24. app/Helpers/Khelper.php:2231
    • 25. app/Http/Controllers/PostController.php:62
  • - 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 null260μ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. app/Models/Post.php:755
    • 24. app/Helpers/Khelper.php:2231
    • 25. app/Http/Controllers/PostController.php:62
  • - 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)280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:755
    • 24. app/Helpers/Khelper.php:2231
    • 25. app/Http/Controllers/PostController.php:62
  • - 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_estates` where `tch_estates`.`id` = 5 limit 1270μstch123_dev_2020Page.php#346
    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
    • 21. app/Models/Page.php:346
    • 22. app/Helpers/Khelper.php:2247
    • 23. app/Http/Controllers/PostController.php:62
    • 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 * 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:2247
    • 23. app/Http/Controllers/PostController.php:62
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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` = 0 limit 1200μstch123_dev_2020Page.php#371
    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:371
    • 22. app/Helpers/Khelper.php:2247
    • 23. app/Http/Controllers/PostController.php:62
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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_provinces` where `tch_provinces`.`id` = 1 limit 1200μstch123_dev_2020Page.php#376
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:376
    • 22. app/Helpers/Khelper.php:2247
    • 23. app/Http/Controllers/PostController.php:62
    • 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_estates` where `tch_estates`.`id` = 5 limit 1220μstch123_dev_2020Page.php#346
    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
    • 21. app/Models/Page.php:346
    • 22. app/Helpers/Khelper.php:2255
    • 23. app/Http/Controllers/PostController.php:62
    • 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 * 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. app/Helpers/Khelper.php:2255
    • 23. app/Http/Controllers/PostController.php:62
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - 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` = 6 limit 1220μstch123_dev_2020Page.php#371
    Bindings
    • 0: 6
    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:371
    • 22. app/Helpers/Khelper.php:2255
    • 23. app/Http/Controllers/PostController.php:62
    • 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_abilities` where (exists (select * from `tch_roles` inner join `tch_permissions` on `tch_roles`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `tch_permissions`.`entity_type` = 'roles' and (`tch_roles`.`scope` is null) and (`tch_permissions`.`scope` is null) and (exists (select * from `tch_users` inner join `tch_assigned_roles` on `tch_users`.`id` = `tch_assigned_roles`.`entity_id` where `tch_assigned_roles`.`role_id` = `tch_roles`.`id` and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 2633 and (`tch_roles`.`scope` is null) and (`tch_assigned_roles`.`scope` is null)))) or exists (select * from `tch_users` inner join `tch_permissions` on `tch_users`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `tch_permissions`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 2633 and (`tch_abilities`.`scope` is null) and (`tch_permissions`.`scope` is null)) or exists (select * from `tch_permissions` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 1 and `entity_id` is null and (`tch_permissions`.`scope` is null))) and (`tch_abilities`.`scope` is null)1.13mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 1
    • 1: roles
    • 2: App\Models\User
    • 3: 2633
    • 4: 1
    • 5: App\Models\User
    • 6: 2633
    • 7: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. vendor/silber/bouncer/src/BaseClipboard.php:101
    • 16. vendor/silber/bouncer/src/CachedClipboard.php:213
    • 17. vendor/silber/bouncer/src/CachedClipboard.php:198
    • 18. vendor/silber/bouncer/src/BaseClipboard.php:111
    • 19. vendor/silber/bouncer/src/CachedClipboard.php:77
  • - EXPLAIN # 1: `tch_abilities` (PRIMARY)211
    Params
    • id: 1
    • select_type: PRIMARY
    • table: tch_abilities
    • type: ALL
    • possible_keys: abilities_scope_index
    • key: 
    • key_len: 
    • ref: 
    • rows: 21
    • Extra: Using where
  • - EXPLAIN # 5: `` (MATERIALIZED)5
    Params
    • id: 5
    • select_type: MATERIALIZED
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE
  • - EXPLAIN # 4: `tch_users` (DEPENDENT SUBQUERY)14
    Params
    • id: 4
    • select_type: DEPENDENT SUBQUERY
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: Using index
  • - EXPLAIN # 4: `tch_permissions` (DEPENDENT SUBQUERY)14
    Params
    • id: 4
    • select_type: DEPENDENT SUBQUERY
    • table: tch_permissions
    • type: ref
    • possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
    • key: permissions_entity_index
    • key_len: 461
    • ref: const,const,const
    • rows: 1
    • Extra: Using index condition; Using where
  • - EXPLAIN # 2: `tch_users` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: Using index
  • - EXPLAIN # 2: `tch_assigned_roles` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_assigned_roles
    • type: ref
    • possible_keys: assigned_roles_entity_index,assigned_roles_role_id_index,assigned_roles_scope_index
    • key: assigned_roles_entity_index
    • key_len: 461
    • ref: const,const,const
    • rows: 1
    • Extra: Using index condition; Start temporary
  • - EXPLAIN # 2: `tch_roles` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_roles
    • type: eq_ref
    • possible_keys: PRIMARY,roles_name_unique,roles_scope_index
    • key: PRIMARY
    • key_len: 4
    • ref: tch123_dev_2020.tch_assigned_roles.role_id
    • rows: 1
    • Extra: Using where; End temporary
  • - EXPLAIN # 2: `tch_permissions` (MATERIALIZED)22
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_permissions
    • type: ref
    • possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
    • key: permissions_entity_index
    • key_len: 461
    • ref: tch123_dev_2020.tch_assigned_roles.role_id,const,const
    • rows: 2
    • Extra: Using index condition; Using where
  • select * from `tch_abilities` where (exists (select * from `tch_roles` inner join `tch_permissions` on `tch_roles`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `tch_permissions`.`entity_type` = 'roles' and (`tch_roles`.`scope` is null) and (`tch_permissions`.`scope` is null) and (exists (select * from `tch_users` inner join `tch_assigned_roles` on `tch_users`.`id` = `tch_assigned_roles`.`entity_id` where `tch_assigned_roles`.`role_id` = `tch_roles`.`id` and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 2633 and (`tch_roles`.`scope` is null) and (`tch_assigned_roles`.`scope` is null)))) or exists (select * from `tch_users` inner join `tch_permissions` on `tch_users`.`id` = `tch_permissions`.`entity_id` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `tch_permissions`.`entity_type` = 'App\Models\User' and `tch_users`.`id` = 2633 and (`tch_abilities`.`scope` is null) and (`tch_permissions`.`scope` is null)) or exists (select * from `tch_permissions` where `tch_permissions`.`ability_id` = `tch_abilities`.`id` and `tch_permissions`.`forbidden` = 0 and `entity_id` is null and (`tch_permissions`.`scope` is null))) and (`tch_abilities`.`scope` is null)1.04mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 0
    • 1: roles
    • 2: App\Models\User
    • 3: 2633
    • 4: 0
    • 5: App\Models\User
    • 6: 2633
    • 7: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. vendor/silber/bouncer/src/BaseClipboard.php:101
    • 16. vendor/silber/bouncer/src/CachedClipboard.php:213
    • 17. vendor/silber/bouncer/src/CachedClipboard.php:198
    • 18. vendor/silber/bouncer/src/CachedClipboard.php:85
    • 19. vendor/silber/bouncer/src/Guard.php:172
  • - EXPLAIN # 1: `tch_abilities` (PRIMARY)211
    Params
    • id: 1
    • select_type: PRIMARY
    • table: tch_abilities
    • type: ALL
    • possible_keys: abilities_scope_index
    • key: 
    • key_len: 
    • ref: 
    • rows: 21
    • Extra: Using where
  • - EXPLAIN # 5: `` (MATERIALIZED)5
    Params
    • id: 5
    • select_type: MATERIALIZED
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE
  • - EXPLAIN # 4: `tch_users` (DEPENDENT SUBQUERY)14
    Params
    • id: 4
    • select_type: DEPENDENT SUBQUERY
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: Using index
  • - EXPLAIN # 4: `tch_permissions` (DEPENDENT SUBQUERY)14
    Params
    • id: 4
    • select_type: DEPENDENT SUBQUERY
    • table: tch_permissions
    • type: ref
    • possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
    • key: permissions_entity_index
    • key_len: 461
    • ref: const,const,const
    • rows: 1
    • Extra: Using index condition; Using where
  • - EXPLAIN # 2: `tch_users` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: Using index
  • - EXPLAIN # 2: `tch_assigned_roles` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_assigned_roles
    • type: ref
    • possible_keys: assigned_roles_entity_index,assigned_roles_role_id_index,assigned_roles_scope_index
    • key: assigned_roles_entity_index
    • key_len: 461
    • ref: const,const,const
    • rows: 1
    • Extra: Using index condition; Start temporary
  • - EXPLAIN # 2: `tch_roles` (MATERIALIZED)12
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_roles
    • type: eq_ref
    • possible_keys: PRIMARY,roles_name_unique,roles_scope_index
    • key: PRIMARY
    • key_len: 4
    • ref: tch123_dev_2020.tch_assigned_roles.role_id
    • rows: 1
    • Extra: Using where; End temporary
  • - EXPLAIN # 2: `tch_permissions` (MATERIALIZED)22
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_permissions
    • type: ref
    • possible_keys: permissions_entity_index,permissions_ability_id_index,permissions_scope_index
    • key: permissions_entity_index
    • key_len: 461
    • ref: tch123_dev_2020.tch_assigned_roles.role_id,const,const
    • rows: 2
    • Extra: Using index condition; Using where
  • select count(*) as aggregate from `tch_posts` where `tch_posts`.`user_id` = 2633 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null410μstch123_dev_2020User.php#256
    Bindings
    • 0: 2633
    Backtrace
    • 19. app/Models/User.php:256
    • 20. view::_desktop.main.post.post:23
    • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)1631
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: user_id_published_deleted_at
    • key: user_id_published_deleted_at
    • key_len: 4
    • ref: const
    • rows: 163
    • Extra: Using where; Using index
  • 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.post.post:24
    • 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)3435602
    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: 343560
    • 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.post.post:24
    • 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)250μ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.post.post:24
    • 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)220μ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.post.post:24
    • 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)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.post.post:24
    • 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` = 'use_replace_highlight' limit 1250μstch123_dev_2020Setting.php#23
    Bindings
    • 0: use_replace_highlight
    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/Helpers/Khelper.php:1505
    • 17. view::_desktop.main.post.post:192
    • 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_estates` where `tch_estates`.`id` = 5 limit 1270μstch123_dev_2020Post.php#223
    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
    • 20. app/Models/Post.php:223
    • 21. app/Helpers/Khelper.php:1515
    • 22. view::_desktop.main.post.post:192
    • 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_post_vips` where `tch_post_vips`.`post_id` = 180199145 and `tch_post_vips`.`post_id` is not null limit 1390μstch123_dev_2020post.blade.php#224
    Bindings
    • 0: 180199145
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post:224
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_post_vips` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_vips
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_global_option` where `name` = 'hotline' limit 1250μstch123_dev_2020Setting.php#23
    Bindings
    • 0: hotline
    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.post.post:260
    • 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: 
  • select * from `tch_pages` where `indexed` = '5_1_6_ward_88' limit 1290μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_6_ward_88
    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.post.post_related_tags:7
    • 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)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.post.post_related_tags:7
    • 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 (6)200μ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.post.post_related_tags:7
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null220μ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.post.post_related_tags:7
    • 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)200μ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.post.post_related_tags:7
    • 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_wards` where `tch_wards`.`id` = 88 limit 1400μstch123_dev_2020Page.php#366
    Bindings
    • 0: 88
    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.post.post_related_tags:46
    • 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: `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_global_option` where `name` = 'use_avatar_social' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: use_avatar_social
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/User.php:169
    • 17. view::_desktop.main.post.post:273
    • 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 1240μ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 1240μ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 1240μ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_pages` where `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1360μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 450 and `tch_projects`.`deleted_at` is null limit 1320μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 450
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_1_14_project_450' limit 1330μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_14_project_450
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (14)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (450) and `tch_projects`.`deleted_at` is null260μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 14 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1340μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 14
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 450 and `tch_projects`.`deleted_at` is null limit 1310μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 450
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_1_14_project_450' limit 1320μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_14_project_450
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (14)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (450) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 21 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1330μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 21
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1230μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 2607 and `tch_projects`.`deleted_at` is null limit 1290μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 2607
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_1_21_project_2607' limit 1340μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_21_project_2607
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (21)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (2607) 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 11 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1300μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 11
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 0 and `tch_projects`.`deleted_at` is null limit 1290μstch123_dev_2020post-item-horizontal.blade.php#69
    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. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `` (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 `tch_pages`.`district_id` = 21 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1300μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 21
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 3060 and `tch_projects`.`deleted_at` is null limit 1290μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 3060
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_1_21_project_3060' limit 1310μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_21_project_3060
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (21)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (3060) 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 11 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1340μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 11
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 0 and `tch_projects`.`deleted_at` is null limit 1300μstch123_dev_2020post-item-horizontal.blade.php#69
    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. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `` (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 `tch_pages`.`district_id` = 11 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1500μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 11
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 0 and `tch_projects`.`deleted_at` is null limit 1280μstch123_dev_2020post-item-horizontal.blade.php#69
    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. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `` (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 `tch_pages`.`district_id` = 9 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1350μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 9
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1230μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 250 and `tch_projects`.`deleted_at` is null limit 1320μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 250
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_1_9_project_250' limit 1360μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_9_project_250
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (9)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (250) and `tch_projects`.`deleted_at` is null240μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 27 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1300μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 27
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 1030 and `tch_projects`.`deleted_at` is null limit 1300μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 1030
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_2_27_project_1030' limit 1330μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_2_27_project_1030
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (27)190μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (1030) and `tch_projects`.`deleted_at` is null240μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `tch_pages`.`district_id` = 27 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1320μstch123_dev_2020post-item-horizontal.blade.php#16
    Bindings
    • 0: 27
    • 1: 0
    • 2: 0
    • 3: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:16
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μ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-horizontal:30
    • 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_projects` where `tch_projects`.`id` = 1030 and `tch_projects`.`deleted_at` is null limit 1300μstch123_dev_2020post-item-horizontal.blade.php#69
    Bindings
    • 0: 1030
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. view::_desktop.main.post.post-item-horizontal:69
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 26. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_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 `indexed` = '5_2_27_project_1030' limit 1450μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_2_27_project_1030
    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. app/Models/Post.php:455
    • 19. view::_desktop.main.post.post-item-horizontal:71
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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` in (27)200μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. 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_projects` where `tch_projects`.`id` in (1030) and `tch_projects`.`deleted_at` is null240μ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. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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/Helpers/Khelper.php:890
    • 23. app/Models/Post.php:455
    • 24. view::_desktop.main.post.post-item-horizontal:71
    • 26. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - 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 `province_id` = 1 and `district_id` = 6 order by `count` desc, `created_at` desc limit 20520μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 1
    • 2: 6
    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.post.post:392
    • 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)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.post.post:392
    • 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 (6)250μ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.post.post:392
    • 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)240μ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.post.post:392
    • 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 (154, 155, 156, 158, 159, 162, 163, 165, 169, 171, 172, 173, 175, 176, 178, 2563, 2664, 2665, 3052, 3157) and `tch_projects`.`deleted_at` is null460μ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.post.post:392
    • 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)201
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 20
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)280μ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.post.post:392
    • 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_global_option` where `name` = 'using_google_cached_image' limit 1400μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.includes.head:48
    • 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 `name`, `tch_roles`.`id`, `tch_assigned_roles`.`entity_id` as `pivot_entity_id`, `tch_assigned_roles`.`role_id` as `pivot_role_id`, `tch_assigned_roles`.`entity_type` as `pivot_entity_type`, `tch_assigned_roles`.`scope` as `pivot_scope` from `tch_roles` inner join `tch_assigned_roles` on `tch_roles`.`id` = `tch_assigned_roles`.`role_id` where `tch_assigned_roles`.`entity_id` = 2633 and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and (`tch_assigned_roles`.`scope` is null) and (`tch_roles`.`scope` is null)460μstch123_dev_2020BaseClipboard.php#76
    Bindings
    • 0: 2633
    • 1: App\Models\User
    Backtrace
    • 15. vendor/silber/bouncer/src/BaseClipboard.php:76
    • 16. vendor/silber/bouncer/src/CachedClipboard.php:226
    • 17. vendor/silber/bouncer/src/CachedClipboard.php:239
    • 18. vendor/silber/bouncer/src/CachedClipboard.php:225
    • 19. vendor/silber/bouncer/src/BaseClipboard.php:53
  • - EXPLAIN # 1: `tch_assigned_roles` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_assigned_roles
    • type: ref
    • possible_keys: assigned_roles_entity_index,assigned_roles_role_id_index,assigned_roles_scope_index
    • key: assigned_roles_entity_index
    • key_len: 461
    • ref: const,const,const
    • rows: 1
    • Extra: Using index condition
  • - EXPLAIN # 1: `tch_roles` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_roles
    • type: eq_ref
    • possible_keys: PRIMARY,roles_scope_index
    • key: PRIMARY
    • key_len: 4
    • ref: tch123_dev_2020.tch_assigned_roles.role_id
    • rows: 1
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μ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.includes.head:196
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `indexed` = '5_1' limit 1350μ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)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: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)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: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 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/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)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: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` asc930μstch123_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)210μ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)250μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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.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 1310μ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)350μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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 null240μ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)200μ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` asc750μ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)270μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)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: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)260μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu: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 1480μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_3
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Helpers/Khelper.php:890
    • 18. view::_desktop.main.includes.main_menu:9
    • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (3)240μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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 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: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)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: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` asc490μ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)310μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)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.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-18' and date(`date_end`) >= '2025-04-18' order by `priority` desc limit 1380μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-18
    • 2: 2025-04-18
    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 1410μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/LocationHelper.php:185
    • 19. app/Helpers/Khelper.php:2797
    • 20. view::_desktop.main.includes.filter_box:3
    • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id_province` in (2) order by `ordering` asc, `id_province` asc, `name` asc290μstch123_dev_2020LocationHelper.php#266
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/LocationHelper.php:266
    • 23. app/Helpers/LocationHelper.php:185
    • 24. app/Helpers/Khelper.php:2797
    • 25. view::_desktop.main.includes.filter_box:3
    • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id_province` = 2 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc310μstch123_dev_2020Province.php#28
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. app/Models/Province.php:28
    • 17. app/Helpers/LocationHelper.php:186
    • 18. app/Helpers/Khelper.php:2797
    • 19. view::_desktop.main.includes.filter_box:3
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_global_option` where `name` = 'address' limit 1430μ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
150District.php#?
App\Models\Page
97Page.php#?
App\Models\Project
43Project.php#?
App\Models\PostCanHoDetail
27PostCanHoDetail.php#?
App\Models\Province
24Province.php#?
App\Models\Estate
19Estate.php#?
App\Models\User
14User.php#?
App\Models\Package
8Package.php#?
App\Models\PostVip
1PostVip.php#?
App\Models\Ward
1Ward.php#?
Silber\Bouncer\Database\Role
1Role.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-18 03:48:56GET/ho-chi-minh/go-vap/180199145.html184385