SHOW FULL COLUMNS FROM `gt_ad_cat` [ RunTime:0.000000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `gt_ad` [ RunTime:0.000000s ]
SELECT `picurl` FROM `gt_ad` WHERE `title` = 7 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000000s ]
SELECT `url` FROM `gt_ad` WHERE `title` = 7 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000000s ]
SELECT COUNT(*) AS think_count FROM `gt_ad` WHERE `title` = 7 [ RunTime:0.000000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `gt_product_class` [ RunTime:0.000000s ]
SELECT * FROM `gt_product_class` ORDER BY `child` DESC LIMIT 6 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `gt_friendlink` [ RunTime:0.000000s ]
SELECT * FROM `gt_friendlink` ORDER BY `id` ASC [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `gt_article` [ RunTime:0.000000s ]
SELECT COUNT(*) AS think_count FROM `gt_article` WHERE `sclass` = '網站公告' [ RunTime:0.000000s ]
SELECT `id`,`sclass`,`a_title`,`b_date`,`a_keywords`,`hits`,`bclassid` FROM `gt_article` WHERE `sclass` = '網站公告' ORDER BY `id` DESC LIMIT 0,5 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `xn_ld_user2012` [ RunTime:0.000000s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 32039 LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 32039 LIMIT 1 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `linkman` [ RunTime:0.000000s ]
SELECT * FROM `linkman` WHERE `compid` = 32039 AND `isindex` = 1 ORDER BY `id` DESC [ RunTime:0.156000s ]
SHOW FULL COLUMNS FROM `xn_mall_zone` [ RunTime:0.000000s ]
SELECT * FROM `xn_mall_zone` WHERE ( pid=0 ) [ RunTime:0.000000s ]
select e.id,e.score,e.progress,
(select count(1) from ld_achievement_log where evaluate_id=e.id) a,
(select 1 from ld_honor_log where evaluate_id=e.id and type BETWEEN 1 and 9 limit 1) h,
(select 1 from ld_honor_log where evaluate_id=e.id and type BETWEEN 11 and 19 limit 1) h1,
(select 1 from ld_honor_log where evaluate_id=e.id and type BETWEEN 21 and 29 limit 1) h2,
(select 1 from ld_honor_log where evaluate_id=e.id and type BETWEEN 31 and 39 limit 1) h3
from ld_evaluate_log e where e.userid=32039 order by e.id desc limit 1 [ RunTime:0.015601s ]
