Iphone 8 plus — 964 оголошення

{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "iphone 8 plus",
                        "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
            }
        }
    }
}

SQL

SHOW TABLES · 1.39 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)

[209987684,207979852,200547166,197413478,194869067,190950099,189795972,206898931,205306844,205240118,204172350,203206049,201624561,200976751,200497843,197992066,196662310,194963570,190950270,188300610,216778411,208502140,209216500,205720103,204418241,203637642,201938915,201321496,199381438,197515112,197413547,197068381,195234062,192251014,191669032,183159291,181322071,178737646,204589655,189385272,216218650,212345829,208945492,205171808,204499766,201537551,195136082,193992047,186952833,179367910] · 31.49 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

[178737646,179367910,181322071,183159291,186952833,188300610,189385272,189795972,190950099,190950270,191669032,192251014,193992047,194869067,194963570,195136082,195234062,196662310,197068381,197413478,197413547,197515112,197992066,199381438,200497843,200547166,200976751,201321496,201537551,201624561,201938915,203206049,203637642,204172350,204418241,204499766,204589655,205171808,205240118,205306844,205720103,206898931,207979852,208502140,208945492,209216500,209987684,212345829,216218650,216778411] · 2.47 ms

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

SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.68 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.5 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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

[115,125,119,127,135,2485,124,117,122,133,121,139,129,137,116,120,2222,132,138,3082,3535,126,2101,2165,2217,3449,6334,128,140,2148] · 0.59 ms