GLD series of clinker chain conveyor and chain / HBY series of central chain mightiness elevator and chain / XZ-kx series of airslide and spare parts /Industrial chain
GLD series of clinker chain conveyor and chain / HBY series of central chain mightiness elevator and chain / XZ-kx series of airslide and spare parts /Industrial chain
基本文件流程错误SQL调试
请求信息 : 2024-11-17 07:17:39 HTTP/1.0 GET : cn.b2b.atc-cn.cn/co-HuludaoDLDMachineryIndustrial/product/gld-series-of-clinker-chain-conveyor-and-chain-hby-series-of-central-chain-mightiness-elevator-and-chain-xz-kx-series-of-airslide-and-spare-parts-industrial-chain.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` = 'HuludaoDLDMachineryIndustrial' AND `a`.`type` = 1 AND `a`.`open_status` = 1 AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ 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` = 73 AND `a`.`open_status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `website_lang` [ RunTime:0.078000s ]
[ 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.078001s ]
[ 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` = 73 AND `a`.`slug` = 'gld-series-of-clinker-chain-conveyor-and-chain-hby-series-of-central-chain-mightiness-elevator-and-chain-xz-kx-series-of-airslide-and-spare-parts-industrial-chain' AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product_pic` [ RunTime:0.062400s ]
[ SQL ] SELECT `id`,`path`,`name` FROM `product_pic` WHERE `product_id` = 83 AND `status` = 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product_attribute` [ RunTime:0.062400s ]
[ 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` = 83 [ RunTime:0.015600s ]
[ 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` = 1514 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SELECT DISTINCT `category_id` FROM `product` WHERE `company_id` = 73 AND `audited_status` = 2 AND `status` = 1 [ RunTime:0.015600s ]
[ 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 (1514) AND `a`.`status` = 1 [ RunTime:0.015600s ]
