SHOW FULL COLUMNS FROM `yf_options` [ RunTime:0.000590s ]
SELECT * FROM `yf_options` WHERE `option_name` = 'site_options' LIMIT 1 [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `yf_menu` [ RunTime:0.000800s ]
SELECT * FROM `yf_menu` WHERE `id` = 164 LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`menu_name` FROM `yf_menu` WHERE `parentid` = 2 AND `menu_open` = 1 ORDER BY `listorder` ASC [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `yf_product` [ RunTime:0.000515s ]
SELECT COUNT(*) AS think_count FROM `yf_product` `a` LEFT JOIN `yf_menu` `b` ON `a`.`catid`=`b`.`id` WHERE `a`.`catid` IN ('164','') AND `a`.`lang` = '1' AND `a`.`status` = '1' AND `a`.`recycle` = '0' LIMIT 1 [ RunTime:0.000625s ]
SELECT `a`.`id`,`a`.`title`,`a`.`cover`,`a`.`description` FROM `yf_product` `a` LEFT JOIN `yf_menu` `b` ON `a`.`catid`=`b`.`id` WHERE `a`.`catid` IN ('164','') AND `a`.`lang` = '1' AND `a`.`status` = '1' AND `a`.`recycle` = '0' ORDER BY `a`.`listorder` DESC LIMIT 0,100 [ RunTime:0.000577s ]
