[ DB ] CONNECT:[ UseTime:0.000445s ] mysql:host=127.0.0.1;port=3306;dbname=seafree_com_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cms_industry_class` [ RunTime:0.000609s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_industry_class` LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT `id`,`title`,`name`,`keyword`,`intro`,`picpath`,`banner_path` FROM `cms_industry_class` ORDER BY `sort` DESC,`id` LIMIT 0,4 [ RunTime:0.000338s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods_class` [ RunTime:0.000533s ]
[ SQL ] SELECT * FROM `cms_goods_class` [ RunTime:0.000297s ]
[ SQL ] SHOW COLUMNS FROM `cms_article` [ RunTime:0.000721s ]
[ 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.000400s ]
[ 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.000397s ]
[ SQL ] SHOW COLUMNS FROM `cms_brand` [ RunTime:0.000521s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_brand` `g` LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `id`,`name`,`picpath` FROM `cms_brand` `g` ORDER BY `sort` DESC,`id` LIMIT 0,3 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `cms_goods_class` WHERE ( FIND_IN_SET(38,parentpath) OR parentid = 38 ) [ RunTime:0.000276s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods` [ RunTime:0.000533s ]
[ 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.001051s ]
[ SQL ] SELECT `parentpath` FROM `cms_goods_class` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT `id`,`name` FROM `cms_goods_class` WHERE `id` IN (38) [ RunTime:0.000228s ]
[ 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.000278s ]
[ 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.000269s ]
[ SQL ] SELECT `id`,`name`,`parentid` FROM `cms_goods_class` WHERE `id` = 38 LIMIT 1 [ RunTime:0.000251s ]
