[ DB ] CONNECT:[ UseTime:0.000447s ] mysql:host=127.0.0.1;port=3306;dbname=seafree_com_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cms_industry_class` [ RunTime:0.000594s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_industry_class` LIMIT 1 [ RunTime:0.000240s ]
[ SQL ] SELECT `id`,`title`,`name`,`keyword`,`intro`,`picpath`,`banner_path` FROM `cms_industry_class` ORDER BY `sort` DESC,`id` LIMIT 0,4 [ RunTime:0.000274s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods_class` [ RunTime:0.000428s ]
[ SQL ] SELECT * FROM `cms_goods_class` [ RunTime:0.000249s ]
[ SQL ] SHOW COLUMNS FROM `cms_article` [ RunTime:0.000485s ]
[ 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.000330s ]
[ 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.000410s ]
[ SQL ] SHOW COLUMNS FROM `cms_brand` [ RunTime:0.000462s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_brand` `g` LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `id`,`name`,`picpath` FROM `cms_brand` `g` ORDER BY `sort` DESC,`id` LIMIT 0,3 [ RunTime:0.000192s ]
[ SQL ] SHOW COLUMNS FROM `cms_advert` [ RunTime:0.000411s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 1 LIMIT 1 [ RunTime:0.000248s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 1 ORDER BY `sort` DESC,`id` LIMIT 0,10 [ RunTime:0.000359s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 2 LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 2 ORDER BY `sort` DESC,`id` LIMIT 0,1 [ RunTime:0.000361s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 3 LIMIT 1 [ RunTime:0.000168s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 3 ORDER BY `sort` DESC,`id` LIMIT 0,1 [ RunTime:0.000292s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 4 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 4 ORDER BY `sort` DESC,`id` LIMIT 0,10 [ RunTime:0.000333s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 5 LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 5 ORDER BY `sort` DESC,`id` LIMIT 0,1 [ RunTime:0.000233s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_advert` WHERE `position_id` = 6 LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SELECT `id`,`title`,`pic_path`,`advert_url`,`type`,`remarks` FROM `cms_advert` WHERE `position_id` = 6 ORDER BY `sort` DESC,`id` LIMIT 0,4 [ RunTime:0.000350s ]
[ SQL ] SHOW COLUMNS FROM `cms_goods` [ RunTime:0.000540s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cms_goods` `g` INNER JOIN `cms_goods_class` `gc` ON `g`.`class_id`=`gc`.`id` WHERE `g`.`elite` = 2 LIMIT 1 [ RunTime:0.000418s ]
[ 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 `g`.`elite` = 2 ORDER BY `g`.`sort` DESC,`g`.`id` LIMIT 0,3 [ RunTime:0.000391s ]