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

Маршрут: категорія —, місто city #3067 · ES: всього 4305, id на сторінці: 50 · знайдено в БД: 49 ← не знайдено в БД (немає в posts, status ≠ active або помилка SQL): 212118552

Elasticsearch

POST /abyhomcom/_search → 200 · 87.1 ms · знайдено 4305, повернуто 50

тіло запиту

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

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 45.32 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\/"] · 22.78 ms

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

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

[212582475,212580738,212575770,212569926,212568846,212564169,212561523,212561502,212548935,212540361,212537148,212532015,212517405,212483871,212482581,212482572,212479086,212448843,212430747,212405802,212400546,212398590,212383020,212379699,212376303,212376291,212365008,212352309,212320851,212314053,212303529,212292969,212292411,212287782,212249394,212239206,212236011,212224359,212218740,212214741,212205810,212200311,212163168,212158566,212153031,212151402,212148147,212118552,212135205,212134053] · 96.73 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

[212134053,212135205,212148147,212151402,212153031,212158566,212163168,212200311,212205810,212214741,212218740,212224359,212236011,212239206,212249394,212287782,212292411,212292969,212303529,212314053,212320851,212352309,212365008,212376291,212376303,212379699,212383020,212398590,212400546,212405802,212430747,212448843,212479086,212482572,212482581,212483871,212517405,212532015,212537148,212540361,212548935,212561502,212561523,212564169,212568846,212569926,212575770,212580738,212582475] · 37.59 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] · 2.74 ms