[ DB ] CONNECT:[ UseTime:0.000508s ] mysql:host=127.0.0.1;port=3306;dbname=seafree_com_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cms_industry_class` [ RunTime:0.000607s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_industry_class` LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SELECT `id`,`title`,`name`,`keyword`,`intro`,`picpath`,`banner_path` FROM `cms_industry_class` ORDER BY `sort` DESC,`id` LIMIT 0,4 [ RunTime:0.000289s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods_class` [ RunTime:0.000455s ]
[ SQL ] SELECT * FROM `cms_goods_class` [ RunTime:0.000272s ]
[ SQL ] SHOW COLUMNS FROM `cms_article` [ RunTime:0.000432s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_article` `a` INNER JOIN `cms_article_class` `ac` ON `a`.`class_id`=`ac`.`id` WHERE ( FIND_IN_SET(3,ac.parentpath) OR ac.parentid = 3 ) LIMIT 1 [ RunTime:0.000310s ]
[ SQL ] SELECT `a`.`id`,`a`.`title`,`a`.`intro`,`a`.`class_id`,`a`.`picpath`,ac.name as classname,`a`.`createtime` FROM `cms_article` `a` INNER JOIN `cms_article_class` `ac` ON `a`.`class_id`=`ac`.`id` WHERE ( FIND_IN_SET(3,ac.parentpath) OR ac.parentid = 3 ) ORDER BY `a`.`sort` DESC,`a`.`id` LIMIT 0,10 [ RunTime:0.000323s ]
[ SQL ] SHOW COLUMNS FROM `cms_brand` [ RunTime:0.000476s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_brand` `g` LIMIT 1 [ RunTime:0.000213s ]
[ SQL ] SELECT `id`,`name`,`picpath` FROM `cms_brand` `g` ORDER BY `sort` DESC,`id` LIMIT 0,3 [ RunTime:0.000211s ]
[ SQL ] SELECT * FROM `cms_goods_class` WHERE ( FIND_IN_SET(38,parentpath) OR parentid = 38 ) [ RunTime:0.000257s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods` [ RunTime:0.000490s ]
[ SQL ] SELECT DISTINCT `g`.`brand_name` FROM `cms_goods` `g` INNER JOIN `cms_goods_class` `gc` ON `g`.`class_id`=`gc`.`id` WHERE ( FIND_IN_SET(38,gc.parentpath) OR gc.parentid = 38 ) [ RunTime:0.000294s ]
[ SQL ] SELECT `parentpath` FROM `cms_goods_class` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `id`,`name` FROM `cms_goods_class` WHERE `id` IN (38) [ RunTime:0.000208s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_goods` `g` INNER JOIN `cms_goods_class` `gc` ON `g`.`class_id`=`gc`.`id` WHERE ( FIND_IN_SET(38,gc.parentpath) OR gc.parentid = 38 ) LIMIT 1 [ RunTime:0.000240s ]
[ SQL ] SELECT `g`.`id`,`g`.`title`,`g`.`name`,`g`.`intro`,`g`.`picpath`,gc.name as classname FROM `cms_goods` `g` INNER JOIN `cms_goods_class` `gc` ON `g`.`class_id`=`gc`.`id` WHERE ( FIND_IN_SET(38,gc.parentpath) OR gc.parentid = 38 ) ORDER BY `g`.`sort` DESC,`g`.`id` LIMIT 0,15 [ RunTime:0.000300s ]
[ SQL ] SELECT `id`,`name`,`parentid` FROM `cms_goods_class` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000202s ]
