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 (328566, 328565, 328563, 328562, 328561, 328560, 328559, 328558, 328556, 328555, 328554, 328553, 328552, 328551, 328550, 328549, 328548, 328547, 328546, 328545, 328544, 328543, 328542, 328541, 328540, 328539, 328538, 328537, 328536, 328535, 328534, 328532, 328531, 328530, 328529, 328527, 328526, 328525, 328523, 328522, 328520, 328519, 328517, 328516, 328515, 328514, 328513, 328512, 328510, 328511, 328509, 328508, 328507, 328506, 328505, 328504, 328503, 328502, 328501, 328500, 328499, 328498, 328497, 328496, 328495, 328494, 328493, 328492, 328491, 328490, 328489, 328488, 328487, 328486, 328485, 328484, 328482, 328480, 328479, 328478, 328477, 328475, 328473, 328472, 328471, 328469, 328468, 328467, 328466, 328464, 328463, 328462, 328461, 328460, 328458, 328457, 328456, 328455, 328454, 328453, 328452, 328451, 328449, 328448, 328447, 328446, 328445, 328444, 328443, 328442, 328441, 328440, 328437, 328434, 328433, 328432, 328431, 328430, 328429, 328428, 328427, 328426, 328425, 328424, 328423, 328422, 328421, 328419, 328418, 328417, 328416, 328415, 328414, 328412, 328411, 328410, 328409, 328408, 328407, 328406, 328405, 328404, 328403, 328402, 328401, 328400, 328399, 328398, 328397, 328396, 328395, 328394, 328393, 328392, 328391, 328390, 328389, 328388, 328387, 328386, 328385, 328384, 328383, 328382, 328381, 328380, 328379, 328378, 328377, 328376, 328375, 328374, 328373, 328372, 328371, 328369, 328370, 328368, 328367, 328366, 328365, 328364, 324864, 328362, 328361, 328360, 328359, 328358, 328357, 328356, 328355, 328354, 328353, 328351, 328350, 328349, 328348, 328347, 328346, 326130)
Run Time: 0.002533
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | qbkdcom_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,qbkdcom_new.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",328566],["thread",328565],["thread",328563],["thread",328562],["thread",328561],["thread",328560],["thread",328559],["thread",328558],["thread",328556],["thread",328555],["thread",328554],["thread",328553],["thread",328552],["thread",328551],["thread",328550],["thread",328549],["thread",328548],["thread",328547],["thread",328546],["thread",328545],["thread",328544],["thread",328543],["thread",328542],["thread",328541],["thread",328540],["thread",328539],["thread",328538],["thread",328537],["thread",328536],["thread",328535],["thread",328534],["thread",328532],["thread",328531],["thread",328530],["thread",328529],["thread",328527],["thread",328526],["thread",328525],["thread",328523],["thread",328522],["thread",328520],["thread",328519],["thread",328517],["thread",328516],["thread",328515],["thread",328514],["thread",328513],["thread",328512],["thread",328510],["thread",328511],["thread",328509],["thread",328508],["thread",328507],["thread",328506],["thread",328505],["thread",328504],["thread",328503],["thread",328502],["thread",328501],["thread",328500],["thread",328499],["thread",328498],["thread",328497],["thread",328496],["thread",328495],["thread",328494],["thread",328493],["thread",328492],["thread",328491],["thread",328490],["thread",328489],["thread",328488],["thread",328487],["thread",328486],["thread",328485],["thread",328484],["thread",328482],["thread",328480],["thread",328479],["thread",328478],["thread",328477],["thread",328475],["thread",328473],["thread",328472],["thread",328471],["thread",328469],["thread",328468],["thread",328467],["thread",328466],["thread",328464],["thread",328463],["thread",328462],["thread",328461],["thread",328460],["thread",328458],["thread",328457],["thread",328456],["thread",328455],["thread",328454],["thread",328453],["thread",328452],["thread",328451],["thread",328449],["thread",328448],["thread",328447],["thread",328446],["thread",328445],["thread",328444],["thread",328443],["thread",328442],["thread",328441],["thread",328440],["thread",328437],["thread",328434],["thread",328433],["thread",328432],["thread",328431],["thread",328430],["thread",328429],["thread",328428],["thread",328427],["thread",328426],["thread",328425],["thread",328424],["thread",328423],["thread",328422],["thread",328421],["thread",328419],["thread",328418],["thread",328417],["thread",328416],["thread",328415],["thread",328414],["thread",328412],["thread",328411],["thread",328410],["thread",328409],["thread",328408],["thread",328407],["thread",328406],["thread",328405],["thread",328404],["thread",328403],["thread",328402],["thread",328401],["thread",328400],["thread",328399],["thread",328398],["thread",328397],["thread",328396],["thread",328395],["thread",328394],["thread",328393],["thread",328392],["thread",328391],["thread",328390],["thread",328389],["thread",328388],["thread",328387],["thread",328386],["thread",328385],["thread",328384],["thread",328383],["thread",328382],["thread",328381],["thread",328380],["thread",328379],["thread",328378],["thread",328377],["thread",328376],["thread",328375],["thread",328374],["thread",328373],["thread",328372],["thread",328371],["thread",328369],["thread",328370],["thread",328368],["thread",328367],["thread",328366],["thread",328365],["thread",328364],["thread",324864],["thread",328362],["thread",328361],["thread",328360],["thread",328359],["thread",328358],["thread",328357],["thread",328356],["thread",328355],["thread",328354],["thread",328353],["thread",328351],["thread",328350],["thread",328349],["thread",328348],["thread",328347],["thread",328346],["thread",326130]], 200, recent-posts, , [], date, 0, , [], 0, 1714403686, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000223