[2024-12-18 08:10:37.505] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 08:10:42.943] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 09:41:49.283] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 09:47:12.605] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3100525%' or phone like '%3100525%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:48:09.285] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%98741029%' or phone like '%98741029%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:49:02.380] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90258200%' or phone like '%90258200%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 09:50:55.582] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3106811%' or phone like '%3106811%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:53:17.562] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94053888%' or phone like '%94053888%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:53:53.377] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3103006%' or phone like '%3103006%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 09:55:35.520] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 09:55:44.026] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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.payment_type_id=1 ) and ( a.status_id=11 ) and ( a.product_id=7842 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:55:48.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.payment_type_id=1 ) and ( a.status_id=11 ) and ( a.product_id=7852 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:55:53.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.payment_type_id=1 ) and ( a.status_id=11 ) and ( a.product_id=7902 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:56:02.563] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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.payment_type_id=1 ) and ( a.status_id=11 ) and ( a.product_id=8102 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:56:08.203] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 09:56:12.516] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 10:06:49.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, 50; [2024-12-18 10:08:43.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 order by a.create_time desc LIMIT 0, 50; [2024-12-18 10:08:47.291] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:08:47.963] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:09:09.213] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:14:18.829] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 10:14:46.267] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-17' and a.create_time <='2024-12-18' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 10:14:55.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.status_id=11 )and a.create_time>='2024-12-17' and a.create_time <='2024-12-18' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 10:19:35.437] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90458200%' or phone like '%90458200%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 10:19:50.828] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 10:19:53.204] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90458200%' or phone like '%90458200%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 10:20:21.970] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:20:32.595] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 10:21:53.484] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:22:13.015] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:23:48.869] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90258200%' or phone like '%90258200%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 10:47:38.762] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:49:35.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 order by a.create_time desc LIMIT 0, 50; [2024-12-18 10:50:50.287] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 10:51:09.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.status_id=11 ) and ( a.product_id=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 10:53:19.642] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 10:58:04.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 order by a.create_time desc LIMIT 0, 50; [2024-12-18 11:00:18.885] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 11:00:42.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 '%94053888%' or phone like '%94053888%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 11:12:59.768] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%a-c3106807%' or phone like '%a-c3106807%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 11:13:03.549] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%a-c3106809%' or phone like '%a-c3106809%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 11:20:53.797] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 11:24:53.356] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 11:52:58.744] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 11:53:39.996] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 12:00:48.107] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 12:01:05.670] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:01:09.201] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 12:02:06.672] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 12:02:18.204] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:02:25.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:02:36.504] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=111 ) and ( a.product_id=7852 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:02:40.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:02:47.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 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 12:05:29.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 order by a.create_time desc LIMIT 0, 50; [2024-12-18 12:24:38.983] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 12:34:32.548] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 12:39:56.477] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%yip%' or phone like '%yip%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 14:15:52.904] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%candylui%' or phone like '%candylui%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 14:20:40.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:20:41.588] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:20:50.510] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:21:38.511] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 14:22:14.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, 25; [2024-12-18 14:23:19.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.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:23:49.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 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-12-18 14:23:52.491] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:23:55.991] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:24:03.006] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:24:14.460] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:24:14.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; [2024-12-18 14:24:18.715] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:24:27.902] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=7842 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:24:49.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:27:50.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:29:41.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 and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:32:22.425] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 14:32:46.990] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=111 )and a.create_time>='2024-12-18' and a.create_time <='2024-12-19' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:47:19.966] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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; [2024-12-18 14:49:30.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-12-18 14:49:37.971] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%93076070%' or phone like '%93076070%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:53:59.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.source is null || a.source = '') ) order by a.create_time desc LIMIT 50, 25; [2024-12-18 14:54:38.064] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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; [2024-12-18 14:55:57.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.user_id in (select id from user where user_login like '%97835949%' or phone like '%97835949%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 14:59:03.211] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%61398688%' or phone like '%61398688%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 15:05:58.050] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3103239%' or phone like '%3103239%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:16:42.785] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%98313078%' or phone like '%98313078%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:17:45.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 and a.user_id in (select id from user where user_login like '%93403787%' or phone like '%93403787%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:19:11.375] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%93402914%' or phone like '%93402914%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:21:18.126] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%55998423%' or phone like '%55998423%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 15:25:20.756] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%91725435%' or phone like '%91725435%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 15:30:18.864] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%t60192%' or phone like '%t60192%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:31:12.005] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%65091536%' or phone like '%65091536%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:32:32.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 '%3102446%' or phone like '%3102446%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:33:27.076] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94363230%' or phone like '%94363230%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:33:51.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 '%90327701%' or phone like '%90327701%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:38:12.273] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%96626421%' or phone like '%96626421%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:38:34.150] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%10239%' or phone like '%10239%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:39:42.074] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3100609%' or phone like '%3100609%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:40:51.333] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%t60072%' or phone like '%t60072%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:41:09.693] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94965546%' or phone like '%94965546%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:41:44.432] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94945782%' or phone like '%94945782%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:43:00.121] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%t60385%' or phone like '%t60385%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:43:01.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 '%t60385%' or phone like '%t60385%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:43:38.657] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%3102044%' or phone like '%3102044%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:52:27.093] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%60740057%' or phone like '%60740057%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:53:22.208] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%92486811%' or phone like '%92486811%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:55:03.398] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%t60348%' or phone like '%t60348%') order by a.create_time desc LIMIT 0, 25; [2024-12-18 15:59:19.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 order by a.create_time desc LIMIT 0, 25; [2024-12-18 16:26:33.714] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90582209%' or phone like '%90582209%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:26:47.889] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 16:26:49.719] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%90582209%' or phone like '%90582209%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:27:17.068] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%ngioksin%' or phone like '%ngioksin%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:31:23.552] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%55998423%' or phone like '%55998423%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:34:02.863] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 16:34:11.019] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 16:34:15.785] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 16:36:59.323] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 16:39:42.388] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 16:39:51.576] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8102 ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 16:41:54.906] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94681838%' or phone like '%94681838%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:43:27.256] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94681838%' or phone like '%94681838%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:44:23.913] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%62089981%' or phone like '%62089981%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:45:14.913] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%91725435%' or phone like '%91725435%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 16:46:57.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, 50; [2024-12-18 17:06:09.510] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%94844799%' or phone like '%94844799%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 17:08:24.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 and a.user_id in (select id from user where user_login like '%98000985%' or phone like '%98000985%') order by a.create_time desc LIMIT 0, 50; [2024-12-18 17:25:58.358] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18 17:27:34.922] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-16' and a.create_time <='2024-12-02' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 25; [2024-12-18 17:27:38.422] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-16' and a.create_time <='2024-12-02' and ( (a.source is null || a.source = '') ) order by a.create_time desc LIMIT 0, 2147483647; [2024-12-18 18:12:38.945] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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, 50; [2024-12-18 18:13:14.025] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-12-18' and a.create_time <='2024-12-19' and ( a.product_id=7912 or a.product_id=7922 or a.product_id=7932 or a.product_id=7942 or a.product_id=7952 or a.product_id=7962 or a.product_id=7972 or a.product_id=7982 or a.product_id=7992 or a.product_id=8002 or a.product_id=8012 or a.product_id=8022 or a.product_id=8032 or a.product_id=8042 or a.product_id=8052 or a.product_id=8062 or a.product_id=8072 or a.product_id=8082 or a.product_id=8092 ) order by a.create_time desc LIMIT 0, 50; [2024-12-18 18:13:17.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.status_id=11 )and a.create_time>='2024-12-18' and a.create_time <='2024-12-19' and ( a.product_id=7912 or a.product_id=7922 or a.product_id=7932 or a.product_id=7942 or a.product_id=7952 or a.product_id=7962 or a.product_id=7972 or a.product_id=7982 or a.product_id=7992 or a.product_id=8002 or a.product_id=8012 or a.product_id=8022 or a.product_id=8032 or a.product_id=8042 or a.product_id=8052 or a.product_id=8062 or a.product_id=8072 or a.product_id=8082 or a.product_id=8092 ) order by a.create_time desc LIMIT 0, 2147483647;