SHOW FULL COLUMNS FROM `sys_config` [ RunTime:0.001500s ]
SHOW FULL COLUMNS FROM `sys_dict_item` [ RunTime:0.001152s ]
SHOW FULL COLUMNS FROM `global_config` [ RunTime:0.001019s ]
SHOW FULL COLUMNS FROM `goods_category` [ RunTime:0.001220s ]
SHOW FULL COLUMNS FROM `member` [ RunTime:0.001846s ]
SELECT `id`,`company_id`,`is_global_ai`,`global_ai_permission_id`,`email`,`username`,`country_id`,`country`,`full_name`,`avatar`,`gender`,`tel_prefix`,`tel_number`,`company_name`,`company_name_cn`,`cn_company_name`,`company_logo`,`business_type`,`registered_address`,`certificate`,`contact_person`,`contact_job`,`contact_tel_prefix`,`contact_tel_number`,`place_of_incorporation`,`business_registration`,`bank_info`,`account_certificate`,`trade_manage`,`is_supply`,`is_self`,`member_auth_status`,`member_auth_time`,`member_auth_message`,`member_audit_operator`,`member_apply_auth_time`,`company_auth_status`,`company_apply_auth_time`,`company_auth_time`,`company_auth_message`,`source`,`company_audit_operator`,`status`,`reg_ip`,`last_login_time`,`last_login_ip`,`source_url`,`reg_channel`,`activity_type`,`activity_id`,`delete_time`,`create_time`,`update_time`,`zip_code`,`city_id`,`city`,`is_show_customer`,`third_id`,`views`,`other_certificate`,`original_company_name`,`is_ignore_ip`,`share_user_id`,`owner_user_id`,`last_update_souce`,`is_home`,`is_app`,`group_id`,`shop_status`,`contact_email`,`contact_avatar`,`pwd_change_time`,`is_admin_apply`,`whatsapp`,`features_label`,`features_img`,`management_cert`,`show_level`,`trade_type`,`invoicing_info`,`agent_id`,`wa_account`,`wa_tel_prefix`,`wa_region_code`,`interest`,`sub_domain`,`member_cert_type`,`member_business_type`,`follow_up_status`,`follow_up_content`,`follow_up_time`,`intention_products`,`other_needs`,`market_channel_id` FROM `member` WHERE ( `company_id` = 18867 AND `is_supply` = 1 AND `company_auth_status` IN (2,3) ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `region` [ RunTime:0.001081s ]
SHOW FULL COLUMNS FROM `member_company` [ RunTime:0.001231s ]
SELECT `id`,`company_id`,`lang`,`company_banner`,`main_product`,`supply_size`,`estab_time`,`certification`,`avg_lead_time`,`introduction`,`create_time`,`update_time`,`trans_type`,`trans_status`,`vr_url`,`company_annex`,`company_attr`,`introduction_desc`,`company_desc`,`sub_domain`,`tags`,`seo_title`,`keywords`,`description`,`is_sitemap`,`is_recommend`,`recommend_goods_ids` FROM `member_company` WHERE `company_id` = 18867 [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `goods_company_category` [ RunTime:0.001014s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order`,`seo_code` FROM `goods_company_category` WHERE `company_id` = 18867 AND `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000622s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order`,`seo_code` FROM `goods_company_category` WHERE `company_id` = 18867 AND `lang` = 'zh-cn' ORDER BY `show_order` DESC [ RunTime:0.000543s ]
SHOW FULL COLUMNS FROM `member_collect` [ RunTime:0.000910s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.001715s ]
SELECT company_category_id,COUNT(*) AS goods_num FROM `goods` WHERE ( `company_id` = 18867 AND `goods_status` = 1 AND `audit_status` = 1 AND `delete_time` = 0 AND `lang` = 'zh-cn' ) AND `goods`.`delete_time` = '0' GROUP BY `company_category_id` [ RunTime:0.000572s ]
SELECT `company_category_id` FROM `goods` WHERE ( `company_id` = 18867 AND `goods_status` = 1 AND `audit_status` = 1 AND `delete_time` = 0 ) AND `goods`.`delete_time` = '0' GROUP BY `company_category_id` [ RunTime:0.000425s ]
SELECT COUNT(*) AS think_count FROM `goods` WHERE ( `lang` = 'en' AND `company_id` = 18867 AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' [ RunTime:0.000495s ]
SELECT `id`,`ref_id`,`goods_sn`,`lang`,`third_goods_sn`,`code`,`goods_name`,`seo_title`,`en_goods_name`,`full_text`,`goods_model`,`goods_promotion`,`goods_thumb`,`goods_album`,`goods_video`,`goods_video_cover`,`category_id`,`company_category_id`,`is_new`,`is_hot`,`is_recommend`,`is_payment`,`brand_id`,`keywords`,`description`,`goods_unit`,`currency`,`currency_symbol`,`currency_symbol_show`,`goods_fob`,`ladder_price`,`base_min_price`,`base_max_price`,`trade_port`,`is_sample`,`sample_price`,`sample_unit`,`allow_payments`,`goods_output`,`hs_code`,`goods_stock`,`min_price`,`warn_stock`,`max_price`,`sale_num`,`limit_buy_num`,`limit_inquiry_num`,`buy_step`,`hits`,`inquiry_num`,`is_allow`,`audit_status`,`audit_time`,`audit_message`,`audit_operator`,`goods_status`,`show_level`,`company_id`,`user_id`,`dept_id`,`trans_type`,`trans_status`,`delete_time`,`create_time`,`update_time`,`temp_category`,`temp_url`,`lead_time`,`shipping_notes`,`sort_number`,`activity_type`,`activity_id`,`activity_status`,`activity_start_time`,`activity_end_time`,`sample_id`,`is_for_like`,`car_id`,`creator_type`,`creator_id`,`creator_name`,`last_edit_time`,`seo_code_type`,`seo_code`,`cn_goods_name`,`wms_bind_status`,`is_sitemap`,`is_auto_offline`,`auto_offline_date` FROM `goods` WHERE ( `lang` = 'en' AND `company_id` = 18867 AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' ORDER BY `is_recommend` DESC,`is_for_like` DESC,`show_level` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.000616s ]
SELECT `is_self`,`company_id`,`email`,`full_name`,`business_type`,`company_logo`,`company_name`,`country_id`,`country`,`contact_tel_prefix`,`contact_tel_number`,`registered_address`,`features_label`,`features_img`,`id` FROM `member` WHERE ( `id` = 18867 ) AND `member`.`delete_time` = '0' [ RunTime:0.000513s ]
SELECT `id`,`company_id`,`lang`,`company_banner`,`main_product`,`supply_size`,`estab_time`,`certification`,`avg_lead_time`,`introduction`,`create_time`,`update_time`,`trans_type`,`trans_status`,`vr_url`,`company_annex`,`company_attr`,`introduction_desc`,`company_desc`,`sub_domain`,`tags`,`seo_title`,`keywords`,`description`,`is_sitemap`,`is_recommend`,`recommend_goods_ids` FROM `member_company` WHERE `company_id` = 18867 [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `goods_unit` [ RunTime:0.001053s ]
SELECT `class_code`,`dict_code`,`dict_value`,`dict_remark`,`show_order` FROM `sys_dict_item` WHERE `class_code` = 'product_spu_currency' AND `status` = 1 ORDER BY `show_order` DESC [ RunTime:0.000531s ]
SHOW FULL COLUMNS FROM `goods_activity_relation` [ RunTime:0.001394s ]
SELECT * FROM `goods_activity_relation` WHERE `goods_ref_id` = 31446 ORDER BY `sort` DESC,`activity_start_time` ASC,`activity_id` DESC [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `seo_tdk_rule` [ RunTime:0.001242s ]
SHOW FULL COLUMNS FROM `sys_patch` [ RunTime:0.001039s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('en','zh-cn') AND `patch_sn` IN ('ga_statistics','app_download','pixel_code') AND `status` = 1 [ RunTime:0.000928s ]
SELECT * FROM `member` WHERE ( `id` = 0 ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000570s ]
SELECT `class_code`,`dict_code`,`dict_value`,`dict_remark`,`show_order` FROM `sys_dict_item` WHERE `class_code` = 'web_lang' AND `status` = 1 ORDER BY `show_order` DESC [ RunTime:0.000886s ]
SHOW FULL COLUMNS FROM `sys_custom_nav` [ RunTime:0.001017s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('en','zh-cn') AND `patch_sn` IN ('indexFollowus','footer_index','app_download','index_friend_chain') AND `status` = 1 [ RunTime:0.000753s ]
