Опис

Перед справа (пасажир)
Эта часть обычно подходит для автомобилей Buick, Chevrolet, GMC, Isuzu, Oldsmobile, Saab и включает такие модели, как 9-7x, Ascender, Bravada, Envo и XL, Envoy XUV, Envoy, Rainier, SSR, Trailblazer EXT, Trailblazer с комплектациями 4.2i Sport Utility 4-Door, 5.3i Sport Utility 4-Door, A Sport Utility 4-Door, Aero Sport Utility 4-Door, Arc Sport Utility 4-Door, B Sport Utility 4-Door, Base Convertible 2-Door, Base Sport Utility 4-Door, CXL Plus Sport Utility 4-Door, CXL Sport Utility 4-Door, Denali Sport Utility 4-Door, Limited Sport Utility 4-Door, Linear Sport

Підходить до автівок
Buick
Rainier 2004–2007 гг.
Chevrolet
SSR 2006 г.
Trailblazer 2002–2009 гг.
Trailblazer EXT 2002–2006 гг.
GMC
Envoy 2002–2009 гг.
Envoy XL 2002–2006 гг.
Envoy XUV 2004–2005 гг.
Isuzu
Ascender 2003–2008 гг.
Oldsmobile
Bravada 2002–2004 гг.
Saab
9-7x 2005–2009 гг.

Схожі оголошення

1 помилк. · 3437.7 ms · SQL 8 (69.2 ms) · ES 3 (3350.9 ms) · PHP 8.5.12 · 0.8 MB

Помилки

Findfay\Controller\PostController Findfay\Search\SearchException: Elasticsearch недоступний: Operation timed out after 3005 milliseconds with 0 bytes received
/sites/test.abyhom.com/src/Search/Elastic.php:75

Elasticsearch

POST /abyhomcom/_search → 200 · 340.3 ms · знайдено 2658267, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            9
                        ]
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 197234035
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 0,
    "size": 8,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}
POST /abyhomcom/_search → 200 · 4.6 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 197234035
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → no connection · 3006 ms · Operation timed out after 3005 milliseconds with 0 bytes received (http://172.20.0.2:9200)
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "match_all": {}
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    9
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 12.32 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) [197234035] · 1.69 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 [197234035] · 2.13 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) [219719842,219719838,219719834,219719830,219719826,219719822,219719818,219719814] · 3.07 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 [219719814,219719818,219719822,219719826,219719830,219719834,219719838,219719842] · 1.48 ms
SELECT c.* FROM `category` c ORDER BY c.id · 35.42 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 12.32 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.77 ms