Транспорт, Лелітка

{
    "query": {
        "bool": {
            "filter": [
                {
                    "terms": {
                        "category_id": [
                            1,
                            10,
                            9,
                            8,
                            7,
                            6,
                            5,
                            4,
                            3,
                            2
                        ]
                    }
                },
                {
                    "term": {
                        "city_id": 7849
                    }
                }
            ]
        }
    },
    "sort": [
        {
            "data_post": {
                "order": "desc"
            }
        },
        {
            "id": "desc"
        }
    ],
    "from": 0,
    "size": 50,
    "_source": [
        "id",
        "m2",
        "km",
        "price2",
        "attribute"
    ],
    "track_total_hits": true
}

SQL

SELECT c.* FROM `category` c ORDER BY c.id · 2.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.url IN (?, ?, ?, ?) LIMIT 1

["lelitka","\/lelitka","lelitka\/","\/lelitka\/"] · 1.78 ms

SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.27 ms

SHOW TABLES · 1.82 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)

[218010112,217087450,215499516,211125705,210703312,203082238,200033695,198044055,195969197,183316925,180591877] · 15.8 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

[180591877,183316925,195969197,198044055,200033695,203082238,210703312,211125705,215499516,217087450,218010112] · 15.04 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.58 ms

SELECT v.attribute_id, v.value, COUNT(*) AS cnt FROM (SELECT p.id FROM `post` p WHERE p.category_id IN (?,?,?,?,?,?,?,?,?,?) AND (1) ORDER BY p.id DESC LIMIT 3000) s JOIN `attribute_value` v ON v.post_id = s.id WHERE v.value IS NOT NULL AND v.value <> '' AND CHAR_LENGTH(v.value) <= 60 GROUP BY v.attribute_id, v.value

[1,10,9,8,7,6,5,4,3,2] · 41.09 ms

SELECT a.id, COALESCE(NULLIF(a.name_ua, ''), NULLIF(a.name, '')) AS name FROM `attribute` a WHERE a.id IN (?,?,?,?,?,?,?,?)

[622,633,634,1424,1426,1427,1430,1431] · 1.37 ms

Катушка Beru , map-сенсор Delphi

Продаж Трактора МТЗ

Продам нову гранату.Нісан Кашкай.

Кабіна МТЗ 80 (мала)

Бампер Opel Movano

Крило нісан ліф 2015 рік

Продам переднє праве крило ло Audi A4 B8 2015р

Міст передній балка МТЗ 80

Алюмінієвий автомобільний бак на 220л.

Підшипник Ступиці Колеса Bpw, Saf Ø90*ø150*45Mm Внутр. Перед. Vkhb2404

Продам задні ліхтарі Jetta6 оригінальні без пошкоджень

Нотатки

Elasticsearch

SQL

Підшипник Ступиці Колеса Bpw, Saf Ø90ø15045Mm Внутр. Перед. Vkhb2404