[ 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.062400s ]
[ 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` = 'SonghangCerealsAndOilTrading' 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.062400s ]
[ 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` = 147 AND `a`.`open_status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `website_lang` [ RunTime:0.062400s ]
[ 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.062401s ]
[ 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` = 147 AND `a`.`slug` = 'imported-high-quality-edible-sorghum-for-wine' AND `a`.`status` = 1 LIMIT 1 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product_pic` [ RunTime:0.062400s ]
[ SQL ] SELECT `id`,`path`,`name` FROM `product_pic` WHERE `product_id` = 157 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` = 157 [ RunTime:0.015600s ]
[ SQL ] SHOW COLUMNS FROM `product_category` [ RunTime:0.062400s ]
[ 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` = 2978 LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT DISTINCT `category_id` FROM `product` WHERE `company_id` = 147 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 (2978) AND `a`.`status` = 1 [ RunTime:0.015600s ]
