Elasticsearch
POST /abyhomcom/_search → 200 · 52.1 ms · знайдено 40292, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
9
]
}
},
{
"term": {
"city_id": 121
}
}
],
"must_not": [
{
"term": {
"id": 185991900
}
}
]
}
},
"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 · 45.4 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 185991900
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 381.9 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 121
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
9
]
}
},
{
"terms": {
"city_id": [
2160,
121,
2162,
2163,
3447,
3448,
3449,
3450,
3451,
3452,
3453,
3454,
3455,
3456,
3457,
3458,
3459,
3460,
3461,
3462,
3463,
6114,
6120,
6179,
6182,
6193,
6209,
6247,
6255,
6265,
6270,
6314,
6339,
6345,
6346,
6350,
6352,
6365,
6388,
6395,
6407,
6431,
6445,
6453,
6456,
6459,
6460,
6472,
6473,
6483,
6493,
6497,
6510,
6535,
6553,
6559,
6570,
6589,
6599,
6626,
6633,
6654,
6672,
6681,
6683,
6690,
6699,
6706,
6780,
6785,
6802,
6809,
6826,
6833,
6837,
6859,
6864,
6874,
6876,
6899,
6905,
6912,
6925,
6927,
6931,
6933,
6937,
7006,
7008,
7019,
7026,
7028,
7089,
7132,
7140,
7156,
7166,
7192,
7210,
7222,
7224,
7233,
7254,
7264,
7267,
7269,
7282,
7289,
7299,
7310,
7312,
7321,
7322,
7325,
7338,
7357,
7372,
7391,
7402,
7424,
7436,
7438,
7440,
7458,
7461,
7473,
7477,
7495,
7519,
7531,
7549,
7563,
7564,
7587,
7593,
7596,
7599,
7602,
7604,
7615,
7618,
7619,
7627,
7641,
7657,
7669,
7673,
7674,
7676,
7698,
7705,
7716,
7720,
7734,
7742,
7771,
7778,
7786,
7792,
7793,
7797,
7808,
7811,
7814,
7815,
7838,
7841,
7866,
7904,
7915,
7922,
7925,
7957,
7964,
7976,
7985,
7993,
8005,
8007,
8032,
8036,
8060,
8063,
8077,
8087,
8088,
8098,
8131,
8140,
8149,
8151,
8152,
8165,
8178,
8183,
8189,
8190,
8203,
8243,
8277,
8291,
8294,
8324,
8334,
8338,
8370,
8379,
8382,
8383,
8413,
8526,
8535,
8559,
8569,
8583,
8598,
8605,
8619,
8650,
8668,
8679,
8698,
8699,
8703,
8708,
8725,
8726,
8775,
8805,
8811,
8834,
8873,
8880,
8883,
8888,
8918,
8935,
8947,
8966,
8993,
9007,
9011,
9020,
9047,
9078,
9106,
9125,
9133,
9170,
9174,
9195,
9219,
9254,
9255,
9269,
9272,
9281,
9307,
9316,
9321,
9323,
9332,
9335,
9339,
9356,
9369,
9384,
9393,
9405,
9415,
9420,
9425,
9434,
9454,
9456,
9473,
9477,
9527,
9541,
9550,
9569,
9592,
9627,
9634,
9637,
9654,
9675,
9694,
9707,
9711,
9725,
9751,
9761,
9768,
9770,
9799,
9806,
9822,
9827,
9829,
9833,
9857,
9886,
9893,
9897,
9932,
9936,
9947,
9950,
9954,
9974,
10041,
10044,
10061,
10101,
10102,
10106,
10130,
10195,
10209,
10216,
10239,
10242,
10283,
10310,
10335,
10444,
10483,
10566,
10576,
10610,
10625,
10626,
10636,
10650,
10659,
10666,
10696,
10710,
10720,
10722,
10726,
10758,
10792,
10811,
10828,
10835,
10847,
10853,
10862,
10888,
10894,
10907,
10912,
10945,
10950,
10954,
10975,
10987,
10993,
11015,
11016,
11059,
11187,
11189,
11205,
11252,
11261,
11265,
11335,
11340,
11348,
11372,
11382,
11388,
11424,
11437,
11467,
11470,
11472,
11479,
11491,
11513,
11524,
11550,
11576,
11583,
11601,
11609,
11610,
11614,
11615,
11627,
11636,
11655,
11658,
11676,
11684,
11780,
11824,
11826,
11847,
11856,
11870,
11874,
11876,
11927,
11932,
11995,
12000,
12029,
12043,
12056,
12058,
12081,
12088,
12107,
12109,
12126,
12179,
12202,
12217,
12221,
12233,
12259,
12282,
12283,
12299,
12300,
12312,
12333,
12352,
12400,
12415,
12459,
12461,
12468,
12491,
12498,
12503,
12505,
12542,
12578,
12587,
12641,
12645,
12672,
12676,
12709,
12715,
12718
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 1.39 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) [185991900] · 1.63 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 [185991900] · 1.32 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) [219419812,219418879,219418810,219418771,219418768,219418729,219418717,219418714] · 1.26 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 [219418714,219418717,219418729,219418768,219418771,219418810,219418879,219419812] · 0.75 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 (?) [121] · 1.07 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.6 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 (?) [2160] · 0.6 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2160] · 0.55 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [121,2162,2163,3447,3448,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3459,3460,3461,3462,3463,6114,6120,6179,6182,6193,6209,6247,6255,6265,6270,6314,6339,6345,6346,6350,6352,6365,6388,6395,6407,6431,6445,6453,6456,6459,6460,6472,6473,6483,6493,6497,6510,6535,6553,6559,6570,6589,6599,6626,6633,6654,6672,6681,6683,6690,6699,6706,6780,6785,6802,6809,6826,6833,6837,6859,6864,6874,6876,6899,6905,6912,6925,6927,6931,6933,6937,7006,7008,7019,7026,7028,7089,7132,7140,7156,7166,7192,7210,7222,7224,7233,7254,7264,7267,7269,7282,7289,7299,7310,7312,7321,7322,7325,7338,7357,7372,7391,7402,7424,7436,7438,7440,7458,7461,7473,7477,7495,7519,7531,7549,7563,7564,7587,7593,7596,7599,7602,7604,7615,7618,7619,7627,7641,7657,7669,7673,7674,7676,7698,7705,7716,7720,7734,7742,7771,7778,7786,7792,7793,7797,7808,7811,7814,7815,7838,7841,7866,7904,7915,7922,7925,7957,7964,7976,7985,7993,8005,8007,8032,8036,8060,8063,8077,8087,8088,8098,8131,8140,8149,8151,8152,8165,8178,8183,8189,8190,8203,8243,8277,8291,8294,8324,8334,8338,8370,8379,8382,8383,8413,8526,8535,8559,8569,8583,8598,8605,8619,8650,8668,8679,8698,8699,8703,8708,8725,8726,8775,8805,8811,8834,8873,8880,8883,8888,8918,8935,8947,8966,8993,9007,9011,9020,9047,9078,9106,9125,9133,9170,9174,9195,9219,9254,9255,9269,9272,9281,9307,9316,9321,9323,9332,9335,9339,9356,9369,9384,9393,9405,9415,9420,9425,9434,9454,9456,9473,9477,9527,9541,9550,9569,9592,9627,9634,9637,9654,9675,9694,9707,9711,9725,9751,9761,9768,9770,9799,9806,9822,9827,9829,9833,9857,9886,9893,9897,9932,9936,9947,9950,9954,9974,10041,10044,10061,10101,10102,10106,10130,10195,10209,10216,10239,10242,10283,10310,10335,10444,10483,10566,10576,10610,10625,10626,10636,10650,10659,10666,10696,10710,10720,10722,10726,10758,10792,10811,10828,10835,10847,10853,10862,10888,10894,10907,10912,10945,10950,10954,10975,10987,10993,11015,11016,11059,11187,11189,11205,11252,11261,11265,11335,11340,11348,11372,11382,11388,11424,11437,11467,11470,11472,11479,11491,11513,11524,11550,11576,11583,11601,11609,11610,11614,11615,11627,11636,11655,11658,11676,11684,11780,11824,11826,11847,11856,11870,11874,11876,11927,11932,11995,12000,12029,12043,12056,12058,12081,12088,12107,12109,12126,12179,12202,12217,12221,12233,12259,12282,12283,12299,12300,12312,12333,12352,12400,12415,12459,12461,12468,12491,12498,12503,12505,12542,12578,12587,12641,12645,12672,12676,12709,12715,12718] · 3.1 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [121,2163,2162,3453,3447,3460,3455,3454,6270,7436,3452,6182,9369,3448,3462,6599,3458,6114,6209,3461,6193,7166,8679,3463,6179,8088,6864,6453,6472,3450] · 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] · 1.27 ms