30 ₴
Продам відра на 5, 10 літрів пластикові, емальовані
30.0
Власівка
Знайдено 793 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6302
}
}
]
}
},
"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 · 25.56 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 ["vlasovka","\/vlasovka","vlasovka\/","\/vlasovka\/"] · 0.62 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 11.17 msSHOW TABLES · 0.63 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) [219837666,219827114,219812046,219811678,219720250,219703210,219701422,219698106,219690942,219649094,219630054,219600586,219549799,219540655,219538975,219440695,219440617,219435676,219372454,219363262,219362371,219356902,219341323,219319030,219285058,219282940,219282166,219281782,219221290,219086849,219052475,219046727,219043493,218995895,218994422,218994110,218994080,218959301,218955659,218950592,218943491,218935883,218894066,218875796,218843936,218836049,218831099,218804390,218722352,218722268] · 7.13 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 [218722268,218722352,218804390,218831099,218836049,218843936,218875796,218894066,218935883,218943491,218950592,218955659,218959301,218994080,218994110,218994422,218995895,219043493,219046727,219052475,219086849,219221290,219281782,219282166,219282940,219285058,219319030,219341323,219362371,219372454,219435676,219440617,219440695,219538975,219540655,219549799,219600586,219630054,219649094,219690942,219698106,219701422,219703210,219720250,219811678,219812046,219827114,219837666] · 12.21 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.97 ms