170 ₴
Автосканер OBD2 ELM327 Bluetooth
170.0
Миргород
Знайдено 182 оголошення
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "bluetooth",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"term": {
"city_id": 2485
}
}
]
}
},
"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.24 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 ["mirgorod","\/mirgorod","mirgorod\/","\/mirgorod\/"] · 0.53 msSELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.31 msSHOW TABLES · 0.67 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) [218292269,214518462,202726375,204812213,203435018,200059492,209434537,208634206,195485216,193603433,214333512,214257183,208634152,201628079,214736745,210356285,207993082,206993515,206082260,189483057,214448565,214257501,213438429,210854056,207076315,206841356,205176983,202475689,201672453,197220983,191302219,207532798,219746102,216936856,215441103,215202522,214393287,209236648,208854091,206910225,200558596,200203987,199486465,197806809,196740143,196330238,188391027,187051941,183253759,183253736] · 45.7 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 [183253736,183253759,187051941,188391027,189483057,191302219,193603433,195485216,196330238,196740143,197220983,197806809,199486465,200059492,200203987,200558596,201628079,201672453,202475689,202726375,203435018,204812213,205176983,206082260,206841356,206910225,206993515,207076315,207532798,207993082,208634152,208634206,208854091,209236648,209434537,210356285,210854056,213438429,214257183,214257501,214333512,214393287,214448565,214518462,214736745,215202522,215441103,216936856,218292269,219746102] · 3.78 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] · 1.12 ms