Hiện có 1 căn hộ cho thuê
Diện tích 90m thiết kết 2 ngủ 2 vệ sinh Nhà bàn giao nội thất cơ bản điều hòa nóng lạnh... Nhà mới tinh Nhận nhà ở ngay Giá 10tr/tháng LH xem free: 0984.745.099
![](https://track.static123.com/session?data={"source":"thuecanho.lbkdev.com","url":"https://thuecanho.lbkdev.com/cho-thue-can-ho-chung-cu-phu-thinh-green-park.html?gia_den=15000000&gia_tu=10000000&pn=2","refer_url":null,"estate":5,"province":2,"district":34,"session":"8qKH3sVJHTgGjfYHWLdgMkJvFbtazdgD5q8ZbpnB","screen_width":1280,"screen_height":720})
| Backtrace |
|
select * from `tch_redirects` where `status` = 1 and `url` = '/cho-thue-can-ho-chung-cu-phu-thinh-green-park.html' limit 13.02mstch123_dev_2020Khelper.php#2679| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_redirects` (SIMPLE)18161| Params |
|
select * from `tch_pages` where `tch_pages`.`id` = 1 limit 1390μstch123_dev_2020PageHelper.php#58| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_pages` where `slug` = 'cho-thue-can-ho-chung-cu-phu-thinh-green-park' limit 1710μstch123_dev_2020PageHelper.php#100| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)380μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)330μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (2709) and `tch_projects`.`deleted_at` is null580μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)11| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)340μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `slug` = 'cho-thue-can-ho-chung-cu-phu-thinh-green-park' limit 1380μstch123_dev_2020PageHelper.php#100| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)240μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)230μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (2709) and `tch_projects`.`deleted_at` is null330μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)11| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)270μstch123_dev_2020PageHelper.php#100| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select `id`, `name`, `code`, `total_posts` from `tch_provinces` order by `ordering` asc, `slug` asc340μstch123_dev_2020LocationHelper.php#24| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)631| Params |
|
select * from `tch_global_option` where `name` = 'post_paging' limit 1300μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select count(*) as aggregate from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `so_phong_ngu` = '2' and `tch_post_apartment_details`.`original_price` >= '10000000' and `tch_post_apartment_details`.`original_price` <= '15000000' and `project_id` = 2709 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null1.02mstch123_dev_2020PageService.php#365| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_posts` (SIMPLE)41| Params |
|
- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11| Params |
|
select `tch_posts`.* from `tch_posts` left join `tch_post_apartment_details` on `tch_posts`.`id` = `tch_post_apartment_details`.`post_id` where `so_phong_ngu` = '2' and `tch_post_apartment_details`.`original_price` >= '10000000' and `tch_post_apartment_details`.`original_price` <= '15000000' and `project_id` = 2709 and `tch_posts`.`status` = 'approved' and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`deleted_at` is null order by `tch_posts`.`ordering` desc, `tch_posts`.`published_at` desc limit 20 offset 01.31mstch123_dev_2020PageService.php#365| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_posts` (SIMPLE)41| Params |
|
- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11| Params |
|
select * from `tch_packages` where `tch_packages`.`id` in (31)480μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_packages` (SIMPLE)11| Params |
|
select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180182587)530μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)11| Params |
|
select * from `tch_post_apartment_expands` where `tch_post_apartment_expands`.`post_id` in (180182587)820μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_post_apartment_expands` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (2709) and `tch_projects`.`deleted_at` is null430μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)11| Params |
|
select * from `tch_pages` where `district_id` > 0 and `project_id` > 0 and `tch_pages`.`project_id` in (2709)37.15mstch123_dev_2020PageService.php#365| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)128691| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)400μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
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)650μstch123_dev_2020PageService.php#365| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)128691| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)380μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_pages` where `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `tch_pages`.`district_id` in (34)480μstch123_dev_2020PageService.php#365| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)128691| Params |
|
select * from `tch_pages` where `street_id` = 0 and `project_id` = 0 and `ward_id` > 0 and `tch_pages`.`ward_id` in (512)30.08mstch123_dev_2020PageService.php#365| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)128691| Params |
|
select * from `tch_users` where `tch_users`.`id` in (6469) and `tch_users`.`deleted_at` is null790μstch123_dev_2020PageService.php#365| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_users` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` = 2 limit 1510μstch123_dev_2020LocationHelper.php#266| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id_province` in (2) order by `ordering` asc, `id_province` asc, `name` asc520μstch123_dev_2020LocationHelper.php#266| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)301| Params |
|
select * from `tch_districts` where `tch_districts`.`id_province` = 2 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc610μstch123_dev_2020Province.php#28| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)301| Params |
|
select * from `tch_districts` where `tch_districts`.`id` = 34 limit 1490μstch123_dev_2020LocationHelper.php#322| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select `id`, CONCAT(pre," ",name) as text, CONCAT(pre," ",name) as name from `tch_wards` where `tch_wards`.`id_district` = 34 and `tch_wards`.`id_district` is not null order by LENGTH(name) ASC, CAST(name AS UNSIGNED) , `name` asc940μstch123_dev_2020District.php#34| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_wards` (SIMPLE)181| Params |
|
select * from `tch_pages` where `indexed` = 5 limit 1480μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (0)340μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)400μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null400μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)410μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `indexed` = '5_2' limit 1530μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)350μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)290μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null430μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)290μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `indexed` = '5_2_34' limit 1580μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)310μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)250μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null240μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)210μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1280μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_pages` where `indexed` = '5_2_34_project_2709' limit 1490μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)210μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)230μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (2709) and `tch_projects`.`deleted_at` is null240μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)11| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)230μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1230μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_pages` where `indexed` = '5_2' limit 1330μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)190μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)200μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null240μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)220μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `estate_id` = 5 and `province_id` = 2 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc630μstch123_dev_2020Page.php#245| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11791| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)190μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (25, 27, 28, 31, 32, 33, 34, 35, 36, 37, 38, 39, 42, 48, 51, 52)250μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)161| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)260μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1270μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1170μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1170μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1350μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1170μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1170μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1170μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1180μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 0 limit 1190μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`parent_id` = 2709 and `tch_projects`.`parent_id` is not null and `tch_projects`.`deleted_at` is null3.37mstch123_dev_2020page_part_project_childs.blade.php#15| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)15401| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1230μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_estates` where `tch_estates`.`id` = 5 limit 1260μstch123_dev_2020Page.php#346| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_projects` where `tch_projects`.`id` = 2709 and `tch_projects`.`deleted_at` is null limit 1350μstch123_dev_2020Page.php#363| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)11| Params |
|
select * from `tch_estates` where `tch_estates`.`id` = 5 limit 1250μstch123_dev_2020Page.php#346| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 512 limit 1210μstch123_dev_2020Page.php#366| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_wards` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 512 limit 1200μstch123_dev_2020post-item.blade.php#91| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_wards` (SIMPLE)11| Params |
|
select project_id, COUNT(*) as total from `tch_posts` where `district_id` = 34 and `created_at` > '2025-02-27 00:00:00' and `project_id` > 0 and `tch_posts`.`deleted_at` is null group by `project_id` having COUNT(*) > 0 order by COUNT(*) DESC limit 20270μstch123_dev_2020ProjectHelper.php#255| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_posts` (SIMPLE)11| Params |
|
select * from `tch_pages` where `project_id` > '0' and `province_id` = 2 and `count` > 0 and `district_id` = 34 order by `count` desc, `created_at` desc limit 15400μstch123_dev_2020PageHelper.php#208| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)18271| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)260μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)190μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` in (0)170μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (1263, 1272, 1274, 1276, 1292, 1309, 1311, 1316, 2698, 2709, 2790, 2836, 2969, 2979, 3019) and `tch_projects`.`deleted_at` is null390μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)151| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)250μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `project_id` > '0' and `district_id` = 34 and 1 = 1 order by `created_at` desc limit 5310μstch123_dev_2020PageHelper.php#208| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)128691| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)190μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (34)180μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` in (0)170μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (3019, 3030, 3057, 3164, 3171) and `tch_projects`.`deleted_at` is null250μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_projects` (SIMPLE)51| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)280μstch123_dev_2020PageHelper.php#208| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select `tch_posts`.* from `tch_posts` where not exists (select * from `tch_promote_post_histories` where `tch_posts`.`id` = `tch_promote_post_histories`.`post_id` and `type` = 'RECREATEPOST' and `tch_promote_post_histories`.`deleted_at` is null) and `tch_posts`.`published` = 1 and `tch_posts`.`out_of_service` = 0 and `tch_posts`.`status` = 'approved' and `tch_posts`.`deleted_at` is null order by `tch_posts`.`created_at` desc limit 10430μstch123_dev_2020PostHelper.php#621| Bindings |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_posts` (PRIMARY)201| Params |
|
- EXPLAIN # 2: `tch_promote_post_histories` (MATERIALIZED)3435602| Params |
|
select * from `tch_packages` where `tch_packages`.`id` in (31, 33, 34, 37)240μstch123_dev_2020PostHelper.php#621| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_packages` (SIMPLE)71| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (1, 2)260μstch123_dev_2020PostHelper.php#621| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)21| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (9, 11, 14, 21, 27)220μstch123_dev_2020PostHelper.php#621| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)51| Params |
|
select * from `tch_post_apartment_details` where `tch_post_apartment_details`.`post_id` in (180223418, 180223419, 180223420, 180223421, 180223423, 180223424, 180223425, 180223429, 180223432, 180223433)250μstch123_dev_2020PostHelper.php#621| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_post_apartment_details` (SIMPLE)101| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1350μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1360μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1330μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1370μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1350μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1360μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1370μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1360μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1340μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'using_google_cached_image' limit 1370μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|
select * from `tch_articles` where `published` = 1 and `tch_articles`.`deleted_at` is null order by `created_at` desc limit 5570μstch123_dev_2020ArticleHelper.php#173| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_articles` (SIMPLE)6641| Params |
|
select * from `tch_pages` where `indexed` = '5_1' limit 1430μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (1)330μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)260μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null320μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)270μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `estate_id` = 5 and `province_id` = 1 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc1.21mstch123_dev_2020Page.php#245| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)10991| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (1)630μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (1, 2, 3, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24)380μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)221| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)340μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `indexed` = '5_2' limit 1470μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)260μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)250μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null330μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)270μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `estate_id` = 5 and `province_id` = 2 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc690μstch123_dev_2020Page.php#245| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11791| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (2)270μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (25, 27, 28, 31, 32, 33, 34, 35, 36, 37, 38, 39, 42, 48, 51, 52)320μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)161| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)330μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `indexed` = '5_3' limit 1440μstch123_dev_2020PageHelper.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)11| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (3)280μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (0)240μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_projects` where `tch_projects`.`id` in (0) and `tch_projects`.`deleted_at` is null310μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `` (SIMPLE)1| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)270μstch123_dev_2020PageHelper.php#23| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_pages` where `estate_id` = 5 and `province_id` = 3 and `district_id` > 0 and `ward_id` = 0 and `street_id` = 0 and `project_id` = 0 and `published` = 1 and `count` > 0 order by `ordering` desc, `title` asc490μstch123_dev_2020Page.php#245| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_pages` (SIMPLE)2221| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` in (3)320μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` in (56, 58, 60, 61, 62)320μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)51| Params |
|
select * from `tch_estates` where `tch_estates`.`id` in (5)290μstch123_dev_2020Page.php#245| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_estates` (SIMPLE)11| Params |
|
select * from `tch_promotions` where `published` = 1 and date(`date_begin`) <= '2025-04-28' and date(`date_end`) >= '2025-04-28' order by `priority` desc limit 1390μstch123_dev_2020header_user_not_login.blade.php#3| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_promotions` (SIMPLE)121| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` = 1 limit 1310μstch123_dev_2020LocationHelper.php#266| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id_province` in (1) order by `ordering` asc, `id_province` asc, `name` asc370μstch123_dev_2020LocationHelper.php#266| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)241| Params |
|
select * from `tch_districts` where `tch_districts`.`id_province` = 1 and `tch_districts`.`id_province` is not null order by `ordering` asc, `id_province` asc, `name` asc410μstch123_dev_2020Province.php#28| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)241| Params |
|
select * from `tch_provinces` where `tch_provinces`.`id` = 2 limit 1400μstch123_dev_2020DelegatesToResource.php#139| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_provinces` (SIMPLE)11| Params |
|
select * from `tch_districts` where `tch_districts`.`id` = 34 limit 1270μstch123_dev_2020DelegatesToResource.php#139| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_districts` (SIMPLE)11| Params |
|
select * from `tch_wards` where `tch_wards`.`id` = 512 limit 1250μstch123_dev_2020LocationHelper.php#284| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_wards` (SIMPLE)11| Params |
|
select * from `tch_streets` where `tch_streets`.`id` = 4380 limit 1350μstch123_dev_2020LocationHelper.php#303| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_streets` (SIMPLE)11| Params |
|
select * from `tch_global_option` where `name` = 'address' limit 1340μstch123_dev_2020Setting.php#23| Bindings |
|
| Hints |
|
| Backtrace |
|
- EXPLAIN # 1: `tch_global_option` (SIMPLE)11| Params |
|