5 000 ₴
Продам оригинальные пороги на BMW X5, 2019 г., G05
5000.0
Ліски
Знайдено 3 621 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6182
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 500,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.05 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\/"] · 1.44 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.18 msSHOW TABLES · 1.13 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) [215956174,215955511,215952739,215951581,215951551,215945653,215940577,215938012,215931313,215929144,215925157,215924293,215915980,215911789,215903668,215901802,215893930,215893054,215888686,215884048,215881777,215875123,215871577,215868898,215868871,215846722,215846020,215845390,215842756,215837902,215830354,215829088,215798937,215790561,215788199,215783675,215783635,215782607,215774768,215774720,215774654,215769755,215769515,215767094,215765300,215749658,215748092,215741255,215739233,215733671] · 42.95 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 [215733671,215739233,215741255,215748092,215749658,215765300,215767094,215769515,215769755,215774654,215774720,215774768,215782607,215783635,215783675,215788199,215790561,215798937,215829088,215830354,215837902,215842756,215845390,215846020,215846722,215868871,215868898,215871577,215875123,215881777,215884048,215888686,215893054,215893930,215901802,215903668,215911789,215915980,215924293,215925157,215929144,215931313,215938012,215940577,215945653,215951551,215951581,215952739,215955511,215956174] · 66.14 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] · 3.21 ms