Оголошення: Павлоград — 27 906 оголошень — сторінка 191

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

SQL

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

["pavlograd","\/pavlograd","pavlograd\/","\/pavlograd\/"] · 1.48 ms

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

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

[210850106,210849212,210847568,210846418,210846354,210846336,210846218,210843574,210842928,210841896,210841724,210840554,210839914,210839420,210838026,210837388,210837222,210837210,210836780,210835994,210835914,210833750,210833620,210833450,210831134,210829934,210827402,210823934,210822942,210821268,210820726,210820716,210820704,210820692,210820688,210820686,210819758,210819510,210819302,210819250,210818606,210818600,210818132,210817998,210813378,210811720,210811226,210805468,210804966,210804560] · 32.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

[210804560,210804966,210805468,210811226,210811720,210813378,210817998,210818132,210818600,210818606,210819250,210819302,210819510,210819758,210820686,210820688,210820692,210820704,210820716,210820726,210821268,210822942,210823934,210827402,210829934,210831134,210833450,210833620,210833750,210835914,210835994,210836780,210837210,210837222,210837388,210838026,210839420,210839914,210840554,210841724,210841896,210842928,210843574,210846218,210846336,210846354,210846418,210847568,210849212,210850106] · 16.79 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