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 12:27:37 HTTP/1.1 GET : http://fdd.global.ibisaas.com/shop/list
SHOW FULL COLUMNS FROM `global_config` [ RunTime:0.000992s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.000417s ]
SHOW FULL COLUMNS FROM `sys_config` [ RunTime:0.000967s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000430s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.000364s ]
SHOW FULL COLUMNS FROM `sys_dict_item` [ RunTime:0.000876s ]
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.000368s ]
SHOW FULL COLUMNS FROM `goods_category` [ RunTime:0.000951s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.001477s ]
SELECT `company_id` FROM `goods` WHERE ( `lang` = 'en' AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' [ RunTime:0.001286s ]
SHOW FULL COLUMNS FROM `member` [ RunTime:0.001416s ]
SELECT COUNT(*) AS think_count FROM `member` WHERE ( `is_supply` = 1 AND `company_auth_status` = 3 AND `company_id` IN (5,31,49,11,70,91,4,15) AND `shop_status` = 1 ) AND `member`.`delete_time` = '0' [ RunTime:0.000533s ]
SELECT `is_self`,`company_id`,`company_name`,`cn_company_name`,`company_logo`,`country_id`,`country`,`business_type`,`features_label`,`features_img` FROM `member` WHERE ( `is_supply` = 1 AND `company_auth_status` = 3 AND `company_id` IN (5,31,49,11,70,91,4,15) AND `shop_status` = 1 ) AND `member`.`delete_time` = '0' ORDER BY `is_self` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `member_company` [ RunTime:0.000937s ]
SELECT `lang`,`main_product`,`estab_time`,`company_id`,`supply_size`,`company_annex`,`introduction_desc`,`introduction` FROM `member_company` WHERE `company_id` IN (31,11,5,91,70,49) [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `region` [ RunTime:0.000879s ]
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.000417s ]
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`,`goods_content`,`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 ( `company_id` = 31 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.001154s ]
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`,`goods_content`,`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 ( `company_id` = 11 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.001201s ]
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`,`goods_content`,`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 ( `company_id` = 5 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.000652s ]
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`,`goods_content`,`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 ( `company_id` = 91 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.003202s ]
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`,`goods_content`,`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 ( `company_id` = 91 AND `ref_id` <> 633 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.003091s ]
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`,`goods_content`,`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 ( `company_id` = 70 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.001188s ]
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`,`goods_content`,`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 ( `company_id` = 49 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'en' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.001184s ]
SHOW FULL COLUMNS FROM `seo_tdk_rule` [ RunTime:0.001060s ]
SELECT * FROM `seo_tdk_rule` WHERE `page_code` = 'shop_list' AND `lang` = 'en' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SHOW FULL COLUMNS FROM `sys_patch` [ RunTime:0.001117s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` = 'ga_statistics' AND `status` = 1 [ RunTime:0.000598s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.000388s ]
SELECT * FROM `member` WHERE ( `id` = 0 ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000587s ]
SELECT * FROM `seo_tdk_rule` WHERE `page_code` = 'shop_list' AND `lang` = 'en' ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` = 'supply_banner' AND `status` = 1 [ RunTime:0.000472s ]
SHOW FULL COLUMNS FROM `sys_custom_nav` [ RunTime:0.002384s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.000516s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` = 'en' AND `patch_sn` = 'app_download' AND `status` = 1 [ RunTime:0.000807s ]
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.000797s ]