1 300 ₴
Продам сукню дитячу 74-80 розмір
1300.0
Коростень
Знайдено 12 666 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2150
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.8 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 ["korosten","\/korosten","korosten\/","\/korosten\/"] · 1.57 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.56 msSHOW TABLES · 0.47 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) [218956331,218955578,218953208,218953016,218952698,218951228,218950208,218948660,218948642,218946305,218943566,218941229,218941049,218940299,218932082,218928491,218928407,218922950,218922680,218921963,218919845,218915624,218912897,218912474,218912066,218911211,218911193,218910377,218908646,218907737,218906861,218902628,218901479,218899634,218895896,218895560,218894276,218891633,218891603,218891069,218878709,218873858,218873213,218871863,218870972,218869970,218867078,218864525,218864420,218856947] · 40.2 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 [218856947,218864420,218864525,218867078,218869970,218870972,218871863,218873213,218873858,218878709,218891069,218891603,218891633,218894276,218895560,218895896,218899634,218901479,218902628,218906861,218907737,218908646,218910377,218911193,218911211,218912066,218912474,218912897,218915624,218919845,218921963,218922680,218922950,218928407,218928491,218932082,218940299,218941049,218941229,218943566,218946305,218948642,218948660,218950208,218951228,218952698,218953016,218953208,218955578,218956331] · 57.35 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.9 ms