5 000 ₴
Тнвд Пнвт Opel Astra g Combo Паливний насос Опель Астра Комбо 1.7DTI
5000.0
Шумськ
Знайдено 2 245 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3491
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 1550,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 14.08 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 ["shumsk","\/shumsk","shumsk\/","\/shumsk\/"] · 0.69 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.23 msSHOW TABLES · 0.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) [186868683,186856884,186839700,186839469,186768453,186696108,186637032,186560667,186497649,186497124,186467580,186436266,186436245,186413664,186413634,186413619,186413550,186413400,186413367,186413340,186366996,186246560,186242740,186232284,186214284,186206916,186188080,186151508,186148650,186054891,186036294,185973927,185969916,185961705,185959317,185951073,185915370,185898855,185860752,185791020,185784285,185754027,185730897,185663559,185583318,185548047,185548029,185548014,185499687,185484534] · 56.5 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 [185484534,185499687,185548014,185548029,185548047,185583318,185663559,185730897,185754027,185784285,185791020,185860752,185898855,185915370,185951073,185959317,185961705,185969916,185973927,186036294,186054891,186148650,186151508,186188080,186206916,186214284,186232284,186242740,186246560,186366996,186413340,186413367,186413400,186413550,186413619,186413634,186413664,186436245,186436266,186467580,186497124,186497649,186560667,186637032,186696108,186768453,186839469,186839700,186856884,186868683] · 6.31 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.61 ms