Оголошення: Сарни — 14 641 оголошення — сторінка 39

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

Elasticsearch

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

тіло запиту

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

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 17.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.url IN (?, ?, ?, ?) LIMIT 1

["sarny","\/sarny","sarny\/","\/sarny\/"] · 0.7 ms

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

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

[214826271,214825446,214819764,214818462,214818372,214815564,214814742,214814142,214805124,214803081,214801965,214800138,214799784,214796133,214795134,214787007,214783389,214779903,214779108,214778619,214764972,214761921,214759047,214758942,214752081,214750014,214734861,214742508,214729278,214727286,214737591,214737504,214736010,214717440,214734909,214732098,214732056,214725444,214725111,214725042,214724985,214712796,214711032,214710810,214708419,214705590,214705587,214705575,214705566,214705098] · 77.93 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

[214705098,214705566,214705575,214705587,214705590,214708419,214710810,214711032,214712796,214724985,214725042,214725111,214725444,214732056,214732098,214734909,214736010,214737504,214737591,214742508,214750014,214752081,214758942,214759047,214761921,214764972,214778619,214779108,214779903,214783389,214787007,214795134,214796133,214799784,214800138,214801965,214803081,214805124,214814142,214814742,214815564,214818372,214818462,214819764,214825446,214826271] · 16.9 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.99 ms