[2025-08-27 07:22:44.984] 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-27 07:22:47.523] 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-27 09:18:15.745] 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-27 09:18:25.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 and a.user_id in (select id from user where user_login like '%92689283%' or phone like '%92689283%') order by a.create_time desc LIMIT 0, 25; [2025-08-27 09:29:43.506] 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 '%90505058%' or phone like '%90505058%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:30:48.120] 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 '%60996070%' or phone like '%60996070%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:31:48.456] 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 '%92310184%' or phone like '%92310184%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:32:56.429] 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 '%51638869%' or phone like '%51638869%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:33:49.705] 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 '%daisyp%' or phone like '%daisyp%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:34:43.205] 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 '%64945677%' or phone like '%64945677%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:35:38.324] 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 '%canmato%' or phone like '%canmato%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:36:42.349] 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 '%55470153%' or phone like '%55470153%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:37:41.973] 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 '%92334330%' or phone like '%92334330%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:38:39.776] 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 '%66113236%' or phone like '%66113236%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:39:44.167] 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 '%98305945%' or phone like '%98305945%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:40:19.163] 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 '%htsui000%' or phone like '%htsui000%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:40:59.565] 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 '%61308177%' or phone like '%61308177%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:46:36.620] 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 '%90821001%' or phone like '%90821001%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 09:52:25.259] 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-27 09:52:33.939] 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 '%92689283%' or phone like '%92689283%') order by a.create_time desc LIMIT 0, 25; [2025-08-27 09:53:06.423] 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 '%90654709%' or phone like '%90654709%') order by a.create_time desc LIMIT 0, 25; [2025-08-27 09:53:45.246] 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 '%96823248%' or phone like '%96823248%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:12:19.329] 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 '%94788860%' or phone like '%94788860%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:15:30.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 order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:15:52.451] 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-27 10:16:06.372] 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=8542 ) order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:16:13.486] 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=8532 ) order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:16:22.404] 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=8522 ) order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:16:33.841] 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=8692 ) order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:23:29.686] 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-27 10:25:10.591] 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-27 10:27:23.569] 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-27 10:28:19.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 and ( a.status_id=11 )and a.create_time>='2025-08-26' and a.create_time <='2025-08-27' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2025-08-27 10:28:24.497] 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-26' and a.create_time <='2025-08-27' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 2147483647; [2025-08-27 10:28:48.675] 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 '%69669688%' or phone like '%69669688%') order by a.create_time desc LIMIT 0, 25; [2025-08-27 10:46:11.759] 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 '%olp701014%' or phone like '%olp701014%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 10:59:50.238] 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-27 10:59:58.695] 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-27 11:00:12.750] 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-27 11:00:18.603] 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-27 11:00:33.341] 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-27 11:00:41.967] 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-27 11:00:45.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 order by a.create_time desc LIMIT 0, 25; [2025-08-27 11:25:42.742] 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-27 11:37:23.760] 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 '%10169%' or phone like '%10169%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 11:39:08.691] 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 '%92107829%' or phone like '%92107829%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 11:47:26.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 order by a.create_time desc LIMIT 0, 100; [2025-08-27 12:12:21.092] 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 '%60426779%' or phone like '%60426779%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 12:20:28.787] 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 '%92265762%' or phone like '%92265762%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 12:28:21.500] 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 '%10169%' or phone like '%10169%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 12:33:58.066] 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 '%keychow%' or phone like '%keychow%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 12:49:50.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 '%60426779%' or phone like '%60426779%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 13:17:14.224] 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 '%67493481%' or phone like '%67493481%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 13:23:39.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-27 13:39:09.436] 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 '%lamhangmei%' or phone like '%lamhangmei%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 13:40:54.337] 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 '%9662 021%' or phone like '%9662 021%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 13:40:57.453] 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 '%96628021%' or phone like '%96628021%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 13:56:52.522] 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 '%3107060%' or phone like '%3107060%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 14:57:28.439] 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-27 15:21:43.420] 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 '%9806\6990%' or phone like '%9806\6990%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:21:46.903] 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 '%98066990%' or phone like '%98066990%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:23:10.844] 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 '%69669688%' or phone like '%69669688%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:29:57.479] 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 '%97591965%' or phone like '%97591965%') order by a.create_time desc LIMIT 0, 25; [2025-08-27 15:31:35.611] 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 '%3104208%' or phone like '%3104208%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:32:33.977] 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 '%62902527%' or phone like '%62902527%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:37:06.242] 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 '%93591640%' or phone like '%93591640%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:57:18.335] 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-27 15:57:26.387] 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 '%98313157%' or phone like '%98313157%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 15:59:40.144] 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 '%3104581%' or phone like '%3104581%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 16:00:12.792] 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 '%yu336699%' or phone like '%yu336699%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 16:18:02.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 and a.user_id in (select id from user where user_login like '%91363436%' or phone like '%91363436%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 16:18:53.424] 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 '%62283636%' or phone like '%62283636%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 16:46:41.371] 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 '%joey8222%' or phone like '%joey8222%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 16:49:39.951] 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 '%wong2020%' or phone like '%wong2020%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 17:02:36.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 '%elsa520%' or phone like '%elsa520%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 17:47:51.601] 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 '%92802187%' or phone like '%92802187%') order by a.create_time desc LIMIT 0, 100; [2025-08-27 17:49:20.408] 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 '%56468672%' or phone like '%56468672%') order by a.create_time desc LIMIT 0, 100;