Продати
Генератор bmw 0125812026 180A

Опис

Генератор 0125812026 180A на BMW 330d, 340i, 440i Coupe, 520i, 530d, 530i, 540d, 540i, 630d, 630i, 640i, 730d

Підходить на

BMW 320i 1.6 (1597ccm) Petrol B48B16A G20 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G21 Touring Van 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G21 xDrive Touring Van 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G21 Touring 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G20 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G20 xDrive 2019 - Manufac.: BOSCH
BMW 330d 3.0 (2993ccm) Diesel B57D30A G21 xDrive Touring 2019 - Manufac.: BOSCH
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 Touring Van 2015 - 2019
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 Touring Van 2015 - 2019 Manufac.: BOSCH
BMW 340i 3.0 (2998ccm) Petrol B58B30A F30 2015 - 2018
BMW 340i 3.0 (2998ccm) Petrol B58B30A F30 xDrive 2015 - 2018
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 xDrive Touring 2015 - 2019
BMW 340i 3.0 (2998ccm) Petrol B58B30A F34 xDrive Gran Turismo 2016 -
BMW 340i 3.0 (2998ccm) Petrol B58B30A F30 2015 - 2018
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 Touring 2015 - 2019
BMW 340i 3.0 (2998ccm) Petrol B58B30A F34 Gran Turismo 2016 -
BMW 340i 3.0 (2998ccm) Petrol B58B30A F34 xDrive Gran Turismo 2016 -
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 Touring 2015 - 2019
BMW 340i 3.0 (2998ccm) Petrol B58B30A F34 Gran Turismo 2016 -
BMW 340i 3.0 (2998ccm) Petrol B58B30A F30 xDrive 2015 - 2018
BMW 340i 3.0 (2998ccm) Petrol B58B30A F31 xDrive Touring 2015 - 2019
BMW 420i Coupe 1.6 (1597ccm) Petrol B48B16A G22 2020 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F33 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F33 xDrive 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F36 Gran Coupe 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F36 xDrive Gran Coupe 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F33 xDrive 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F33 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F36 Gran Coupe 2016 -
BMW 440i 3.0 (2998ccm) Petrol B58B30A F36 xDrive Gran Coupe 2016 -
BMW 440i Coupe 3.0 (2998ccm) Petrol B58B30A F32 2016 -
BMW 440i Coupe 3.0 (2998ccm) Petrol B58B30A F32 xDrive 2016 -
BMW 440i Coupe 3.0 (2998ccm) Petrol B58B30A F32 xDrive 2016 -
BMW 440i Coupe 3.0 (2998ccm) Petrol B58B30A F32 2016 -
BMW 520i 1.6 (1597ccm) Petrol B48B16A G30 2017 -
BMW 520i 2.0 (1998ccm) Petrol B48B20A G31 Touring Van 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 520i 2.0 (1998ccm) Petrol B48B20A/B48B20B G30 2017 - 2017 Month/Year to: - 10/17
BMW 520i 2.0 (1998ccm) Petrol B48B20A/B48B20B G30 2017 - 2017 Month/Year to: - 10/17
BMW 520i 2.0 (1998ccm) Petrol B48B20A/B48B20B G30 2017 - 2020
BMW 520i 2.0 (1998ccm) Petrol B48B20A G31 Touring 2017 - 2020
BMW 520i 2.0 (1998ccm) Petrol B48B20A G31 Touring 2017 - 2018 Month/Year to: - 05/18 Manufac.: Bosch
BMW 520i 2.0 (1998ccm) Petrol B48B20A G31 Touring 2017 - 2018 Month/Year to: - 05/18 Manufac.: Bosch
BMW 530d 3.0 (2993ccm) Diesel B57D30A G31 Touring Van 2017 - Manufac.: BOSCH
BMW 530d 3.0 (2993ccm) Diesel B57D30A G31 xDrive Touring Van 2017 - Manufac.: BOSCH
BMW 530d 3.0 (2993ccm) Diesel B57D30A G30 xDrive 2016 - 2020
BMW 530d 3.0 (2993ccm) Diesel B57D30A G30 2016 - 2020
BMW 530d 3.0 (2993ccm) Diesel B57D30A G30 xDrive 2016 - 2020
BMW 530d 3.0 (2993ccm) Diesel B57D30A G31 Touring 2017 - 2020
BMW 530d 3.0 (2993ccm) Diesel B57D30A G31 xDrive Touring 2017 - 2020
BMW 530i 2.0 (1998ccm) Petrol B48B20B G31 xDrive Touring Van 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 530i 2.0 (1998ccm) Petrol B48B20B G31 Touring Van 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 530i 2.0 (1998ccm) Petrol B46B20B G30 xDrive 2016 - Manufac.: BOSCH
BMW 530i 2.0 (1998ccm) Petrol B46B20B/B48B20B G30 2017 - 2020 Month/Year from : 08/17 -
BMW 530i 2.0 (1998ccm) Petrol B46B20B/B48B20B G30 xDrive 2016 - 2017 Month/Year to: - 09/17
BMW 530i 2.0 (1998ccm) Petrol B48B20B G31 Touring 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 530i 2.0 (1998ccm) Petrol B48B20B G31 xDrive Touring 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 540d 3.0 (2993ccm) Diesel B57D30B G31 xDrive Touring Van 2017 - Manufac.: BOSCH
BMW 540d 3.0 (2993ccm) Diesel B57D30B G30 xDrive 2017 - 2020
BMW 540d 3.0 (2993ccm) Diesel B57D30B G31 xDrive Touring 2017 - 2020
BMW 540i 3.0 (2998ccm) Petrol B58B30A G31 xDrive Touring Van 2017 - 2018 Month/Year to: - 06/18 Manufac.: BOSCH
BMW 540i 3.0 (2998ccm) Petrol B58B30A G30 2016 - 2020
BMW 540i 3.0 (2998ccm) Petrol B58B30A G30 xDrive 2016 - 2020
BMW 540i 3.0 (2998ccm) Petrol B58B30A G31 xDrive Touring 2017 - 2018 Month/Year to: - 06/18 Manufac.: Bosch
BMW 540i 3.0 (2998ccm) Petrol B58B30A G31 xDrive Touring 2017 - 2018 Month/Year to: - 06/18 Manufac.: Bosch
BMW 540i 3.0 (2998ccm) Petrol B58B30A G30 2016 - 2020
BMW 540i 3.0 (2998ccm) Petrol B58B30A G30 xDrive 2016 - 2020
BMW 630d 3.0 (2993ccm) Diesel B57D30A G32 Gran Turismo 2017 - 2020
BMW 630d 3.0 (2993ccm) Diesel B57D30A G32 Gran Turismo 2017 - 2020
BMW 630d 3.0 (2993ccm) Diesel B57D30A G32 xDrive Gran Turismo 2017 - 2020
BMW 630d 3.0 (2993ccm) Diesel B57D30A G32 xDrive Gran Turismo 2017 - 2020
BMW 630d 3.0 (2993ccm) Diesel B57D30A G32 xDrive Gran Turismo 2017 - 2020
BMW 630i 2.0 (1998ccm) Petrol B48B20B G32 Gran Turismo 2017 - 2018 Month/Year to: - 05/18 Manufac.: BOSCH
BMW 630i 2.0 (1998ccm) Petrol B48B20B G32 Gran Turismo 2017 - 2018 Month/Year to: - 05/18 Manufac.: Bosch
BMW 640d 3.0 (2993ccm) Diesel B57D30B G32 xDrive Gran Turismo 2017 - 2020
BMW 640i 3.0 (2998ccm) Petrol B58B30A/B58B30C G32 Gran Turismo 2017 - 2020 Manufac.: Bosch
BMW 640i 3.0 (2998ccm) Petrol B58B30A/B58B30C G32 xDrive Gran Turismo 2017 - 2020 Manufac.: Bosch
BMW 640i 3.0 (2998ccm) Petrol B58B30A/B58B30C G32 Gran Turismo 2017 - 2020 Manufac.: Bosch
BMW 640i 3.0 (2998ccm) Petrol B58B30A/B58B30C G32 xDrive Gran Turismo 2017 - 2020 Manufac.: Bosch
BMW 730d 3.0 (2993ccm) Diesel B57D30A G11 xDrive 2015 - 2020 Manufac.: BOSCH
BMW 730d 3.0 (2993ccm) Diesel B57D30A G12 Long 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G12 xDrive Long 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G11 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G12 Long 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G11 xDrive 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G11 xDrive 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G12 xDrive Long 2015 - 2020 Manufac.: BOSCH
BMW 730d 3.0 (2993ccm) Diesel B57D30A G12 xDrive Long 2015 - 2020
BMW 730d 3.0 (2993ccm) Diesel B57D30A G11 2015 - 2020
BMW 730i 2.0 (1998ccm) Petrol B48B20B G11 2015 - 2019
BMW 730i 2.0 (1998ccm) Petrol B48B20B G11 2015 - Manufac.: BOSCH
BMW 730i 2.0 (1998ccm) Petrol B48B20B G12 Long 2015 - 2019
BMW 740d 3.0 (2993ccm) Diesel B57D30B G11 xDrive 2015 - 2020
BMW 740d 3.0 (2993ccm) Diesel B57D30B G12 xDrive Long 2015 - 2020
BMW 740i 3.0 (2998ccm) Petrol B58B30A G11 2015 - 2019
BMW 740i 3.0 (2998ccm) Petrol B58B30A G12 Long 2015 - 2019
BMW 740i 3.0 (2998ccm) Petrol B58B30A G12 xDrive Long 2016 -
BMW 750d 3.0 (2993ccm) Diesel B57D30C G11 xDrive 2016 -
BMW 750d 3.0 (2993ccm) Diesel B57D30C G12 xDrive Long 2016 -
BMW 840d 3.0 (2993ccm) Diesel B57D30B G16 xDrive Gran Coupe 2019 - 2020 Manufac.: BOSCH
BMW 840d 3.0 (2993ccm) Diesel B57D30B G14 xDrive Roadster 2018 - 2020 Manufac.: BOSCH
BMW 840d Coupe 3.0 (2993ccm) Diesel B57D30B G15 xDrive 2018 - 2020 Manufac.: BOSCH
BMW M140i 3.0 (2998ccm) Petrol B58B30A F20 VAN 2016 - 2019
BMW M140i 3.0 (2998ccm) Petrol B58B30A F20 xDrive 2016 - 2019
BMW M140i 3.0 (2998ccm) Petrol B58B30A F21 xDrive 2015 -
BMW M140i 3.0 (2998ccm) Petrol B58B30A F20 2016 - 2019
BMW M140i 3.0 (2998ccm) Petrol B58B30A F21 2015 -
BMW M240i 3.0 (2998ccm) Petrol B58B30A F23 2015 -
BMW M240i 3.0 (2998ccm) Petrol B58B30A F23 xDrive 2015 -
BMW M240i Coupe 3.0 (2998ccm) Petrol B58B30A F22 xDrive 2015 -
BMW M240i Coupe 3.0 (2998ccm) Petrol B58B30A F22 2015 -
BMW M550d 3.0 (2993ccm) Diesel B57D30C G30 xDrive 2017 -
BMW M550d 3.0 (2993ccm) Diesel B57D30C G31 xDrive Touring 2017 -
BMW X3 20i 1.6 (1597ccm) Petrol B48B16A G01 sDrive 2017 -
BMW X3 20i 2.0 (1998ccm) Petrol B48B20A G01 xDrive VAN 2017 -
BMW X3 20i 2.0 (1998ccm) Petrol B48B20A G01 sDrive 2017 -
BMW X3 20i 2.0 (1998ccm) Petrol B48B20A G01 xDrive 2017 -
BMW X3 30d 3.0 (2993ccm) Diesel B57D30A G01 xDrive VAN 2017 - Manufac.: BOSCH
BMW X3 30d 3.0 (2993ccm) Diesel B57D30A G01 xDrive 2018 - 2020 Manufac.: BOSCH
BMW X3 30d 3.0 (2993ccm) Diesel B57D30A G01 xDrive 2017 - 2020
BMW X3 30i 2.0 (1998ccm) Petrol B48B20B G01 xDrive VAN 2017 - Manufac.: BOSCH
BMW X3 30i 2.0 (1998ccm) Petrol B48B20B G01 xDrive 2017 - 2019 Month/Year to: - 07/19 Manufac.: BOSCH
BMW X3 30i 2.0 (1998ccm) Petrol B48B20B G01 xDrive 2017 -
BMW X3 M40d 3.0 (2993ccm) Diesel B57D30B G01 xDrive 2018 - 2020
BMW X3 M40i 3.0 (2998ccm) Petrol B5

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

Коробка передач роздатка Дастер Рено 1.5 TL8 B000 8201057489
800 $

Коробка передач роздатка Дастер Рено 1.5 TL8 B000 8201057489

Ковель · 30 хв
Бампер Mercedes EQS 2021- разборка електро клас запчастини
799 $

Бампер Mercedes EQS 2021- разборка електро клас запчастини

Ковель · 1 год
Бампер Volkswagen Tiguan 571 запчастини Тігуан 571 шрот
300 $

Бампер Volkswagen Tiguan 571 запчастини Тігуан 571 шрот

Ковель · 1 год
Tesla Model Y Juniper бампер передній в колір PN-01 Тесла Джуніпер бампери запчастини
800 $

Tesla Model Y Juniper бампер передній в колір PN-01 Тесла Джуніпер бампери запчастини

Ковель · 1 год
Двигун Renault Master 3 2.3 dCi 92 кВт 125 к.с. 2010-2014 | Мотор двигатель турбодизель Рено Мастер 3 M9T Opel Movano B Nissan NV400
2 500 $

Двигун Renault Master 3 2.3 dCi 92 кВт 125 к.с. 2010-2014 | Мотор двигатель турбодизель Рено Мастер 3 M9T Opel Movano B Nissan NV400

Ковель · 1 год
Форсунки 0445110574 Mercedes Sprinter Vito 2.1 OM651 форсунка Мерседес Спрінтер Віто
4 900 ₴

Форсунки 0445110574 Mercedes Sprinter Vito 2.1 OM651 форсунка Мерседес Спрінтер Віто

Ковель · 2 год
Форсунка EJBR02101Z Renault Clio Kangoo Symbol Dacia Logan Sandero Nissan Kubistar Micra Suzuki Jimny форсунки Рено Ніссан
4 100 ₴

Форсунка EJBR02101Z Renault Clio Kangoo Symbol Dacia Logan Sandero Nissan Kubistar Micra Suzuki Jimny форсунки Рено Ніссан

Ковель · 2 год
Батарея ID4 62Kw акумулятор Volkswagen ID.4 ід4 62кв
3 500 $

Батарея ID4 62Kw акумулятор Volkswagen ID.4 ід4 62кв

Ковель · 2 год

Схожі запити

OK · 562.7 ms · SQL 13 (276.8 ms) · ES 3 (268.7 ms) · PHP 8.5.12 · 0.9 MB

Elasticsearch

POST /abyhomcom/_search → 200 · 95 ms · знайдено 59357, повернуто 8
тіло запиту
{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            9
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 2124
                    }
                }
            ],
            "must_not": [
                {
                    "term": {
                        "id": 168192247
                    }
                }
            ]
        }
    },
    "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 · 72.5 ms · знайдено 1, повернуто 1
тіло запиту
{
    "query": {
        "term": {
            "id": 168192247
        }
    },
    "size": 1,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ]
}
POST /abyhomcom/_search → 200 · 101.2 ms
тіло запиту
{
    "size": 0,
    "track_total_hits": false,
    "aggs": {
        "by_cat": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "term": {
                                "city_id": 2124
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "category_id",
                        "size": 2000
                    }
                }
            }
        },
        "by_city": {
            "filter": {
                "bool": {
                    "filter": [
                        {
                            "terms": {
                                "category_id": [
                                    9
                                ]
                            }
                        },
                        {
                            "terms": {
                                "city_id": [
                                    2123,
                                    124,
                                    2124,
                                    3604,
                                    3605,
                                    3606,
                                    3607,
                                    3608,
                                    3609,
                                    3610,
                                    3611,
                                    3612,
                                    3613,
                                    3614,
                                    3615,
                                    3616,
                                    3617,
                                    3618,
                                    3634,
                                    3652,
                                    6116,
                                    6147,
                                    6164,
                                    6206,
                                    6246,
                                    6266,
                                    6271,
                                    6288,
                                    6389,
                                    6392,
                                    6398,
                                    6406,
                                    6429,
                                    6449,
                                    6457,
                                    6468,
                                    6495,
                                    6529,
                                    6549,
                                    6552,
                                    6584,
                                    6787,
                                    6791,
                                    6818,
                                    6831,
                                    6834,
                                    6882,
                                    6885,
                                    6890,
                                    6894,
                                    6926,
                                    6954,
                                    6957,
                                    7001,
                                    7003,
                                    7049,
                                    7079,
                                    7135,
                                    7181,
                                    7205,
                                    7209,
                                    7212,
                                    7241,
                                    7265,
                                    7276,
                                    7279,
                                    7284,
                                    7329,
                                    7347,
                                    7348,
                                    7354,
                                    7362,
                                    7369,
                                    7376,
                                    7384,
                                    7423,
                                    7447,
                                    7465,
                                    7504,
                                    7507,
                                    7512,
                                    7515,
                                    7579,
                                    7631,
                                    7633,
                                    7661,
                                    7713,
                                    7721,
                                    7765,
                                    7816,
                                    7824,
                                    7862,
                                    7900,
                                    7916,
                                    7929,
                                    7937,
                                    7946,
                                    7971,
                                    8056,
                                    8110,
                                    8142,
                                    8146,
                                    8161,
                                    8199,
                                    8215,
                                    8259,
                                    8403,
                                    8407,
                                    8514,
                                    8538,
                                    8580,
                                    8588,
                                    8617,
                                    8666,
                                    8711,
                                    8754,
                                    8797,
                                    8799,
                                    8814,
                                    8826,
                                    8827,
                                    8830,
                                    8848,
                                    8892,
                                    8894,
                                    8895,
                                    8902,
                                    8927,
                                    8934,
                                    8941,
                                    8959,
                                    8978,
                                    8981,
                                    8986,
                                    9003,
                                    9005,
                                    9006,
                                    9038,
                                    9054,
                                    9090,
                                    9105,
                                    9110,
                                    9127,
                                    9199,
                                    9205,
                                    9266,
                                    9270,
                                    9304,
                                    9341,
                                    9345,
                                    9390,
                                    9395,
                                    9406,
                                    9408,
                                    9494,
                                    9502,
                                    9507,
                                    9534,
                                    9537,
                                    9539,
                                    9548,
                                    9584,
                                    9598,
                                    9631,
                                    9698,
                                    9706,
                                    9741,
                                    9749,
                                    9849,
                                    9850,
                                    9855,
                                    9923,
                                    9945,
                                    9952,
                                    9962,
                                    10023,
                                    10035,
                                    10043,
                                    10100,
                                    10109,
                                    10114,
                                    10163,
                                    10175,
                                    10180,
                                    10205,
                                    10225,
                                    10233,
                                    10263,
                                    10294,
                                    10307,
                                    10325,
                                    10339,
                                    10386,
                                    10388,
                                    10406,
                                    10433,
                                    10445,
                                    10458,
                                    10464,
                                    10478,
                                    10601,
                                    10603,
                                    10611,
                                    10612,
                                    10616,
                                    10622,
                                    10630,
                                    10676,
                                    10686,
                                    10694,
                                    10771,
                                    10776,
                                    10784,
                                    10793,
                                    10817,
                                    10823,
                                    10883,
                                    10914,
                                    10920,
                                    10981,
                                    11001,
                                    11004,
                                    11007,
                                    11013,
                                    11023,
                                    11033,
                                    11042,
                                    11065,
                                    11093,
                                    11103,
                                    11164,
                                    11181,
                                    11183,
                                    11185,
                                    11198,
                                    11210,
                                    11226,
                                    11232,
                                    11263,
                                    11271,
                                    11295,
                                    11327,
                                    11330,
                                    11359,
                                    11381,
                                    11383,
                                    11427,
                                    11454,
                                    11463,
                                    11481,
                                    11482,
                                    11490,
                                    11506,
                                    11515,
                                    11533,
                                    11543,
                                    11566,
                                    11570,
                                    11607,
                                    11613,
                                    11620,
                                    11646,
                                    11647,
                                    11679,
                                    11681,
                                    11689,
                                    11712,
                                    11724,
                                    11750,
                                    11754,
                                    11756,
                                    11774,
                                    11777,
                                    11782,
                                    11808,
                                    11813,
                                    11821,
                                    11840,
                                    11858,
                                    11863,
                                    11886,
                                    11897,
                                    11906,
                                    11907,
                                    11965,
                                    11982,
                                    11994,
                                    11998,
                                    12013,
                                    12022,
                                    12026,
                                    12034,
                                    12035,
                                    12051,
                                    12059,
                                    12067,
                                    12079,
                                    12087,
                                    12119,
                                    12148,
                                    12149,
                                    12155,
                                    12175,
                                    12201,
                                    12240,
                                    12252,
                                    12258,
                                    12308,
                                    12380,
                                    12386,
                                    12416,
                                    12435,
                                    12439,
                                    12448,
                                    12462,
                                    12479,
                                    12480,
                                    12488,
                                    12495,
                                    12514,
                                    12563,
                                    12582,
                                    12618,
                                    12622,
                                    12623,
                                    12628,
                                    12648,
                                    12658,
                                    12660,
                                    12663,
                                    12686,
                                    12691,
                                    12705,
                                    12735,
                                    12741
                                ]
                            }
                        }
                    ]
                }
            },
            "aggs": {
                "t": {
                    "terms": {
                        "field": "city_id",
                        "size": 30
                    }
                }
            }
        }
    }
}

SQL

SHOW TABLES · 171.89 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) [168192247] · 2.2 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 [168192247] · 0.5 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) [219465280,219462340,219462154,219459589,219459466,219458674,219458653,219458641] · 12.2 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 [219458641,219458653,219458674,219459466,219459589,219462154,219462340,219465280] · 6.2 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.78 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 (?) [2124] · 0.65 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.39 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 (?) [2123] · 6.05 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2123] · 9.64 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [124,2124,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3634,3652,6116,6147,6164,6206,6246,6266,6271,6288,6389,6392,6398,6406,6429,6449,6457,6468,6495,6529,6549,6552,6584,6787,6791,6818,6831,6834,6882,6885,6890,6894,6926,6954,6957,7001,7003,7049,7079,7135,7181,7205,7209,7212,7241,7265,7276,7279,7284,7329,7347,7348,7354,7362,7369,7376,7384,7423,7447,7465,7504,7507,7512,7515,7579,7631,7633,7661,7713,7721,7765,7816,7824,7862,7900,7916,7929,7937,7946,7971,8056,8110,8142,8146,8161,8199,8215,8259,8403,8407,8514,8538,8580,8588,8617,8666,8711,8754,8797,8799,8814,8826,8827,8830,8848,8892,8894,8895,8902,8927,8934,8941,8959,8978,8981,8986,9003,9005,9006,9038,9054,9090,9105,9110,9127,9199,9205,9266,9270,9304,9341,9345,9390,9395,9406,9408,9494,9502,9507,9534,9537,9539,9548,9584,9598,9631,9698,9706,9741,9749,9849,9850,9855,9923,9945,9952,9962,10023,10035,10043,10100,10109,10114,10163,10175,10180,10205,10225,10233,10263,10294,10307,10325,10339,10386,10388,10406,10433,10445,10458,10464,10478,10601,10603,10611,10612,10616,10622,10630,10676,10686,10694,10771,10776,10784,10793,10817,10823,10883,10914,10920,10981,11001,11004,11007,11013,11023,11033,11042,11065,11093,11103,11164,11181,11183,11185,11198,11210,11226,11232,11263,11271,11295,11327,11330,11359,11381,11383,11427,11454,11463,11481,11482,11490,11506,11515,11533,11543,11566,11570,11607,11613,11620,11646,11647,11679,11681,11689,11712,11724,11750,11754,11756,11774,11777,11782,11808,11813,11821,11840,11858,11863,11886,11897,11906,11907,11965,11982,11994,11998,12013,12022,12026,12034,12035,12051,12059,12067,12079,12087,12119,12148,12149,12155,12175,12201,12240,12252,12258,12308,12380,12386,12416,12435,12439,12448,12462,12479,12480,12488,12495,12514,12563,12582,12618,12622,12623,12628,12648,12658,12660,12663,12686,12691,12705,12735,12741] · 13.27 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [124,2124,3608,3613,3611,12741,6271,6392,7212,7265,3615,6288,9749,3607,7001,3605,8754,6206,6147,7241,10616,6164,6468,8830,6457,6429,6449,6549,7049,7465] · 2.31 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] · 50.71 ms