[2021-08-07T09:13:57+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:13:57+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:13:57+08:00][sql] CONNECT:[ UseTime:0.000620s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001142s ] [2021-08-07T09:13:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000326s ] [2021-08-07T09:13:57+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000399s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.001073s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000359s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000728s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000383s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000808s ] [2021-08-07T09:13:57+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000359s ] [2021-08-07T09:13:57+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:13:57+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:13:57+08:00][sql] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001134s ] [2021-08-07T09:13:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000280s ] [2021-08-07T09:13:57+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000458s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000836s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000294s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000670s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000380s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000570s ] [2021-08-07T09:13:57+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000285s ] [2021-08-07T09:13:57+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:13:57+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:13:57+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001021s ] [2021-08-07T09:13:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000367s ] [2021-08-07T09:13:57+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000409s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000654s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000266s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000692s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000369s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000629s ] [2021-08-07T09:13:57+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000344s ] [2021-08-07T09:13:57+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:13:57+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:13:57+08:00][sql] CONNECT:[ UseTime:0.000672s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001169s ] [2021-08-07T09:13:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000495s ] [2021-08-07T09:13:57+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000555s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.001000s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000374s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000899s ] [2021-08-07T09:13:57+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000483s ] [2021-08-07T09:13:57+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000825s ] [2021-08-07T09:13:57+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000445s ] [2021-08-07T09:15:35+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:15:35+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:15:35+08:00][sql] CONNECT:[ UseTime:0.000639s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001022s ] [2021-08-07T09:15:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000532s ] [2021-08-07T09:15:35+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000456s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000891s ] [2021-08-07T09:15:35+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000548s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000768s ] [2021-08-07T09:15:35+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000309s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000857s ] [2021-08-07T09:15:35+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000344s ] [2021-08-07T09:15:35+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:15:35+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:15:35+08:00][sql] CONNECT:[ UseTime:0.000474s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001061s ] [2021-08-07T09:15:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000300s ] [2021-08-07T09:15:35+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000382s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.002092s ] [2021-08-07T09:15:35+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000259s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000776s ] [2021-08-07T09:15:35+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000490s ] [2021-08-07T09:15:35+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.001122s ] [2021-08-07T09:15:35+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000353s ] [2021-08-07T09:23:36+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:23:36+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:23:36+08:00][sql] CONNECT:[ UseTime:0.000592s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001041s ] [2021-08-07T09:23:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000389s ] [2021-08-07T09:23:36+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000619s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000881s ] [2021-08-07T09:23:36+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000368s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000794s ] [2021-08-07T09:23:36+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000472s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000795s ] [2021-08-07T09:23:36+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000429s ] [2021-08-07T09:23:36+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:23:36+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:23:36+08:00][sql] CONNECT:[ UseTime:0.000634s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000940s ] [2021-08-07T09:23:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000399s ] [2021-08-07T09:23:36+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000373s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000683s ] [2021-08-07T09:23:36+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000307s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000706s ] [2021-08-07T09:23:36+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000429s ] [2021-08-07T09:23:36+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000776s ] [2021-08-07T09:23:36+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000376s ] [2021-08-07T09:25:08+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:25:08+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:25:08+08:00][sql] CONNECT:[ UseTime:0.000834s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001287s ] [2021-08-07T09:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000597s ] [2021-08-07T09:25:08+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000548s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000905s ] [2021-08-07T09:25:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000345s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000715s ] [2021-08-07T09:25:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000480s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000823s ] [2021-08-07T09:25:08+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000324s ] [2021-08-07T09:25:08+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:25:08+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:25:08+08:00][sql] CONNECT:[ UseTime:0.000662s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001042s ] [2021-08-07T09:25:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000393s ] [2021-08-07T09:25:08+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000487s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000755s ] [2021-08-07T09:25:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000277s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000808s ] [2021-08-07T09:25:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000475s ] [2021-08-07T09:25:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000902s ] [2021-08-07T09:25:08+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000359s ] [2021-08-07T09:34:22+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:34:22+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:34:22+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000956s ] [2021-08-07T09:34:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000332s ] [2021-08-07T09:34:22+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000339s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000626s ] [2021-08-07T09:34:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000248s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000733s ] [2021-08-07T09:34:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000470s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000795s ] [2021-08-07T09:34:22+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000246s ] [2021-08-07T09:34:22+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:34:22+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:34:22+08:00][sql] CONNECT:[ UseTime:0.000687s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001240s ] [2021-08-07T09:34:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000383s ] [2021-08-07T09:34:22+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000570s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000808s ] [2021-08-07T09:34:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000297s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000698s ] [2021-08-07T09:34:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000361s ] [2021-08-07T09:34:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000778s ] [2021-08-07T09:34:22+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000375s ] [2021-08-07T09:47:43+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:47:43+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:47:43+08:00][sql] CONNECT:[ UseTime:0.000611s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001197s ] [2021-08-07T09:47:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000352s ] [2021-08-07T09:47:43+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000381s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000610s ] [2021-08-07T09:47:43+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000334s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000760s ] [2021-08-07T09:47:43+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000342s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000780s ] [2021-08-07T09:47:43+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000293s ] [2021-08-07T09:47:43+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:47:43+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:47:43+08:00][sql] CONNECT:[ UseTime:0.000770s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001090s ] [2021-08-07T09:47:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000452s ] [2021-08-07T09:47:43+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000599s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000803s ] [2021-08-07T09:47:43+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000360s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000692s ] [2021-08-07T09:47:43+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000293s ] [2021-08-07T09:47:43+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000631s ] [2021-08-07T09:47:43+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000295s ] [2021-08-07T09:53:39+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:53:39+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:53:39+08:00][sql] CONNECT:[ UseTime:0.000491s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001180s ] [2021-08-07T09:53:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000344s ] [2021-08-07T09:53:39+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000544s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000630s ] [2021-08-07T09:53:39+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000305s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000765s ] [2021-08-07T09:53:39+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000332s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000674s ] [2021-08-07T09:53:39+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000410s ] [2021-08-07T09:53:39+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:53:39+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:53:39+08:00][sql] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001166s ] [2021-08-07T09:53:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000439s ] [2021-08-07T09:53:39+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000577s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000917s ] [2021-08-07T09:53:39+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000356s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000918s ] [2021-08-07T09:53:39+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000403s ] [2021-08-07T09:53:39+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000740s ] [2021-08-07T09:53:39+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000432s ] [2021-08-07T09:54:45+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:54:45+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:54:45+08:00][sql] CONNECT:[ UseTime:0.000611s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001177s ] [2021-08-07T09:54:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000388s ] [2021-08-07T09:54:45+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000605s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000921s ] [2021-08-07T09:54:45+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000369s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000698s ] [2021-08-07T09:54:45+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000501s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000724s ] [2021-08-07T09:54:45+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000281s ] [2021-08-07T09:54:45+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:54:45+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:54:45+08:00][sql] CONNECT:[ UseTime:0.000475s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000941s ] [2021-08-07T09:54:45+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000298s ] [2021-08-07T09:54:45+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000521s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000616s ] [2021-08-07T09:54:45+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000270s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000634s ] [2021-08-07T09:54:45+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000388s ] [2021-08-07T09:54:45+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.001373s ] [2021-08-07T09:54:45+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000319s ] [2021-08-07T09:58:23+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T09:58:23+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:58:23+08:00][sql] CONNECT:[ UseTime:0.000667s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001230s ] [2021-08-07T09:58:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000517s ] [2021-08-07T09:58:23+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000475s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000906s ] [2021-08-07T09:58:23+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000347s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000671s ] [2021-08-07T09:58:23+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000466s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000834s ] [2021-08-07T09:58:23+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000388s ] [2021-08-07T09:58:23+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T09:58:23+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T09:58:23+08:00][sql] CONNECT:[ UseTime:0.000514s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000900s ] [2021-08-07T09:58:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000524s ] [2021-08-07T09:58:23+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000541s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000709s ] [2021-08-07T09:58:23+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000418s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000908s ] [2021-08-07T09:58:23+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000363s ] [2021-08-07T09:58:23+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000826s ] [2021-08-07T09:58:23+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000317s ] [2021-08-07T10:00:08+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T10:00:08+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:00:08+08:00][sql] CONNECT:[ UseTime:0.000654s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001221s ] [2021-08-07T10:00:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000445s ] [2021-08-07T10:00:08+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000456s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000786s ] [2021-08-07T10:00:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000394s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001095s ] [2021-08-07T10:00:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000456s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.001014s ] [2021-08-07T10:00:08+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000514s ] [2021-08-07T10:00:08+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T10:00:08+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:00:08+08:00][sql] CONNECT:[ UseTime:0.000721s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001002s ] [2021-08-07T10:00:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000363s ] [2021-08-07T10:00:08+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000455s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000800s ] [2021-08-07T10:00:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000309s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000699s ] [2021-08-07T10:00:08+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000430s ] [2021-08-07T10:00:08+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000964s ] [2021-08-07T10:00:08+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000306s ] [2021-08-07T10:49:58+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T10:49:58+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:49:58+08:00][sql] CONNECT:[ UseTime:0.000579s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000968s ] [2021-08-07T10:49:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000389s ] [2021-08-07T10:49:58+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000517s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000686s ] [2021-08-07T10:49:58+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000327s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000735s ] [2021-08-07T10:49:58+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000577s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000916s ] [2021-08-07T10:49:58+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000341s ] [2021-08-07T10:49:58+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T10:49:58+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:49:58+08:00][sql] CONNECT:[ UseTime:0.000596s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001105s ] [2021-08-07T10:49:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000412s ] [2021-08-07T10:49:58+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000347s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000945s ] [2021-08-07T10:49:58+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000345s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000650s ] [2021-08-07T10:49:58+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000319s ] [2021-08-07T10:49:58+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000567s ] [2021-08-07T10:49:58+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000336s ] [2021-08-07T10:57:50+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T10:57:50+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:57:50+08:00][sql] CONNECT:[ UseTime:0.000490s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000951s ] [2021-08-07T10:57:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000557s ] [2021-08-07T10:57:50+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000403s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000798s ] [2021-08-07T10:57:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000280s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000679s ] [2021-08-07T10:57:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000475s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000846s ] [2021-08-07T10:57:50+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000312s ] [2021-08-07T10:57:50+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T10:57:50+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T10:57:50+08:00][sql] CONNECT:[ UseTime:0.000624s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000961s ] [2021-08-07T10:57:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000365s ] [2021-08-07T10:57:50+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000596s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000818s ] [2021-08-07T10:57:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000336s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000757s ] [2021-08-07T10:57:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000361s ] [2021-08-07T10:57:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000687s ] [2021-08-07T10:57:50+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000289s ] [2021-08-07T11:21:22+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T11:21:22+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:21:22+08:00][sql] CONNECT:[ UseTime:0.000663s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001009s ] [2021-08-07T11:21:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000356s ] [2021-08-07T11:21:22+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000367s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000822s ] [2021-08-07T11:21:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000286s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001048s ] [2021-08-07T11:21:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000410s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000913s ] [2021-08-07T11:21:22+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000396s ] [2021-08-07T11:21:22+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T11:21:22+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:21:22+08:00][sql] CONNECT:[ UseTime:0.000511s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001246s ] [2021-08-07T11:21:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000340s ] [2021-08-07T11:21:22+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000315s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000599s ] [2021-08-07T11:21:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000325s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001088s ] [2021-08-07T11:21:22+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000363s ] [2021-08-07T11:21:22+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.002038s ] [2021-08-07T11:21:22+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000359s ] [2021-08-07T11:29:12+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T11:29:12+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:29:12+08:00][sql] CONNECT:[ UseTime:0.000599s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000974s ] [2021-08-07T11:29:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000323s ] [2021-08-07T11:29:12+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000359s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000621s ] [2021-08-07T11:29:12+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000326s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000794s ] [2021-08-07T11:29:12+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000413s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000605s ] [2021-08-07T11:29:12+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000311s ] [2021-08-07T11:29:12+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T11:29:12+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:29:12+08:00][sql] CONNECT:[ UseTime:0.000583s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000961s ] [2021-08-07T11:29:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000297s ] [2021-08-07T11:29:12+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000387s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000723s ] [2021-08-07T11:29:12+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000287s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001033s ] [2021-08-07T11:29:12+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000383s ] [2021-08-07T11:29:12+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000672s ] [2021-08-07T11:29:12+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000281s ] [2021-08-07T11:32:53+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T11:32:53+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:32:53+08:00][sql] CONNECT:[ UseTime:0.000563s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001028s ] [2021-08-07T11:32:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000355s ] [2021-08-07T11:32:53+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000465s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000664s ] [2021-08-07T11:32:53+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000301s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.001239s ] [2021-08-07T11:32:53+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000315s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000599s ] [2021-08-07T11:32:53+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000239s ] [2021-08-07T11:32:53+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T11:32:53+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:32:53+08:00][sql] CONNECT:[ UseTime:0.000485s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001086s ] [2021-08-07T11:32:53+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000363s ] [2021-08-07T11:32:53+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000357s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000556s ] [2021-08-07T11:32:53+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000263s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000633s ] [2021-08-07T11:32:53+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000295s ] [2021-08-07T11:32:53+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000754s ] [2021-08-07T11:32:53+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000273s ] [2021-08-07T11:34:49+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/tops [2021-08-07T11:34:49+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:34:49+08:00][sql] CONNECT:[ UseTime:0.000515s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:34:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.000997s ] [2021-08-07T11:34:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000299s ] [2021-08-07T11:34:49+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `top_status` = 'y' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000462s ] [2021-08-07T11:34:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000712s ] [2021-08-07T11:34:49+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000350s ] [2021-08-07T11:34:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000697s ] [2021-08-07T11:34:49+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (66,37,36) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000274s ] [2021-08-07T11:34:49+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000742s ] [2021-08-07T11:34:49+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (66,37,36) GROUP BY `content_id` [ RunTime:0.000264s ] [2021-08-07T11:34:50+08:00][debug] middleware/Authorise: handle | request path = api.app.Content/dangjianzixun [2021-08-07T11:34:50+08:00][debug] ---$rediskey---app:jwt:vDWblPwrB53bA97Rj8Mi8eaVgoeF9_5pdcolRBMHeNU [2021-08-07T11:34:50+08:00][sql] CONNECT:[ UseTime:0.000683s ] mysql:host=127.0.0.1;port=3306;dbname=dangjian;charset=utf8mb4 [2021-08-07T11:34:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_content` [ RunTime:0.001038s ] [2021-08-07T11:34:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 [ RunTime:0.000424s ] [2021-08-07T11:34:50+08:00][sql] SELECT `id`,`title`,`contents`,`vid`,`icon_path`,`type`,`pics`,`release_time`,`isperson`,`iscomment`,`aid`,`top_status`,`top_icon` FROM `yl_content` WHERE `node_id` = '24' AND `status` = '上线' AND `organ_id` = 2 ORDER BY `sort` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000591s ] [2021-08-07T11:34:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user_action_logs` [ RunTime:0.000832s ] [2021-08-07T11:34:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'praise' ORDER BY `id` DESC [ RunTime:0.000344s ] [2021-08-07T11:34:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_user` [ RunTime:0.000864s ] [2021-08-07T11:34:50+08:00][sql] SELECT `c_id`,`operate_user_id` FROM `yl_user_action_logs` WHERE `c_id` IN (57,66,62,61,60) AND `action` = 'collect' ORDER BY `id` DESC [ RunTime:0.000579s ] [2021-08-07T11:34:50+08:00][sql] SHOW FULL COLUMNS FROM `yl_comment` [ RunTime:0.000883s ] [2021-08-07T11:34:50+08:00][sql] SELECT content_id, count(*) as num FROM `yl_comment` WHERE `content_id` IN (57,66,62,61,60) GROUP BY `content_id` [ RunTime:0.000436s ]