2 400 ₴
радіарор форд транзит конект 1.8 дизель без кондиціонера.
2400.0
Нововоронцовка
Знайдено 192 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3520
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 15.73 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 ["novovoroncovka","\/novovoroncovka","novovoroncovka\/","\/novovoroncovka\/"] · 3.76 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 7.55 msSHOW TABLES · 0.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) [219642822,219497392,219327286,219325930,218973851,218672249,218496725,218227519,218194249,218194183,218193871,218193145,218068840,218068300,218067208,217934969,217934151,217934137,217931896,217685029,217554556,217471144,217068727,216948076,216686158,216683509,216677803,216631963,216631936,216629908,216610942,216610915,216566923,216477502,216311449,216309778,216194485,216039826,215836903,215825548,215742953,215559873,215491218,215452323,215217246,215164824,215129883,215123271,214964154,214624632] · 497.05 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 [214624632,214964154,215123271,215129883,215164824,215217246,215452323,215491218,215559873,215742953,215825548,215836903,216039826,216194485,216309778,216311449,216477502,216566923,216610915,216610942,216629908,216631936,216631963,216677803,216683509,216686158,216948076,217068727,217471144,217554556,217685029,217931896,217934137,217934151,217934969,218067208,218068300,218068840,218193145,218193871,218194183,218194249,218227519,218496725,218672249,218973851,219325930,219327286,219497392,219642822] · 23.42 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.04 ms