800 ₴
Завіса капота Фіат Фіоріно
800.0
Макарів
Знайдено 3 021 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6134
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1700,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.28 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 ["makarov","\/makarov","makarov\/","\/makarov\/"] · 0.74 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.92 msSHOW TABLES · 18 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) [200640820,200617519,200602798,200580358,200562736,200552758,200539198,200495671,200466172,200452195,200429275,200415238,200406484,200398084,200397523,200380837,200372800,200357188,200263969,200228575,200225320,200205751,200172220,200166217,200159701,200129638,200128453,200126458,200113984,200080033,200068681,200065108,200057047,200045578,200026288,199978366,199959211,199945795,199941013,199933909,199885954,199885177,199846729,199836310,199776367,199772521,199754371,199728733,199726237,199725280] · 188.09 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 [199725280,199726237,199728733,199754371,199772521,199776367,199836310,199846729,199885177,199885954,199933909,199941013,199945795,199959211,199978366,200026288,200045578,200057047,200065108,200068681,200080033,200113984,200126458,200128453,200129638,200159701,200166217,200172220,200205751,200225320,200228575,200263969,200357188,200372800,200380837,200397523,200398084,200406484,200415238,200429275,200452195,200466172,200495671,200539198,200552758,200562736,200580358,200602798,200617519,200640820] · 1.19 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.8 ms