10 000 ₴
OnePlus 10 Pro 128GB
10000.0
Київ
Знайдено 143 оголошення
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "oneplus 10 pro",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"terms": {
"category_id": [
53,
98,
60,
59,
58,
57,
56,
55,
54
]
}
}
]
}
},
"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
}
}
}
}SELECT c.* FROM `category` c ORDER BY c.id · 1.85 msSHOW TABLES · 1.74 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) [196960075,196736875,203320547,196224416,185464611,204812387,203574683,204244581,197217659,171902005,192047677,191961841,182332759,200266051,190873677,199586125,183317027,211025598,203817768,194168396,207745912,177318745,207188410,188673036,178893997,203637630,202701100,212145777,188009550,218334239,213336597,201996823,188306373,201846153,202966486,181949284,213872790,196513811,203320535,210185888,213346437,196365974,213760980,201996712,167499316,219511717,218901404,202966639,177615457,202966630] · 28.49 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 [167499316,171902005,177318745,177615457,178893997,181949284,182332759,183317027,185464611,188009550,188306373,188673036,190873677,191961841,192047677,194168396,196224416,196365974,196513811,196736875,196960075,197217659,199586125,200266051,201846153,201996712,201996823,202701100,202966486,202966630,202966639,203320535,203320547,203574683,203637630,203817768,204244581,204812387,207188410,207745912,210185888,211025598,212145777,213336597,213346437,213760980,213872790,218334239,218901404,219511717] · 2.73 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.08 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.08 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,125,129,133,117,124,135,3194,119,134,139,2101,2153,2165,116,126,128,137,2142,2163,2190,2217,2717,2994,3082,3187,3332,3483] · 0.79 msSELECT v.attribute_id, v.value, COUNT(*) AS cnt FROM (SELECT p.id FROM `post` p WHERE p.category_id IN (?,?,?,?,?,?,?,?,?) AND (1) ORDER BY p.id DESC LIMIT 3000) s JOIN `attribute_value` v ON v.post_id = s.id WHERE v.value IS NOT NULL AND v.value <> '' AND CHAR_LENGTH(v.value) <= 60 GROUP BY v.attribute_id, v.value [53,98,60,59,58,57,56,55,54] · 60.15 ms