Elasticsearch
POST /abyhomcom/_search → 200 · 70.5 ms · знайдено 48840, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"term": {
"city_id": 129
}
}
],
"must_not": [
{
"term": {
"id": 214165223
}
}
]
}
},
"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 · 13.4 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 214165223
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 530 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 129
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
2
]
}
},
{
"terms": {
"city_id": [
2198,
129,
2944,
3069,
3492,
3493,
3494,
3495,
3496,
3497,
3498,
3499,
3500,
3501,
3502,
3503,
3504,
3505,
6146,
6216,
6225,
6268,
6292,
6359,
6447,
6711,
6765,
6774,
6782,
6848,
6865,
6883,
6906,
6908,
6923,
6985,
7009,
7022,
7027,
7118,
7144,
7174,
7193,
7201,
7223,
7245,
7324,
7340,
7352,
7379,
7393,
7394,
7421,
7450,
7454,
7471,
7505,
7553,
7639,
7653,
7663,
7714,
7726,
7741,
7779,
7785,
7787,
7798,
7833,
7863,
7867,
7881,
7917,
7924,
7926,
7933,
7962,
7963,
8000,
8011,
8083,
8103,
8113,
8117,
8135,
8145,
8154,
8220,
8287,
8296,
8311,
8328,
8352,
8515,
8575,
8640,
8647,
8654,
8661,
8723,
8742,
8789,
8862,
8963,
8995,
8998,
9018,
9025,
9037,
9061,
9062,
9089,
9126,
9252,
9297,
9319,
9322,
9340,
9347,
9350,
9367,
9381,
9387,
9501,
9519,
9543,
9546,
9562,
9585,
9591,
9651,
9658,
9662,
9692,
9697,
9714,
9727,
9763,
9769,
9789,
9841,
9843,
9848,
9867,
9883,
9912,
9917,
9989,
10008,
10031,
10049,
10069,
10119,
10131,
10145,
10149,
10153,
10168,
10173,
10183,
10202,
10284,
10286,
10315,
10319,
10329,
10338,
10358,
10363,
10367,
10391,
10394,
10399,
10405,
10412,
10418,
10431,
10443,
10453,
10457,
10479,
10497,
10550,
10591,
10595,
10602,
10621,
10644,
10653,
10665,
10688,
10695,
10711,
10729,
10739,
10764,
10774,
10777,
10787,
10795,
10819,
10845,
10848,
10884,
10890,
10904,
10932,
10935,
10937,
10952,
10980,
10997,
11002,
11003,
11021,
11040,
11051,
11092,
11113,
11118,
11192,
11259,
11266,
11274,
11281,
11285,
11307,
11322,
11341,
11374,
11380,
11386,
11393,
11406,
11428,
11432,
11484,
11561,
11562,
11568,
11569,
11591,
11726,
11741,
11749,
11789,
11806,
11809,
11836,
11913,
11915,
11929,
11938,
11959,
11996,
12005,
12012,
12014,
12042,
12044,
12045,
12054,
12071,
12094,
12098,
12112,
12138,
12166,
12184,
12216,
12219,
12224,
12241,
12244,
12273,
12325,
12348,
12362,
12373,
12387,
12465,
12477,
12489,
12511,
12527,
12553,
12554,
12573,
12581,
12612,
12619,
12626,
12635,
12639,
12642,
12698,
12714,
12719,
12722
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 5.81 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, ''), NULLIF(c.name_ua, '')) 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) [214165223] · 4.21 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [214165223] · 12.04 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, ''), NULLIF(c.name_ua, '')) 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) [219552730,219552223,219552214,219552187,219552139,219551914,219551629,219551413] · 2.2 ms
SELECT v.post_id, v.attribute_id, v.value, COALESCE(NULLIF(a.name, ''), NULLIF(a.name_ua, '')) 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 [219551413,219551629,219551914,219552139,219552187,219552214,219552223,219552730] · 2.25 ms
SELECT c.* FROM `category` c ORDER BY c.id · 0.68 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?) [129] · 2.59 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 2.97 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?) [2198] · 0.9 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2198] · 0.61 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [129,2944,3069,3492,3493,3494,3495,3496,3497,3498,3499,3500,3501,3502,3503,3504,3505,6146,6216,6225,6268,6292,6359,6447,6711,6765,6774,6782,6848,6865,6883,6906,6908,6923,6985,7009,7022,7027,7118,7144,7174,7193,7201,7223,7245,7324,7340,7352,7379,7393,7394,7421,7450,7454,7471,7505,7553,7639,7653,7663,7714,7726,7741,7779,7785,7787,7798,7833,7863,7867,7881,7917,7924,7926,7933,7962,7963,8000,8011,8083,8103,8113,8117,8135,8145,8154,8220,8287,8296,8311,8328,8352,8515,8575,8640,8647,8654,8661,8723,8742,8789,8862,8963,8995,8998,9018,9025,9037,9061,9062,9089,9126,9252,9297,9319,9322,9340,9347,9350,9367,9381,9387,9501,9519,9543,9546,9562,9585,9591,9651,9658,9662,9692,9697,9714,9727,9763,9769,9789,9841,9843,9848,9867,9883,9912,9917,9989,10008,10031,10049,10069,10119,10131,10145,10149,10153,10168,10173,10183,10202,10284,10286,10315,10319,10329,10338,10358,10363,10367,10391,10394,10399,10405,10412,10418,10431,10443,10453,10457,10479,10497,10550,10591,10595,10602,10621,10644,10653,10665,10688,10695,10711,10729,10739,10764,10774,10777,10787,10795,10819,10845,10848,10884,10890,10904,10932,10935,10937,10952,10980,10997,11002,11003,11021,11040,11051,11092,11113,11118,11192,11259,11266,11274,11281,11285,11307,11322,11341,11374,11380,11386,11393,11406,11428,11432,11484,11561,11562,11568,11569,11591,11726,11741,11749,11789,11806,11809,11836,11913,11915,11929,11938,11959,11996,12005,12012,12014,12042,12044,12045,12054,12071,12094,12098,12112,12138,12166,12184,12216,12219,12224,12241,12244,12273,12325,12348,12362,12373,12387,12465,12477,12489,12511,12527,12553,12554,12573,12581,12612,12619,12626,12635,12639,12642,12698,12714,12719,12722] · 3.3 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [129,3496,3069,3501,3505,3503,3499,6216,3497,3493,3498,3494,3495,6359,6146,6782,10457,7324,6292,7450,7553,8287,6447,6923,7009,7393,6268,7726,7867,6985] · 2.43 ms
SELECT c.id, c.parent_id, c.url AS slug, COALESCE(NULLIF(c.name, ''), NULLIF(c.name_ua, '')) AS name, NULL AS name_loc FROM `city` c WHERE c.parent_id = ? LIMIT 3000 [5] · 3.37 ms
