Оголошення: Некрасово — 55 оголошень

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

["nekrasovo","\/nekrasovo","nekrasovo\/","\/nekrasovo\/"] · 1.17 ms

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

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

[214619874,214246497,211627245,211006496,210173279,201970597,201969844,182098645,180466014,180451494,180451476,180450918,180380995,180142777,180142531,180142396,180142297,180138742,179960887,179896969,179883061,179725263,179725259,179725021,179397586,179121067,179118811,179117983,179116798,179110531,179110063,178912759,178582012,177749431,177013281,176828842,176753977,176673492,175946553,175824015,175436025,175140994,174599242,174306670,173632714,173532976,173422126,173417182,172630681,171933376] · 55.57 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

[171933376,172630681,173417182,173422126,173532976,173632714,174306670,174599242,175140994,175436025,175824015,175946553,176673492,176753977,176828842,177013281,177749431,178582012,178912759,179110063,179110531,179116798,179117983,179118811,179121067,179397586,179725021,179725259,179725263,179883061,179896969,179960887,180138742,180142297,180142396,180142531,180142777,180380995,180450918,180451476,180451494,180466014,182098645,201969844,201970597,210173279,211006496,211627245,214246497,214619874] · 11.27 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.85 ms