Оголошення: Евминка — 51 оголошення

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 6943
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 12.48 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

["evminka","\/evminka","evminka\/","\/evminka\/"] · 0.95 ms

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

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

[219139280,218482835,217607164,217588360,217112017,217013545,216790425,216556393,216349627,216312037,216032704,215622648,215359068,215309241,215175933,214289313,214033210,212157921,212107830,211432662,211236483,210470522,208583113,207638650,207265960,207150895,207055999,207006471,206003507,205581809,205069808,205042511,204320271,203707673,202173532,196289456,196204628,196019402,190952403,188934144,186824616,186456393,185664807,184605955,182291101,181818790,177157513,176459353,175297267,174093814] · 268.93 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

[174093814,175297267,176459353,177157513,181818790,182291101,184605955,185664807,186456393,186824616,188934144,190952403,196019402,196204628,196289456,202173532,203707673,204320271,205042511,205069808,205581809,206003507,207006471,207055999,207150895,207265960,207638650,208583113,210470522,211236483,211432662,212107830,212157921,214033210,214289313,215175933,215309241,215359068,215622648,216032704,216312037,216349627,216556393,216790425,217013545,217112017,217588360,217607164,218482835,219139280] · 110.25 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] · 1.36 ms