Оголошення: Лучка — 51 оголошення

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

["luchka","\/luchka","luchka\/","\/luchka\/"] · 1.5 ms

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

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

[218967662,218743904,218717456,217959271,217027018,216470356,216253030,215703263,214978389,214978098,214977519,214977414,213942340,213940094,213940040,213940036,213939566,213939534,213939522,213939516,213939490,213939178,213555879,213155451,212598978,210890554,210708514,207215257,203222510,202994143,202981711,201861965,201187012,200987962,198808069,198559994,197725208,194714840,193635743,192522694,189134434,187101627,186401130,186355914,185738004,185218542,185016912,183979824,180607435,178175253] · 24.28 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

[178175253,180607435,183979824,185016912,185218542,185738004,186355914,186401130,187101627,189134434,192522694,193635743,194714840,197725208,198559994,198808069,200987962,201187012,201861965,202981711,202994143,203222510,207215257,210708514,210890554,212598978,213155451,213555879,213939178,213939490,213939516,213939522,213939534,213939566,213940036,213940040,213940094,213942340,214977414,214977519,214978098,214978389,215703263,216253030,216470356,217027018,217959271,218717456,218743904,218967662] · 3 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.14 ms