[ DB ] CONNECT:[ UseTime:0.000574s ] mysql:host=127.0.0.1;port=33889;dbname=jinshi;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `website` [ RunTime:0.000451s ]
[ SQL ] SHOW COLUMNS FROM `website_navigation` [ RunTime:0.000383s ]
[ SQL ] SHOW COLUMNS FROM `model_course` [ RunTime:0.000458s ]
[ SQL ] SELECT `title`,`keywords`,`description` FROM `model_course` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SELECT id,title,image,url,description,pr_guiding,pr_selling,level,views,type,keywords,CASE `level` WHEN '初级' THEN 'yc-level-1' WHEN '中级' THEN 'yc-level-2' WHEN '高级' THEN 'yc-level-3' ELSE 'yc-level-0' END as level_cls FROM `model_course` WHERE `id` = 6 AND `site_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] UPDATE `model_course` SET `views`=`views`+1 WHERE `id` = 6 [ RunTime:0.001126s ]
[ SQL ] SHOW COLUMNS FROM `course_sections` [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `course_sections` WHERE `course_id` = 6 AND `pid` = 0 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001056s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 6 AND `node_type` = 2 AND `pid` = 200 ORDER BY `weigh` ASC LIMIT 5 [ RunTime:0.001089s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 6 AND `node_type` = 2 AND `id` NOT IN (201,202,203) ORDER BY `weigh` ASC LIMIT 2 [ RunTime:0.001167s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `course_sections` WHERE `course_id` = 6 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000861s ]
[ SQL ] SELECT SUM(seconds) AS tp_sum FROM `course_sections` WHERE `course_id` = 6 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000938s ]
