1 100 ₴
Манекени (розміри: S, M, L)
1100.0
Малин
Знайдено 42 оголошення
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
88,
94,
93,
92,
91,
90,
89
]
}
},
{
"term": {
"city_id": 3067
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 3.49 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 ["malin","\/malin","malin\/","\/malin\/"] · 1.66 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.44 msSHOW TABLES · 1.46 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) [218787095,218061445,217937979,217749727,217001254,216337648,215846761,214914414,211101935,211101869,209924627,209560393,209464354,208775380,207674785,205877093,205605125,205390484,203404241,201397977,201347759,200302708,200217556,200055985,199884070,198075253,196727810,195771800,194996900,192544495,188906940,187603530,187155123,184950933,184924959,184924956,184924953,184857163,184857160,180607717,180459524,170442733] · 30.03 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 [170442733,180459524,180607717,184857160,184857163,184924953,184924956,184924959,184950933,187155123,187603530,188906940,192544495,194996900,195771800,196727810,198075253,199884070,200055985,200217556,200302708,201347759,201397977,203404241,205390484,205605125,205877093,207674785,208775380,209464354,209560393,209924627,211101869,211101935,214914414,215846761,217001254,217749727,217937979,218061445,218787095] · 1.05 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.89 msSELECT v.attribute_id, v.value, COUNT(*) AS cnt FROM (SELECT p.id FROM `post` p WHERE p.category_id IN (?,?,?,?,?,?,?) AND (1) ORDER BY p.id DESC LIMIT 3000) s JOIN `attribute_value` v ON v.post_id = s.id WHERE v.value IS NOT NULL AND v.value <> '' AND CHAR_LENGTH(v.value) <= 60 GROUP BY v.attribute_id, v.value [88,94,93,92,91,90,89] · 203.43 ms