Оголошення: Глибочок — 98 оголошень

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 7404
                    }
                }
            ]
        }
    },
    "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.85 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

["glubochek","\/glubochek","glubochek\/","\/glubochek\/"] · 1.43 ms

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

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

[219090353,218748539,218701523,218463125,218367662,218177839,217796932,217623424,217619782,217299484,216721237,216389926,216317209,216204268,216077800,215907112,215675951,215538330,215534115,215508429,215119449,214570086,214436064,214316262,214173278,213914062,213504336,212987049,212912211,212784147,212575410,212410863,212263173,211983993,211664307,211563492,211557183,211524249,211001904,210393281,210358394,210358382,210221495,209815337,209440654,209440168,209355280,209061955,209054686,208806643] · 19.79 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

[208806643,209054686,209061955,209355280,209440168,209440654,209815337,210221495,210358382,210358394,210393281,211001904,211524249,211557183,211563492,211664307,211983993,212263173,212410863,212575410,212784147,212912211,212987049,213504336,213914062,214173278,214316262,214436064,214570086,215119449,215508429,215534115,215538330,215675951,215907112,216077800,216204268,216317209,216389926,216721237,217299484,217619782,217623424,217796932,218177839,218367662,218463125,218701523,218748539,219090353] · 25.04 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.2 ms