SHOW FULL COLUMNS FROM `libraryList` [ RunTime:0.000000s ]
SELECT `lib_name`,`lib_table`,`lib_bg` FROM `libraryList` WHERE `lib_num` = '2601' LIMIT 1 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `xn_video` [ RunTime:0.015600s ]
SELECT COUNT(*) AS think_count FROM `xn_video` WHERE `lib_num` = '2601' AND `type_id` = 10 [ RunTime:0.000000s ]
SELECT `video_id`,`title`,`author`,`cat_id`,`keyword`,`desc`,`task_year`,`section_num` FROM `xn_video` WHERE `lib_num` = '2601' AND `type_id` = 10 ORDER BY `title` LIMIT 50,5 [ RunTime:0.000000s ]
SELECT SUM(`section_num`) AS think_sum FROM `xn_video` WHERE `lib_num` = '2601' AND `type_id` = 10 [ RunTime:0.015600s ]
SELECT `video_id`,`title`,`author`,`task_year` FROM `xn_video` WHERE `lib_num` = '2601' ORDER BY rand() LIMIT 5 [ RunTime:0.000000s ]
SELECT DISTINCT ANY_VALUE(video_id) as video_id,author,(CASE WHEN LENGTH(ANY_VALUE(author_desc))>50 THEN CONCAT(SUBSTRING(ANY_VALUE(author_desc),1,50),'...') ELSE ANY_VALUE(author_desc) END ) as author_desc,ANY_VALUE(task_year) as task_year FROM `xn_video` WHERE `lib_num` = '2601' GROUP BY `author` ORDER BY rand() LIMIT 3 [ RunTime:0.000000s ]