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 (13774, 12548, 12546, 12243, 12112, 11129, 11117, 10973, 10940, 10937, 10910, 10909, 10907, 10875, 10209, 10168, 10165, 10164, 10037, 10035, 10023, 9753, 9749, 9719, 9717, 9715, 9695, 9694, 9693, 9691, 9661, 9660, 9659, 9555, 9553, 9543, 9542, 9540, 8396, 8216, 8215, 8214, 8213, 8194, 8193, 8192, 8191, 8190, 8184, 8180, 8179, 8178, 8128, 8127, 8126, 8125, 8076, 8075, 8074, 8073, 8072, 8067, 8064, 8062, 8005, 8004, 8003, 7999, 7968, 7966, 7958, 7956, 7955, 7954, 7933, 7932, 7931, 7930, 7929, 7928, 7926, 7924, 7871, 7855, 7853, 7852, 7851, 7850, 7840, 7839, 7838, 7837, 7836, 7780, 7684, 7683, 7682, 7681, 7680, 7679, 7676, 7675, 7674, 7673, 7672, 7671, 7670, 7669, 7668, 7667, 7646, 7645, 7644, 7637, 7636, 7635, 7634, 7633, 7584, 7581, 7551, 7550, 7549, 7548, 7547, 7546, 7528, 7527, 7526, 7388, 7387, 7386, 7385, 7384, 7382, 7381, 7341, 7339, 7324, 7323, 7322, 7321, 7320, 7297, 7282, 7281, 7280, 7279, 7278, 7265, 7262, 7261, 7260, 7259, 7258, 7242, 7215, 7213, 7211, 7198, 7196, 7194, 7184, 7182, 7179, 7177, 7175, 7160, 7146, 7144, 7142, 7120, 7118, 7116, 7113, 7110, 7102, 7094, 7090, 7076, 7073, 7070, 7066, 7016, 7014, 6960, 6958, 6927, 6880, 6784, 6783, 6759, 6758, 6718, 6717, 6716, 6715, 6695, 6694, 6693)
Run Time: 0.023348
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: 452, 0, 1656802478, 1656806078, [["thread",13774],["thread",12548],["thread",12546],["thread",12243],["thread",12112],["thread",11129],["thread",11117],["thread",10973],["thread",10940],["thread",10937],["thread",10910],["thread",10909],["thread",10907],["thread",10875],["thread",10209],["thread",10168],["thread",10165],["thread",10164],["thread",10037],["thread",10035],["thread",10023],["thread",9753],["thread",9749],["thread",9719],["thread",9717],["thread",9715],["thread",9695],["thread",9694],["thread",9693],["thread",9691],["thread",9661],["thread",9660],["thread",9659],["thread",9555],["thread",9553],["thread",9543],["thread",9542],["thread",9540],["thread",8396],["thread",8216],["thread",8215],["thread",8214],["thread",8213],["thread",8194],["thread",8193],["thread",8192],["thread",8191],["thread",8190],["thread",8184],["thread",8180],["thread",8179],["thread",8178],["thread",8128],["thread",8127],["thread",8126],["thread",8125],["thread",8076],["thread",8075],["thread",8074],["thread",8073],["thread",8072],["thread",8067],["thread",8064],["thread",8062],["thread",8005],["thread",8004],["thread",8003],["thread",7999],["thread",7968],["thread",7966],["thread",7958],["thread",7956],["thread",7955],["thread",7954],["thread",7933],["thread",7932],["thread",7931],["thread",7930],["thread",7929],["thread",7928],["thread",7926],["thread",7924],["thread",7871],["thread",7855],["thread",7853],["thread",7852],["thread",7851],["thread",7850],["thread",7840],["thread",7839],["thread",7838],["thread",7837],["thread",7836],["thread",7780],["thread",7684],["thread",7683],["thread",7682],["thread",7681],["thread",7680],["thread",7679],["thread",7676],["thread",7675],["thread",7674],["thread",7673],["thread",7672],["thread",7671],["thread",7670],["thread",7669],["thread",7668],["thread",7667],["thread",7646],["thread",7645],["thread",7644],["thread",7637],["thread",7636],["thread",7635],["thread",7634],["thread",7633],["thread",7584],["thread",7581],["thread",7551],["thread",7550],["thread",7549],["thread",7548],["thread",7547],["thread",7546],["thread",7528],["thread",7527],["thread",7526],["thread",7388],["thread",7387],["thread",7386],["thread",7385],["thread",7384],["thread",7382],["thread",7381],["thread",7341],["thread",7339],["thread",7324],["thread",7323],["thread",7322],["thread",7321],["thread",7320],["thread",7297],["thread",7282],["thread",7281],["thread",7280],["thread",7279],["thread",7278],["thread",7265],["thread",7262],["thread",7261],["thread",7260],["thread",7259],["thread",7258],["thread",7242],["thread",7215],["thread",7213],["thread",7211],["thread",7198],["thread",7196],["thread",7194],["thread",7184],["thread",7182],["thread",7179],["thread",7177],["thread",7175],["thread",7160],["thread",7146],["thread",7144],["thread",7142],["thread",7120],["thread",7118],["thread",7116],["thread",7113],["thread",7110],["thread",7102],["thread",7094],["thread",7090],["thread",7076],["thread",7073],["thread",7070],["thread",7066],["thread",7016],["thread",7014],["thread",6960],["thread",6958],["thread",6927],["thread",6880],["thread",6784],["thread",6783],["thread",6759],["thread",6758],["thread",6718],["thread",6717],["thread",6716],["thread",6715],["thread",6695],["thread",6694],["thread",6693]]
Run Time: 0.000531