Elasticsearch
POST /abyhomcom/_search → 200 · 58.5 ms · знайдено 24124, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"term": {
"city_id": 138
}
}
],
"must_not": [
{
"term": {
"id": 219482155
}
}
]
}
},
"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 · 44 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 219482155
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 95.2 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 138
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"terms": {
"city_id": [
2216,
138,
2217,
2218,
2711,
3357,
3358,
3359,
3360,
3361,
3362,
3363,
3364,
3365,
3366,
3367,
3368,
3369,
3370,
3371,
3372,
3373,
6163,
6342,
6375,
6418,
6435,
6557,
6692,
6712,
6893,
6913,
6962,
7043,
7062,
7129,
7141,
7159,
7199,
7215,
7230,
7286,
7295,
7318,
7319,
7336,
7351,
7360,
7425,
7431,
7506,
7675,
7702,
7724,
7743,
7761,
7810,
7887,
7905,
7949,
7997,
8112,
8126,
8129,
8166,
8202,
8254,
8345,
8391,
8562,
8570,
8599,
8607,
8624,
8693,
8741,
8766,
8795,
8818,
8829,
8861,
8906,
8917,
8961,
8983,
8987,
9015,
9016,
9033,
9088,
9130,
9132,
9190,
9202,
9212,
9227,
9291,
9302,
9326,
9391,
9413,
9463,
9498,
9536,
9597,
9633,
9644,
9671,
9685,
9712,
9747,
9779,
9881,
9906,
9922,
9959,
9960,
9966,
9970,
10034,
10105,
10117,
10121,
10138,
10179,
10226,
10311,
10318,
10334,
10340,
10341,
10360,
10383,
10384,
10403,
10414,
10427,
10447,
10465,
10477,
10486,
10496,
10560,
10589,
10641,
10679,
10741,
10857,
11010,
11027,
11034,
11053,
11055,
11064,
11066,
11097,
11108,
11111,
11142,
11155,
11177,
11180,
11236,
11241,
11250,
11275,
11280,
11306,
11324,
11329,
11342,
11367,
11455,
11459,
11512,
11520,
11541,
11597,
11604,
11650,
11720,
11727,
11745,
11747,
11814,
11889,
11896,
11910,
11918,
11956,
11989,
12038,
12055,
12137,
12144,
12157,
12160,
12163,
12198,
12206,
12231,
12232,
12287,
12341,
12403,
12408,
12441,
12456,
12506,
12509,
12530,
12541,
12543,
12617,
12659,
12675,
12688,
12695
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 4.3 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) [219482155] · 1.74 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 [219482155] · 1.89 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) [219490072,219490057,219482698,219482500,219482149,219481903,219481372,219481024] · 1.22 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 [219481024,219481372,219481903,219482149,219482500,219482698,219490057,219490072] · 1.8 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.94 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 (?) [138] · 0.65 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.5 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 (?) [2216] · 0.38 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2216] · 0.49 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [138,2217,2218,2711,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,6163,6342,6375,6418,6435,6557,6692,6712,6893,6913,6962,7043,7062,7129,7141,7159,7199,7215,7230,7286,7295,7318,7319,7336,7351,7360,7425,7431,7506,7675,7702,7724,7743,7761,7810,7887,7905,7949,7997,8112,8126,8129,8166,8202,8254,8345,8391,8562,8570,8599,8607,8624,8693,8741,8766,8795,8818,8829,8861,8906,8917,8961,8983,8987,9015,9016,9033,9088,9130,9132,9190,9202,9212,9227,9291,9302,9326,9391,9413,9463,9498,9536,9597,9633,9644,9671,9685,9712,9747,9779,9881,9906,9922,9959,9960,9966,9970,10034,10105,10117,10121,10138,10179,10226,10311,10318,10334,10340,10341,10360,10383,10384,10403,10414,10427,10447,10465,10477,10486,10496,10560,10589,10641,10679,10741,10857,11010,11027,11034,11053,11055,11064,11066,11097,11108,11111,11142,11155,11177,11180,11236,11241,11250,11275,11280,11306,11324,11329,11342,11367,11455,11459,11512,11520,11541,11597,11604,11650,11720,11727,11745,11747,11814,11889,11896,11910,11918,11956,11989,12038,12055,12137,12144,12157,12160,12163,12198,12206,12231,12232,12287,12341,12403,12408,12441,12456,12506,12509,12530,12541,12543,12617,12659,12675,12688,12695] · 2.4 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [138,2218,2217,3361,3360,3365,3373,3369,6163,3366,3371,3372,7043,6893,7743,7318,7215,8166,7199,6435,7336,7431,11034,11342,8129,6962,7159,7761,8391,9922] · 1.82 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.83 ms