5 900 $
Volvo V50
270 000 км 259600.0
Свист
Знайдено 255 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7158
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.94 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 ["jvirka","\/jvirka","jvirka\/","\/jvirka\/"] · 1.01 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.3 msSHOW TABLES · 2.5 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) [208512718,208461589,207380443,207362305,207322642,207202687,206819153,205921034,205668035,205406483,205392575,205307882,205212290,205199381,204695372,204640742,204488147,204212106,203997555,203930232,203677652,203450633,203025424,203016598,202345021,202003353,201941381,201790979,201499539,201450106,201434407,200720008,200548561,200000683,199933741,199933693,199746991,199309228,199308643,199308556,199308109,199308106,199028665,198987484,198955033,198849076,198809449,198757576,198653077,198461373] · 35.1 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 [198461373,198653077,198757576,198809449,198849076,198955033,198987484,199028665,199308106,199308109,199308556,199308643,199309228,199746991,199933693,199933741,200000683,200548561,200720008,201434407,201450106,201499539,201790979,201941381,202003353,202345021,203016598,203025424,203450633,203677652,203930232,203997555,204212106,204488147,204640742,204695372,205199381,205212290,205307882,205392575,205406483,205668035,205921034,206819153,207202687,207322642,207362305,207380443,208461589,208512718] · 36.22 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.47 ms