Open box iphone, Чернівці

{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "open box iphone",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 139
                    }
                }
            ]
        }
    },
    "sort": [
        "_score",
        {
            "data_post": {
                "order": "desc"
            }
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true,
    "aggs": {
        "cats": {
            "terms": {
                "field": "category_id",
                "size": 2000
            }
        }
    }
}

SQL

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

["chernovcy","\/chernovcy","chernovcy\/","\/chernovcy\/"] · 1.73 ms

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

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

[191293228,207187918,204589208,198975235,197621723,193992020,193991999,207627664,206984689] · 24.72 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

[191293228,193991999,193992020,197621723,198975235,204589208,206984689,207187918,207627664] · 2.17 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.62 ms

iPhone 13 128Gb Midnight, Black, НОВИЙ open box Європа 390€

iPhone 17 Pro 512gb Orange Фіз Сім Open Box Укр сертиф, 1230€

iPhone 17 Air 256Gb Space Black Open Box 100% АКБ 66 циклів Вітрина

Новий iPhone 17 Pro Max 256GB Blue *Магазин inStyle*

iPhone 17 Pro 256GB Silver *Магазин inStyle* 15/16 Max

iPhone 16 Pro Max 256Gb Desert, Black, Natural, White НОВІ Євоопа

iPhone 16 Pro Max 512Gb Нові Європа Фізична сім Black, White, Natural

•НАЙКРАЩА ЦІНА• Новий Iphone 15 Pro Max Neverlock ЄВРОПА 256gb, 512gb, 1TB•

•НАЙКРАЩА ЦІНА• Новий Iphone 17 Pro Max Neverlock ЄВРОПА 256gb, 512gb, 1TB•

Нотатки

Elasticsearch

SQL

Новий iPhone 17 Pro Max 256GB Blue Магазин inStyle

iPhone 17 Pro 256GB Silver Магазин inStyle 15/16 Max