SHOW FULL COLUMNS FROM `gt_ad_cat` [ RunTime:0.004000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 7 LIMIT 1 [ RunTime:0.001000s ]
SHOW FULL COLUMNS FROM `gt_ad` [ RunTime:0.005001s ]
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.001000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 8 LIMIT 1 [ RunTime:0.001000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.001000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.001000s ]
SELECT * FROM `gt_ad_cat` WHERE `id` = 9 LIMIT 1 [ RunTime:0.001000s ]
SHOW FULL COLUMNS FROM `gt_product_class` [ RunTime:0.011001s ]
SELECT * FROM `gt_product_class` ORDER BY `child` DESC LIMIT 6 [ RunTime:0.003000s ]
SHOW FULL COLUMNS FROM `gt_friendlink` [ RunTime:0.007001s ]
SELECT * FROM `gt_friendlink` ORDER BY `id` ASC [ RunTime:0.001000s ]
SHOW FULL COLUMNS FROM `gt_article` [ RunTime:0.006000s ]
SELECT COUNT(*) AS think_count FROM `gt_article` WHERE `sclass` = '网站公告' [ RunTime:0.001000s ]
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.002000s ]
SHOW FULL COLUMNS FROM `xn_ld_user2012` [ RunTime:0.009001s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 37545 LIMIT 1 [ RunTime:0.001000s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 37545 LIMIT 1 [ RunTime:0.001000s ]
SHOW FULL COLUMNS FROM `gt_cproduct` [ RunTime:0.007001s ]
SELECT `id`,`pname`,`zhibiao`,`slpic`,`compid`,`lclass`,`price` FROM `gt_cproduct` WHERE `compid` = 37545 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.031001s ]
SHOW FULL COLUMNS FROM `gt_supply` [ RunTime:0.007001s ]
SELECT * FROM `gt_supply` WHERE `compid` = 37545 AND `sclass` = '采购信息' ORDER BY `id` DESC LIMIT 4 [ RunTime:0.057003s ]
SELECT * FROM `gt_supply` WHERE `compid` = 37545 AND `sclass` = '供应信息' ORDER BY `id` DESC LIMIT 4 [ RunTime:0.059004s ]
SHOW FULL COLUMNS FROM `gt_carticle` [ RunTime:0.008000s ]
SELECT `id`,`title`,`d_content`,`bdate` FROM `gt_carticle` WHERE `compid` = 37545 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.124007s ]
SHOW FULL COLUMNS FROM `gt_honor` [ RunTime:0.009001s ]
SELECT `id`,`title`,`picurl` FROM `gt_honor` WHERE `compid` = 37545 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.009000s ]
SHOW FULL COLUMNS FROM `linkman` [ RunTime:0.008001s ]
SELECT * FROM `linkman` WHERE `compid` = 37545 AND `isindex` = 1 ORDER BY `id` DESC [ RunTime:0.250014s ]
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=37545 order by e.id desc limit 1 [ RunTime:0.010001s ]
