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