2 700 ₴
Шкільна форма, сарафан, плаття
2700.0
Почаев
Найдено 3 842 объявления
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 3488
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 2000,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 2.5 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["pochaev","\/pochaev","pochaev\/","\/pochaev\/"] · 1.12 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 0.67 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, ''), NULLIF(c.name_ua, '')) 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) [197927959,197926690,197922001,197921989,197905666,197890561,197885773,197884702,197884675,197875801,197870161,197870062,197865655,197852435,197846129,197843156,197839247,197833886,197830739,197829155,197819995,197819629,197808441,197808225,197807135,197798795,197793056,197758325,197742047,197734826,197727032,197721389,197721386,197721380,197717915,197709515,197691944,197667968,197667485,197664734,197618159,197614142,197594081,197593850,197593319,197590370,197576117,197575388,197570543,197560226] · 52.12 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [197560226,197570543,197575388,197576117,197590370,197593319,197593850,197594081,197614142,197618159,197664734,197667485,197667968,197691944,197709515,197717915,197721380,197721386,197721389,197727032,197734826,197742047,197758325,197793056,197798795,197807135,197808225,197808441,197819629,197819995,197829155,197830739,197833886,197839247,197843156,197846129,197852435,197865655,197870062,197870161,197875801,197884675,197884702,197885773,197890561,197905666,197921989,197922001,197926690,197927959] · 1.36 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 1.52 ms