The sealless canned motor pump and magnetic driven pump as the main products, they have been widely applied in chemical, petrochemical, pharmaceutical, textile, nuclear power and refrigeration industries.
基本文件流程错误SQL调试
请求信息 : 2024-07-01 19:33:07 HTTP/1.0 GET : cn.b2b.atc-cn.cn/co-HERMETIC/product/the-sealless-canned-motor-pump-and-magnetic-driven-pump.html
[ DB ] CONNECT:[ UseTime:0.015600s ] mysql:host=10.10.100.11;port=3306;dbname=atc_b2b;charset=utf8
[ SQL ] SHOW COLUMNS FROM `company` [ RunTime:0.078000s ]
[ SQL ] SELECT `a`.*,b.name as lang_name,b.country as lang_country,b.province as lang_province,b.city as lang_city,b.contacts as lang_contacts,b.main_products as lang_main_products,b.description as lang_description FROM `company` `a` LEFT JOIN `company_lang` `b` ON `a`.`id`=b.company_id and b.lang = 'cn' WHERE `a`.`slug` = 'HERMETIC' AND `a`.`type` = 1 AND `a`.`open_status` = 1 AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `company_showroom` [ RunTime:0.078000s ]
[ SQL ] SELECT * FROM `company_showroom` `a` LEFT JOIN `company_showroom_lang` `b` ON `a`.`company_id`=b.company_id and b.lang = 'cn' WHERE `a`.`company_id` = 106 AND `a`.`open_status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `website_lang` [ RunTime:0.093601s ]
[ SQL ] SELECT `name`,`copyright`,`icp`,`seo_title`,`seo_keywords`,`seo_description` FROM `website_lang` WHERE `lang` = 'cn' LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.078000s ]
[ SQL ] SELECT `a`.*,b.name as lang_name,b.keywords as lang_keywords,b.productivity as lang_productivity,b.content as lang_content FROM `product` `a` LEFT JOIN `product_lang` `b` ON `a`.`id`=b.product_id and b.lang = 'cn' WHERE `a`.`company_id` = 106 AND `a`.`slug` = 'the-sealless-canned-motor-pump-and-magnetic-driven-pump' AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product_pic` [ RunTime:0.093600s ]
[ SQL ] SELECT `id`,`path`,`name` FROM `product_pic` WHERE `product_id` = 116 AND `status` = 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product_attribute` [ RunTime:0.093600s ]
[ SQL ] SELECT `a`.*,b.name as attribute_name FROM `product_attribute` `a` LEFT JOIN `product_category_attribute` `b` ON `a`.`attribute_id`=`b`.`id` WHERE `a`.`product_id` = 116 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product_category` [ RunTime:0.093600s ]
[ SQL ] SELECT `a`.`slug`,`a`.`title`,b.title as lang_title FROM `product_category` `a` LEFT JOIN `product_category_lang` `b` ON `a`.`id`=b.category_id and b.lang = 'cn' WHERE `a`.`id` = 1288 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SELECT DISTINCT `category_id` FROM `product` WHERE `company_id` = 106 AND `audited_status` = 2 AND `status` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `a`.`slug`,`a`.`title`,b.title as lang_title FROM `product_category` `a` LEFT JOIN `product_category_lang` `b` ON `a`.`id`=b.category_id and b.lang = 'cn' WHERE `a`.`id` IN (1288) AND `a`.`status` = 1 [ RunTime:0.015600s ]
