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 (180329, 42106, 182974, 18500, 183150, 121278, 168074, 184840, 120999, 145066, 120542, 185233, 120332, 1656, 182303, 164674, 120458, 170088, 185274, 100130, 183454, 179181, 48839, 163352, 120672, 181393, 185174, 162057, 184965, 174391, 181465, 184542, 185262, 179359, 179911, 148227, 42889, 185172, 183427, 158682, 174116, 180198, 175441, 72104, 118339, 184936, 86397, 183275, 184389, 181040, 60954, 183445, 184516, 183476, 120710, 45919, 174404, 120661, 184957, 120680, 182411, 120423, 185061, 185241, 185100, 185049, 115709, 119763, 183481, 178012, 182368, 121050, 185245, 178961, 120317, 182079, 162049, 176198, 119078, 65159, 120349, 120380, 121087, 184135, 120233, 177608, 165097, 180771, 143391, 169463, 180316, 162552, 183194, 169868, 120357, 164675, 120772, 160547, 116239, 177478, 183113, 179047, 104937, 182985, 184916, 185273, 171756, 173939, 118599, 60560, 180797, 175993, 162104, 185013, 177292, 120238, 120550, 179265, 159319, 185264, 185269, 119737, 179418, 120296, 183337, 120789, 162101, 179368, 120506, 182870, 184961, 183195, 181603, 184373, 184562, 121208, 162541, 164156, 179147, 120242, 182910, 121307, 149713, 184479, 120497, 159929, 75830, 162023, 185149, 94015, 181807, 182130, 164580, 178134, 183833, 184490, 164640, 59997, 59956, 182827, 170171, 160069, 89972, 44033, 177886, 120464, 103399, 120653, 118929, 174525, 97277, 180965, 185085, 118907, 120633, 101821, 177159, 181041, 175909, 120659, 178082, 181368, 185065, 120499, 184299, 180483, 185272, 120769, 111730, 164806, 134745, 157460, 162535, 158493, 185055, 185010, 74, 160703, 179732, 161897)
Run Time: 0.000424
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",180329],["thread",42106],["thread",182974],["thread",18500],["thread",183150],["thread",121278],["thread",168074],["thread",184840],["thread",120999],["thread",145066],["thread",120542],["thread",185233],["thread",120332],["thread",1656],["thread",182303],["thread",164674],["thread",120458],["thread",170088],["thread",185274],["thread",183454],["thread",179181],["thread",48839],["thread",163352],["thread",120672],["thread",181393],["thread",185174],["thread",162057],["thread",174391],["thread",184542],["thread",185262],["thread",179911],["thread",148227],["thread",42889],["thread",185172],["thread",183427],["thread",158682],["thread",174116],["thread",180198],["thread",175441],["thread",72104],["thread",118339],["thread",86397],["thread",183275],["thread",184389],["thread",181040],["thread",60954],["thread",183445],["thread",184516],["thread",183476],["thread",120710],["thread",45919],["thread",174404],["thread",120661],["thread",184957],["thread",120680],["thread",182411],["thread",120423],["thread",185100],["thread",182368],["thread",121050],["thread",185245],["thread",178961],["thread",120317],["thread",182079],["thread",176198],["thread",119078],["thread",65159],["thread",120349],["thread",120380],["thread",184135],["thread",177608],["thread",165097],["thread",180771],["thread",143391],["thread",180316],["thread",162552],["thread",183194],["thread",169868],["thread",160547],["thread",177478],["thread",183113],["thread",179047],["thread",104937],["thread",185273],["thread",171756],["thread",173939],["thread",118599],["thread",180797],["thread",175993],["thread",162104],["thread",185013],["thread",177292],["thread",120238],["thread",120550],["thread",159319],["thread",185264],["thread",185269],["thread",179418],["thread",120296],["thread",183337],["thread",120789],["thread",162101],["thread",179368],["thread",120506],["thread",183195],["thread",121208],["thread",162541],["thread",164156],["thread",179147],["thread",120242],["thread",182910],["thread",121307],["thread",149713],["thread",184479],["thread",120497],["thread",75830],["thread",162023],["thread",94015],["thread",181807],["thread",178134],["thread",184490],["thread",59956],["thread",182827],["thread",170171],["thread",160069],["thread",89972],["thread",44033],["thread",177886],["thread",120464],["thread",120653],["thread",174525],["thread",97277],["thread",180965],["thread",185085],["thread",118907],["thread",177159],["thread",175909],["thread",120659],["thread",178082],["thread",185065],["thread",120499],["thread",180483],["thread",185272],["thread",120769],["thread",111730],["thread",164806],["thread",157460],["thread",162535],["thread",158493],["thread",185055],["thread",160703],["thread",179732],["thread",161897]], 153, recent-posts, , [], date, 0, , [], 0, 1713518103, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000562