Оголошення: Зашків — 159 оголошень — сторінка 3

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

SQL

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

["zashkov","\/zashkov","zashkov\/","\/zashkov\/"] · 2.1 ms

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

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

[195884747,195745031,195698210,195681590,195064361,194636885,193188754,193188016,191022444,191013267,190985049,190717533,190380246,190213263,189366588,189161076,188806056,188736600,188578308,188052186,187966308,187853760,187209789,186263235,186126756,186122030,184419477,184224987,183343704,183343210,183257754,182958540,182356300,181267543,181267525,181267516,181253575,180867643,180773206,180573640,180197590,178421729,178230534,178209474,177756904,177633178,175598292,175441503,175440783,174199603] · 42.1 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

[174199603,175440783,175441503,175598292,177633178,177756904,178209474,178230534,178421729,180197590,180573640,180773206,180867643,181253575,181267516,181267525,181267543,182356300,182958540,183257754,183343210,183343704,184224987,184419477,186122030,186126756,186263235,187209789,187853760,187966308,188052186,188578308,188736600,188806056,189161076,189366588,190213263,190380246,190717533,190985049,191013267,191022444,193188016,193188754,194636885,195064361,195681590,195698210,195745031,195884747] · 1.04 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.72 ms