4 650 ₴
Ультрабук Microsoft Surface Laptop 1st Gen
4650.0
Луцк
Найдено 44 объявления
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "surface laptop",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 124
}
}
]
}
},
"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 · 100.85 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["luck","\/luck","luck\/","\/luck\/"] · 10.17 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.37 msSHOW TABLES · 18.95 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, ''), NULLIF(c.name_ua, '')) 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) [189897735,200661109,213937916,200555002,196518992,205436174,205311464,185779056,216889585,205724684,204878948,204878927,204025044,204024819,203953092,203821173,203386148,203027659,202062323,200462725,200371108,196569387,216266833,214813941,213666066,213048009,212623911,219428773,215943202,215501817,215154012,214330785,213145539,213772161,217451077,212623875,218005651,217451572,214130054,213145629,213145635,207876937,212942967,213145833] · 215.71 msSELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [185779056,189897735,196518992,196569387,200371108,200462725,200555002,200661109,202062323,203027659,203386148,203821173,203953092,204024819,204025044,204878927,204878948,205311464,205436174,205724684,207876937,212623875,212623911,212942967,213048009,213145539,213145629,213145635,213145833,213666066,213772161,213937916,214130054,214330785,214813941,215154012,215501817,215943202,216266833,216889585,217451077,217451572,218005651,219428773] · 63.5 msSELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 17.86 ms