Kênh thông tin cho thuê căn hộ số 1 Việt Nam
Đăng tin
Hóc Môn, Hồ Chí Minh
Dự án
30 - 100 triệu
Diện tích
Số phòng ngủ
Số toilet
Hướng chính
Đặt lại

Cho thuê căn hộ chung cư HQC Hóc Môn Giá trên 30 triệu đồng T4/2025

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

Đề xuất Mới đăng Có video

Hiện tại chưa có tin đăng trong khu vực này

Hãy thay đổi hoặc đặt lại tiêu chí tìm kiếm.

Có thể bạn quan tâm
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è
Hóc Môn
  • Tất cả
  • Phường Hóc Môn
  • Xã Tân Xuân
  • Phường Bà Điểm
  • Xã Nhị Bình
  • Xã Tân Hiệp
  • Xã Trung Chánh
  • Xã Đông Thạnh
  • Xã Tân Thới Nhì
  • Xã Thới Tam Thôn
  • Xã Xuân Thới Sơn
  • Xã Xuân Thới Đông
  • Xã Xuân Thới Thượng
Chọn khoảng giá
  • Tất cả
  • Dưới 5 triệu
  • 5 - 7 triệu
  • 7 - 10 triệu
  • 10 - 15 triệu
  • 15 - 20 triệu
  • 20 - 30 triệu
  • 30 - 50 triệu
  • 50 - 100 triệu
  • Trên 100 triệu
Hủy
Áp dụng
Chọn diện tích
  • Tất cả
  • Dưới 20m2
  • 20m2 - 30m2
  • 30m2 - 50m2
  • 50m2 - 70m2
  • 70m2 - 90m2
  • 90m2 - 120m2
  • 120m2 - 200m2
  • 200m2 - 500m2
  • Trên 500m2
Hủy
Áp dụng
Số phòng ngủ
  • Tất cả
  • 1 phòng ngủ
  • 2 phòng ngủ
  • 3 phòng ngủ
  • 4+ phòng ngủ
Hủy
Áp dụng
Số toilet
  • Tất cả
  • 1 toilet
  • 2 toilet
  • 3 toilet
  • 4+ toilet
Hủy
Áp dụng
Hướng chính
  • Tất cả
  • Đông
  • Tây
  • Nam
  • Bắc
  • Đông Nam
  • Đông Bắc
  • Tây Nam
  • Tây Bắc
Hủy
Áp dụng
Hỗ trợ chủ nhà
Ms.Huỳnh Hương
0903.007.123
Hỗ trợ ngoài giờ
Thuecanho123
Bảng giá dịch vụ Hướng dẫn đăng tin Yêu cầu hỗ trợ
Queries180Models141
Request history34MBMemory Usage
180 statements were executed, 127 of which were duplicates, 53 unique. Show only duplicated84.63ms
  • Connection Establishedtch123_dev_2020PostHelper.php#28
    Backtrace
    • 15. app/Helpers/PostHelper.php:28
    • 16. app/Helpers/Khelper.php:1112
    • 17. app/Http/Controllers/Api/V1/PostController.php:1657
    • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • select * from `tch_posts` where `tch_posts`.`id` = '180221455' and `tch_posts`.`deleted_at` is null limit 12.38mstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221455
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (12875) and `tch_users`.`deleted_at` is null1.16mstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)480μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null430μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)400μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)360μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)470μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)680μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221455)620μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180222719' and `tch_posts`.`deleted_at` is null limit 1750μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180222719
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (16264) and `tch_users`.`deleted_at` is null750μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)400μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null420μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)350μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)420μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)410μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180222719)620μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221360' and `tch_posts`.`deleted_at` is null limit 1850μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221360
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14087) and `tch_users`.`deleted_at` is null420μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)340μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null390μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)310μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)300μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)380μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)390μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221360)620μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221842' and `tch_posts`.`deleted_at` is null limit 1810μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221842
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (10574) and `tch_users`.`deleted_at` is null450μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null350μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)320μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)480μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)490μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)410μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221842)730μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221162' and `tch_posts`.`deleted_at` is null limit 11.02mstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221162
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14087) and `tch_users`.`deleted_at` is null400μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)350μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null490μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)300μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)310μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)400μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)380μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221162)650μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180220708' and `tch_posts`.`deleted_at` is null limit 1840μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180220708
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14705) and `tch_users`.`deleted_at` is null700μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)350μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null370μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)420μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)400μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)400μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180220708)690μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180220948' and `tch_posts`.`deleted_at` is null limit 1970μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180220948
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14941) and `tch_users`.`deleted_at` is null700μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)360μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null350μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)360μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)360μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)370μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180220948)580μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221484' and `tch_posts`.`deleted_at` is null limit 1970μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221484
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (12875) and `tch_users`.`deleted_at` is null390μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)370μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null390μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)310μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)420μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)450μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221484)750μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221403' and `tch_posts`.`deleted_at` is null limit 11.1mstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221403
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (13202) and `tch_users`.`deleted_at` is null370μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)280μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)730μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)580μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221403)860μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180208444' and `tch_posts`.`deleted_at` is null limit 11.05mstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180208444
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (1963) and `tch_users`.`deleted_at` is null930μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)450μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null500μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)370μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)410μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)490μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)510μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180208444)690μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180223092' and `tch_posts`.`deleted_at` is null limit 11.19mstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180223092
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (18161) and `tch_users`.`deleted_at` is null930μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)460μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null540μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)340μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)550μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)540μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223092)540μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180219018' and `tch_posts`.`deleted_at` is null limit 1930μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180219018
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (13969) and `tch_users`.`deleted_at` is null730μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null450μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)280μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)360μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)360μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180219018)430μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221374' and `tch_posts`.`deleted_at` is null limit 1910μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221374
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (11306) and `tch_users`.`deleted_at` is null650μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)310μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null300μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)250μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)350μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)350μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221374)410μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180222100' and `tch_posts`.`deleted_at` is null limit 1680μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180222100
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (15634) and `tch_users`.`deleted_at` is null560μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)250μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)240μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180222100)390μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221126' and `tch_posts`.`deleted_at` is null limit 1870μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221126
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14941) and `tch_users`.`deleted_at` is null300μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)270μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)240μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)240μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221126)440μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221524' and `tch_posts`.`deleted_at` is null limit 1800μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221524
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (13354) and `tch_users`.`deleted_at` is null580μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)330μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)230μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)230μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)320μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221524)860μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221338' and `tch_posts`.`deleted_at` is null limit 1890μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221338
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (13202) and `tch_users`.`deleted_at` is null300μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)240μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)250μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)300μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)290μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221338)460μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180222796' and `tch_posts`.`deleted_at` is null limit 1800μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180222796
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (16935) and `tch_users`.`deleted_at` is null490μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)260μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (2848) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_projects` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_projects
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)220μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)250μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)320μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)310μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180222796)410μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180221421' and `tch_posts`.`deleted_at` is null limit 1600μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180221421
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (14439) and `tch_users`.`deleted_at` is null450μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)340μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null280μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)270μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)320μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)290μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)320μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180221421)430μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_posts` where `tch_posts`.`id` = '180223006' and `tch_posts`.`deleted_at` is null limit 1590μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 180223006
    Hints
    • 0: Use SELECT * 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/PostHelper.php:28
    • 18. app/Helpers/Khelper.php:1112
    • 19. app/Http/Controllers/Api/V1/PostController.php:1657
    • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_posts` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_posts
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_users` where `tch_users`.`id` in (17785) and `tch_users`.`deleted_at` is null560μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_users` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_users
    • type: const
    • possible_keys: PRIMARY,deleted_at
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_packages` where `tch_packages`.`id` in (37)290μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_packages` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_packages
    • type: const
    • possible_keys: PRIMARY
    • key: PRIMARY
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
  • select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null270μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `` (SIMPLE)1
    Params
    • id: 1
    • select_type: SIMPLE
    • table: 
    • type: 
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 
    • Extra: Impossible WHERE noticed after reading const tables
  • select * from `tch_provinces` where `tch_provinces`.`id` in (1)230μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)230μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - 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 (20)290μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 20
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (1)290μstch123_dev_2020PostHelper.php#28
    Bindings
    • 0: 0
    • 1: 0
    • 2: 0
    • 3: 0
    • 4: 1
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_pages` (SIMPLE)128691
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_pages
    • type: ALL
    • possible_keys: 
    • key: 
    • key_len: 
    • ref: 
    • rows: 12869
    • Extra: Using where
  • select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223006)610μstch123_dev_2020PostHelper.php#28
    Hints
    • 0: Use SELECT * only if you need all columns from table
    Backtrace
    • 22. app/Helpers/PostHelper.php:28
    • 23. app/Helpers/Khelper.php:1112
    • 24. app/Http/Controllers/Api/V1/PostController.php:1657
    • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:46
    • 26. vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
  • - EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11
    Params
    • id: 1
    • select_type: SIMPLE
    • table: tch_post_apartment_details
    • type: ref
    • possible_keys: post_id
    • key: post_id
    • key_len: 4
    • ref: const
    • rows: 1
    • Extra: 
App\Models\Page
40Page.php#?
App\Models\User
20User.php#?
App\Models\Package
20Package.php#?
App\Models\Province
20Province.php#?
App\Models\District
20District.php#?
App\Models\PostCanHoDetail
20PostCanHoDetail.php#?
App\Models\Project
1Project.php#?
ClearShow all
Date ↕MethodURLData
#12025-04-13 14:11:19GET/cho-thue-can-ho-chung-cu-hqc-hoc-mon.html?gia_tu=30000000&orderby=video165430
#22025-04-13 14:11:12POST/api/refresh/header (ajax)1
#32025-04-13 14:11:13POST/api/post/view/count (ajax)180141