[ DB ] CONNECT:[ UseTime:0.000561s ] mysql:host=127.0.0.1;port=33889;dbname=jinshi;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `website` [ RunTime:0.000431s ]
[ SQL ] SHOW COLUMNS FROM `website_navigation` [ RunTime:0.000717s ]
[ SQL ] SHOW COLUMNS FROM `model_course` [ RunTime:0.000411s ]
[ SQL ] SELECT `title`,`keywords`,`description` FROM `model_course` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000243s ]
[ 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` = 12 AND `site_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] UPDATE `model_course` SET `views`=`views`+1 WHERE `id` = 12 [ RunTime:0.001063s ]
[ SQL ] SHOW COLUMNS FROM `course_sections` [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `course_sections` WHERE `course_id` = 12 AND `pid` = 0 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001047s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 12 AND `node_type` = 2 AND `pid` = 450 ORDER BY `weigh` ASC LIMIT 5 [ RunTime:0.001070s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 12 AND `node_type` = 2 AND `id` NOT IN (451,452,453,454) ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001136s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `course_sections` WHERE `course_id` = 12 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000870s ]
[ SQL ] SELECT SUM(seconds) AS tp_sum FROM `course_sections` WHERE `course_id` = 12 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000947s ]