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 (9694803, 9692763, 9692597, 9692146, 9686424, 9685959, 9684990, 9684989, 9684351, 9681298, 9678845, 9677325, 9675785, 9674550, 9672566, 9659909, 9659552, 9657758, 9657757, 9650233, 9648033, 9644984, 9644983, 9644531, 9644133, 9644061, 9643573, 9642983, 9642948, 9641099, 9640891, 9636932, 9636469, 9634635, 9633933, 9633737, 9632972, 9629707, 9629706, 9627517, 9627516, 9627515, 9627514, 9627184, 9626133, 9625566, 9625536, 9625355, 9624776, 9624284, 9623601, 9623410, 9623144, 9623143, 9622831, 9622410, 9622075, 9621810, 9621528, 9620822, 9620799, 9620579, 9620243, 9619786, 9619362, 9618935, 9618737, 9618573, 9618518, 9617265, 9615960, 9615321, 9615144, 9613044, 9610540, 9608710, 9608381, 9608181, 9607899, 9607444, 9606942, 9606939, 9605945, 9605807, 9605802, 9604111, 9604011, 9603762, 9603731, 9603401, 9599818, 9596672, 9595822, 9595821, 9589774, 9587926, 9586467, 9586466, 9586465, 9585575, 9584937, 9584936, 9579555, 9578259, 9578258, 9578159, 9577172, 9577171, 9577169, 9575535, 9575009, 9568788, 9565185, 9565181, 9555874, 9555452, 9554676, 9553867, 9552333, 9547995, 9547275, 9547273, 9546020, 9545597, 9544798, 9543878, 9542987, 9541858, 9532707, 9532627, 9526226, 9524198, 9524197, 9524196, 9522032, 9522018, 9521721, 9521717, 9521713, 9521712, 9521598, 9521593, 9521580, 9521574, 9521570, 9521160, 9521157, 9521144, 9520787, 9520780, 9520777, 9518855, 9518850, 9518841, 9518837, 9518835, 9518832, 9518381, 9518375, 9518366, 9518363, 9518350, 9517930, 9517921, 9517916, 9517750, 9517738, 9517729, 9517714, 9498080, 9498079, 9490992, 9490990, 9490943, 9490927, 9490897, 9490190, 9489195, 9489167, 9489135, 9489110, 9489080, 9489013, 9489012, 9485287, 9485286, 9485283, 9484551, 9477257, 9472465, 9472462, 9472461, 9472460, 9458326, 9458324, 9458323, 9458322, 9455124, 9446661, 9438893, 9437492, 9436255, 9436254, 9433799, 9433259, 9428076, 9417085, 9413601, 9410233, 9410229, 9409947, 9409946, 9394889, 9386948, 9386947, 9378405, 9374543, 9373389, 9369488, 9342070, 9324418, 9324417, 9324416, 9323482, 9321993, 9314318, 9302011, 9289426, 9289105, 9289088, 9289080, 9288475, 9288449, 9288448, 9288082, 9288076, 9288075, 9282876, 9277531, 9268015, 9259705, 9259704, 9252335, 9251719, 9250003, 9242028, 9216194, 9198226, 9196655, 9195899, 9195897, 9195041, 9192305, 9191962, 9191931, 9191214, 9184644, 9153799, 9153798, 9135880, 9121402, 9121401, 9119899, 9111159, 9109030, 9109028, 9108482, 9103026, 9094727, 9090119, 9087115, 9085432, 9041290, 9035571, 9035570, 9022376, 9006468, 8947888, 8947848, 8943023, 8939198, 8939197, 8936819, 8928762, 8928761, 8928747, 8928738, 8917982, 8917980, 8912879, 8912867, 8912850, 8912843, 8912832, 8912825, 8912823, 8912808, 8912799, 8909638, 8908890, 8908581, 8908048, 8906778, 8904662, 8904029, 8903836, 8903067, 8902141, 8901076, 8901065, 8896566, 8893552, 8893550, 8893477, 8891097, 8888548, 8887039, 8886367, 8886365, 8886296, 8875168, 8870118, 8870116, 8804561, 8789155, 8776034, 8775925, 8746133, 8746128, 8730778, 8725346, 8718178, 8662142, 8658223, 8630951, 8622565, 8617830, 8617305, 8609913, 8591378, 8590294, 8586201, 8548668, 8484831, 8476172, 8476171, 8449801, 8449085, 8404540, 8256360, 8253762, 8228933, 8201013, 8179710, 8032928, 8023845, 7929380, 7924826, 7817226, 7695835, 7608236, 7565639, 7449591, 7300435, 7136864, 6895564)
Run Time: 0.009494
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 366 | 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_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",159],["thread",9694803],["thread",9692763],["thread",9692597],["thread",9684990],["thread",9684989],["thread",9684351],["thread",9678845],["thread",9677325],["thread",9672566],["thread",9659909],["thread",9659552],["thread",9650233],["thread",9648033],["thread",9644984],["thread",9644133],["thread",9644061],["thread",9643573],["thread",9642948],["thread",9641099],["thread",9640891],["thread",9629707],["thread",9627517],["thread",9627184],["thread",9625536],["thread",9624776],["thread",9623144],["thread",9621810],["thread",9621528],["thread",9620822],["thread",9618573],["thread",9618518],["thread",9608710],["thread",9606942],["thread",9606939],["thread",9605945],["thread",9605807],["thread",9605802],["thread",9599818],["thread",9596672],["thread",9595822],["thread",9589774],["thread",9587926],["thread",9586467],["thread",9585575],["thread",9584937],["thread",9579555],["thread",9578259],["thread",9578159],["thread",9577172],["thread",9575535],["thread",9575009],["thread",9568788],["thread",9565185],["thread",9565181],["thread",9555874],["thread",9555452],["thread",9554676],["thread",9553867],["thread",9552333],["thread",9547995],["thread",9546020],["thread",9545597],["thread",9544798],["thread",9543878],["thread",9542987],["thread",9541858],["thread",9532707],["thread",9532627],["thread",9526226],["thread",9522032],["thread",9522018],["thread",9521721],["thread",9521717],["thread",9521713],["thread",9521712],["thread",9521598],["thread",9521593],["thread",9521580],["thread",9521574],["thread",9521570],["thread",9521160],["thread",9521157],["thread",9521144],["thread",9520787],["thread",9520780],["thread",9520777],["thread",9518855],["thread",9518850],["thread",9518841],["thread",9518837],["thread",9518835],["thread",9518832],["thread",9518381],["thread",9518375],["thread",9518366],["thread",9518363],["thread",9518350],["thread",9517930],["thread",9517921],["thread",9517916],["thread",9517750],["thread",9517738],["thread",9517729],["thread",9517714],["thread",9498080],["thread",9490992],["thread",9490943],["thread",9490927],["thread",9490897],["thread",9490190],["thread",9489195],["thread",9489167],["thread",9489135],["thread",9489110],["thread",9489080],["thread",9489013],["thread",9485287],["thread",9485286],["thread",9485283],["thread",9484551],["thread",9477257],["thread",9472462],["thread",9458326],["thread",9446661],["thread",9438893],["thread",9437492],["thread",9436255],["thread",9433799],["thread",9433259],["thread",9428076],["thread",9417085],["thread",9413601],["thread",9410233],["thread",9409947],["thread",9394889],["thread",9386948],["thread",9374543],["thread",9373389],["thread",9369488],["thread",9342070],["thread",9324418],["thread",9321993],["thread",9314318],["thread",9302011],["thread",9289426],["thread",9289105],["thread",9289088],["thread",9289080],["thread",9288475],["thread",9288449],["thread",9288082],["thread",9288076],["thread",9277531],["thread",9268015],["thread",9251719],["thread",9250003],["thread",9242028],["thread",9216194],["thread",9198226],["thread",9196655],["thread",9195899],["thread",9195041],["thread",9192305],["thread",9109030],["thread",9094727],["thread",9090119],["thread",9087115],["thread",9041290],["thread",9035571],["thread",9035570],["thread",9022376],["thread",8939198],["thread",8936819],["thread",8912879],["thread",8912843],["thread",8912799],["thread",8909638],["thread",8908890],["thread",8908048],["thread",8906778],["thread",8903836],["thread",8903067],["thread",8901076],["thread",8901065],["thread",8896566],["thread",8893552],["thread",8893477],["thread",8891097],["thread",8888548],["thread",8887039],["thread",8875168],["thread",8870118],["thread",8804561],["thread",8776034],["thread",8775925],["thread",8662142],["thread",8658223],["thread",8617830],["thread",8617305],["thread",8609913],["thread",8591378],["thread",8590294],["thread",8586201],["thread",8548668],["thread",8476172],["thread",8449801],["thread",8449085],["thread",8404540],["thread",8256360],["thread",8253762],["thread",8228933],["thread",8201013],["thread",8179710],["thread",8032928],["thread",8023845],["thread",7929380],["thread",7817226],["thread",7608236],["thread",7565639],["thread",7449591],["thread",7300435],["thread",7136864]], 223, tinhte_xentag_tag, , {"tags":["s\u1eeda t\u1ee7 l\u1ea1nh t\u1ea1i nh\u00e0"]}, date, 0, , [], 0, 1660138105, ba4dd209faab5979ac0f5cea6d2e4e00
Run Time: 0.000603