Оголошення: Буськ — 3 029 оголошень — сторінка 44

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

SQL

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

["busk","\/busk","busk\/","\/busk\/"] · 0.51 ms

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

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

[188176311,188173314,188120736,188100876,188100108,188040870,188040867,187992345,187990692,187980474,187980462,187944951,187944207,187941132,187867893,187855497,187854024,187808763,187804944,187803108,187771116,187762293,187743669,187730892,187659285,187649532,187637109,187624410,187609509,187562181,187558032,187537662,187516698,187494492,187478115,187471755,187463877,187450584,187439664,187338136,187327899,187201779,187201674,187200735,187199733,187185771,187172484,187159587,187126647,187116753] · 695.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

[187116753,187126647,187159587,187172484,187185771,187199733,187200735,187201674,187201779,187327899,187338136,187439664,187450584,187463877,187471755,187478115,187494492,187516698,187537662,187558032,187562181,187609509,187624410,187637109,187649532,187659285,187730892,187743669,187762293,187771116,187803108,187804944,187808763,187854024,187855497,187867893,187941132,187944207,187944951,187980462,187980474,187990692,187992345,188040867,188040870,188100108,188100876,188120736,188173314,188176311] · 2.01 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] · 13.11 ms