Оголошення: Стрий — 29 124 оголошення — сторінка 101

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 2183
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 5000,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 1.64 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

["stryy","\/stryy","stryy\/","\/stryy\/"] · 1.11 ms

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

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

[212352369,212351151,212350938,212345877,212344005,212343012,212342937,212342928,212342742,212342637,212342241,212342139,212341017,212340990,212340261,212340201,212340189,212340003,212339979,212339628,212338650,212338632,212338422,212337156,212337036,212336796,212336250,212335584,212335533,212334936,212334798,212334339,212333664,212330670,212330409,212329362,212329188,212329131,212323407,212322435,212319294,212318895,212316366,212315427,212309895,212309877,212309397,212308497,212308017,212305497] · 29.65 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

[212305497,212308017,212308497,212309397,212309877,212309895,212315427,212316366,212318895,212319294,212322435,212323407,212329131,212329188,212329362,212330409,212330670,212333664,212334339,212334798,212334936,212335533,212335584,212336250,212336796,212337036,212337156,212338422,212338632,212338650,212339628,212339979,212340003,212340189,212340201,212340261,212340990,212341017,212342139,212342241,212342637,212342742,212342928,212342937,212343012,212344005,212345877,212350938,212351151,212352369] · 20.73 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.63 ms