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 (183476, 184542, 185231, 170088, 101821, 120223, 161897, 181603, 181080, 18500, 175260, 174067, 48839, 121012, 120534, 185248, 179494, 168293, 183150, 180965, 184135, 184840, 181807, 183144, 162101, 185172, 183275, 53394, 46221, 134745, 183427, 185032, 174404, 120506, 165097, 120233, 154397, 185140, 185241, 60114, 185061, 184345, 55092, 184299, 181525, 105201, 100130, 183245, 120653, 120337, 175441, 120321, 184490, 120680, 168074, 158682, 59395, 113234, 179181, 120550, 120318, 164674, 185049, 184479, 179265, 113766, 179732, 185113, 164522, 111616, 185086, 45919, 96293, 184894, 149713, 185242, 184389, 159732, 183833, 185174, 183218, 167665, 162057, 182910, 159929, 185247, 182706, 120380, 72104, 70592, 174525, 120589, 164640, 183481, 171756, 162535, 172423, 164156, 120593, 182303, 37311, 179652, 150653, 185164, 115709, 46648, 89972, 121073, 182974, 114370, 185189, 168185, 182827, 185245, 169799, 100603, 167949, 183420, 185089, 157460, 120772, 168109, 118907, 120542, 1656, 120672, 181691, 181744, 110889, 184380, 185239, 162049, 120332, 184046, 165546, 179368, 162541, 182079, 185065, 184961, 182366, 184451, 182251, 185233, 161114, 175993, 185228, 120242, 177159, 169868, 179875, 120519, 120692, 120423, 181608, 185246, 82310, 168565, 183194, 120661, 129282, 163791, 181393, 181635, 163352, 121307, 120317, 120305, 185237, 143391, 131333, 120349, 170281, 181465, 179418, 116239, 181688, 42106, 118599, 163219, 137194, 176198, 120287, 120357, 185243, 120458, 179047, 185014, 182020, 42730, 171115, 164675, 184936, 182368, 183454, 121278, 120358, 183043, 183989, 167483)
Run Time: 0.001584
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",183476],["thread",184542],["thread",185231],["thread",170088],["thread",120223],["thread",161897],["thread",181080],["thread",18500],["thread",175260],["thread",48839],["thread",121012],["thread",120534],["thread",185248],["thread",179494],["thread",168293],["thread",183150],["thread",180965],["thread",184135],["thread",184840],["thread",181807],["thread",162101],["thread",185172],["thread",183275],["thread",53394],["thread",46221],["thread",183427],["thread",174404],["thread",120506],["thread",165097],["thread",185140],["thread",184345],["thread",55092],["thread",181525],["thread",183245],["thread",120653],["thread",120337],["thread",175441],["thread",120321],["thread",184490],["thread",120680],["thread",168074],["thread",158682],["thread",59395],["thread",179181],["thread",120550],["thread",120318],["thread",164674],["thread",184479],["thread",113766],["thread",179732],["thread",185113],["thread",164522],["thread",111616],["thread",45919],["thread",184894],["thread",149713],["thread",185242],["thread",184389],["thread",159732],["thread",185174],["thread",183218],["thread",167665],["thread",162057],["thread",182910],["thread",185247],["thread",182706],["thread",120380],["thread",72104],["thread",70592],["thread",174525],["thread",120589],["thread",171756],["thread",162535],["thread",172423],["thread",164156],["thread",182303],["thread",37311],["thread",179652],["thread",150653],["thread",185164],["thread",46648],["thread",89972],["thread",182974],["thread",114370],["thread",185189],["thread",168185],["thread",182827],["thread",185245],["thread",169799],["thread",100603],["thread",183420],["thread",157460],["thread",168109],["thread",118907],["thread",120542],["thread",1656],["thread",120672],["thread",181691],["thread",181744],["thread",110889],["thread",184380],["thread",185239],["thread",120332],["thread",184046],["thread",165546],["thread",179368],["thread",162541],["thread",182079],["thread",185065],["thread",182366],["thread",184451],["thread",185233],["thread",161114],["thread",175993],["thread",185228],["thread",120242],["thread",177159],["thread",169868],["thread",179875],["thread",120519],["thread",120692],["thread",120423],["thread",181608],["thread",185246],["thread",168565],["thread",183194],["thread",120661],["thread",129282],["thread",163791],["thread",181393],["thread",181635],["thread",163352],["thread",121307],["thread",120317],["thread",120305],["thread",185237],["thread",143391],["thread",131333],["thread",120349],["thread",170281],["thread",179418],["thread",181688],["thread",42106],["thread",118599],["thread",163219],["thread",137194],["thread",176198],["thread",120287],["thread",185243],["thread",120458],["thread",179047],["thread",185014],["thread",182020],["thread",42730],["thread",182368],["thread",183454],["thread",121278],["thread",120358],["thread",183043],["thread",183989],["thread",167483]], 161, recent-posts, , [], date, 0, , [], 0, 1711673656, 33d9f6025f582b3ef32bd337677090fe
Run Time: 0.000786