SHOW FULL COLUMNS FROM `settings` [ RunTime:0.003182s ]
SELECT `sysvalue`,`syskey` FROM `settings` WHERE `sys_type` <> 'smtp' AND `status` = 1 [ RunTime:0.001559s ]
SHOW FULL COLUMNS FROM `slide` [ RunTime:0.002073s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 2 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.001736s ]
SHOW FULL COLUMNS FROM `goods_cate` [ RunTime:0.000843s ]
SELECT * FROM `goods_cate` WHERE `status` = 1 AND `delete_time` = 0 [ RunTime:0.002360s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.003805s ]
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 '%-1-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.004192s ]
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 '%-1-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` LIMIT 0,20 [ RunTime:0.001013s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 7 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.003479s ]
