Оголошення: Десна — 1 675 оголошень — сторінка 13

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

SQL

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

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

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

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

[211063272,211047010,211045556,211045478,210995148,210966328,210930796,210917848,210897612,210888000,210874852,210860016,210854146,210826948,210826790,210807376,210789144,210761038,210760240,210736954,210736950,210686150,210645022,210628950,210615768,210615098,210582485,210578159,210566711,210562865,210562823,210562667,210562652,210562061,210545693,210533621,210521096,210462089,210446888,210401240,210388619,210377036,210320738,210300461,210274370,210274217,210218276,210155603,210152645,210151247] · 265.66 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

[210151247,210152645,210155603,210218276,210274217,210274370,210300461,210320738,210377036,210388619,210401240,210446888,210462089,210521096,210533621,210545693,210562061,210562652,210562667,210562823,210562865,210566711,210578159,210582485,210615098,210615768,210628950,210645022,210686150,210736950,210736954,210760240,210761038,210789144,210807376,210826790,210826948,210854146,210860016,210874852,210888000,210897612,210917848,210930796,210966328,210995148,211045478,211045556,211047010,211063272] · 15.87 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] · 10.16 ms