1 163 ₴
долгосрочная аренда Свидивок
1163.0
Свидівок
Знайдено 326 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6435
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.29 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 ["svidivok","\/svidivok","svidivok\/","\/svidivok\/"] · 1.07 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.46 msSHOW TABLES · 1.88 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) [212369583,212307858,212231427,212135175,212023011,211833204,211767978,211713381,211630518,211272543,211270752,211198143,211119561,210918188,210882336,210749786,210615864,210584873,210521723,210451160,210314531,210280151,210158882,210049850,210001211,209667560,209624748,209185258,208994164,208851541,208686538,208659352,208507120,208375477,207378349,207257974,207257788,207232369,207207199,207206323,207135703,207072197,207041841,207021601,206959609,206950751,206920753,206872029,205589924,205428698] · 22.6 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 [205428698,205589924,206872029,206920753,206950751,206959609,207021601,207041841,207072197,207135703,207206323,207207199,207232369,207257788,207257974,207378349,208375477,208507120,208659352,208686538,208851541,208994164,209185258,209624748,209667560,210001211,210049850,210158882,210280151,210314531,210451160,210521723,210584873,210615864,210749786,210882336,210918188,211119561,211198143,211270752,211272543,211630518,211713381,211767978,211833204,212023011,212135175,212231427,212307858,212369583] · 20.87 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.07 ms