[ DB ] CONNECT:[ UseTime:0.000659s ] mysql:host=127.0.0.1;port=33889;dbname=jinshi;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `website` [ RunTime:0.000523s ]
[ SQL ] SHOW COLUMNS FROM `website_navigation` [ RunTime:0.000583s ]
[ SQL ] SHOW COLUMNS FROM `model_course` [ RunTime:0.000609s ]
[ SQL ] SELECT `title`,`keywords`,`description` FROM `model_course` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000304s ]
[ 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` = 5 AND `site_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000332s ]
[ SQL ] UPDATE `model_course` SET `views`=`views`+1 WHERE `id` = 5 [ RunTime:0.001174s ]
[ SQL ] SHOW COLUMNS FROM `course_sections` [ RunTime:0.000385s ]
[ SQL ] SELECT * FROM `course_sections` WHERE `course_id` = 5 AND `pid` = 0 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001044s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 5 AND `node_type` = 2 AND `pid` = 174 ORDER BY `weigh` ASC LIMIT 5 [ RunTime:0.001066s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 5 AND `node_type` = 2 AND `id` NOT IN (175,176) ORDER BY `weigh` ASC LIMIT 3 [ RunTime:0.001143s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `course_sections` WHERE `course_id` = 5 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000930s ]
[ SQL ] SELECT SUM(seconds) AS tp_sum FROM `course_sections` WHERE `course_id` = 5 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000968s ]