315 000 ₴
продажа Романов
315000.0
Романов
Знайдено 208 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3568
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.27 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 ["romanov","\/romanov","romanov\/","\/romanov\/"] · 0.55 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.29 msSHOW TABLES · 0.98 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) [211109601,210847354,210834214,210834212,210834140,210830874,210821224,210808656,210763748,210753158,210703940,210703918,210703906,210703886,210703868,210703854,210703834,210703828,210641790,210495725,209215045,209001814,209001811,208806799,208585912,208546246,208354720,208277983,208258000,208257997,208257994,208257991,208257988,208152325,208129417,208129414,208016443,207702988,207407620,207142645,207142627,207142609,207142591,207142573,207141739,207141736,207136123,207105475,207104833,207104821] · 18.37 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 [207104821,207104833,207105475,207136123,207141736,207141739,207142573,207142591,207142609,207142627,207142645,207407620,207702988,208016443,208129414,208129417,208152325,208257988,208257991,208257994,208257997,208258000,208277983,208354720,208546246,208585912,208806799,209001811,209001814,209215045,210495725,210641790,210703828,210703834,210703854,210703868,210703886,210703906,210703918,210703940,210753158,210763748,210808656,210821224,210830874,210834140,210834212,210834214,210847354,211109601] · 10.4 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] · 0.79 ms