SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000246
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT tag.*
,
0 AS tag_is_watched
FROM `xf_tinhte_xentag_tag` AS tag
WHERE (tag.tag_text = 'học nghề')
Run Time: 0.000624
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 2 | Using index condition |
SELECT *
FROM xf_search
WHERE search_id = ?
Params: 49213037
Run Time: 0.000327
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 53
Run Time: 0.000437
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 53
Run Time: 0.000175
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (9679978, 9679356, 9677489, 9676155, 9675697, 9675696, 9675695, 9675083, 9668638, 9666278, 9666277, 9666276, 9665397, 9665033, 9664992, 9664206, 9663047, 9662387, 9662264, 9661768, 9660206, 9660156, 9660060, 9658326, 9658307, 9658306, 9656866, 9652936, 9649000, 9648818, 9648815, 9647304, 9647074, 9647073, 9646591, 9646590, 9646437, 9646436, 9646258, 9646025, 9645893, 9645749, 9645449, 9645180, 9645005, 9644998, 9644849, 9644835, 9644784, 9644740, 9644660, 9644659, 9644630, 9644550, 9644362, 9644352, 9644169, 9644149, 9644125, 9644095, 9644034, 9643452, 9643261, 9643239, 9643181, 9643156, 9643015, 9642995, 9642845, 9642844, 9642818, 9642553, 9642551, 9642518, 9639478, 9635404, 9635240, 9634840, 9634838, 9634837, 9629822, 9628374, 9627685, 9626736, 9626705, 9626704, 9626504, 9626503, 9626502, 9626501, 9626485, 9626484, 9626467, 9626465, 9623270, 9623266, 9621129, 9621128, 9621126, 9618626, 9617518, 9614366, 9614365, 9614081, 9611195, 9607931, 9607295, 9606842, 9606582, 9605553, 9604613, 9603227, 9602110, 9601084, 9601073, 9601013, 9601012, 9601011, 9600374, 9599651, 9598751, 9598286, 9592468, 9591903, 9591900, 9591337, 9591120, 9591119, 9591118, 9591117, 9591116, 9589093, 9588333, 9588332, 9588331, 9581502, 9580699, 9577229, 9576886, 9571376, 9570415, 9569719, 9569354, 9569353, 9568915, 9568265, 9567995, 9567755, 9566862, 9565726, 9564886, 9564289, 9563450, 9563006, 9562037, 9561478, 9560967, 9559510, 9558586, 9557715, 9557702, 9555571, 9555006, 9552499, 9551948, 9550525, 9550479, 9549615, 9549178, 9549176, 9548999, 9548572, 9548442, 9546607, 9545308, 9544687, 9544087, 9542416, 9539339, 9538652, 9537886, 9537885, 9536265, 9535799, 9532486, 9532485, 9532484, 9532483, 9530886, 9530679, 9528716, 9527137, 9525883, 9520906, 9520846, 9520845, 9518743, 9518524, 9518521, 9518520, 9518204, 9516009, 9515861, 9515859, 9515668, 9515667, 9515234, 9515233, 9512457, 9512456, 9512454, 9512452, 9511823, 9509349, 9509278, 9508407, 9507345, 9507344, 9507179, 9507108, 9506379, 9505760, 9503234, 9500016, 9498876, 9493998, 9491082, 9490289, 9487010, 9485481, 9484973, 9484972, 9483864, 9482998, 9482804, 9482672, 9480057, 9478801, 9477914, 9476023, 9466353, 9466104, 9466103, 9465916, 9465902, 9463856, 9460449, 9460001, 9459293, 9450322, 9448905, 9448096, 9444559, 9444314, 9444313, 9442176, 9431336, 9429346, 9427904, 9427896, 9427884, 9424763, 9422330, 9422326, 9420032, 9412545, 9412544, 9412487, 9411220, 9411219, 9409459, 9406075, 9406057, 9406044, 9406043, 9405490, 9405489, 9403808, 9403807, 9403806, 9403805, 9402265, 9400234, 9400193, 9400175, 9399801, 9398852, 9396853, 9396842, 9396839, 9395992, 9393487, 9391622, 9390980, 9390979, 9390505, 9389454, 9388387, 9386951, 9386020, 9386019, 9386018, 9385772, 9385728, 9385713, 9385237, 9384791, 9383742, 9383741, 9382495, 9382107, 9381397, 9381368, 9380588, 9380587, 9378490, 9378447, 9378446, 9375924, 9375923, 9367260, 9362067, 9361685, 9352608, 9350378, 9349435, 9347757, 9346744, 9346632, 9343023, 9341980, 9341637, 9340825, 9340824, 9340822, 9337456, 9337370, 9335129, 9334372, 9334206, 9334205, 9333235, 9330229, 9328700, 9327349, 9325045, 9324568, 9323770, 9319566, 9319565, 9319034, 9317159, 9316962, 9316241, 9315194, 9315193, 9315192, 9314651, 9314650, 9305619, 9305618, 9301782, 9301780, 9301660, 9300683, 9300005, 9300004, 9299295, 9298991, 9286544, 9285164, 9284300, 9281745, 9281744, 9281743, 9281445, 9281224, 9280828, 9279995, 9279981, 9274854, 9274188, 9272917, 9269670, 9264680, 9258290, 9257802, 9257801, 9250935, 9250920, 9250221, 9249663, 9247521, 9243036, 9243035, 9242520, 9237642, 9236942, 9228395, 9225705, 9223249, 9222594, 9218854, 9218320, 9218053, 9217585, 9215714, 9214825, 9214506, 9214231, 9210877, 9210348, 9208835, 9208812, 9206964, 9200967, 9199914, 9199912, 9199904, 9199900, 9188360, 9185882, 9185431, 9183057, 9177583, 9172054, 9171137, 9170761, 9169241, 9168206, 9168203, 9168200, 9164782, 9164780, 9163707, 9154863, 9154155, 9153703, 9153083, 9151774, 9151267, 9151035, 9149095, 9149080, 9144825, 9142432, 9140396, 9139491, 9139490, 9139489, 9139488, 9138137, 9138136, 9136904, 9129096, 9123747, 9123655, 9123650, 9123645, 9123384, 9123379, 9123373, 9123372, 9123339, 9118945, 9112506, 9112494, 9111638, 9111637, 9111487, 9110469, 9109241, 9108327, 9102884, 9100259, 9096011, 9092816, 9091289, 9091287, 9089073, 9089069, 9087729, 9086945, 9086447, 9084112, 9082361, 9081733, 9080665, 9080664, 9077978, 9077562, 9072455, 9072454, 9069723, 9068367, 9068366, 9062625, 9062623, 9060030, 9057909, 9056755, 9054812, 9054056, 9053200, 9040615, 9029237, 9024312, 9021977, 9020544, 9009804, 9009240, 9007110, 9007109, 9006505, 9006450, 9006449, 9004015, 9003831, 8998430, 8998429, 8993343, 8989414, 8982069, 8977991, 8975324, 8975148, 8975140, 8974906, 8970234, 8969401, 8967995, 8965743, 8965735, 8965729, 8962398, 8962396, 8960609, 8960276, 8960275, 8957244, 8956242, 8955558, 8954993, 8954905, 8953980, 8951053, 8949986, 8949984, 8944056, 8943121, 8943119, 8934226, 8933934, 8933932, 8933441, 8933440, 8930328, 8930166, 8930094, 8928591, 8922208, 8919295, 8919284, 8917773, 8912688, 8912026, 8911987, 8902318, 8894929, 8894252, 8894189, 8894186, 8885757, 8878813, 8878812, 8875957, 8875956, 8874229, 8874227, 8872634, 8872632, 8870088, 8870087, 8868237, 8868226, 8867957, 8867955, 8867827, 8867793, 8867792, 8867791, 8867439, 8861291, 8860975, 8860974, 8860585, 8859114, 8859110, 8859109, 8858602, 8858508, 8858506, 8858505, 8858429, 8858428, 8858325, 8855976, 8853467, 8848521, 8845216, 8838084, 8837526, 8834568, 8830174, 8830173, 8830172, 8830171, 8830170, 8830169, 8830168, 8821060, 8814648, 8814010, 8810707, 8807298, 8805490, 8805489, 8795700, 8795698, 8795639, 8795637, 8793974, 8793973, 8793972, 8793971, 8792380, 8792310, 8792309, 8792291, 8791683, 8790041, 8782798, 8780816, 8779229, 8778232, 8777347, 8776946, 8776944, 8776194, 8771265, 8771260, 8771210, 8770403, 8770401, 8769023, 8763492, 8762802, 8760718, 8760045, 8759646, 8759481, 8758114, 8757226, 8757224, 8752796, 8749343, 8749342, 8749341, 8747852, 8743655, 8743654, 8743652, 8741447, 8737883, 8737881, 8737644, 8736801, 8725422, 8722426, 8722069, 8722068, 8722066, 8722064, 8722062, 8722061, 8722060, 8717219, 8714427, 8714426, 8706503, 8703842, 8702164, 8697653, 8694021, 8693897, 8693744, 8692157, 8685452, 8685406, 8685122, 8683377, 8677651, 8677165, 8677164, 8674680, 8669446, 8669432, 8666979, 8664236, 8664098, 8663791, 8663790, 8661461, 8657955, 8657812, 8657375, 8657374, 8656938, 8656825, 8650967, 8648300, 8644663, 8644354, 8642678, 8641380, 8641172, 8639050, 8639049, 8638027, 8634698, 8634635, 8634634, 8629556, 8625921, 8624275, 8621449, 8621448, 8620304, 8619498, 8614245, 8606564, 8604834, 8603987, 8599858, 8596739, 8596738, 8594168, 8592755, 8592131, 8591223, 8591222, 8591063, 8588766, 8588765, 8588764, 8588762, 8588412, 8587546, 8583558, 8581068, 8580159, 8578014, 8577397, 8575840, 8571092, 8568040, 8564875, 8564376, 8563123, 8562692, 8561826, 8561457, 8560738, 8559829, 8559206, 8554856, 8546248, 8541803, 8540233, 8538733, 8538731, 8538481, 8536619, 8535520, 8534739, 8532921, 8532898, 8531363, 8529410, 8527476, 8527398, 8527148, 8527139, 8527137, 8526601, 8525474, 8420500, 8415272, 8408186, 8314864, 8314863, 8288936, 8281380, 8260155, 8259735, 8259731, 8250928, 8209120, 8196045, 8189541, 8189319, 8188852)
Run Time: 0.019064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 812 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 53
Run Time: 0.003642
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["tinhte_xentag_forum",53],["thread",9679978],["thread",9677489],["thread",9675083],["thread",9668638],["thread",9666278],["thread",9665397],["thread",9665033],["thread",9664992],["thread",9664206],["thread",9663047],["thread",9662387],["thread",9662264],["thread",9661768],["thread",9660206],["thread",9660156],["thread",9660060],["thread",9658326],["thread",9658307],["thread",9656866],["thread",9652936],["thread",9649000],["thread",9648815],["thread",9647304],["thread",9645893],["thread",9645749],["thread",9644849],["thread",9644835],["thread",9644784],["thread",9644660],["thread",9644630],["thread",9644550],["thread",9644169],["thread",9644149],["thread",9643239],["thread",9643181],["thread",9643015],["thread",9642845],["thread",9642553],["thread",9639478],["thread",9635404],["thread",9635240],["thread",9634840],["thread",9629822],["thread",9628374],["thread",9627685],["thread",9626736],["thread",9626705],["thread",9626504],["thread",9626503],["thread",9626502],["thread",9626501],["thread",9626485],["thread",9626484],["thread",9626467],["thread",9626465],["thread",9623270],["thread",9623266],["thread",9621129],["thread",9621126],["thread",9617518],["thread",9614081],["thread",9607931],["thread",9607295],["thread",9606842],["thread",9606582],["thread",9605553],["thread",9604613],["thread",9603227],["thread",9602110],["thread",9601084],["thread",9601013],["thread",9600374],["thread",9599651],["thread",9598751],["thread",9598286],["thread",9591903],["thread",9591900],["thread",9591337],["thread",9580699],["thread",9577229],["thread",9576886],["thread",9570415],["thread",9567755],["thread",9563450],["thread",9561478],["thread",9560967],["thread",9559510],["thread",9558586],["thread",9557715],["thread",9557702],["thread",9555571],["thread",9552499],["thread",9551948],["thread",9550479],["thread",9549178],["thread",9548442],["thread",9536265],["thread",9530886],["thread",9530679],["thread",9527137],["thread",9520906],["thread",9520846],["thread",9518204],["thread",9515861],["thread",9515234],["thread",9512457],["thread",9511823],["thread",9509349],["thread",9509278],["thread",9508407],["thread",9507345],["thread",9507108],["thread",9506379],["thread",9503234],["thread",9500016],["thread",9498876],["thread",9493998],["thread",9491082],["thread",9490289],["thread",9484973],["thread",9484972],["thread",9483864],["thread",9482672],["thread",9480057],["thread",9477914],["thread",9466104],["thread",9465916],["thread",9463856],["thread",9459293],["thread",9450322],["thread",9448096],["thread",9444559],["thread",9431336],["thread",9429346],["thread",9427904],["thread",9427896],["thread",9427884],["thread",9424763],["thread",9422330],["thread",9420032],["thread",9412545],["thread",9412487],["thread",9411220],["thread",9409459],["thread",9406075],["thread",9406057],["thread",9406044],["thread",9403808],["thread",9402265],["thread",9399801],["thread",9398852],["thread",9396853],["thread",9391622],["thread",9390980],["thread",9390505],["thread",9389454],["thread",9388387],["thread",9385772],["thread",9385728],["thread",9385713],["thread",9385237],["thread",9384791],["thread",9381397],["thread",9381368],["thread",9378447],["thread",9362067],["thread",9350378],["thread",9349435],["thread",9346744],["thread",9346632],["thread",9341980],["thread",9340825],["thread",9337370],["thread",9334372],["thread",9334206],["thread",9333235],["thread",9327349],["thread",9324568],["thread",9319034],["thread",9316962],["thread",9314651],["thread",9301782],["thread",9301780],["thread",9300005],["thread",9298991],["thread",9286544],["thread",9285164],["thread",9284300],["thread",9281745],["thread",9280828],["thread",9279995],["thread",9279981],["thread",9274854],["thread",9274188],["thread",9269670],["thread",9264680],["thread",9258290],["thread",9250935],["thread",9250920],["thread",9250221],["thread",9249663],["thread",9247521],["thread",9243036],["thread",9242520],["thread",9237642],["thread",9236942],["thread",9228395],["thread",9223249],["thread",9217585],["thread",9215714],["thread",9214825],["thread",9210877],["thread",9210348],["thread",9208835],["thread",9208812],["thread",9206964],["thread",9199914],["thread",9199912],["thread",9199904],["thread",9199900],["thread",9188360],["thread",9185882],["thread",9185431],["thread",9183057],["thread",9177583],["thread",9170761],["thread",9169241],["thread",9164782],["thread",9163707],["thread",9154863],["thread",9154155],["thread",9153703],["thread",9153083],["thread",9151774],["thread",9142432],["thread",9136904],["thread",9129096],["thread",9123747],["thread",9123655],["thread",9123650],["thread",9123645],["thread",9123384],["thread",9123379],["thread",9123373],["thread",9123372],["thread",9123339],["thread",9118945],["thread",9111638],["thread",9111487],["thread",9110469],["thread",9109241],["thread",9108327],["thread",9100259],["thread",9096011],["thread",9092816],["thread",9091289],["thread",9089073],["thread",9087729],["thread",9086447],["thread",9084112],["thread",9082361],["thread",9080665],["thread",9077978],["thread",9068367],["thread",9062625],["thread",9060030],["thread",9057909],["thread",9054812],["thread",9054056],["thread",9040615],["thread",9029237],["thread",9024312],["thread",9021977],["thread",9020544],["thread",9009804],["thread",9007110],["thread",9006450],["thread",9004015],["thread",8998430],["thread",8989414],["thread",8982069],["thread",8977991],["thread",8975148],["thread",8970234],["thread",8969401],["thread",8967995],["thread",8965743],["thread",8965735],["thread",8965729],["thread",8962398],["thread",8960609],["thread",8960276],["thread",8957244],["thread",8953980],["thread",8934226],["thread",8933441],["thread",8930328],["thread",8930166],["thread",8930094],["thread",8922208],["thread",8919284],["thread",8912026],["thread",8911987],["thread",8894252],["thread",8894189],["thread",8885757],["thread",8878813],["thread",8874229],["thread",8867957],["thread",8860585],["thread",8859110],["thread",8858602],["thread",8858508],["thread",8855976],["thread",8837526],["thread",8821060],["thread",8814648],["thread",8807298],["thread",8793972],["thread",8792380],["thread",8792310],["thread",8792291],["thread",8791683],["thread",8777347],["thread",8776946],["thread",8771265],["thread",8771260],["thread",8760718],["thread",8760045],["thread",8759646],["thread",8759481],["thread",8757226],["thread",8747852],["thread",8737883],["thread",8737644],["thread",8725422],["thread",8722426],["thread",8714427],["thread",8706503],["thread",8703842],["thread",8702164],["thread",8697653],["thread",8694021],["thread",8693897],["thread",8692157],["thread",8685452],["thread",8685122],["thread",8683377],["thread",8677651],["thread",8677165],["thread",8677164],["thread",8669446],["thread",8669432],["thread",8666979],["thread",8664236],["thread",8664098],["thread",8663791],["thread",8661461],["thread",8657955],["thread",8657812],["thread",8657375],["thread",8644663],["thread",8644354],["thread",8642678],["thread",8641380],["thread",8641172],["thread",8634698],["thread",8634635],["thread",8629556],["thread",8624275],["thread",8621449],["thread",8620304],["thread",8619498],["thread",8614245],["thread",8606564],["thread",8604834],["thread",8603987],["thread",8599858],["thread",8594168],["thread",8592755],["thread",8592131],["thread",8591223],["thread",8591063],["thread",8588412],["thread",8587546],["thread",8581068],["thread",8580159],["thread",8577397],["thread",8575840],["thread",8571092],["thread",8564875],["thread",8564376],["thread",8563123],["thread",8562692],["thread",8561457],["thread",8560738],["thread",8559829],["thread",8559206],["thread",8554856],["thread",8546248],["thread",8540233],["thread",8538733],["thread",8538731],["thread",8538481],["thread",8535520],["thread",8532921],["thread",8532898],["thread",8531363],["thread",8529410],["thread",8527476],["thread",8527398],["thread",8527139],["thread",8525474],["thread",8420500],["thread",8408186],["thread",8260155],["thread",8259735],["thread",8209120],["thread",8189541],["thread",8189319],["thread",8188852]], 422, tinhte_xentag_tag, , {"tags":["h\u1ecdc ngh\u1ec1"]}, date, 0, , [], 0, 1656549524, 799c611b59b66ff014b952e37e3028ad
Run Time: 0.001534
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (9617518, 9614081, 9607931, 9607295, 9606842, 9606582, 9605553, 9604613, 9603227, 9602110, 9601084, 9601013, 9600374, 9599651, 9598751, 9598286, 9591903, 9591900, 9591337, 9580699)
Run Time: 0.002709
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 20 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,5s_db1.thread.node_id | 1 | Using where |
INSERT INTO xf_tinhte_xentag_tag_view
(tag_id)
VALUES
(?)
Params: 520504
Run Time: 0.000375
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , Tinhte_XenTag_ControllerPublic_Tag, View, valid, t=h%E1%BB%8Dc+ngh%E1%BB%81&page=4, 1656549524,
Run Time: 0.000519
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000344
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_widget | ALL | | | | | 17 | Using where; Using filesort |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1656548624)
ORDER BY session_activity.view_date DESC
Run Time: 0.003304
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1543 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |