[ DB ] CONNECT:[ UseTime:0.000163s ] mysql:host=localhost;port=3306;dbname=dyg;charset=utf8
[ SQL ] SHOW COLUMNS FROM `qm_dance_cate` [ RunTime:0.000488s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 13 ORDER BY `sort` ASC [ RunTime:0.000128s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 4 ORDER BY `sort` ASC [ RunTime:0.000092s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 2 ORDER BY `sort` ASC [ RunTime:0.000106s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 1 ORDER BY `sort` ASC [ RunTime:0.000090s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 6 ORDER BY `sort` ASC [ RunTime:0.000064s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 7 ORDER BY `sort` ASC [ RunTime:0.000060s ]
[ SQL ] SELECT `id`,`name` FROM `qm_dance_cate` WHERE `status` = 1 AND `p_id` = 3 ORDER BY `sort` ASC [ RunTime:0.000060s ]
[ SQL ] SHOW COLUMNS FROM `qm_album` [ RunTime:0.000493s ]
[ SQL ] SELECT `id`,`name`,`hits`,`path` FROM `qm_album` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 0,20 [ RunTime:0.000236s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album` WHERE `status` = 1 [ RunTime:0.000112s ]
[ SQL ] SHOW COLUMNS FROM `qm_album_dance` [ RunTime:0.000382s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 551 [ RunTime:0.000083s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 1204 [ RunTime:0.000064s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 775 [ RunTime:0.000045s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 762 [ RunTime:0.000054s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 648 [ RunTime:0.000051s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 618 [ RunTime:0.000041s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 617 [ RunTime:0.000040s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 614 [ RunTime:0.000042s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 601 [ RunTime:0.000040s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 585 [ RunTime:0.000037s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 562 [ RunTime:0.000042s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 70 [ RunTime:0.000042s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 547 [ RunTime:0.000052s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 539 [ RunTime:0.000041s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 538 [ RunTime:0.000041s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 534 [ RunTime:0.000052s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 387 [ RunTime:0.000043s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 365 [ RunTime:0.000040s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 361 [ RunTime:0.000039s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `qm_album_dance` WHERE `album_id` = 279 [ RunTime:0.000042s ]
[ SQL ] SHOW COLUMNS FROM `qm_user_down` [ RunTime:0.000418s ]
[ SQL ] SELECT `d`.`id`,`d`.`path`,`d`.`name`,`d`.`dance_time`,`d`.`dance_size`,`d`.`hits`,`d`.`createtime` FROM `qm_user_down` `u` INNER JOIN `qm_dance` `d` ON `u`.`dance_id`=`d`.`id` WHERE `d`.`status` = 1 AND `u`.`createtime` BETWEEN '2026-01-01 00:00:00' AND '2026-01-31 23:59:59' GROUP BY `d`.`id` ORDER BY `u`.`createtime` DESC LIMIT 9 [ RunTime:0.001375s ]
[ SQL ] SELECT DISTINCT `d`.`id`,`d`.`path`,`d`.`name`,`d`.`dance_time`,`d`.`dance_size`,`d`.`hits`,`d`.`createtime` FROM `qm_user_down` `u` INNER JOIN `qm_dance` `d` ON `u`.`dance_id`=`d`.`id` WHERE `d`.`status` = 1 AND `u`.`createtime` BETWEEN '2026-01-01 00:00:00' AND '2026-03-31 23:59:59' GROUP BY `d`.`id` ORDER BY `u`.`createtime` DESC LIMIT 9 [ RunTime:0.001163s ]