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 (184105, 180965, 158420, 184389, 185158, 184840, 174404, 120233, 184490, 176848, 176198, 183476, 53712, 18500, 163275, 170088, 162101, 183833, 120672, 162057, 120634, 149713, 185245, 163219, 103399, 174525, 185013, 120497, 134745, 162580, 182974, 162541, 183275, 185174, 181041, 45919, 183255, 177558, 101821, 185281, 184135, 183481, 182079, 184299, 168074, 183134, 167640, 1656, 184542, 163352, 114291, 182870, 184936, 185280, 185241, 161897, 183427, 164674, 174542, 120593, 159061, 173664, 158682, 182303, 120242, 178012, 185233, 120287, 116239, 179368, 162288, 60560, 121208, 183454, 157460, 162049, 179265, 178961, 120264, 120506, 118929, 175441, 54091, 179047, 113234, 180436, 185065, 184916, 56103, 183386, 182910, 96293, 120668, 59956, 182368, 164156, 181393, 179359, 121307, 185274, 185172, 94015, 185282, 120633, 161347, 137194, 183334, 46078, 120464, 164580, 184676, 179732, 185089, 184479, 181453, 120317, 176869, 185061, 119763, 121278, 120458, 185149, 180316, 184373, 120380, 158919, 120784, 167830, 171756, 163791, 179181, 182561, 120710, 162104, 89972, 181616, 185175, 120318, 160703, 118907, 183043, 121076, 164675, 120653, 120745, 179493, 185164, 176582, 183245, 179494, 120636, 167326, 120772, 120223, 21969, 120550, 183434, 175993, 58838, 177608, 184811, 185269, 159505, 185085, 184961, 158839, 120534, 120542, 119078, 181807, 185100, 46648, 42106, 181603, 162812, 120626, 74, 178197, 171115, 185010, 115709, 185262, 183382, 184538, 166440, 165835, 159000, 162103, 170281, 182274, 106154, 185049, 100130, 131333, 183337, 185279, 184744, 120332, 184957, 185086)
Run Time: 0.001621
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 | themainb_tmb_new.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | themainb_tmb_new.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,themainb_tmb_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",184105],["thread",180965],["thread",158420],["thread",184389],["thread",185158],["thread",184840],["thread",174404],["thread",184490],["thread",176848],["thread",176198],["thread",183476],["thread",53712],["thread",18500],["thread",163275],["thread",170088],["thread",162101],["thread",120672],["thread",162057],["thread",120634],["thread",149713],["thread",185245],["thread",163219],["thread",174525],["thread",185013],["thread",120497],["thread",162580],["thread",182974],["thread",162541],["thread",183275],["thread",185174],["thread",45919],["thread",183255],["thread",177558],["thread",185281],["thread",184135],["thread",182079],["thread",168074],["thread",183134],["thread",1656],["thread",184542],["thread",163352],["thread",114291],["thread",185280],["thread",161897],["thread",183427],["thread",164674],["thread",174542],["thread",173664],["thread",158682],["thread",182303],["thread",120242],["thread",185233],["thread",120287],["thread",179368],["thread",162288],["thread",121208],["thread",183454],["thread",157460],["thread",178961],["thread",120264],["thread",120506],["thread",175441],["thread",54091],["thread",179047],["thread",180436],["thread",185065],["thread",56103],["thread",183386],["thread",182910],["thread",120668],["thread",59956],["thread",182368],["thread",164156],["thread",181393],["thread",121307],["thread",185274],["thread",185172],["thread",94015],["thread",185282],["thread",161347],["thread",137194],["thread",183334],["thread",46078],["thread",120464],["thread",184676],["thread",179732],["thread",184479],["thread",181453],["thread",120317],["thread",176869],["thread",121278],["thread",120458],["thread",180316],["thread",120380],["thread",158919],["thread",120784],["thread",171756],["thread",163791],["thread",179181],["thread",182561],["thread",120710],["thread",162104],["thread",89972],["thread",181616],["thread",185175],["thread",120318],["thread",160703],["thread",118907],["thread",183043],["thread",121076],["thread",120653],["thread",185164],["thread",176582],["thread",183245],["thread",179494],["thread",120636],["thread",167326],["thread",120223],["thread",21969],["thread",120550],["thread",183434],["thread",175993],["thread",58838],["thread",177608],["thread",185269],["thread",185085],["thread",158839],["thread",120534],["thread",120542],["thread",119078],["thread",181807],["thread",185100],["thread",46648],["thread",42106],["thread",162812],["thread",120626],["thread",178197],["thread",185262],["thread",183382],["thread",184538],["thread",170281],["thread",182274],["thread",131333],["thread",183337],["thread",185279],["thread",184744],["thread",120332],["thread",184957]], 148, recent-posts, , [], date, 0, , [], 0, 1713988967, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000653