[ DB ] CONNECT:[ UseTime:0.000859s ] mysql:host=127.0.0.1;port=3306;dbname=3w2019.com;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_white` [ RunTime:0.001736s ]
[ SQL ] SELECT * FROM `cmf_white` [ RunTime:0.000515s ]
[ SQL ] SHOW COLUMNS FROM `cmf_company_info` [ RunTime:0.001864s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE ( companysite='www.pig007.com' or companysite='pig007.com' ) LIMIT 1 [ RunTime:0.000942s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `companysite` = 'www.pig007.com' LIMIT 1 [ RunTime:0.000974s ]
[ SQL ] SELECT * FROM `cmf_white` [ RunTime:0.000571s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE ( companysite='www.pig007.com' or companysite='pig007.com' ) LIMIT 1 [ RunTime:0.000653s ]
[ SQL ] SHOW COLUMNS FROM `cmf_company_product` [ RunTime:0.001665s ]
[ SQL ] SELECT `product`.`id`,`product`.`uid`,`product`.`product_name`,`product`.`keywords`,`product`.`product_thum`,`product`.`product_content`,`product`.`product_createtime`,`product`.`product_subcontent`,`product`.`tag_polymerization`,company.id as companyid,`company`.`company_abbr` FROM `cmf_company_product` `product` LEFT JOIN `cmf_company_info` `company` ON `company`.`uid`=`product`.`uid` WHERE `product`.`is_del` = 1 AND `product`.`id` > 2494 AND `product`.`uid` = 507 ORDER BY `product`.`id` ASC LIMIT 1 [ RunTime:0.003609s ]
[ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001167s ]
[ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'newthems' AND ( `is_public` = 1 OR `file` = '/www/wwwroot/3w2019.com/public/../public/themes/company/company_2/show_product' ) [ RunTime:0.000468s ]
[ SQL ] SELECT `uid` FROM `cmf_company_info` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000556s ]
[ SQL ] SHOW COLUMNS FROM `cmf_user_banner` [ RunTime:0.001492s ]
[ SQL ] SELECT * FROM `cmf_user_banner` WHERE `uid` = 507 AND `belong_to` = 0 ORDER BY `id` DESC [ RunTime:0.000728s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000826s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000614s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000599s ]
[ SQL ] SELECT * FROM `cmf_company_info` WHERE `uid` = 507 LIMIT 1 [ RunTime:0.000629s ]
[ SQL ] SELECT `web_type` FROM `cmf_company_info` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SELECT `web_type` FROM `cmf_company_info` WHERE `id` = 204 LIMIT 1 [ RunTime:0.000414s ]
[ SQL ] SHOW COLUMNS FROM `cmf_tag_polymerization` [ RunTime:0.001555s ]
[ SQL ] SELECT distinct(tagp.type_id) as id,tagp.type,news.title as name,news.create_time as createtime,company.id as companyid,
company.companyurltype,company.companysite,company.company_abbr,
news.cityId,news.kid,news.groupId,news.prefixId,news.x_groupId,news.suffixId,news.w_groupId,news.city_pinyin FROM `cmf_tag_polymerization` `tagp` LEFT JOIN `cmf_news` `news` ON `tagp`.`type_id`=`news`.`id` LEFT JOIN `cmf_company_info` `company` ON `news`.`uid`=`company`.`uid` WHERE `news`.`uid` = 507 AND `news`.`city_pinyin` = '' AND `news`.`kid` = 0 AND `news`.`groupId` = 0 AND `news`.`prefixId` = 0 AND `news`.`x_groupId` = 0 AND `news`.`suffixId` = 0 AND `news`.`w_groupId` = 0 AND `tag_id` IN (19371) AND `type` = 1 ORDER BY `tagp`.`id` DESC LIMIT 8 [ RunTime:22.159204s ]
公司产品
扫一扫关注
