19 800 $
Бурова установка самохідна японська ЕСО 1 V
871200.0
Фастів
Знайдено 11 582 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2168
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 250,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 106.38 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 ["fastov","\/fastov","fastov\/","\/fastov\/"] · 0.47 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.21 msSHOW TABLES · 9.05 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) [218861429,218861219,218860580,218850290,218848772,218847344,218847218,218847185,218847119,218845592,218838284,218836739,218833319,218831075,218822660,218820434,218798996,218798078,218792831,218789339,218784917,218774573,218773379,218771780,218771636,218770451,218762405,218757065,218754011,218749775,218746868,218735414,218745317,218744726,218744660,218740616,218738963,218733782,218731103,218728637,218726984,218726741,218726144,218719793,218718794,218713616,218709593,218707199,218706824,218705822] · 111.85 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 [218705822,218706824,218707199,218709593,218713616,218718794,218719793,218726144,218726741,218726984,218728637,218731103,218733782,218738963,218740616,218744660,218744726,218745317,218746868,218749775,218754011,218757065,218762405,218770451,218771636,218771780,218773379,218774573,218784917,218789339,218792831,218798078,218820434,218822660,218831075,218833319,218836739,218838284,218845592,218847119,218847185,218847218,218847344,218848772,218850290,218860580,218861219,218861429] · 174.97 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.41 ms