Нотатки
Маршрут: категорія —, місто region #2224 · ES: всього 6, id на сторінці: 6 · знайдено в БД: 6
Elasticsearch
POST /abyhomcom/_search → 200 · 54.4 ms · знайдено 6, повернуто 6
тіло запиту
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "iphone se iphone",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"terms": {
"city_id": [
2224,
139,
3542,
3543,
3544,
3545,
3546,
3547,
3548,
3549,
3550,
3551,
3552,
3553,
3631,
3636,
6297,
6400,
6443,
6463,
6623,
6625,
6694,
6897,
6918,
6959,
6977,
7117,
7330,
7341,
7349,
7377,
7389,
7497,
7611,
7648,
7654,
7662,
7711,
7733,
7766,
7784,
7822,
7829,
7832,
7860,
7879,
7890,
7898,
7913,
7923,
7938,
7965,
8014,
8020,
8064,
8068,
8076,
8091,
8139,
8141,
8238,
8247,
8272,
8274,
8302,
8346,
8358,
8399,
8517,
8544,
8620,
8621,
8626,
8657,
8662,
8675,
8719,
8743,
8753,
8819,
8837,
8874,
8953,
9004,
9143,
9159,
9175,
9177,
9209,
9290,
9308,
9422,
9450,
9459,
9483,
9489,
9530,
9604,
9623,
9641,
9682,
9777,
9801,
9810,
9838,
9854,
9927,
9990,
10006,
10009,
10050,
10107,
10171,
10260,
10277,
10300,
10323,
10387,
10419,
10438,
10564,
10614,
10657,
10683,
10772,
10791,
10798,
10803,
10822,
10837,
10840,
10880,
10887,
11020,
11090,
11135,
11136,
11162,
11345,
11354,
11410,
11413,
11468,
11480,
11553,
11628,
11723,
11744,
11766,
11822,
11937,
11997,
11999,
12032,
12104,
12177,
12213,
12261,
12304,
12544,
12547,
12566,
12656,
12737
]
}
}
]
}
},
"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 · 3.28 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 ["chernovickaya-oblast","\/chernovickaya-oblast","chernovickaya-oblast\/","\/chernovickaya-oblast\/"] · 0.76 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.08 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2224] · 1.26 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [139,3542,3543,3544,3545,3546,3547,3548,3549,3550,3551,3552,3553,3631,3636,6297,6400,6443,6463,6623,6625,6694,6897,6918,6959,6977,7117,7330,7341,7349,7377,7389,7497,7611,7648,7654,7662,7711,7733,7766,7784,7822,7829,7832,7860,7879,7890,7898,7913,7923,7938,7965,8014,8020,8064,8068,8076,8091,8139,8141,8238,8247,8272,8274,8302,8346,8358,8399,8517,8544,8620,8621,8626,8657,8662,8675,8719,8743,8753,8819,8837,8874,8953,9004,9143,9159,9175,9177,9209,9290,9308,9422,9450,9459,9483,9489,9530,9604,9623,9641,9682,9777,9801,9810,9838,9854,9927,9990,10006,10009,10050,10107,10171,10260,10277,10300,10323,10387,10419,10438,10564,10614,10657,10683,10772,10791,10798,10803,10822,10837,10840,10880,10887,11020,11090,11135,11136,11162,11345,11354,11410,11413,11468,11480,11553,11628,11723,11744,11766,11822,11937,11997,11999,12032,12104,12177,12213,12261,12304,12544,12547,12566,12656,12737] · 2.86 ms
SHOW TABLES · 4.48 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) [196716479,196177772,210348944,202834981,204812480,207865612] · 14.64 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 [196177772,196716479,202834981,204812480,207865612,210348944] · 0.88 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 [2224] · 0.86 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 (?,?) [139,3545] · 0.5 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] · 2.15 ms