SHOW FULL COLUMNS FROM `settings` [ RunTime:0.001120s ]
SELECT `sysvalue`,`syskey` FROM `settings` WHERE `sys_type` <> 'smtp' AND `status` = 1 [ RunTime:0.000457s ]
SHOW FULL COLUMNS FROM `slide` [ RunTime:0.000741s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 2 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000432s ]
SHOW FULL COLUMNS FROM `goods_cate` [ RunTime:0.000742s ]
SELECT * FROM `goods_cate` WHERE `status` = 1 AND `delete_time` = 0 [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.000840s ]
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 '%-6-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.001325s ]
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 '%-6-%' AND `g`.`status` = '1' AND `g`.`delete_time` = '0' GROUP BY `g`.`id` LIMIT 0,20 [ RunTime:0.000978s ]
SELECT * FROM `slide` WHERE `lang` = 'zh_CN' AND `position` = 7 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000484s ]
