[2024-04-22 08:33:51.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 08:46:49.938]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%66279199%' or phone like '%66279199%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:14:34.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:15:02.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 '%91062861%' or phone like '%91062861%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:17:26.241]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%93255800%' or phone like '%93255800%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:22:42.303]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%96697590%' or phone like '%96697590%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:25:11.445]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%bingbing%' or phone like '%bingbing%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:28:17.102]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and a.user_id in (select id from user where user_login like '%96504688%' or phone like '%96504688%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:29:50.367]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%9874 1029%' or phone like '%9874 1029%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:30:10.199]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 25; 

[2024-04-22 09:34:36.676]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%93637484%' or phone like '%93637484%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:35:46.803]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and a.user_id in (select id from user where user_login like '%54176087%' or phone like '%54176087%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:39:03.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:40:22.839]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%96696642%' or phone like '%96696642%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:45:21.531]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 09:47:06.985]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%3106304%' or phone like '%3106304%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:49:18.182]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 09:52:27.155]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%3103461%' or phone like '%3103461%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 09:55:34.532]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%97564483%' or phone like '%97564483%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:03:07.554]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:07:20.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:07:43.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.product_id=7372  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:07:52.639]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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=7372  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:07:56.545]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 a.status_id=11  ) and (
 a.product_id=7372  ) order by a.create_time desc 
  LIMIT 0, 2147483647; 

[2024-04-22 10:10:00.722]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:10:15.379]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 10:10:27.529]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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=7442  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:10:31.139]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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=7442  ) order by a.create_time desc 
  LIMIT 0, 2147483647; 

[2024-04-22 10:12:17.724]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%97206683%' or phone like '%97206683%')
 and (
 a.status_id=11  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:28:49.526]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 10:30:48.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.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:31:18.765]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:31:50.546]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 a.status_id=11  ) and (
 a.product_id=7442  ) order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:31:58.749]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:35:43.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-04-22 10:36:24.469]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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-04-19' 
and a.create_time <='2024-04-22' 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:36:40.610]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 a.status_id=11  )and a.create_time>='2024-04-19' 
and a.create_time <='2024-04-22' 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 2147483647; 

[2024-04-22 10:40:03.627]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%98768558%' or phone like '%98768558%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 10:40:21.174]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 10:40:33.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  and (
 a.source='Pos'  ) order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 10:40:52.924]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 10:43:33.091]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%96696642%' or phone like '%96696642%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 11:16:01.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.source='Pos'  ) order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 11:16: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.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 100; 

[2024-04-22 11:23:40.182]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 11:28:04.027]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 11:39:40.894]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 11:40:38.226]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 11:45:20.578]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 11:46:50.735]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 11:53:07.938]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 12:18:49.044]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 12:24:50.368]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 12:52:30.580]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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 '%91916432%' or phone like '%91916432%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 13:03:30.872]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:03:52.247]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:04:54.439]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 13:06:06.206]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:39:51.512]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:40:10.637]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:40:12.215]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 13:40:12.684]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 13:40:13.137]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:40:13.575]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:40:13.997]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 13:40:14.434]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 13:53:24.444]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 14:12:28.641]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 14:15:13.754]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 14:36:19.993]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 14:44:52.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, 25; 

[2024-04-22 15:46:36.438]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 16:27:01.862]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 16:28:57.036]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 16:29:47.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.status_id=11  ) and (
 a.product_id=6792  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 16:30:21.178]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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=6772  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 16:37:40.794]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-04-22 16:37:48.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 16:38:02.450]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and a.user_id in (select id from user where user_login like '%91021616%' or phone like '%91021616%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-04-22 16:51:19.833]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 16:53:20.198]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 16:54:26.237]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100; 

[2024-04-22 16:54:53.487]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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, 100;