2 000 ₴
Сидіння дачия орган 1
2000.0
Володарка
Знайдено 953 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3086
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 750,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.96 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 ["volodarka","\/volodarka","volodarka\/","\/volodarka\/"] · 0.83 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.88 msSHOW TABLES · 1.33 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) [183653706,183639405,183545112,183431925,183406161,183375765,183321981,183243891,183194751,183194211,183178836,183148428,183148359,183063756,182976465,182644219,182585506,182020567,181953646,181933003,181932928,181932916,181932913,181932907,181849951,181833502,181778113,181768753,181729024,181640206,181399765,181399708,181399582,181367911,181322467,181226326,181226167,181132069,180973678,180865987,180778681,180745390,180733102,180646684,180581110,180520735,180516682,180493342,180491476,180463920] · 31.59 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 [180463920,180491476,180493342,180516682,180520735,180581110,180646684,180733102,180745390,180778681,180865987,180973678,181132069,181226167,181226326,181322467,181367911,181399582,181399708,181399765,181640206,181729024,181768753,181778113,181833502,181849951,181932907,181932913,181932916,181932928,181933003,181953646,182020567,182585506,182644219,182976465,183063756,183148359,183148428,183178836,183194211,183194751,183243891,183321981,183375765,183406161,183431925,183545112,183639405,183653706] · 1.34 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.42 ms