Нотатки
Маршрут: категорія #1 /transport/, місто region #2123 · ES: всього 6, id на сторінці: 6 · знайдено в БД: 6
Elasticsearch
POST /abyhomcom/_search → 200 · 58.9 ms · знайдено 6, повернуто 6
тіло запиту
{
"query": {
"bool": {
"must": [
{
"multi_match": {
"query": "macbook",
"fields": [
"name^3",
"description",
"city^2"
],
"type": "best_fields",
"operator": "and",
"fuzziness": "AUTO",
"prefix_length": 2
}
}
],
"filter": [
{
"terms": {
"category_id": [
1,
10,
9,
8,
7,
6,
5,
4,
3,
2
]
}
},
{
"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
]
}
}
]
}
},
"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 · 2.45 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 ["volynskaya-oblast","\/volynskaya-oblast","volynskaya-oblast\/","\/volynskaya-oblast\/"] · 1.62 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.48 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2123] · 0.98 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] · 7.92 ms
SHOW TABLES · 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) [201826227,218613542,203527823,181870003,194613263,176944417] · 6.37 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 [176944417,181870003,194613263,201826227,203527823,218613542] · 2.26 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 [2123] · 5.33 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,3613,3615,6271,12741] · 2.72 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] · 119.92 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] · 0.44 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.64 ms