5 500 ₴
Радар Дистронік ACC круіз Адаптивний
5500.0
Чигирин
Знайдено 1 532 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3372
}
}
]
}
},
"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.93 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 ["chigirin","\/chigirin","chigirin\/","\/chigirin\/"] · 12.52 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.5 msSHOW TABLES · 0.65 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) [212658090,212648184,212626296,212620845,212592642,212582352,212581173,212561667,212509383,212443467,212442783,212426778,212393841,212384490,212384331,212374128,212358468,212355042,212354697,212353350,212313300,212300508,212299995,212299278,212298876,212251293,212228967,212227605,212218182,212217675,212119140,212107452,212100225,212060991,212000760,211995186,211909830,211884453,211805166,211779351,211740978,211726656,211726644,211726623,211723461,211722324,211722123,211718406,211703814,211662207] · 59.94 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 [211662207,211703814,211718406,211722123,211722324,211723461,211726623,211726644,211726656,211740978,211779351,211805166,211884453,211909830,211995186,212000760,212060991,212100225,212107452,212119140,212217675,212218182,212227605,212228967,212251293,212298876,212299278,212299995,212300508,212313300,212353350,212354697,212355042,212358468,212374128,212384331,212384490,212393841,212426778,212442783,212443467,212509383,212561667,212581173,212582352,212592642,212620845,212626296,212648184,212658090] · 36.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] · 0.54 ms