40 000 ₴
Весільна сукня в ідеальному стані
40000.0
Чайковка
Найдено 377 объявлений
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6755
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 50,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 0.91 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 ["chaykovka","\/chaykovka","chaykovka\/","\/chaykovka\/"] · 1.1 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.56 msSHOW TABLES · 0.59 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) [217505806,217382821,217373686,217316953,217218298,217187302,217124008,217086964,217048774,216960844,216969511,216952924,216934294,216931564,216897607,216897451,216881215,216846934,216831781,216707053,216697468,216656524,216568783,216544105,216513160,216468367,216434947,216381688,216333379,216276691,216251320,216225664,216223102,216201106,216124867,216061978,215942323,215915365,215826616,215769584,215722844,215584290,215491824,215412873,215394258,215386796,215384764,215309133,215116914,215076453] · 20.44 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 [215076453,215116914,215309133,215384764,215386796,215394258,215412873,215491824,215584290,215722844,215769584,215826616,215915365,215942323,216061978,216124867,216201106,216223102,216225664,216251320,216276691,216333379,216381688,216434947,216468367,216513160,216544105,216568783,216656524,216697468,216707053,216831781,216846934,216881215,216897451,216897607,216931564,216934294,216952924,216969511,217048774,217086964,217124008,217187302,217218298,217316953,217382821,217505806] · 18.42 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] · 0.88 ms