SHOW FULL COLUMNS FROM `yifan_cat` [ RunTime:0.000787s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `yifan_cat_data` [ RunTime:0.000452s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000226s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000512s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 51 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000267s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 50 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000267s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000244s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 52 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000240s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000300s ]
SHOW FULL COLUMNS FROM `yifan_cms_product` [ RunTime:0.000714s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.000413s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.000255s ]
SELECT `id`,`catid`,`modelid`,`link`,`titleurl`,`pagetitle`,`keywords`,`description`,`pubid`,`sort`,`userid`,`username`,`addtime`,`editortime`,`is_good`,`is_top`,`views`,`goods`,`comments`,`title`,`newstime`,`tuku`,`dw`,`active`,`pack`,`formulation`,`jieshao`,`cont` FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC,`id` DESC LIMIT 0,12 [ RunTime:0.000485s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 69 LIMIT 1 [ RunTime:0.000738s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000301s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000258s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 69 LIMIT 1 [ RunTime:0.000259s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000270s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000255s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000261s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000317s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000698s ]
SELECT `thumb`,`catid`,`classpath`,`name` FROM `yifan_cat` WHERE `pid` = 0 AND `catid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000355s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000221s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000376s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000375s ]
