| 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
|