Оголошення: Миргород — 10 371 оголошення — сторінка 85

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

SQL

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

["mirgorod","\/mirgorod","mirgorod\/","\/mirgorod\/"] · 5.1 ms

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

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

[206003090,205983014,205982144,205978874,205970858,205966700,205964057,205957655,205955906,205952654,205949975,205947596,205945856,205944941,205944896,205941506,205937327,205936466,205936292,205930025,205926284,205919105,205916969,205902290,205901591,205894538,205890965,205890836,205884545,205881326,205880987,205880351,205877231,205866104,205865240,205864541,205864124,205862174,205858859,205858004,205855760,205850210,205850132,205834454,205834316,205833311,205831085,205824170,205823681,205823327] · 88.55 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

[205823327,205823681,205824170,205831085,205833311,205834316,205834454,205850132,205850210,205855760,205858004,205858859,205862174,205864124,205864541,205865240,205866104,205877231,205880351,205880987,205881326,205884545,205890836,205890965,205894538,205901591,205902290,205916969,205919105,205926284,205930025,205936292,205936466,205937327,205941506,205944896,205944941,205945856,205947596,205949975,205952654,205955906,205957655,205964057,205966700,205970858,205978874,205982144,205983014,206003090] · 1.09 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] · 0.85 ms