Оголошення: Дубно — 20 949 оголошень — сторінка 37

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

SQL

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

["dubno","\/dubno","dubno\/","\/dubno\/"] · 0.99 ms

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

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

[215471718,215470656,215470284,215465127,215463480,215462649,215458860,215458005,215457432,215457147,215454483,215453745,215453571,215453334,215452527,215447166,215444019,215442480,215441013,215438472,215434206,215434002,215432205,215427705,215425008,215424220,215419170,215417826,215405916,215405108,215405098,215405092,215383916,215380296,215379642,215379314,215372079,215371917,215371914,215371908,215367861,215366016,215365617,215363184,215357409,215356353,215355207,215340210,215338810,215337364] · 21.35 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

[215337364,215338810,215340210,215355207,215356353,215357409,215363184,215365617,215366016,215367861,215371908,215371914,215371917,215372079,215379314,215379642,215380296,215383916,215405092,215405098,215405108,215405916,215417826,215419170,215424220,215425008,215427705,215432205,215434002,215434206,215438472,215441013,215442480,215444019,215447166,215452527,215453334,215453571,215453745,215454483,215457147,215457432,215458005,215458860,215462649,215463480,215465127,215470284,215470656,215471718] · 7.72 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.73 ms