300 ₴
Ноутбук ACER 15"
300.0
Суми
Знайдено 988 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "acer 15",
"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 · 2.39 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) [186191130,186169704,218049226,214129856,204950669,203210381,201036469,196369514,185969739,183165801,217451389,217151875,216746932,216433513,216322834,216266875,215599158,215105100,213145497,211660806,209133286,208851601,205311362,199862140,198884131,198270309,197805659,197417729,194784866,187304895,170733493,219097523,216170290,215942731,214330656,208407142,207073875,201941625,191741134,187821645,179093878,218662337,217887220,217208122,214762845,210750720,209791169,203704094,201176989,187050618] · 45.29 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 [170733493,179093878,183165801,185969739,186169704,186191130,187050618,187304895,187821645,191741134,194784866,196369514,197417729,197805659,198270309,198884131,199862140,201036469,201176989,201941625,203210381,203704094,204950669,205311362,207073875,208407142,208851601,209133286,209791169,210750720,211660806,213145497,214129856,214330656,214762845,215105100,215599158,215942731,216170290,216266875,216322834,216433513,216746932,217151875,217208122,217451389,217887220,218049226,218662337,219097523] · 3.57 msSELECT c.* FROM `category` c ORDER BY c.id · 1.98 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.14 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] · 2.35 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,121,127,125,117,135,3088,126,120,137,129,116,124,139,128,140,2181,133,138,2101,2222,132,122,2124,6334,119,6152,2168,2213,3085] · 0.61 ms