Kênh thông tin cho thuê căn hộ số 1 Việt Nam
Đăng tin
Cầu Giấy, Hà Nội
Dự án
Chọn giá
Diện tích
Số phòng ngủ
Số toilet
Hướng chính
Đặt lại

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

180177722

Cho thuê chung cư hanhub, 234 hoàng quốc việt , 3pn, full nội thất, giá 13tr

Đường Hoàng Quốc Việt, Phường Nghĩa Tân, Cầu Giấy, Hà Nội - Xem bản đồ
13 triệu/tháng
93 m2
3 phòng ngủ
2 toilet

Thông tin mô tả

Cho thuê căn hộ chính chủ 93m2 thuộc khu Nam Cường, ngõ 234 Hoàng Quốc Việt.

Căn góc, 3  phòng ngủ đều có cửa sổ, 1 phòng khách, 1 bếp, 2 WC, 2 ban công. Full nội thất cơ bản. Giá dịch vụ căn hộ 600k/tháng. Giá điện nước theo nhà nước. Tiện ích: đã có bếp từ, tủ lạnh, máy giặt, lò vi sóng, bàn ghế + giường  + tủ quần áo đã sẵn, an ninh an toàn (ngay bên cạnh Học viện kỹ thuật quân sự + bệnh viện E), gần chợ, thẳng đường về sân bay, dịch vụ tiện ích xung quanh tiện lợi, giá cả phải chăng. Có thể vào ở từ tháng 3 năm 2023. Ảnh thật mới chụp 2 ngày trước.

Cửa chính hướng Đông Nam

Giá thuê 13r/ tháng. Thanh toán 1 cọc 1 tháng, tối thiểu thuê trong 1 năm. Đã để giá thấp nhất của khu vực rồi em nhé.

Phòng 1107 chung cư HANHUD số 20 đường Tôn Quang Phiệt, đối diện CT1 Chung cư Nam Cường. Có thể vào từ ngõ 234 Hoàng Quốc Việt.

Vị trí & bản đồ

Địa chỉ: Đường Hoàng Quốc Việt, Phường Nghĩa Tân, Cầu Giấy, Hà Nội Xem bản đồ lớn

Đặc điểm tin đăng

Mã tin: 180177722
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/ha-noi/cau-giay/180177722.html
Sao chép
Chọn khu vực
  • Toàn quốc
  • Hồ Chí Minh
  • Hà Nội
  • Bình Dương
  • Đà Nẵng
  • Hải Phòng
  • Long An
  • Bà Rịa Vũng Tàu
  • An Giang
  • Bắc Giang
  • Bắc Kạn
  • Bạc Liêu
  • Bắc Ninh
  • Bến Tre
  • Bình Định
  • Bình Phước
  • Bình Thuận
  • Cà Mau
  • Cần Thơ
  • Cao Bằng
  • Đắk Lắk
  • Đắk Nông
  • Điện Biên
  • Đồng Nai
  • Đồng Tháp
  • Gia Lai
  • Hà Giang
  • Hà Nam
  • Hà Tĩnh
  • Hải Dương
  • Hậu Giang
  • Hòa Bình
  • Hưng Yên
  • Khánh Hòa
  • Kiên Giang
  • Kon Tum
  • Lai Châu
  • Lâm Đồng
  • Lạng Sơn
  • Lào Cai
  • Nam Định
  • Nghệ An
  • Ninh Bình
  • Ninh Thuận
  • Phú Thọ
  • Phú Yên
  • Quảng Bình
  • Quảng Nam
  • Quảng Ngãi
  • Quảng Ninh
  • Quảng Trị
  • Sóc Trăng
  • Sơn La
  • Tây Ninh
  • Thái Bình
  • Thái Nguyên
  • Thanh Hóa
  • Thừa Thiên Huế
  • Tiền Giang
  • Trà Vinh
  • Tuyên Quang
  • Vĩnh Long
  • Vĩnh Phúc
  • Yên Bái
Hà Nội
  • Tất cả
  • Ba Đình
  • Bắc Từ Liêm
  • Cầu Giấy
  • Hà Đông
  • Đống Đa
  • Hai Bà Trưng
  • Hoàn Kiếm
  • Hoàng Mai
  • Long Biên
  • Nam Từ Liêm
  • Tây Hồ
  • Thanh Xuân
  • Đông Anh
  • Gia Lâm
  • Ba Vì
  • Chương Mỹ
  • Đan Phượng
  • Hoài Đức
  • Mê Linh
  • Mỹ Đức
  • Phú Xuyên
  • Phúc Thọ
  • Quốc Oai
  • Sơn Tây
  • Thạch Thất
  • Thanh Oai
  • Thanh Trì
  • Thường Tín
  • Ứng Hòa
  • Sóc Sơn
Cầu Giấy
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ợ
Queries181Models362
Request history7MBMemory Usage
181 statements were executed, 119 of which were duplicates, 62 unique. Show only duplicated247ms
  • 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` = '/ha-noi/cau-giay/180177722.html' limit 13.85mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /ha-noi/cau-giay/180177722.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` = '180177722' and `tch_posts`.`deleted_at` is null limit 1160mstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 180177722
    Hints
    • 0: Use SELECT * 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 (6689) and `tch_users`.`deleted_at` is null810μ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 (180177722)510μ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)380μ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 null360μ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 (2)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. 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 (28)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. 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 (28)390μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 28
    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 (2)540μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 2
    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)500μ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` = '180177722' and `tch_posts`.`deleted_at` is null limit 1520μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 180177722
    Hints
    • 0: Use SELECT * 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 (6689) and `tch_users`.`deleted_at` is null480μ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 (180177722)330μ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 null360μ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 (2)260μ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 (28)260μ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 (28)380μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 28
    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 (2)440μstch123_dev_2020PostHelper.php#45
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 2
    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)330μ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` = 2 limit 1300μ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/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 (2) order by `ordering` asc, `id_province` asc, `name` asc370μ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)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 `tch_posts`.* from `tch_posts` where `estate_id` = 5 and `province_id` = 2 and `district_id` = 28 and `id` <> 180177722 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 04.17mstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 5
    • 1: 2
    • 2: 28
    • 3: 180177722
    • 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)6521
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: PRIMARY,out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,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: district_id_published_status_out_of_service_deleted_at
    • key_len: 317
    • ref: const,const,const,const,const
    • rows: 652
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_packages` where `tch_packages`.`id` in (31, 37)260μ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)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using where
  • select * from `tch_projects` where `tch_projects`.`id` in (1107, 1166, 2674, 2913, 3014, 3144) and `tch_projects`.`deleted_at` is null330μ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)61
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 6
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (2)250μ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 (28)220μ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 (7653, 15639, 18153, 18797) and `tch_users`.`deleted_at` is null340μ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)41
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: range
    • possible_keys: PRIMARY,deleted_at
    • key: deleted_at
    • key_len: 9
    • ref: 
    • rows: 4
    • 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 (2)320μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 2
    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 (28)320μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 28
    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 (180222214, 180222253, 180222256, 180222290, 180222314, 180222584, 180223169, 180223193, 180223372, 180223375)260μ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` = 28 and `package_id` in (34, 35, 36) and `id` <> 180177722 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 0710μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 28
    • 1: 34
    • 2: 35
    • 3: 36
    • 4: 180177722
    • 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` = 2 and `package_id` in (34, 35, 36) and `id` <> 180177722 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 025.06mstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 2
    • 1: 34
    • 2: 35
    • 3: 36
    • 4: 180177722
    • 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)136821
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • 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: province_id_published_status_ordering_out_of_deleted_at
    • key_len: 311
    • ref: const,const,const
    • rows: 13682
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_packages` where `tch_packages`.`id` in (34, 35)260μ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)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using where
  • select * from `tch_projects` where `tch_projects`.`id` in (2617) and `tch_projects`.`deleted_at` is null270μ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)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_provinces` where `tch_provinces`.`id` in (2)200μ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 (33)200μ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)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 (2245, 9801) and `tch_users`.`deleted_at` is null270μ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)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: range
    • possible_keys: PRIMARY,deleted_at
    • key: deleted_at
    • key_len: 9
    • ref: 
    • rows: 2
    • 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 (2)320μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 2
    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 (33)320μstch123_dev_2020PostHelper.php#169
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 33
    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 (180222906, 180222952)220μ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)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using index condition
  • select * from `tch_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)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: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 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. 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)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. 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 1260μ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` = 2 limit 1200μstch123_dev_2020Page.php#376
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. 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 1210μ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` = 28 limit 1200μstch123_dev_2020Page.php#371
    Bindings
    • 0: 28
    Hints
    • 0: Use SELECT * 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` = 6689 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` = 6689 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.49mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 1
    • 1: roles
    • 2: App\Models\User
    • 3: 6689
    • 4: 1
    • 5: App\Models\User
    • 6: 6689
    • 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` = 6689 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` = 6689 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.1mstch123_dev_2020BaseClipboard.php#101
    Bindings
    • 0: 0
    • 1: roles
    • 2: App\Models\User
    • 3: 6689
    • 4: 0
    • 5: App\Models\User
    • 6: 6689
    • 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` = 6689 and `tch_posts`.`user_id` is not null and `tch_posts`.`deleted_at` is null380μstch123_dev_2020User.php#256
    Bindings
    • 0: 6689
    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)31
    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: 3
    • 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 10430μ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)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_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)280μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.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)280μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.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 1240μ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` = 180177722 and `tch_post_vips`.`post_id` is not null limit 1400μstch123_dev_2020post.blade.php#224
    Bindings
    • 0: 180177722
    Hints
    • 0: Use SELECT * 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 1470μ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_2_28_ward_389' limit 1450μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_2_28_ward_389
    Hints
    • 0: Use SELECT * 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 (2)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.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 (28)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_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.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` = 389 limit 1340μstch123_dev_2020Page.php#366
    Bindings
    • 0: 389
    Hints
    • 0: Use SELECT * 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 1250μ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 1260μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 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 1380μ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 1300μ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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. 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)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 (450) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. 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` = 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 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` = 450 and `tch_projects`.`deleted_at` is null limit 1300μ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 1310μ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)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_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)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_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 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)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` = 21 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: 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 1260μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-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 1270μ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)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_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)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 (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)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 1330μ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 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` = 21 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1310μ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` = 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 1300μ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)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_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)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_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 1330μ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 1310μ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 1320μ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` = 9 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: 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 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` = 250 and `tch_projects`.`deleted_at` is null limit 1290μ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 1280μ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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. 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)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 (250) 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` = 27 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1310μ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 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` = 1030 and `tch_projects`.`deleted_at` is null limit 1290μ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 1340μ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)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)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` = 27 and `tch_pages`.`district_id` is not null and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 limit 1310μ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 1290μ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 1300μ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)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_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 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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. 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` = 2 and `district_id` = 28 order by `count` desc, `created_at` desc limit 20550μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 2
    • 2: 28
    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 (2)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: `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 (28)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 (1088, 1101, 1107, 1108, 1117, 1128, 1133, 1136, 1152, 1153, 1155, 1162, 1166, 1171, 2489, 2606, 2668, 2674, 2857, 2913) and `tch_projects`.`deleted_at` is null500μ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)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_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 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.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` = 6689 and `tch_assigned_roles`.`entity_type` = 'App\Models\User' and (`tch_assigned_roles`.`scope` is null) and (`tch_roles`.`scope` is null)470μstch123_dev_2020BaseClipboard.php#76
    Bindings
    • 0: 6689
    • 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 1310μ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)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. 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)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:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `estate_id` = 5 and `province_id` = 1 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc1.24mstch123_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)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_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)280μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu: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 1340μ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)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_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)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. 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 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.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)210μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.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` asc690μ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)200μ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)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: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 1310μ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)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: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)180μ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 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.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)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: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` asc430μ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)200μ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)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: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)200μ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-15' and date(`date_end`) >= '2025-04-15' order by `priority` desc limit 1260μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-15
    • 2: 2025-04-15
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. view::_desktop.main.includes.header_user_not_login:3
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 21. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_promotions` (SIMPLE)121
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_promotions
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12
    • Extra: Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1260μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/LocationHelper.php:185
    • 19. app/Helpers/Khelper.php:2797
    • 20. view::_desktop.main.includes.filter_box:2
    • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id_province` in (1) order by `ordering` asc, `id_province` asc, `name` asc260μstch123_dev_2020LocationHelper.php#266
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/LocationHelper.php:266
    • 23. app/Helpers/LocationHelper.php:185
    • 24. app/Helpers/Khelper.php:2797
    • 25. view::_desktop.main.includes.filter_box:2
    • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)241
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 24
    • Extra: Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id_province` = 1 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc310μstch123_dev_2020Province.php#28
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. app/Models/Province.php:28
    • 17. app/Helpers/LocationHelper.php:186
    • 18. app/Helpers/Khelper.php:2797
    • 19. view::_desktop.main.includes.filter_box:2
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)241
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 24
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_global_option` where `name` = 'address' limit 1250μ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
140District.php#?
App\Models\Page
93Page.php#?
App\Models\Project
41Project.php#?
App\Models\PostCanHoDetail
24PostCanHoDetail.php#?
App\Models\Province
24Province.php#?
App\Models\Estate
19Estate.php#?
App\Models\Package
10Package.php#?
App\Models\User
8User.php#?
App\Models\PostVip
1PostVip.php#?
App\Models\Ward
1Ward.php#?
Silber\Bouncer\Database\Role
1Role.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-15 12:33:01GET/ha-noi/cau-giay/180177722.html181362