SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
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_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 (25520, 25519, 25518, 25517, 25516, 25515, 25514, 6853, 4027, 25513, 25512, 25511, 25510, 25509, 25508, 25507, 25506, 25505, 25504, 25503, 25502, 25501, 25500, 25499, 25498, 25497, 25490, 25489, 25488, 25487, 25486, 25485, 25484, 25483, 25482, 25481, 25480, 25479, 25478, 25477, 25476, 25475, 25474, 25473, 25472, 25471, 25470, 25469, 25468, 25467, 25466, 25465, 25464, 25463, 25462, 25461, 25460, 25459, 25458, 25457, 25456, 25455, 25454, 25453, 25452, 25451, 25450, 25449, 25448, 25447, 25446, 25445, 25444, 25443, 25442, 25441, 25440, 25439, 25438, 25437, 25436, 25435, 25434, 25433, 25432, 25431, 25430, 25429, 25428, 25427, 25426, 25425, 25424, 25423, 25422, 25421, 25420, 25419, 25418, 25417, 25416, 25415, 25414, 25413, 25412, 25411, 25410, 25409, 25408, 25407, 25406, 25405, 25404, 25403, 25402, 25401, 25400, 25399, 25398, 25397, 25396, 25395, 25394, 25393, 25392, 25391, 25390, 25389, 25388, 25387, 25386, 25385, 25384, 25383, 25382, 25381, 25380, 25379, 25378, 25377, 25376, 25375, 25374, 25373, 25372, 25371, 25370, 25369, 25368, 25367, 25366, 25365, 25364, 25363, 25362, 25361, 25360, 25359, 25358, 25357, 25356, 25355, 25354, 25353, 25352, 25351, 25350, 25349, 25348, 25347, 25346, 25345, 25344, 25343, 25342, 25341, 25340, 25339, 25338, 25337, 25336, 25335, 25334, 25333, 25332, 25331, 25330, 25329, 25328, 25327, 25326, 25325, 25324, 25323, 25322, 25321, 25320, 25319, 25318, 25317, 25316, 25315, 25314, 25313, 25312, 25311, 25310, 25309, 25308, 25307, 25306, 25305, 25304, 25303, 25302, 25301, 25300, 25299, 25298, 25297, 25296, 25295, 25294, 25290, 25289, 25288, 25287, 25286, 25285, 25284, 25283, 25282, 25281, 25280, 25279, 25278, 25277, 25276, 25275, 25274, 25273, 25272, 25271, 25270, 25269, 25268, 25267, 25266, 25265, 25264, 25263, 25262, 25261, 25260, 25259, 25258, 25257, 25256, 25255, 25254, 25253, 25252, 25251, 25250, 25249, 25248, 25247, 25246, 25245, 25244, 25243, 25242, 25241, 25240, 25239, 25238, 25237, 25236, 25235, 25234, 25233, 25232, 25231, 25230)
Run Time: 0.004887
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 284 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dien7104_tailieu.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: [["thread",25520],["thread",25519],["thread",25518],["thread",25517],["thread",25516],["thread",25515],["thread",25514],["thread",6853],["thread",25513],["thread",25512],["thread",25511],["thread",25510],["thread",25509],["thread",25508],["thread",25507],["thread",25506],["thread",25505],["thread",25504],["thread",25503],["thread",25500],["thread",25499],["thread",25498],["thread",25497],["thread",25490],["thread",25489],["thread",25488],["thread",25487],["thread",25486],["thread",25485],["thread",25484],["thread",25483],["thread",25482],["thread",25481],["thread",25480],["thread",25479],["thread",25478],["thread",25477],["thread",25476],["thread",25475],["thread",25474],["thread",25473],["thread",25472],["thread",25471],["thread",25470],["thread",25469],["thread",25468],["thread",25467],["thread",25466],["thread",25465],["thread",25464],["thread",25463],["thread",25462],["thread",25461],["thread",25460],["thread",25459],["thread",25458],["thread",25457],["thread",25456],["thread",25455],["thread",25454],["thread",25453],["thread",25452],["thread",25451],["thread",25450],["thread",25449],["thread",25448],["thread",25447],["thread",25446],["thread",25445],["thread",25444],["thread",25443],["thread",25442],["thread",25441],["thread",25440],["thread",25439],["thread",25438],["thread",25437],["thread",25436],["thread",25435],["thread",25434],["thread",25433],["thread",25432],["thread",25431],["thread",25430],["thread",25429],["thread",25428],["thread",25427],["thread",25426],["thread",25425],["thread",25424],["thread",25423],["thread",25422],["thread",25421],["thread",25420],["thread",25419],["thread",25418],["thread",25417],["thread",25416],["thread",25415],["thread",25414],["thread",25413],["thread",25412],["thread",25411],["thread",25410],["thread",25409],["thread",25408],["thread",25407],["thread",25406],["thread",25405],["thread",25404],["thread",25403],["thread",25402],["thread",25401],["thread",25400],["thread",25399],["thread",25398],["thread",25397],["thread",25396],["thread",25395],["thread",25394],["thread",25393],["thread",25392],["thread",25391],["thread",25390],["thread",25389],["thread",25388],["thread",25387],["thread",25386],["thread",25385],["thread",25384],["thread",25383],["thread",25382],["thread",25381],["thread",25380],["thread",25379],["thread",25378],["thread",25377],["thread",25376],["thread",25375],["thread",25374],["thread",25373],["thread",25372],["thread",25371],["thread",25370],["thread",25369],["thread",25368],["thread",25367],["thread",25366],["thread",25365],["thread",25364],["thread",25363],["thread",25362],["thread",25361],["thread",25360],["thread",25359],["thread",25358],["thread",25357],["thread",25356],["thread",25355],["thread",25354],["thread",25353],["thread",25352],["thread",25351],["thread",25350],["thread",25349],["thread",25348],["thread",25347],["thread",25346],["thread",25345],["thread",25344],["thread",25343],["thread",25342],["thread",25341],["thread",25340],["thread",25339],["thread",25338],["thread",25337],["thread",25336],["thread",25335],["thread",25334],["thread",25333],["thread",25332],["thread",25331],["thread",25330],["thread",25329],["thread",25328],["thread",25327],["thread",25326],["thread",25325],["thread",25324],["thread",25323],["thread",25322],["thread",25321],["thread",25320],["thread",25319],["thread",25318],["thread",25317],["thread",25316],["thread",25315],["thread",25314],["thread",25313],["thread",25312],["thread",25311],["thread",25310],["thread",25309],["thread",25308],["thread",25307],["thread",25306],["thread",25305],["thread",25304],["thread",25303],["thread",25302],["thread",25301],["thread",25300],["thread",25299],["thread",25298],["thread",25297],["thread",25296],["thread",25295],["thread",25294],["thread",25290],["thread",25289],["thread",25288],["thread",25287],["thread",25286],["thread",25285],["thread",25284],["thread",25283],["thread",25282],["thread",25281],["thread",25280],["thread",25279],["thread",25278],["thread",25277],["thread",25276],["thread",25275],["thread",25274],["thread",25273],["thread",25272],["thread",25271],["thread",25270],["thread",25269],["thread",25268],["thread",25267],["thread",25266],["thread",25265],["thread",25264],["thread",25263],["thread",25262],["thread",25261],["thread",25260],["thread",25259],["thread",25258],["thread",25257],["thread",25256],["thread",25255],["thread",25254],["thread",25253],["thread",25252],["thread",25251],["thread",25250],["thread",25249],["thread",25248],["thread",25247],["thread",25246],["thread",25245],["thread",25244],["thread",25243],["thread",25242],["thread",25241],["thread",25240],["thread",25239],["thread",25238],["thread",25237],["thread",25236],["thread",25235],["thread",25234],["thread",25233],["thread",25232],["thread",25231],["thread",25230]], 281, recent-posts, , [], date, 0, , [], 0, 1714544417, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.002582