Оголошення: Зарванцы — 4 466 оголошень — сторінка 87

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

SQL

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

["zarvancy","\/zarvancy","zarvancy\/","\/zarvancy\/"] · 0.75 ms

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

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

[171674722,171656023,171655750,171654007,171653989,171648844,171647182,171645811,171643012,171642565,171638497,171638341,171638164,171638047,171637912,171637363,171615250,171519325,171517378,171500362,171486199,171485545,171357721,171324877,171315787,171303979,171300256,171155590,171155368,171155260,171154765,171126523,171126499,171125941,171124429,171122671,171115906,171107491,171104929,170939017,170937967,170937628,170803978,170594035,170588305,170587096,170586859,170586586,170583514,170430874] · 44.39 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

[170430874,170583514,170586586,170586859,170587096,170588305,170594035,170803978,170937628,170937967,170939017,171104929,171107491,171115906,171122671,171124429,171125941,171126499,171126523,171154765,171155260,171155368,171155590,171300256,171303979,171315787,171324877,171357721,171485545,171486199,171500362,171517378,171519325,171615250,171637363,171637912,171638047,171638164,171638341,171638497,171642565,171643012,171645811,171647182,171648844,171653989,171654007,171655750,171656023,171674722] · 0.74 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.55 ms