Продать

Solutions intermediate third, Кировоградская область

0 объявлений

Фильтры

Ничего не найдено

Попробуйте изменить фильтры или сбросить их.

Города: Кировоградская область

OK · 53.5 ms · SQL 7 (7.6 ms) · ES 1 (16.1 ms) · PHP 8.5.12 · 0.9 MB

Нотатки

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

Elasticsearch

POST /abyhomcom/_search → 200 · 16.1 ms · знайдено 0, повернуто 0
тіло запиту
{
    "query": {
        "bool": {
            "must": [
                {
                    "multi_match": {
                        "query": "solutions intermediate third",
                        "fields": [
                            "name^3",
                            "description",
                            "city^2"
                        ],
                        "type": "best_fields",
                        "operator": "and",
                        "fuzziness": "AUTO",
                        "prefix_length": 2
                    }
                }
            ],
            "filter": [
                {
                    "terms": {
                        "city_id": [
                            2169,
                            122,
                            2170,
                            2172,
                            2715,
                            3525,
                            3526,
                            3527,
                            3528,
                            3529,
                            3530,
                            3531,
                            3532,
                            3533,
                            3534,
                            3535,
                            3536,
                            3537,
                            3538,
                            3539,
                            3540,
                            3541,
                            6186,
                            6214,
                            6261,
                            6302,
                            6386,
                            6405,
                            6427,
                            6441,
                            6609,
                            6658,
                            6766,
                            6795,
                            6855,
                            6879,
                            6881,
                            6935,
                            6998,
                            7112,
                            7317,
                            7408,
                            7488,
                            7502,
                            7562,
                            7612,
                            7613,
                            7723,
                            7932,
                            7942,
                            7994,
                            8031,
                            8128,
                            8169,
                            8174,
                            8378,
                            8551,
                            8555,
                            8649,
                            8739,
                            8801,
                            8878,
                            8929,
                            9034,
                            9128,
                            9203,
                            9239,
                            9328,
                            9363,
                            9389,
                            9470,
                            9522,
                            9571,
                            9601,
                            9649,
                            9664,
                            9672,
                            9720,
                            9745,
                            9752,
                            9767,
                            9774,
                            9835,
                            9951,
                            10002,
                            10013,
                            10018,
                            10081,
                            10184,
                            10273,
                            10291,
                            10299,
                            10304,
                            10440,
                            10677,
                            10685,
                            10725,
                            10765,
                            10881,
                            10916,
                            10968,
                            11081,
                            11121,
                            11182,
                            11209,
                            11302,
                            11445,
                            11446,
                            11452,
                            11469,
                            11509,
                            11519,
                            11700,
                            11722,
                            11867,
                            11882,
                            11917,
                            11946,
                            11976,
                            12091,
                            12125,
                            12136,
                            12303,
                            12313,
                            12433,
                            12611,
                            12662,
                            12729,
                            12736
                        ]
                    }
                }
            ]
        }
    },
    "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

SELECT c.* FROM `category` c ORDER BY c.id · 1.5 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 ["kirovogradskaya-oblast","\/kirovogradskaya-oblast","kirovogradskaya-oblast\/","\/kirovogradskaya-oblast\/"] · 0.92 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.9 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2169] · 0.55 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [122,2170,2172,2715,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3538,3539,3540,3541,6186,6214,6261,6302,6386,6405,6427,6441,6609,6658,6766,6795,6855,6879,6881,6935,6998,7112,7317,7408,7488,7502,7562,7612,7613,7723,7932,7942,7994,8031,8128,8169,8174,8378,8551,8555,8649,8739,8801,8878,8929,9034,9128,9203,9239,9328,9363,9389,9470,9522,9571,9601,9649,9664,9672,9720,9745,9752,9767,9774,9835,9951,10002,10013,10018,10081,10184,10273,10291,10299,10304,10440,10677,10685,10725,10765,10881,10916,10968,11081,11121,11182,11209,11302,11445,11446,11452,11469,11509,11519,11700,11722,11867,11882,11917,11946,11976,12091,12125,12136,12303,12313,12433,12611,12662,12729,12736] · 0.93 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 [2169] · 1.04 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] · 1.71 ms