SHOW FULL COLUMNS FROM `sys_cooperation` [ RunTime:0.000504s ]
SELECT * FROM `sys_cooperation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `sys_navigation` [ RunTime:0.000403s ]
SELECT `name`,`icon`,`url`,`platform` FROM `sys_navigation` WHERE `status` = 1 ORDER BY `sort` ASC,`id` DESC [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `sys_user` [ RunTime:0.000429s ]
SELECT `id`,`nickname`,`avatar`,`mobile`,`email`,`sex` FROM `sys_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `sys_order_notify` [ RunTime:0.000380s ]
SELECT * FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) ORDER BY `addtime` DESC LIMIT 5 [ RunTime:0.000216s ]
SELECT COUNT(*) AS think_count FROM `sys_order_notify` WHERE ( `uid` = 0 AND `is_read` = 0 ) [ RunTime:0.000151s ]
SHOW FULL COLUMNS FROM `sys_user_cart` [ RunTime:0.000328s ]
SELECT COUNT(*) AS think_count FROM `sys_user_cart` WHERE `uid` = 0 [ RunTime:0.000193s ]
SHOW FULL COLUMNS FROM `sys_competition` [ RunTime:0.000518s ]
SELECT COUNT(*) AS think_count FROM `sys_competition` WHERE ( `status` = 1 ) [ RunTime:0.000203s ]
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.000286s ]
SHOW FULL COLUMNS FROM `sys_competition_signup` [ RunTime:0.000461s ]
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.000249s ]
