1 700 $
Kia Rio Кондиціонер 2002 рік
74800.0
Бородянка
Знайдено 5 901 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3082
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2200,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.94 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 ["borodyanka","\/borodyanka","borodyanka\/","\/borodyanka\/"] · 0.56 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.79 msSHOW TABLES · 1.16 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) [203313215,203306237,203304926,203285402,203272661,203259995,203253617,203249924,203249096,203229980,203219672,203214131,203209073,203205749,203195945,203174512,203172403,203162512,203161711,203148577,203148529,203147440,203145367,203142505,203139781,203137561,203134546,203131741,203129227,203122684,203121292,203117065,203109400,203109277,203103328,203102551,203100847,203083222,203062366,203060809,203050405,203050381,203050363,203047141,203043679,203028865,203008210,203008177,203007733,202978567] · 52.1 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 [202978567,203007733,203008177,203008210,203028865,203043679,203047141,203050363,203050381,203050405,203060809,203062366,203083222,203100847,203102551,203103328,203109277,203109400,203117065,203121292,203122684,203129227,203131741,203134546,203137561,203139781,203142505,203145367,203147440,203148529,203148577,203161711,203162512,203172403,203174512,203195945,203205749,203209073,203214131,203219672,203229980,203249096,203249924,203253617,203259995,203272661,203285402,203304926,203306237,203313215] · 1.98 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.8 ms