0.0003 |
SELECT GET_LOCK('cf76814a67a1fe2fcbadd9ed312fbad9', 300) AS ci_session_lock
|
0.0008 |
SELECT `data` FROM `ci_session` WHERE `id` = 'qfe7nh4im80c0keobumg5e6nrl2hunah'
|
0.3707 |
SELECT `T1`.`id`, `T1`.`create_at`, `T1`.`sell_price`, `T1`.`rent_price`, `T1`.`areasize_sqm`, `T1`.`landarea_total_sqw`, `T1`.`post_type`, `T1`.`house_type` FROM `terra_freepost` `T1` LEFT JOIN `terra_freepost_detail` `T2` ON `T1`.`id` = `T2`.`freepost_id` LEFT JOIN `area` `T3` ON `T1`.`area_id` = `T3`.`id` WHERE `house_type` = 7 AND `area_id` = 2 AND `amphur_id` = 39 AND `district_id` = 211 AND `T1`.`areasize_sqm` >= 40 AND `T1`.`areasize_sqm` <= 150 AND `T2`.`province_id` IN(1, 2, 3, 4) AND `T1`.`status` IN(1, 3, 4)
|
1.2044 |
SELECT `T1`.`id`, `T1`.`create_at`, `T1`.`sell_price`, `T1`.`rent_price`, `T1`.`areasize_sqm`, `T1`.`landarea_total_sqw`, `T1`.`post_type`, `T1`.`house_type` FROM `terra_freepost` `T1` LEFT JOIN `terra_freepost_detail` `T2` ON `T1`.`id` = `T2`.`freepost_id` LEFT JOIN `area` `T3` ON `T1`.`area_id` = `T3`.`id` WHERE `house_type` = 7 AND `area_id` = 2 AND `T1`.`areasize_sqm` >= 40 AND `T1`.`areasize_sqm` <= 150 AND `T2`.`province_id` IN(1, 2, 3, 4) AND `T1`.`status` IN(1, 3, 4)
|
0.0074 |
SELECT * FROM `calulate_price_yearly` WHERE `amphur_id` = 39 AND `type_id` = 7 ORDER BY `year` ASC
|
0.9547 |
SELECT `T1`.`id`, `T1`.`create_at`, `T1`.`sell_price`, `T1`.`rent_price`, `T1`.`areasize_sqm`, `T1`.`landarea_total_sqw`, `T1`.`post_type`, `T1`.`house_type` FROM `terra_freepost` `T1` LEFT JOIN `terra_freepost_detail` `T2` ON `T1`.`id` = `T2`.`freepost_id` LEFT JOIN `area` `T3` ON `T1`.`area_id` = `T3`.`id` WHERE `house_type` = 7 AND `amphur_id` = 39 AND `T1`.`areasize_sqm` >= 40 AND `T1`.`areasize_sqm` <= 150 AND `T1`.`create_at` >= '2018-01-01 00:00:00' AND `T2`.`province_id` IN(1, 2, 3, 4) AND `T1`.`status` IN(1, 3, 4)
|
0.0004 |
SELECT `province_id`, `id`, `code`, th as 'name' FROM `address_amphur` WHERE `id` = 39 ORDER BY `th` ASC
|
0.0009 |
SELECT * FROM `terra_freepost_terms` WHERE `category` = 'house_type' ORDER BY `id` ASC
|
0.0009 |
SELECT * FROM `terra_freepost_terms` WHERE `category` = 'room_type' ORDER BY `id` ASC
|
0.0006 |
SELECT * FROM `zone` WHERE `id` != 5 ORDER BY `id` ASC
|
0.0013 |
SELECT * FROM `area` ORDER BY `id` ASC
|
0.0005 |
SELECT * FROM `address_amphur` WHERE `area_id` = 2 ORDER BY `id` ASC
|
0.0007 |
SELECT * FROM `address_district` WHERE `amphur_id` = 39 ORDER BY `id` ASC
|
0.0004 |
SELECT * FROM `address_district` WHERE `id` = 211 ORDER BY `id` ASC
|