The main products include baby clothes, crib products, saliva towels, children's clothing, adult knitting clothing, pet clothing, plush toys and so on.
基本文件流程错误SQL调试
请求信息 : 2024-07-01 18:27:32 HTTP/1.0 GET : cn.b2b.atc-cn.cn/co-Fuxinhuayangfurtrade/product/baby-clothes-crib-products-saliva-towels-children-s-clothing-adult-knitting-clothing-pet-clothing-plush-toys-and-so-on.html
[ DB ] CONNECT:[ UseTime:0.015601s ] mysql:host=10.10.100.11;port=3306;dbname=atc_b2b;charset=utf8
[ SQL ] SHOW COLUMNS FROM `company` [ RunTime:0.109200s ]
[ 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` = 'Fuxinhuayangfurtrade' 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.109200s ]
[ 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` = 79 AND `a`.`open_status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `website_lang` [ RunTime:0.109200s ]
[ 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.093600s ]
[ 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` = 79 AND `a`.`slug` = 'baby-clothes-crib-products-saliva-towels-children-s-clothing-adult-knitting-clothing-pet-clothing-plush-toys-and-so-on' AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product_pic` [ RunTime:0.093601s ]
[ SQL ] SELECT `id`,`path`,`name` FROM `product_pic` WHERE `product_id` = 90 AND `status` = 1 [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `product_attribute` [ RunTime:0.078000s ]
[ 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` = 90 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product_category` [ RunTime:0.078000s ]
[ 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` = 1113 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SELECT DISTINCT `category_id` FROM `product` WHERE `company_id` = 79 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 (1113) AND `a`.`status` = 1 [ RunTime:0.000000s ]
