Quận 2, Hồ Chí Minh
Dự án
Chọn giá
Diện tích
Số phòng ngủ
Số toilet
Hướng chính
Đặt lại

Cho Thuê Căn Hộ Chung Cư Zeit River Thủ Thiêm Mới Nhất T5/2025

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

CHO THUÊ CĂN HỘ CHUNG CƯ ZEIT RIVER THỦ THIÊM

Được đầu tư bởi GS Engineering & Construction (GS E&C Group từ Hàn Quốc), thuê và cho thuê căn hộ Zeit River Thủ Thiêm là đề tài không thể bỏ qua đối vối những ai có nhu cầu tìm chỗ ở tại khu đô thị mới Quận 2. Sở hữu vị trí ngay lõi khu đô thị Thủ Thiêm và tầm nhìn thẳng ra sông Sài Gòn, Zeit River sẽ mang đến cho khách thuê căn hộ một môi trường sống gần gũi thiên nhiên, nhưng không kém phần hiện đại. Vậy hãy cùng Thuecanho123 theo dõi bài viết này nếu quý khách đang có dự định thuê hay đầu tư cho thuê căn hộ chung cư Zeit River Thủ Thiêm. Đầu tiên mời bạn tham khảo bảng giá cho thuê dự án này bên dưới đây của được khảo sát bởi Thuecanho123.com.

Cho thuê căn hộ chung cư Zeit River Thủ Thiêm
Cho thuê căn hộ chung cư Zeit River Thủ Thiêm

Giá thuê căn hộ Zeit River Thủ Thiêm

Đối với một dự án đặc biệt như Zeit River ta không thể bỏ qua mức giá cho thuê của nó. Là một dự án hạng sang, cực kỳ cao cấp trong KĐT Thủ Thiêm, chung cư này đang được phát triển và xây dựng dưới một quy mô hết sức hoành tráng. Chỉ sau đợt mở bán đầu tiên 3 ngày, lượng căn hộ bán ra đã dường như đạt 95%, một con số không phải dự án cao cấp nào cũng có thể làm được. Được biết giá bán căn hộ này rẻ nhất đối với căn một phòng ngủ cùng từ 8.5 tỷ đồng chưa bao gồm VAT. Như vậy giá cho thuê căn hộ Zeit River Thủ Thiêm sẽ phải đạt ở mức bao nhiêu? Hãy cùng tham khảo bảng giá mà Thuecanho123 đã tổng hợp theo loại hình và diện tích căn hộ tại dự án Zeit River:

BẢNG GIÁ CHO THUÊ CĂN HỘ CHUNG CƯ ZEIT RIVER THỦ THIÊM T5/2025
Loại căn hộ Diện tích Giá cho thuê
1 phòng ngủ 60m² 23 - 25 triệu/tháng
2 phòng ngủ 88m² - 97m² 25 - 30 triệu/tháng
3 phòng ngủ 125m² - 135m² 55 - 65 triệu/tháng
4 phòng ngủ 180m² - 200m² Trên 90 triệu/tháng

Giá cho thuê căn hộ Thủ Thiêm Zeit River như trên được cho là phù hợp, bởi nếu dựa trên mức giá bán ra gần chục tỷ đồng cho đến vài chục tỷ đồng một căn hộ ngay khu đô thị Thủ Thiêm thì giá trên khá hợp lý. Tính đến thời điểm hiện tại, Thuecanho123 đã ghi nhận tổng số 2 tin đăng được môi giới và chủ nhà đăng tải. Con số này dự đoán còn tiếp tục tăng cao hơn nữa trong thời gian tới.

Thuê và cho thuê căn hộ Zeit River Thủ Thiêm có gì hấp dẫn?

Nếu bên trên là mức giá cho thuê chung cư Zeit River thì bên dưới đây, chúng tôi sẽ điểm qua những điều cực kỳ quan trọng liên quan đến dự án mà tuyệt đối dù bạn là khách đi thuê hay nhà đầu tư cho thuê cùng không nên bỏ qua.

Vị trí kết nối, di chuyển nhanh gọn

Chung cư Zeit River có địa chỉ nằm trên mặt tiền đường Nguyễn Cơ Thạch, phường An Khánh, quận 2, TP. Thủ Đức. Hay chính xác hơn là nằm ngay góc giao của tuyến Nguyễn Cơ Thạch xuyên tâm và Đại lộ Vòng Cung kết nối vào các dự án chung cư phía trong KĐT Thủ Thiêm. Địa chỉ dự án Zeit River hiện nay cũng được nhiều người trong giới chuyên môn nhận định là một vị trí đẹp, có tiềm năng phát triển rất lớn trong tương lai gần. Vì đa phần các hạ tầng giao thông trong khu vực này cũng như những dự án căn hộ khác cũng đã được hình thành và phát triển khá nhiều, tạo tiền đề cho Zeit Thủ Thiêm rất tốt. Nhu cầu cho thuê căn hộ chung cư tại Quận 2 hiện nay đang được đánh giá là một trong những sức bật rất lớn, khi mà có rất nhiều dự án đang xây dựng hoặc sắp sửa bàn giao. Khu vực này tiềm năng hơn cả chính là nhờ vị trí gần trung tâm Quận 1 sầm uất. 

Vị trí dự án Zeit River Thủ Thiêm
Vị trí dự án Zeit River Thủ Thiêm

Nếu khách có nhu cầu thuê căn hộ Zeit River thì việc kết nối trong và ngoài khu vực ở tại dự án này là điều vô cùng dễ dàng.

  • Qua Bình Thạnh nơi có Landmark 81 chỉ khoảng 1 phút lái xe thông qua cầu Thủ Thiêm 1 đã hoàn thành.
  • Vào quận 1, cư dân cũng có thể thông qua cầu Thủ Thiêm 2, hoặc hầm Thủ Thiêm và chỉ tốn vỏn vẹn 5 phút.
  • Quận Thủ Đức, quận 9 thông qua tuyến Xa Lộ Hà Nội cũng mất khoảng 5 phút
  • Từ 10 - 15 phút, cư dân cũng đã có mặt tại các quận 4, 5, 6 hoặc quận 7, Nhà Bè thông qua hầm Thủ Thiêm hoặc cầu Thủ Thiêm 4
Chuỗi 50+ tiện ích hiện đại nâng tầm cuộc sống

Ngoài vị trí, thì khách thuê căn hộ Thủ Thiêm Zeit River còn quan tâm đến những tiện ích mà mình sẽ được trải nghiệm tại đây. Tất nhiên với một dự án căn hộ cao cấp nằm ngay KĐT Thủ Thiêm thì có lẽ các tiện ích mang đến cho cư dân cũng vô cùng hoành tráng và hiện đại.

Cụ thể hơn 50 tiện ích đã được chủ đầu tư dự án là tập đoàn GS E&C đến từ Hàn Quốc triển khai vô cùng đẳng cấp. Cư dân sẽ tận hưởng một không gian sống trong lành nhờ hệ thống khuôn viên cây xanh tự nhiên bao phủ, thoải mái mua sắm ngay trong khu nhà ở của mình, những bữa tiệc cuối tuần tại khu vực BBQ, khu cắm trại. Khu vực hồ bơi và khu vui chơi cho trẻ, khu sức khỏe như GYM, spa, xông hơi cũng được xây dựng hoành tráng, đẳng cấp 5 sao.

Thiết kế phiên bản giới hạn cho giới thượng lưu

Quy mô dự án căn hộ chung cư Zeit River Thủ Thiêm bao gồm 2 tòa tháp: Tháp T1 cao 25 tầng nằm mặt tiền Đại lộ Vòng Cung và tháp T2 cao 32 tầng nằm ở mặt tiền đường Nguyễn Cơ Thạch. Dự kiến chỉ có khoảng 300 sản phẩm căn hộ hạng sang sẽ tung ra thị trường trong đó cũng có các loại hình Duplex, Penthouse, shophouse và nhà phố cũng nhận về vô số lượt quan tâm của khách hàng. Toàn bộ dự án được thiết kết theo hình dạng 4 cánh hoa xòe ra - tương ứng với 4 bán đảo Thủ Thiêm được ghép lại với nhau.

Khác biệt với những dự án khác trên thị trường, Thủ Thiêm Zeit River sở hữu thiết kế độc đáo, không rập khuôn số đông. Với mục tiêu hướng đến khách hàng thượng lưu, Zeit River được "chăm chút" trong từng chi tiết thiết kế. Từng đường nét, góc cạnh đều được trau chuốt tỉ mỉ, tạo nên không gian sống tinh tế và sang trọng. Bên cạnh đó, mỗi căn hộ đều được tối ưu hóa diện tích, mang đến sự thông thoáng và tiện nghi cho cuộc sống của gia đình bạn.

Ngoài ra, chủ đầu tư Thủ Thiêm Zeit River mong muốn mang đến cho cư dân trải nghiệm sống sang trọng với các căn hộ được bàn giao hoàn thiện nội thất cơ bản cao cấp. Bằng cách lựa chọn tỉ mỉ từng vật liệu, từ máy lạnh âm trần, tủ bếp, tủ áo, nhà vệ sinh đến sàn gỗ, tất cả đều đến từ các thương hiệu uy tín hàng đầu, đảm bảo chất lượng vượt trội và độ bền đẹp theo thời gian.

Nơi cho thuê căn hộ Thủ Thiêm Zeit River giá rẻ

Nếu bạn đang có ý định tìm thuê căn hộ chung cư Thủ Thiêm Zeit River giá rẻ hiện nay thì đừng bỏ qua trang web Thuecanho123.com của chúng tôi nhé. Giỏ hàng chung cư Zeit River cho thuê của các môi giới liên tục được cập nhật, các chủ nhà cũng thường xuyên cần cho thuê gấp với mức giá vô cùng rẻ. Riêng đối với những người mong muốn tìm một nơi đăng tin cho thuê chung cư Thủ Thiêm Zeit River hiệu quả và nhanh chóng thì ngay lập tức hãy đăng ký để trở thành đối tác đăng tin của chúng tôi. Đa dạng gói tin với giá đăng rẻ hơn thị trường, nhưng lại mang đến kết quả vô cùng hài lòng.

Tìm thuê căn hộ Zeit River Thủ Thiêm tại Thuecanho123.com
Tìm thuê căn hộ Zeit River Thủ Thiêm tại Thuecanho123.com

Hãy liên hệ với đội ngũ CSKH qua số điện thoại 0902657123 để có được sự hỗ trợ nếu bạn gặp khó khăn ở bất cứ điều gì khi sử dụng dịch vụ tại website chuyên đăng tin cho thuê chung cư Zeit River chúng tôi nhé.

Chọn khu vực
  • Toàn quốc
  • Hồ Chí Minh
  • Hà Nội
  • Bình Dương
  • Đà Nẵng
  • Hải Phòng
  • Long An
  • Bà Rịa Vũng Tàu
  • An Giang
  • Bắc Giang
  • Bắc Kạn
  • Bạc Liêu
  • Bắc Ninh
  • Bến Tre
  • Bình Định
  • Bình Phước
  • Bình Thuận
  • Cà Mau
  • Cần Thơ
  • Cao Bằng
  • Đắk Lắk
  • Đắk Nông
  • Điện Biên
  • Đồng Nai
  • Đồng Tháp
  • Gia Lai
  • Hà Giang
  • Hà Nam
  • Hà Tĩnh
  • Hải Dương
  • Hậu Giang
  • Hòa Bình
  • Hưng Yên
  • Khánh Hòa
  • Kiên Giang
  • Kon Tum
  • Lai Châu
  • Lâm Đồng
  • Lạng Sơn
  • Lào Cai
  • Nam Định
  • Nghệ An
  • Ninh Bình
  • Ninh Thuận
  • Phú Thọ
  • Phú Yên
  • Quảng Bình
  • Quảng Nam
  • Quảng Ngãi
  • Quảng Ninh
  • Quảng Trị
  • Sóc Trăng
  • Sơn La
  • Tây Ninh
  • Thái Bình
  • Thái Nguyên
  • Thanh Hóa
  • Thừa Thiên Huế
  • Tiền Giang
  • Trà Vinh
  • Tuyên Quang
  • Vĩnh Long
  • Vĩnh Phúc
  • Yên Bái
Hồ Chí Minh
  • Tất cả
  • Quận 1
  • Quận 2
  • Quận 3
  • Quận 4
  • Quận 5
  • Quận 6
  • Quận 7
  • Quận 8
  • Quận 9
  • Quận 10
  • Quận 11
  • Quận 12
  • Bình Tân
  • Bình Thạnh
  • Gò Vấp
  • Phú Nhuận
  • Tân Bình
  • Tân Phú
  • Thủ Đức
  • Bình Chánh
  • Cần Giờ
  • Củ Chi
  • Hóc Môn
  • Nhà Bè
Quận 2
  • Tất cả
  • Phường An Phú
  • Phường Bình An
  • Phường An Khánh
  • Phường Cát Lái
  • Phường Bình Khánh
  • Phường Thủ Thiêm
  • Phường Thảo Điền
  • Phường An Lợi Đông
  • Phường Bình Trưng Tây
  • Phường Thạnh Mỹ Lợi
  • Phường Bình Trưng Đông
Chọn dự án
Chọn khoảng giá
  • Tất cả
  • Dưới 5 triệu
  • 5 - 7 triệu
  • 7 - 10 triệu
  • 10 - 15 triệu
  • 15 - 20 triệu
  • 20 - 30 triệu
  • 30 - 50 triệu
  • 50 - 100 triệu
  • Trên 100 triệu
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
Số phòng ngủ
  • Tất cả
  • 1 phòng ngủ
  • 2 phòng ngủ
  • 3 phòng ngủ
  • 4+ phòng ngủ
Số toilet
  • Tất cả
  • 1 toilet
  • 2 toilet
  • 3 toilet
  • 4+ toilet
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
Request history7MBMemory Usage
159 statements were executed, 113 of which were duplicates, 46 unique. Show only duplicated138ms
  • Connection Establishedtch123_dev_2020Khelper.php#2679
    Backtrace
    • 15. app/Helpers/Khelper.php:2679
    • 16. app/Http/Middleware/RedirectTrailingSlash.php:26
    • 17. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 18. vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:75
    • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
  • select * from `tch_redirects` where `status` = 1 and `url` = '/cho-thue-can-ho-chung-cu-zeit-river-thu-thiem.html' limit 14.05mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /cho-thue-can-ho-chung-cu-zeit-river-thu-thiem.html
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/Khelper.php:2679
    • 17. app/Http/Middleware/RedirectTrailingSlash.php:26
    • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 19. vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:75
    • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
  • - EXPLAIN # 1: `tch_redirects` (SIMPLE)18161
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_redirects
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 1816
    • Extra: Using where
  • select * from `tch_pages` where `tch_pages`.`id` = 1 limit 1510μstch123_dev_2020PageHelper.php#58
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 20. app/Helpers/PageHelper.php:58
    • 21. app/Helpers/Khelper.php:256
    • 22. middleware::page.hook:14
    • 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 24. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `slug` = 'cho-thue-can-ho-chung-cu-zeit-river-thu-thiem' limit 11.72mstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-zeit-river-thu-thiem
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:100
    • 17. app/Helpers/Khelper.php:279
    • 18. middleware::page.hook:16
    • 19. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 20. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: slug_deleted_at
    • key: slug_deleted_at
    • key_len: 767
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)390μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)400μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (3021) and `tch_projects`.`deleted_at` is null660μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)370μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. middleware::page.hook:16
    • 24. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
    • 25. app/Http/Middleware/LastUserActivity.php:25
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `slug` = 'cho-thue-can-ho-chung-cu-zeit-river-thu-thiem' limit 1430μstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-zeit-river-thu-thiem
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:100
    • 17. app/Helpers/Khelper.php:279
    • 18. app/Http/Controllers/PageController.php:37
    • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: slug_deleted_at
    • key: slug_deleted_at
    • key_len: 767
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)270μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)270μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (3021) and `tch_projects`.`deleted_at` is null310μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)280μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc350μstch123_dev_2020LocationHelper.php#24
    Hints
    • 0: The SELECT statement has no WHERE clause and could examine many more rows than intended
    Backtrace
    • 15. app/Helpers/LocationHelper.php:24
    • 16. app/Helpers/Khelper.php:1972
    • 17. app/Services/Page/PageService.php:377
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)631
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 63
    • Extra: Using filesort
  • select * from `tch_global_option` where `name` = 'post_paging' limit 1340μstch123_dev_2020Setting.php#23
    Bindings
    • 0: post_paging
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Services/Page/PageService.php:362
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select count(*) as aggregate from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `project_id` = 3021 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null1.01mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 3021
    • 1: approved
    • 2: 1
    • 3: 0
    Backtrace
    • 16. app/Services/Page/PageService.php:365
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
    • key: project_id_published_status_out_of_service_ordering_deleted_at
    • key_len: 312
    • ref: const,const,const,const
    • rows: 2
    • Extra: Using where; Using index
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: tch123_dev_2020.tch_posts.id
    • rows: 1
    • Extra: Using where; Using index
  • select `tch_posts`.* from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `project_id` = 3021 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null order by `tch_posts`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 01.62mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 3021
    • 1: approved
    • 2: 1
    • 3: 0
    Backtrace
    • 16. app/Services/Page/PageService.php:365
    • 17. app/Services/Page/PageService.php:425
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: ref
    • possible_keys: out_of_service_deleted_at,project_id_published_deleted_at,status_published_out_of_service_ordering_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at
    • key: project_id_published_deleted_at
    • key_len: 13
    • ref: const,const,const
    • rows: 2
    • Extra: Using index condition; Using where; Using filesort
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: tch123_dev_2020.tch_posts.id
    • rows: 1
    • Extra: Using where; Using index
  • select * from `tch_packages` where `tch_packages`.`id` in (31, 37)410μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)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_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180207712, 180222510)1mstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using index condition
  • select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180207712, 180222510)1.39mstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_expands
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using index condition
  • select * from `tch_projects` where `tch_projects`.`id` in (3021) and `tch_projects`.`deleted_at` is null310μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (3021)34.95mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 3021
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)420μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)510μstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_districts` where `tch_districts`.`id` in (14)470μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (14)730μstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `street_id` = 0 and `project_id` = 0 and `ward_id` > 0 and `tch_pages`.`ward_id` in (182)33.12mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 182
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_users` where `tch_users`.`id` in (1002, 1413) and `tch_users`.`deleted_at` is null770μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_users` (SIMPLE)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_provinces` where `tch_provinces`.`id` = 1 limit 1370μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/Khelper.php:195
    • 19. app/Services/Page/PageService.php:427
    • 20. app/Services/Page/PageService.php:32
    • 21. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id_province` in (1) order by `ordering` asc, `id_province` asc, `name` asc400μstch123_dev_2020LocationHelper.php#266
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/LocationHelper.php:266
    • 23. app/Helpers/Khelper.php:195
    • 24. app/Services/Page/PageService.php:427
    • 25. app/Services/Page/PageService.php:32
    • 26. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)241
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 24
    • Extra: Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id_province` = 1 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc430μstch123_dev_2020Province.php#28
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. app/Models/Province.php:28
    • 17. app/Services/Page/PageService.php:427
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)241
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 24
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1330μstch123_dev_2020LocationHelper.php#322
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 20. app/Helpers/LocationHelper.php:322
    • 21. app/Helpers/Khelper.php:207
    • 22. app/Services/Page/PageService.php:430
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select `id`, CONCAT(pre," ",name) as text, CONCAT(pre," ",name) as name from `tch_wards` where `tch_wards`.`id_district` = 14 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc780μstch123_dev_2020District.php#34
    Bindings
    • 0: 14
    Backtrace
    • 16. app/Models/District.php:34
    • 17. app/Services/Page/PageService.php:430
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
    • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_wards` (SIMPLE)111
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_wards
    • type: ref
    • possible_keys: id_district
    • key: id_district
    • key_len: 4
    • ref: const
    • rows: 11
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_pages` where `indexed` = 5 limit 1380μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Models/Page.php:183
    • 18. app/Helpers/Khelper.php:2292
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (0)240μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_districts` where `tch_districts`.`id` in (0)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null340μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)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/Models/Page.php:183
    • 23. app/Helpers/Khelper.php:2292
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `indexed` = '5_1' limit 1460μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Models/Page.php:189
    • 18. app/Helpers/Khelper.php:2306
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)240μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)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/Models/Page.php:189
    • 23. app/Helpers/Khelper.php:2306
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `indexed` = '5_1_14' limit 1560μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Models/Page.php:216
    • 18. app/Helpers/Khelper.php:2307
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)300μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is 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/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:216
    • 23. app/Helpers/Khelper.php:2307
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1370μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. app/Helpers/Khelper.php:2346
    • 23. app/Services/Page/PageService.php:448
    • 24. app/Services/Page/PageService.php:32
    • 25. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_pages` where `indexed` = '5_1_14_project_3021' limit 1560μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_14_project_3021
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Models/Page.php:303
    • 18. app/Helpers/Khelper.php:2350
    • 19. app/Services/Page/PageService.php:448
    • 20. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_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 (3021) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` in (5)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1360μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. app/Helpers/Khelper.php:2355
    • 23. app/Services/Page/PageService.php:448
    • 24. app/Services/Page/PageService.php:32
    • 25. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_pages` where `indexed` = '5_1' limit 1370μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/Helpers/Khelper.php:890
    • 18. view::_desktop.main.includes.khuvuc:4
    • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ref
    • possible_keys: indexed_deleted_at
    • key: indexed_deleted_at
    • key_len: 768
    • ref: const
    • rows: 1
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.khuvuc:4
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `estate_id` = 5 and `province_id` = 1 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc1.09mstch123_dev_2020Page.php#245
    Bindings
    • 0: 5
    • 1: 1
    • 2: 0
    • 3: 0
    • 4: 0
    • 5: 0
    • 6: 1
    • 7: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Models/Page.php:245
    • 16. view::_desktop.main.includes.khuvuc:5
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)10991
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: range
    • possible_keys: estate_id_deleted_at,estate_id_province_id_deleted_at,estate_id_province_id_district_id_deleted_at,count_deleted_at,published_deleted_at,estate_id_project_id_deleted_at
    • key: estate_id_province_id_district_id_deleted_at
    • key_len: 15
    • ref: 
    • rows: 1099
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)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.khuvuc:5
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (1, 2, 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.khuvuc:5
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)221
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 22
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)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.khuvuc:5
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1370μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1330μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1330μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1290μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1310μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1330μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1260μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1260μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1290μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1260μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1340μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1240μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1230μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`parent_id` = 3021 and `tch_projects`.`parent_id` is not null and `tch_projects`.`deleted_at` is null5.33mstch123_dev_2020page_part_project_childs.blade.php#15
    Bindings
    • 0: 3021
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. view::_desktop.main.page.page_part.page_part_project_childs:15
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 21. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)15401
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 1540
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1390μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_estates` where `tch_estates`.`id` = 5 limit 1390μ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. view::_desktop.main.post.post-item:86
    • 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_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_projects` where `tch_projects`.`id` = 3021 and `tch_projects`.`deleted_at` is null limit 1580μstch123_dev_2020Page.php#363
    Bindings
    • 0: 3021
    Hints
    • 0: Use SELECT * 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:363
    • 22. view::_desktop.main.post.post-item:86
    • 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_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` = 5 limit 1300μ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. view::_desktop.main.post.post-item:91
    • 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_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` = 182 limit 1260μstch123_dev_2020Page.php#366
    Bindings
    • 0: 182
    Hints
    • 0: Use SELECT * 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-item:91
    • 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_wards` where `tch_wards`.`id` = 182 limit 1250μstch123_dev_2020post-item.blade.php#91
    Bindings
    • 0: 182
    Hints
    • 0: Use SELECT * 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:91
    • 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_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` = 'using_google_cached_image' limit 1340μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` = 182 limit 1320μstch123_dev_2020post-item.blade.php#91
    Bindings
    • 0: 182
    Hints
    • 0: Use SELECT * 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:91
    • 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_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 project_id, COUNT(*) as total from `tch_posts` where `district_id` = 14 and `created_at` > '2025-02-27 00:00:00' and `project_id` > 0 and `tch_posts`.`deleted_at` is null group by `project_id` having COUNT(*) > 0 order by COUNT(*) DESC limit 20390μstch123_dev_2020ProjectHelper.php#255
    Bindings
    • 0: 14
    • 1: 2025-02-27 00:00:00
    • 2: 0
    • 3: 0
    Backtrace
    • 15. app/Helpers/ProjectHelper.php:255
    • 16. view::_desktop.main.page.page_part.page_part_project:8
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: range
    • possible_keys: project_id_published_deleted_at,project_id_published_status_out_of_service_ordering_deleted_at,district_id_published_status_out_of_service_deleted_at,created_at
    • key: created_at
    • key_len: 5
    • ref: 
    • rows: 1
    • Extra: Using index condition; Using where; Using temporary; Using filesort
  • select * from `tch_pages` where `project_id` > '0' and `province_id` = 1 and `count` > 0 and `district_id` = 14 order by `count` desc, `created_at` desc limit 151.06mstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 1
    • 2: 0
    • 3: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/PageHelper.php:208
    • 16. app/Helpers/Khelper.php:866
    • 17. view::_desktop.main.page.page_part.page_part_project:19
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)18271
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: range
    • possible_keys: count_deleted_at
    • key: count_deleted_at
    • key_len: 4
    • ref: 
    • rows: 1827
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)290μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` in (0)230μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (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 (402, 404, 405, 420, 422, 426, 450, 462, 2434, 2450, 2493, 2530, 2537, 2649, 2881) and `tch_projects`.`deleted_at` is null650μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)151
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 15
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)320μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `project_id` > '0' and `district_id` = 14 and 1 = 1 order by `created_at` desc limit 5650μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/PageHelper.php:208
    • 16. app/Helpers/Khelper.php:866
    • 17. view::_desktop.main.page.page_part.page_part_project:20
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (14)260μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` in (0)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.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (3083, 3129, 3131, 3133, 3165) and `tch_projects`.`deleted_at` is null290μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 5
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)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.page.page_part.page_part_project:20
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select `tch_posts`.* from `tch_posts` where not exists (select * from `tch_promote_post_histories` where `tch_posts`.`id` = `tch_promote_post_histories`.`post_id` and `type` = 'RECREATEPOST' and `tch_promote_post_histories`.`deleted_at` is null) and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`status` = 'approved' and `tch_posts`.`deleted_at` is null order by `tch_posts`.`created_at` desc limit 10660μstch123_dev_2020PostHelper.php#621
    Bindings
    • 0: RECREATEPOST
    • 1: 1
    • 2: 0
    • 3: approved
    Backtrace
    • 15. app/Helpers/PostHelper.php:621
    • 16. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_posts` (PRIMARY)201
    Params
    • id: 1
    • select_type: PRIMARY
    • table: tch_posts
    • type: index
    • possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at
    • key: created_at
    • key_len: 5
    • ref: 
    • rows: 20
    • Extra: Using where
  • - EXPLAIN # 2: `tch_promote_post_histories` (MATERIALIZED)3435602
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_promote_post_histories
    • type: ALL
    • possible_keys: post_id,type,deleted_at
    • key: 
    • key_len: 
    • ref: 
    • rows: 343560
    • Extra: Using where
  • select * from `tch_packages` where `tch_packages`.`id` in (31, 33, 34, 37)270μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)71
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: ALL
    • possible_keys: PRIMARY
    • key: 
    • key_len: 
    • ref: 
    • rows: 7
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1, 2)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.page.page_part.page_part_lastest_posts:3
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)21
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 2
    • Extra: Using where
  • select * from `tch_districts` where `tch_districts`.`id` in (9, 11, 14, 21, 27)240μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)230μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)101
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 10
    • Extra: Using index condition
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1330μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-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 1360μ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 1220μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1240μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1260μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1250μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_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-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 1340μ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 1340μ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 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-aside:15
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_articles` where `published` = 1 and `tch_articles`.`deleted_at` is null order by `created_at` desc limit 5490μstch123_dev_2020ArticleHelper.php#173
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Helpers/ArticleHelper.php:173
    • 16. app/Helpers/Khelper.php:2973
    • 17. view::_desktop.main.page.page_part.page_part_lastest_articles:22
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_articles` (SIMPLE)6641
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_articles
    • type: ref
    • possible_keys: published_deleted_at,deleted_at
    • key: deleted_at
    • key_len: 5
    • ref: const
    • rows: 664
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_pages` where `indexed` = '5_1' limit 1470μ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)330μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `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)300μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (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 null320μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/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)280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_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.19mstch123_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)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)390μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)221
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 22
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)310μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `indexed` = '5_2' limit 1430μ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)310μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)300μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null380μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)290μ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` asc810μ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)310μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)360μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)340μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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 1400μ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)330μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)280μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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 null350μ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)290μ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` asc500μ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)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)320μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 5
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_promotions` where `published` = 1 and date(`date_begin`) <= '2025-04-28' and date(`date_end`) >= '2025-04-28' order by `priority` desc limit 1480μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-28
    • 2: 2025-04-28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. view::_desktop.main.includes.header_user_not_login:3
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 21. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_promotions` (SIMPLE)121
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_promotions
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12
    • Extra: Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` = 2 limit 1410μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/LocationHelper.php:185
    • 19. app/Helpers/Khelper.php:2797
    • 20. view::_desktop.main.includes.filter_box:3
    • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id_province` in (2) order by `ordering` asc, `id_province` asc, `name` asc390μstch123_dev_2020LocationHelper.php#266
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/LocationHelper.php:266
    • 23. app/Helpers/LocationHelper.php:185
    • 24. app/Helpers/Khelper.php:2797
    • 25. view::_desktop.main.includes.filter_box:3
    • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id_province` = 2 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc440μstch123_dev_2020Province.php#28
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. app/Models/Province.php:28
    • 17. app/Helpers/LocationHelper.php:186
    • 18. app/Helpers/Khelper.php:2797
    • 19. view::_desktop.main.includes.filter_box:3
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1380μstch123_dev_2020DelegatesToResource.php#139
    Bindings
    • 0: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. vendor/laravel/framework/src/Illuminate/Http/Resources/DelegatesToResource.php:139
    • 22. app/Http/Resources/ProjectResource.php:17
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
    • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` = 14 limit 1340μstch123_dev_2020DelegatesToResource.php#139
    Bindings
    • 0: 14
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. vendor/laravel/framework/src/Illuminate/Http/Resources/DelegatesToResource.php:139
    • 22. app/Http/Resources/ProjectResource.php:18
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
    • 32. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_wards` where `tch_wards`.`id` = 182 limit 1310μstch123_dev_2020LocationHelper.php#284
    Bindings
    • 0: 182
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 20. app/Helpers/LocationHelper.php:284
    • 21. app/Helpers/Khelper.php:199
    • 22. app/Http/Resources/ProjectResource.php:19
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
  • - EXPLAIN # 1: `tch_wards` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_wards
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_streets` where `tch_streets`.`id` = 18658 limit 1330μstch123_dev_2020LocationHelper.php#303
    Bindings
    • 0: 18658
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 20. app/Helpers/LocationHelper.php:303
    • 21. app/Helpers/Khelper.php:203
    • 22. app/Http/Resources/ProjectResource.php:20
    • 23. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:108
    • 24. vendor/laravel/framework/src/Illuminate/Http/Resources/Json/JsonResource.php:255
  • - EXPLAIN # 1: `tch_streets` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_streets
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'address' limit 1310μ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:49
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
App\Models\District
187District.php#?
App\Models\Page
100Page.php#?
App\Models\Province
84Province.php#?
App\Models\Project
25Project.php#?
App\Models\Estate
18Estate.php#?
App\Models\Ward
15Ward.php#?
App\Models\PostCanHoDetail
12PostCanHoDetail.php#?
App\Models\Package
6Package.php#?
App\Models\Article
5Article.php#?
App\Models\PostCanHoExpand
2PostCanHoExpand.php#?
App\Models\User
2User.php#?
App\Models\Street
1Street.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-28 05:30:39GET/cho-thue-can-ho-chung-cu-zeit-river-thu-thiem.html159457