552 ₴
‼️Знижки‼️ Бездротові навушники AirPods 3 FULL
552.0
Переможець
Знайдено 47 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 7672
}
}
]
}
},
"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 · 1.32 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 ["pobeditel","\/pobeditel","pobeditel\/","\/pobeditel\/"] · 0.94 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 2.13 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) [218945084,218880470,218850446,217808749,217599034,217439491,216893884,215911924,215295522,215221650,214951443,214060450,213951496,213879606,212452281,211221873,210783692,210358628,209520124,209515276,209515267,208789501,208310935,208174633,208037731,208031974,204249921,204177111,203056804,202182232,201914153,201846195,199486471,199312603,197869243,197169541,197084707,197010067,194509844,187301874,187301823,180871579,176965853,173363371,172613017,170919499,169709011] · 104.08 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 [169709011,170919499,172613017,173363371,176965853,180871579,187301823,187301874,194509844,197010067,197084707,197169541,197869243,199312603,199486471,201846195,201914153,202182232,203056804,204177111,204249921,208031974,208037731,208174633,208310935,208789501,209515267,209515276,209520124,210358628,210783692,211221873,212452281,213879606,213951496,214060450,214951443,215221650,215295522,215911924,216893884,217439491,217599034,217808749,218850446,218880470,218945084] · 81.75 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] · 3.36 ms