Elasticsearch
POST /abyhomcom/_search → 200 · 158.7 ms · знайдено 118, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
100
]
}
},
{
"term": {
"city_id": 6371
}
}
],
"must_not": [
{
"term": {
"id": 212181450
}
}
]
}
},
"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 · 73 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 212181450
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 776.7 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 6371
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
100
]
}
},
{
"terms": {
"city_id": [
6059,
6060,
6061,
6062,
6063,
6064,
6065,
6066,
6067,
6068,
6069,
6070,
6071,
6072,
6073,
6074,
6075,
6076,
6077,
6078,
6079,
6080,
6081,
6082,
6099,
6109,
6126,
6207,
6217,
6223,
6258,
6272,
6276,
6301,
6307,
6325,
6327,
6332,
6336,
6371,
6422,
6426,
6433,
6439,
6448,
6474,
6475,
6503,
6504,
6512,
6518,
6520,
6522,
6523,
6536,
6572,
6580,
6592,
6593,
6637,
6640,
6671,
6710,
6772,
6779,
6807,
6840,
6867,
6872,
6892,
6921,
6924,
6940,
6942,
6945,
6981,
6996,
7024,
7037,
7055,
7143,
7145,
7147,
7153,
7161,
7188,
7198,
7206,
7211,
7214,
7216,
7219,
7220,
7253,
7271,
7281,
7331,
7374,
7479,
7509,
7536,
7540,
7545,
7575,
7582,
7598,
7682,
7685,
7696,
7699,
7745,
7818,
7828,
7893,
7906,
7911,
7945,
7969,
7978,
8008,
8042,
8044,
8070,
8096,
8114,
8159,
8170,
8201,
8258,
8279,
8280,
8306,
8321,
8323,
8361,
8388,
8532,
8556,
8593,
8597,
8613,
8635,
8644,
8671,
8751,
8765,
8780,
8782,
8889,
8928,
8946,
8952,
8992,
8997,
9028,
9154,
9166,
9186,
9198,
9213,
9310,
9362,
9383,
9417,
9418,
9430,
9437,
9484,
9504,
9512,
9535,
9538,
9579,
9581,
9582,
9587,
9588,
9612,
9696,
9715,
9772,
9773,
9784,
9941,
9948,
9980,
9983,
10042,
10048,
10052,
10071,
10094,
10115,
10136,
10140,
10197,
10243,
10267,
10268,
10272,
10278,
10293,
10328,
10385,
10409,
10411,
10430,
10480,
10515,
10529,
10542,
10552,
10604,
10635,
10673,
10761,
10781,
10800,
10852,
10871,
10906,
10909,
10953,
10971,
10990,
11128,
11195,
11206,
11228,
11235,
11243,
11260,
11312,
11397,
11401,
11403,
11418,
11443,
11475,
11530,
11555,
11594,
11666,
11697,
11709,
11819,
11844,
11862,
11928,
11957,
12024,
12075,
12105,
12246,
12247,
12291,
12295,
12358,
12406,
12413,
12446,
12457,
12487,
12536,
12583,
12730
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 1.58 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) [212181450] · 1.68 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 [212181450] · 2.56 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) [219369475,219335845,218867309,218516582,218373161,217775635,217396222,217363807] · 3.51 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 [217363807,217396222,217775635,218373161,218516582,218867309,219335845,219369475] · 4.39 ms
SELECT c.* FROM `category` c ORDER BY c.id · 1.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 (?) [6371] · 0.75 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 0.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.id IN (?) [6059] · 0.53 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [6059] · 0.42 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6072,6073,6074,6075,6076,6077,6078,6079,6080,6081,6082,6099,6109,6126,6207,6217,6223,6258,6272,6276,6301,6307,6325,6327,6332,6336,6371,6422,6426,6433,6439,6448,6474,6475,6503,6504,6512,6518,6520,6522,6523,6536,6572,6580,6592,6593,6637,6640,6671,6710,6772,6779,6807,6840,6867,6872,6892,6921,6924,6940,6942,6945,6981,6996,7024,7037,7055,7143,7145,7147,7153,7161,7188,7198,7206,7211,7214,7216,7219,7220,7253,7271,7281,7331,7374,7479,7509,7536,7540,7545,7575,7582,7598,7682,7685,7696,7699,7745,7818,7828,7893,7906,7911,7945,7969,7978,8008,8042,8044,8070,8096,8114,8159,8170,8201,8258,8279,8280,8306,8321,8323,8361,8388,8532,8556,8593,8597,8613,8635,8644,8671,8751,8765,8780,8782,8889,8928,8946,8952,8992,8997,9028,9154,9166,9186,9198,9213,9310,9362,9383,9417,9418,9430,9437,9484,9504,9512,9535,9538,9579,9581,9582,9587,9588,9612,9696,9715,9772,9773,9784,9941,9948,9980,9983,10042,10048,10052,10071,10094,10115,10136,10140,10197,10243,10267,10268,10272,10278,10293,10328,10385,10409,10411,10430,10480,10515,10529,10542,10552,10604,10635,10673,10761,10781,10800,10852,10871,10906,10909,10953,10971,10990,11128,11195,11206,11228,11235,11243,11260,11312,11397,11401,11403,11418,11443,11475,11530,11555,11594,11666,11697,11709,11819,11844,11862,11928,11957,12024,12075,12105,12246,12247,12291,12295,12358,12406,12413,12446,12457,12487,12536,12583,12730] · 3.7 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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [6301,6272,6325,6207,6217,6258,6807,6332,6223,6371,6426,7153,6448,6536,6637,6523,6772,7945,6710,7374,6422,6580,6592,7037,6439,8556,7198,7220,6080,7143] · 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.parent_id = ? LIMIT 3000 [5] · 4.96 ms