Оголошення: Задністрянське — 108 оголошень

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

["zadnestryanskoe","\/zadnestryanskoe","zadnestryanskoe\/","\/zadnestryanskoe\/"] · 1.1 ms

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

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

[219293491,218849282,218520191,218330210,217788337,216971128,216485551,216485353,216484240,216473770,216219166,216191368,215691413,215631132,215347086,215345868,215052267,214955628,214385112,214326282,213930424,213608163,213447576,213339681,212990367,212626350,211930518,211883907,211485159,211304961,210969680,210748264,210688258,210614918,210541145,210540353,210536042,209994656,209197768,209062675,208780672,208703590,208703512,208629103,208478194,207823582,207198583,207198442,206854108,206843995] · 24.89 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

[206843995,206854108,207198442,207198583,207823582,208478194,208629103,208703512,208703590,208780672,209062675,209197768,209994656,210536042,210540353,210541145,210614918,210688258,210748264,210969680,211304961,211485159,211883907,211930518,212626350,212990367,213339681,213447576,213608163,213930424,214326282,214385112,214955628,215052267,215345868,215347086,215631132,215691413,216191368,216219166,216473770,216484240,216485353,216485551,216971128,217788337,218330210,218520191,218849282,219293491] · 9.05 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] · 2.06 ms