SHOW FULL COLUMNS FROM `yifan_cat` [ RunTime:0.000652s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `yifan_cat_data` [ RunTime:0.000618s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000240s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000496s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 51 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000271s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 50 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000282s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 64 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000321s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 52 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000273s ]
SELECT `catid`,`modelid` FROM `yifan_cat` WHERE `pid` = 69 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `yifan_cms_product` [ RunTime:0.000587s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.008670s ]
SELECT COUNT(*) AS think_count FROM `yifan_cms_product` WHERE `catid` IN (49,51,50,64,52,69) [ RunTime:0.000306s ]
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.000550s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 69 LIMIT 1 [ RunTime:0.000352s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000298s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000351s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000348s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 69 LIMIT 1 [ RunTime:0.000320s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000262s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000290s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 51 LIMIT 1 [ RunTime:0.000279s ]
SELECT * FROM `yifan_cat` WHERE `catid` = 50 LIMIT 1 [ RunTime:0.000321s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000472s ]
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.000284s ]
SELECT * FROM `yifan_cat_data` WHERE `catid` = 49 LIMIT 1 [ RunTime:0.000218s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000397s ]
SELECT * FROM `yifan_cat` WHERE `pid` = 49 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000463s ]
