5 200 $
Земельна ділянка вул. Лубенська м. Миргород
228800.0
Миргород
Знайдено 103 оголошення
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
24
]
}
},
{
"term": {
"city_id": 2485
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.39 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["mirgorod","\/mirgorod","mirgorod\/","\/mirgorod\/"] · 0.54 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.36 msSHOW TABLES · 1.41 msSELECT p.id, p.category_id, p.city_id, p.region AS region_id, p.vendor AS vendor_id, p.name, p.description, p.name AS name_orig, p.price, p.currency, p.bargain, p.conditions, p.url, p.img, p.view AS views, p.data_post, p.data_edit, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS city_name, c.url AS city_slug FROM `post` p LEFT JOIN `city` c ON c.id = p.city_id WHERE p.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND (1=1) [219842566,219751278,218938529,218928176,218904200,218665949,218542169,218483600,218382038,218105053,217967699,217725178,217725151,217601797,217430476,217424158,217312240,217231693,217089721,216977581,216939943,216771247,216718558,216622576,216538732,216506944,216238894,216197155,216119515,216024166,215864698,215857570,215805735,215725946,215506338,215467578,215418435,215397724,214290294,214004552,213940586,213883680,213432009,213401298,213249933,213228210,212993196,212629941,212575344,212278467] · 73.98 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute_value` v JOIN `attribute` a ON a.id = v.attribute_id WHERE v.post_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND v.value IS NOT NULL AND v.value <> '' ORDER BY a.id [212278467,212575344,212629941,212993196,213228210,213249933,213401298,213432009,213883680,213940586,214004552,214290294,215397724,215418435,215467578,215506338,215725946,215805735,215857570,215864698,216024166,216119515,216197155,216238894,216506944,216538732,216622576,216718558,216771247,216939943,216977581,217089721,217231693,217312240,217424158,217430476,217601797,217725151,217725178,217967699,218105053,218382038,218483600,218542169,218665949,218904200,218928176,218938529,219751278,219842566] · 49.14 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name_ua, ''), NULLIF(c.name, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 1.74 msSELECT v.attribute_id, v.value, COUNT(*) AS cnt FROM (SELECT p.id FROM `post` p WHERE p.category_id IN (?) AND (1) ORDER BY p.id DESC LIMIT 3000) s JOIN `attribute_value` v ON v.post_id = s.id WHERE v.value IS NOT NULL AND v.value <> '' AND CHAR_LENGTH(v.value) <= 60 GROUP BY v.attribute_id, v.value [24] · 40.71 msSELECT a.id, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute` a WHERE a.id IN (?,?,?,?) [690,673,665,692] · 1.17 ms