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 (2024622, 2020569, 2019943, 2019153, 2018046, 2017996, 2015772, 2015598, 2015169, 2015100, 2015027, 2014998, 2014986, 2014976, 2014868, 2014793, 2014679, 2014107, 2014080, 2014071, 2014070, 2014068, 2014035, 2013923, 2013807, 2013635, 2013619, 2013580, 2013543, 2013541, 2013498, 2013467, 2013381, 2013184, 2013140, 2013139, 2013040, 2012805, 2012788, 2012002, 2011904, 2011869, 2011762, 2011535, 2010348, 2009098, 2008966, 2008363, 2007491, 2007259, 2007258, 2007183, 2007182, 2006688, 2006137, 2005262, 2004942, 2004906, 2004763, 2004623, 2004527, 2004363, 2004071, 2004060, 2003988, 2003908, 2003774, 2003720, 2003600, 2003479, 2003270, 2003247, 2003153, 2003119, 2003079, 2003040, 2003035, 2003033, 2002985, 2002759, 2002690, 2002611, 2002545, 2002481, 2002373, 2002354, 2002308, 2002273, 2002189, 2002160, 2001896, 2001891, 2001671, 2001628, 2001599, 2001598, 2001362, 2001128, 2001100, 1999878, 1999638, 1999032, 1999006, 1998686, 1991568, 1991229, 1991201, 1991163, 1991162, 1991132, 1991125, 1991110, 1991103, 1991094, 1991079, 1991078, 1991074, 1991073, 1991070, 1991051, 1991050, 1991049, 1991048, 1991047, 1991046, 1991042, 1990949, 1990927, 1990925, 1990902, 1990888, 1990541, 1990520, 1990498, 1990475, 1990464, 1990407, 1990400, 1989983, 1989956, 1989852, 1989821, 1989815, 1989813, 1989765, 1989763, 1989761, 1989734, 1989733, 1989707, 1989597, 1989569, 1989327, 1989025, 1988992, 1988939, 1988574, 1987130, 1986682, 1986666, 1986048, 1986047, 1984664, 1984405, 1983918, 1983221, 1983116, 1982928, 1978035, 1976467, 1973691, 1972768, 1972466, 1970905, 1969780, 1969747, 1969734, 1969692, 1969669, 1969622, 1969603, 1969581, 1969510, 1969455, 1969390, 1969375, 1969250, 1969207, 1969182, 1969125, 1969045, 1968999, 1968989, 1968948, 1968919, 1968821, 1968708, 1968690, 1968668, 1968564)
Run Time: 0.060035
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 | 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: 91, 0, 1714055564, 1714059164, [["thread",2024622],["thread",2020569],["thread",2019943],["thread",2019153],["thread",2018046],["thread",2017996],["thread",2015772],["thread",2015598],["thread",2015169],["thread",2015100],["thread",2015027],["thread",2014998],["thread",2014986],["thread",2014976],["thread",2014868],["thread",2014793],["thread",2014679],["thread",2014107],["thread",2014080],["thread",2014071],["thread",2014070],["thread",2014068],["thread",2014035],["thread",2013923],["thread",2013807],["thread",2013635],["thread",2013619],["thread",2013580],["thread",2013543],["thread",2013541],["thread",2013498],["thread",2013467],["thread",2013381],["thread",2013184],["thread",2013140],["thread",2013139],["thread",2013040],["thread",2012805],["thread",2012788],["thread",2012002],["thread",2011904],["thread",2011869],["thread",2011762],["thread",2011535],["thread",2010348],["thread",2009098],["thread",2008966],["thread",2008363],["thread",2007491],["thread",2007259],["thread",2007258],["thread",2007183],["thread",2007182],["thread",2006688],["thread",2006137],["thread",2005262],["thread",2004942],["thread",2004906],["thread",2004763],["thread",2004623],["thread",2004527],["thread",2004363],["thread",2004071],["thread",2004060],["thread",2003988],["thread",2003908],["thread",2003774],["thread",2003720],["thread",2003600],["thread",2003479],["thread",2003270],["thread",2003247],["thread",2003153],["thread",2003119],["thread",2003079],["thread",2003040],["thread",2003035],["thread",2003033],["thread",2002985],["thread",2002759],["thread",2002690],["thread",2002611],["thread",2002545],["thread",2002481],["thread",2002373],["thread",2002354],["thread",2002308],["thread",2002273],["thread",2002189],["thread",2002160],["thread",2001896],["thread",2001891],["thread",2001671],["thread",2001628],["thread",2001599],["thread",2001598],["thread",2001362],["thread",2001128],["thread",2001100],["thread",1999878],["thread",1999638],["thread",1999032],["thread",1999006],["thread",1998686],["thread",1991568],["thread",1991229],["thread",1991201],["thread",1991163],["thread",1991162],["thread",1991132],["thread",1991125],["thread",1991110],["thread",1991103],["thread",1991094],["thread",1991079],["thread",1991078],["thread",1991074],["thread",1991073],["thread",1991070],["thread",1991051],["thread",1991050],["thread",1991049],["thread",1991048],["thread",1991047],["thread",1991046],["thread",1991042],["thread",1990949],["thread",1990927],["thread",1990925],["thread",1990902],["thread",1990888],["thread",1990541],["thread",1990520],["thread",1990498],["thread",1990475],["thread",1990464],["thread",1990407],["thread",1990400],["thread",1989983],["thread",1989956],["thread",1989852],["thread",1989821],["thread",1989815],["thread",1989813],["thread",1989765],["thread",1989763],["thread",1989761],["thread",1989734],["thread",1989733],["thread",1989707],["thread",1989597],["thread",1989569],["thread",1989327],["thread",1989025],["thread",1988992],["thread",1988939],["thread",1988574],["thread",1987130],["thread",1986682],["thread",1986666],["thread",1986048],["thread",1986047],["thread",1984664],["thread",1984405],["thread",1983918],["thread",1983221],["thread",1983116],["thread",1982928],["thread",1978035],["thread",1976467],["thread",1973691],["thread",1972768],["thread",1972466],["thread",1970905],["thread",1969780],["thread",1969747],["thread",1969734],["thread",1969692],["thread",1969669],["thread",1969622],["thread",1969603],["thread",1969581],["thread",1969510],["thread",1969455],["thread",1969390],["thread",1969375],["thread",1969250],["thread",1969207],["thread",1969182],["thread",1969125],["thread",1969045],["thread",1968999],["thread",1968989],["thread",1968948],["thread",1968919],["thread",1968821],["thread",1968708],["thread",1968690],["thread",1968668],["thread",1968564]]
Run Time: 0.003362