Elasticsearch
POST /abyhomcom/_search → 200 · 56 ms · знайдено 28665, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"term": {
"city_id": 128
}
}
],
"must_not": [
{
"term": {
"id": 215023671
}
}
]
}
},
"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 · 41 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 215023671
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 335.3 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 128
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"terms": {
"city_id": [
2193,
128,
2107,
2194,
2196,
2485,
3217,
3218,
3219,
3220,
3221,
3222,
3223,
3224,
3225,
3226,
3227,
3228,
3229,
3230,
3231,
3232,
3233,
3234,
3235,
3236,
3237,
3654,
6135,
6161,
6173,
6180,
6205,
6306,
6353,
6411,
6421,
6437,
6488,
6519,
6554,
6563,
6611,
6612,
6638,
6676,
6697,
6716,
6811,
6832,
6836,
6854,
6869,
6873,
6895,
6907,
6914,
6955,
6960,
6993,
7035,
7038,
7072,
7080,
7091,
7092,
7094,
7099,
7109,
7123,
7125,
7152,
7167,
7187,
7213,
7217,
7258,
7288,
7292,
7300,
7306,
7363,
7365,
7386,
7396,
7400,
7414,
7467,
7489,
7494,
7525,
7576,
7589,
7609,
7636,
7646,
7689,
7704,
7709,
7710,
7718,
7738,
7746,
7769,
7775,
7847,
7853,
7865,
7869,
7910,
7918,
7959,
7966,
7981,
7983,
8019,
8052,
8157,
8167,
8185,
8191,
8194,
8218,
8239,
8242,
8250,
8262,
8267,
8268,
8271,
8319,
8349,
8355,
8359,
8374,
8396,
8400,
8553,
8610,
8642,
8653,
8709,
8718,
8731,
8744,
8772,
8806,
8808,
8810,
8823,
8838,
8845,
8859,
8865,
8866,
8869,
8877,
8881,
8887,
8898,
8903,
8905,
8923,
8989,
9013,
9024,
9031,
9044,
9048,
9056,
9072,
9076,
9119,
9150,
9161,
9180,
9181,
9193,
9236,
9262,
9263,
9306,
9313,
9333,
9353,
9355,
9360,
9374,
9409,
9465,
9474,
9499,
9523,
9544,
9556,
9560,
9566,
9574,
9586,
9608,
9632,
9669,
9677,
9683,
9693,
9719,
9722,
9726,
9744,
9753,
9757,
9764,
9832,
9856,
9870,
9871,
9878,
9899,
9902,
9904,
9913,
9915,
9920,
9924,
9930,
9934,
9940,
9969,
9975,
9996,
10003,
10019,
10025,
10055,
10057,
10080,
10095,
10096,
10112,
10148,
10182,
10192,
10200,
10215,
10230,
10232,
10237,
10241,
10245,
10250,
10255,
10258,
10297,
10349,
10364,
10372,
10376,
10396,
10400,
10407,
10435,
10449,
10451,
10454,
10467,
10491,
10492,
10498,
10503,
10504,
10516,
10544,
10579,
10581,
10583,
10594,
10599,
10606,
10609,
10620,
10634,
10642,
10648,
10656,
10668,
10670,
10682,
10693,
10701,
10713,
10736,
10748,
10769,
10785,
10796,
10809,
10818,
10831,
10833,
10839,
10856,
10885,
10893,
10899,
10903,
10963,
10999,
11022,
11028,
11037,
11048,
11078,
11095,
11100,
11101,
11127,
11131,
11160,
11166,
11193,
11211,
11215,
11227,
11234,
11258,
11276,
11279,
11318,
11339,
11362,
11373,
11375,
11385,
11399,
11400,
11420,
11423,
11425,
11434,
11451,
11466,
11476,
11488,
11495,
11501,
11502,
11505,
11537,
11548,
11580,
11581,
11587,
11600,
11602,
11612,
11619,
11657,
11662,
11664,
11683,
11710,
11730,
11734,
11787,
11796,
11812,
11834,
11842,
11843,
11855,
11857,
11884,
11892,
11898,
11912,
11921,
11945,
11952,
11962,
11971,
11974,
11981,
12017,
12053,
12062,
12072,
12111,
12135,
12181,
12194,
12239,
12250,
12256,
12279,
12280,
12318,
12329,
12339,
12346,
12349,
12366,
12385,
12392,
12404,
12405,
12419,
12430,
12431,
12447,
12453,
12469,
12484,
12486,
12490,
12501,
12508,
12546,
12595,
12599,
12601,
12610,
12613,
12640,
12644,
12654,
12673,
12674,
12717,
12721
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 3.34 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) [215023671] · 0.9 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 [215023671] · 1.67 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) [219362884,219360418,219360409,219360121,219360055,219359890,219359557,219359521] · 1.52 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 [219359521,219359557,219359890,219360055,219360121,219360409,219360418,219362884] · 2.25 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.79 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 (?) [128] · 0.36 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 15.06 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 (?) [2193] · 1.3 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2193] · 0.5 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [128,2107,2194,2196,2485,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3654,6135,6161,6173,6180,6205,6306,6353,6411,6421,6437,6488,6519,6554,6563,6611,6612,6638,6676,6697,6716,6811,6832,6836,6854,6869,6873,6895,6907,6914,6955,6960,6993,7035,7038,7072,7080,7091,7092,7094,7099,7109,7123,7125,7152,7167,7187,7213,7217,7258,7288,7292,7300,7306,7363,7365,7386,7396,7400,7414,7467,7489,7494,7525,7576,7589,7609,7636,7646,7689,7704,7709,7710,7718,7738,7746,7769,7775,7847,7853,7865,7869,7910,7918,7959,7966,7981,7983,8019,8052,8157,8167,8185,8191,8194,8218,8239,8242,8250,8262,8267,8268,8271,8319,8349,8355,8359,8374,8396,8400,8553,8610,8642,8653,8709,8718,8731,8744,8772,8806,8808,8810,8823,8838,8845,8859,8865,8866,8869,8877,8881,8887,8898,8903,8905,8923,8989,9013,9024,9031,9044,9048,9056,9072,9076,9119,9150,9161,9180,9181,9193,9236,9262,9263,9306,9313,9333,9353,9355,9360,9374,9409,9465,9474,9499,9523,9544,9556,9560,9566,9574,9586,9608,9632,9669,9677,9683,9693,9719,9722,9726,9744,9753,9757,9764,9832,9856,9870,9871,9878,9899,9902,9904,9913,9915,9920,9924,9930,9934,9940,9969,9975,9996,10003,10019,10025,10055,10057,10080,10095,10096,10112,10148,10182,10192,10200,10215,10230,10232,10237,10241,10245,10250,10255,10258,10297,10349,10364,10372,10376,10396,10400,10407,10435,10449,10451,10454,10467,10491,10492,10498,10503,10504,10516,10544,10579,10581,10583,10594,10599,10606,10609,10620,10634,10642,10648,10656,10668,10670,10682,10693,10701,10713,10736,10748,10769,10785,10796,10809,10818,10831,10833,10839,10856,10885,10893,10899,10903,10963,10999,11022,11028,11037,11048,11078,11095,11100,11101,11127,11131,11160,11166,11193,11211,11215,11227,11234,11258,11276,11279,11318,11339,11362,11373,11375,11385,11399,11400,11420,11423,11425,11434,11451,11466,11476,11488,11495,11501,11502,11505,11537,11548,11580,11581,11587,11600,11602,11612,11619,11657,11662,11664,11683,11710,11730,11734,11787,11796,11812,11834,11842,11843,11855,11857,11884,11892,11898,11912,11921,11945,11952,11962,11971,11974,11981,12017,12053,12062,12072,12111,12135,12181,12194,12239,12250,12256,12279,12280,12318,12329,12339,12346,12349,12366,12385,12392,12404,12405,12419,12430,12431,12447,12453,12469,12484,12486,12490,12501,12508,12546,12595,12599,12601,12610,12613,12640,12644,12654,12673,12674,12717,12721] · 2.21 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [128,2107,2196,2485,3234,3218,2194,3231,3224,3229,3222,3237,3226,3225,3221,6135,6205,6180,3228,3235,6306,6437,6554,9161,7109,7306,7038,7217,6519,7746] · 2.06 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.93 ms