1 800 ₴
Аккумуляторная кофемашина Dnipro-M DCM-200
1800.0
Коростень
Найдено 12 607 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2150
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.81 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["korosten","\/korosten","korosten\/","\/korosten\/"] · 0.97 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.48 msSHOW TABLES · 0.92 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, ''), NULLIF(c.name_ua, '')) 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) [219703154,219699734,219696778,219695510,219691894,219690146,219689098,219687026,219683922,219672522,219671326,219664798,219661626,219661570,219659946,219658734,219658298,219658090,219657938,219656466,219653718,219649586,219638374,219635310,219635102,219634730,219633362,219633262,219625898,219624694,219620078,219596530,219596238,219585964,219585568,219583345,219583246,219583114,219572956,219568666,219564730,219563956,219563803,219559189,219555982,219554962,219553900,219552163,219551773,219549775] · 1.83 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [219549775,219552163,219553900,219554962,219555982,219559189,219563803,219563956,219564730,219568666,219572956,219583114,219583246,219583345,219585964,219596530,219620078,219624694,219625898,219633262,219633362,219634730,219635102,219635310,219638374,219649586,219653718,219656466,219657938,219658090,219658298,219658734,219659946,219661570,219661626,219664798,219671326,219672522,219683922,219687026,219689098,219690146,219691894,219696778,219699734,219703154] · 5.19 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.89 ms