51 000 ₴
30/927194 Радіатор водяний JS240-290
51000.0
Перемога
Знайдено 546 оголошень
{
"query": {
"bool": {
"filter": [
{
"term": {
"city_id": 6790
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 300,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
}SELECT c.* FROM `category` c ORDER BY c.id · 1.01 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 ["peremoga","\/peremoga","peremoga\/","\/peremoga\/"] · 0.71 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.29 msSHOW TABLES · 0.58 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) [203028628,202880920,202837321,202598681,202598111,202597495,202555001,202388965,202379621,202373317,202372467,202148488,202095826,202030027,201962841,201917791,201917765,201869635,201804635,201790835,201782461,201742571,201734113,201475135,201415165,201353791,201288079,201140812,201088957,200826730,200810536,200084062,200055106,199915615,199804183,199803517,199771102,199722463,199386661,199376824,199352002,199202002,199201966,199122940,198939811,198892336,198785563,198728578,198697999,198678262] · 20.22 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 [198678262,198697999,198728578,198785563,198892336,198939811,199122940,199201966,199202002,199352002,199376824,199386661,199722463,199771102,199803517,199804183,199915615,200055106,200084062,200810536,200826730,201088957,201140812,201288079,201353791,201415165,201475135,201734113,201742571,201782461,201790835,201804635,201869635,201917765,201917791,201962841,202030027,202095826,202148488,202372467,202373317,202379621,202388965,202555001,202597495,202598111,202598681,202837321,202880920,203028628] · 1.35 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.86 ms