Elasticsearch
POST /abyhomcom/_search → 200 · 80.9 ms · знайдено 79511, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"term": {
"city_id": 117
}
}
],
"must_not": [
{
"term": {
"id": 219538195
}
}
]
}
},
"sort": [
{
"data_post": {
"order": "desc"
}
},
{
"id": "desc"
}
],
"from": 0,
"size": 8,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
],
"track_total_hits": true
} POST /abyhomcom/_search → 200 · 40.5 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 219538195
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 81.5 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 117
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"terms": {
"city_id": [
2126,
117,
2101,
2127,
2129,
2131,
2132,
2133,
2716,
2717,
3072,
3132,
3133,
3134,
3135,
3136,
3137,
3138,
3139,
3141,
3142,
3143,
3144,
3145,
3146,
3147,
3148,
3149,
3150,
3151,
3152,
3621,
3645,
3646,
6101,
6121,
6125,
6133,
6167,
6191,
6198,
6200,
6208,
6222,
6224,
6263,
6278,
6284,
6304,
6308,
6311,
6334,
6347,
6348,
6368,
6387,
6403,
6404,
6432,
6440,
6451,
6469,
6477,
6480,
6490,
6509,
6527,
6548,
6561,
6564,
6577,
6581,
6590,
6594,
6613,
6619,
6624,
6635,
6645,
6680,
6686,
6693,
6698,
6753,
6773,
6796,
6800,
6825,
6850,
6910,
6958,
6968,
6970,
6983,
7013,
7016,
7017,
7045,
7046,
7067,
7086,
7088,
7095,
7100,
7113,
7119,
7142,
7179,
7195,
7231,
7239,
7256,
7272,
7273,
7274,
7342,
7350,
7367,
7381,
7405,
7456,
7516,
7524,
7535,
7538,
7556,
7565,
7567,
7568,
7592,
7597,
7600,
7622,
7650,
7679,
7697,
7729,
7759,
7802,
7819,
7823,
7872,
7873,
7919,
7940,
7967,
8024,
8038,
8048,
8049,
8069,
8071,
8089,
8108,
8120,
8124,
8156,
8182,
8196,
8205,
8219,
8226,
8281,
8317,
8342,
8364,
8371,
8387,
8401,
8409,
8546,
8581,
8591,
8604,
8623,
8629,
8646,
8648,
8659,
8673,
8691,
8696,
8707,
8721,
8737,
8755,
8785,
8786,
8794,
8798,
8800,
8828,
8840,
8843,
8886,
8904,
8926,
8940,
8980,
9008,
9045,
9063,
9096,
9118,
9144,
9153,
9157,
9165,
9176,
9185,
9188,
9197,
9207,
9210,
9211,
9218,
9226,
9228,
9284,
9286,
9349,
9361,
9366,
9386,
9388,
9398,
9445,
9455,
9545,
9559,
9570,
9593,
9624,
9668,
9687,
9690,
9704,
9732,
9733,
9742,
9765,
9776,
9786,
9863,
9865,
9895,
9905,
9909,
9953,
9976,
10021,
10077,
10090,
10093,
10098,
10122,
10164,
10169,
10174,
10176,
10196,
10203,
10208,
10217,
10224,
10231,
10238,
10252,
10266,
10285,
10309,
10320,
10330,
10416,
10425,
10461,
10475,
10508,
10524,
10593,
10605,
10615,
10674,
10697,
10707,
10712,
10730,
10733,
10749,
10750,
10773,
10786,
10815,
10827,
10841,
10872,
10922,
10933,
10949,
10961,
10962,
10964,
10978,
10982,
10991,
11080,
11117,
11145,
11229,
11233,
11240,
11242,
11257,
11262,
11268,
11273,
11283,
11315,
11333,
11337,
11358,
11376,
11389,
11417,
11430,
11433,
11453,
11456,
11464,
11497,
11532,
11557,
11577,
11582,
11608,
11633,
11695,
11707,
11713,
11729,
11768,
11769,
11805,
11830,
11835,
11848,
11861,
11966,
12052,
12057,
12090,
12100,
12154,
12162,
12164,
12167,
12168,
12170,
12185,
12189,
12222,
12235,
12257,
12272,
12306,
12316,
12332,
12344,
12388,
12407,
12432,
12452,
12463,
12478,
12483,
12494,
12523,
12584,
12585,
12589,
12591,
12632,
12643,
12647,
12650,
12706,
12711,
12712
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 1.84 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) [219538195] · 0.48 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 [219538195] · 0.69 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) [219538474,219538471,219538465,219538441,219538306,219538300,219538279,219538192] · 9.91 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 [219538192,219538279,219538300,219538306,219538441,219538465,219538471,219538474] · 16.33 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.72 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 (?) [117] · 0.62 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.89 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 (?) [2126] · 1.08 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2126] · 1.17 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [117,2101,2127,2129,2131,2132,2133,2716,2717,3072,3132,3133,3134,3135,3136,3137,3138,3139,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3621,3645,3646,6101,6121,6125,6133,6167,6191,6198,6200,6208,6222,6224,6263,6278,6284,6304,6308,6311,6334,6347,6348,6368,6387,6403,6404,6432,6440,6451,6469,6477,6480,6490,6509,6527,6548,6561,6564,6577,6581,6590,6594,6613,6619,6624,6635,6645,6680,6686,6693,6698,6753,6773,6796,6800,6825,6850,6910,6958,6968,6970,6983,7013,7016,7017,7045,7046,7067,7086,7088,7095,7100,7113,7119,7142,7179,7195,7231,7239,7256,7272,7273,7274,7342,7350,7367,7381,7405,7456,7516,7524,7535,7538,7556,7565,7567,7568,7592,7597,7600,7622,7650,7679,7697,7729,7759,7802,7819,7823,7872,7873,7919,7940,7967,8024,8038,8048,8049,8069,8071,8089,8108,8120,8124,8156,8182,8196,8205,8219,8226,8281,8317,8342,8364,8371,8387,8401,8409,8546,8581,8591,8604,8623,8629,8646,8648,8659,8673,8691,8696,8707,8721,8737,8755,8785,8786,8794,8798,8800,8828,8840,8843,8886,8904,8926,8940,8980,9008,9045,9063,9096,9118,9144,9153,9157,9165,9176,9185,9188,9197,9207,9210,9211,9218,9226,9228,9284,9286,9349,9361,9366,9386,9388,9398,9445,9455,9545,9559,9570,9593,9624,9668,9687,9690,9704,9732,9733,9742,9765,9776,9786,9863,9865,9895,9905,9909,9953,9976,10021,10077,10090,10093,10098,10122,10164,10169,10174,10176,10196,10203,10208,10217,10224,10231,10238,10252,10266,10285,10309,10320,10330,10416,10425,10461,10475,10508,10524,10593,10605,10615,10674,10697,10707,10712,10730,10733,10749,10750,10773,10786,10815,10827,10841,10872,10922,10933,10949,10961,10962,10964,10978,10982,10991,11080,11117,11145,11229,11233,11240,11242,11257,11262,11268,11273,11283,11315,11333,11337,11358,11376,11389,11417,11430,11433,11453,11456,11464,11497,11532,11557,11577,11582,11608,11633,11695,11707,11713,11729,11768,11769,11805,11830,11835,11848,11861,11966,12052,12057,12090,12100,12154,12162,12164,12167,12168,12170,12185,12189,12222,12235,12257,12272,12306,12316,12332,12344,12388,12407,12432,12452,12463,12478,12483,12494,12523,12584,12585,12589,12591,12632,12643,12647,12650,12706,12711,12712] · 4.91 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [117,2101,6334,2133,6224,2129,2131,2717,3142,6645,3148,3147,3143,6133,3137,2716,3150,3146,3136,3646,6208,3149,3138,3645,3151,3135,7017,10231,6198,6404] · 1.29 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.68 ms