410 ₴
Сукня святкова з фатину для дівчинки
410.0
Кагарлик
Знайдено 2 832 оголошення
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 2676
}
}
]
}
},
"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 · 1.64 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 ["kagarlyk","\/kagarlyk","kagarlyk\/","\/kagarlyk\/"] · 1.38 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.84 msSHOW TABLES · 0.94 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) [216949423,216949363,216949330,216949291,216942085,216927445,216926602,216913837,216913207,216902323,216884632,216877936,216875893,216873019,216849049,216842197,216837493,216809339,216800521,216790563,216788821,216771859,216746779,216740551,216736759,216720982,216719401,216688852,216673453,216672763,216672724,216664090,216642322,216641890,216608674,216601027,216589714,216584917,216584887,216584761,216564409,216556774,216551014,216549391,216541918,216533515,216529966,216502108,216479227,216463426] · 126.5 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 [216463426,216479227,216502108,216529966,216533515,216541918,216549391,216551014,216556774,216564409,216584761,216584887,216584917,216589714,216601027,216608674,216641890,216642322,216664090,216672724,216672763,216673453,216688852,216719401,216720982,216736759,216740551,216746779,216771859,216788821,216790563,216800521,216809339,216837493,216842197,216849049,216873019,216875893,216877936,216884632,216902323,216913207,216913837,216926602,216927445,216942085,216949291,216949330,216949363,216949423] · 22.46 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] · 2.05 ms