Оголошення: Оконськ — 265 оголошень — сторінка 5

{
    "query": {
        "bool": {
            "filter": [
                {
                    "term": {
                        "city_id": 7135
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 200,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 7.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

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

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

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

[183824753,183458181,183360766,183345546,183337577,183306982,183296556,183250906,183015339,182734278,181669219,181557253,181091293,180772516,180764647,180415452,179872018,179798512,179649745,179224828,179095894,177254277,177111249,177096335,176427650,176143737,175722628,175636516,175423461,175376803,175143424,173854147,173773735,173773546,173623609,173124775,171777121,171713764,171256705,170817505,170710933,169845745,169844749,169844005,169657804,169651786,169498840,169479148,169477573,169396183] · 124.01 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

[169396183,169477573,169479148,169498840,169651786,169657804,169844005,169844749,169845745,170710933,170817505,171256705,171713764,171777121,173124775,173623609,173773546,173773735,173854147,175143424,175376803,175423461,175636516,175722628,176143737,176427650,177096335,177111249,177254277,179095894,179224828,179649745,179798512,179872018,180415452,180764647,180772516,181091293,181557253,181669219,182734278,183015339,183250906,183296556,183306982,183337577,183345546,183360766,183458181,183824753] · 0.93 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.06 ms