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 (2014492, 2006696, 1972515, 1957603, 1954358, 1947636, 1947552, 1935990, 1935973, 1935607, 1935492, 1933647, 1933273, 1933272, 1932462, 1932368, 1932343, 1931946, 1931592, 1930761, 1929996, 1929854, 1929741, 1929349, 1929075, 1928717, 1928513, 1928274, 1928175, 1928100, 1926789, 1926759, 1926715, 1926564, 1926256, 1925382, 1924342, 1923868, 1920946, 1920599, 1918155, 1917771, 1917137, 1916821, 1916167, 1915688, 1915232, 1915231, 1909671, 1909242, 1904824, 1901102, 1897563, 1830302, 1784462, 1779329, 1778207, 1773440, 1771062, 1229458, 643074, 643070, 643058, 172784, 168712, 126999, 120258, 120254, 120249, 77756, 76592, 76451, 61941, 59283, 40369, 40362, 37699, 36882, 36246, 34516, 27286, 27082, 27073, 27072, 25817, 25098, 23145, 18265, 17805, 17348, 17215, 17213, 17068, 16730, 16729, 16532, 15783, 14132, 13825, 13368, 12615, 12614, 7589, 7572, 7559, 1070, 1046, 989, 918, 352, 351, 292, 61, 60, 59, 58, 57, 56, 55, 54, 53, 52, 50, 49, 48, 47, 46, 45, 44, 43, 42, 41, 40, 35, 34, 33, 32, 31, 25, 24, 23, 22, 8, 5, 4, 3)
Run Time: 0.010739
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 146 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.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: 6, 0, 1711617864, 1711621464, [["thread",2014492],["thread",2006696],["thread",1972515],["thread",1957603],["thread",1954358],["thread",1947636],["thread",1947552],["thread",1935990],["thread",1935973],["thread",1935607],["thread",1935492],["thread",1933647],["thread",1933273],["thread",1933272],["thread",1932462],["thread",1932368],["thread",1932343],["thread",1931946],["thread",1931592],["thread",1930761],["thread",1929996],["thread",1929854],["thread",1929741],["thread",1929349],["thread",1929075],["thread",1928717],["thread",1928513],["thread",1928274],["thread",1928175],["thread",1928100],["thread",1926789],["thread",1926759],["thread",1926715],["thread",1926564],["thread",1926256],["thread",1925382],["thread",1924342],["thread",1923868],["thread",1920946],["thread",1920599],["thread",1918155],["thread",1917771],["thread",1917137],["thread",1916821],["thread",1916167],["thread",1915688],["thread",1915232],["thread",1915231],["thread",1909671],["thread",1909242],["thread",1904824],["thread",1901102],["thread",1897563],["thread",1830302],["thread",1784462],["thread",1779329],["thread",1778207],["thread",1773440],["thread",1771062],["thread",1229458],["thread",643074],["thread",643070],["thread",643058],["thread",172784],["thread",168712],["thread",126999],["thread",120258],["thread",120254],["thread",120249],["thread",77756],["thread",76592],["thread",76451],["thread",61941],["thread",59283],["thread",40369],["thread",40362],["thread",37699],["thread",36882],["thread",36246],["thread",34516],["thread",27286],["thread",27082],["thread",27073],["thread",27072],["thread",25817],["thread",25098],["thread",23145],["thread",18265],["thread",17805],["thread",17348],["thread",17215],["thread",17213],["thread",17068],["thread",16730],["thread",16729],["thread",16532],["thread",15783],["thread",14132],["thread",13825],["thread",13368],["thread",12615],["thread",12614],["thread",7589],["thread",7572],["thread",7559],["thread",1070],["thread",1046],["thread",989],["thread",918],["thread",352],["thread",351],["thread",292],["thread",61],["thread",60],["thread",59],["thread",58],["thread",57],["thread",56],["thread",55],["thread",54],["thread",53],["thread",52],["thread",50],["thread",49],["thread",48],["thread",47],["thread",46],["thread",45],["thread",44],["thread",43],["thread",42],["thread",41],["thread",40],["thread",35],["thread",34],["thread",33],["thread",32],["thread",31],["thread",25],["thread",24],["thread",23],["thread",22],["thread",8],["thread",5],["thread",4],["thread",3]]
Run Time: 0.003895