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 (7772, 7756, 7723, 7710, 7674, 7638, 7422, 7180, 7025, 6687, 6600, 6516, 6467, 6461, 6448, 6296, 5783, 5702, 5660, 5484, 5351, 5250, 5027, 4977, 4719, 4652, 4463, 4337, 4259, 4136, 4027, 4011, 3808, 3797, 3669, 3668, 3628, 3623, 3610, 3593, 3589, 3588, 3572, 3571, 3551, 3550, 3455, 3393, 3373, 3341, 3325, 3313, 3310, 3275, 3258, 3245, 3242, 3223, 3222, 3206, 3149, 3138, 3120, 3060, 3052, 3050, 3026, 3015, 3001, 2989, 2987, 2982, 2965, 2960, 2940, 2911, 2909, 2905, 2901, 2884, 2851, 2850, 2846, 2828, 2811, 2799, 2797, 2794, 2786, 2746, 2712, 2702, 2679, 2664, 2658, 2645, 2641, 2639, 2624, 2623, 2622, 2615, 2614, 2582, 2569, 2561, 2557, 2553, 2552, 2551, 2550, 2549, 2546, 2544, 2536, 2535, 2534, 2530, 2511, 2507, 2504, 2503, 2499, 2498, 2496, 2486, 2480, 2473, 2468, 2463, 2462, 2461, 2456, 2455, 2454, 2453, 2434, 2429, 2385, 2384, 2378, 2366, 2364, 2352, 2345, 2321, 2316, 2311, 2301, 2300, 2274, 2273, 2270, 2269, 2268, 2267, 2266, 2265, 2264, 2263, 2262, 2261, 2260, 2259, 2258, 2256, 2255, 2254, 2253, 2252, 2250, 2248, 2247, 2246, 2245, 2244, 2243, 2242, 2241, 2240, 2223, 2136, 2098, 2072, 2063, 2062, 2059, 2057, 2051, 2036, 2023, 2017, 1979, 1977, 1959, 1958, 1957, 1919, 1900, 1895)
Run Time: 0.020588
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: 9, 0, 1715136112, 1715139712, [["thread",7772],["thread",7756],["thread",7723],["thread",7710],["thread",7674],["thread",7638],["thread",7422],["thread",7180],["thread",7025],["thread",6687],["thread",6600],["thread",6516],["thread",6467],["thread",6461],["thread",6448],["thread",6296],["thread",5783],["thread",5702],["thread",5660],["thread",5484],["thread",5351],["thread",5250],["thread",5027],["thread",4977],["thread",4719],["thread",4652],["thread",4463],["thread",4337],["thread",4259],["thread",4136],["thread",4027],["thread",4011],["thread",3808],["thread",3797],["thread",3669],["thread",3668],["thread",3628],["thread",3623],["thread",3610],["thread",3593],["thread",3589],["thread",3588],["thread",3572],["thread",3571],["thread",3551],["thread",3550],["thread",3455],["thread",3393],["thread",3373],["thread",3341],["thread",3325],["thread",3313],["thread",3310],["thread",3275],["thread",3258],["thread",3245],["thread",3242],["thread",3223],["thread",3222],["thread",3206],["thread",3149],["thread",3138],["thread",3120],["thread",3060],["thread",3052],["thread",3050],["thread",3026],["thread",3015],["thread",3001],["thread",2989],["thread",2987],["thread",2982],["thread",2965],["thread",2960],["thread",2940],["thread",2911],["thread",2909],["thread",2905],["thread",2901],["thread",2884],["thread",2851],["thread",2850],["thread",2846],["thread",2828],["thread",2811],["thread",2799],["thread",2797],["thread",2794],["thread",2786],["thread",2746],["thread",2712],["thread",2702],["thread",2679],["thread",2664],["thread",2658],["thread",2645],["thread",2641],["thread",2639],["thread",2624],["thread",2623],["thread",2622],["thread",2615],["thread",2614],["thread",2582],["thread",2569],["thread",2561],["thread",2557],["thread",2553],["thread",2552],["thread",2551],["thread",2550],["thread",2549],["thread",2546],["thread",2544],["thread",2536],["thread",2535],["thread",2534],["thread",2530],["thread",2511],["thread",2507],["thread",2504],["thread",2503],["thread",2499],["thread",2498],["thread",2496],["thread",2486],["thread",2480],["thread",2473],["thread",2468],["thread",2463],["thread",2462],["thread",2461],["thread",2456],["thread",2455],["thread",2454],["thread",2453],["thread",2434],["thread",2429],["thread",2385],["thread",2384],["thread",2378],["thread",2366],["thread",2364],["thread",2352],["thread",2345],["thread",2321],["thread",2316],["thread",2311],["thread",2301],["thread",2300],["thread",2274],["thread",2273],["thread",2270],["thread",2269],["thread",2268],["thread",2267],["thread",2266],["thread",2265],["thread",2264],["thread",2263],["thread",2262],["thread",2261],["thread",2260],["thread",2259],["thread",2258],["thread",2256],["thread",2255],["thread",2254],["thread",2253],["thread",2252],["thread",2250],["thread",2248],["thread",2247],["thread",2246],["thread",2245],["thread",2244],["thread",2243],["thread",2242],["thread",2241],["thread",2240],["thread",2223],["thread",2136],["thread",2098],["thread",2072],["thread",2063],["thread",2062],["thread",2059],["thread",2057],["thread",2051],["thread",2036],["thread",2023],["thread",2017],["thread",1979],["thread",1977],["thread",1959],["thread",1958],["thread",1957],["thread",1919],["thread",1900],["thread",1895]]
Run Time: 0.008747