10 android auto, Луцьк — 72 оголошення

{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "10 android auto",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 124
                    }
                }
            ]
        }
    },
    "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
            }
        }
    }
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 1.59 ms

SELECT 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

["luck","\/luck","luck\/","\/luck\/"] · 0.49 ms

SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.59 ms

SHOW TABLES · 1.99 ms

SELECT 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)

[198038043,205559609,175695430,196605727,198037733,173313148,171737518,213173226,214404753,214404747,214404741,214404735,203098642,214556229,209677136,186065844,217347898,199217938,209469013,174780517,175702072,174316591,217980115,217659100,198357818,170765755,208473877,203449829,175890354,174780520,169279066,212120859,179186875,202522135,194707964,184735885,179677975,177460523,172095139,184235568,205677224,199082965,198426932,198217353,188073024,177551167,171937798,179305117,175887048,184470534] · 38.73 ms

SELECT 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

[169279066,170765755,171737518,171937798,172095139,173313148,174316591,174780517,174780520,175695430,175702072,175887048,175890354,177460523,177551167,179186875,179305117,179677975,184235568,184470534,184735885,186065844,188073024,194707964,196605727,198037733,198038043,198217353,198357818,198426932,199082965,199217938,202522135,203098642,203449829,205559609,205677224,208473877,209469013,209677136,212120859,213173226,214404735,214404741,214404747,214404753,214556229,217347898,217659100,217980115] · 4.33 ms

SELECT 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.75 ms