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
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)
WHERE thread.thread_id IN (3714, 3681, 3671, 3654, 3637, 3621, 3607, 3591, 3552, 3550, 3543, 3538, 3529, 3517, 3509, 3506, 3500, 3483, 3472, 3470, 3461, 3443, 3435, 3418, 3411, 3395, 3349, 3334, 3327, 3322, 3303, 3291, 3244, 3229, 3220, 3211, 3192, 3186, 3172, 3155, 3146, 3140, 3137, 3122, 3121, 3116, 3111, 3096, 3078, 3068, 3045, 3032, 3022, 3009, 3001, 2993, 2955, 2943, 2928, 2908, 2901, 2891, 2877, 2861, 2856, 2851, 2836, 2823, 2816, 2808, 2791, 2773, 2765, 2747, 2726, 2718, 2706, 2687, 2679, 2675, 2673, 2631, 2624, 2616, 2601, 2581, 2573, 2565, 2531, 2525, 2522, 2498, 2486, 2475, 2465, 2446, 2429, 2424, 2412, 2410, 2403, 2394, 2386, 2379, 2358, 2354, 2348, 2340, 2333, 2323, 2317, 2307, 2302, 2295, 2287, 2277, 2271, 2259, 2254, 2249, 2241, 2235, 2224, 2220, 2213, 2205, 2202, 2201, 2192, 2189, 2182, 2175, 2170, 2168, 2160, 2156, 2153, 2145, 2136, 2128, 2118, 2109, 2103, 2090, 2079, 2076, 2072, 2060, 2052, 2047, 2041, 2035, 2025, 2015, 2006, 2001, 1996, 1990, 1976, 1966, 1955, 1948, 1937, 1934, 1927, 1920, 1910, 1896, 1869, 1854, 1847, 1838, 1832, 1821, 1809, 1803, 1791, 1784, 1774, 1770, 1760, 1751, 1744, 1740, 1734, 1729, 1720, 1704, 1696, 1681, 1674, 1667, 1664, 1660, 1654, 1648)
Run Time: 0.083308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 196 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | kakatavn_db.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,kakatavn_db.thread.node_id | 1 | Using where |
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: 1668, 0, 1739751285, 1739754885, [["thread",3714],["thread",3681],["thread",3671],["thread",3654],["thread",3637],["thread",3621],["thread",3607],["thread",3591],["thread",3552],["thread",3550],["thread",3543],["thread",3538],["thread",3529],["thread",3517],["thread",3509],["thread",3506],["thread",3500],["thread",3483],["thread",3472],["thread",3470],["thread",3461],["thread",3443],["thread",3435],["thread",3418],["thread",3411],["thread",3395],["thread",3349],["thread",3334],["thread",3327],["thread",3322],["thread",3303],["thread",3291],["thread",3244],["thread",3229],["thread",3220],["thread",3211],["thread",3192],["thread",3186],["thread",3172],["thread",3155],["thread",3146],["thread",3140],["thread",3137],["thread",3122],["thread",3121],["thread",3116],["thread",3111],["thread",3096],["thread",3078],["thread",3068],["thread",3045],["thread",3032],["thread",3022],["thread",3009],["thread",3001],["thread",2993],["thread",2955],["thread",2943],["thread",2928],["thread",2908],["thread",2901],["thread",2891],["thread",2877],["thread",2861],["thread",2856],["thread",2851],["thread",2836],["thread",2823],["thread",2816],["thread",2808],["thread",2791],["thread",2773],["thread",2765],["thread",2747],["thread",2726],["thread",2718],["thread",2706],["thread",2687],["thread",2679],["thread",2675],["thread",2673],["thread",2631],["thread",2624],["thread",2616],["thread",2601],["thread",2581],["thread",2573],["thread",2565],["thread",2531],["thread",2525],["thread",2522],["thread",2498],["thread",2486],["thread",2475],["thread",2465],["thread",2446],["thread",2429],["thread",2424],["thread",2412],["thread",2410],["thread",2403],["thread",2394],["thread",2386],["thread",2379],["thread",2358],["thread",2354],["thread",2348],["thread",2340],["thread",2333],["thread",2323],["thread",2317],["thread",2307],["thread",2302],["thread",2295],["thread",2287],["thread",2277],["thread",2271],["thread",2259],["thread",2254],["thread",2249],["thread",2241],["thread",2235],["thread",2224],["thread",2220],["thread",2213],["thread",2205],["thread",2202],["thread",2201],["thread",2192],["thread",2189],["thread",2182],["thread",2175],["thread",2170],["thread",2168],["thread",2160],["thread",2156],["thread",2153],["thread",2145],["thread",2136],["thread",2128],["thread",2118],["thread",2109],["thread",2103],["thread",2090],["thread",2079],["thread",2076],["thread",2072],["thread",2060],["thread",2052],["thread",2047],["thread",2041],["thread",2035],["thread",2025],["thread",2015],["thread",2006],["thread",2001],["thread",1996],["thread",1990],["thread",1976],["thread",1966],["thread",1955],["thread",1948],["thread",1937],["thread",1934],["thread",1927],["thread",1920],["thread",1910],["thread",1896],["thread",1869],["thread",1854],["thread",1847],["thread",1838],["thread",1832],["thread",1821],["thread",1809],["thread",1803],["thread",1791],["thread",1784],["thread",1774],["thread",1770],["thread",1760],["thread",1751],["thread",1744],["thread",1740],["thread",1734],["thread",1729],["thread",1720],["thread",1704],["thread",1696],["thread",1681],["thread",1674],["thread",1667],["thread",1664],["thread",1660],["thread",1654],["thread",1648]]
Run Time: 0.001803