109 $
Блок керування двигуном Polestar2 Блок управления двигателем Polestar
4796.0
Одеса
Знайдено 7 359 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "polestar",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
]
}
},
"sort": [
"_score",
{
"data_post": {
"order": "desc"
}
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cities": {
"terms": {
"field": "city_id",
"size": 30
}
},
"cats": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
}SHOW TABLES · 2.94 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) [216154729,214573470,212933022,178152837,172863874,171628231,186033072,197220537,197220513,197220503,197220451,203858763,197734922,197220525,197220511,197220419,197220417,214138834,214120620,214119586,214084720,214041954,214026226,214024646,213927152,213887798,213867222,213866760,213815235,213788571,213754329,213645885,213534780,213437706,213209226,213156291,212889834,212704257,212684373,212609886,212575560,212563956,212526222,212525094,212524089,212388897,212337792,212265711,212263128,212235369] · 79.77 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 [171628231,172863874,178152837,186033072,197220417,197220419,197220451,197220503,197220511,197220513,197220525,197220537,197734922,203858763,212235369,212263128,212265711,212337792,212388897,212524089,212525094,212526222,212563956,212575560,212609886,212684373,212704257,212889834,212933022,213156291,213209226,213437706,213534780,213645885,213754329,213788571,213815235,213866760,213867222,213887798,213927152,214024646,214026226,214041954,214084720,214119586,214120620,214138834,216154729] · 20.53 msSELECT c.* FROM `category` c ORDER BY c.id · 0.6 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.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.parent_id = ? LIMIT 3000 [5] · 0.52 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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [115,125,2124,135,129,124,117,116,127,6574,120,121,3499,2203,133,128,137,119,138,139,2101,2107,122,132,3200,3083,140,2181,134,126] · 0.51 ms