Оголошення: Дроговиж — 244 оголошення

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

["drogovij","\/drogovij","drogovij\/","\/drogovij\/"] · 1.68 ms

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

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

[219166547,219142985,219140588,219088289,218814521,218795813,218701643,218128021,217966807,217791226,217390732,217218349,217087780,216958534,216915913,216871651,216854854,216702997,216452644,216239236,216187465,216063799,215769632,215769521,215769143,215768633,215732096,215349610,214584018,214436382,214118616,214116644,214052392,214031310,213433524,213126054,213078714,212839575,212769483,212568549,212433177,211994961,211570734,210987476,210397844,210263003,209685128,209685101,209685062,209684915] · 21.97 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

[209684915,209685062,209685101,209685128,210263003,210397844,210987476,211570734,211994961,212433177,212568549,212769483,212839575,213078714,213126054,213433524,214031310,214052392,214116644,214118616,214436382,214584018,215349610,215732096,215768633,215769143,215769521,215769632,216063799,216187465,216239236,216452644,216702997,216854854,216871651,216915913,216958534,217087780,217218349,217390732,217791226,217966807,218128021,218701643,218795813,218814521,219088289,219140588,219142985,219166547] · 26.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.parent_id = ? LIMIT 3000

[5] · 0.72 ms