Оголошення: Гайове — 69 оголошень

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

["gaevoe","\/gaevoe","gaevoe\/","\/gaevoe\/"] · 1.83 ms

SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.85 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)

[219085751,218867804,218666336,217778494,217391839,217020226,216239050,216207517,216118756,215728331,215204931,214872028,214781436,214620303,214148326,214034812,213724722,213349491,213302589,213205788,213169731,213016497,212272890,211642473,211622295,211566744,210762246,210736946,210505322,209603170,207645061,207328285,207193201,207029077,206870351,206865309,206021117,205634735,204803162,204386834,203855796,202988149,202826128,202109443,201764315,201743551,201713833,201493335,201373069,200055367] · 100.43 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

[200055367,201373069,201493335,201713833,201743551,201764315,202109443,202826128,202988149,203855796,204386834,204803162,205634735,206021117,206865309,206870351,207029077,207193201,207328285,207645061,209603170,210505322,210736946,210762246,211566744,211622295,211642473,212272890,213016497,213169731,213205788,213302589,213349491,213724722,214034812,214148326,214620303,214781436,214872028,215204931,215728331,216118756,216207517,216239050,217020226,217391839,217778494,218666336,218867804,219085751] · 40.18 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.61 ms