Elasticsearch
POST /abyhomcom/_search → 200 · 196.7 ms · знайдено 369871, повернуто 8
тіло запиту
{
"query": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
95
]
}
},
{
"term": {
"city_id": 115
}
}
],
"must_not": [
{
"term": {
"id": 219281125
}
}
]
}
},
"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 · 21.2 ms · знайдено 1, повернуто 1
тіло запиту
{
"query": {
"term": {
"id": 219281125
}
},
"size": 1,
"_source": [
"id",
"m2",
"km",
"price2",
"attribute"
]
} POST /abyhomcom/_search → 200 · 1579.1 ms
тіло запиту
{
"size": 0,
"track_total_hits": false,
"aggs": {
"by_cat": {
"filter": {
"bool": {
"filter": [
{
"term": {
"city_id": 115
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "category_id",
"size": 2000
}
}
}
},
"by_city": {
"filter": {
"bool": {
"filter": [
{
"terms": {
"category_id": [
95
]
}
},
{
"terms": {
"city_id": [
2164,
115,
2165,
2166,
2167,
2168,
2434,
2445,
2673,
2674,
2675,
2676,
3078,
3079,
3080,
3081,
3082,
3083,
3084,
3085,
3086,
3087,
3088,
3089,
3090,
3091,
3092,
3093,
3094,
3095,
3096,
3097,
3098,
3099,
3100,
3101,
3102,
3103,
3104,
3105,
3106,
3107,
6100,
6107,
6108,
6115,
6117,
6119,
6127,
6130,
6134,
6137,
6151,
6154,
6162,
6166,
6170,
6174,
6175,
6177,
6187,
6192,
6194,
6199,
6202,
6218,
6226,
6229,
6230,
6231,
6241,
6250,
6253,
6267,
6283,
6294,
6299,
6316,
6320,
6321,
6323,
6326,
6328,
6329,
6331,
6337,
6343,
6360,
6362,
6363,
6364,
6370,
6373,
6377,
6381,
6382,
6397,
6401,
6402,
6413,
6414,
6415,
6416,
6430,
6442,
6444,
6454,
6458,
6461,
6478,
6485,
6505,
6506,
6511,
6541,
6542,
6543,
6551,
6558,
6566,
6571,
6588,
6596,
6598,
6606,
6615,
6618,
6620,
6630,
6632,
6641,
6646,
6648,
6649,
6651,
6667,
6670,
6688,
6689,
6707,
6709,
6713,
6748,
6760,
6762,
6764,
6770,
6778,
6803,
6814,
6822,
6828,
6830,
6843,
6847,
6849,
6860,
6866,
6896,
6900,
6903,
6919,
6930,
6944,
6952,
6964,
6965,
6975,
6978,
6990,
6997,
7012,
7020,
7023,
7039,
7050,
7061,
7063,
7069,
7085,
7106,
7120,
7127,
7128,
7133,
7155,
7168,
7177,
7183,
7184,
7196,
7204,
7221,
7226,
7232,
7235,
7240,
7242,
7246,
7248,
7262,
7278,
7305,
7345,
7371,
7380,
7382,
7395,
7453,
7470,
7472,
7484,
7511,
7539,
7554,
7555,
7570,
7581,
7583,
7585,
7591,
7603,
7606,
7617,
7628,
7635,
7656,
7668,
7672,
7684,
7693,
7703,
7712,
7736,
7739,
7749,
7768,
7770,
7772,
7773,
7790,
7809,
7857,
7871,
7883,
7899,
7930,
7939,
7948,
7950,
7953,
7958,
7961,
7977,
7984,
8013,
8018,
8021,
8027,
8029,
8035,
8040,
8041,
8074,
8081,
8092,
8100,
8127,
8137,
8148,
8158,
8164,
8181,
8186,
8210,
8216,
8217,
8236,
8248,
8284,
8285,
8292,
8293,
8303,
8305,
8331,
8336,
8351,
8356,
8363,
8372,
8375,
8376,
8377,
8385,
8386,
8397,
8525,
8527,
8529,
8531,
8534,
8536,
8558,
8586,
8587,
8590,
8608,
8612,
8614,
8630,
8631,
8639,
8672,
8685,
8688,
8694,
8715,
8729,
8734,
8758,
8781,
8793,
8817,
8820,
8825,
8841,
8844,
8851,
8857,
8876,
8882,
8899,
8900,
8914,
8920,
8932,
8969,
9012,
9026,
9032,
9049,
9055,
9058,
9071,
9073,
9080,
9086,
9098,
9100,
9114,
9115,
9116,
9137,
9158,
9225,
9251,
9258,
9278,
9292,
9293,
9331,
9359,
9399,
9400,
9416,
9439,
9444,
9451,
9461,
9475,
9480,
9481,
9490,
9513,
9524,
9532,
9547,
9557,
9606,
9607,
9617,
9620,
9622,
9626,
9628,
9648,
9667,
9686,
9695,
9721,
9775,
9782,
9793,
9794,
9795,
9836,
9851,
9873,
9875,
9879,
9900,
9928,
9939,
9946,
9956,
9961,
9991,
10015,
10036,
10039,
10046,
10063,
10064,
10073,
10074,
10120,
10156,
10161,
10177,
10235,
10236,
10322,
10357,
10365,
10373,
10398,
10410,
10413,
10429,
10469,
10473,
10484,
10493,
10501,
10530,
10624,
10627,
10655,
10663,
10678,
10684,
10703,
10718,
10727,
10732,
10751,
10755,
10780,
10810,
10816,
10825,
10889,
10897,
10898,
10913,
10930,
10944,
10967,
10977,
10984,
10995,
11012,
11019,
11079,
11159,
11168,
11173,
11190,
11204,
11254,
11282,
11286,
11297,
11343,
11350,
11352,
11398,
11442,
11458,
11465,
11579,
11595,
11618,
11654,
11696,
11711,
11716,
11725,
11728,
11732,
11738,
11794,
11802,
11839,
11859,
11871,
11877,
11879,
11916,
11970,
12193,
12276,
12277,
12289,
12315,
12393,
12396,
12397,
12410,
12421,
12434,
12440,
12442,
12460,
12513,
12517,
12519,
12529,
12577,
12594,
12602,
12615,
12621,
12649,
12694,
12707,
12732
]
}
}
]
}
},
"aggs": {
"t": {
"terms": {
"field": "city_id",
"size": 30
}
}
}
}
}
} SQL
SHOW TABLES · 2.31 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) [219281125] · 3.28 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 [219281125] · 2.42 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) [219554164,219553912,219550111,219549103,219548287,219547822,219547237,219547231] · 1.12 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 [219547231,219547237,219547822,219548287,219549103,219550111,219553912,219554164] · 2.26 ms
SELECT c.* FROM `category` c ORDER BY c.id · 1.77 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 (?) [115] · 1.16 ms
SELECT c.id FROM `city` c WHERE c.parent_id = 0 LIMIT 2 · 1.77 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 (?) [2164] · 1.11 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?) [2164] · 0.6 ms
SELECT c.id FROM `city` c WHERE c.parent_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [115,2165,2166,2167,2168,2434,2445,2673,2674,2675,2676,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,6100,6107,6108,6115,6117,6119,6127,6130,6134,6137,6151,6154,6162,6166,6170,6174,6175,6177,6187,6192,6194,6199,6202,6218,6226,6229,6230,6231,6241,6250,6253,6267,6283,6294,6299,6316,6320,6321,6323,6326,6328,6329,6331,6337,6343,6360,6362,6363,6364,6370,6373,6377,6381,6382,6397,6401,6402,6413,6414,6415,6416,6430,6442,6444,6454,6458,6461,6478,6485,6505,6506,6511,6541,6542,6543,6551,6558,6566,6571,6588,6596,6598,6606,6615,6618,6620,6630,6632,6641,6646,6648,6649,6651,6667,6670,6688,6689,6707,6709,6713,6748,6760,6762,6764,6770,6778,6803,6814,6822,6828,6830,6843,6847,6849,6860,6866,6896,6900,6903,6919,6930,6944,6952,6964,6965,6975,6978,6990,6997,7012,7020,7023,7039,7050,7061,7063,7069,7085,7106,7120,7127,7128,7133,7155,7168,7177,7183,7184,7196,7204,7221,7226,7232,7235,7240,7242,7246,7248,7262,7278,7305,7345,7371,7380,7382,7395,7453,7470,7472,7484,7511,7539,7554,7555,7570,7581,7583,7585,7591,7603,7606,7617,7628,7635,7656,7668,7672,7684,7693,7703,7712,7736,7739,7749,7768,7770,7772,7773,7790,7809,7857,7871,7883,7899,7930,7939,7948,7950,7953,7958,7961,7977,7984,8013,8018,8021,8027,8029,8035,8040,8041,8074,8081,8092,8100,8127,8137,8148,8158,8164,8181,8186,8210,8216,8217,8236,8248,8284,8285,8292,8293,8303,8305,8331,8336,8351,8356,8363,8372,8375,8376,8377,8385,8386,8397,8525,8527,8529,8531,8534,8536,8558,8586,8587,8590,8608,8612,8614,8630,8631,8639,8672,8685,8688,8694,8715,8729,8734,8758,8781,8793,8817,8820,8825,8841,8844,8851,8857,8876,8882,8899,8900,8914,8920,8932,8969,9012,9026,9032,9049,9055,9058,9071,9073,9080,9086,9098,9100,9114,9115,9116,9137,9158,9225,9251,9258,9278,9292,9293,9331,9359,9399,9400,9416,9439,9444,9451,9461,9475,9480,9481,9490,9513,9524,9532,9547,9557,9606,9607,9617,9620,9622,9626,9628,9648,9667,9686,9695,9721,9775,9782,9793,9794,9795,9836,9851,9873,9875,9879,9900,9928,9939,9946,9956,9961,9991,10015,10036,10039,10046,10063,10064,10073,10074,10120,10156,10161,10177,10235,10236,10322,10357,10365,10373,10398,10410,10413,10429,10469,10473,10484,10493,10501,10530,10624,10627,10655,10663,10678,10684,10703,10718,10727,10732,10751,10755,10780,10810,10816,10825,10889,10897,10898,10913,10930,10944,10967,10977,10984,10995,11012,11019,11079,11159,11168,11173,11190,11204,11254,11282,11286,11297,11343,11350,11352,11398,11442,11458,11465,11579,11595,11618,11654,11696,11711,11716,11725,11728,11732,11738,11794,11802,11839,11859,11871,11877,11879,11916,11970,12193,12276,12277,12289,12315,12393,12396,12397,12410,12421,12434,12440,12442,12460,12513,12517,12519,12529,12577,12594,12602,12615,12621,12649,12694,12707,12732] · 2.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.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [115,3092,3083,2434,2165,2167,3085,6137,6151,2166,6154,3079,6130,3087,3088,3106,6253,6166,2445,2673,3082,2168,3084,6187,6170,2674,6294,6192,6218,3089] · 0.83 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.59 ms