Продать

Bmw e81 e87, Виноградов

5 объявлений

AMP
Фильтры
Поршень BMW 2.0 N46B20 84.00mm E60 E81 E83 E84 E85 E87 E90 E91 E92
75 $
3300.0

Поршень BMW 2.0 N46B20 84.00mm E60 E81 E83 E84 E85 E87 E90 E91 E92

Поршень с кольцами BMW 2.0 N46B20 84.00mm E60 E81 E83 E84 E85 E87 E90 E91 E92 118i 120i 320i 520i X1 X3 Z4 N46B20B N46B20C N46B20E N46B20BD N46B20CC N46B20CD 11257562451 11257548001 11257540067 11257562457 11257556435 11257541469

Виноградов · 19.01.2025
Поршень BMW 2.5 N52B25 323i 325i 523i 525i X1 X3 X4 82.00mm
100 $
4400.0

Поршень BMW 2.5 N52B25 323i 325i 523i 525i X1 X3 X4 82.00mm

Поршень с кольцами на BMW 2.5 N52B25 E83 E81 E87 E84E90 E91 E60 E61 F10 F11 E89 323i 325i 523i 525i X1 X3 X4 82.00mm 11257612982 11257561848 11257561844 11257542057

Виноградов · 26.01.2025
Коробка bmw 1series 6МКПП
200 $
8800.0

Коробка bmw 1series 6МКПП

Коробка bmw 1series 6МКПП. BMW 1 Series (E81, E87): 116i, 118i, 118d, 120i, 120d. BMW 3 Series (E90, E91, E92): 318d, 320i. 217.0.0173.96 Сумісні двигуни Дизельні: N47. Бензинові: N43 (зокрема N43B16A, N43B20A)

Виноградов · 02.09.2026
Поршень BMW N52B30 125i 130i 330i 530i 630i 730i X3 X5 Z4 85.00mm
4 000 ₴
4000.0

Поршень BMW N52B30 125i 130i 330i 530i 630i 730i X3 X5 Z4 85.00mm

Поршень с кольцами на BMW N52B30 E82 E87 E90 E92 E60 E63 E66 125i 130i 330i 530i 630i 730i X3 X5 Z4 85.00mm 11257564335 11257559434 11257551349 11257534552 11257547838

Виноградов · 19.01.2025
Поршень BMW 3.0 N54B30 84.00mm F01 F02 135i 335i 535i 740i X6 E61 E71
100 $
4400.0

Поршень BMW 3.0 N54B30 84.00mm F01 F02 135i 335i 535i 740i X6 E61 E71

Поршень с кольцами на BMW 3.0 E82 E90 E91 E92 E93 E60 E61 E71 E89 F01 F02 135i 335i 535i 740i X6 N54B30 84.00mm 11257610295 11257577586 11257577581 11257577582 11257610296 11257561698 11257570405 11257577587

Виноградов · 26.01.2025

Похожие запросы

Объявления по областям

OK · 153.8 ms · SQL 8 (34.8 ms) · ES 1 (104.5 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 104.5 ms · знайдено 5, повернуто 5
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "bmw e81 e87",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "term": {
                        "city_id": 3594
                    }
                }
            ]
        }
    },
    "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 · 4.19 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.url IN (?, ?, ?, ?) LIMIT 1 ["vinogradov","\/vinogradov","vinogradov\/","\/vinogradov\/"] · 20.71 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.18 ms
SHOW TABLES · 1.28 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, ''), NULLIF(c.name_ua, '')) 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) [169561609,170868721,215999398,169549462,170868646] · 3.34 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [169549462,169561609,170868646,170868721,215999398] · 1.28 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 0.37 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 2.49 ms