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 (184542, 170088, 168074, 184936, 185174, 176198, 185245, 162049, 184957, 183337, 185061, 184389, 162101, 120672, 120593, 149713, 164675, 183386, 60560, 183476, 185086, 184373, 183427, 120626, 174404, 53771, 121278, 183833, 181393, 116239, 174525, 185066, 119763, 181807, 185279, 185241, 120233, 164674, 182974, 120242, 131333, 185010, 185055, 120542, 166440, 184479, 120534, 179047, 181963, 184840, 177292, 159505, 65950, 119078, 180436, 180316, 18500, 120287, 182079, 163620, 175441, 89972, 179368, 168239, 185172, 162541, 118929, 184490, 179494, 162812, 134745, 180965, 120506, 179359, 120523, 162103, 162057, 180654, 121208, 185175, 120259, 183275, 181465, 185270, 181635, 183481, 176582, 158839, 185065, 170281, 121155, 184961, 185049, 120497, 179418, 168564, 179308, 179265, 120380, 42106, 178012, 185158, 74, 185278, 177608, 120772, 120550, 120653, 185100, 118599, 164156, 120332, 185013, 120223, 179147, 183213, 120318, 158682, 183334, 161347, 183382, 120499, 185085, 115709, 170694, 183150, 177391, 159061, 113234, 120636, 72104, 181603, 123737, 100130, 37311, 181080, 184135, 185262, 120661, 182910, 181041, 182303, 183457, 184299, 53394, 97277, 118907, 46648, 121055, 185275, 182052, 105482, 185266, 179181, 164013, 120860, 171756, 121307, 169868, 185149, 160703, 164640, 129282, 120967, 183621, 165835, 1656, 157460, 179732, 159319, 121073, 185277, 184916, 119737, 157453, 33483, 120692, 164984, 83333, 185269, 120999, 120634, 110910, 173864, 184066, 168565, 182411, 114291, 59395, 120641, 163468, 182870, 54091, 120633, 121087, 183053, 121076, 181368, 55092, 183454)
Run Time: 0.001630
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",184542],["thread",170088],["thread",168074],["thread",185174],["thread",176198],["thread",185245],["thread",184957],["thread",183337],["thread",184389],["thread",162101],["thread",120672],["thread",149713],["thread",183386],["thread",183476],["thread",183427],["thread",120626],["thread",174404],["thread",53771],["thread",121278],["thread",181393],["thread",174525],["thread",185066],["thread",181807],["thread",185279],["thread",164674],["thread",182974],["thread",120242],["thread",131333],["thread",185055],["thread",120542],["thread",184479],["thread",120534],["thread",179047],["thread",184840],["thread",177292],["thread",119078],["thread",180436],["thread",180316],["thread",18500],["thread",120287],["thread",182079],["thread",163620],["thread",175441],["thread",89972],["thread",179368],["thread",168239],["thread",185172],["thread",162541],["thread",184490],["thread",179494],["thread",162812],["thread",180965],["thread",120506],["thread",120523],["thread",162057],["thread",180654],["thread",121208],["thread",185175],["thread",120259],["thread",183275],["thread",185270],["thread",181635],["thread",176582],["thread",158839],["thread",185065],["thread",170281],["thread",121155],["thread",120497],["thread",179418],["thread",168564],["thread",179308],["thread",120380],["thread",42106],["thread",185158],["thread",177608],["thread",120550],["thread",120653],["thread",185100],["thread",118599],["thread",164156],["thread",120332],["thread",185013],["thread",120223],["thread",179147],["thread",183213],["thread",120318],["thread",158682],["thread",183334],["thread",161347],["thread",183382],["thread",120499],["thread",185085],["thread",170694],["thread",183150],["thread",177391],["thread",120636],["thread",72104],["thread",123737],["thread",37311],["thread",181080],["thread",184135],["thread",185262],["thread",120661],["thread",182910],["thread",182303],["thread",53394],["thread",97277],["thread",118907],["thread",46648],["thread",121055],["thread",185275],["thread",182052],["thread",105482],["thread",185266],["thread",179181],["thread",120860],["thread",171756],["thread",121307],["thread",169868],["thread",160703],["thread",129282],["thread",120967],["thread",183621],["thread",1656],["thread",157460],["thread",179732],["thread",159319],["thread",185277],["thread",157453],["thread",33483],["thread",120692],["thread",164984],["thread",83333],["thread",185269],["thread",120999],["thread",120634],["thread",110910],["thread",173864],["thread",184066],["thread",168565],["thread",182411],["thread",114291],["thread",59395],["thread",163468],["thread",54091],["thread",183053],["thread",121076],["thread",55092],["thread",183454]], 149, recent-posts, , [], date, 0, , [], 0, 1713892643, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000571