Оголошення: Малин — 4 305 оголошень — сторінка 50

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

SQL

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

["malin","\/malin","malin\/","\/malin\/"] · 0.34 ms

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

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

[199123798,199122868,199121530,199101082,199083979,199081054,199074910,199068328,199066873,199063645,199057462,199053955,199044937,198981403,198981313,198981211,198925963,198924151,198915319,198913666,198907732,198890692,198871279,198829201,198813844,198809500,198802051,198777205,198777097,198777031,198772885,198771289,198764677,198740341,198734047,198715168,198704839,198675883,198661444,198650218,198637875,198627109,198623561,198619769,198610172,198607388,198591960,198589020,198588868,198588588] · 76.95 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

[198588588,198588868,198589020,198591960,198607388,198610172,198619769,198623561,198627109,198637875,198650218,198661444,198675883,198704839,198715168,198734047,198740341,198764677,198771289,198772885,198777031,198777097,198777205,198802051,198809500,198813844,198829201,198871279,198890692,198907732,198913666,198915319,198924151,198925963,198981211,198981313,198981403,199044937,199053955,199057462,199063645,199066873,199068328,199074910,199081054,199083979,199101082,199121530,199122868,199123798] · 3.94 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.52 ms