Đăng tin

Xin chào Khách

Đăng nhập

Đăng ký

Đăng tin mới

Hỗ trợ đăng tin: 0902.657.123

Nguyễn Hoàng Duy Tân

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

6

KHAI TRƯƠNG STUDIO BANCOL FULL NỘI THẤT MỚI 100% NGAY CẦU NGUYỄN VĂN CỪ

8.5 triệu/tháng 25m² 1 pn 1 wc

Quận 8, Hồ Chí Minh

Dương Bá Trạc - Quận 8 - Chính sách: + Điện 4000kwh + Nước 150k/người + Phí Quản lý 200k/phòng ( wifi, bảo trì, rác, vệ sinh, thang máy … ) + Xe máy : 150k/xe + Nuôi thú cưng : Được phép ( cọc thêm 0.5 đối với HĐ 6 tháng ) + Thang máy +…

Đăng 4 tháng trước

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

https://thuecanho.lbkdev.com/0335371347

Lý do phản ánh:

Ảnh đại diện vi phạm

Thông tin cá nhân vi phạm

Người đăng tin có dấu hiệu lừa đảo

Lý do khác

Mô tả thêm

Thông tin liên hệ

Họ tên của bạn

Số điện thoại của bạn

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

Tất cả

Dự án nổi bật

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

Tất cả
Dưới 20m²
20m² - 30m²
30m² - 50m²
50m² - 70m²
70m² - 90m²
90m² - 120m²
120m² - 200m²
200m² - 500m²
Trên 500m²

Tất cả
1 phòng ngủ
2 phòng ngủ
3 phòng ngủ
4+ phòng ngủ

Tất cả
1 toilet
2 toilet
3 toilet
4+ toilet

Tất cả
Đông
Tây
Nam
Bắc
Đông Nam
Đông Bắc
Tây Nam
Tây Bắc

Queries90 Models79

Request history34MB

90 statements were executed, 57 of which were duplicates, 33 unique. Show only duplicated27.85ms

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` = '180221778' and `tch_posts`.`deleted_at` is null limit 11.71mstch123_dev_2020PostHelper.php#28

Bindings	0: 180221778
Hints	0: Use `SELECT *` 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 (15546) 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)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_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 (1166) 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: `tch_projects` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_provinces` where `tch_provinces`.`id` in (2)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 (28)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 (28)

350μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

310μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180221778)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_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` = '180221763' and `tch_posts`.`deleted_at` is null limit 1450μstch123_dev_2020PostHelper.php#28

Bindings	0: 180221763
Hints	0: Use `SELECT *` 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 (15546) and `tch_users`.`deleted_at` is null250μ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)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_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 (1166) and `tch_projects`.`deleted_at` is null310μ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 (2)210μ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 (28)190μ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 (28)

330μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

300μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180221763)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_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` = '180223193' and `tch_posts`.`deleted_at` is null limit 1450μstch123_dev_2020PostHelper.php#28

Bindings	0: 180223193
Hints	0: Use `SELECT *` 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 (7653) 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 (31)210μ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 (3014) and `tch_projects`.`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_projects` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_provinces` where `tch_provinces`.`id` in (2)190μ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 (28)210μ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 (28)

270μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

280μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180223193)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_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` = '180223375' and `tch_posts`.`deleted_at` is null limit 1740μstch123_dev_2020PostHelper.php#28

Bindings	0: 180223375
Hints	0: Use `SELECT *` 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 (18153) 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 (31)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_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 (2913) and `tch_projects`.`deleted_at` is null380μ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 (2)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 (28)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_districts` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_districts
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (28)

240μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

230μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180223375)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_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` = '180223169' and `tch_posts`.`deleted_at` is null limit 1690μstch123_dev_2020PostHelper.php#28

Bindings	0: 180223169
Hints	0: Use `SELECT *` 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 (18153) and `tch_users`.`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: `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)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_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 (2674) and `tch_projects`.`deleted_at` is null310μ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 (2)170μ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 (28)170μ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 (28)

220μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

230μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180223169)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_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` = '180223372' and `tch_posts`.`deleted_at` is null limit 1400μstch123_dev_2020PostHelper.php#28

Bindings	0: 180223372
Hints	0: Use `SELECT *` 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 (18797) and `tch_users`.`deleted_at` is null320μ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)200μ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 (1166) and `tch_projects`.`deleted_at` is null240μ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 (2)190μ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 (28)190μ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 (28)

250μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

250μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180223372)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_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` = '180221665' and `tch_posts`.`deleted_at` is null limit 1560μstch123_dev_2020PostHelper.php#28

Bindings	0: 180221665
Hints	0: Use `SELECT *` 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 (13311) and `tch_users`.`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: `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)210μ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 (1117) 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: `tch_projects` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_provinces` where `tch_provinces`.`id` in (2)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 (28)190μ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 (28)

270μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

270μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180221665)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_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` = '180221303' and `tch_posts`.`deleted_at` is null limit 1460μstch123_dev_2020PostHelper.php#28

Bindings	0: 180221303
Hints	0: Use `SELECT *` 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 (15262) 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)200μ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 (2857) and `tch_projects`.`deleted_at` is null320μ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 (2)180μ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 (28)170μ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 (28)

240μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

230μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180221303)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_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` = '180221077' and `tch_posts`.`deleted_at` is null limit 1420μstch123_dev_2020PostHelper.php#28

Bindings	0: 180221077
Hints	0: Use `SELECT *` 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 (15047) and `tch_users`.`deleted_at` is null380μ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)200μ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 null200μ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 (2)180μ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 (28)170μ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 (28)

230μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

250μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180221077)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_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` = '180219292' and `tch_posts`.`deleted_at` is null limit 1440μstch123_dev_2020PostHelper.php#28

Bindings	0: 180219292
Hints	0: Use `SELECT *` 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 (13792) 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)200μ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 (2489) and `tch_projects`.`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_projects` (SIMPLE)11
Params
id: 1
select_type: SIMPLE
table: tch_projects
type: const
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: const
rows: 1
Extra:

select * from `tch_provinces` where `tch_provinces`.`id` in (2)200μstch123_dev_2020PostHelper.php#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 (28)180μ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 (28)

240μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 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_pages` (SIMPLE)128691
Params
id: 1
select_type: SIMPLE
table: tch_pages
type: ALL
possible_keys:
key:
key_len:
ref:
rows: 12869
Extra: Using where

select * from `tch_pages` where `district_id` = 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`province_id` in (2)

240μstch123_dev_2020PostHelper.php#28

Bindings	0: 0 1: 0 2: 0 3: 0 4: 2
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 (180219292)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_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: 20Page.php#?
App\Models\User: 10User.php#?
App\Models\Package: 10Package.php#?
App\Models\Province: 10Province.php#?
App\Models\District: 10District.php#?
App\Models\PostCanHoDetail: 10PostCanHoDetail.php#?
App\Models\Project: 9Project.php#?

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-20 11:49:32	GET	/0335371347	53 219
#2	2025-04-20 11:49:29	POST	/api/refresh/header (ajax)	1
#3	2025-04-20 11:49:29	POST	/api/post/view/count (ajax)	90 79

KHAI TRƯƠNG STUDIO BANCOL FULL NỘI THẤT MỚI 100% NGAY CẦU NGUYỄN VĂN CỪ