SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000222
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 = 'balo nam')
Run Time: 0.000463
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | tag | ref | tag_text | tag_text | 302 | const | 1 | Using index condition |
SELECT *
FROM xf_search
WHERE search_id = ?
Params: 45562034
Run Time: 0.000291
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: 97
Run Time: 0.000933
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, 97
Run Time: 0.002685
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 (10007667, 10002824, 9993560, 9993559, 9962796, 9936088, 9934158, 9934148, 9934147, 9927226, 9922925, 9922924, 9915497, 9908584, 9907274, 9903995, 9882442, 9880278, 9880270, 9875285, 9870112, 9868396, 9859735, 9859734, 9853207, 9853157, 9853135, 9850934, 9850933, 9850932, 9814342, 9805134, 9786784, 9716658, 9708454, 9708452, 9708046, 9696784, 9680062, 9680061, 9680060, 9678654, 9676807, 9676058, 9674987, 9660667, 9659460, 9659050, 9659049, 9659048, 9659045, 9646937, 9646828, 9646824, 9646814, 9646809, 9643552, 9643539, 9643538, 9643135, 9641811, 9640524, 9628849, 9626262, 9624857, 9624163, 9622151, 9621432, 9620696, 9620555, 9620117, 9620116, 9620036, 9619648, 9616951, 9615799, 9615178, 9613579, 9613254, 9611977, 9611022, 9610676, 9610671, 9610369, 9609694, 9609080, 9607993, 9606986, 9606275, 9605993, 9605901, 9604754, 9604753, 9603483, 9602557, 9602555, 9600086, 9598543, 9595908, 9595145, 9583119, 9583118, 9582355, 9582352, 9582349, 9570791, 9564772, 9559880, 9559879, 9556125, 9556124, 9556123, 9556122, 9556121, 9556120, 9556119, 9555190, 9550116, 9544240, 9544238, 9540220, 9539487, 9536545, 9535889, 9535713, 9534855, 9532624, 9530953, 9530952, 9530882, 9530764, 9530763, 9530223, 9525064, 9524712, 9514654, 9514648, 9514647, 9514646, 9510474, 9509846, 9498648, 9487226, 9486466, 9486463, 9481763, 9470784, 9470775, 9470773, 9470732, 9470397, 9470352, 9469315, 9469176, 9464825, 9461191, 9461190, 9457961, 9457959, 9447866, 9444235, 9444140, 9437154, 9437152, 9436583, 9433559, 9433347, 9428477, 9427338, 9426404, 9426403, 9425045, 9421173, 9421172, 9419282, 9419280, 9417916, 9415667, 9413711, 9411115, 9408681, 9408680, 9408567, 9408566, 9408133, 9406936, 9406073, 9404177, 9403280, 9402993, 9400559, 9399114, 9391379, 9386081, 9382519, 9382506, 9381547, 9380835, 9380834, 9380833, 9374365, 9374364, 9373449, 9373447, 9373444, 9373443, 9373428, 9371616, 9366404, 9363010, 9363009, 9362291, 9356981, 9351740, 9351465, 9351461, 9345168, 9345023, 9345022, 9343151, 9343142, 9339826, 9339503, 9337002, 9336847, 9336846, 9336635, 9336633, 9336632, 9330904, 9330224, 9329077, 9325871, 9323407, 9320488, 9320487, 9319911, 9319873, 9318413, 9317093, 9314986, 9314985, 9314563, 9311967, 9306955, 9306153, 9305862, 9303162, 9303161, 9301068, 9297984, 9297983, 9297507, 9296359, 9294378, 9293739, 9291606, 9291605, 9288368, 9286539, 9276124, 9268814, 9267113, 9267112, 9267111, 9265171, 9264761, 9264704, 9261100, 9257697, 9257696, 9255893, 9254845, 9254044, 9249593, 9249592, 9249591, 9249590, 9249588, 9249582, 9249580, 9246356, 9246354, 9246347, 9244401, 9242878, 9242713, 9240618, 9240115, 9239014, 9238263, 9234253, 9234252, 9231865, 9231864, 9228761, 9228568, 9228363, 9228362, 9226267, 9226266, 9221999, 9221924, 9219216, 9214077, 9214076, 9213558, 9213556, 9209729, 9205230, 9204858, 9204659, 9204272, 9204267, 9204259, 9204255, 9204245, 9200719, 9200511, 9200510, 9199487, 9199486, 9196781, 9196780, 9194818, 9190144, 9190143, 9185854, 9185622, 9185281, 9179784, 9179783, 9178444, 9178046, 9177441, 9175595, 9174731, 9174728, 9174727, 9174478, 9173955, 9173954, 9172368, 9172366, 9168086, 9168085, 9167131, 9167130, 9167129, 9165152, 9162712, 9162019, 9160676, 9160674, 9158338, 9152465, 9147158, 9139450, 9139449, 9139447, 9138830, 9135278, 9133455, 9133089, 9129905, 9129904, 9129290, 9129289, 9124534, 9124533, 9124531, 9113810, 9109841, 9109840, 9105016, 9097804, 9095192, 9089553, 9089122, 9089121, 9083871, 9083838, 9080188, 9080186, 9078950, 9078012, 9078011, 9076301, 9076134, 9076133, 9075722, 9067747, 9067540, 9067416, 9067401, 9067346, 9067299, 9065614, 9065568, 9065567, 9065511, 9065510, 9065488, 9065459, 9065458, 9065422, 9063881, 9062113, 9058327, 9051460, 9048823, 9048822, 9036547, 9036546, 9029218, 9028085, 9026559, 9026558, 9025588, 9025586, 9025569, 9025568, 9022976, 9020046, 9016309, 9014285, 9014002, 9012441, 9011418, 9008465, 9007305, 9006345, 9005097, 9005068, 9005067, 9004522, 9004269, 9004268, 9001934, 9000180, 8998276, 8996315, 8996314, 8994228, 8994227, 8992607, 8990101, 8990100, 8989520, 8987791, 8984416, 8984292, 8981814, 8980955, 8980381, 8979793, 8979476, 8975806, 8974068, 8969518, 8962290, 8961098, 8958636, 8956919, 8956232, 8953138, 8953137, 8950573, 8949993, 8949992, 8947279, 8947227, 8947226, 8946813, 8945775, 8944517, 8944516, 8943169, 8942014, 8941526, 8941525, 8941524, 8939235, 8939233, 8937594, 8932758, 8932757, 8932755, 8932753, 8932474, 8930087, 8930086, 8928845, 8928844, 8926793, 8926790, 8923770, 8923577, 8922920, 8920495, 8916313, 8916273, 8916272, 8915357, 8913353, 8913272, 8913269, 8912313, 8911744, 8911395, 8910374, 8909841, 8907824, 8907595, 8907164, 8906084, 8906083, 8905786, 8905641, 8905640, 8905620, 8905418, 8901396, 8901386, 8901385, 8900269, 8900268, 8900266, 8896783, 8896780, 8895463, 8890925, 8890458, 8890457, 8890159, 8890091, 8890090, 8889583, 8889573, 8889571, 8889566, 8889565, 8889563, 8889561, 8889410, 8888444, 8888253, 8888248, 8888247, 8888246, 8888245, 8887656, 8883896, 8883528, 8883527, 8882683, 8881154, 8875783, 8875782, 8874744, 8874390, 8872207, 8871535, 8871107, 8871104, 8871039, 8870389, 8870381, 8868549, 8868547, 8867533, 8865324, 8865252, 8864383, 8855915, 8855913, 8855777, 8854695, 8851152, 8849720, 8849719, 8849145, 8849144, 8849096, 8848755, 8846358, 8846357, 8846244, 8844092, 8842047, 8842046, 8842044, 8842043, 8841983, 8834887, 8833396, 8831933, 8831918, 8828020, 8827997, 8826946, 8826942, 8820152, 8819965, 8819964, 8816734, 8810441, 8810126, 8810125, 8809819, 8809818, 8809533, 8809188, 8807143, 8807139, 8805336, 8798721, 8796780, 8796744, 8796591, 8796578, 8796551, 8796511, 8795951, 8795727, 8795721, 8787703, 8786698, 8785980, 8785103, 8785102, 8784061, 8784036, 8784035, 8778617, 8778613, 8778254, 8775102, 8775099, 8774658, 8772494, 8767531, 8766984, 8766983, 8766982, 8765874, 8763466, 8763463, 8762226, 8761472, 8761471, 8761244, 8760347, 8758857, 8758856, 8757930, 8757837, 8757326, 8757324, 8756869, 8756457, 8756378, 8755682, 8753313, 8752236, 8750709, 8750708, 8750707, 8747634, 8747598, 8747550, 8747351, 8746996, 8746995, 8746980, 8736559, 8736402, 8736264, 8736263, 8734360, 8731527, 8730863, 8729623, 8728664, 8728408, 8728407, 8725433, 8723885, 8723029, 8723027, 8723026, 8720498, 8720345, 8720344, 8720218, 8718020, 8718019, 8715165, 8710385, 8710384, 8709743, 8709252, 8708396, 8708197, 8706156, 8706155, 8705446, 8702808, 8701368, 8697598, 8696110, 8696107, 8692136, 8691271, 8683227, 8679250, 8678049, 8678043, 8677157, 8676110, 8673968, 8673340, 8672861, 8672859, 8668260, 8664656, 8662425, 8661733, 8661134, 8655549, 8653997, 8651902, 8650524, 8650523, 8648509, 8648291, 8643410, 8637287, 8636960, 8636863, 8636081, 8635914, 8635441, 8635077, 8635050, 8628777, 8626570, 8624103, 8624101, 8623402, 8619006, 8619005, 8616888, 8616887, 8616564, 8616562, 8611943, 8611689, 8611083, 8611069, 8609057, 8608871, 8608868, 8603663, 8601729, 8599598, 8598359, 8597645, 8597419, 8596645, 8595597, 8590918, 8590908, 8587304, 8586273, 8581446, 8579609, 8579587, 8575155, 8575153, 8572890, 8572091, 8572090, 8570059, 8570057, 8570056, 8570054, 8567875, 8567873, 8567851, 8567517, 8566733, 8566732, 8566513, 8563500, 8563339, 8562844, 8562746, 8561295, 8559936, 8559935, 8559394, 8559392, 8557809, 8557752, 8557618, 8554558, 8554541, 8549119, 8547891, 8547770, 8547072, 8544485, 8544482, 8544481, 8543112, 8543072, 8538172, 8538170, 8533979, 8533743, 8527328, 8526787, 8526786, 8521413, 8521411, 8521410, 8510588, 8509439, 8505185, 8496371, 8450487, 8450236, 8449172, 8449163, 8449156, 8449150, 8447629, 8439909, 8439316, 8439142, 8431087, 8430160, 8428961, 8428050, 8427893, 8425969, 8412560, 8412553, 8408829, 8396173, 8377740, 8369774, 8369698, 8369665, 8368353, 8340699, 8328304, 8326974, 8322480, 8312034, 8283819, 8283697, 8248787, 8248288, 8247871, 8243396, 8236607, 8227558, 8227556, 8227540, 8227539, 8223967, 8223048, 8222372, 8222244, 8222189, 8221027, 8213545, 8207253, 8206022, 8205935, 8205921, 8205916, 8205871, 8205870, 8204775, 8204700, 8204699, 8204687, 8204675, 8204238, 8203403, 8202481, 8199704, 8183481, 8182502, 8168165, 8165936, 8165449, 8165445, 8165435, 8069184, 7516273)
Run Time: 0.020038
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 904 | 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: 97
Run Time: 0.000685
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",97],["thread",10007667],["thread",10002824],["thread",9993560],["thread",9962796],["thread",9936088],["thread",9934158],["thread",9934148],["thread",9927226],["thread",9922925],["thread",9922924],["thread",9908584],["thread",9903995],["thread",9882442],["thread",9880278],["thread",9880270],["thread",9875285],["thread",9870112],["thread",9868396],["thread",9859735],["thread",9859734],["thread",9853207],["thread",9853157],["thread",9853135],["thread",9850934],["thread",9814342],["thread",9805134],["thread",9786784],["thread",9708452],["thread",9696784],["thread",9680062],["thread",9680061],["thread",9678654],["thread",9674987],["thread",9660667],["thread",9659460],["thread",9646937],["thread",9646828],["thread",9646824],["thread",9646814],["thread",9646809],["thread",9643552],["thread",9643539],["thread",9643538],["thread",9640524],["thread",9628849],["thread",9626262],["thread",9624857],["thread",9624163],["thread",9622151],["thread",9621432],["thread",9620696],["thread",9620036],["thread",9616951],["thread",9615799],["thread",9615178],["thread",9613579],["thread",9613254],["thread",9611022],["thread",9610676],["thread",9610369],["thread",9609694],["thread",9609080],["thread",9607993],["thread",9606986],["thread",9606275],["thread",9605901],["thread",9595145],["thread",9583119],["thread",9582355],["thread",9582352],["thread",9570791],["thread",9556125],["thread",9556124],["thread",9556123],["thread",9556122],["thread",9556121],["thread",9556120],["thread",9555190],["thread",9544240],["thread",9539487],["thread",9536545],["thread",9535889],["thread",9535713],["thread",9530953],["thread",9530223],["thread",9524712],["thread",9514654],["thread",9514648],["thread",9510474],["thread",9498648],["thread",9486466],["thread",9481763],["thread",9461191],["thread",9457961],["thread",9447866],["thread",9444235],["thread",9433559],["thread",9428477],["thread",9426404],["thread",9425045],["thread",9417916],["thread",9413711],["thread",9408681],["thread",9408567],["thread",9408133],["thread",9406936],["thread",9404177],["thread",9402993],["thread",9386081],["thread",9382519],["thread",9382506],["thread",9381547],["thread",9373449],["thread",9373447],["thread",9373444],["thread",9373443],["thread",9373428],["thread",9363010],["thread",9362291],["thread",9351740],["thread",9351465],["thread",9351461],["thread",9345023],["thread",9343151],["thread",9343142],["thread",9339826],["thread",9336847],["thread",9330904],["thread",9329077],["thread",9325871],["thread",9323407],["thread",9320488],["thread",9319873],["thread",9318413],["thread",9317093],["thread",9314986],["thread",9314563],["thread",9306955],["thread",9305862],["thread",9303162],["thread",9297984],["thread",9296359],["thread",9294378],["thread",9293739],["thread",9286539],["thread",9267113],["thread",9255893],["thread",9246356],["thread",9242713],["thread",9240618],["thread",9240115],["thread",9231865],["thread",9228363],["thread",9221999],["thread",9209729],["thread",9204858],["thread",9200511],["thread",9199487],["thread",9196781],["thread",9194818],["thread",9190144],["thread",9185854],["thread",9179784],["thread",9177441],["thread",9175595],["thread",9174731],["thread",9174728],["thread",9173955],["thread",9167131],["thread",9165152],["thread",9162712],["thread",9162019],["thread",9135278],["thread",9133455],["thread",9129905],["thread",9129290],["thread",9097804],["thread",9095192],["thread",9089122],["thread",9083871],["thread",9078012],["thread",9076301],["thread",9076134],["thread",9067416],["thread",9067401],["thread",9067346],["thread",9067299],["thread",9065614],["thread",9065568],["thread",9065511],["thread",9065488],["thread",9065459],["thread",9065422],["thread",9063881],["thread",9062113],["thread",9058327],["thread",9051460],["thread",9029218],["thread",9025569],["thread",9020046],["thread",9016309],["thread",9005097],["thread",9004269],["thread",8996315],["thread",8994228],["thread",8990101],["thread",8987791],["thread",8984416],["thread",8984292],["thread",8980955],["thread",8980381],["thread",8979793],["thread",8975806],["thread",8974068],["thread",8962290],["thread",8958636],["thread",8956919],["thread",8953138],["thread",8950573],["thread",8949993],["thread",8946813],["thread",8945775],["thread",8944517],["thread",8941526],["thread",8939235],["thread",8937594],["thread",8932758],["thread",8932755],["thread",8932753],["thread",8930087],["thread",8928845],["thread",8922920],["thread",8916273],["thread",8915357],["thread",8913272],["thread",8912313],["thread",8906084],["thread",8905418],["thread",8896783],["thread",8895463],["thread",8890458],["thread",8890159],["thread",8890091],["thread",8888444],["thread",8883528],["thread",8882683],["thread",8871535],["thread",8871104],["thread",8871039],["thread",8870381],["thread",8867533],["thread",8855777],["thread",8854695],["thread",8851152],["thread",8849720],["thread",8849145],["thread",8849096],["thread",8848755],["thread",8846358],["thread",8844092],["thread",8834887],["thread",8826946],["thread",8826942],["thread",8820152],["thread",8819965],["thread",8816734],["thread",8810126],["thread",8809188],["thread",8805336],["thread",8796780],["thread",8796744],["thread",8796578],["thread",8796551],["thread",8796511],["thread",8787703],["thread",8786698],["thread",8784061],["thread",8784036],["thread",8778254],["thread",8772494],["thread",8767531],["thread",8765874],["thread",8761472],["thread",8761244],["thread",8760347],["thread",8757326],["thread",8753313],["thread",8750709],["thread",8747634],["thread",8747550],["thread",8747351],["thread",8746996],["thread",8746980],["thread",8736264],["thread",8734360],["thread",8730863],["thread",8729623],["thread",8728664],["thread",8728408],["thread",8723885],["thread",8723029],["thread",8720498],["thread",8718020],["thread",8709743],["thread",8709252],["thread",8706156],["thread",8702808],["thread",8697598],["thread",8696110],["thread",8692136],["thread",8691271],["thread",8683227],["thread",8679250],["thread",8678049],["thread",8678043],["thread",8676110],["thread",8668260],["thread",8664656],["thread",8662425],["thread",8661733],["thread",8661134],["thread",8655549],["thread",8653997],["thread",8651902],["thread",8648509],["thread",8648291],["thread",8636960],["thread",8636863],["thread",8636081],["thread",8635914],["thread",8635050],["thread",8628777],["thread",8626570],["thread",8624103],["thread",8623402],["thread",8619006],["thread",8616564],["thread",8611943],["thread",8611689],["thread",8611083],["thread",8611069],["thread",8601729],["thread",8599598],["thread",8597419],["thread",8596645],["thread",8595597],["thread",8590918],["thread",8590908],["thread",8587304],["thread",8579609],["thread",8579587],["thread",8572890],["thread",8570059],["thread",8567875],["thread",8566733],["thread",8566513],["thread",8563500],["thread",8562844],["thread",8562746],["thread",8561295],["thread",8559936],["thread",8559394],["thread",8557809],["thread",8557752],["thread",8557618],["thread",8554558],["thread",8554541],["thread",8549119],["thread",8547770],["thread",8547072],["thread",8543112],["thread",8533979],["thread",8527328],["thread",8521413],["thread",8505185],["thread",8496371],["thread",8450487],["thread",8450236],["thread",8449172],["thread",8449163],["thread",8449156],["thread",8449150],["thread",8447629],["thread",8439909],["thread",8439316],["thread",8439142],["thread",8431087],["thread",8428961],["thread",8427893],["thread",8425969],["thread",8412553],["thread",8408829],["thread",8396173],["thread",8377740],["thread",8369774],["thread",8369698],["thread",8369665],["thread",8368353],["thread",8340699],["thread",8326974],["thread",8312034],["thread",8283819],["thread",8283697],["thread",8248787],["thread",8248288],["thread",8243396],["thread",8236607],["thread",8227558],["thread",8227556],["thread",8227540],["thread",8223967],["thread",8223048],["thread",8222372],["thread",8222244],["thread",8222189],["thread",8221027],["thread",8213545],["thread",8206022],["thread",8205921],["thread",8205916],["thread",8203403],["thread",8202481],["thread",8183481],["thread",8165449],["thread",8069184],["thread",7516273]], 427, tinhte_xentag_tag, , {"tags":["balo nam"]}, date, 0, , [], 0, 1717352049, af0f884d4a7a348a2aa0d21179f601df
Run Time: 0.000794
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 (9351740, 9351465, 9351461, 9345023, 9343151, 9343142, 9339826, 9336847, 9330904, 9329077, 9325871, 9323407, 9320488, 9319873, 9318413, 9317093, 9314986, 9314563, 9306955, 9305862)
Run Time: 0.001717
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: 520131
Run Time: 0.000272
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, tv, tv, Tinhte_XenTag_ControllerPublic_Tag, View, valid, t=balo+nam&page=7, 1717352049,
Run Time: 0.000295
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000229
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 > 1717351149)
ORDER BY session_activity.view_date DESC
Run Time: 0.005406
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | ALL | view_date | | | | 1828 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 5s_db1.session_activity.user_id | 1 | |