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 (87152, 77988, 119850, 81608, 133075, 84938, 76513, 86275, 122340, 79258, 86664, 120108, 132077, 88511, 82058, 77589, 99470, 76373, 77842, 77335, 83832, 76956, 80997, 127912, 76994, 77007, 119576, 77394, 88750, 122469, 77840, 101811, 119418, 80038, 75728, 80919, 78756, 131988, 76514, 76399, 82177, 75279, 122342, 80897, 82276, 78338, 97443, 82185, 97811, 83065, 120532, 126183, 82051, 76696, 120531, 126185, 28166, 82184, 131957, 78584, 75953, 76694, 122468, 136546, 86554, 133188, 76995, 101808, 77700, 131712, 76428, 99765, 119676, 90160, 119848, 77361, 77701, 120839, 81461, 127837, 80037, 77332, 100447, 80472, 86834, 82774, 79736, 76666, 81605, 82181, 82926, 133315, 78042, 131866, 133706, 77365, 77262, 77413, 76699, 100872, 87827, 133284, 97813, 136635, 78327, 136405, 86539, 87240, 119842, 78385, 83746, 76886, 83073, 76100, 80284, 76330, 97080, 78334, 76240, 136432, 89411, 119847, 80457, 76657, 82055, 80994, 82180, 82172, 132445, 76185, 64694, 80959, 76096, 132267, 80123, 100712, 132395, 80119, 97814, 77527, 127678, 127676, 79260, 86344, 78004, 88420, 133489, 77991, 82052, 80910, 78572, 132113, 77120, 131744, 122467, 77810, 119679, 81459, 83124, 82174, 77525, 127844, 74405, 76326, 86866, 76553, 81000, 78404, 88116, 81801, 81224, 136553, 80901, 122343, 88400, 76516, 93603, 88161, 122471, 76396, 76307, 76057, 83063, 77816, 127910, 132309, 80036, 119476, 131689, 80121, 77269, 119577, 78160, 131825, 97121, 136392, 75954, 116214, 100494, 82053, 119841, 92123, 132268, 123910, 90286)
Run Time: 0.004071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 205 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dembuon_vn_d58b.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dembuon_vn_d58b.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: 29733, 0, 1713550942, 1713554542, [["resource",27],["thread",87152],["thread",77988],["thread",119850],["thread",81608],["thread",133075],["thread",84938],["thread",76513],["thread",86275],["thread",122340],["thread",79258],["thread",86664],["thread",120108],["thread",132077],["thread",88511],["thread",82058],["thread",77589],["thread",99470],["thread",76373],["thread",77842],["thread",77335],["thread",83832],["thread",76956],["thread",80997],["thread",127912],["thread",76994],["thread",77007],["thread",119576],["thread",77394],["thread",88750],["thread",122469],["thread",77840],["thread",101811],["thread",119418],["thread",80038],["thread",75728],["thread",80919],["thread",78756],["thread",131988],["thread",76514],["thread",76399],["thread",82177],["thread",75279],["thread",122342],["thread",80897],["thread",82276],["thread",78338],["thread",97443],["thread",82185],["thread",97811],["thread",83065],["thread",120532],["thread",126183],["thread",82051],["thread",76696],["thread",120531],["thread",126185],["thread",28166],["thread",82184],["thread",131957],["thread",78584],["thread",75953],["thread",76694],["thread",122468],["thread",136546],["thread",86554],["thread",133188],["thread",76995],["thread",101808],["thread",77700],["thread",131712],["thread",76428],["thread",99765],["thread",119676],["thread",90160],["thread",119848],["thread",77361],["thread",77701],["thread",120839],["thread",81461],["thread",127837],["thread",80037],["thread",77332],["thread",100447],["thread",80472],["thread",86834],["thread",82774],["thread",79736],["thread",76666],["thread",81605],["thread",82181],["thread",82926],["thread",133315],["thread",78042],["thread",131866],["thread",133706],["thread",77365],["thread",77262],["thread",77413],["thread",76699],["thread",100872],["thread",87827],["thread",133284],["thread",97813],["thread",136635],["thread",78327],["thread",136405],["thread",86539],["thread",87240],["thread",119842],["thread",78385],["thread",83746],["thread",76886],["thread",83073],["thread",76100],["thread",80284],["thread",76330],["thread",97080],["thread",78334],["thread",76240],["thread",136432],["thread",89411],["thread",119847],["thread",80457],["thread",76657],["thread",82055],["thread",80994],["thread",82180],["thread",82172],["thread",132445],["thread",76185],["thread",64694],["thread",80959],["thread",76096],["thread",132267],["thread",80123],["thread",100712],["thread",132395],["thread",80119],["thread",97814],["thread",77527],["thread",127678],["thread",127676],["thread",79260],["thread",86344],["thread",78004],["thread",88420],["thread",133489],["thread",77991],["thread",82052],["thread",80910],["thread",78572],["thread",132113],["thread",77120],["thread",131744],["thread",122467],["thread",77810],["thread",119679],["thread",81459],["thread",83124],["thread",82174],["thread",77525],["thread",127844],["thread",74405],["thread",76326],["thread",86866],["thread",76553],["thread",81000],["thread",78404],["thread",88116],["thread",81801],["thread",81224],["thread",136553],["thread",80901],["thread",122343],["thread",88400],["thread",76516],["thread",93603],["thread",88161],["thread",122471],["thread",76396],["thread",76307],["thread",76057],["thread",83063],["thread",77816],["thread",127910],["thread",132309],["thread",80036],["thread",119476],["thread",131689],["thread",80121],["thread",77269],["thread",119577],["thread",78160],["thread",131825],["thread",97121],["thread",136392],["thread",75954],["thread",116214],["thread",100494],["thread",82053],["thread",119841],["thread",92123],["thread",132268],["thread",123910],["thread",90286]]
Run Time: 0.003226