5 999 ₴
FDIK T7 8 кВт KW — НОВИЙ АВТОНОМНИЙ ДИЗЕЛЬНИЙ ОБІГРІВАЧ (12/24/220 В V) аналог вебасто автономка
5999.0
Баришівка
Знайдено 127 оголошень
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
53,
98,
60,
59,
58,
57,
56,
55,
54
]
}
},
{
"term": {
"city_id": 3078
}
}
]
}
},
"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 · 1.44 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 ["baryshevka","\/baryshevka","baryshevka\/","\/baryshevka\/"] · 0.86 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.71 msSHOW TABLES · 1.35 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) [219512854,219321727,219318622,218988455,218945081,218822486,218241526,217966677,216937708,216744184,216063028,215695958,215652954,215646297,215595666,215348160,215348114,214902730,214698984,214327710,214003060,214001936,213657705,213549387,212931912,212622357,212252433,212250717,212250663,212156319,212059806,211654797,211238574,211232682,210898094,210851068,210850712,210850462,210622572,210536807,210444620,210192014,210191522,210191333,210191258,210189914,209616928,209135872,208520545,208302391] · 47.35 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 [208302391,208520545,209135872,209616928,210189914,210191258,210191333,210191522,210192014,210444620,210536807,210622572,210850462,210850712,210851068,210898094,211232682,211238574,211654797,212059806,212156319,212250663,212250717,212252433,212622357,212931912,213549387,213657705,214001936,214003060,214327710,214698984,214902730,215348114,215348160,215595666,215646297,215652954,215695958,216063028,216744184,216937708,217966677,218241526,218822486,218945081,218988455,219318622,219321727,219512854] · 2.59 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.12 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.99 ms