Оголошення: Бражники — 152 оголошення

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 6775
                    }
                }
            ]
        }
    },
    "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 · 1.3 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

["brajniki","\/brajniki","brajniki\/","\/brajniki\/"] · 1.51 ms

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

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

[218994602,218989535,218979386,218432948,218288422,218181718,218076091,217902226,217738924,217696120,217242553,217111633,217021576,216828742,216695980,216403789,216131902,216072679,216060451,215669375,215636208,215631969,215071191,215067942,214766985,214585854,214450944,214393941,214339311,214059220,213924960,213829731,213662727,212781477,212534913,212308524,211867401,211666611,211612110,211461636,210953378,210878870,210878858,210878854,210865192,210850176,210791464,210739006,210691154,210305633] · 26.12 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

[210305633,210691154,210739006,210791464,210850176,210865192,210878854,210878858,210878870,210953378,211461636,211612110,211666611,211867401,212308524,212534913,212781477,213662727,213829731,213924960,214059220,214339311,214393941,214450944,214585854,214766985,215067942,215071191,215631969,215636208,215669375,216060451,216072679,216131902,216403789,216695980,216828742,217021576,217111633,217242553,217696120,217738924,217902226,218076091,218181718,218288422,218432948,218979386,218989535,218994602] · 11.92 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.97 ms