10 500 ₴
Ноутбук DELL Precision 3541
10500.0
Біла Церква
Знайдено 199 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "dell precision 3581",
"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.72 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,184091745,198775051,167960257,183319859,218199325,204746882,217096978,215998894,204878837,216322984,218332700,202526903,187212780,207431224,205651349,201627453,197850827,196967947,194784596,202839298,197805633,214505214,218155357,217887097,205105640,203640538,201941799,201583737,198351242,196569517,196569381,192794095,187747032,215501466,215053407,214813782,212153418,211884936,207530773,207323989,205175405,203159641,202705009,199078156,197519045,196666822,193807976,192862915,179293531] · 52.69 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,179293531,183319859,184091745,187212780,187747032,192794095,192862915,193807976,194784596,196569381,196569517,196666822,196967947,197519045,197805633,197850827,198351242,198775051,199078156,201583737,201627453,201941799,202526903,202705009,202839298,203159641,203640538,204746882,204878837,205105640,205175405,205651349,207323989,207431224,207530773,211884936,212153418,214505214,214813782,215053407,215501466,215998894,216322984,217096978,217639411,217887097,218155357,218199325,218332700] · 6.54 msSELECT c.* FROM `category` c ORDER BY c.id · 0.75 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.67 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.62 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,127,121,135,117,125,2181,116,133,3088,6152,124,126,129,2165,119,134,2163,2485,120,139,2167,2213,3198,3336,3483,6335,122,128,2101] · 2 ms