5 500 ₴
Срочно!!! Продам кофемашини з молочником дуже великий вибір!!!
5500.0
Яготин
Знайдено 3 447 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3107
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 6.33 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 ["yagotin","\/yagotin","yagotin\/","\/yagotin\/"] · 2.79 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.17 msSHOW TABLES · 0.71 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) [196567009,196565919,196561545,196548207,196540268,196524884,196506332,196500413,196498207,196488752,196486607,196468022,196430858,196396685,196385303,196330067,196325921,196325060,196320008,196282331,196268429,196266695,196261700,196224470,196176743,196174265,196168268,196163123,196138427,196123355,196121852,196052672,196042976,196037873,196031120,196027670,196025726,196006820,196006817,196003796,196002383,195994760,195983150,195966056,195940676,195865439,195857705,195837035,195836897,195823283] · 91.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 [195823283,195836897,195837035,195857705,195865439,195940676,195966056,195983150,195994760,196002383,196003796,196006817,196006820,196025726,196027670,196031120,196037873,196042976,196052672,196121852,196123355,196138427,196163123,196168268,196174265,196176743,196224470,196261700,196266695,196268429,196282331,196320008,196325060,196325921,196330067,196385303,196396685,196430858,196468022,196486607,196488752,196498207,196500413,196506332,196524884,196540268,196548207,196561545,196565919,196567009] · 1 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.49 ms