[ SQL ] SHOW COLUMNS FROM `cmf_goods_spec_group` [ RunTime:0.000635s ]
[ SQL ] SELECT `a`.*,`b`.`val`,`c`.`name`,`d`.`sort` FROM `cmf_goods_spec_group` `a` INNER JOIN `cmf_goods_spec_detail` `b` ON `a`.`did`=`b`.`id` INNER JOIN `cmf_goods_spec` `c` ON `a`.`sid`=`c`.`id` LEFT JOIN `cmf_goodscategory_spec_group` `d` ON `a`.`sid`=`d`.`sid` WHERE `a`.`gid` = '196' GROUP BY `a`.`id` ORDER BY `d`.`sort`,`a`.`id` [ RunTime:0.005102s ]
