166 ₴
Кабель Awei 60W type-c type-c 1m для Apple, в обплетеннi
166.0
Знайдено 118 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "apple type c 60w",
"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 · 3.97 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) [181469440,199888204,179646021,214579059,217599004,186679383,195388772,207324079,181767037,219394735,219394762,207421330,216961771,176594125,189650382,200196646,215942698,197068183,179646111,202636529,205175621,179646063,205647140,185493516,210354914,180866209,185965500,214946142,202839280,204358985,216266128,198504386,175635538,191033190,217786312,167178076,180594730,179646033,186510519,217437598,208832707,217256947,200461129,178753846,189057474,171901363,217597813,200519086,192790606,192859498] · 62.86 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 [167178076,171901363,175635538,176594125,178753846,179646021,179646033,179646063,179646111,180594730,180866209,181469440,181767037,185493516,185965500,186510519,186679383,189057474,189650382,191033190,192790606,192859498,195388772,197068183,198504386,199888204,200196646,200461129,200519086,202636529,202839280,204358985,205175621,205647140,207324079,207421330,208832707,210354914,214579059,214946142,215942698,216266128,216961771,217256947,217437598,217597813,217599004,217786312,219394735,219394762] · 8.62 msSELECT c.* FROM `category` c ORDER BY c.id · 0.72 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.45 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.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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [115,121,127,120,125,135,137,117,6334,119,124,126,129,132,128,138,2107,2181,3605,116,122,133,134,136,140,2218,3188,3453,6130,6162] · 0.52 ms