14 750 ₴
HP Pavilion 15 16/512 Ryzen 5
14750.0
Рівне
Знайдено 68 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "hp ryzen",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 129
}
}
]
}
},
"sort": [
"_score",
{
"data_post": {
"order": "desc"
}
}
],
"from": 0,
"size": 50,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true,
"aggs": {
"cats": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
}SELECT c.* FROM `category` c ORDER BY c.id · 10.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.url IN (?, ?, ?, ?) LIMIT 1 ["rovno","\/rovno","rovno\/","\/rovno\/"] · 5.13 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.4 msSHOW TABLES · 2.79 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) [189388689,218661902,204422216,203704232,203210189,211482999,207199816,205931396,212832282,212724792,200462554,200036413,195395435,216693808,217401580,215251389,210446249,218006119,209433118,219428551,208397716,218243383,216378640,216170353,191294887,198771265,215304447,192419386,216060214,204878807,203440904,188204367,204314922,196326017,204501173,204500924,202127842,195234335,201491435,215304444,215304441,215304432,215304426,204668270,199385467,194695598,216378283,216378235,204501116,181521715] · 33.34 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 [181521715,188204367,189388689,191294887,192419386,194695598,195234335,195395435,196326017,198771265,199385467,200036413,200462554,201491435,202127842,203210189,203440904,203704232,204314922,204422216,204500924,204501116,204501173,204668270,204878807,205931396,207199816,208397716,209433118,210446249,211482999,212724792,212832282,215251389,215304426,215304432,215304441,215304444,215304447,216060214,216170353,216378235,216378283,216378640,216693808,217401580,218006119,218243383,218661902,219428551] · 4.2 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.7 ms