[ DB ] CONNECT:[ UseTime:0.007748s ] mysql:host=127.0.0.1;port=33889;dbname=jinshi;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `website` [ RunTime:0.002456s ]
[ SQL ] SHOW COLUMNS FROM `website_navigation` [ RunTime:0.001057s ]
[ SQL ] SHOW COLUMNS FROM `model_course` [ RunTime:0.001172s ]
[ SQL ] SELECT `title`,`keywords`,`description` FROM `model_course` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000642s ]
[ 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` = 22 AND `site_id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000389s ]
[ SQL ] UPDATE `model_course` SET `views`=`views`+1 WHERE `id` = 22 [ RunTime:0.001371s ]
[ SQL ] SHOW COLUMNS FROM `course_sections` [ RunTime:0.000616s ]
[ SQL ] SELECT * FROM `course_sections` WHERE `course_id` = 22 AND `pid` = 0 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT `id`,`pid`,`node_type`,`course_id`,`name`,`duration`,`seconds` FROM `course_sections` WHERE `course_id` = 22 AND `node_type` = 2 AND `pid` = 975 ORDER BY `weigh` ASC LIMIT 5 [ RunTime:0.000224s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `course_sections` WHERE `course_id` = 22 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000210s ]
[ SQL ] SELECT SUM(seconds) AS tp_sum FROM `course_sections` WHERE `course_id` = 22 AND `node_type` = 2 LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT title,url,image,views,level,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 ( FIND_IN_SET('4',posids) ) AND `site_id` = 1 AND `status` = 1 LIMIT 3 [ RunTime:0.000347s ]
[ SQL ] SHOW COLUMNS FROM `course_type` [ RunTime:0.000538s ]
[ SQL ] SELECT `name` FROM `course_type` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000212s ]
