We use cookies to give you the best possible experience on our website. For more details including how to change your cookie settings, please read our Cookies Policy
基本文件流程错误SQL调试
请求信息 : 2024-10-14 16:24:03 HTTP/1.1 GET : http://fdd.global.ibisaas.com/supplier-15/products.html
SHOW FULL COLUMNS FROM `global_config` [ RunTime:0.001547s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.000559s ]
SHOW FULL COLUMNS FROM `sys_config` [ RunTime:0.010293s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.004771s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.011371s ]
SHOW FULL COLUMNS FROM `sys_dict_item` [ RunTime:0.007174s ]
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.003655s ]
SHOW FULL COLUMNS FROM `goods_category` [ RunTime:0.015190s ]
SHOW FULL COLUMNS FROM `member` [ RunTime:0.022932s ]
SELECT `id`,`company_id`,`email`,`username`,`country_id`,`country`,`full_name`,`avatar`,`gender`,`tel_prefix`,`tel_number`,`company_name`,`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`,`company_audit_operator`,`source`,`status`,`reg_ip`,`last_login_time`,`last_login_ip`,`source_url`,`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`,`whatsapp`,`features_label`,`features_img`,`management_cert`,`is_admin_apply` FROM `member` WHERE ( `company_id` = 15 AND `is_supply` = 1 AND `company_auth_status` IN (2,3) ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.002636s ]
SHOW FULL COLUMNS FROM `region` [ RunTime:0.003919s ]
SHOW FULL COLUMNS FROM `member_company` [ RunTime:0.007786s ]
SELECT `lang`,`main_product`,`estab_time`,`company_id`,`supply_size`,`company_annex`,`introduction_desc`,`introduction` FROM `member_company` WHERE `company_id` = 15 [ RunTime:0.003850s ]
SELECT `class_code`,`dict_code`,`dict_value`,`dict_remark`,`show_order` FROM `sys_dict_item` WHERE `class_code` = 'supplierFeatures' AND `status` = 1 ORDER BY `show_order` DESC [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `goods_company_category` [ RunTime:0.001590s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order` FROM `goods_company_category` WHERE `company_id` = 15 AND `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000520s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order` FROM `goods_company_category` WHERE `company_id` = 15 AND `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `member_collect` [ RunTime:0.001207s ]
SHOW FULL COLUMNS FROM `seo_tdk_rule` [ RunTime:0.001258s ]
SELECT * FROM `seo_tdk_rule` WHERE `page_code` = 'shop_index' AND `lang` = 'en' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006657s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.001153s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.007338s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.003326s ]
SELECT COUNT(*) AS think_count FROM `goods` WHERE ( `lang` = 'en' AND `company_id` = 15 AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' [ RunTime:0.002221s ]
SELECT `id`,`ref_id`,`goods_sn`,`lang`,`third_goods_sn`,`code`,`goods_name`,`activity_type`,`activity_id`,`activity_status`,`activity_start_time`,`activity_end_time`,`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`,`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`,`sample_id`,`is_for_like` FROM `goods` WHERE ( `lang` = 'en' AND `company_id` = 15 AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' ORDER BY `show_level` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.004619s ]
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` = 15 ) AND `member`.`delete_time` = '0' [ RunTime:0.000643s ]
SELECT `lang`,`main_product`,`estab_time`,`company_id`,`supply_size`,`company_annex`,`introduction_desc`,`introduction` FROM `member_company` WHERE `company_id` = 15 [ RunTime:0.000521s ]
SELECT `class_code`,`dict_code`,`dict_value`,`dict_remark`,`show_order` FROM `sys_dict_item` WHERE `class_code` = 'supplierFeatures' AND `status` = 1 ORDER BY `show_order` DESC [ RunTime:0.024288s ]
SHOW FULL COLUMNS FROM `goods_unit` [ RunTime:0.005326s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order` FROM `goods_company_category` WHERE `company_id` = 15 AND `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.008558s ]
SELECT `ref_id`,`pid`,`company_id`,`lang`,`category_name`,`category_image`,`create_time`,`trans_type`,`trans_status`,`update_time`,`show_order` FROM `goods_company_category` WHERE `company_id` = 15 AND `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `sys_patch` [ RunTime:0.005847s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` = 'ga_statistics' AND `status` = 1 [ RunTime:0.007378s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.009043s ]
SELECT * FROM `member` WHERE ( `id` = 0 ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.009591s ]
SHOW FULL COLUMNS FROM `sys_custom_nav` [ RunTime:0.007995s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.000572s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` = 'app_download' AND `status` = 1 [ RunTime:0.001034s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` IN ('indexFollowus','footer_index','app_download') AND `status` = 1 [ RunTime:0.001541s ]
