Elasticsearch
POST /abyhomcom/_search → 200 · 20.8 ms · знайдено 11, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"term": {
"city_id": 6631
}
}
],
"must_not": [
{
"term": {
"id": 215908273
}
}
]
}
},
"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 · 4.6 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 215908273
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 503.5 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 6631
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"terms": {
"city_id": [
2134,
118,
2104,
2135,
2136,
2138,
2139,
2140,
2142,
2143,
2144,
2145,
2146,
2508,
2509,
2656,
3238,
3239,
3240,
3241,
3242,
3243,
3244,
3245,
3246,
3247,
3248,
3249,
3250,
3251,
3253,
3254,
3255,
3256,
3258,
3259,
3260,
3262,
3263,
3264,
3265,
3266,
3268,
3269,
3619,
3626,
3630,
3633,
3784,
6124,
6155,
6158,
6165,
6169,
6184,
6227,
6260,
6279,
6317,
6341,
6384,
6394,
6408,
6424,
6428,
6482,
6484,
6517,
6525,
6530,
6539,
6575,
6583,
6617,
6631,
6634,
6747,
6777,
6789,
6815,
6839,
6846,
6852,
6857,
6871,
6884,
6980,
7005,
7011,
7032,
7051,
7090,
7104,
7116,
7150,
7151,
7154,
7172,
7180,
7203,
7208,
7302,
7315,
7339,
7401,
7412,
7435,
7442,
7449,
7474,
7518,
7530,
7574,
7586,
7624,
7671,
7715,
7744,
7758,
7806,
7843,
7856,
7861,
7877,
7895,
7896,
7914,
7927,
7960,
7991,
8009,
8037,
8058,
8059,
8086,
8115,
8116,
8132,
8144,
8153,
8188,
8200,
8204,
8265,
8273,
8276,
8313,
8318,
8353,
8398,
8405,
8518,
8533,
8549,
8576,
8584,
8592,
8622,
8641,
8676,
8686,
8756,
8760,
8767,
8821,
8846,
8924,
8936,
8949,
8957,
8985,
9002,
9027,
9039,
9046,
9070,
9094,
9140,
9147,
9191,
9192,
9242,
9412,
9495,
9497,
9506,
9540,
9555,
9580,
9679,
9748,
9811,
9823,
9933,
9977,
10028,
10033,
10051,
10059,
10070,
10076,
10084,
10089,
10092,
10146,
10159,
10167,
10204,
10221,
10227,
10253,
10324,
10337,
10348,
10393,
10395,
10448,
10468,
10472,
10499,
10507,
10521,
10554,
10567,
10586,
10587,
10588,
10608,
10618,
10651,
10709,
10723,
10746,
10782,
10789,
10814,
10864,
10882,
10891,
10902,
11029,
11069,
11116,
11120,
11129,
11134,
11143,
11174,
11216,
11223,
11292,
11293,
11310,
11311,
11323,
11336,
11371,
11396,
11411,
11422,
11527,
11637,
11674,
11699,
11704,
11737,
11767,
11783,
11798,
11799,
11804,
11873,
11919,
11926,
11935,
12030,
12048,
12049,
12076,
12102,
12128,
12192,
12223,
12309,
12326,
12351,
12378,
12391,
12394,
12420,
12424,
12466,
12564,
12596,
12616,
12734
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 3.79 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) [215908273] · 2.53 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 [215908273] · 1.63 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) [215912911,215582802,215554077,214603617,214052328,213191019,210237005,208575973] · 5.76 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 [208575973,210237005,213191019,214052328,214603617,215554077,215582802,215912911] · 11.33 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.84 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 (?) [6631] · 0.52 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 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.id IN (?) [2134] · 0.69 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2134] · 0.43 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [118,2104,2135,2136,2138,2139,2140,2142,2143,2144,2145,2146,2508,2509,2656,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3253,3254,3255,3256,3258,3259,3260,3262,3263,3264,3265,3266,3268,3269,3619,3626,3630,3633,3784,6124,6155,6158,6165,6169,6184,6227,6260,6279,6317,6341,6384,6394,6408,6424,6428,6482,6484,6517,6525,6530,6539,6575,6583,6617,6631,6634,6747,6777,6789,6815,6839,6846,6852,6857,6871,6884,6980,7005,7011,7032,7051,7090,7104,7116,7150,7151,7154,7172,7180,7203,7208,7302,7315,7339,7401,7412,7435,7442,7449,7474,7518,7530,7574,7586,7624,7671,7715,7744,7758,7806,7843,7856,7861,7877,7895,7896,7914,7927,7960,7991,8009,8037,8058,8059,8086,8115,8116,8132,8144,8153,8188,8200,8204,8265,8273,8276,8313,8318,8353,8398,8405,8518,8533,8549,8576,8584,8592,8622,8641,8676,8686,8756,8760,8767,8821,8846,8924,8936,8949,8957,8985,9002,9027,9039,9046,9070,9094,9140,9147,9191,9192,9242,9412,9495,9497,9506,9540,9555,9580,9679,9748,9811,9823,9933,9977,10028,10033,10051,10059,10070,10076,10084,10089,10092,10146,10159,10167,10204,10221,10227,10253,10324,10337,10348,10393,10395,10448,10468,10472,10499,10507,10521,10554,10567,10586,10587,10588,10608,10618,10651,10709,10723,10746,10782,10789,10814,10864,10882,10891,10902,11029,11069,11116,11120,11129,11134,11143,11174,11216,11223,11292,11293,11310,11311,11323,11336,11371,11396,11411,11422,11527,11637,11674,11699,11704,11737,11767,11783,11798,11799,11804,11873,11919,11926,11935,12030,12048,12049,12076,12102,12128,12192,12223,12309,12326,12351,12378,12391,12394,12420,12424,12466,12564,12596,12616,12734] · 2.58 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [2139,2142,3249,2508,2656,7412,7302,6394,6260,7180,6165,6631,6530,8265,7203,7856,3238,6158,6424,8592,8767,6980,7474,7960,9977,11029,2140,6539,6815,7154] · 1.54 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.61 ms