Нотатки
Маршрут: категорія —, місто region #2169 · ES: всього 6, id на сторінці: 6 · знайдено в БД: 6
Elasticsearch
POST /abyhomcom/_search → 200 · 60.4 ms · знайдено 6, повернуто 6
тіло запиту
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "wireless logitech",
"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 · 18.68 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 ["kirovogradskaya-oblast","\/kirovogradskaya-oblast","kirovogradskaya-oblast\/","\/kirovogradskaya-oblast\/"] · 14.16 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.38 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2169] · 0.4 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] · 1.23 ms
SHOW TABLES · 0.85 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) [201033817,203387045,201033850,198976321,202576659,197367419] · 16.35 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 [197367419,198976321,201033817,201033850,202576659,203387045] · 2.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 [2169] · 2.3 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 (?,?,?) [122,2172,6214] · 0.95 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.94 ms