500 ₴
Поріг/пороги BMW E81/E82/E87/E88/E21/E30/E36/E46/E92/E93/F30/F31/G20
500.0
Київ
Знайдено 885 оголошень
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "bmw e46 e87",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 115
}
}
]
}
},
"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 · 1.13 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.url IN (?, ?, ?, ?) LIMIT 1 ["kiev","\/kiev","kiev\/","\/kiev\/"] · 0.71 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.39 msSHOW TABLES · 0.66 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) [193703219,218242723,214247841,216988282,215789579,219805950,168343033,168348514,171213508,195013202,203561132,201054727,188787249,185786922,215196030,217001455,194050370,185779557,169534690,216993178,172152487,190690953,211050048,217438495,197444573,216988348,216428764,191189556,185757726,216773089,172156570,219093071,206836359,174655372,197537099,197445530,209383210,213023370,211625784,169416067,208443685,206836194,188946174,218518943,216779506,172896274,198212017,197576444,211133700,197113261] · 90.13 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 [168343033,168348514,169416067,169534690,171213508,172152487,172156570,172896274,174655372,185757726,185779557,185786922,188787249,188946174,190690953,191189556,193703219,194050370,195013202,197113261,197444573,197445530,197537099,197576444,198212017,201054727,203561132,206836194,206836359,208443685,209383210,211050048,211133700,211625784,213023370,214247841,215196030,215789579,216428764,216773089,216779506,216988282,216988348,216993178,217001455,217438495,218242723,218518943,219093071,219805950] · 10.48 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.87 ms