Оголошення: Реваківці — 837 оголошень

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

["revakovcy","\/revakovcy","revakovcy\/","\/revakovcy\/"] · 0.7 ms

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

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

[219187589,219161843,219152003,219123761,219123752,219123728,219123656,219102026,219101798,219101768,219101546,219101519,219100418,219042845,219015488,219015476,219015470,219015467,219015449,218966591,218937029,218924993,218901770,218901260,218704592,218657333,218640557,218566997,218565512,218561003,218526542,218526476,218282170,218279446,218101756,218094124,218093980,218092777,218054179,218053225,218053216,218053192,218053171,218052880,217989760,217863112,217844320,217844263,217844092,217844089] · 63.7 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

[217844089,217844092,217844263,217844320,217863112,217989760,218052880,218053171,218053192,218053216,218053225,218054179,218092777,218093980,218094124,218101756,218279446,218282170,218526476,218526542,218561003,218565512,218566997,218640557,218657333,218704592,218901260,218901770,218924993,218937029,218966591,219015449,219015467,219015470,219015476,219015488,219042845,219100418,219101519,219101546,219101768,219101798,219102026,219123656,219123728,219123752,219123761,219152003,219161843,219187589] · 7.93 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.64 ms