Thủ Đức, 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ư Opal Riverside Mới Nhất T4/2025

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

CHO THUÊ CĂN HỘ CHUNG CƯ OPAL RIVERSIDE

Với 21 tin đăng hiện có trên trang Thuecanho123, thuê căn hộ Opal Riverside là một lựa chọn đáng cân nhắc cho những ai đang tìm kiếm không gian sống xanh, hiện đại và tiện nghi. Opal Riverside tọa lạc tại phường Hiệp Bình Chánh, TP. Thủ Đức, được phát triển bởi tập đoàn Đất Xanh –  top 10 nhà đầu tư bất động sản uy tín hàng đầu Việt Nam. Từ khi ra mắt, dự án đã nhận được nhiều sự quan tâm không chỉ từ giới đầu tư mà còn từ những người tìm kiếm nơi an cư lý tưởng. Hãy cùng khám phá bảng giá cho thuê mới nhất và các lý do khiến bạn nên chọn Opal Riverside trong bài viết dưới đây.

Cho thuê chung cư Opal Riverside
Cho thuê chung cư Opal Riverside

Bảng giá cho thuê căn hộ Opal Riverside

Opal Riverside, gồm hai tòa tháp cao 19 tầng với 626 căn hộ, mang đến cho cư dân những căn hộ chất lượng cao, thiết kế hiện đại với nhiều loại diện tích. Theo số liệu từ trang Thuecanho123.com, giá thuê căn hộ tại Opal Riverside hiện dao động từ 9 - 18 triệu đồng/tháng, tùy thuộc vào diện tích, nội thất và view căn hộ. Dưới đây là bảng giá khi thuê Opal Riverside chi tiết mà chúng tôi đã tổng hợp:

BẢNG GIÁ CHO THUÊ CĂN HỘ OPAL RIVERSIDE T4/2025
Loại căn hộ Giá thuê
2 phòng ngủ (66m2 - 72m2) 9 triệu - 13 triệu
3 phòng ngủ (87m2 - 112m2) 12 triệu - 18 triệu

Mỗi căn hộ tại Opal Riverside có sự đa dạng về diện tích và nội thất, do đó bạn có thể tìm được căn hộ phù hợp với nhu cầu và chính của mình.

Nội thất trong căn chung cư Opal Riverside
Nội thất trong căn chung cư Opal Riverside

3 lý do nên chọn thuê căn hộ Opal Riverside

1. Vị trí đẹp ven sông view “xịn”

Opal Riverside nằm ngay ven sông Sài Gòn, mang đến không gian sống thoáng đãng, trong lành với tầm nhìn hướng sông tuyệt đẹp. Dự án kết nối nhanh chóng đến trung tâm TP. Hồ Chí Minh như cách sân bay Tân Sơn Nhất 15p lái xe, cách quận 1 khoảng 25p lái xe và qua các tuyến đường như Quốc lộ 13, Phạm Văn Đồng và xa lộ Hà Nội.  Vị trí này không chỉ giúp cư dân dễ dàng di chuyển mà còn hưởng lợi từ mạng lưới tiện ích ngoại khu đầy đủ như trường học, bệnh viện, trung tâm thương mại và chợ đầu mối. Nên đã trở thành một khu vực vàng thu hút nhiều doanh nghiệp BĐS lớn nhỏ đến đây để đầu tư xây dựng  căn hộ chung cư Thủ Đức cho thuê

Vị trí của Opal Riverside
Vị trí của chung cư Opal Riverside

2. Không gian sống xanh mát, tiện ích đầy đủ

Opal Riverside được thiết kế với sự chú trọng đến không gian xanh, bao quanh bởi những mảng cây xanh rộng lớn và công viên ven sông diện tích lớn khoảng 8000m2. Cư dân tại đây được tận hưởng các tiện ích hiện đại như hồ bơi tràn 500m2, khu BBQ ngoài trời, phòng gym, công viên chạy bộ và khu vui chơi cho trẻ em. Tất cả tạo nên không gian sống lý tưởng cho cả gia đình trẻ và người yêu thích cuộc sống gần gũi với thiên nhiên.

3. Thiết kế căn hộ hiện đại, tối ưu hóa không gian

Các căn hộ tại Opal Riverside đều được thiết kế tối ưu hóa không gian sống, với cửa sổ lớn đón ánh sáng tự nhiên và gió trời. Nội thất căn hộ mang phong cách hiện đại, tinh tế, phù hợp với cuộc sống năng động và tiện nghi. Đặc biệt, các căn hộ cao tầng sở hữu view sông và thành phố cực kỳ đẹp mắt, mang lại cảm giác thư giãn, bình yên sau những giờ làm việc căng thẳng.

So sánh Opal Riverside với các dự án lân cận

Opal Riverside: Tọa lạc tại phường Hiệp Bình Chánh, Thủ Đức, giá thuê căn hộ 2 phòng ngủ tại đây dao động từ 12 - 18 triệu đồng/tháng, tùy thuộc vào tầng, diện tích và trang bị nội thất. Đây là dự án thuộc phân khúc cao cấp, với nhiều tiện ích và vị trí đắc địa. Cao Ốc Căn Hộ Mỹ An: cũng nằm tại phường Hiệp Bình Chánh, giá thuê căn hộ 2 phòng ngủ dao động từ 7 - 12 triệu đồng/tháng, thuộc phân khúc trung cấp. Giá cả tại đây có phần thấp hơn Opal Riverside do dự án không quá mới và không thuộc hạng cao cấp. Vị trí mặt tiền của 2 dự án này đều tương tự nhau, tuy nhiên giá thuê của Cao Ốc Căn Hộ Mỹ An rẻ hơn Opal Riverside.

Opal Riverside: Thiết kế hiện đại, tận dụng ánh sáng tự nhiên, với ban công thoáng đãng nhìn ra sông Sài Gòn, tạo không gian sống thoải mái và trong lành. Tiện ích nội khu phong phú, bao gồm hồ bơi, gym, công viên ven sông, khu BBQ, và khu vui chơi cho trẻ em. Khu vực xung quanh thoáng mát, gần sông và các khu dân cư mới, tạo môi trường sống yên tĩnh và an ninh. Cao Ốc Căn Hộ Mỹ An: Căn hộ thiết kế đơn giản nhưng vẫn đảm bảo không gian sống tiện nghi với đầy đủ ánh sáng và thông gió tự nhiên. Tiện ích nội khu cơ bản nhưng không có nhiều tiện ích cao cấp như hồ bơi hoặc phòng gym. Nằm trong khu dân cư hiện hữu, môi trường sống xung quanh ổn định, an ninh tốt, nhưng không có cảnh quan thiên nhiên đặc biệt.

Opal Riverside là lựa chọn phù hợp cho những ai ưu tiên không gian sống cao cấp, với nhiều tiện ích nội khu hiện đại và môi trường sống thoáng mát, gần sông. Tuy nhiên, chi phí thuê sẽ cao hơn. Cao Ốc Căn Hộ Mỹ An là lựa chọn tốt hơn cho những người muốn tiết kiệm chi phí thuê nhưng vẫn có không gian sống thoải mái, tiện nghi cơ bản, và vị trí thuận tiện trong khu vực.

Tìm thuê căn hộ Opal Riverside ở đâu?

Nếu bạn đang tìm kiếm thuê căn hộ Thủ Đức chất lượng, thì Opal Riverside là một trong những lựa chọn không thể bỏ qua. Hãy truy cập Thuecanho123.com để tìm thuê căn hộ Hồ Chí Minh chi tiết và chính xác nhất tại đây. Trang web cung cấp đa dạng loại căn hộ với mức giá phù hợp cho mọi nhu cầu.

Tìm thuê Opal Riverside trên Thuecanho123
Tìm thuê Opal Riverside trên Thuecanho123

Đăng tin cho thuê căn hộ Opal Riverside tại Thuecanho123.com

Nếu bạn là chính chủ hoặc môi giới đang muốn cho thuê căn hộ tại Opal Riverside, hãy truy cập ngay Thuecanho123.com để đăng tin. Với lượng truy cập lớn mỗi ngày, tin đăng của bạn sẽ tiếp cận được nhiều người và giúp bạn nhanh chóng tìm được khách thuê phù hợp. Nếu có bất kỳ thắc mắc nào, đừng ngần ngại liên hệ với đội ngũ CSKH qua hotline 0839202123 để được hỗ trợ nhanh chóng và chính xác.

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è
Thủ Đức
  • Tất cả
  • Phường Tam Phú
  • Phường Linh Tây
  • Phường Tam Bình
  • Phường Linh Trung
  • Phường Linh Xuân
  • Phường Bình Thọ
  • Phường Linh Đông
  • Phường Linh Chiểu
  • Phường Bình Chiểu
  • Phường Trường Thọ
  • Phường Trường Thạnh
  • Phường Hiệp Bình Chánh
  • Phường Hiệp Bình Phước
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
170 statements were executed, 125 of which were duplicates, 45 unique. Show only duplicated140ms
  • 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-opal-riverside.html' limit 13.61mstch123_dev_2020Khelper.php#2679
    Bindings
    • 0: 1
    • 1: /cho-thue-can-ho-chung-cu-opal-riverside.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 1450μ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-opal-riverside' limit 1840μstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-opal-riverside
    Hints
    • 0: Use SELECT * 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)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_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 (24)420μ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 (942) and `tch_projects`.`deleted_at` is null670μ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)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_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-opal-riverside' limit 1470μstch123_dev_2020PageHelper.php#100
    Bindings
    • 0: cho-thue-can-ho-chung-cu-opal-riverside
    Hints
    • 0: Use SELECT * 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)290μ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 (24)310μ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 (942) and `tch_projects`.`deleted_at` is null360μ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)290μstch123_dev_2020PageHelper.php#100
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:100
    • 22. app/Helpers/Khelper.php:279
    • 23. app/Http/Controllers/PageController.php:37
    • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc430μstch123_dev_2020LocationHelper.php#24
    Hints
    • 0: The SELECT statement has no WHERE clause and could examine many more rows than intended
    Backtrace
    • 15. app/Helpers/LocationHelper.php:24
    • 16. app/Helpers/Khelper.php:1972
    • 17. app/Services/Page/PageService.php:377
    • 18. app/Services/Page/PageService.php:32
    • 19. app/Http/Controllers/PageController.php:42
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)631
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 63
    • Extra: Using filesort
  • select * from `tch_global_option` where `name` = 'post_paging' limit 1350μ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` = 942 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null1mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 942
    • 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)211
    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: 21
    • 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` = 942 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.75mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 942
    • 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)211
    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: 21
    • 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)390μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180120075, 180120076, 180124782, 180124783, 180124784, 180125446, 180126425, 180126936, 180126937, 180127454, 180132804, 180133554, 180151206, 180151207, 180181421, 180190666, 180191131, 180199441, 180203584, 180209841)1.17mstch123_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)201
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 20
    • Extra: Using index condition
  • select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180120075, 180120076, 180124782, 180124783, 180124784, 180125446, 180126425, 180126936, 180126937, 180127454, 180132804, 180133554, 180151206, 180151207, 180181421, 180190666, 180191131, 180199441, 180203584, 180209841)1.7mstch123_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)201
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_expands
    • type: range
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: 
    • rows: 20
    • Extra: Using index condition
  • select * from `tch_projects` where `tch_projects`.`id` in (942) and `tch_projects`.`deleted_at` is null400μ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 (942)34.63mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 942
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)360μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)600μ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 (24)360μstch123_dev_2020PageService.php#365
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Services/Page/PageService.php:365
    • 22. app/Services/Page/PageService.php:425
    • 23. app/Services/Page/PageService.php:32
    • 24. app/Http/Controllers/PageController.php:42
    • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
  • - EXPLAIN # 1: `tch_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 (24)32.19mstch123_dev_2020PageService.php#365
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 24
    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 (1004, 1105, 1438, 1537, 1721, 2770, 6964, 8457, 11226) and `tch_users`.`deleted_at` is null1.35mstch123_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)91
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: range
    • possible_keys: PRIMARY,deleted_at
    • key: deleted_at
    • key_len: 9
    • ref: 
    • rows: 9
    • Extra: Using index condition
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1500μ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` asc480μ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` asc620μ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` = 24 limit 1470μstch123_dev_2020LocationHelper.php#322
    Bindings
    • 0: 24
    Hints
    • 0: Use SELECT * 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` = 24 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc860μstch123_dev_2020District.php#34
    Bindings
    • 0: 24
    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)131
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_wards
    • type: ref
    • possible_keys: id_district
    • key: id_district
    • key_len: 4
    • ref: const
    • rows: 13
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_pages` where `indexed` = 5 limit 1490μ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)340μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/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)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: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 null410μ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)380μ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 1520μ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)380μ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)360μ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 null460μ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)320μ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_24' limit 1490μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_24
    Hints
    • 0: Use SELECT * 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)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/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 (24)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/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 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/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)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/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 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. 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_24_project_942' limit 1660μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1_24_project_942
    Hints
    • 0: Use SELECT * 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)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: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 (24)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (942) and `tch_projects`.`deleted_at` is null300μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php: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)260μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Models/Page.php:303
    • 23. app/Helpers/Khelper.php:2350
    • 24. app/Services/Page/PageService.php:448
    • 25. app/Services/Page/PageService.php:32
  • - EXPLAIN # 1: `tch_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 1400μ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 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/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)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.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 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/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)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.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.22mstch123_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)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.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)380μ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)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.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 1400μ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 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 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 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 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 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 1250μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. 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 1250μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. 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 1250μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. 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 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 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_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 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 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_wards` where `tch_wards`.`id` = 0 limit 1220μstch123_dev_2020Page.php#366
    Bindings
    • 0: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 21. app/Models/Page.php:366
    • 22. view::_desktop.main.includes.khuvuc:34
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_wards` where `tch_wards`.`id` = 0 limit 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` = 942 and `tch_projects`.`parent_id` is not null and `tch_projects`.`deleted_at` is null4.65mstch123_dev_2020page_part_project_childs.blade.php#13
    Bindings
    • 0: 942
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. view::_desktop.main.page.page_part.page_part_project_childs:13
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
    • 21. vendor/laravel/framework/src/Illuminate/View/View.php:208
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)15401
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 1540
    • Extra: Using where
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1280μ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_global_option` where `name` = 'using_google_cached_image' limit 1370μ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_global_option` where `name` = 'using_google_cached_image' limit 1380μ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_global_option` where `name` = 'using_google_cached_image' limit 1310μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1370μ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_global_option` where `name` = 'using_google_cached_image' limit 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_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_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_global_option` where `name` = 'using_google_cached_image' limit 1320μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_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: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_global_option` where `name` = 'using_google_cached_image' limit 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_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_global_option` where `name` = 'using_google_cached_image' limit 1300μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1310μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item:33
    • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
  • select project_id, COUNT(*) as total from `tch_posts` where `district_id` = 24 and `created_at` > '2025-02-03 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 20380μstch123_dev_2020ProjectHelper.php#255
    Bindings
    • 0: 24
    • 1: 2025-02-03 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` = 24 order by `count` desc, `created_at` desc limit 15680μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 1
    • 2: 0
    • 3: 24
    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)260μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project:19
    • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_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 (24)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: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)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: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 (912, 913, 918, 920, 932, 941, 942, 951, 2452, 2469, 2499, 2522, 2564, 2597, 2927) and `tch_projects`.`deleted_at` is null550μ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)410μ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` = 24 and 1 = 1 order by `created_at` desc limit 5500μstch123_dev_2020PageHelper.php#208
    Bindings
    • 0: 0
    • 1: 24
    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)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_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 (24)270μstch123_dev_2020PageHelper.php#208
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PageHelper.php:208
    • 21. app/Helpers/Khelper.php:866
    • 22. view::_desktop.main.page.page_part.page_part_project: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)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: `` (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 (3087, 3091, 3092, 3093, 3146) and `tch_projects`.`deleted_at` is null310μ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)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: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 10520μstch123_dev_2020PostHelper.php#621
    Bindings
    • 0: RECREATEPOST
    • 1: 1
    • 2: 0
    • 3: approved
    Backtrace
    • 15. app/Helpers/PostHelper.php:621
    • 16. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_posts` (PRIMARY)201
    Params
    • id: 1
    • select_type: PRIMARY
    • table: tch_posts
    • type: index
    • possible_keys: out_of_service_deleted_at,status_published_out_of_service_ordering_deleted_at
    • key: created_at
    • key_len: 5
    • ref: 
    • rows: 20
    • Extra: Using where
  • - EXPLAIN # 2: `tch_promote_post_histories` (MATERIALIZED)3435592
    Params
    • id: 2
    • select_type: MATERIALIZED
    • table: tch_promote_post_histories
    • type: ALL
    • possible_keys: post_id,type,deleted_at
    • key: 
    • key_len: 
    • ref: 
    • rows: 343559
    • Extra: Using where
  • select * from `tch_packages` where `tch_packages`.`id` in (31, 33, 34, 37)330μ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)370μ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)280μstch123_dev_2020PostHelper.php#621
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Helpers/PostHelper.php:621
    • 21. view::_desktop.main.page.page_part.page_part_lastest_posts:3
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)330μ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 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_global_option` where `name` = 'using_google_cached_image' limit 1370μ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 1310μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-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_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_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_global_option` where `name` = 'using_google_cached_image' limit 1290μstch123_dev_2020Setting.php#23
    Bindings
    • 0: using_google_cached_image
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. app/Models/Post.php:197
    • 17. view::_desktop.main.post.post-item-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_global_option` where `name` = 'using_google_cached_image' limit 1380μ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 5480μ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 1380μstch123_dev_2020PageHelper.php#23
    Bindings
    • 0: 5_1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 16. app/Helpers/PageHelper.php:23
    • 17. app/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)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.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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_estates` where `tch_estates`.`id` in (5)240μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:3
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `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.07mstch123_dev_2020Page.php#245
    Bindings
    • 0: 5
    • 1: 1
    • 2: 0
    • 3: 0
    • 4: 0
    • 5: 0
    • 6: 1
    • 7: 0
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 15. app/Models/Page.php:245
    • 16. view::_desktop.main.includes.main_menu:4
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)10991
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: range
    • possible_keys: estate_id_deleted_at,estate_id_province_id_deleted_at,estate_id_province_id_district_id_deleted_at,count_deleted_at,published_deleted_at,estate_id_project_id_deleted_at
    • key: estate_id_province_id_district_id_deleted_at
    • key_len: 15
    • ref: 
    • rows: 1099
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)250μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:4
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (1, 2, 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)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_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)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: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 1510μ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)230μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)220μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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 null270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:6
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_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` asc770μ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)260μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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)290μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:7
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_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 1380μ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)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: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id` in (0)270μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu:9
    • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null290μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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)250μstch123_dev_2020PageHelper.php#23
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 21. app/Helpers/PageHelper.php:23
    • 22. app/Helpers/Khelper.php:890
    • 23. view::_desktop.main.includes.main_menu: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` asc480μ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)270μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu: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)260μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)51
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: range
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: 
    • rows: 5
    • Extra: Using where
  • select * from `tch_estates` where `tch_estates`.`id` in (5)260μstch123_dev_2020Page.php#245
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 20. app/Models/Page.php:245
    • 21. view::_desktop.main.includes.main_menu:10
    • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
    • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:73
  • - EXPLAIN # 1: `tch_estates` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_estates
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_promotions` where `published` = 1 and date(`date_begin`) <= '2025-04-04' and date(`date_end`) >= '2025-04-04' order by `priority` desc limit 1320μstch123_dev_2020header_user_not_login.blade.php#3
    Bindings
    • 0: 1
    • 1: 2025-04-04
    • 2: 2025-04-04
    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 1340μstch123_dev_2020LocationHelper.php#266
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 17. app/Helpers/LocationHelper.php:266
    • 18. app/Helpers/LocationHelper.php:185
    • 19. app/Helpers/Khelper.php:2797
    • 20. view::_desktop.main.includes.filter_box:3
    • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_provinces` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_provinces
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_districts` where `tch_districts`.`id_province` in (2) order by `ordering` asc, `id_province` asc, `name` asc290μstch123_dev_2020LocationHelper.php#266
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/LocationHelper.php:266
    • 23. app/Helpers/LocationHelper.php:185
    • 24. app/Helpers/Khelper.php:2797
    • 25. view::_desktop.main.includes.filter_box:3
    • 27. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using where; Using filesort
  • select * from `tch_districts` where `tch_districts`.`id_province` = 2 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc380μstch123_dev_2020Province.php#28
    Bindings
    • 0: 2
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 16. app/Models/Province.php:28
    • 17. app/Helpers/LocationHelper.php:186
    • 18. app/Helpers/Khelper.php:2797
    • 19. view::_desktop.main.includes.filter_box:3
    • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
  • - EXPLAIN # 1: `tch_districts` (SIMPLE)301
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_districts
    • type: ref
    • possible_keys: id_province
    • key: id_province
    • key_len: 4
    • ref: const
    • rows: 30
    • Extra: Using index condition; Using where; Using filesort
  • select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1330μ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` = 24 limit 1230μstch123_dev_2020DelegatesToResource.php#139
    Bindings
    • 0: 24
    Hints
    • 0: Use SELECT * 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` = 317 limit 1240μstch123_dev_2020LocationHelper.php#284
    Bindings
    • 0: 317
    Hints
    • 0: Use SELECT * 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` = 3582 limit 1630μstch123_dev_2020LocationHelper.php#303
    Bindings
    • 0: 3582
    Hints
    • 0: Use SELECT * 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 1420μstch123_dev_2020Setting.php#23
    Bindings
    • 0: address
    Hints
    • 0: Use SELECT * only if you need all columns from table
    • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
    Backtrace
    • 14. app/Helpers/Setting.php:23
    • 15. app/Helpers/Khelper.php:363
    • 16. view::_desktop.main.includes.footer:50
    • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
    • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
  • - EXPLAIN # 1: `tch_global_option` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_global_option
    • type: const
    • possible_keys: name
    • key: name
    • key_len: 302
    • ref: const
    • rows: 1
    • Extra: 
App\Models\District
187District.php#?
App\Models\Page
99Page.php#?
App\Models\Province
84Province.php#?
App\Models\PostCanHoDetail
30PostCanHoDetail.php#?
App\Models\Project
24Project.php#?
App\Models\PostCanHoExpand
20PostCanHoExpand.php#?
App\Models\Estate
16Estate.php#?
App\Models\Ward
14Ward.php#?
App\Models\User
9User.php#?
App\Models\Package
5Package.php#?
App\Models\Article
5Article.php#?
App\Models\Street
1Street.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-04 09:29:16GET/cho-thue-can-ho-chung-cu-opal-riverside.html170494