Продати

Kinder joy one, Дніпро (Дніпропетровськ)

3 оголошення

AMP
Фільтри
фігурки ван піс one piece kinder joy
224 ₴
224.0

фігурки ван піс one piece kinder joy

фігурки ван піс kinder joy 50 грн кожна,продаю в упаковці з вкладишами. за наявністью пишіть в особисті повідомлення

Дніпро (Дніпропетровськ) · 05.11.2026
Фігурка Луфі Luffy wanted Funko pop one piece
1 000 ₴
1000.0

Фігурка Луфі Luffy wanted Funko pop one piece

Фігурка Луфі Luffy wanted Funko pop one piece kinder joy

Дніпро (Дніпропетровськ) · 14.10.2026
Kate Ellis Kissing the demons книга англійською
170 ₴
170.0

Kate Ellis Kissing the demons книга англійською

Thirteen Torland Place is a house with a disturbing past. Not only was it the scene of five terrible murders back in the nineteenth century, but the place is also linked to the disappearance of two teenage girls twelve years ago. When a student living there is found murdered, DI Joe Plantagenet wond…

Дніпро (Дніпропетровськ) · 31.07.2026

Схожі запити

Оголошення по областях

OK · 57.1 ms · SQL 8 (19.2 ms) · ES 1 (28 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

Маршрут: категорія —, місто city #117 · ES: всього 3, id на сторінці: 3 · знайдено в БД: 3

Elasticsearch

POST /abyhomcom/_search → 200 · 28 ms · знайдено 3, повернуто 3
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "kinder joy one",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 117
                    }
                }
            ]
        }
    },
    "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 · 1.97 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 ["dnepr-dnepropetrovsk","\/dnepr-dnepropetrovsk","dnepr-dnepropetrovsk\/","\/dnepr-dnepropetrovsk\/"] · 2.76 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.52 ms
SHOW TABLES · 4.02 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) [219172406,218066989,214342506] · 5 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 [214342506,218066989,219172406] · 3.12 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.29 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.47 ms