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 (185245, 168074, 180965, 42106, 183215, 121278, 184542, 59956, 185174, 164156, 178120, 185241, 179047, 48839, 120287, 158682, 183275, 185149, 119763, 184840, 149713, 120380, 119078, 164674, 165097, 121307, 183427, 182974, 120317, 120769, 60560, 184135, 184965, 175441, 120499, 180329, 157460, 121208, 185013, 182870, 120242, 184916, 120519, 184936, 183476, 179453, 150653, 170088, 162057, 120534, 162552, 184389, 181393, 183213, 163352, 185100, 174391, 185061, 185032, 179368, 176198, 182079, 182368, 101821, 185049, 185269, 148227, 179265, 184957, 185065, 185164, 183337, 185239, 120672, 184321, 18500, 62550, 185273, 185158, 183833, 182910, 178012, 179308, 174404, 46648, 105104, 183454, 184373, 184315, 183088, 184479, 181465, 42889, 54091, 185172, 1656, 162619, 181807, 183481, 120661, 105201, 120357, 174525, 171756, 185274, 118339, 185233, 185262, 182303, 179147, 179911, 145066, 120593, 162541, 84639, 182168, 180316, 113234, 86397, 110910, 178961, 183150, 120999, 120542, 120332, 120458, 100130, 179181, 179359, 174116, 180198, 72104, 181040, 60954, 183445, 184516, 120710, 45919, 120680, 182411, 120423, 115709, 121050, 162049, 65159, 120349, 121087, 120233, 177608, 180771, 143391, 169463, 183194, 169868, 164675, 120772, 160547, 116239, 177478, 183113, 104937, 182985, 173939, 118599, 180797, 175993, 162104, 177292, 120238, 120550, 159319, 185264, 119737, 179418, 120296, 120789, 162101, 120506, 184961, 183195, 181603, 184562, 120497, 159929, 75830, 162023, 94015, 182130, 164580, 178134, 184490, 164640, 59997, 182827, 170171, 160069, 89972, 44033, 177886, 120464)
Run Time: 0.001710
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",185245],["thread",168074],["thread",180965],["thread",42106],["thread",121278],["thread",184542],["thread",59956],["thread",185174],["thread",164156],["thread",178120],["thread",179047],["thread",48839],["thread",120287],["thread",158682],["thread",183275],["thread",184840],["thread",149713],["thread",120380],["thread",119078],["thread",164674],["thread",165097],["thread",121307],["thread",183427],["thread",182974],["thread",120317],["thread",120769],["thread",184135],["thread",175441],["thread",120499],["thread",180329],["thread",157460],["thread",121208],["thread",185013],["thread",120242],["thread",120519],["thread",183476],["thread",179453],["thread",150653],["thread",170088],["thread",162057],["thread",120534],["thread",162552],["thread",184389],["thread",181393],["thread",183213],["thread",163352],["thread",185100],["thread",174391],["thread",179368],["thread",176198],["thread",182079],["thread",182368],["thread",185269],["thread",148227],["thread",184957],["thread",185065],["thread",185164],["thread",183337],["thread",185239],["thread",120672],["thread",184321],["thread",18500],["thread",62550],["thread",185273],["thread",185158],["thread",182910],["thread",179308],["thread",174404],["thread",46648],["thread",183454],["thread",184315],["thread",183088],["thread",184479],["thread",42889],["thread",54091],["thread",185172],["thread",1656],["thread",162619],["thread",181807],["thread",120661],["thread",174525],["thread",171756],["thread",185274],["thread",118339],["thread",185233],["thread",185262],["thread",182303],["thread",179147],["thread",179911],["thread",145066],["thread",162541],["thread",84639],["thread",182168],["thread",180316],["thread",86397],["thread",110910],["thread",178961],["thread",183150],["thread",120999],["thread",120542],["thread",120332],["thread",120458],["thread",179181],["thread",174116],["thread",180198],["thread",72104],["thread",181040],["thread",60954],["thread",183445],["thread",184516],["thread",120710],["thread",45919],["thread",120680],["thread",182411],["thread",120423],["thread",121050],["thread",65159],["thread",120349],["thread",177608],["thread",180771],["thread",143391],["thread",183194],["thread",169868],["thread",160547],["thread",177478],["thread",183113],["thread",104937],["thread",173939],["thread",118599],["thread",180797],["thread",175993],["thread",162104],["thread",177292],["thread",120238],["thread",120550],["thread",159319],["thread",185264],["thread",179418],["thread",120296],["thread",120789],["thread",162101],["thread",120506],["thread",183195],["thread",120497],["thread",75830],["thread",162023],["thread",94015],["thread",178134],["thread",184490],["thread",182827],["thread",170171],["thread",160069],["thread",89972],["thread",44033],["thread",177886],["thread",120464]], 156, recent-posts, , [], date, 0, , [], 0, 1713553256, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000543