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 (25213, 25187, 24992, 24850, 24668, 24632, 24630, 24504, 24457, 24456, 24230, 24229, 24146, 22954, 22703, 22623, 22610, 21926, 21739, 21499, 21191, 20992, 20910, 20876, 20756, 20746, 20731, 20509, 20339, 19924, 19612, 19611, 19610, 19474, 19194, 18583, 18562, 18378, 18377, 18372, 18248, 18244, 18074, 17962, 17848, 17827, 17601, 17599, 17597, 17534, 17416, 17415, 17413, 17412, 17411, 17161, 17123, 17055, 16659, 16569, 16568, 16567, 16566, 16565, 16564, 16563, 16562, 16561, 16560, 16559, 16558, 16557, 16556, 16555, 16554, 16553, 16552, 16551, 16550, 16549, 16548, 16547, 16546, 16545, 16544, 16543, 16542, 16541, 16540, 16539, 16538, 16537, 16536, 16535, 16534, 16533, 16532, 16529, 16528, 16527, 16526, 16525, 16524, 16523, 16520, 16519, 16518, 16517, 16515, 16514, 16513, 16512, 16511, 16360, 16343, 15918, 15492, 15491, 15489, 15488, 14682, 14364, 14031, 14030, 13356, 12032, 11766, 11756, 11690, 11491, 11407, 11406, 11405, 11404, 11403, 11402, 11401, 11400, 11399, 11398, 11397, 11396, 11394, 11393, 11392, 11391, 11390, 11389, 11388, 11387, 11386, 11385, 11384, 11383, 11382, 11381, 11380, 11379, 11378, 11377, 11376, 11375, 11374, 11371, 11143, 10352, 10029, 10028, 9953, 9797, 9732, 9478, 9355, 9221, 9165, 8918, 8262, 8042, 7641, 7242, 7086, 7023, 6928, 5801, 5800, 5734, 4872, 4331, 4317, 4294, 4260, 3842, 3841, 3840, 3646, 3560, 3555, 3551, 3550, 3535, 3531, 3529, 3528, 3526, 3524, 3522, 3519, 3518, 3517, 3515, 3514, 3513, 3502, 3477, 2669, 2654, 2598, 2578, 2351, 2347, 2346, 2302, 2301, 2266, 2192, 2191, 2190, 2171, 2146, 2053, 1964, 1945, 1839, 1838, 1832, 1831, 1825, 1824, 1822, 1820, 1819, 1818, 1817, 1816, 1815, 1814, 1813, 1812, 1810, 1803, 1723, 1701, 1665, 1653, 1602, 1549, 1548, 1547, 1531, 1477, 1315, 1273, 1268, 1205, 1204, 1200, 1199, 1196, 1046, 1016, 979, 975, 881, 849, 815, 637, 604, 451, 420, 413, 412, 409, 376, 329, 185, 164, 163, 162, 161)
Run Time: 0.073149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 289 | 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: 254, 0, 1711692405, 1711696005, {"0":["thread",25213],"1":["thread",25187],"2":["thread",24992],"3":["thread",24850],"4":["thread",24668],"5":["thread",24632],"6":["thread",24630],"7":["thread",24504],"8":["thread",24457],"9":["thread",24456],"10":["thread",24230],"11":["thread",24229],"12":["thread",24146],"13":["thread",22954],"14":["thread",22703],"15":["thread",22623],"16":["thread",22610],"17":["thread",21926],"19":["thread",21499],"20":["thread",21191],"21":["thread",20992],"22":["thread",20910],"23":["thread",20876],"24":["thread",20756],"25":["thread",20746],"26":["thread",20731],"27":["thread",20509],"28":["thread",20339],"29":["thread",19924],"30":["thread",19612],"31":["thread",19611],"32":["thread",19610],"33":["thread",19474],"34":["thread",19194],"35":["thread",18583],"36":["thread",18562],"37":["thread",18378],"38":["thread",18377],"39":["thread",18372],"40":["thread",18248],"41":["thread",18244],"42":["thread",18074],"43":["thread",17962],"44":["thread",17848],"45":["thread",17827],"46":["thread",17601],"47":["thread",17599],"48":["thread",17597],"49":["thread",17534],"50":["thread",17416],"51":["thread",17415],"52":["thread",17413],"53":["thread",17412],"54":["thread",17411],"55":["thread",17161],"56":["thread",17123],"57":["thread",17055],"58":["thread",16659],"59":["thread",16569],"60":["thread",16568],"61":["thread",16567],"62":["thread",16566],"63":["thread",16565],"64":["thread",16564],"65":["thread",16563],"66":["thread",16562],"67":["thread",16561],"68":["thread",16560],"69":["thread",16559],"70":["thread",16558],"71":["thread",16557],"72":["thread",16556],"73":["thread",16555],"74":["thread",16554],"75":["thread",16553],"76":["thread",16552],"77":["thread",16551],"78":["thread",16550],"79":["thread",16549],"80":["thread",16548],"81":["thread",16547],"82":["thread",16546],"83":["thread",16545],"84":["thread",16544],"85":["thread",16543],"86":["thread",16542],"87":["thread",16541],"88":["thread",16540],"89":["thread",16539],"90":["thread",16538],"91":["thread",16537],"92":["thread",16536],"93":["thread",16535],"94":["thread",16534],"95":["thread",16533],"96":["thread",16532],"97":["thread",16529],"98":["thread",16528],"99":["thread",16527],"100":["thread",16526],"101":["thread",16525],"102":["thread",16524],"103":["thread",16523],"104":["thread",16520],"105":["thread",16519],"106":["thread",16518],"107":["thread",16517],"108":["thread",16515],"109":["thread",16514],"110":["thread",16513],"111":["thread",16512],"112":["thread",16511],"113":["thread",16360],"114":["thread",16343],"115":["thread",15918],"116":["thread",15492],"117":["thread",15491],"118":["thread",15489],"119":["thread",15488],"120":["thread",14682],"121":["thread",14364],"122":["thread",14031],"123":["thread",14030],"124":["thread",13356],"125":["thread",12032],"126":["thread",11766],"127":["thread",11756],"128":["thread",11690],"130":["thread",11407],"131":["thread",11406],"132":["thread",11405],"133":["thread",11404],"134":["thread",11403],"135":["thread",11402],"136":["thread",11401],"137":["thread",11400],"138":["thread",11399],"139":["thread",11398],"140":["thread",11397],"141":["thread",11396],"142":["thread",11394],"143":["thread",11393],"144":["thread",11392],"145":["thread",11391],"146":["thread",11390],"147":["thread",11389],"148":["thread",11388],"149":["thread",11387],"150":["thread",11386],"151":["thread",11385],"152":["thread",11384],"153":["thread",11383],"154":["thread",11382],"155":["thread",11381],"156":["thread",11380],"157":["thread",11379],"158":["thread",11378],"159":["thread",11377],"160":["thread",11376],"161":["thread",11375],"162":["thread",11374],"163":["thread",11371],"164":["thread",11143],"165":["thread",10352],"166":["thread",10029],"167":["thread",10028],"168":["thread",9953],"169":["thread",9797],"170":["thread",9732],"171":["thread",9478],"172":["thread",9355],"173":["thread",9221],"174":["thread",9165],"175":["thread",8918],"176":["thread",8262],"177":["thread",8042],"178":["thread",7641],"179":["thread",7242],"180":["thread",7086],"181":["thread",7023],"182":["thread",6928],"183":["thread",5801],"184":["thread",5800],"185":["thread",5734],"186":["thread",4872],"187":["thread",4331],"188":["thread",4317],"189":["thread",4294],"190":["thread",4260],"191":["thread",3842],"192":["thread",3841],"193":["thread",3840],"194":["thread",3646],"195":["thread",3560],"196":["thread",3555],"197":["thread",3551],"198":["thread",3550],"199":["thread",3535],"200":["thread",3531],"201":["thread",3529],"202":["thread",3528],"203":["thread",3526],"204":["thread",3524],"205":["thread",3522],"206":["thread",3519],"207":["thread",3518],"208":["thread",3517],"209":["thread",3515],"210":["thread",3514],"211":["thread",3513],"212":["thread",3502],"213":["thread",3477],"214":["thread",2669],"215":["thread",2654],"216":["thread",2598],"217":["thread",2578],"218":["thread",2351],"219":["thread",2347],"220":["thread",2346],"221":["thread",2302],"222":["thread",2301],"223":["thread",2266],"224":["thread",2192],"225":["thread",2191],"226":["thread",2190],"227":["thread",2171],"228":["thread",2146],"229":["thread",2053],"230":["thread",1964],"231":["thread",1945],"232":["thread",1839],"233":["thread",1838],"234":["thread",1832],"235":["thread",1831],"236":["thread",1825],"237":["thread",1824],"238":["thread",1822],"239":["thread",1820],"240":["thread",1819],"241":["thread",1818],"242":["thread",1817],"243":["thread",1816],"244":["thread",1815],"245":["thread",1814],"246":["thread",1813],"247":["thread",1812],"248":["thread",1810],"249":["thread",1803],"250":["thread",1723],"251":["thread",1701],"252":["thread",1665],"253":["thread",1653],"254":["thread",1602],"255":["thread",1549],"256":["thread",1548],"257":["thread",1547],"258":["thread",1531],"259":["thread",1477],"260":["thread",1315],"261":["thread",1273],"262":["thread",1268],"263":["thread",1205],"264":["thread",1204],"265":["thread",1200],"266":["thread",1199],"267":["thread",1196],"268":["thread",1046],"269":["thread",1016],"270":["thread",979],"271":["thread",975],"272":["thread",881],"273":["thread",849],"274":["thread",815],"275":["thread",637],"276":["thread",604],"277":["thread",451],"278":["thread",420],"279":["thread",413],"280":["thread",412],"281":["thread",409],"282":["thread",376],"283":["thread",329],"284":["thread",185],"285":["thread",164],"286":["thread",163],"287":["thread",162],"288":["thread",161]}
Run Time: 0.004259