Оголошення: Бышев — 108 оголошень — сторінка 2

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

SQL

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

["byshev","\/byshev","byshev\/","\/byshev\/"] · 0.79 ms

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

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

[208158802,207964741,207933418,207679063,207679048,207679039,207679015,207679006,207678994,207578320,207507379,207391435,207239218,206837295,206834367,206116490,205869464,205801886,205323536,204629051,204608720,204557633,203735504,203734628,203007721,202972459,202876123,202875751,202433757,201800291,200641621,199701499,199352788,199284997,199272016,199271863,198344548,198292673,197989627,197979682,197666528,197282264,196757693,196589517,194933930,194925170,191594938,190527042,189392223,187781853] · 34.64 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

[187781853,189392223,190527042,191594938,194925170,194933930,196589517,196757693,197282264,197666528,197979682,197989627,198292673,198344548,199271863,199272016,199284997,199352788,199701499,200641621,201800291,202433757,202875751,202876123,202972459,203007721,203734628,203735504,204557633,204608720,204629051,205323536,205801886,205869464,206116490,206834367,206837295,207239218,207391435,207507379,207578320,207678994,207679006,207679015,207679039,207679048,207679063,207933418,207964741,208158802] · 12.62 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.91 ms