640 ₴
Сервісна книга для Renault Megane
640.0
Умань
Знайдено 30 673 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2218
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5400,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 4.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.url IN (?, ?, ?, ?) LIMIT 1 ["uman","\/uman","uman\/","\/uman\/"] · 1.53 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.89 msSHOW TABLES · 0.43 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) [214135278,214135004,214134860,214134840,214134512,214134240,214133774,214133632,214132980,214132798,214132530,214131144,214130934,214130522,214128650,214128176,214127624,214127118,214125572,214124550,214124150,214123862,214122992,214122912,214121254,214121196,214121186,214120804,214120784,214120736,214118746,214115816,214114624,214114086,214113244,214113236,214113234,214113010,214112934,214112928,214112922,214112920,214109256,214108124,214107100,214102596,214101056,214101022,214099280,214099276] · 18.22 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 [214099276,214099280,214101022,214101056,214102596,214107100,214108124,214109256,214112920,214112922,214112928,214112934,214113010,214113234,214113236,214113244,214114086,214114624,214115816,214118746,214120736,214120784,214120804,214121186,214121196,214121254,214122912,214122992,214123862,214124150,214124550,214125572,214127118,214127624,214128176,214128650,214130522,214130934,214131144,214132530,214132798,214132980,214133632,214133774,214134240,214134512,214134840,214134860,214135004,214135278] · 13.07 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.13 ms