5 999 $
Yamaha T-MAX 19 т.км. Макси-скутер, обслужен в ноль !
263956.0
Ліски
Знайдено 3 610 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6182
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2900,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 30.56 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 ["leski","\/leski","leski\/","\/leski\/"] · 2.57 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.28 msSHOW TABLES · 1.05 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) [191486182,191476147,191472034,191467258,191456149,191455285,191449891,191447299,191441356,191424079,191386921,191386891,191385550,191380759,191368981,191364022,191353147,191342716,191315230,191280409,191260950,191232206,191209695,191207766,191204265,191181756,191181342,191086545,191084478,191044284,191013024,191005629,190978392,190931163,190923180,190909005,190882680,190877043,190862025,190855773,190846074,190837191,190803381,190698750,190676481,190670736,190659222,190647162,190629921,190559844] · 35.13 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 [190559844,190629921,190647162,190659222,190670736,190676481,190698750,190803381,190837191,190846074,190855773,190862025,190877043,190882680,190909005,190923180,190931163,190978392,191005629,191013024,191044284,191084478,191086545,191181342,191181756,191204265,191207766,191209695,191232206,191260950,191280409,191315230,191342716,191353147,191364022,191368981,191380759,191385550,191386891,191386921,191424079,191441356,191447299,191449891,191455285,191456149,191467258,191472034,191476147,191486182] · 1.52 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.88 ms