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 (7781, 7778, 7777, 7775, 7765, 7757, 7756, 7722, 7721, 7720, 7700, 7696, 7692, 7691, 7686, 7667, 7663, 7656, 7650, 7645, 7639, 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, 7497, 7467, 7453, 7433, 7430, 7424, 7407, 7397, 7388, 7363, 7358, 7356, 7349, 7345, 7340, 7336, 7334, 7329, 7308, 7301, 7288, 7287, 7274, 7268, 7267, 7253, 7247, 7246, 7245, 7227, 7219, 7218, 7208, 7192, 7189, 7181, 7175, 7174, 7130, 7129, 7094, 7089, 7083, 7081, 7073, 7072, 7059, 7043, 7042, 7041, 7037, 7035, 7021, 7012, 7003, 7002, 6983, 6965, 6961, 6959, 6951, 6950, 6931, 6930, 6928, 6927, 6919, 6911, 6905, 6896, 6887, 6881, 6880, 6868, 6864, 6854, 6845, 6844, 6830, 6829, 6819, 6815, 6809, 6808, 6804, 6803, 6798, 6759, 6757, 6725, 6720, 6698, 6662, 6661, 6648, 6630, 6622, 6612, 6603, 6573, 6572, 6549, 6519, 6491, 6489, 6435, 6434, 6421, 6393, 6378, 6371, 6366, 6359, 6337, 6323, 6322, 6316, 6292, 6291, 6280, 6279, 6269, 6257, 6255, 6196, 6195, 6192, 6181, 6146, 6145, 6136, 6134, 6133, 6097, 5961, 5920, 5919, 5871, 5867, 5855, 5805, 5769, 5695, 5694, 5664, 5657, 5584, 5583, 5576, 5573, 5571, 5506, 5491, 5454)
Run Time: 0.026561
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: 464, 0, 1714962650, 1714966250, [["thread",7781],["thread",7778],["thread",7777],["thread",7775],["thread",7765],["thread",7757],["thread",7756],["thread",7722],["thread",7721],["thread",7720],["thread",7700],["thread",7696],["thread",7692],["thread",7691],["thread",7686],["thread",7667],["thread",7663],["thread",7656],["thread",7650],["thread",7645],["thread",7639],["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",7497],["thread",7467],["thread",7453],["thread",7433],["thread",7430],["thread",7424],["thread",7407],["thread",7397],["thread",7388],["thread",7363],["thread",7358],["thread",7356],["thread",7349],["thread",7345],["thread",7340],["thread",7336],["thread",7334],["thread",7329],["thread",7308],["thread",7301],["thread",7288],["thread",7287],["thread",7274],["thread",7268],["thread",7267],["thread",7253],["thread",7247],["thread",7246],["thread",7245],["thread",7227],["thread",7219],["thread",7218],["thread",7208],["thread",7192],["thread",7189],["thread",7181],["thread",7175],["thread",7174],["thread",7130],["thread",7129],["thread",7094],["thread",7089],["thread",7083],["thread",7081],["thread",7073],["thread",7072],["thread",7059],["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",6951],["thread",6950],["thread",6931],["thread",6930],["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",6845],["thread",6844],["thread",6830],["thread",6829],["thread",6819],["thread",6815],["thread",6809],["thread",6808],["thread",6804],["thread",6803],["thread",6798],["thread",6759],["thread",6757],["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",6491],["thread",6489],["thread",6435],["thread",6434],["thread",6421],["thread",6393],["thread",6378],["thread",6371],["thread",6366],["thread",6359],["thread",6337],["thread",6323],["thread",6322],["thread",6316],["thread",6292],["thread",6291],["thread",6280],["thread",6279],["thread",6269],["thread",6257],["thread",6255],["thread",6196],["thread",6195],["thread",6192],["thread",6181],["thread",6146],["thread",6145],["thread",6136],["thread",6134],["thread",6133],["thread",6097],["thread",5961],["thread",5920],["thread",5919],["thread",5871],["thread",5867],["thread",5855],["thread",5805],["thread",5769],["thread",5695],["thread",5694],["thread",5664],["thread",5657],["thread",5584],["thread",5583],["thread",5576],["thread",5573],["thread",5571],["thread",5506],["thread",5491],["thread",5454]]
Run Time: 0.004256