14 200 ₴
Iphone 13 IP68 Айфон 13 ІДЕАЛ!!!
14200.0
Луцьк
Знайдено 78 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "iphone 13 ip68",
"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.5 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) [203024461,213347547,190950357,205307492,190170144,188106765,189646752,193699427,199074043,204946631,193502218,193501987,202700605,194869106,200653723,195741161,197991862,199175866,198504434,189476760,192496264,192496243,192496225,192496192,189721125,205647587,203637630,192068383,191132235,187476438,202701100,203382143,194245844,202966630,202905508,208622242,173892358,203751350,202524395,199857535,194695190,178815682,212822271,207067549,190873512,202966639,200976793,212443329,207746911,197462618] · 40.82 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 [173892358,178815682,187476438,188106765,189476760,189646752,189721125,190170144,190873512,190950357,191132235,192068383,192496192,192496225,192496243,192496264,193501987,193502218,193699427,194245844,194695190,194869106,195741161,197462618,197991862,198504434,199074043,199175866,199857535,200653723,200976793,202524395,202700605,202701100,202905508,202966630,202966639,203024461,203382143,203637630,203751350,204946631,205307492,205647587,207067549,207746911,208622242,212443329,212822271,213347547] · 1.51 msSELECT c.* FROM `category` c ORDER BY c.id · 0.73 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.47 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.45 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,3123,120,117,135,2101,6203,119,122,124,125,126,129,133,138,140,2107,3188,3234,3331,3565,6146,9661] · 0.63 ms