4 000 ₴
Капот Volkswagen Passat B5+ Пасат Б5 рестайл
4000.0
Самбор
Найдено 19 656 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3194
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 6500,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.56 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 ["sambor","\/sambor","sambor\/","\/sambor\/"] · 4.25 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 15.38 msSHOW TABLES · 1.18 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) [208085935,208084960,208082992,208081807,208081795,208080298,208080058,208077181,208073776,208069954,208065586,208063741,208058335,208057114,208056427,208054381,208048837,208041784,208040818,208038952,208037236,208034560,208031170,208030108,208029151,208027708,208027279,208027153,208024714,208024435,208022812,208022806,208012573,208011745,208008451,208003342,208003006,208002949,208002703,207999337,207998881,207996229,207995791,207995179,207995098,207994636,207994618,207991039,207989428,207988798] · 121.76 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 [207988798,207989428,207991039,207994618,207994636,207995098,207995179,207995791,207996229,207998881,207999337,208002703,208002949,208003006,208003342,208008451,208011745,208012573,208022806,208022812,208024435,208024714,208027153,208027279,208027708,208029151,208030108,208031170,208034560,208037236,208038952,208040818,208041784,208048837,208054381,208056427,208057114,208058335,208063741,208065586,208069954,208073776,208077181,208080058,208080298,208081795,208081807,208082992,208084960,208085935] · 89.99 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] · 4.84 ms