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.015600s ]
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.015600s ]
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.015600s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 28613 LIMIT 1 [ RunTime:0.000000s ]
SELECT * FROM `xn_ld_user2012` WHERE `userid` = 28613 LIMIT 1 [ RunTime:0.015600s ]
SHOW FULL COLUMNS FROM `gt_cproduct` [ RunTime:0.000000s ]
SELECT `id`,`pname`,`zhibiao`,`slpic`,`compid`,`lclass`,`price` FROM `gt_cproduct` WHERE `compid` = 28613 ORDER BY `id` DESC LIMIT 4 [ RunTime:0.031200s ]
SHOW FULL COLUMNS FROM `gt_supply` [ RunTime:0.000000s ]
SELECT * FROM `gt_supply` WHERE `compid` = 28613 AND `sclass` = '采購信息' ORDER BY `id` DESC LIMIT 4 [ RunTime:0.031200s ]
SELECT * FROM `gt_supply` WHERE `compid` = 28613 AND `sclass` = '供應信息' ORDER BY `id` DESC LIMIT 4 [ RunTime:0.031200s ]
SHOW FULL COLUMNS FROM `gt_carticle` [ RunTime:0.000000s ]
SELECT `id`,`title`,`d_content`,`bdate` FROM `gt_carticle` WHERE `compid` = 28613 ORDER BY `id` DESC LIMIT 5 [ RunTime:0.078000s ]
SHOW FULL COLUMNS FROM `gt_honor` [ RunTime:0.000000s ]
SELECT `id`,`title`,`picurl` FROM `gt_honor` WHERE `compid` = 28613 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000000s ]
SHOW FULL COLUMNS FROM `linkman` [ RunTime:0.000000s ]
SELECT * FROM `linkman` WHERE `compid` = 28613 AND `isindex` = 1 ORDER BY `id` DESC [ RunTime:0.187201s ]
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=28613 order by e.id desc limit 1 [ RunTime:0.078000s ]
已核驗基本資料
