10 500 ₴
Ноутбук DELL Precision 3541
10500.0
Біла Церква
Знайдено 226 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "dell precision 3551",
"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.41 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) [217639411,191301001,189800013,184091745,217256545,198775051,167960257,204746882,198508002,201627453,196967947,194784596,218199325,218286619,217887097,201583737,198351242,196569517,196569381,192794095,204878837,183319859,214813782,212153418,203159641,199078156,207431224,205651349,197850827,197518965,197467328,189650526,179293531,209133349,203386220,195237602,181947958,175286071,214505214,218155357,217096978,205105640,203640538,202062511,192794002,187747032,173897002,201540151,201583857,218332700] · 44.15 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 [167960257,173897002,175286071,179293531,181947958,183319859,184091745,187747032,189650526,189800013,191301001,192794002,192794095,194784596,195237602,196569381,196569517,196967947,197467328,197518965,197850827,198351242,198508002,198775051,199078156,201540151,201583737,201583857,201627453,202062511,203159641,203386220,203640538,204746882,204878837,205105640,205651349,207431224,209133349,212153418,214505214,214813782,217096978,217256545,217639411,217887097,218155357,218199325,218286619,218332700] · 2.32 msSELECT c.* FROM `category` c ORDER BY c.id · 0.95 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.94 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [121,115,127,135,117,125,2181,124,116,133,3088,126,134,6152,129,2165,139,2163,2485,119,120,2101,2167,2213,3085,3198,6112,122,128,2142] · 1.45 ms