Оголошення: Краматорськ — 19 865 оголошень — сторінка 6

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

Elasticsearch

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

тіло запиту

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

SQL

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

["kramatorsk","\/kramatorsk","kramatorsk\/","\/kramatorsk\/"] · 0.39 ms

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

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

[218396240,218394989,218394776,218392799,218390480,218385053,218384354,218381600,218379686,218378246,218377010,218375606,218354462,218366039,218364398,218359772,218346074,218344766,218343968,218341373,218340581,218332832,218329643,218326163,218324126,218316986,218300555,218312762,218312690,218311895,218309600,218301080,218294277,218290167,218287966,218284105,218284033,218280520,218279959,218273227,218271640,218270485,218268460,218268154,218266903,218262883,218248264,218247766,218247691,218244976] · 31.7 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

[218244976,218247691,218247766,218248264,218262883,218266903,218268154,218268460,218270485,218271640,218273227,218279959,218280520,218284033,218284105,218287966,218290167,218294277,218301080,218309600,218311895,218312690,218312762,218316986,218324126,218326163,218329643,218332832,218340581,218341373,218343968,218344766,218346074,218359772,218364398,218366039,218375606,218377010,218378246,218379686,218381600,218384354,218385053,218390480,218392799,218394776,218394989,218396240] · 68.81 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.53 ms