[2024-10-23 08:04:58.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 order by a.create_time desc LIMIT 0, 25; [2024-10-23 08:31:04.690] 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; [2024-10-23 08:31:14.690] 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.source is null || a.source = '') ) and ( a.product_id=7852 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 08:31:32.815] 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.source is null || a.source = '') ) and ( a.product_id=7902 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 08:31: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; [2024-10-23 08:31:43.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 order by a.create_time desc LIMIT 0, 25; [2024-10-23 08:31:47.065] 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; [2024-10-23 09:09:46.161] 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; [2024-10-23 09:09:51.146] 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 '%54452862%' or phone like '%54452862%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:11:10.281] 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 '%96266909%' or phone like '%96266909%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:18:07.843] 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; [2024-10-23 09:28:35.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 '%3105708%' or phone like '%3105708%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:30:15.056] 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 '%3107829%' or phone like '%3107829%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:31:38.314] 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 '%3105634%' or phone like '%3105634%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:33:06.228] 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; [2024-10-23 09:33:18.181] 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 '%90344300%' or phone like '%90344300%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:33:36.494] 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 '%66871799%' or phone like '%66871799%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:35:05.651] 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 '%3101559%' or phone like '%3101559%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:37:24.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 and a.user_id in (select id from user where user_login like '%92793848%' or phone like '%92793848%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:37:33.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 '%92193848%' or phone like '%92193848%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:39:07.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 and a.user_id in (select id from user where user_login like '%62362991%' or phone like '%62362991%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:40:47.909] 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 '%31046564%' or phone like '%31046564%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:40:51.346] 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 '%3104654%' or phone like '%3104654%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:42:04.223] 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 '%92507186%' or phone like '%92507186%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:43:10.114] 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 '%9803911%' or phone like '%9803911%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:43:16.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 '%98803911%' or phone like '%98803911%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:45:37.594] 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 '%91312789%' or phone like '%91312789%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:45:41.172] 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 '%91312787%' or phone like '%91312787%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:51:45.915] 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 '%3105459%' or phone like '%3105459%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:53:42.609] 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 '%93281941%' or phone like '%93281941%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:55:31.175] 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 '%64465600%' or phone like '%64465600%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:56:54.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.user_id in (select id from user where user_login like '%93563039%' or phone like '%93563039%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:58:31.053] 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 '%97581008%' or phone like '%97581008%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 09:59:52.778] 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 '%3112413%' or phone like '%3112413%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:09:12.326] 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 '%98619895%' or phone like '%98619895%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:12:00.730] 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; [2024-10-23 10:12:18.105] 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=7852 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:13:00.936] 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; [2024-10-23 10:13:19.014] 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=7902 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:13:22.577] 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; [2024-10-23 10:13:28.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 and ( a.product_id=7902 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:13:32.342] 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; [2024-10-23 10:17:20.725] 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; [2024-10-23 10:17:47.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.status_id=11 )and a.create_time>='2024-10-22' and a.create_time <='2024-10-23' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:17:51.509] 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>='2024-10-22' and a.create_time <='2024-10-23' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 2147483647; [2024-10-23 10:35:34.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; [2024-10-23 10:37:32.183] 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; [2024-10-23 10:52:27.746] 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; [2024-10-23 10:54:33.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.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 10:56:46.926] 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; [2024-10-23 11:30:40.800] 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 '%56965555%' or phone like '%56965555%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 11:40:22.251] 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; [2024-10-23 11:40:31.673] 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; [2024-10-23 11:41:12.112] 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; [2024-10-23 12:37:36.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; [2024-10-23 12:37:37.589] 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; [2024-10-23 12:37:47.917] 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; [2024-10-23 12:37:59.339] 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; [2024-10-23 14:00:36.369] 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; [2024-10-23 14:29:51.798] 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 '%94262893%' or phone like '%94262893%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 14:32:53.870] 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 '%92206276%' or phone like '%92206276%') order by a.create_time desc LIMIT 0, 25; [2024-10-23 14:45:59.007] 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; [2024-10-23 14:46:08.632] 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=7902 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 14:46:25.304] 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=7852 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 14:46:33.100] 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; [2024-10-23 15:16:51.791] 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; [2024-10-23 15:17:15.378] 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; [2024-10-23 15:17:19.986] 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; [2024-10-23 15:17:30.644] 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.source is null || a.source = '') ) and ( a.product_id=7902 ) order by a.create_time desc LIMIT 0, 25; [2024-10-23 15:17:32.628] 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; [2024-10-23 15:17:42.917] 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; [2024-10-23 15:17:54.855] 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; [2024-10-23 15:18:01.496] 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; [2024-10-23 15:18:08.621] 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; [2024-10-23 16:19:11.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 order by a.create_time desc LIMIT 0, 25; [2024-10-23 16:26:48.718] 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; [2024-10-23 16:26:53.875] 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; [2024-10-23 16:46:06.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;