700 ₴
Резинові ролики картоплекопалки пара
700.0
Хорошів
Знайдено 541 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 11301
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.77 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 ["horoshev","\/horoshev","horoshev\/","\/horoshev\/"] · 1.14 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.25 msSHOW TABLES · 1.27 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) [217578889,217578823,217578727,217578580,217577506,217577479,217576024,217574878,217573006,217559713,217552051,217501933,217445140,217312039,217221652,217213534,217137994,216979675,216957226,216899971,216880102,216852544,216816065,216815765,216708358,216705955,216682738,216682585,216676060,216669889,216644431,216642454,216640585,216573415,216558673,216522724,216390454,216235810,216214720,216202405,216187702,216157204,216147490,216146923,216123736,216104929,216012052,215823682,215819693,215733551] · 15.55 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 [215733551,215819693,215823682,216012052,216104929,216123736,216146923,216147490,216157204,216187702,216202405,216214720,216235810,216390454,216522724,216558673,216573415,216640585,216642454,216644431,216669889,216676060,216682585,216682738,216705955,216708358,216815765,216816065,216852544,216880102,216899971,216957226,216979675,217137994,217213534,217221652,217312039,217445140,217501933,217552051,217559713,217573006,217574878,217576024,217577479,217577506,217578580,217578727,217578823,217578889] · 6.43 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.59 ms