Оголошення: Ланна — 93 оголошення

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

["lanna","\/lanna","lanna\/","\/lanna\/"] · 1.33 ms

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

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

[218758154,218302706,218002771,217797079,217761754,217610686,217515838,217128847,217032352,216898426,216662611,216577867,216270811,216233392,216132352,215472405,215115249,214886706,213229923,213122277,212217081,211965729,211126056,210811582,210806612,210499919,210297959,210108368,210012710,209837081,209085919,207961228,207841708,206961585,206825125,205800056,205798694,205296959,204987257,204802412,204598115,204432458,204372431,204372239,204372236,203555183,203147011,202688975,202244314,202170007] · 131.4 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

[202170007,202244314,202688975,203147011,203555183,204372236,204372239,204372431,204432458,204598115,204802412,204987257,205296959,205798694,205800056,206825125,206961585,207841708,207961228,209085919,209837081,210012710,210108368,210297959,210499919,210806612,210811582,211126056,211965729,212217081,213122277,213229923,214886706,215115249,215472405,216132352,216233392,216270811,216577867,216662611,216898426,217032352,217128847,217515838,217610686,217761754,217797079,218002771,218302706,218758154] · 193.39 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