SHOW FULL COLUMNS FROM `yifan_cat` [ RunTime:0.003351s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000649s ]
SHOW FULL COLUMNS FROM `yifan_cat_data` [ RunTime:0.000950s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000623s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000592s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 51 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000306s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 50 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000357s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000352s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 52 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000263s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000415s ]
SHOW FULL COLUMNS FROM `yifan_cms_product` [ RunTime:0.000850s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.000366s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.000304s ]
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 12,12 [ RunTime:0.000578s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000346s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000287s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000483s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000447s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000285s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000701s ]
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.000303s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000655s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000504s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000470s ]