SHOW FULL COLUMNS FROM `settings` [ RunTime:0.001095s ]
SELECT `sysvalue`,`syskey` FROM `settings` WHERE `sys_type` <> 'smtp' AND `status` = 1 [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `slide` [ RunTime:0.000725s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 2 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000641s ]
SHOW FULL COLUMNS FROM `goods_cate` [ RunTime:0.000771s ]
SELECT * FROM `goods_cate` WHERE `status` = 1 AND `delete_time` = 0 [ RunTime:0.000495s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000871s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `goods` `g` LEFT JOIN `goods_cate_join` `j` ON `g`.`id`=`j`.`goods_id` LEFT JOIN `goods_cate` `c` ON `j`.`cate_id`=`c`.`id` WHERE `c`.`cate_str` LIKE '%-16-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.001203s ]
SELECT g.id,g.goods_name,g.simple_desc,g.images,g.video,seo_url FROM `goods` `g` LEFT JOIN `goods_cate_join` `j` ON `g`.`id`=`j`.`goods_id` LEFT JOIN `goods_cate` `c` ON `j`.`cate_id`=`c`.`id` WHERE `c`.`cate_str` LIKE '%-16-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` LIMIT 0,20 [ RunTime:0.001046s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 7 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000599s ]