Оголошення: Сарни — 14 609 оголошень — сторінка 87

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

SQL

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

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

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

[208625155,208623481,208621696,208620250,208615744,208611400,208608319,208607407,208607125,208605328,208597438,208596553,208593766,208593076,208591603,208591441,208590976,208583482,208582174,208576630,208576006,208569886,208561552,208560109,208558384,208543630,208542928,208532107,208524610,208523515,208519705,208518616,208515631,208515061,208514314,208512622,208501024,208497673,208496167,208494076,208477060,208471090,208465288,208462180,208458022,208457176,208449964,208449439,208448743,208443265] · 31.04 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

[208443265,208448743,208449439,208449964,208457176,208458022,208462180,208465288,208471090,208477060,208494076,208496167,208497673,208501024,208512622,208514314,208515061,208515631,208518616,208519705,208523515,208524610,208532107,208542928,208543630,208558384,208560109,208561552,208569886,208576006,208576630,208582174,208583482,208590976,208591441,208591603,208593076,208593766,208596553,208597438,208605328,208607125,208607407,208608319,208611400,208615744,208620250,208621696,208623481,208625155] · 25.77 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.95 ms