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 (17188, 17186, 17014, 17013, 17012, 17011, 17010, 17009, 17008, 17007, 17006, 17005, 17004, 17003, 17002, 17001, 17000, 16999, 16998, 16997, 16996, 16995, 16993, 16992, 16991, 16990, 16989, 16988, 16987, 16986, 16985, 16984, 16983, 16982, 16981, 16980, 16979, 16978, 16977, 16976, 16968, 16967, 16966, 16965, 16964, 16963, 16962, 16961, 16960, 16958, 16957, 16956, 16955, 16954, 16953, 16952, 16951, 16949, 16948, 16944, 16943, 16942, 16941, 16940, 16939, 16938, 16934, 16928, 16927, 16926, 16925, 16924, 16923, 16922, 16921, 16920, 16919, 16918, 16917, 16916, 16915, 16914, 16913, 16912, 16911, 16910, 16909, 16908, 16907, 16906, 16905, 16904, 16903, 16902, 16901, 16900, 16899, 16898, 16897, 16896, 16895, 16894, 16893, 16892, 16891, 16890, 16889, 16888, 16887, 16886, 16885, 16879, 16878, 16877, 16876, 16875, 16874, 16873, 16872, 16871, 16870, 16869, 16868, 16864, 16863, 16857, 16856, 16854, 16852, 16851, 16850, 16849, 16843, 16830, 16822, 16821, 16819, 16817)
Run Time: 0.012914
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 138 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | chanpro.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,chanpro.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: 1894, 0, 1715016916, 1715020516, [["thread",17188],["thread",17186],["thread",17014],["thread",17013],["thread",17012],["thread",17011],["thread",17010],["thread",17009],["thread",17008],["thread",17007],["thread",17006],["thread",17005],["thread",17004],["thread",17003],["thread",17002],["thread",17001],["thread",17000],["thread",16999],["thread",16998],["thread",16997],["thread",16996],["thread",16995],["thread",16993],["thread",16992],["thread",16991],["thread",16990],["thread",16989],["thread",16988],["thread",16987],["thread",16986],["thread",16985],["thread",16984],["thread",16983],["thread",16982],["thread",16981],["thread",16980],["thread",16979],["thread",16978],["thread",16977],["thread",16976],["thread",16968],["thread",16967],["thread",16966],["thread",16965],["thread",16964],["thread",16963],["thread",16962],["thread",16961],["thread",16960],["thread",16958],["thread",16957],["thread",16956],["thread",16955],["thread",16954],["thread",16953],["thread",16952],["thread",16951],["thread",16949],["thread",16948],["thread",16944],["thread",16943],["thread",16942],["thread",16941],["thread",16940],["thread",16939],["thread",16938],["thread",16934],["thread",16928],["thread",16927],["thread",16926],["thread",16925],["thread",16924],["thread",16923],["thread",16922],["thread",16921],["thread",16920],["thread",16919],["thread",16918],["thread",16917],["thread",16916],["thread",16915],["thread",16914],["thread",16913],["thread",16912],["thread",16911],["thread",16910],["thread",16909],["thread",16908],["thread",16907],["thread",16906],["thread",16905],["thread",16904],["thread",16903],["thread",16902],["thread",16901],["thread",16900],["thread",16899],["thread",16898],["thread",16897],["thread",16896],["thread",16895],["thread",16894],["thread",16893],["thread",16892],["thread",16891],["thread",16890],["thread",16889],["thread",16888],["thread",16887],["thread",16886],["thread",16885],["thread",16879],["thread",16878],["thread",16877],["thread",16876],["thread",16875],["thread",16874],["thread",16873],["thread",16872],["thread",16871],["thread",16870],["thread",16869],["thread",16868],["thread",16864],["thread",16863],["thread",16857],["thread",16856],["thread",16854],["thread",16852],["thread",16851],["thread",16850],["thread",16849],["thread",16843],["thread",16830],["thread",16822],["thread",16821],["thread",16819],["thread",16817]]
Run Time: 0.001408