Оголошення: Хуст — 11 880 оголошень — сторінка 94

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

SQL

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

["hust","\/hust","hust\/","\/hust\/"] · 2.15 ms

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

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

[204828731,204828269,204824603,204823691,204823628,204823619,204823568,204823550,204820370,204804806,204804617,204794270,204792191,204790088,204790085,204788333,204781607,204774752,204774305,204773759,204767786,204767771,204767750,204766130,204753872,204752171,204738530,204738095,204733781,204733055,204729500,204721070,204719444,204719288,204719204,204710024,204701657,204701453,204700736,204699023,204698162,204682760,204681536,204677414,204676892,204674969,204653999,204651161,204645650,204635714] · 21.37 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

[204635714,204645650,204651161,204653999,204674969,204676892,204677414,204681536,204682760,204698162,204699023,204700736,204701453,204701657,204710024,204719204,204719288,204719444,204721070,204729500,204733055,204733781,204738095,204738530,204752171,204753872,204766130,204767750,204767771,204767786,204773759,204774305,204774752,204781607,204788333,204790085,204790088,204792191,204794270,204804617,204804806,204820370,204823550,204823568,204823619,204823628,204823691,204824603,204828269,204828731] · 1.23 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.66 ms