5 500 ₴
Музыкальный центр Alwa nsx V-70 Japan!
5500.0
Свобода
Знайдено 41 оголошення
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
53,
98,
60,
59,
58,
57,
56,
55,
54
]
}
},
{
"term": {
"city_id": 6864
}
}
]
}
},
"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 · 27.84 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 ["sloboda","\/sloboda","sloboda\/","\/sloboda\/"] · 0.75 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.2 msSHOW TABLES · 8.92 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) [218244688,217451131,216744709,215834560,215102514,213662250,213662205,213139824,212939826,212147844,211816476,211659201,211565046,210969882,209341204,209132038,208624129,208517854,207988054,207525682,205651793,204500807,203211983,203206226,201899537,199385281,198656230,197955694,197520019,197416097,197072248,196089311,191678458,189121875,189052764,185375790,185096247,177615061,176728067,171083554,169040101] · 42.59 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 [169040101,171083554,176728067,177615061,185096247,185375790,189052764,189121875,191678458,196089311,197072248,197416097,197520019,197955694,198656230,199385281,201899537,203206226,203211983,204500807,205651793,207525682,207988054,208517854,208624129,209132038,209341204,210969882,211565046,211659201,211816476,212147844,212939826,213139824,213662205,213662250,215102514,215834560,216744709,217451131,218244688] · 1.66 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] · 1.11 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 [53,98,60,59,58,57,56,55,54] · 106.19 ms