[ DB ] CONNECT:[ UseTime:0.031200s ] 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` = 'AnsteelGroupCorporation' 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.093601s ]
[ 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` = 142 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_category` [ RunTime:0.093600s ]
[ SQL ] SELECT `a`.`id`,`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`.`slug` = 'other-manufacturing-processing-machinery' AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.093600s ]
[ SQL ] SELECT DISTINCT `category_id` FROM `product` WHERE `company_id` = 142 AND `audited_status` = 2 AND `status` = 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `a`.`id`,`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 (5786) AND `a`.`status` = 1 [ RunTime:0.015600s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` `a` LEFT JOIN `product_lang` `b` ON `a`.`id`=b.product_id and b.lang = 'cn' WHERE `a`.`company_id` = 142 AND `a`.`category_id` = 5786 AND `a`.`audited_status` = 2 AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT `a`.`name`,`a`.`slug`,`a`.`cover_path`,`a`.`min_order_unit`,`a`.`min_order`,`a`.`min_price`,`a`.`max_price`,b.name as lang_name FROM `product` `a` LEFT JOIN `product_lang` `b` ON `a`.`id`=b.product_id and b.lang = 'cn' WHERE `a`.`company_id` = 142 AND `a`.`category_id` = 5786 AND `a`.`audited_status` = 2 AND `a`.`status` = 1 LIMIT 0,12 [ RunTime:0.015600s ]
