Оголошення: Новий Розділ — 2 677 оголошень

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

SQL

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

["novyy-rozdol","\/novyy-rozdol","novyy-rozdol\/","\/novyy-rozdol\/"] · 1.18 ms

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

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

[219468805,219460930,219425803,219422338,219417235,219353440,219353425,219351160,219332896,219332677,219327829,219321847,219204140,219195284,219190061,219181667,219176642,219168566,219167945,219162581,219158129,219155903,219155846,219154268,219150686,219121154,219113627,219109355,219104327,219099041,219069350,219067727,219058235,219052604,219051902,219050177,219034928,219020696,219013376,219008720,219002453,218993711,218990912,218990867,218990126,218986997,218977130,218950529,218950004,218900117] · 2.62 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

[218900117,218950004,218950529,218977130,218986997,218990126,218990867,218990912,218993711,219002453,219008720,219013376,219020696,219034928,219050177,219051902,219052604,219058235,219067727,219069350,219099041,219104327,219109355,219113627,219121154,219150686,219154268,219155846,219155903,219158129,219162581,219167945,219168566,219176642,219181667,219190061,219195284,219204140,219321847,219327829,219332677,219332896,219351160,219353425,219353440,219417235,219422338,219425803,219460930,219468805] · 5.37 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] · 1.19 ms