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 (19083, 18298, 12548, 12546, 12243, 11152, 11132, 11131, 11129, 11117, 11032, 10972, 10937, 10859, 10839, 10838, 10835, 10834, 10315, 10265, 10262, 10209, 10168, 10165, 10164, 10130, 10090, 10089, 10087, 10086, 10069, 10063, 10062, 10038, 10037, 10036, 10035, 10023, 10003, 10002, 10001, 9980, 9861, 9859, 9792, 9791, 9789, 9788, 9753, 9749, 9695, 9694, 9693, 9691, 9675, 9674, 9673, 9672, 9671, 9635, 9633, 9631, 9556, 9554, 9552, 9544, 9543, 9542, 9541, 9540, 8976, 8963, 8667, 8663, 8599, 8397, 8393, 8391, 8380, 8379, 8378, 8377, 8250, 8249, 8248, 8246, 8245, 8216, 8215, 8214, 8213, 8198, 8196, 8194, 8193, 8192, 8191, 8190, 8184, 8167, 8166, 8165, 8164, 8152, 8151, 8150, 8133, 8132, 8131, 8130, 8129, 8112, 8111, 8110, 8109, 8108, 8076, 8075, 8074, 8073, 8072, 8067, 8066, 8064, 8063, 8062, 8032, 8018, 8017, 8016, 8015, 8014, 8011, 8010, 8009, 8008, 8007, 7994, 7993, 7992, 7991, 7990, 7989, 7988, 7987, 7986, 7985, 7975, 7974, 7973, 7972, 7971, 7968, 7967, 7966, 7965, 7964, 7963, 7950, 7948, 7947, 7946, 7945, 7943, 7942, 7941, 7927, 7925, 7895, 7894, 7893, 7892, 7891, 7889, 7887, 7885, 7878, 7876, 7872, 7871, 7855, 7853, 7852, 7851, 7850, 7849, 7848, 7847, 7846, 7845, 7784, 7783, 7718, 7717, 7690, 7688, 7685, 7676, 7675, 7674)
Run Time: 0.013622
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: 358, 0, 1652880703, 1652884303, [["thread",19083],["thread",18298],["thread",12548],["thread",12546],["thread",12243],["thread",11152],["thread",11132],["thread",11131],["thread",11129],["thread",11117],["thread",11032],["thread",10972],["thread",10937],["thread",10859],["thread",10839],["thread",10838],["thread",10835],["thread",10834],["thread",10315],["thread",10265],["thread",10262],["thread",10209],["thread",10168],["thread",10165],["thread",10164],["thread",10130],["thread",10090],["thread",10089],["thread",10087],["thread",10086],["thread",10069],["thread",10063],["thread",10062],["thread",10038],["thread",10037],["thread",10036],["thread",10035],["thread",10023],["thread",10003],["thread",10002],["thread",10001],["thread",9980],["thread",9861],["thread",9859],["thread",9792],["thread",9791],["thread",9789],["thread",9788],["thread",9753],["thread",9749],["thread",9695],["thread",9694],["thread",9693],["thread",9691],["thread",9675],["thread",9674],["thread",9673],["thread",9672],["thread",9671],["thread",9635],["thread",9633],["thread",9631],["thread",9556],["thread",9554],["thread",9552],["thread",9544],["thread",9543],["thread",9542],["thread",9541],["thread",9540],["thread",8976],["thread",8963],["thread",8667],["thread",8663],["thread",8599],["thread",8397],["thread",8393],["thread",8391],["thread",8380],["thread",8379],["thread",8378],["thread",8377],["thread",8250],["thread",8249],["thread",8248],["thread",8246],["thread",8245],["thread",8216],["thread",8215],["thread",8214],["thread",8213],["thread",8198],["thread",8196],["thread",8194],["thread",8193],["thread",8192],["thread",8191],["thread",8190],["thread",8184],["thread",8167],["thread",8166],["thread",8165],["thread",8164],["thread",8152],["thread",8151],["thread",8150],["thread",8133],["thread",8132],["thread",8131],["thread",8130],["thread",8129],["thread",8112],["thread",8111],["thread",8110],["thread",8109],["thread",8108],["thread",8076],["thread",8075],["thread",8074],["thread",8073],["thread",8072],["thread",8067],["thread",8066],["thread",8064],["thread",8063],["thread",8062],["thread",8032],["thread",8018],["thread",8017],["thread",8016],["thread",8015],["thread",8014],["thread",8011],["thread",8010],["thread",8009],["thread",8008],["thread",8007],["thread",7994],["thread",7993],["thread",7992],["thread",7991],["thread",7990],["thread",7989],["thread",7988],["thread",7987],["thread",7986],["thread",7985],["thread",7975],["thread",7974],["thread",7973],["thread",7972],["thread",7971],["thread",7968],["thread",7967],["thread",7966],["thread",7965],["thread",7964],["thread",7963],["thread",7950],["thread",7948],["thread",7947],["thread",7946],["thread",7945],["thread",7943],["thread",7942],["thread",7941],["thread",7927],["thread",7925],["thread",7895],["thread",7894],["thread",7893],["thread",7892],["thread",7891],["thread",7889],["thread",7887],["thread",7885],["thread",7878],["thread",7876],["thread",7872],["thread",7871],["thread",7855],["thread",7853],["thread",7852],["thread",7851],["thread",7850],["thread",7849],["thread",7848],["thread",7847],["thread",7846],["thread",7845],["thread",7784],["thread",7783],["thread",7718],["thread",7717],["thread",7690],["thread",7688],["thread",7685],["thread",7676],["thread",7675],["thread",7674]]
Run Time: 0.000432