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 (20705, 20702, 20701, 11164, 11031, 11028, 10994, 10975, 10974, 10937, 10936, 10911, 10908, 10838, 10835, 9277, 9274, 8963, 8962, 8900, 8897, 8895, 8893, 8892, 8891, 8890, 8889, 8835, 8832, 8629, 8600, 8599, 8598, 8507, 8397, 8393, 8380, 8379, 8378, 8201, 8200, 8199, 8184, 8183, 8182, 8181, 8154, 8152, 8151, 8124, 8122, 8056, 8055, 8052, 8051, 8046, 8028, 8027, 7975, 7974, 7971, 7967, 7965, 7964, 7943, 7942, 7877, 7876, 7875, 7871, 7803, 7802, 7801, 7773, 7772, 7771, 7747, 7746, 7744, 7737, 7736, 7719, 7713, 7712, 7686, 7678, 7676, 7675, 7674, 7673, 7672, 7671, 7670, 7669, 7668, 7667, 7657, 7656, 7655, 7654, 7637, 7636, 7635, 7634, 7633, 7584, 7581, 7560, 7559, 7475, 7406, 7405, 7404, 7403, 6887, 6886, 6855, 6854, 6853, 6852, 6817, 6816, 6811, 6810, 6767, 6763, 6762, 6761, 6760, 6759, 6758, 6670, 6664, 6663, 6662, 6661, 6657, 6655, 6646, 6645, 6632, 6631, 6630, 6628, 6627, 6611, 6610, 6574, 6573, 6572, 6558, 6557, 6556, 6555, 6552, 6551, 6538, 6535, 6531, 6520, 6518, 6508, 6505, 6504, 6503, 6349, 6348, 6347, 6346, 6344, 6343, 6316, 6315, 6313, 6311, 6285, 6284, 6282, 6274, 6273, 5721, 5720, 5648, 5647, 5639, 5594, 5568, 5565, 5533, 5530, 5397, 5394, 5393, 5392, 4274, 4272, 4271, 4233, 4152, 3230)
Run Time: 0.018844
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using index condition |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | tugrghshosting_diendanduoc.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,tugrghshosting_diendanduoc.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: 387, 0, 1656807116, 1656810716, [["thread",20705],["thread",20702],["thread",20701],["thread",11164],["thread",11031],["thread",11028],["thread",10994],["thread",10975],["thread",10974],["thread",10937],["thread",10936],["thread",10911],["thread",10908],["thread",10838],["thread",10835],["thread",9277],["thread",9274],["thread",8963],["thread",8962],["thread",8900],["thread",8897],["thread",8895],["thread",8893],["thread",8892],["thread",8891],["thread",8890],["thread",8889],["thread",8835],["thread",8832],["thread",8629],["thread",8600],["thread",8599],["thread",8598],["thread",8507],["thread",8397],["thread",8393],["thread",8380],["thread",8379],["thread",8378],["thread",8201],["thread",8200],["thread",8199],["thread",8184],["thread",8183],["thread",8182],["thread",8181],["thread",8154],["thread",8152],["thread",8151],["thread",8124],["thread",8122],["thread",8056],["thread",8055],["thread",8052],["thread",8051],["thread",8046],["thread",8028],["thread",8027],["thread",7975],["thread",7974],["thread",7971],["thread",7967],["thread",7965],["thread",7964],["thread",7943],["thread",7942],["thread",7877],["thread",7876],["thread",7875],["thread",7871],["thread",7803],["thread",7802],["thread",7801],["thread",7773],["thread",7772],["thread",7771],["thread",7747],["thread",7746],["thread",7744],["thread",7737],["thread",7736],["thread",7719],["thread",7713],["thread",7712],["thread",7686],["thread",7678],["thread",7676],["thread",7675],["thread",7674],["thread",7673],["thread",7672],["thread",7671],["thread",7670],["thread",7669],["thread",7668],["thread",7667],["thread",7657],["thread",7656],["thread",7655],["thread",7654],["thread",7637],["thread",7636],["thread",7635],["thread",7634],["thread",7633],["thread",7584],["thread",7581],["thread",7560],["thread",7559],["thread",7475],["thread",7406],["thread",7405],["thread",7404],["thread",7403],["thread",6887],["thread",6886],["thread",6855],["thread",6854],["thread",6853],["thread",6852],["thread",6817],["thread",6816],["thread",6811],["thread",6810],["thread",6767],["thread",6763],["thread",6762],["thread",6761],["thread",6760],["thread",6759],["thread",6758],["thread",6670],["thread",6664],["thread",6663],["thread",6662],["thread",6661],["thread",6657],["thread",6655],["thread",6646],["thread",6645],["thread",6632],["thread",6631],["thread",6630],["thread",6628],["thread",6627],["thread",6611],["thread",6610],["thread",6574],["thread",6573],["thread",6572],["thread",6558],["thread",6557],["thread",6556],["thread",6555],["thread",6552],["thread",6551],["thread",6538],["thread",6535],["thread",6531],["thread",6520],["thread",6518],["thread",6508],["thread",6505],["thread",6504],["thread",6503],["thread",6349],["thread",6348],["thread",6347],["thread",6346],["thread",6344],["thread",6343],["thread",6316],["thread",6315],["thread",6313],["thread",6311],["thread",6285],["thread",6284],["thread",6282],["thread",6274],["thread",6273],["thread",5721],["thread",5720],["thread",5648],["thread",5647],["thread",5639],["thread",5594],["thread",5568],["thread",5565],["thread",5533],["thread",5530],["thread",5397],["thread",5394],["thread",5393],["thread",5392]]
Run Time: 0.000261