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, 7772, 7765, 7758, 7756, 7721, 7720, 7696, 7691, 7667, 7650, 7645, 7638, 7633, 7629, 7620, 7612, 7609, 7608, 7598, 7574, 7538, 7533, 7526, 7515, 7514, 7507, 7497, 7467, 7430, 7424, 7422, 7407, 7388, 7358, 7356, 7349, 7329, 7301, 7293, 7274, 7253, 7246, 7245, 7219, 7218, 7208, 7192, 7180, 7175, 7174, 7089, 7043, 7037, 7035, 7012, 6965, 6959, 6951, 6950, 6931, 6928, 6919, 6905, 6896, 6881, 6880, 6845, 6844, 6830, 6829, 6819, 6815, 6809, 6808, 6804, 6803, 6798, 6755, 6698, 6662, 6612, 6573, 6572, 6549, 6519, 6491, 6489, 6461, 6448, 6435, 6434, 6421, 6378, 6366, 6365, 6359, 6337, 6323, 6322, 6316, 6298, 6296, 6292, 6291, 6269, 6196, 6195, 6192, 6146, 6145, 6136, 6134, 6133, 5971, 5920, 5919, 5867, 5855, 5702, 5657, 5583, 5576, 5573, 5568, 5506, 5491, 5484, 5342, 5319, 5304, 5301, 5299, 5287, 5284, 5250, 5242, 5231, 5221, 5212, 5179, 5139, 5087, 5010, 4888, 4887, 4864, 4846, 4731, 4719, 4688, 4625, 4558, 4543, 4541, 4526, 4517, 4464, 4450, 4444, 4431, 4180, 4178, 4101, 4027, 3908, 3870, 3818, 3797, 3794, 3753, 3688, 3623, 3610, 3418, 3393, 3373, 3310, 3245, 3242, 3222, 3206, 3052, 3050, 3029, 3026, 2987, 2982, 2960, 2940, 2884, 2876, 2846, 2811, 2797, 2794, 2746)
Run Time: 0.006955
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: 300, 0, 1714821990, 1714825590, [["thread",7781],["thread",7778],["thread",7777],["thread",7775],["thread",7772],["thread",7765],["thread",7758],["thread",7756],["thread",7721],["thread",7720],["thread",7696],["thread",7691],["thread",7667],["thread",7650],["thread",7645],["thread",7638],["thread",7633],["thread",7629],["thread",7620],["thread",7612],["thread",7609],["thread",7608],["thread",7598],["thread",7574],["thread",7538],["thread",7533],["thread",7526],["thread",7515],["thread",7514],["thread",7507],["thread",7497],["thread",7467],["thread",7430],["thread",7424],["thread",7422],["thread",7407],["thread",7388],["thread",7358],["thread",7356],["thread",7349],["thread",7329],["thread",7301],["thread",7293],["thread",7274],["thread",7253],["thread",7246],["thread",7245],["thread",7219],["thread",7218],["thread",7208],["thread",7192],["thread",7180],["thread",7175],["thread",7174],["thread",7089],["thread",7043],["thread",7037],["thread",7035],["thread",7012],["thread",6965],["thread",6959],["thread",6951],["thread",6950],["thread",6931],["thread",6928],["thread",6919],["thread",6905],["thread",6896],["thread",6881],["thread",6880],["thread",6845],["thread",6844],["thread",6830],["thread",6829],["thread",6819],["thread",6815],["thread",6809],["thread",6808],["thread",6804],["thread",6803],["thread",6798],["thread",6755],["thread",6698],["thread",6662],["thread",6612],["thread",6573],["thread",6572],["thread",6549],["thread",6519],["thread",6491],["thread",6489],["thread",6461],["thread",6448],["thread",6435],["thread",6434],["thread",6421],["thread",6378],["thread",6366],["thread",6365],["thread",6359],["thread",6337],["thread",6323],["thread",6322],["thread",6316],["thread",6298],["thread",6296],["thread",6292],["thread",6291],["thread",6269],["thread",6196],["thread",6195],["thread",6192],["thread",6146],["thread",6145],["thread",6136],["thread",6134],["thread",6133],["thread",5971],["thread",5920],["thread",5919],["thread",5867],["thread",5855],["thread",5702],["thread",5657],["thread",5583],["thread",5576],["thread",5573],["thread",5568],["thread",5506],["thread",5491],["thread",5484],["thread",5342],["thread",5319],["thread",5304],["thread",5301],["thread",5299],["thread",5287],["thread",5284],["thread",5250],["thread",5242],["thread",5231],["thread",5221],["thread",5212],["thread",5179],["thread",5139],["thread",5087],["thread",5010],["thread",4888],["thread",4887],["thread",4864],["thread",4846],["thread",4731],["thread",4719],["thread",4688],["thread",4625],["thread",4558],["thread",4543],["thread",4541],["thread",4526],["thread",4517],["thread",4464],["thread",4450],["thread",4444],["thread",4431],["thread",4180],["thread",4178],["thread",4101],["thread",4027],["thread",3908],["thread",3870],["thread",3818],["thread",3797],["thread",3794],["thread",3753],["thread",3688],["thread",3623],["thread",3610],["thread",3418],["thread",3393],["thread",3373],["thread",3310],["thread",3245],["thread",3242],["thread",3222],["thread",3206],["thread",3052],["thread",3050],["thread",3029],["thread",3026],["thread",2987],["thread",2982],["thread",2960],["thread",2940],["thread",2884],["thread",2876],["thread",2846],["thread",2811],["thread",2797],["thread",2794],["thread",2746]]
Run Time: 0.006675