Оголошення: Суми — 87 203 оголошення — сторінка 183

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

SQL

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

["sumy","\/sumy","sumy\/","\/sumy\/"] · 1.29 ms

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

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

[216466393,216466309,216466258,216465847,216465796,216465553,216465130,216465100,216465085,216464536,216464326,216463582,216463531,216463270,216462979,216462034,216461893,216461875,216461740,216461512,216461419,216460159,216460003,216459610,216459454,216459223,216458506,216458203,216458191,216458188,216458152,216458107,216457441,216456157,216456118,216455929,216455923,216455881,216455695,216455638,216455209,216455200,216455134,216454789,216454372,216453496,216452743,216452686,216451945,216451180] · 29.5 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

[216451180,216451945,216452686,216452743,216453496,216454372,216454789,216455134,216455200,216455209,216455638,216455695,216455881,216455923,216455929,216456118,216456157,216457441,216458107,216458152,216458188,216458191,216458203,216458506,216459223,216459454,216459610,216460003,216460159,216461419,216461512,216461740,216461875,216461893,216462034,216462979,216463270,216463531,216463582,216464326,216464536,216465085,216465100,216465130,216465553,216465796,216465847,216466258,216466309,216466393] · 8.98 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.67 ms