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,
social_forum.title AS social_forum_title, social_forum.user_id AS social_forum_user_id, social_forum.style_id AS social_forum_style_id,
IF (social_forum.title, social_forum.title, node.title) AS node_title
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)
LEFT JOIN xf_social_forum AS social_forum ON
(social_forum.social_forum_id = thread.social_forum_id)
WHERE thread.thread_id IN (98003, 97947, 97779, 96471, 96363, 91995, 91782, 89618, 89471, 89318, 89306, 89281, 89172, 89105, 88946, 88891, 88738, 88731, 88728, 87418, 86909, 86746, 86518, 86409, 85190, 84281, 83607, 83341, 82647, 82633, 82201, 82200, 82065, 81922, 81774, 81760, 81146, 81084, 81014, 80673, 80462, 80409, 80169, 79443, 79408, 79289, 79266, 79242, 79201, 79125, 78893, 78825, 78604, 77947, 76898, 76883, 76766, 76565, 76529, 76331, 76320, 75846, 75453, 75375, 75234, 74995, 74820, 74718, 74715, 74678, 74598, 72719, 72511, 70202, 70181, 69598, 69221, 68409, 68133, 67364, 67211, 66932, 66420, 66377, 66333, 66286, 66254, 65734, 65546, 65512, 65495, 65252, 64793, 64502, 64133, 63982, 63893, 63747, 63064, 72187, 62481, 62414, 61733, 61732, 61609, 61552, 61453, 58636, 58611, 58338, 58158, 57573, 57269, 56800, 56284, 56168, 55677, 55608, 55375, 55017, 54816, 54770, 54547, 54383, 54155, 54154, 53947, 53863, 52892, 52692, 51613, 50524, 49952, 49169, 48066, 48006, 47958, 47872, 47635, 47129, 46925, 45741, 45645, 45458, 45438, 45261, 45165, 45025, 44729, 44583, 44506, 44081, 43985, 43793, 43500, 43418, 43155, 43093, 42821, 42042, 42041, 41504, 41479, 40864, 40293, 40271, 39490, 39021, 36172, 35961, 35819, 35818, 35773, 35493, 34998, 33637, 33401, 33024, 32897, 31859, 31659, 31043, 30456, 30199, 29893, 29690, 28794, 28780, 28771, 28109, 27606, 27499, 27472, 27268, 27169, 27091, 26950, 26804, 26772, 26649, 26494, 26247, 26198, 26155, 26055, 25883, 25626, 25625, 25520, 25383, 25351, 25233, 24819, 24512, 23855, 23770, 23554, 23424, 23285, 23275, 23205, 23024, 22980, 22788, 22429, 22425, 22261, 22193, 21815, 21403, 21356, 21127, 20998, 20997, 20852, 20372, 20369, 20319, 20266, 20240, 19925, 19735, 19365, 18827, 18293, 18187, 17998, 17983, 17978, 17846, 17774, 17274, 16674, 16152, 15787, 15457, 15047, 14654, 14589, 14563, 14215, 14126, 14070, 13816, 13724, 13453, 13259, 12837, 12403, 12402, 12146, 11902, 11825, 11806, 11781, 11214, 11042, 11036, 11004, 10927, 10926, 10809, 10722, 10666, 10468, 10451, 10439, 10437, 10345, 10303, 10276, 10264, 10215, 10213, 10155, 10145, 10126, 10089, 10081, 10069, 10063, 10047, 10043, 10041, 9916, 9901, 9869, 9797, 3173, 1142)
Run Time: 0.026927
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 310 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | bs_xf.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | bs_xf.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | bs_xf.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,bs_xf.thread.node_id | 1 | Using where |
SIMPLE | social_forum | eq_ref | PRIMARY | PRIMARY | 4 | bs_xf.thread.social_forum_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: 240, 0, 1575759306, 1575762906, [["thread",98003],["thread",97947],["thread",97779],["thread",96471],["thread",96363],["thread",91995],["thread",91782],["thread",89618],["thread",89471],["thread",89318],["thread",89306],["thread",89281],["thread",89172],["thread",89105],["thread",88946],["thread",88891],["thread",88738],["thread",88731],["thread",88728],["thread",87418],["thread",86909],["thread",86746],["thread",86518],["thread",86409],["thread",85190],["thread",84281],["thread",83607],["thread",83341],["thread",82647],["thread",82633],["thread",82201],["thread",82200],["thread",82065],["thread",81922],["thread",81774],["thread",81760],["thread",81146],["thread",81084],["thread",81014],["thread",80673],["thread",80462],["thread",80409],["thread",80169],["thread",79443],["thread",79408],["thread",79289],["thread",79266],["thread",79242],["thread",79201],["thread",79125],["thread",78893],["thread",78825],["thread",78604],["thread",77947],["thread",76898],["thread",76883],["thread",76766],["thread",76565],["thread",76529],["thread",76331],["thread",76320],["thread",75846],["thread",75453],["thread",75375],["thread",75234],["thread",74995],["thread",74820],["thread",74718],["thread",74715],["thread",74678],["thread",74598],["thread",72719],["thread",72511],["thread",70202],["thread",70181],["thread",69598],["thread",69221],["thread",68409],["thread",68133],["thread",67364],["thread",67211],["thread",66932],["thread",66420],["thread",66377],["thread",66333],["thread",66286],["thread",66254],["thread",65734],["thread",65546],["thread",65512],["thread",65495],["thread",65252],["thread",64793],["thread",64502],["thread",64133],["thread",63982],["thread",63893],["thread",63747],["thread",63064],["thread",72187],["thread",62481],["thread",62414],["thread",61733],["thread",61732],["thread",61609],["thread",61552],["thread",61453],["thread",58636],["thread",58611],["thread",58338],["thread",58158],["thread",57573],["thread",57269],["thread",56800],["thread",56284],["thread",56168],["thread",55677],["thread",55608],["thread",55375],["thread",55017],["thread",54816],["thread",54770],["thread",54547],["thread",54383],["thread",54155],["thread",54154],["thread",53947],["thread",53863],["thread",52892],["thread",52692],["thread",51613],["thread",50524],["thread",49952],["thread",49169],["thread",48066],["thread",48006],["thread",47958],["thread",47872],["thread",47635],["thread",47129],["thread",46925],["thread",45741],["thread",45645],["thread",45458],["thread",45438],["thread",45261],["thread",45165],["thread",45025],["thread",44729],["thread",44583],["thread",44506],["thread",44081],["thread",43985],["thread",43793],["thread",43500],["thread",43418],["thread",43155],["thread",43093],["thread",42821],["thread",42042],["thread",42041],["thread",41504],["thread",41479],["thread",40864],["thread",40293],["thread",40271],["thread",39490],["thread",39021],["thread",36172],["thread",35961],["thread",35819],["thread",35818],["thread",35773],["thread",35493],["thread",34998],["thread",33637],["thread",33401],["thread",33024],["thread",32897],["thread",31859],["thread",31659],["thread",31043],["thread",30456],["thread",30199],["thread",29893],["thread",29690],["thread",28794],["thread",28780],["thread",28771],["thread",28109],["thread",27606],["thread",27499],["thread",27472],["thread",27268],["thread",27169],["thread",27091],["thread",26950],["thread",26804],["thread",26772],["thread",26649],["thread",26494],["thread",26247],["thread",26198],["thread",26155],["thread",26055],["thread",25883],["thread",25626],["thread",25625],["thread",25520],["thread",25383],["thread",25351],["thread",25233],["thread",24819],["thread",24512],["thread",23855],["thread",23770],["thread",23554],["thread",23424],["thread",23285],["thread",23275],["thread",23205],["thread",23024],["thread",22980],["thread",22788],["thread",22429],["thread",22425],["thread",22261],["thread",22193],["thread",21815],["thread",21403],["thread",21356],["thread",21127],["thread",20998],["thread",20997],["thread",20852],["thread",20372],["thread",20369],["thread",20319],["thread",20266],["thread",20240],["thread",19925],["thread",19735],["thread",19365],["thread",18827],["thread",18293],["thread",18187],["thread",17998],["thread",17983],["thread",17978],["thread",17846],["thread",17774],["thread",17274],["thread",16674],["thread",16152],["thread",15787],["thread",15457],["thread",15047],["thread",14654],["thread",14589],["thread",14563],["thread",14215],["thread",14126],["thread",14070],["thread",13816],["thread",13724],["thread",13453],["thread",13259],["thread",12837],["thread",12403],["thread",12402],["thread",12146],["thread",11902],["thread",11825],["thread",11806],["thread",11781],["thread",11214],["thread",11042],["thread",11036],["thread",11004],["thread",10927],["thread",10926],["thread",10809],["thread",10722],["thread",10666],["thread",10468],["thread",10451],["thread",10439],["thread",10437],["thread",10345],["thread",10303],["thread",10276],["thread",10264],["thread",10215],["thread",10213],["thread",10155],["thread",10145],["thread",10126],["thread",10089],["thread",10081],["thread",10069],["thread",10063],["thread",10047],["thread",10043],["thread",10041],["thread",9916],["thread",9901],["thread",9869],["thread",9797],["thread",3173],["thread",1142]]
Run Time: 0.009710