SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache,
pr_cache.rating_cache,
privacy.snog_flag_view
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_post AS post ON
(post.post_id = thread.first_post_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)
left join dark_postrating_post_cache pr_cache ON (thread.first_post_id = pr_cache.post_id)
LEFT JOIN xf_user_privacy AS privacy ON
(privacy.user_id = thread.user_id)
WHERE thread.thread_id IN (7758, 7757, 7756, 7723, 7722, 7721, 7720, 7700, 7696, 7692, 7691, 7686, 7667, 7663, 7657, 7656, 7650, 7645, 7639, 7638, 7635, 7633, 7632, 7629, 7620, 7612, 7611, 7609, 7608, 7598, 7578, 7577, 7576, 7574, 7571, 7554, 7553, 7552, 7551, 7542, 7538, 7533, 7532, 7526, 7515, 7514, 7507, 7505, 7497, 7467, 7458, 7453, 7435, 7433, 7430, 7424, 7422, 7407, 7397, 7388, 7383, 7382, 7374, 7370, 7363, 7358, 7356, 7352, 7351, 7349, 7345, 7340, 7336, 7334, 7329, 7312, 7308, 7303, 7302, 7301, 7293, 7288, 7287, 7274, 7272, 7270, 7268, 7267, 7256, 7254, 7253, 7247, 7246, 7245, 7227, 7219, 7218, 7208, 7192, 7189, 7181, 7180, 7175, 7174, 7168, 7130, 7129, 7125, 7118, 7094, 7089, 7083, 7081, 7073, 7072, 7063, 7059, 7054, 7043, 7042, 7041, 7037, 7035, 7021, 7012, 7003, 7002, 6983, 6965, 6961, 6959, 6956, 6951, 6950, 6931, 6928, 6927, 6919, 6911, 6905, 6896, 6887, 6881, 6880, 6868, 6864, 6854, 6852, 6845, 6844, 6830, 6829, 6819, 6815, 6809, 6808, 6804, 6803, 6798, 6761, 6759, 6757, 6755, 6725, 6720, 6698, 6662, 6661, 6648, 6630, 6622, 6612, 6603, 6573, 6572, 6549, 6519, 6496, 6491, 6489, 6461, 6448, 6435, 6434, 6421, 6393, 6390, 6389, 6388, 6378, 6371, 6366, 6359, 6337, 6323, 6322, 6321, 6316, 6298, 6296)
Run Time: 0.003791
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 | sculptan_base.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sculptan_base.thread.node_id | 1 | Using where |
SIMPLE | pr_cache | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.thread.first_post_id | 1 | |
SIMPLE | privacy | eq_ref | PRIMARY | PRIMARY | 4 | sculptan_base.thread.user_id | 1 | |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 57, 0, 1711727782, 1711731382, [["thread",7758],["thread",7757],["thread",7756],["thread",7723],["thread",7722],["thread",7721],["thread",7720],["thread",7700],["thread",7696],["thread",7692],["thread",7691],["thread",7686],["thread",7667],["thread",7663],["thread",7657],["thread",7656],["thread",7650],["thread",7645],["thread",7639],["thread",7638],["thread",7635],["thread",7633],["thread",7632],["thread",7629],["thread",7620],["thread",7612],["thread",7611],["thread",7609],["thread",7608],["thread",7598],["thread",7578],["thread",7577],["thread",7576],["thread",7574],["thread",7571],["thread",7554],["thread",7553],["thread",7552],["thread",7551],["thread",7542],["thread",7538],["thread",7533],["thread",7532],["thread",7526],["thread",7515],["thread",7514],["thread",7507],["thread",7505],["thread",7497],["thread",7467],["thread",7458],["thread",7453],["thread",7435],["thread",7433],["thread",7430],["thread",7424],["thread",7422],["thread",7407],["thread",7397],["thread",7388],["thread",7383],["thread",7382],["thread",7374],["thread",7370],["thread",7363],["thread",7358],["thread",7356],["thread",7352],["thread",7351],["thread",7349],["thread",7345],["thread",7340],["thread",7336],["thread",7334],["thread",7329],["thread",7312],["thread",7308],["thread",7303],["thread",7302],["thread",7301],["thread",7293],["thread",7288],["thread",7287],["thread",7274],["thread",7272],["thread",7270],["thread",7268],["thread",7267],["thread",7256],["thread",7254],["thread",7253],["thread",7247],["thread",7246],["thread",7245],["thread",7227],["thread",7219],["thread",7218],["thread",7208],["thread",7192],["thread",7189],["thread",7181],["thread",7180],["thread",7175],["thread",7174],["thread",7168],["thread",7130],["thread",7129],["thread",7125],["thread",7118],["thread",7094],["thread",7089],["thread",7083],["thread",7081],["thread",7073],["thread",7072],["thread",7063],["thread",7059],["thread",7054],["thread",7043],["thread",7042],["thread",7041],["thread",7037],["thread",7035],["thread",7021],["thread",7012],["thread",7003],["thread",7002],["thread",6983],["thread",6965],["thread",6961],["thread",6959],["thread",6956],["thread",6951],["thread",6950],["thread",6931],["thread",6928],["thread",6927],["thread",6919],["thread",6911],["thread",6905],["thread",6896],["thread",6887],["thread",6881],["thread",6880],["thread",6868],["thread",6864],["thread",6854],["thread",6852],["thread",6845],["thread",6844],["thread",6830],["thread",6829],["thread",6819],["thread",6815],["thread",6809],["thread",6808],["thread",6804],["thread",6803],["thread",6798],["thread",6761],["thread",6759],["thread",6757],["thread",6755],["thread",6725],["thread",6720],["thread",6698],["thread",6662],["thread",6661],["thread",6648],["thread",6630],["thread",6622],["thread",6612],["thread",6603],["thread",6573],["thread",6572],["thread",6549],["thread",6519],["thread",6496],["thread",6491],["thread",6489],["thread",6461],["thread",6448],["thread",6435],["thread",6434],["thread",6421],["thread",6393],["thread",6390],["thread",6389],["thread",6388],["thread",6378],["thread",6371],["thread",6366],["thread",6359],["thread",6337],["thread",6323],["thread",6322],["thread",6321],["thread",6316],["thread",6298],["thread",6296]]
Run Time: 0.008139