SHOW FULL COLUMNS FROM `tp6_ability` [ RunTime:0.001250s ]
SELECT `id`,`name` FROM `tp6_ability` WHERE `pid` = 1 ORDER BY `sort` ASC [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tp6_ability` WHERE `pid` = 0 [ RunTime:0.000800s ]
SHOW FULL COLUMNS FROM `tp6_auth_rule_user` [ RunTime:0.001089s ]
SELECT `a`.`id`,`a`.`title`,`a`.`name`,`a`.`desc`,`a`.`sort`,`a`.`cover`,b.name as abilityName,c.id as isSave FROM `tp6_auth_rule_user` `a` INNER JOIN `tp6_ability` `b` ON `a`.`abilityId`=`b`.`id` LEFT JOIN `tp6_user_save` `c` ON `a`.`id`=c.authId and c.userId=0 WHERE `a`.`class` = '1' AND `a`.`isLook` = '1' AND `b`.`pid` = '1' ORDER BY `a`.`page_sort` DESC,`a`.`id` DESC [ RunTime:0.001237s ]