8 000 ₴
Оригінальна магнітола Volkswagen Jetta 6 (штатна мультимедія)
8000.0
Мукачево
Найдено 29 937 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2153
}
}
]
}
},
"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 · 2.24 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["mukachevo","\/mukachevo","mukachevo\/","\/mukachevo\/"] · 1.65 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.54 msSHOW TABLES · 2.27 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, ''), NULLIF(c.name_ua, '')) 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) [219320485,219319930,219319621,219317074,219315115,219314407,219309658,219308866,219305887,219305602,219305452,219303772,219303148,219297184,219296740,219296515,219295192,219295084,219295039,219293539,219290071,219289714,219289306,219288613,219288469,219287209,219286999,219285307,219285304,219285067,219282952,219281734,219280978,219277009,219277006,219277003,219231319,219228799,219211754,219208805,219207714,219201641,219201029,219201011,219200756,219200501,219197699,219196376,219195557,219195386] · 3.49 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [219195386,219195557,219196376,219197699,219200501,219200756,219201011,219201029,219201641,219207714,219208805,219211754,219228799,219231319,219277003,219277006,219277009,219280978,219281734,219282952,219285067,219285304,219285307,219286999,219287209,219288469,219288613,219289306,219289714,219290071,219293539,219295039,219295084,219295192,219296515,219296740,219297184,219303148,219303772,219305452,219305602,219305887,219308866,219309658,219314407,219315115,219317074,219319621,219319930,219320485] · 6.32 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.92 ms