[ DB ] CONNECT:[ UseTime:0.000466s ] mysql:host=127.0.0.1;port=3306;dbname=seafree_com_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cms_industry_class` [ RunTime:0.000693s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_industry_class` LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT `id`,`title`,`name`,`keyword`,`intro`,`picpath`,`banner_path` FROM `cms_industry_class` ORDER BY `sort` DESC,`id` LIMIT 0,4 [ RunTime:0.000332s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods_class` [ RunTime:0.000639s ]
[ SQL ] SELECT * FROM `cms_goods_class` [ RunTime:0.000346s ]
[ SQL ] SHOW COLUMNS FROM `cms_article` [ RunTime:0.000627s ]
[ 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.000464s ]
[ 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.000441s ]
[ SQL ] SHOW COLUMNS FROM `cms_brand` [ RunTime:0.000552s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_brand` `g` LIMIT 1 [ RunTime:0.000243s ]
[ SQL ] SELECT `id`,`name`,`picpath` FROM `cms_brand` `g` ORDER BY `sort` DESC,`id` LIMIT 0,3 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `cms_goods_class` WHERE ( FIND_IN_SET(41,parentpath) OR parentid = 41 ) [ RunTime:0.000304s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods` [ RunTime:0.000496s ]
[ 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(41,gc.parentpath) OR gc.parentid = 41 ) [ RunTime:0.000388s ]
[ SQL ] SELECT `parentpath` FROM `cms_goods_class` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT `id`,`name` FROM `cms_goods_class` WHERE `id` IN (41) [ RunTime:0.000242s ]
[ 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(41,gc.parentpath) OR gc.parentid = 41 ) LIMIT 1 [ RunTime:0.000304s ]
[ 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(41,gc.parentpath) OR gc.parentid = 41 ) ORDER BY `g`.`sort` DESC,`g`.`id` LIMIT 0,15 [ RunTime:0.000358s ]
[ SQL ] SELECT `id`,`name`,`parentid` FROM `cms_goods_class` WHERE `id` = 41 LIMIT 1 [ RunTime:0.000239s ]
