Оголошення: Тойкут — 50 оголошень

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

["toykut","\/toykut","toykut\/","\/toykut\/"] · 1.06 ms

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

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

[217618468,217141096,215815183,215202816,214923306,214236603,211693722,210736516,208460329,207554005,205421381,202573419,202448696,202346065,200280913,194490356,193738136,192944842,189157701,185529123,184955199,181728082,181257340,177122233,174350335,173117941,173117887,172768996,172035016,171306763,170973163,170754067,170245693,170193376,170103805,169784998,169784956,169653151,169566889,169566850,169496356,169093948,169093864,169093669,169093636,168616573,168596020,168429499,168398365,168191533] · 31.87 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

[168191533,168398365,168429499,168596020,168616573,169093636,169093669,169093864,169093948,169496356,169566850,169566889,169653151,169784956,169784998,170103805,170193376,170245693,170754067,170973163,171306763,172035016,172768996,173117887,173117941,174350335,177122233,181257340,181728082,184955199,185529123,189157701,192944842,193738136,194490356,200280913,202346065,202448696,202573419,205421381,207554005,208460329,210736516,211693722,214236603,214923306,215202816,215815183,217141096,217618468] · 3.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.parent_id = ? LIMIT 3000

[5] · 1.72 ms