700 ₴
Цепь и натяжитель масляного насоса Хонда CR-V 2012-14, 2.4 Америка
700.0
Нетішин
Знайдено 5 584 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3418
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 5300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.92 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 ["neteshin","\/neteshin","neteshin\/","\/neteshin\/"] · 0.47 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.38 msSHOW TABLES · 0.55 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) [171260680,171253258,171229798,171209560,171205546,171193585,171187921,171180868,171115657,171115483,171115453,171094513,171060670,171053878,171052120,171047197,171039379,171023899,171014539,171014209,170993698,170982340,170971777,170969521,170968477,170967928,170967739,170951800,170946544,170925961,170925844,170919187,170911336,170901361,170878792,170854840,170840413,170836222,170836183,170836180,170836126,170836099,170835601,170833831,170831032,170830969,170818471,170801695,170800603,170784391] · 24.24 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 [170784391,170800603,170801695,170818471,170830969,170831032,170833831,170835601,170836099,170836126,170836180,170836183,170836222,170840413,170854840,170878792,170901361,170911336,170919187,170925844,170925961,170946544,170951800,170967739,170967928,170968477,170969521,170971777,170982340,170993698,171014209,171014539,171023899,171039379,171047197,171052120,171053878,171060670,171094513,171115453,171115483,171115657,171180868,171187921,171193585,171205546,171209560,171229798,171253258,171260680] · 1.23 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.37 ms