oceanbase/unittest/share/schema/gen_ddl_sql/dml.test

SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND (str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") >= start_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < start_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < end_time) OR str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") >= end_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < end_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") > start_time;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1;
SELECT id, group_name, owner, start_date, end_date , gmt_create, gmt_modified FROM category_group_base WHERE end_date > now() AND id = 1 ORDER BY id ASC LIMIT 1;
SELECT * FROM pmp_seller_group_score WHERE 1 = 2;
SELECT id, gmt_create, gmt_modified, reason, nick , check_id, status FROM review_reason_config ORDER BY status DESC;
SELECT COUNT(1) FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND cat_id = 1 AND status = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id = 1 AND status > 1 AND options  or 1<1 ORDER BY start_time DESC LIMIT 1;
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND status = 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND bid_status = 1 AND ifnull(options, 1)  and 1=1;
SELECT COUNT(1) FROM bid_album WHERE album_id = 1 AND album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT cat_id FROM bid_settle_cat WHERE status = 1 AND pcat_id = 1;
SELECT COUNT(id) FROM cycle_bid_foregifts WHERE cycle_id = 1 AND status > 1;
SELECT id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift FROM bid_auction_message WHERE outer_id = 1;
SELECT id, gmt_create, gmt_modified, venue_id, album_id , item_id, message, message_time_stamp, message_type, message_params FROM tbp_message WHERE album_id = 1 ORDER BY message_time_stamp DESC LIMIT 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 AND status = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, appraiser_id, status , push_number, batch_id FROM ta_push_task WHERE batch_id = "2015-09-30 12:00:00" AND status = 1 LIMIT 1;
SELECT user_id, group_id, group_name, score, rank , gmv, price, cj_rate, wq_jr_num, wq_num , is_have FROM pmp_seller_group_score WHERE log_dt = "2015-09-30 12:00:00" AND user_id = 1 AND group_id = 1 LIMIT 1;
SELECT id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift FROM bid_auction_message WHERE status != 1 AND user_id = 1 AND outer_id = 1 AND type = 1 LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, operate_type, status, amount , type, memo, target_id, cycle_id, gmt_create , gmt_modified FROM settler_user_foregift WHERE user_id = 1 AND operate_type = 1;
SELECT id, gmt_end, extra_property, gmt_create, gmt_modified FROM bid_activity WHERE id = 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1;
SELECT id, gmt_create, gmt_modified, record_id, check_id , reason_id, ext_memo, cat_id, seller_id FROM review_result_relation WHERE record_id = 1;
SELECT COUNT(id) FROM seller_apply_info WHERE month_plan_id = 1 AND use_day >= "2015-09-30 12:00:00" AND use_day <= "2015-09-30 12:00:00" AND group_id = 1 AND status = 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND pcat_id = 1;
SELECT id, user_id, album_id, group_id, day_plan_id , status, type, category_id, use_day, gmt_create , gmt_modified, month_plan_id FROM seller_apply_info WHERE album_id = 1 AND status = 1 LIMIT 1;
SELECT id, gmt_create, gmt_modified, user_id, user_nick , remind_cnt FROM app_user_info WHERE user_id = 1;
SELECT COUNT(1) FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND end_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY audit_max_date ASC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND status = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" AND organization LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, object_type, object_id, free_type, starts , end, operator, is_deleted, gmt_create, gmt_modified FROM service_free WHERE is_deleted = 1 AND object_id = 1 AND object_type = 1;
SELECT id, gmt_create, gmt_modified, user_id, opt_id , start_date, end_date, reason_id, excute_date, cc_desc , status, cc_comment, excute_status, source_id, source_type , cc_unit FROM cc_seller_record WHERE status = 1 AND end_date = "2015-09-30 12:00:00" ORDER BY id DESC LIMIT 1;
SELECT bid_extra.id, bid_extra.item_id, bid_extra.cycle_id, bid_extra.title, bid_extra.auction_starts , bid_extra.auction_ends, bid_extra.auction_type, bid_extra.bid_status, bid_extra.features, bid_extra.options , bid_extra.attribute_cc, bid_extra.gmt_create, bid_extra.gmt_modified, bid_extra.current_price, bid_extra.reserve_price , bid_extra.next_bid, bid_extra.user_id, bid_extra.start_price, bid_extra.album_id, bid_extra.album_status , bid_extra.s_desc, bid_extra.fail_reason, bid_extra.cat_id, bid_extra.biz_cat_id, bid_extra.sort_seq , bid_extra.hour_forbid, bid_extra.item_tag FROM bid_extra bid_extra WHERE bid_extra.item_id = 1;
SELECT id, gmt_create, gmt_modified, type, deal_mode , target_id FROM offline_rule_config;
SELECT t.cycle_id, t.amount FROM (SELECT cycle_id, SUM(amount) AS amount FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status = 1 AND ifnull(options, 1)  or 1<1 AND ifnull(options, 1)  or 1<1 AND gmt_create > str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND gmt_create < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") GROUP BY cycle_id ORDER BY id DESC LIMIT 1, 1 ) t;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND (type = 1 AND status = 1 OR type != 1) ORDER BY id DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, user_id, opt_id , start_date, end_date, reason_id, excute_date, cc_desc , status, cc_comment, excute_status, source_id, source_type , cc_unit FROM cc_seller_record WHERE status = 1 AND excute_date = "2015-09-30 12:00:00" ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, user_id, cat_id , record_id, pics, status, props, complete_info , longitude, latitude, position, division_id, version , distribution, submit_time, name, tel, reports , prop_ids FROM user_ta_treasure WHERE user_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY submit_time DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE foregift_id = 1;
SELECT id, user_id, user_nick, owner, group_id , type, effective_start, effective_end, num, memo FROM seller_reward WHERE status = 1 AND type = 1 AND group_id = 1 ORDER BY effective_start ASC LIMIT 1;
SELECT user_id FROM bid_settler WHERE organization = "2015-09-30 12:00:00";
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_auction_message WHERE user_id = 1 AND status != 1 AND type IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND buyer_id = 1 ORDER BY bid_price DESC, gmt_create DESC, id DESC;
SELECT COUNT(1) FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND apply_status = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(1) FROM bid_album WHERE album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, name, status, start_time, end_time , attribute_cc, current_zhibo, gmt_create, gmt_modified FROM bid_venue WHERE start_time < "2015-09-30 12:00:00" AND end_time > "2015-09-30 12:00:00" ORDER BY id DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 AND auction_no = "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT biz_cat_id FROM bid_album_cat WHERE album_id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_auction_message WHERE scan_date >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND scan_date < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status != 1 AND (forbid_flag IS NULL OR forbid_flag = 1);
SELECT MIN(id) FROM bid_auction_message WHERE scan_date >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND scan_date < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status != 1 AND (forbid_flag IS NULL OR forbid_flag = 1);
SELECT COUNT(id) FROM user_ta_treasure WHERE user_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, gmt_create, gmt_modified, treasure_id, appraiser_id , status, submit_time, distribution, report_id, version , cat_id FROM ta_record WHERE id = 1;
SELECT cat_id FROM bid_settle_cat WHERE status = 1 AND level = 1 AND pcat_id = 1;
SELECT COUNT(id) FROM seller_apply_info WHERE use_day = "2015-09-30 12:00:00" AND group_id = 1 AND user_id = 1 AND status = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, biz_cat_bit, biz_cat_id, sort_seq , item_type FROM bid_extra WHERE item_id = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift FROM bid_auction_message WHERE id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, gmt_create, gmt_modified, cat_id, pcat_id , level, status, operator, start, end , error, trade_rate, biz_type, brokerage_id FROM bid_brokerage_cat WHERE 1 = 1 AND gmt_modified >= "2015-09-30 12:00:00" AND gmt_modified <= "2015-09-30 12:00:00";
SELECT id, seller_album_num, audit_cycle, pre_cycle_min, enroll_cycle , group_id, start_date, end_date, status, last_date FROM cat_month_plan WHERE id = 1;
SELECT COUNT(1) FROM master_authorize WHERE user_id = 1 AND master_id = 1 LIMIT 1;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND cat_id = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, user_nick, owner, group_id , type, effective_start, effective_end, num, memo FROM seller_reward WHERE id = 1 AND status = 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND user_id = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT id, group_name, owner, start_date, end_date , gmt_create, gmt_modified FROM category_group_base WHERE end_date > now() ORDER BY id ASC LIMIT 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND level = 1 AND cat_id = 1 AND pcat_id = 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status = 1 ORDER BY bid_price DESC, gmt_create ASC, id DESC LIMIT 1, 1;
SELECT id, name, status, start_time, end_time , attribute_cc, current_zhibo, gmt_create, gmt_modified FROM bid_venue ORDER BY id DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, cat_id, pcat_id , level, status, operator, start, end , error, trade_rate, biz_type, brokerage_id FROM bid_brokerage_cat WHERE cat_id = 1 AND biz_type = 1 AND status = 1 AND start <= now() AND end >= now() ORDER BY id DESC LIMIT 1;
SELECT seller_id AS sellerid, order_succ_count AS ordersucccount, order_succ_amount AS ordersuccamount, pass_auction_count AS passauctioncount, create_album_count AS createalbumcount , succ_auction_count AS succauctioncount, end_auction_count AS endauctioncount FROM bid_seller_file WHERE seller_id = 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 AND auther_id = 1 AND item_id = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, user_id, user_nick, owner, group_id , type, effective_start, effective_end, num, memo FROM seller_reward WHERE status = 1 AND group_id = 1 ORDER BY effective_start ASC LIMIT 1;
SELECT id, type, ref_id, user_id, operator , gmt_create, gmt_modified FROM user_whitelist WHERE ref_id = 1 AND type = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND title LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 AND review_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, operate_type, status, amount , type, memo, target_id, cycle_id, gmt_create , gmt_modified FROM settler_user_foregift WHERE user_id = 1 AND target_id = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND level = 1;
SELECT id, object_type, object_id, free_type, starts , end, operator, is_deleted, gmt_create, gmt_modified FROM service_free WHERE is_deleted = 1 AND if(end, end > now(), 1) AND starts <= now() AND object_id = 1 AND object_type = 1 AND free_type = 1;
SELECT id, seller_album_num, audit_cycle, pre_cycle_min, enroll_cycle , group_id, start_date, end_date, status, last_date FROM cat_month_plan WHERE group_id = 1 AND status = 1 AND start_date <= "2015-09-30 12:00:00" AND end_date > "2015-09-30 12:00:00" LIMIT 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id = 1 AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY audit_max_date ASC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND album_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT itemid, punishtype FROM bid_punish ORDER BY itemid DESC LIMIT 1, 1;
SELECT COUNT(DISTINCT buyer_id) FROM bid_auction WHERE cycle_id = 1 AND status = 1;
SELECT COUNT(*) FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat REGEXP "2015-09-30 12:00:00" AND organization LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT id, gmt_create, gmt_modified, venue_id, album_id , item_id, message, message_time_stamp, message_type, message_params FROM tbp_message WHERE item_id = 1 ORDER BY message_time_stamp DESC LIMIT 1;
SELECT SUM(amount) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND (type = 1 AND status = 1 OR type = 1 AND status = 1 OR type = 1 AND status = 1);
SELECT id, gmt_create, gmt_modified, album_id, album_status , status, cc_id, user_id, album_creator_id, album_type FROM cc_bid_album WHERE status = 1 ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE auther_id = 1 AND item_id = 1 AND role_type = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, order_id, source_type, pay_status, charge_status , cycle_id, item_id, buyer_id, seller_id, category_id , cat_id, amount, fee, gmt_create, gmt_modified FROM bid_trade WHERE order_id = 1 ORDER BY gmt_create ASC LIMIT 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status = 1 AND bid_price >= 1 ORDER BY bid_price DESC, gmt_create DESC;
SELECT group_id, group_name, user_id, score, rank , gmv, price, cj_rate, wq_jr_num, wq_num , log_dt, is_have FROM pmp_seller_group_score WHERE 1 = 2;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document WHERE id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1;
SELECT id, name, biz_cat_id, template, demo , placeholder, creator, gmt_create, gmt_modified FROM bid_extra_desc_template ORDER BY id DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 AND auction_no = "2015-09-30 12:00:00";
SELECT id, cycle_id, buyer_id, name, phone , address, memo, options, gmt_create, gmt_modified , cardno FROM bid_bidder_info WHERE cycle_id = 1 AND buyer_id = 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND user_id = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND item_type = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, operate_type, status, amount , type, memo, target_id, cycle_id, gmt_create , gmt_modified FROM settler_user_foregift WHERE id = 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 AND auther_id = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, gmt_create, gmt_modified, item_id, status , cc_id, user_id, auction_user_id, system, album_id , album_type, foregifts_scan FROM cc_bid_extra WHERE status = 1 ORDER BY id DESC LIMIT 1;
SELECT seller_id, order_succ_count, order_succ_amount, pass_auction_count, create_album_count , succ_auction_count, end_auction_count, gmt_create, gmt_modified FROM bid_seller_file WHERE seller_id = 1 ORDER BY succ_auction_count DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, cat_id, pcat_id , level, status, operator, start, end , error, trade_rate, biz_type, brokerage_id FROM bid_brokerage_cat WHERE cat_id = 1 AND pcat_id = 1 AND level = 1 AND status = 1 AND start <= now() AND end >= now();
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE id = 1 LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM bid_extra WHERE (bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND auction_ends BETWEEN str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") OR bid_status = 1 AND auction_ends > date_add(now(), INTERVAL 1 HOUR)) AND id > 1 AND item_type = 1 ORDER BY id ASC LIMIT 1;
SELECT id, unique_id, foregifts_id, foregifts_from, cycle_id , item_id, buyer_id, seller_id, account_out, amount , type, status, operator, error_code, alias_name , foregifts_gmt_create, foregifts_gmt_modified, contact, pause_flag, features , operate_time, action_time, options, address_id, admin_status , admin_user_id, admin_desc, gmt_create, gmt_modified FROM foregifts_unfreeze_fail WHERE 1 = 1 AND foregifts_id = 1 AND admin_status = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND user_id = 1 AND seller_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE type = 1 AND status = 1 AND gmt_create < date_add(now(), INTERVAL 1 DAY) AND action_time IS NULL LIMIT 1;
SELECT COUNT(1) FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM bid_extra WHERE item_id = 1;
SELECT * FROM (SELECT DISTINCT cat_id, biz_type, MAX(end) AS end FROM bid_brokerage_cat WHERE status = 1 GROUP BY cat_id, biz_type ) a WHERE a.end <= "2015-09-30 12:00:00";
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status = 1;
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 AND type = 1 AND status = 1;
SELECT COUNT(1) FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND cat_id = 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 ORDER BY id DESC LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, mobile_phone, email, notify_type , notify_interval, mail_sub_items, nick, update_phone, check_code , expire_time, flag, gmt_create, gmt_modified FROM bid_user_extra WHERE user_id = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE foregift_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT id, name, status, start_time, end_time , attribute_cc, current_zhibo, gmt_create, gmt_modified FROM bid_venue WHERE id = 1;
SELECT COUNT(1) FROM bid_album WHERE creator_id = 1 AND album_type = 1;
SELECT id, gmt_create, gmt_modified, obj_id, sponsor , sponsor_id, type, name, info, name_id FROM bid_process_detail WHERE obj_id = 1 ORDER BY id ASC;
SELECT SUM(num) FROM seller_reward WHERE status = 1 AND user_id = 1 AND group_id = 1 AND effective_start <= "2015-09-30 12:00:00" AND effective_end >= "2015-09-30 12:00:00";
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status = 1 AND ifnull(options, 1)  or 1<1 AND ifnull(options, 1)  or 1<1 AND gmt_create > str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND gmt_create < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 AND review_status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id FROM bid_auction_message WHERE scan_date >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND scan_date < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status != 1 AND (forbid_flag IS NULL OR forbid_flag = 1) AND id > 1 ORDER BY id ASC LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND bid_status >= 1;
SELECT COUNT(1) FROM master_document_edit WHERE name = "2015-09-30 12:00:00" AND cat_id = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM master_document WHERE id = 1;
SELECT cat_id FROM settler_cat WHERE user_id = 1 AND status = 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND user_id = 1 AND seller_type = 1;
SELECT id, gmt_create, gmt_modified, type, title , template, action_url, user_id FROM bid_seller_message WHERE user_id = 1 ORDER BY id DESC LIMIT 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id = 1 AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY status ASC, start_time DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND item_id = 1 AND album_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, user_id, nick , old_user_id, old_nick, import_relation, attribute FROM account_mapping WHERE user_id = 1 LIMIT 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status = 1 AND bid_price = 1 LIMIT 1;
SELECT id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift FROM bid_auction_message WHERE outer_id = 1 AND status = 1;
SELECT COUNT(1) FROM bid_album WHERE album_type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND audit_max_date <= "2015-09-30 12:00:00" ORDER BY id DESC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_album WHERE album_id = 1 AND album_type = 1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND apply_status = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT id, week_day, group_id, month_plan_id, type , divide_album_num, divide_name, divide_start_time, continue_time FROM cat_day_plan WHERE id = 1;
SELECT * FROM `album_bid_extra` LIMIT 1;
SELECT COUNT(1) FROM bid_album WHERE album_id = 1 AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, gmt_create, gmt_modified, treasure_id, cat_id , pic, result_type, user_id, appraiser_id, name , tel, reason, advise, invite, praise , vin, prop_title FROM ta_report WHERE id = 1 AND appraiser_id = 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT COUNT(*) FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND user_id = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, treasure_id, cat_id , status, submit_time, division_id, version, rand FROM ta_task WHERE cat_id = 1 AND "2015-09-30 12:00:00" > submit_time AND submit_time > "2015-09-30 12:00:00" AND status = 1 ORDER BY submit_time DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, reason, nick , check_id, status FROM review_reason_config;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE item_id = 1 ORDER BY id DESC LIMIT 1;
SELECT user_id FROM user_whitelist WHERE user_id = 1 AND ref_id = 1 AND type = 1;
SELECT id, biz_cat_name, biz_cat_id, cat_name, cat_id , group_id, type, start_date, end_date, gmt_create , gmt_modified FROM category_group_detail WHERE end_date > now() AND group_id = 1 ORDER BY group_id ASC;
SELECT id, user_id, user_nick, owner, group_id , type, effective_start, effective_end, num, memo FROM seller_reward WHERE status = 1 AND group_id = 1 AND effective_start <= "2015-09-30 12:00:00" AND effective_end >= "2015-09-30 12:00:00" ORDER BY effective_start ASC LIMIT 1;
SELECT COUNT(*) FROM bid_auction WHERE cycle_id = 1 AND status = 1;
SELECT COUNT(1) FROM bid_auction_message WHERE user_id = 1 AND scan_date >= now() AND status != 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND start_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 AND review_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT auction_id, title, user_id, user_nick, category , auction_type, auction_from, city, quantity, gmt_create , gmt_modified, auction_status, pict_url, attribute, property , ends, minimum_bid, incrementnum, currentprice, totalcnt , auctionscore, starts, desc_path FROM pmp_auctions_extra WHERE auction_id = 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND buyer_id = 1 AND status = 1 AND biz_order_id > 1;
SELECT id, user_id, nick, settled_amount, settled_actual_amount , service_amount, service_actual_amount, settle_type, user_rate, settle_status , seller_type, tasking, organization, contact, contact_number , organization_desc, location_id, gmt_create, gmt_modified FROM bid_settler WHERE settle_status = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT pict_url FROM pmp_auctions_extra WHERE auction_id = 1;
SELECT id, gmt_create, gmt_modified, user_id, cat_id , record_id, pics, status, props, complete_info , longitude, latitude, position, division_id, version , distribution, submit_time, name, tel, reports , prop_ids FROM ta_treasure WHERE id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT COUNT(*) FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND user_id = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status = 1 ORDER BY bid_price DESC, gmt_create, id DESC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_punish;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND end_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY status ASC, start_time DESC LIMIT 1, 1;
SELECT album_id FROM bid_album_cat WHERE biz_cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM bid_extra WHERE auction_ends > str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND auction_ends < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND (type = 1 AND status = 1 OR type = 1 AND status = 1 OR type = 1 AND status = 1) ORDER BY id DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, appraiser_id, name , title, org_name, org_id, rank, cat_id , online, image_url, appraiser_no, city_division, province_division , position, char_1 FROM ta_appraiser WHERE appraiser_id = 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 AND item_id = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT seller_id, order_succ_count, order_succ_amount, pass_auction_count, create_album_count , succ_auction_count, end_auction_count, gmt_create, gmt_modified FROM bid_seller_file ORDER BY succ_auction_count DESC LIMIT 1, 1;
SELECT album_id, title, tags, start_time, end_time , banner_path FROM bid_album WHERE album_id = 1;
SELECT id, user_id, commission_unpay_amount, gmt_create, gmt_modified , fee_type, quantity, amount, status, trade_id , p_trade_id FROM bid_huijin WHERE user_id = 1 AND commission_unpay_amount > 1;
SELECT COUNT(1) FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status = 1;
SELECT id, gmt_create, gmt_modified, album_id, sort FROM bid_album_sort WHERE album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND album_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT * FROM `seller_bid_extra` LIMIT 1;
SELECT COUNT(*) FROM foregifts_unfreeze_fail WHERE 1 = 1 AND foregifts_id = 1 AND admin_status = 1;
SELECT bau.id, bau.user_id, bau.outer_id, bau.type, bau.status , bau.scan_date, bau.gmt_create, bau.gmt_modified, bau.notify_interval, bau.forbid_flag , bau.short_url, bau.cycle_id, bau.title, bau.start, bau.end , bau.foregift FROM (SELECT id FROM bid_auction_message WHERE user_id = 1 AND status != 1 AND type IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1 ) t, bid_auction_message bau WHERE bau.id = t.id;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM bid_extra WHERE item_id = 1;
SELECT id, gmt_create, gmt_modified, name, day_size , type, value, template, need_source FROM cc_seller_reason WHERE id = 1;
SELECT COUNT(id) FROM seller_apply_info WHERE day_plan_id = 1 AND status = 1;
SELECT id, week_day, group_id, month_plan_id, type , divide_album_num, divide_name, divide_start_time, continue_time FROM cat_day_plan WHERE group_id = 1 AND month_plan_id = 1 ORDER BY divide_start_time ASC LIMIT 1;
SELECT COUNT(1) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND (type = 1 AND status = 1 OR type = 1 AND status = 1 OR type = 1 AND status = 1);
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE user_id = 1 AND id = 1;
SELECT COUNT(1) FROM bid_album WHERE album_id = 1 AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND start_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND user_id = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, cc_id, item_id , buyer_id, system, send_message, foregift_id, cycle_id , foregift_status FROM cc_bid_foregift WHERE 1 = 1 AND foregift_status = 1 ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id DESC LIMIT 1, 1;
SELECT COUNT(*) FROM bid_settler WHERE settle_status = 1;
SELECT id, unique_id, foregifts_id, foregifts_from, cycle_id , item_id, buyer_id, seller_id, account_out, amount , type, status, operator, error_code, alias_name , foregifts_gmt_create, foregifts_gmt_modified, contact, pause_flag, features , operate_time, action_time, options, address_id, admin_status , admin_user_id, admin_desc, gmt_create, gmt_modified FROM foregifts_unfreeze_fail WHERE 1 = 1 AND admin_status = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND bid_status >= 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND bid_status >= 1 AND ifnull(options, 1)  and 1=1 ORDER BY sort_seq ASC;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM bid_extra WHERE (bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND auction_ends BETWEEN str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") OR bid_status = 1 AND auction_ends > date_add(now(), INTERVAL 1 HOUR)) AND id > 1 AND item_type = 1 ORDER BY id ASC LIMIT 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id = 1 AND album_type = 1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY audit_max_date ASC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, user_id, user_nick, owner, group_id , type, effective_start, effective_end, num, memo FROM seller_reward WHERE status = 1 AND user_id = 1 AND group_id = 1 AND effective_start <= "2015-09-30 12:00:00" AND effective_end >= "2015-09-30 12:00:00" ORDER BY effective_start ASC LIMIT 1;
SELECT id, user_id, album_id, group_id, day_plan_id , status, type, category_id, use_day, gmt_create , gmt_modified, month_plan_id FROM seller_apply_info WHERE use_day >= "2015-09-30 12:00:00" AND use_day <= "2015-09-30 12:00:00" AND user_id = 1 AND status = 1 AND group_id = 1 ORDER BY use_day ASC;
SELECT id, week_day, group_id, month_plan_id, type , divide_album_num, divide_name, divide_start_time, continue_time FROM cat_day_plan WHERE week_day = 1 AND group_id = 1 AND month_plan_id = 1 ORDER BY divide_start_time ASC LIMIT 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND gmt_create BETWEEN str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id ASC LIMIT 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND level = 1 AND cat_id = 1;
SELECT id, gmt_create, gmt_modified, name, category_id , scene, nick, status FROM review_check_config WHERE category_id = 1 AND scene = 1 ORDER BY status DESC;
SELECT COUNT(1) FROM bid_auction_message WHERE outer_id = 1 AND status != 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY gmt_create DESC, bid_price DESC, id DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, user_id, opt_id , start_date, end_date, reason_id, excute_date, cc_desc , status, cc_comment, excute_status, source_id, source_type , cc_unit FROM cc_seller_record WHERE user_id = 1 ORDER BY id DESC;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND user_id = 1 AND task_type = 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND album_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, gmt_create, gmt_modified, name, day_size , type, value, template, need_source FROM cc_seller_reason ORDER BY id DESC LIMIT 1;
SELECT id, seller_album_num, audit_cycle, pre_cycle_min, enroll_cycle , group_id, start_date, end_date, status, last_date FROM cat_month_plan WHERE end_date > "2015-09-30 12:00:00" AND group_id = 1 AND status = 1 ORDER BY start_date ASC LIMIT 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND cat_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 AND type = 1 AND status = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM cycle_bid_foregifts WHERE cycle_id = 1 AND status > 1 ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, user_id, nick , old_user_id, old_nick, import_relation, attribute FROM account_mapping WHERE old_user_id = 1 LIMIT 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id = 1 AND album_type = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND user_id = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE item_id = 1 AND role_type = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT id, biz_cat_name, biz_cat_id, cat_name, cat_id , group_id, type, start_date, end_date, gmt_create , gmt_modified FROM category_group_detail WHERE end_date > now() AND biz_cat_id = 1 ORDER BY group_id ASC;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM cycle_bid_foregifts WHERE cycle_id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" AND organization LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT id, gmt_create, gmt_modified, user_id, opt_id , start_date, end_date, reason_id, excute_date, cc_desc , status, cc_comment, excute_status, source_id, source_type , cc_unit FROM cc_seller_record WHERE status = 1 AND excute_date = "2015-09-30 12:00:00" AND excute_status = 1 ORDER BY id DESC LIMIT 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE user_id = 1 AND task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND task_dealed = 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND cat_id = 1;
SELECT auction_id, title, minimum_bid, incrementnum, pict_url , category, city, quantity, user_id, user_nick , auction_status, auction_from, auction_type, ends, gmt_modified , gmt_create, property, currentprice, totalcnt, auctionscore , attribute, starts, desc_path, delay_secends, delay_times , buyer_qualification, type FROM pmp_auctions_extra WHERE auction_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND cat_id = 1 AND status = 1 ORDER BY id DESC LIMIT 1, 1;
SELECT settled_actual_amount, organization_desc, settle_status, settled_amount, date_format(gmt_modified, "2015-09-30 12:00:00") AS gmt_modified , user_rate, contact, location_id, service_actual_amount, contact_number , id, date_format(gmt_create, "2015-09-30 12:00:00") AS gmt_create, organization, tasking, nick , user_id, seller_type, service_amount, settle_type FROM bid_settler;
SELECT COUNT(1) FROM bid_album WHERE album_type = 1 AND apply_status = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, user_id, album_id, group_id, day_plan_id , status, type, category_id, use_day, gmt_create , gmt_modified, month_plan_id FROM seller_apply_info WHERE use_day >= "2015-09-30 12:00:00" AND use_day <= "2015-09-30 12:00:00" AND status = 1 AND group_id = 1 ORDER BY use_day ASC;
SELECT id, gmt_create, gmt_modified, biz_id, biz_type , status, action_time, try_count, failed_count, features , version FROM timeout_records WHERE biz_id = 1 AND biz_type = 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND album_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE user_id = 1 AND task_status = 1 ORDER BY gmt_create DESC LIMIT 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id = 1 AND album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY audit_max_date ASC LIMIT 1, 1;
SELECT COUNT(*) FROM bid_auction WHERE cycle_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(1) FROM bid_album WHERE album_type = 1 AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND audit_max_date <= "2015-09-30 12:00:00";
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 AND review_status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(*) FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT COUNT(1) FROM ta_push_task WHERE batch_id = "2015-09-30 12:00:00" AND status = 1;
SELECT DISTINCT buyer_id FROM bid_auction WHERE cycle_id = 1 AND status = 1;
SELECT id, gmt_create, gmt_modified, item_id, status , cc_id, user_id, auction_user_id, system, album_id , album_type, foregifts_scan FROM cc_bid_extra WHERE status = 1 AND foregifts_scan < 1 ORDER BY id DESC LIMIT 1;
SELECT COUNT(id) FROM seller_apply_info WHERE use_day = "2015-09-30 12:00:00" AND group_id = 1 AND status = 1 AND type = 1 AND day_plan_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(1) FROM master_document WHERE cat_id = 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND user_id = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, user_id, cat_id , record_id, pics, status, props, complete_info , longitude, latitude, position, division_id, version , distribution, submit_time, name, tel, reports , prop_ids FROM user_ta_treasure WHERE id = 1 AND user_id = 1;
SELECT id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp FROM bid_auction WHERE cycle_id = 1 AND status = 1 ORDER BY bid_price DESC, gmt_create DESC, id DESC LIMIT 1, 1;
SELECT id, name, title, cat_id, image_url , describtion FROM master_document WHERE cat_id = 1 ORDER BY id ASC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, cycle_id, buyer_id, proxy_bid, status , gmt_create, gmt_modified FROM bid_proxy WHERE cycle_id = 1;
SELECT COUNT(1) FROM bid_album WHERE creator_id = 1 AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type = 1 AND apply_status = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM bid_extra WHERE auction_ends > str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND auction_ends < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND item_id IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, object_type, object_id, free_type, starts , end, operator, is_deleted, gmt_create, gmt_modified FROM service_free WHERE is_deleted = 1 AND object_id = 1 AND object_type = 1 AND free_type = 1;
SELECT COUNT(1) FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT id, gmt_create, gmt_modified, name, category_id , scene, nick, status FROM review_check_config WHERE category_id = 1 AND scene = 1;
SELECT COUNT(*) AS totalcnt FROM bid_auction WHERE cycle_id = 1 AND status = 1;
SELECT id, user_id, nick, status, start_time , end_time, app_id, count, operator_id, complainant , reason FROM black_list WHERE app_id = 1 AND user_id = 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND gmt_create > str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND gmt_create < str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE type = 1 AND status = 1 AND action_time < now() LIMIT 1;
SELECT COUNT(*) FROM audit_task WHERE task_status = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00";
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT COUNT(*) FROM bid_settler;
SELECT cat_id FROM settler_cat WHERE user_id = 1 AND target_id = 1 AND status = 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND user_id = 1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1;
SELECT COUNT(1) FROM bid_album WHERE album_id = 1 AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND bid_status >= 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(*) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 AND status = 1;
SELECT id, biz_cat_name, biz_cat_id, cat_name, cat_id , group_id, type, start_date, end_date, gmt_create , gmt_modified FROM category_group_detail WHERE end_date > now() AND cat_id = 1 ORDER BY group_id ASC;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND bid_status >= 1 AND ifnull(options, 1)  and 1=1 ORDER BY sort_seq ASC;
SELECT org_id FROM top_follow_org WHERE user_id = 1 LIMIT 1;
SELECT id, gmt_create, gmt_modified, album_id, item_id , memo, auther_id, auther, role_type, action , current_number FROM review_record WHERE album_id = 1 AND role_type = 1 AND action IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY id DESC LIMIT 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM cycle_bid_foregifts WHERE cycle_id = 1 AND (status > 1 OR status = 1 AND type = 1) ORDER BY id DESC LIMIT 1;
SELECT id, gmt_create, gmt_modified, master_id, user_id , authorize_start, authorize_end, status, authorize_type, cat_id FROM master_authorize WHERE master_id = 1 LIMIT 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND user_id = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM bid_extra WHERE item_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT COUNT(*) FROM foregifts_unfreeze_fail WHERE 1 = 1 AND admin_status = 1;
SELECT COUNT(1) FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND item_type = 1;
SELECT id, gmt_create, gmt_modified, treasure_id, cat_id , status, submit_time, division_id, version, rand FROM ta_task WHERE treasure_id = 1;
SELECT id, cat_id, name, pcat_id, level , settled_amount, trade_rate, status, operator, recommend_word , gmt_create, gmt_modified, stop_status, stop_time FROM bid_settle_cat WHERE status = 1 AND level = 1 AND pcat_id = 1;
SELECT COUNT(1) FROM master_document_edit WHERE 1 = 1 AND name LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00");
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM bid_foregifts WHERE type = 1 AND status = 1 LIMIT 1;
SELECT COUNT(1) FROM buyer_bid_foregifts WHERE buyer_id = 1 AND (type = 1 AND status = 1 OR type != 1);
SELECT MAX(sort_seq) FROM album_bid_extra WHERE album_id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, biz_cat_name, biz_cat_id, cat_name, cat_id , group_id, type, start_date, end_date, gmt_create , gmt_modified FROM category_group_detail WHERE "2015-09-30 12:00:00" BETWEEN start_date AND end_date AND cat_id = 1 ORDER BY group_id ASC;
SELECT id, gmt_create, gmt_modified, biz_id, biz_type , status, action_time, try_count, failed_count, features , version FROM timeout_records WHERE status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND action_time < "2015-09-30 12:00:00" AND id > 1 ORDER BY id ASC LIMIT 1;
SELECT COUNT(1) FROM bid_album WHERE creator_id = 1 AND album_type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM bid_extra WHERE item_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT id, name, biz_cat_id, template, demo , placeholder, creator, gmt_create, gmt_modified FROM bid_extra_desc_template WHERE id = 1;
SELECT id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift FROM bid_auction_message WHERE user_id = 1 AND scan_date >= now() AND status != 1 ORDER BY id DESC LIMIT 1, 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_type = 1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND end_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND end_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY id DESC LIMIT 1, 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE task_status = 1 AND task_type = 1 AND biz_cat REGEXP "2015-09-30 12:00:00" ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT id, foregift_id, cycle_id, item_id, buyer_id , seller_id, account_out, amount, type, status , operator, gmt_create, gmt_modified, error_code, operate_time , action_time, options, address_id, features, pre_auth_id , transform_amont, unfreeze_amont, alias_name FROM buyer_bid_foregifts WHERE buyer_id = 1 AND cycle_id = 1 AND type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM bid_activity;
SELECT COUNT(*) FROM bid_album WHERE status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND (str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") >= start_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < start_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < end_time OR str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") >= end_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") < end_time AND str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") > start_time);
SELECT id, gmt_create, gmt_modified, cc_id, item_id , buyer_id, system, send_message, foregift_id, cycle_id , foregift_status FROM cc_bid_foregift WHERE 1 = 1 AND send_message = 1 ORDER BY id DESC LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name, review_status FROM album_bid_extra WHERE album_id = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE creator_id NOT IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND album_type = 1 AND options  or 1<1 AND options  or 1<1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND start_time >= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") AND start_time <= str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00") ORDER BY start_time ASC LIMIT 1, 1;
SELECT COUNT(id) FROM seller_apply_info WHERE day_plan_id = 1 AND use_day = "2015-09-30 12:00:00" AND status = 1 AND type = 1;
SELECT id, gmt_end, extra_property, gmt_create, gmt_modified FROM bid_activity ORDER BY id DESC LIMIT 1, 1;
SELECT user_id FROM user_whitelist WHERE ref_id = 1 AND type = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id = 1 AND album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND options  and 1=1 AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523) ORDER BY audit_max_date ASC LIMIT 1, 1;
SELECT id, user_id, nick, settled_amount, settled_actual_amount , service_amount, service_actual_amount, settle_type, user_rate, settle_status , seller_type, tasking, organization, contact, contact_number , organization_desc, location_id, gmt_create, gmt_modified FROM bid_settler WHERE user_id = 1 AND settle_status = 1 ORDER BY gmt_create ASC;
SELECT COUNT(id) FROM seller_apply_info WHERE day_plan_id = 1 AND use_day = "2015-09-30 12:00:00" AND status = 1;
SELECT id, album_id, biz_cat, title, banner_path , tiny_desc, apply_status, info, auction_limit, start_time , end_time, status, options, creator_id, fail_reason , gmt_create, gmt_modified, features, property, active_link , mobile_active_link, seller_auction_limit, apply_cnt, bid_cnt, deal_cnt , deal_amount, bidder_cnt, album_type, audit_date, audit_max_date , apply_date FROM bid_album WHERE album_id IN (1,2,4,6,7,8,11,56,68,89,435,4523) LIMIT 1;
SELECT id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra FROM audit_task WHERE id = 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM album_bid_extra WHERE album_id = 1 AND ifnull(options, 1)  and 1=1 AND ifnull(options, 1)  or 1<1 AND bid_status IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND item_type = 1 ORDER BY sort_seq ASC, gmt_create DESC LIMIT 1, 1;
SELECT id, gmt_create, gmt_modified, master_id, user_id , authorize_start, authorize_end, status, authorize_type, cat_id FROM master_authorize WHERE user_id = 1 LIMIT 1;
SELECT COUNT(1) FROM bid_album WHERE album_type IN (1,2,4,6,7,8,11,56,68,89,435,4523) AND creator_id = 1 AND title LIKE concat("2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00") AND status IN (1,2,4,6,7,8,11,56,68,89,435,4523);
SELECT org_id FROM top_follow_org WHERE user_id = 1 AND top_status = 1 LIMIT 1;
SELECT id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece, reject_reson, version FROM master_document WHERE id = 1 LIMIT 1;
SELECT id, item_id, cycle_id, title, auction_starts , auction_ends, auction_type, bid_status, features, options , attribute_cc, gmt_create, gmt_modified, current_price, reserve_price , next_bid, user_id, start_price, album_id, album_status , s_desc, fail_reason, cat_id, biz_cat_id, sort_seq , hour_forbid, item_tag, auction_no, item_type, master_id , master_name FROM seller_bid_extra WHERE ifnull(options, 1)  and 1=1 AND user_id = 1 AND ifnull(options, 1)  or 1<1 AND item_type = 1 ORDER BY gmt_create DESC LIMIT 1, 1;
SELECT COUNT(1) FROM seller_bid_extra WHERE user_id = 1 AND ifnull(options, 1)  and 1=1 AND item_type = 1;
INSERT INTO timeout_records (id, gmt_create, gmt_modified, biz_id, biz_type , status, action_time, try_count, failed_count, features , version) VALUES (1, now(), now(), 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, "2015-09-30 12:00:00" , 1);
INSERT INTO review_check_config (id, gmt_create, gmt_modified, name, category_id , scene, nick, status) VALUES (1, now(), now(), "2015-09-30 12:00:00", 1 , 1, "2015-09-30 12:00:00", 1);
INSERT INTO bid_auction_message (id, user_id, outer_id, type, status , scan_date, gmt_create, gmt_modified, notify_interval, forbid_flag , short_url, cycle_id, title, start, end , foregift) VALUES (1, 1, 1, 1, 1 , "2015-09-30 12:00:00", now(), now(), "2015-09-30 12:00:00", 1 , "2015-09-30 12:00:00", 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 1);
INSERT INTO bid_trade (id, order_id, source_type, pay_status, charge_status , cycle_id, item_id, buyer_id, seller_id, category_id , cat_id, amount, fee, gmt_create, gmt_modified) VALUES (1, 1, 1, 1, 1 , 1, 1, 1, 1, 1 , 1, 1, 1, now(), now());
INSERT INTO ta_treasure (id, gmt_create, gmt_modified, user_id, cat_id , record_id, pics, status, props, complete_info , longitude, latitude, position, division_id, version , distribution, submit_time, name, tel, reports , prop_ids) VALUES (1, now(), now(), 1, 1 , 1, "2015-09-30 12:00:00", 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 11, 11, "2015-09-30 12:00:00", 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, 1 , "2015-09-30 12:00:00");
INSERT INTO master_document (id, gmt_create, gmt_modified, name, title , cat_id, cat_level2_id, editor_id, status, sex , birthday, image_url, video_url, video_cover_url, describtion , year_book, awards, master_piece) VALUES (1, now(), now(), "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 1, "2015-09-30 12:00:00", 1, 1, 1 , "2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00" , "2015-09-30 12:00:00", "2015-09-30 12:00:00", "2015-09-30 12:00:00");
INSERT INTO bid_proxy (id, cycle_id, buyer_id, proxy_bid, status , gmt_create, gmt_modified) VALUES (1, 1, 1, 1, 1 , now(), now());
INSERT INTO bid_process_detail (id, gmt_create, gmt_modified, obj_id, sponsor , sponsor_id, type, name, info, name_id) VALUES (1, now(), now(), 1, "2015-09-30 12:00:00" , 1, 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00", 1);
INSERT INTO ta_record (id, gmt_create, gmt_modified, treasure_id, appraiser_id , status, submit_time, distribution, report_id, version , cat_id) VALUES (1, now(), now(), 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, 1 , 1);
INSERT INTO audit_task (id, user_id, biz_cat, settled_amount, service_amount , settle_type, user_rate, options, seller_type, task_status , reason, descs, file_url, operator, task_type , task_dealed, file_name, organization, protocol_commission, user_name , phone_number, gmt_create, gmt_modified, extra) VALUES (1, 1, "2015-09-30 12:00:00", 1, 1 , 1, 1, 1, 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, 1 , 1, 1, 1, 1, 1 , 1, now(), now(), 1);
INSERT INTO review_result_relation (id, gmt_create, gmt_modified, check_id, record_id , reason_id, ext_memo, cat_id, seller_id) VALUES (1, now(), now(), 1, 1 , 1, 1, 1, 1);
INSERT INTO bid_album_sort (id, gmt_create, gmt_modified, album_id, sort) VALUES (1, now(), now(), 1, 1);
INSERT INTO bid_seller_message (gmt_create, gmt_modified, type, title, template , action_url, user_id) VALUES (now(), now(), 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 1, 1);
INSERT INTO master_document_edit (gmt_create, gmt_modified, cat_id, name) VALUES (now(), now(), 1, "2015-09-30 12:00:00");
INSERT INTO bid_auction (id, item_id, cycle_id, buyer_id, seller_id , bid_price, bid_time, quantity, bidder_ip, status , options, biz_order_id, gmt_create, gmt_modified, memo , alias_name, bid_time_stamp, update_time_stamp) VALUES (1, 1, 1, 1, 1 , 1, now(), 1, "2015-09-30 12:00:00", 1 , 1, 1, now(), now(), 1 , 1, 1, 1);
INSERT INTO master_authorize (gmt_create, gmt_modified, master_id, user_id, authorize_start , authorize_end, status, authorize_type, cat_id) VALUES (now(), now(), 1, 1, now() , "2015-09-30 12:00:00", 1, 1, 1);
INSERT INTO bid_bidder_info (id, cycle_id, buyer_id, name, phone , address, memo, options, gmt_create, gmt_modified , cardno) VALUES (1, 1, 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 1, 1, 1, now(), now() , 1);
INSERT INTO app_user_info (id, gmt_create, gmt_modified, user_id, user_nick , remind_cnt) VALUES (1, now(), now(), 1, "2015-09-30 12:00:00" , 1);
INSERT INTO user_whitelist (id, type, ref_id, user_id, operator , gmt_create, gmt_modified) VALUES (1, 1, 1, 1, 1 , now(), now());
INSERT INTO app_remind_consume (id, gmt_create, gmt_modified, user_id, remind_type , read_cnt) VALUES (1, now(), now(), 1, 1 , 1);
INSERT INTO ta_task (gmt_create, gmt_modified, treasure_id, cat_id, status , submit_time, division_id, version, rand) VALUES (now(), now(), 1, 1, 1 , "2015-09-30 12:00:00", 1, 1, 1);
INSERT INTO seller_reward (user_id, user_nick, owner, group_id, type , status, effective_start, effective_end, num, memo , gmt_create, gmt_modified) VALUES (1, "2015-09-30 12:00:00", "2015-09-30 12:00:00", 1, 1 , 1, "2015-09-30 12:00:00", "2015-09-30 12:00:00", 1, "2015-09-30 12:00:00" , now(), now());
INSERT INTO settler_user_foregift (id, user_id, operate_type, status, amount , type, memo, target_id, cycle_id, gmt_create , gmt_modified) VALUES (1, 1, 1, 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, now() , now());
INSERT INTO seller_apply_info (user_id, album_id, group_id, day_plan_id, status , type, category_id, use_day, gmt_create, gmt_modified , month_plan_id) VALUES (1, 1, 1, 1, 1 , 1, 1, "2015-09-30 12:00:00", now(), now() , 1);
INSERT INTO review_reason_config (id, gmt_create, gmt_modified, reason, nick , check_id, status) VALUES (1, now(), now(), "2015-09-30 12:00:00", "2015-09-30 12:00:00" , 1, 1);
INSERT INTO tbp_message (id, gmt_create, gmt_modified, venue_id, album_id , item_id, message, message_time_stamp, message_type, message_params) VALUES (1, now(), now(), 1, 1 , 1, "2015-09-30 12:00:00", 1, 1, "2015-09-30 12:00:00");
INSERT INTO top_follow_org (id, gmt_create, gmt_modified, user_id, org_id , top_status) VALUES (1, now(), now(), 1, 1 , 1);
INSERT INTO settler_cat (id, user_id, cat_id, level, target_id , settled_amount, status, gmt_create, gmt_modified) VALUES (1, 1, 1, 1, 1 , 1, 1, now(), now());
INSERT INTO cat_day_plan (week_day, group_id, month_plan_id, type, divide_album_num , divide_name, divide_start_time, continue_time, gmt_create, gmt_modified) VALUES (1, 1, 1, 1, 1 , "2015-09-30 12:00:00", "2015-09-30 12:00:00", 1, now(), now());
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", album_id = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), title = "2015-09-30 12:00:00", status = 1, property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = 1, gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = 1, desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_album SET gmt_modified = now(), status = 1 WHERE id = 1;
UPDATE bid_auction_message SET scan_date = str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00"), gmt_modified = now(), forbid_flag = 1 WHERE id = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, review_status = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE settler_cat SET status = 1, gmt_modified = now() WHERE user_id = 1 AND target_id = 1;
UPDATE bid_album SET gmt_modified = now(), start_time = "2015-09-30 12:00:00", end_time = "2015-09-30 12:00:00" WHERE album_id = 1;
UPDATE bid_extra SET bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, review_status = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE master_document_edit SET editor_id = 1, gmt_modified = now() WHERE id = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, review_status = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = 1, gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = "2015-09-30 12:00:00", starts = 1, desc_path = "2015-09-30 12:00:00", delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_album SET gmt_modified = now(), apply_cnt = ifnull(apply_cnt, 1) + 1 WHERE album_id = 1;
UPDATE bid_foregifts SET gmt_modified = now(), status = 1, operator = "2015-09-30 12:00:00" WHERE foregift_id = 1 AND status = 1 AND type = 1;
UPDATE cat_day_plan SET gmt_modified = now(), divide_album_num = 1, divide_name = "2015-09-30 12:00:00", divide_start_time = "2015-09-30 12:00:00", continue_time = 1 WHERE id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE album_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE album_id = 1 AND item_id = 1;
UPDATE bid_album SET gmt_modified = now(), audit_date = now(), approve_admin = "2015-09-30 12:00:00", options = 1, property = "2015-09-30 12:00:00" WHERE album_id = 1;
UPDATE album_bid_extra SET album_status = 1, gmt_modified = now(), fail_reason = "2015-09-30 12:00:00", bid_status = 1, options = options  WHERE album_id = 1 AND bid_status = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = 1, category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = "2015-09-30 12:00:00", gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = "2015-09-30 12:00:00", desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_auction_message SET status = 1, gmt_modified = now() WHERE outer_id = 1;
UPDATE seller_bid_extra SET auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET album_status = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE bid_extra SET review_status = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = 1, desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE timeout_records SET gmt_modified = now(), status = 1, version = version + 1 WHERE biz_id = 1 AND biz_type = 1 AND version = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_proxy SET gmt_modified = now(), buyer_id = 1, proxy_bid = 1, status = 1 WHERE cycle_id = 1;
UPDATE cycle_bid_foregifts SET options = 1, gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE audit_task SET file_url = "2015-09-30 12:00:00", task_status = 1, operator = 1, task_dealed = 1, file_url = "2015-09-30 12:00:00", file_name = "2015-09-30 12:00:00", reason = "2015-09-30 12:00:00", organization = "2015-09-30 12:00:00", settled_amount = 1, service_amount = 1, biz_cat = "2015-09-30 12:00:00", user_name = "2015-09-30 12:00:00", phone_number = "2015-09-30 12:00:00", gmt_modified = now() WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), banner_path = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE cycle_bid_foregifts SET action_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE album_bid_extra SET album_status = 1, gmt_modified = now(), bid_status = 1, review_status = 1, options = options  WHERE album_id = 1 AND bid_status = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE cycle_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE cycle_bid_foregifts SET gmt_modified = now(), status = 1, operator = "2015-09-30 12:00:00" WHERE cycle_id = 1 AND foregift_id = 1 AND status = 1 AND type = 1;
UPDATE cat_month_plan SET gmt_modified = now(), seller_album_num = 1, audit_cycle = 1, pre_cycle_min = 1, enroll_cycle = 1, start_date = "2015-09-30 12:00:00", end_date = "2015-09-30 12:00:00", last_date = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_settler SET gmt_modified = now(), contact = "2015-09-30 12:00:00", contact_number = "2015-09-30 12:00:00", organization_desc = "2015-09-30 12:00:00", location_id = 1 WHERE user_id = 1;
UPDATE bid_album SET gmt_modified = now(), status = 1, end_time = "2015-09-30 12:00:00" WHERE album_id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), audit_date = "2015-09-30 12:00:00", approve_admin = "2015-09-30 12:00:00", options = 1, status = 1, fail_reason = "2015-09-30 12:00:00" WHERE album_id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = "2015-09-30 12:00:00", gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = "2015-09-30 12:00:00", desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET bid_status = 1, auction_starts = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_settle_cat SET stop_status = 1, gmt_modified = now() WHERE status = 1 AND id = 1;
UPDATE bid_album SET gmt_modified = now(), banner_path = "2015-09-30 12:00:00", info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET album_status = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE timeout_records SET gmt_modified = now(), status = 1, version = version + 1 WHERE biz_id = 1 AND biz_type = 1;
UPDATE buyer_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE audit_task SET file_url = 1, task_status = 1, operator = 1, task_dealed = 1, reason = "2015-09-30 12:00:00", settled_amount = 1, service_amount = 1, biz_cat = "2015-09-30 12:00:00", gmt_modified = now() WHERE id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET bid_status = 1, current_price = 1, next_bid = 1, album_status = 1, auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_trade SET pay_status = 1, charge_status = 1, gmt_modified = now() WHERE order_id = 1;
UPDATE bid_album SET gmt_modified = now(), status = 1, property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE buyer_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE timeout_records SET gmt_modified = now(), try_count = try_count + 1, version = version + 1 WHERE biz_id = 1 AND biz_type = 1 AND version = 1;
UPDATE bid_album SET gmt_modified = now(), info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_album SET gmt_modified = now(), title = "2015-09-30 12:00:00", banner_path = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE foregift_id = 1;
UPDATE bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE foregift_id = 1;
UPDATE master_document_edit SET gmt_modified = now(), title = "2015-09-30 12:00:00", status = 1, cat_id = 1, cat_level2_id = "2015-09-30 12:00:00", sex = 1, birthday = "2015-09-30 12:00:00", image_url = "2015-09-30 12:00:00", describtion = "2015-09-30 12:00:00", video_url = "2015-09-30 12:00:00", video_cover_url = "2015-09-30 12:00:00", year_book = "2015-09-30 12:00:00", awards = "2015-09-30 12:00:00", master_piece = "2015-09-30 12:00:00", reject_reson = "2015-09-30 12:00:00", version = version + 1 WHERE id = 1 AND version = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), banner_path = "2015-09-30 12:00:00", status = 1, property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_venue SET gmt_modified = now(), attribute_cc = attribute_cc + 1, status = 1, end_time = "2015-09-30 12:00:00" WHERE id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET options = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE ta_treasure SET gmt_modified = now(), status = 1, version = version + 1, distribution = 1, record_id = 1 WHERE id = 1 AND version = 1;
UPDATE bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET bid_status = 1, auction_ends = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1;
UPDATE bid_extra SET bid_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_settler SET settled_amount = 1, settled_actual_amount = 1, service_amount = 1, service_actual_amount = 1, settle_type = 1, user_rate = 1, settle_status = 1, tasking = 1, gmt_modified = now() WHERE id = 1;
UPDATE bid_album SET gmt_modified = now(), bid_cnt = ifnull(bid_cnt, 1) + 1 WHERE album_id = 1;
UPDATE bid_foregifts SET options = 1, gmt_modified = now() WHERE foregift_id = 1;
UPDATE bid_extra SET sort_seq = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE cc_seller_record SET status = 1, gmt_modified = now() WHERE id = 1;
UPDATE bid_auction_message SET status = 1, scan_date = str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00"), notify_interval = "2015-09-30 12:00:00", gmt_modified = now() WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", unfreeze_amont = 1, gmt_modified = now() WHERE foregift_id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", notify_interval = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_auction_message SET scan_date = str_to_date("2015-09-30 12:00:00", "2015-09-30 12:00:00"), gmt_modified = now() WHERE id = 1;
UPDATE buyer_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", transform_amont = 1, gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE bid_extra SET bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", album_id = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE review_check_config SET gmt_modified = now(), status = 1 WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), banner_path = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_foregifts SET action_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE foregift_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE audit_task SET file_url = "2015-09-30 12:00:00", task_status = 1, operator = 1, task_dealed = 1, file_url = "2015-09-30 12:00:00", file_name = "2015-09-30 12:00:00", organization = "2015-09-30 12:00:00", settled_amount = 1, service_amount = 1, biz_cat = "2015-09-30 12:00:00", user_name = "2015-09-30 12:00:00", phone_number = "2015-09-30 12:00:00", gmt_modified = now() WHERE id = 1;
UPDATE pmp_auctions_extra SET attribute = "2015-09-30 12:00:00" WHERE auction_id = 1;
UPDATE bid_album SET gmt_modified = now(), end_time = "2015-09-30 12:00:00", status = 1 WHERE album_id = 1;
UPDATE bid_album SET gmt_modified = now(), tiny_desc = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_auction_message SET status = 1, gmt_modified = now() WHERE type = 1 AND user_id = 1 AND outer_id = 1 AND status != 1;
UPDATE seller_bid_extra SET album_id = 1, album_status = 1, options = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_album SET gmt_modified = now(), options = 1, status = 1 WHERE album_id = 1;
UPDATE bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE timeout_records SET gmt_modified = now(), failed_count = failed_count + 1, version = version + 1 WHERE biz_id = 1 AND biz_type = 1;
UPDATE bid_album SET gmt_modified = now(), status = 1, apply_date = now(), audit_max_date = "2015-09-30 12:00:00", audit_date = "2015-09-30 12:00:00", start_time = "2015-09-30 12:00:00", end_time = "2015-09-30 12:00:00", options = 1 WHERE album_id = 1;
UPDATE bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", transform_amont = 1, gmt_modified = now() WHERE foregift_id = 1;
UPDATE bid_extra SET bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, review_status = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE buyer_bid_foregifts SET options = 1, gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE cycle_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE bid_album SET gmt_modified = now(), fail_reason = "2015-09-30 12:00:00", options = 1, status = 1 WHERE album_id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = 1, gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = 1, desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", options = 1, address_id = 1, features = "2015-09-30 12:00:00", pre_auth_id = 1, transform_amont = 1, unfreeze_amont = 1, gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE bid_album SET gmt_modified = now(), banner_path = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_extra SET auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE buyer_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", options = 1, address_id = 1, features = "2015-09-30 12:00:00", pre_auth_id = 1, transform_amont = 1, unfreeze_amont = 1, gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE cycle_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", unfreeze_amont = 1, gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, current_price = 1, next_bid = 1, album_status = 1, auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET album_id = 1, album_status = 1, options = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE user_ta_treasure SET gmt_modified = now(), status = 1, version = version + 1, distribution = 1, record_id = 1 WHERE id = 1 AND user_id = 1;
UPDATE bid_settler SET settled_amount = 1, settled_actual_amount = 1, service_amount = 1, service_actual_amount = 1, settle_type = 1, user_rate = 1, settle_status = 1, tasking = 1, gmt_modified = now() WHERE id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = "2015-09-30 12:00:00", gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = "2015-09-30 12:00:00", desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE buyer_bid_foregifts SET action_time = "2015-09-30 12:00:00", gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE bid_album SET gmt_modified = now(), title = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE pmp_auctions_extra SET delay_times = 1, delay_secends = 1, gmt_modified = now() WHERE auction_id = 1;
UPDATE cycle_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", transform_amont = 1, gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE bid_album SET gmt_modified = now(), audit_date = now(), approve_admin = "2015-09-30 12:00:00", options = 1 WHERE album_id = 1;
UPDATE bid_extra SET bid_status = 1, gmt_modified = now() WHERE item_id = 1;
UPDATE settler_user_foregift SET status = 1, gmt_modified = now() WHERE id = 1;
UPDATE seller_apply_info SET gmt_modified = now(), status = 1 WHERE id = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", email = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET bid_status = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE app_user_info SET remind_cnt = remind_cnt + 1, gmt_modified = now() WHERE user_id = 1;
UPDATE bid_album SET gmt_modified = now(), audit_date = "2015-09-30 12:00:00", approve_admin = "2015-09-30 12:00:00", options = 1, status = 1 WHERE album_id = 1;
UPDATE bid_album SET gmt_modified = now(), status = 1, apply_date = now(), audit_max_date = "2015-09-30 12:00:00" WHERE album_id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE ta_task SET gmt_modified = now(), status = 1, version = version + 1 WHERE id = 1 AND status = 1 AND version = 1;
UPDATE seller_bid_extra SET options = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_album SET gmt_modified = now(), deal_cnt = ifnull(deal_cnt, 1) + 1, deal_amount = ifnull(deal_amount, 1) + 1 WHERE album_id = 1;
UPDATE cycle_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", options = 1, address_id = 1, features = "2015-09-30 12:00:00", pre_auth_id = 1, transform_amont = 1, unfreeze_amont = 1, gmt_modified = now() WHERE cycle_id = 1 AND foregift_id = 1;
UPDATE album_bid_extra SET album_status = 1, gmt_modified = now(), options = options  WHERE album_id = 1 AND bid_status = 1;
UPDATE seller_bid_extra SET sort_seq = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE top_follow_org SET gmt_modified = now(), top_status = 1 WHERE user_id = 1 AND org_id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET bid_status = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = "2015-09-30 12:00:00", category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = "2015-09-30 12:00:00", starts = 1, desc_path = "2015-09-30 12:00:00", delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_album SET gmt_modified = now(), title = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE buyer_bid_foregifts SET gmt_modified = now(), status = 1, operator = "2015-09-30 12:00:00" WHERE buyer_id = 1 AND foregift_id = 1 AND status = 1 AND type = 1;
UPDATE bid_album SET gmt_modified = now(), audit_date = "2015-09-30 12:00:00", approve_admin = "2015-09-30 12:00:00", options = 1, property = "2015-09-30 12:00:00", status = 1 WHERE album_id = 1;
UPDATE bid_album SET gmt_modified = now(), property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, notify_interval = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_venue SET gmt_modified = now(), attribute_cc = attribute_cc + 1, current_zhibo = "2015-09-30 12:00:00" WHERE id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_id = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = 1, category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = 1, gmt_create = 1, gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = 1, desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_album SET gmt_modified = now(), title = "2015-09-30 12:00:00", banner_path = "2015-09-30 12:00:00", tiny_desc = "2015-09-30 12:00:00", info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE settler_user_foregift SET target_id = 1, gmt_modified = now() WHERE id = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, attribute_cc = 1 + 1, master_id = 1, master_name = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE seller_bid_extra SET features = "2015-09-30 12:00:00", bid_status = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE ta_push_task SET status = 1, gmt_modified = now() WHERE id = 1;
UPDATE seller_bid_extra SET bid_status = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE master_document_edit SET gmt_modified = now(), title = "2015-09-30 12:00:00", status = 1, cat_id = 1, cat_level2_id = "2015-09-30 12:00:00", sex = 1, birthday = "2015-09-30 12:00:00", image_url = "2015-09-30 12:00:00", describtion = "2015-09-30 12:00:00", video_url = "2015-09-30 12:00:00", video_cover_url = "2015-09-30 12:00:00", year_book = "2015-09-30 12:00:00", awards = "2015-09-30 12:00:00", master_piece = "2015-09-30 12:00:00", reject_reson = 1, version = version + 1 WHERE id = 1 AND version = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", update_phone = "2015-09-30 12:00:00", expire_time = "2015-09-30 12:00:00", check_code = 1, notify_type = "2015-09-30 12:00:00", mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE seller_bid_extra SET review_status = 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_auction SET transform_order_id = 1, gmt_modified = now() WHERE buyer_id = 1 AND cycle_id = 1 AND (biz_order_id IS NOT NULL AND biz_order_id > 1);
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET bid_status = 1, auction_starts = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_no = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, master_id = 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), tiny_desc = "2015-09-30 12:00:00", info = "2015-09-30 12:00:00", property = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE bid_auction SET biz_order_id = 1, status = 1, gmt_modified = now() WHERE id = 1 AND cycle_id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), status = 1 WHERE album_id = 1;
UPDATE pmp_auctions_extra SET title = "2015-09-30 12:00:00", minimum_bid = 1, incrementnum = 1, pict_url = 1, category = 1, city = "2015-09-30 12:00:00", quantity = 1, user_id = 1, user_nick = "2015-09-30 12:00:00", auction_status = 1, auction_from = "2015-09-30 12:00:00", auction_type = "2015-09-30 12:00:00", ends = "2015-09-30 12:00:00", gmt_create = "2015-09-30 12:00:00", gmt_modified = now(), property = "2015-09-30 12:00:00", currentprice = 1, totalcnt = 1, auctionscore = 1, attribute = 1, starts = "2015-09-30 12:00:00", desc_path = 1, delay_times = 1, delay_secends = 1, buyer_qualification = 1, type = 1 WHERE auction_id = "2015-09-30 12:00:00";
UPDATE bid_bidder_info SET gmt_modified = now(), name = "2015-09-30 12:00:00", phone = "2015-09-30 12:00:00" WHERE cycle_id = 1;
UPDATE bid_extra SET features = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, auction_ends = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, album_status = 1, options = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_user_extra SET gmt_modified = now(), mobile_phone = "2015-09-30 12:00:00", notify_type = "2015-09-30 12:00:00", flag = 1, mail_sub_items = "2015-09-30 12:00:00", nick = "2015-09-30 12:00:00" WHERE id = 1;
UPDATE buyer_bid_foregifts SET type = 1, status = 1, operator = "2015-09-30 12:00:00", error_code = "2015-09-30 12:00:00", operate_time = "2015-09-30 12:00:00", unfreeze_amont = 1, gmt_modified = now() WHERE buyer_id = 1 AND foregift_id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, auction_no = "2015-09-30 12:00:00", biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, options = 1, sort_seq = 1, attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1 AND attribute_cc = 1;
UPDATE bid_album SET gmt_modified = now(), active_link = 1, mobile_active_link = 1 WHERE album_id = 1;
UPDATE seller_bid_extra SET bid_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_album SET gmt_modified = now(), start_time = "2015-09-30 12:00:00", end_time = "2015-09-30 12:00:00", options = 1, status = 1 WHERE album_id = 1;
UPDATE seller_bid_extra SET title = "2015-09-30 12:00:00", cycle_id = 1, features = "2015-09-30 12:00:00", bid_status = 1, current_price = 1, reserve_price = 1, next_bid = 1, auction_type = "2015-09-30 12:00:00", cat_id = 1, biz_cat_id = 1, start_price = 1, hour_forbid = 1, album_id = 1, album_status = 1, auction_starts = "2015-09-30 12:00:00", auction_ends = "2015-09-30 12:00:00", options = 1, sort_seq = 1, fail_reason = "2015-09-30 12:00:00", attribute_cc = 1 + 1, gmt_modified = now() WHERE item_id = 1 AND user_id = 1;
UPDATE bid_album SET gmt_modified = now(), bidder_cnt = ifnull(bidder_cnt, 1) + 1 WHERE album_id = 1;
UPDATE bid_extra SET bid_status = 1, options = 1, fail_reason = "2015-09-30 12:00:00", gmt_modified = now() WHERE item_id = 1;
DELETE FROM album_bid_extra WHERE item_id = 1;
DELETE FROM user_whitelist WHERE id = 1;