Оголошення: Росава — 97 оголошень

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 7382
                    }
                }
            ]
        }
    },
    "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.09 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

["rosava","\/rosava","rosava\/","\/rosava\/"] · 0.92 ms

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

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

[218904338,217888618,217720318,217531507,216828574,216763138,216601081,216522160,215986537,215864830,215205594,215040072,215022093,214451820,214421547,214416012,214373520,214146208,213623220,212988345,212986494,212582130,212515974,212156910,212107608,211938834,211487727,211119444,210804228,210772758,210736478,210547268,210130022,208319584,208305268,207608674,207488875,207230077,205567025,205457327,205297559,204988724,204802646,204434849,203954571,203636652,202771453,202572909,201970087,201804691] · 77.83 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

[201804691,201970087,202572909,202771453,203636652,203954571,204434849,204802646,204988724,205297559,205457327,205567025,207230077,207488875,207608674,208305268,208319584,210130022,210547268,210736478,210772758,210804228,211119444,211487727,211938834,212107608,212156910,212515974,212582130,212986494,212988345,213623220,214146208,214373520,214416012,214421547,214451820,215022093,215040072,215205594,215864830,215986537,216522160,216601081,216763138,216828574,217531507,217720318,217888618,218904338] · 19.91 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.96 ms