2 500 ₴
Кавомашина на запчастини сименс EQ7
2500.0
Мачухи
Знайдено 440 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6697
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 100,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.53 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 ["machehi","\/machehi","machehi\/","\/machehi\/"] · 0.97 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.44 msSHOW TABLES · 0.8 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) [213550287,213494157,213173145,213099978,213046515,212970234,212894181,212836050,212805687,212482323,212356314,212356089,212290665,212217009,212158050,211806501,211793934,211730397,211649826,211647315,211636065,211636041,211630695,211537032,211397229,211062374,211012090,210953694,210928166,210927668,210890580,210888792,210854036,210835472,210798940,210782564,210752856,210648404,210428546,210257984,210193406,210127730,209812430,209550025,209240797,209101711,209101693,209101639,209070853,209046778] · 28.92 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 [209046778,209070853,209101639,209101693,209101711,209240797,209550025,209812430,210127730,210193406,210257984,210428546,210648404,210752856,210782564,210798940,210835472,210854036,210888792,210890580,210927668,210928166,210953694,211012090,211062374,211397229,211537032,211630695,211636041,211636065,211647315,211649826,211730397,211793934,211806501,212158050,212217009,212290665,212356089,212356314,212482323,212805687,212836050,212894181,212970234,213046515,213099978,213173145,213494157,213550287] · 19.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.parent_id = ? LIMIT 3000 [5] · 1 ms