Объявления: Калиновка — 7 666 объявлений

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

SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1

["kalinovka","\/kalinovka","kalinovka\/","\/kalinovka\/"] · 0.78 ms

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

SHOW TABLES · 2.69 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, ''), NULLIF(c.name_ua, '')) 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)

[219415237,219377326,219374683,219367600,219367570,219367537,219367420,219367384,219366400,219366388,219362860,219362266,219362215,219361840,219360571,219355876,219355381,219355150,219354013,219346213,219345850,219335905,219333001,219313540,219311206,219310582,219308434,219307042,219306163,219306052,219305935,219305782,219305773,219305710,219303400,219302239,219300568,219299704,219298414,219294412,219290410,219290392,219281623,219281530,219281476,219228592,219226585,219222451,219218224,219213329] · 9.67 ms

SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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

[219213329,219218224,219222451,219226585,219228592,219281476,219281530,219281623,219290392,219290410,219294412,219298414,219299704,219300568,219302239,219303400,219305710,219305773,219305782,219305935,219306052,219306163,219307042,219308434,219310582,219311206,219313540,219333001,219335905,219345850,219346213,219354013,219355150,219355381,219355876,219360571,219361840,219362215,219362266,219362860,219366388,219366400,219367384,219367420,219367537,219367570,219367600,219374683,219377326,219415237] · 3.57 ms

SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000

[5] · 1.42 ms