5 500 ₴
Msi rtx 4070 12gb
5500.0
Київ
Знайдено 1 306 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "msi rtx 4070",
"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 · 1.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) [208089115,201669149,211654692,189721479,183166221,197172910,196968193,196326155,196614535,193032515,216433588,208305679,207876913,199180354,198582606,178816054,217887175,201099607,199382044,197895910,188305053,185570313,210801720,209125438,208407151,181414531,200364649,215304558,211815255,208954063,208193071,206838152,201581433,199587055,195654896,217838287,215834293,205501664,200266264,198975901,197176813,197120791,195395585,195234269,193804163,183250833,200653876,214059344,213048000,212146383] · 106.94 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 [178816054,181414531,183166221,183250833,185570313,188305053,189721479,193032515,193804163,195234269,195395585,195654896,196326155,196614535,196968193,197120791,197172910,197176813,197895910,198582606,198975901,199180354,199382044,199587055,200266264,200364649,200653876,201099607,201581433,201669149,205501664,206838152,207876913,208089115,208193071,208305679,208407151,208954063,209125438,210801720,211654692,211815255,212146383,213048000,214059344,215304558,215834293,216433588,217838287,217887175] · 1.25 msSELECT c.* FROM `category` c ORDER BY c.id · 1.06 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.53 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,122,127,117,120,135,129,116,139,124,2101,126,137,121,138,133,2218,128,2167,2213,119,2124,3092,3123,6283,132,140,2715,3331] · 0.63 ms