SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000561s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000514s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000480s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000436s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000256s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000224s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000408s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000227s ]
SHOW FULL COLUMNS FROM `sys_competition` [ RunTime:0.002474s ]
SELECT COUNT(*) AS think_count FROM `sys_competition` WHERE ( `status` = 1 ) [ RunTime:0.000220s ]
SELECT `id`,`name`,`summary`,`cover`,`start_date`,`end_date`,`max_signup` FROM `sys_competition` WHERE ( `status` = 1 ) ORDER BY `start_date` DESC,`end_date` DESC,`id` DESC LIMIT 0,10 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `sys_competition_signup` [ RunTime:0.000534s ]
SELECT COUNT(1),`competition_id` FROM `sys_competition_signup` WHERE `competition_id` IN (12,10,7,6,5,4,3,11,9,8) GROUP BY `competition_id` [ RunTime:0.000290s ]
