SHOW FULL COLUMNS FROM `yf_options` [ RunTime:0.000847s ]
SELECT * FROM `yf_options` WHERE `option_name` = 'site_options' LIMIT 1 [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `yf_menu` [ RunTime:0.000740s ]
SELECT * FROM `yf_menu` WHERE `id` = 99 LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`menu_name` FROM `yf_menu` WHERE `parentid` = 2 AND `menu_open` = 1 ORDER BY `listorder` ASC [ RunTime:0.000278s ]
SHOW FULL COLUMNS FROM `yf_product` [ RunTime:0.000537s ]
SELECT COUNT(*) AS think_count FROM `yf_product` `a` LEFT JOIN `yf_menu` `b` ON `a`.`catid`=`b`.`id` WHERE `a`.`catid` IN ('99','') AND `a`.`lang` = '1' AND `a`.`status` = '1' AND `a`.`recycle` = '0' LIMIT 1 [ RunTime:0.000629s ]
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 ('99','') AND `a`.`lang` = '1' AND `a`.`status` = '1' AND `a`.`recycle` = '0' ORDER BY `a`.`listorder` DESC LIMIT 0,100 [ RunTime:0.000697s ]