Оголошення: Вереси — 93 оголошення

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

["veresy","\/veresy","veresy\/","\/veresy\/"] · 0.9 ms

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

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

[219105899,218408741,218272288,218141275,218097865,218018434,217381447,217143202,216991441,216865423,216808657,216507094,215998357,215897305,215892178,215813869,215779247,215645514,215174013,214105254,213707283,213514962,213455493,213383253,213126021,212771946,212718399,212718366,211458846,211420245,211419144,211119063,211077824,210985788,210808620,210753314,210721846,210640540,210306695,209725895,209714186,209664242,209022109,208913005,208826131,208779760,208067245,207824563,207167002,205408559] · 284.48 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

[205408559,207167002,207824563,208067245,208779760,208826131,208913005,209022109,209664242,209714186,209725895,210306695,210640540,210721846,210753314,210808620,210985788,211077824,211119063,211419144,211420245,211458846,212718366,212718399,212771946,213126021,213383253,213455493,213514962,213707283,214105254,215174013,215645514,215779247,215813869,215892178,215897305,215998357,216507094,216808657,216865423,216991441,217143202,217381447,218018434,218097865,218141275,218272288,218408741,219105899] · 500.62 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.67 ms