Оголошення: Мамрін — 123 оголошення

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

["mamrin","\/mamrin","mamrin\/","\/mamrin\/"] · 8.07 ms

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

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

[218930837,218791706,218791568,218667503,218523923,217702459,217577383,216848353,216770494,216690277,216531280,216311062,216124549,215838808,215780585,215675612,215563056,215555556,215549352,215533611,215290896,215111187,214971687,214843638,214784190,214439376,213806493,213806340,213671223,213629481,213322497,213184941,212768046,212586897,212022777,211939347,211608861,210707770,210703898,209883359,209883059,209582194,209201548,209178523,208472500,208414801,208413952,207546199,207115579,207105160] · 100.81 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

[207105160,207115579,207546199,208413952,208414801,208472500,209178523,209201548,209582194,209883059,209883359,210703898,210707770,211608861,211939347,212022777,212586897,212768046,213184941,213322497,213629481,213671223,213806340,213806493,214439376,214784190,214843638,214971687,215111187,215290896,215533611,215549352,215555556,215563056,215675612,215780585,215838808,216124549,216311062,216531280,216690277,216770494,216848353,217577383,217702459,218523923,218667503,218791568,218791706,218930837] · 38.41 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.96 ms