[2025-08-13 07:34:47.103] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 07:34:49.937] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 07:39:04.399] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3103809%' or phone like '%3103809%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 08:12:51.845] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3100638%' or phone like '%3100638%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 08:46:49.458] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3105550%' or phone like '%3105550%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 08:50:42.376] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96505050%' or phone like '%96505050%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 08:56:23.816] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%irened100%' or phone like '%irened100%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 09:14:55.232] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 09:15:07.284] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%98002139%' or phone like '%98002139%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 09:32:08.022] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%94253228%' or phone like '%94253228%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 09:33:22.918] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96505050%' or phone like '%96505050%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 10:11:12.664] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 10:23:25.492] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 10:23:56.748] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( a.status_id=11 )and a.create_time>='2025-08-12' and a.create_time <='2025-08-13' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 10:24:01.290] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( a.status_id=11 )and a.create_time>='2025-08-12' and a.create_time <='2025-08-13' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 2147483647; [2025-08-13 10:29:04.354] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92888287%' or phone like '%92888287%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 10:35:24.807] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92285987%' or phone like '%92285987%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:07:15.233] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:07:35.258] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:07:43.612] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:42.416] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:42.804] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:43.330] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:43.857] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:44.587] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:45.189] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:45.579] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:46.307] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:46.895] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:47.625] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:47.965] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:08:59.767] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:09:05.222] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( a.source='Pos' ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:10:08.703] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%johnmychan%' or phone like '%johnmychan%') and ( a.source='Pos' ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:10:40.852] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:10:58.081] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:10:58.733] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:11:00.547] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:11:04.993] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:30:07.073] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:34:56.052] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%90977174%' or phone like '%90977174%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:41:45.763] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96504688%' or phone like '%96504688%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:50:08.592] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:50:10.940] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:54:50.727] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:00.054] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( a.status_id=11 ) and ( a.product_id=7842 ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:04.034] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:12.761] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:13.397] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:14.450] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:19.029] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:19.707] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:20.300] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:20.858] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:21.557] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:27.012] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:55:48.127] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%johnmychan%' or phone like '%johnmychan%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:10.461] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:12.459] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:19.160] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:19.890] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:20.276] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:20.881] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:21.533] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:22.817] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:56:28.545] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:01.956] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:02.452] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:07.102] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:07.648] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:08.801] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:57:12.758] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:59:01.861] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:59:07.635] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 11:59:08.485] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 12:00:51.615] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 25, 25; [2025-08-13 12:00:58.782] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 50, 25; [2025-08-13 12:01:02.837] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 75, 25; [2025-08-13 12:01:32.543] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3102505%' or phone like '%3102505%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 12:02:10.441] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( a.source='Pos' ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 12:02:29.706] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 12:04:21.262] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%69988459%' or phone like '%69988459%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 12:05:03.649] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3100638%' or phone like '%3100638%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 13:15:54.914] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 13:16:05.008] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%97228182%' or phone like '%97228182%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 13:16:06.881] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%97228182%' or phone like '%97228182%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 13:29:12.727] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%9320 981%' or phone like '%9320 981%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:29:16.194] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93202981%' or phone like '%93202981%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:31:29.740] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:32:25.536] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:37:59.396] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3102134%' or phone like '%3102134%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:44:23.735] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:47:12.449] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 13:48:40.877] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 14:00:43.196] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 14:17:05.557] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92782599%' or phone like '%92782599%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:19:52.116] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:20:29.054] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:20:29.764] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:20:47.877] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:20:48.279] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:20:52.751] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 14:27:51.243] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:05:49.929] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 15:06:06.544] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%97232855%' or phone like '%97232855%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 15:32:26.684] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%chenjiko319@yahoo.com.hk%' or phone like '%chenjiko319@yahoo.com.hk%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:32:50.925] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93617421%' or phone like '%93617421%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 15:39:17.478] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92362366%' or phone like '%92362366%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 15:48:22.956] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:57:08.610] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:57:36.770] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and (a.transactionID like '%cp3-250800082%' or a.order_no like '%cp3-250800082%' ) order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:58:21.891] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100; [2025-08-13 15:58:28.803] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96505050%' or phone like '%96505050%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 16:09:24.868] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%61239855%' or phone like '%61239855%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:17:13.239] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:17:20.426] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%61239855%' or phone like '%61239855%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:17:31.391] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3100243%' or phone like '%3100243%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:18:48.530] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%60849360%' or phone like '%60849360%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 16:29:01.392] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93209961%' or phone like '%93209961%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:29:20.630] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%bess22342@yahoo.com.hk%' or phone like '%bess22342@yahoo.com.hk%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 16:39:48.831] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92322274%' or phone like '%92322274%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:40:22.692] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92154723%' or phone like '%92154723%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:41:44.043] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%98002139%' or phone like '%98002139%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:42:22.954] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%61519571%' or phone like '%61519571%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:43:37.733] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%68057957%' or phone like '%68057957%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:44:17.039] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%52257668%' or phone like '%52257668%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:45:22.052] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92176860%' or phone like '%92176860%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:46:13.282] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93407888%' or phone like '%93407888%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:47:01.772] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%90189677%' or phone like '%90189677%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:47:46.701] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96898202%' or phone like '%96898202%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:48:47.405] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92316829%' or phone like '%92316829%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:49:26.668] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%9835660%' or phone like '%9835660%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:51:45.546] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%92329494%' or phone like '%92329494%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 16:52:25.930] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%91858030%' or phone like '%91858030%') order by a.create_time desc LIMIT 0, 25; [2025-08-13 17:02:59.111] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%909339183%' or phone like '%909339183%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:03:11.834] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3100095%' or phone like '%3100095%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:05:02.215] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3105719%' or phone like '%3105719%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:06:24.434] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3107559%' or phone like '%3107559%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:07:17.442] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%98356601%' or phone like '%98356601%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:07:53.964] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%61332133%' or phone like '%61332133%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:08:49.835] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%65777245%' or phone like '%65777245%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:09:25.699] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%90175073%' or phone like '%90175073%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:10:07.949] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%61080072%' or phone like '%61080072%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:11:06.102] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96396341%' or phone like '%96396341%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:11:33.428] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93617421%' or phone like '%93617421%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:13:00.508] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and (a.transactionID like '%cp3-250800082%' or a.order_no like '%cp3-250800082%' ) order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:13:18.959] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%96505050%' or phone like '%96505050%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:14:40.222] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2025-08-13 17:15:26.021] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and (a.transactionID like '%250800082%' or a.order_no like '%250800082%' ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 17:16:19.310] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and (a.transactionID like '%250800087%' or a.order_no like '%250800087%' ) order by a.create_time desc LIMIT 0, 25; [2025-08-13 17:36:09.011] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%62910138%' or phone like '%62910138%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:39:20.610] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%310371%' or phone like '%310371%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:39:30.354] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%3106371%' or phone like '%3106371%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:50:44.541] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 and a.user_id in (select id from user where user_login like '%93398142%' or phone like '%93398142%') order by a.create_time desc LIMIT 0, 100; [2025-08-13 17:52:58.888] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 100;