SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000563s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000299s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000413s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000402s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000180s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000432s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000291s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000430s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000316s ]
SHOW FULL COLUMNS FROM `sys_competition` [ RunTime:0.000637s ]
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.000330s ]
SHOW FULL COLUMNS FROM `sys_competition_signup` [ RunTime:0.000493s ]
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.000295s ]
