Мы используем cookies, чтобы обеспечить вам наилучший возможный опыт на нашем сайте. Для получения более подробной информации, включая инструкции по изменению настроек cookies, пожалуйста, ознакомьтесь с нашей Политикой Cookies
基本文件流程错误SQL调试
请求信息 : 2024-10-14 14:18:53 HTTP/1.1 GET : http://ru.fdd.global.ibisaas.com/shop/list
SHOW FULL COLUMNS FROM `global_config` [ RunTime:0.021503s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.022048s ]
SHOW FULL COLUMNS FROM `sys_config` [ RunTime:0.010321s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'en' ORDER BY `show_order` DESC [ RunTime:0.005852s ]
SELECT `config_key`,`input_type`,`config_value` FROM `sys_config` WHERE `lang` = 'ru' ORDER BY `show_order` DESC [ RunTime:0.012502s ]
SHOW FULL COLUMNS FROM `sys_dict_item` [ RunTime:0.048478s ]
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.039389s ]
SHOW FULL COLUMNS FROM `goods_category` [ RunTime:0.026817s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.007830s ]
SELECT `company_id` FROM `goods` WHERE ( `lang` = 'ru' AND `goods_status` = 1 AND `audit_status` = 1 ) AND `goods`.`delete_time` = '0' [ RunTime:0.004394s ]
SHOW FULL COLUMNS FROM `member` [ RunTime:0.002426s ]
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,14,15) AND `shop_status` = 1 ) AND `member`.`delete_time` = '0' [ RunTime:0.000844s ]
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,14,15) AND `shop_status` = 1 ) AND `member`.`delete_time` = '0' ORDER BY `is_self` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.000801s ]
SHOW FULL COLUMNS FROM `member_company` [ RunTime:0.001563s ]
SELECT `lang`,`main_product`,`estab_time`,`company_id`,`supply_size`,`company_annex`,`introduction_desc`,`introduction` FROM `member_company` WHERE `company_id` IN (31,14,11,5,91,70,49) [ RunTime:0.000579s ]
SHOW FULL COLUMNS FROM `region` [ RunTime:0.001993s ]
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.001202s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.004532s ]
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` = 14 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.032797s ]
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` = 14 AND `ref_id` <> 638 AND `goods_status` = 1 AND `audit_status` = 1 AND `lang` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.028954s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.062415s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.053849s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.008977s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.006900s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.004399s ]
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` = 'ru' ) AND `goods`.`delete_time` = '0' LIMIT 4 [ RunTime:0.019079s ]
SHOW FULL COLUMNS FROM `seo_tdk_rule` [ RunTime:0.023160s ]
SELECT * FROM `seo_tdk_rule` WHERE `page_code` = 'shop_list' AND `lang` IN ('ru','en') ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006694s ]
SHOW FULL COLUMNS FROM `sys_patch` [ RunTime:0.027676s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('ru','en') AND `patch_sn` = 'ga_statistics' AND `status` = 1 [ RunTime:0.033434s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.058321s ]
SELECT * FROM `member` WHERE ( `id` = 0 ) AND `member`.`delete_time` = '0' LIMIT 1 [ RunTime:0.017279s ]
SELECT * FROM `seo_tdk_rule` WHERE `page_code` = 'shop_list' AND `lang` IN ('ru','en') ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004328s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('ru','en') AND `patch_sn` = 'supply_banner' AND `status` = 1 [ RunTime:0.009570s ]
SHOW FULL COLUMNS FROM `sys_custom_nav` [ RunTime:0.008029s ]
SELECT `config_name`,`config_key`,`config_value`,`config_remark` FROM `global_config` ORDER BY `show_order` DESC [ RunTime:0.017328s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('ru','en') AND `patch_sn` = 'app_download' AND `status` = 1 [ RunTime:0.009502s ]
SELECT `lang`,`patch_type`,`patch_sn`,`patch_content` FROM `sys_patch` WHERE `lang` IN ('ru','en') AND `patch_sn` IN ('indexFollowus','footer_index','app_download') AND `status` = 1 [ RunTime:0.005940s ]