700 $
Акпп автоматична коробка передач GM 5L40 м54 3.0 bmw x5 e53 m54b30
30800.0
Завалів
Знайдено 264 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 9224
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 150,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.97 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 ["zavalov","\/zavalov","zavalov\/","\/zavalov\/"] · 1.48 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.39 msSHOW TABLES · 0.59 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) [197213182,197189767,196973602,196680082,196633915,196633900,196586153,196586149,195831428,195830216,195444617,195238658,194912774,194897135,194554868,194175767,193486117,192973234,192970480,192967198,192967120,192966970,192791815,192747784,190939956,190646877,189127736,189127251,189110256,188471487,187841100,187831194,186829812,186565083,186556383,186366486,185358918,184513785,184086585,184074405,184000314,183975195,183973062,183645234,183455454,183295881,183166812,182582395,182013184,181689868] · 36.8 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 [181689868,182013184,182582395,183166812,183295881,183455454,183645234,183973062,183975195,184000314,184074405,184086585,184513785,185358918,186366486,186556383,186565083,186829812,187831194,187841100,188471487,189110256,189127251,189127736,190646877,190939956,192747784,192791815,192966970,192967120,192967198,192970480,192973234,193486117,194175767,194554868,194897135,194912774,195238658,195444617,195830216,195831428,196586149,196586153,196633900,196633915,196680082,196973602,197189767,197213182] · 1.12 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.89 ms