SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000370s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000186s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000198s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000096s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000200s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000080s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000183s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000115s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000074s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000162s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000119s ]
SHOW FULL COLUMNS FROM `sys_competition` [ RunTime:0.000223s ]
SELECT COUNT(*) AS think_count FROM `sys_competition` WHERE ( `status` = 1 ) [ RunTime:0.000091s ]
SELECT `id`,`name`,`summary`,`main_cover`,`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.000145s ]
SHOW FULL COLUMNS FROM `sys_competition_signup` [ RunTime:0.000198s ]
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.000141s ]
