Продати

Chrysler aspen limited

3 оголошення

AMP
Фільтри
Chrysler Aspen Limited
9 999 $
439956.0

Chrysler Aspen Limited

2007 CHRYSLER ASPEN все що робилось по авто. $120 работа радиатор $ 134 rear spoiler + $ 169 head lights + $. 66 bug deflector + $. 84 Hamelion tint + $. 7 lighter charger + $. 7 air filter + $ 31 head cam ? $. 80 splash guards + $. 7 batman sticer ? $ 100 push bar + $ 277 brakes rotors. + $ 36 fron…

Тернопіль · 26.04.2025
Датчики тиску (давления) в шинах Jeep Compass, Liberty, Wrangler, Dodge Dakota, Durango, Chrysler 315Mhz
500 ₴
500.0

Датчики тиску (давления) в шинах Jeep Compass, Liberty, Wrangler, Dodge Dakota, Durango, Chrysler 315Mhz

Застосування: Для 2017 Jeep Compass Latitude, Sport Для 2017 Jeep Patriot Latitude, Sport Для Jeep Compass 75th Anniversary, Latitude, Sport 2016 року випуску Для Jeep Patriot 75th Anniversary, Latitude, Sport 2016 року випуску Для Jeep Compass 2015 року випуску: моделі Altitude, High Altitude, Lati…

Харків · 16.08.2026
Датчики тиску (давления) шин Jeep Dodge Cruiser Ram Fiat USA&EUROPE
540 ₴
540.0

Датчики тиску (давления) шин Jeep Dodge Cruiser Ram Fiat USA&EUROPE

Датчики тиску в шинах нові та Б У для всіх моделей Jeep Dodge Cruiser. Chrysler Chrysler 300: 2012–2020 Chrysler Aspen: 2012–2020 Chrysler Town & Country: 2011–2016 Dodge Dodge C/V: 2012–2015 Dodge Challenger: 2008–2022 Dodge Charger: 2009–2022 Dodge Durango: 2011–2015 Dodge Grand Caravan: 2011–2020…

Софіївська Борщагівка · 24.09.2025

Схожі запити

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

OK · 138.1 ms · SQL 8 (71.6 ms) · ES 1 (56.3 ms) · PHP 8.5.12 · 0.8 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 56.3 ms · знайдено 3, повернуто 3
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "chrysler aspen limited",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ]
        }
    },
    "sort": [
        "_score",
        {
            "data_post": {
                "order": "desc"
            }
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true,
    "aggs": {
        "cities": {
            "terms": {
                "field": "city_id",
                "size": 30
            }
        },
        "cats": {
            "terms": {
                "field": "category_id",
                "size": 2000
            }
        }
    }
}

SQL

SHOW TABLES · 4.03 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) [179890273,215212731,193120544] · 5.34 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 [179890273,193120544,215212731] · 0.95 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.41 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.02 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] · 16.61 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.id IN (?,?,?) [133,135,6283] · 39.1 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] · 4.17 ms