Оголошення: Чмирівка — 60 оголошень

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 7628
                    }
                }
            ]
        }
    },
    "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 · 1.38 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

["chmyrevka","\/chmyrevka","chmyrevka\/","\/chmyrevka\/"] · 0.94 ms

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

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

[218908607,218758238,218726348,218364485,218285155,218255575,217623406,217617088,217375699,217348129,217212832,217102366,217082449,216566107,216277993,216227485,215814959,215667533,215666024,215592105,215518332,215507151,214618743,214152046,213963016,213914894,213878794,213275016,212851479,211850373,211336764,210599459,210495914,210299405,209745572,208744819,208325980,206109968,205835897,205523291,203096413,200401852,198034822,197245709,197172859,196699681,195832637,195448430,194245787,193598642] · 25.83 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

[193598642,194245787,195448430,195832637,196699681,197172859,197245709,198034822,200401852,203096413,205523291,205835897,206109968,208325980,208744819,209745572,210299405,210495914,210599459,211336764,211850373,212851479,213275016,213878794,213914894,213963016,214152046,214618743,215507151,215518332,215592105,215666024,215667533,215814959,216227485,216277993,216566107,217082449,217102366,217212832,217348129,217375699,217617088,217623406,218255575,218285155,218364485,218726348,218758238,218908607] · 14.44 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.96 ms