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 (25222, 25211, 25101, 25049, 25048, 25021, 24793, 24780, 24701, 24647, 24634, 24587, 24455, 24263, 24174, 23859, 23815, 23814, 23668, 23541, 23540, 23539, 23296, 23021, 22987, 22842, 22822, 22819, 22815, 22757, 22636, 22635, 22547, 21939, 21938, 21922, 21883, 21638, 21474, 21440, 21388, 21358, 21333, 21136, 21106, 21092, 21079, 21013, 20945, 20938, 20891, 20876, 20735, 20734, 20699, 20611, 20364, 20362, 20344, 20342, 20324, 19998, 19893, 19891, 19736, 19672, 19592, 19578, 19527, 19521, 19473, 19468, 19463, 19434, 19147, 18850, 18845, 18829, 18823, 18745, 18626, 18291, 18244, 18117, 18092, 18090, 17967, 17790, 17768, 17589, 17547, 17541, 17539, 17538, 17492, 17489, 17488, 17485, 17484, 17438, 17437, 17436, 17434, 17433, 17273, 17133, 17048, 16974, 16966, 16961, 16916, 16751, 16619, 16434, 16407, 16406, 16383, 16287, 16245, 16244, 16086, 16035, 15981, 15978, 15862, 15833, 15672, 15525, 15429, 15404, 15403, 15386, 15273, 15266, 15168, 15016, 14917, 14916, 14915, 14914, 14913, 14912, 14911, 14910, 14847, 14475, 14431, 14414, 14377, 14341, 14230, 14196, 14189, 14188, 14187, 14186, 13940, 13647, 13539, 13525, 13521, 13502, 13316, 13258, 12860, 12855, 12669, 12588, 12526, 12335, 12334, 12124, 11857, 11749, 11748, 11590, 11060, 10795, 10760, 10623, 10316, 10311, 10221, 9465, 9452, 8694, 7076, 3693, 2912, 1585, 1537, 942, 725, 307)
Run Time: 0.118017
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 194 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dien7104_tailieu.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dien7104_tailieu.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: 572, 0, 1711696629, 1711700229, {"0":["thread",25222],"1":["thread",25211],"2":["thread",25101],"3":["thread",25049],"4":["thread",25048],"5":["thread",25021],"7":["thread",24780],"8":["thread",24701],"9":["thread",24647],"10":["thread",24634],"11":["thread",24587],"12":["thread",24455],"13":["thread",24263],"14":["thread",24174],"15":["thread",23859],"16":["thread",23815],"17":["thread",23814],"18":["thread",23668],"19":["thread",23541],"20":["thread",23540],"21":["thread",23539],"22":["thread",23296],"23":["thread",23021],"24":["thread",22987],"25":["thread",22842],"26":["thread",22822],"27":["thread",22819],"28":["thread",22815],"29":["thread",22757],"30":["thread",22636],"31":["thread",22635],"32":["thread",22547],"33":["thread",21939],"34":["thread",21938],"35":["thread",21922],"36":["thread",21883],"37":["thread",21638],"38":["thread",21474],"39":["thread",21440],"40":["thread",21388],"41":["thread",21358],"42":["thread",21333],"43":["thread",21136],"44":["thread",21106],"45":["thread",21092],"46":["thread",21079],"47":["thread",21013],"48":["thread",20945],"49":["thread",20938],"50":["thread",20891],"51":["thread",20876],"52":["thread",20735],"53":["thread",20734],"54":["thread",20699],"55":["thread",20611],"56":["thread",20364],"57":["thread",20362],"58":["thread",20344],"59":["thread",20342],"60":["thread",20324],"61":["thread",19998],"62":["thread",19893],"63":["thread",19891],"64":["thread",19736],"65":["thread",19672],"66":["thread",19592],"67":["thread",19578],"68":["thread",19527],"69":["thread",19521],"70":["thread",19473],"71":["thread",19468],"72":["thread",19463],"73":["thread",19434],"74":["thread",19147],"75":["thread",18850],"76":["thread",18845],"77":["thread",18829],"78":["thread",18823],"79":["thread",18745],"80":["thread",18626],"81":["thread",18291],"82":["thread",18244],"83":["thread",18117],"84":["thread",18092],"85":["thread",18090],"86":["thread",17967],"87":["thread",17790],"88":["thread",17768],"89":["thread",17589],"90":["thread",17547],"91":["thread",17541],"92":["thread",17539],"93":["thread",17538],"94":["thread",17492],"95":["thread",17489],"96":["thread",17488],"97":["thread",17485],"98":["thread",17484],"99":["thread",17438],"100":["thread",17437],"101":["thread",17436],"102":["thread",17434],"103":["thread",17433],"104":["thread",17273],"105":["thread",17133],"106":["thread",17048],"107":["thread",16974],"108":["thread",16966],"109":["thread",16961],"110":["thread",16916],"111":["thread",16751],"112":["thread",16619],"113":["thread",16434],"114":["thread",16407],"115":["thread",16406],"116":["thread",16383],"117":["thread",16287],"118":["thread",16245],"119":["thread",16244],"120":["thread",16086],"121":["thread",16035],"122":["thread",15981],"123":["thread",15978],"124":["thread",15862],"125":["thread",15833],"126":["thread",15672],"127":["thread",15525],"128":["thread",15429],"129":["thread",15404],"130":["thread",15403],"131":["thread",15386],"132":["thread",15273],"133":["thread",15266],"134":["thread",15168],"135":["thread",15016],"136":["thread",14917],"137":["thread",14916],"138":["thread",14915],"139":["thread",14914],"140":["thread",14913],"141":["thread",14912],"142":["thread",14911],"143":["thread",14910],"144":["thread",14847],"145":["thread",14475],"146":["thread",14431],"147":["thread",14414],"148":["thread",14377],"149":["thread",14341],"150":["thread",14230],"151":["thread",14196],"152":["thread",14189],"153":["thread",14188],"154":["thread",14187],"155":["thread",14186],"156":["thread",13940],"157":["thread",13647],"158":["thread",13539],"159":["thread",13525],"160":["thread",13521],"161":["thread",13502],"162":["thread",13316],"163":["thread",13258],"164":["thread",12860],"165":["thread",12855],"166":["thread",12669],"167":["thread",12588],"168":["thread",12526],"169":["thread",12335],"170":["thread",12334],"171":["thread",12124],"172":["thread",11857],"173":["thread",11749],"174":["thread",11748],"175":["thread",11590],"176":["thread",11060],"177":["thread",10795],"178":["thread",10760],"179":["thread",10623],"180":["thread",10316],"181":["thread",10311],"182":["thread",10221],"183":["thread",9465],"184":["thread",9452],"185":["thread",8694],"186":["thread",7076],"187":["thread",3693],"188":["thread",2912],"189":["thread",1585],"190":["thread",1537],"191":["thread",942],"192":["thread",725],"193":["thread",307]}
Run Time: 0.006622