650 ₴
Біле святкове плаття на дівчину 128 ріст
650.0
Умань
Знайдено 30 584 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2218
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 8050,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.48 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 ["uman","\/uman","uman\/","\/uman\/"] · 5.09 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.87 msSHOW TABLES · 1.87 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) [211054542,211054244,211051696,211051560,211051550,211051414,211051334,211051010,211050778,211050610,211050034,211050018,211049978,211048764,211046660,211046630,211045610,211042178,211037314,211037058,211036418,211036092,211034494,211031064,211029622,211029202,211028228,211025460,211025326,211024976,211024794,211022586,211020396,211019624,211019454,211019338,211017068,211016338,211015304,211012082,211012076,211008410,211007776,211007186,211007132,211007112,211007050,211005046,211004434,211004432] · 67.89 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 [211004432,211004434,211005046,211007050,211007112,211007132,211007186,211007776,211008410,211012076,211012082,211015304,211016338,211017068,211019338,211019454,211019624,211020396,211022586,211024794,211024976,211025326,211025460,211028228,211029202,211029622,211031064,211034494,211036092,211036418,211037058,211037314,211042178,211045610,211046630,211046660,211048764,211049978,211050018,211050034,211050610,211050778,211051010,211051334,211051414,211051550,211051560,211051696,211054244,211054542] · 31.11 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.52 ms