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

[2023-12-11 09:21:54.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  order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 09:23:03.038]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%64629828%' or a.order_no  like '%64629828%' or b.user_login like '%64629828%' or b.phone like '%64629828%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 09:26:42.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 09:26:48.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  and (a.transactionID like '%66272521%' or a.order_no  like '%66272521%' or b.user_login like '%66272521%' or b.phone like '%66272521%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 09:31:02.915]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%d20231129328359%' or a.order_no  like '%d20231129328359%' or b.user_login like '%d20231129328359%' or b.phone like '%d20231129328359%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 09:41:14.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.transactionID like '%62348209%' or a.order_no  like '%62348209%' or b.user_login like '%62348209%' or b.phone like '%62348209%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 10:02:32.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, 100; 

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

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

[2023-12-11 10:27:56.851]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%90798538%' or a.order_no  like '%90798538%' or b.user_login like '%90798538%' or b.phone like '%90798538%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 10:35:05.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.transactionID like '%98263497%' or a.order_no  like '%98263497%' or b.user_login like '%98263497%' or b.phone like '%98263497%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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

[2023-12-11 10:42:29.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 10:42:52.266]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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 50, 25; 

[2023-12-11 10:42:56.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 350, 25; 

[2023-12-11 10:42:59.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  order by a.create_time desc 
  LIMIT 550, 25; 

[2023-12-11 10:43:05.063]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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 500, 25; 

[2023-12-11 10:43:08.813]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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 525, 25; 

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

[2023-12-11 10:43:35.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, 100; 

[2023-12-11 10:47:05.571]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%shanicechan828@gmail.com%' or a.order_no  like '%shanicechan828@gmail.com%' or b.user_login like '%shanicechan828@gmail.com%' or b.phone like '%shanicechan828@gmail.com%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 10:58:18.210]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3110914%' or a.order_no  like '%3110914%' or b.user_login like '%3110914%' or b.phone like '%3110914%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:00:32.282]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%51687880%' or a.order_no  like '%51687880%' or b.user_login like '%51687880%' or b.phone like '%51687880%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:01:36.846]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:02:15.190]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%wolily%' or a.order_no  like '%wolily%' or b.user_login like '%wolily%' or b.phone like '%wolily%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 11:05:05.301]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:05:14.848]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%93024679%' or a.order_no  like '%93024679%' or b.user_login like '%93024679%' or b.phone like '%93024679%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 11:08:52.056]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%63310183%' or a.order_no  like '%63310183%' or b.user_login like '%63310183%' or b.phone like '%63310183%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:13:03.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 11:13:27.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.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

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

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

[2023-12-11 11:17:04.717]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3102605%' or a.order_no  like '%3102605%' or b.user_login like '%3102605%' or b.phone like '%3102605%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:20:36.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.transactionID like '%63310183%' or a.order_no  like '%63310183%' or b.user_login like '%63310183%' or b.phone like '%63310183%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:24:10.823]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%nagoya%' or a.order_no  like '%nagoya%' or b.user_login like '%nagoya%' or b.phone like '%nagoya%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:26:02.138]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

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

[2023-12-11 11:26:10.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  and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 11:26:37.813]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:29:03.593]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:29:16.509]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%maylee%' or a.order_no  like '%maylee%' or b.user_login like '%maylee%' or b.phone like '%maylee%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 11:29:16.962]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:31:42.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.transactionID like '%90394114%' or a.order_no  like '%90394114%' or b.user_login like '%90394114%' or b.phone like '%90394114%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:34:32.521]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 11:39:05.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, 25; 

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

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

[2023-12-11 11:39:47.052]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 275, 25; 

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

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

[2023-12-11 11:39:57.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  and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 300, 25; 

[2023-12-11 11:41:00.974]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%t60533%' or a.order_no  like '%t60533%' or b.user_login like '%t60533%' or b.phone like '%t60533%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 11:50:43.593]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3108699%' or a.order_no  like '%3108699%' or b.user_login like '%3108699%' or b.phone like '%3108699%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 12:01:42.951]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3100781%' or a.order_no  like '%3100781%' or b.user_login like '%3100781%' or b.phone like '%3100781%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 12:03:51.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  and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 275, 25; 

[2023-12-11 12:10:47.416]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%60885040%' or a.order_no  like '%60885040%' or b.user_login like '%60885040%' or b.phone like '%60885040%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 12:16:12.514]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%93637484%' or a.order_no  like '%93637484%' or b.user_login like '%93637484%' or b.phone like '%93637484%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 12:16:19.655]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%91545805%' or a.order_no  like '%91545805%' or b.user_login like '%91545805%' or b.phone like '%91545805%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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

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

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

[2023-12-11 12:23:50.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.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 250, 25; 

[2023-12-11 12:32:02.640]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3102605%' or a.order_no  like '%3102605%' or b.user_login like '%3102605%' or b.phone like '%3102605%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 12:42:23.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.transactionID like '%3103723%' or a.order_no  like '%3103723%' or b.user_login like '%3103723%' or b.phone like '%3103723%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 12:51:53.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.transactionID like '%62837289%' or a.order_no  like '%62837289%' or b.user_login like '%62837289%' or b.phone like '%62837289%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:04:48.053]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%93637484%' or a.order_no  like '%93637484%' or b.user_login like '%93637484%' or b.phone like '%93637484%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:07:44.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  and (a.transactionID like '%91806381%' or a.order_no  like '%91806381%' or b.user_login like '%91806381%' or b.phone like '%91806381%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:08:35.350]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%62837289%' or a.order_no  like '%62837289%' or b.user_login like '%62837289%' or b.phone like '%62837289%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 13:11:02.210]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%lyman2568%' or a.order_no  like '%lyman2568%' or b.user_login like '%lyman2568%' or b.phone like '%lyman2568%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:15:29.133]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%t60133.%' or a.order_no  like '%t60133.%' or b.user_login like '%t60133.%' or b.phone like '%t60133.%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:16:46.883]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%t60133%' or a.order_no  like '%t60133%' or b.user_login like '%t60133%' or b.phone like '%t60133%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:21:27.498]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%lylam2568%' or a.order_no  like '%lylam2568%' or b.user_login like '%lylam2568%' or b.phone like '%lylam2568%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:23:50.227]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%wolily%' or a.order_no  like '%wolily%' or b.user_login like '%wolily%' or b.phone like '%wolily%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:28:19.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  and (a.transactionID like '%96758047%' or a.order_no  like '%96758047%' or b.user_login like '%96758047%' or b.phone like '%96758047%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:37:36.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  order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 13:38:19.423]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%515381830%' or a.order_no  like '%515381830%' or b.user_login like '%515381830%' or b.phone like '%515381830%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:39:09.814]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3109045%' or a.order_no  like '%3109045%' or b.user_login like '%3109045%' or b.phone like '%3109045%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 13:39:28.533]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%93369982%' or a.order_no  like '%93369982%' or b.user_login like '%93369982%' or b.phone like '%93369982%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 13:47:23.503]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 13:47:32.628]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%94382045%' or a.order_no  like '%94382045%' or b.user_login like '%94382045%' or b.phone like '%94382045%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 13:50:00.851]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%91953220%' or a.order_no  like '%91953220%' or b.user_login like '%91953220%' or b.phone like '%91953220%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 13:51:46.551]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3100866%' or a.order_no  like '%3100866%' or b.user_login like '%3100866%' or b.phone like '%3100866%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 13:52:34.911]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%91545805%' or a.order_no  like '%91545805%' or b.user_login like '%91545805%' or b.phone like '%91545805%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 13:54:55.975]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 13:55:06.960]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%94647313%' or a.order_no  like '%94647313%' or b.user_login like '%94647313%' or b.phone like '%94647313%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 13:55:33.022]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%shanice%' or a.order_no  like '%shanice%' or b.user_login like '%shanice%' or b.phone like '%shanice%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 13:56:50.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  and (a.transactionID like '%60885040%' or a.order_no  like '%60885040%' or b.user_login like '%60885040%' or b.phone like '%60885040%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 14:01:33.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  and (a.transactionID like '%dcd100%' or a.order_no  like '%dcd100%' or b.user_login like '%dcd100%' or b.phone like '%dcd100%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 14:25:52.404]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%fwong%' or a.order_no  like '%fwong%' or b.user_login like '%fwong%' or b.phone like '%fwong%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 14:47:48.553]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%babyc%' or a.order_no  like '%babyc%' or b.user_login like '%babyc%' or b.phone like '%babyc%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 14:50:38.541]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%7783889900%' or a.order_no  like '%7783889900%' or b.user_login like '%7783889900%' or b.phone like '%7783889900%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:18:47.870]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%60135013%' or a.order_no  like '%60135013%' or b.user_login like '%60135013%' or b.phone like '%60135013%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:19:48.092]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%babyc%' or a.order_no  like '%babyc%' or b.user_login like '%babyc%' or b.phone like '%babyc%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:27:16.320]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 15:27:22.538]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3100902%' or a.order_no  like '%3100902%' or b.user_login like '%3100902%' or b.phone like '%3100902%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:30:54.592]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%60135013%' or a.order_no  like '%60135013%' or b.user_login like '%60135013%' or b.phone like '%60135013%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:31:59.766]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 15:32:08.344]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%90487190%' or a.order_no  like '%90487190%' or b.user_login like '%90487190%' or b.phone like '%90487190%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 15:35:48.274]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%51053225%' or a.order_no  like '%51053225%' or b.user_login like '%51053225%' or b.phone like '%51053225%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:41:25.652]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 15:42:22.359]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%babyc%' or a.order_no  like '%babyc%' or b.user_login like '%babyc%' or b.phone like '%babyc%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 15:43:23.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.transactionID like '%babyc%' or a.order_no  like '%babyc%' or b.user_login like '%babyc%' or b.phone like '%babyc%') 
 order by a.create_time desc 
  LIMIT 25, 25; 

[2023-12-11 15:44:24.667]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 15:44:40.745]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%7783889900%' or a.order_no  like '%7783889900%' or b.user_login like '%7783889900%' or b.phone like '%7783889900%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 15:45:48.293]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%cecitemp@hotmail.com%' or a.order_no  like '%cecitemp@hotmail.com%' or b.user_login like '%cecitemp@hotmail.com%' or b.phone like '%cecitemp@hotmail.com%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 15:52:20.592]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%54216867%' or a.order_no  like '%54216867%' or b.user_login like '%54216867%' or b.phone like '%54216867%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 15:56:21.982]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3106854%' or a.order_no  like '%3106854%' or b.user_login like '%3106854%' or b.phone like '%3106854%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 15:58:31.614]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:01:10.486]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3102197%' or a.order_no  like '%3102197%' or b.user_login like '%3102197%' or b.phone like '%3102197%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 16:05:42.535]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:05:47.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.transactionID like '%3106328%' or a.order_no  like '%3106328%' or b.user_login like '%3106328%' or b.phone like '%3106328%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 16:12:56.590]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%16180168%' or a.order_no  like '%16180168%' or b.user_login like '%16180168%' or b.phone like '%16180168%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2023-12-11 16:19:04.665]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3104367%' or a.order_no  like '%3104367%' or b.user_login like '%3104367%' or b.phone like '%3104367%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 16:23:45.602]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:23:57.258]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%16180168%' or a.order_no  like '%16180168%' or b.user_login like '%16180168%' or b.phone like '%16180168%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 16:27:09.665]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:27:13.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  order by a.create_time desc 
  LIMIT 500, 100; 

[2023-12-11 16:31:18.028]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3104367%' or a.order_no  like '%3104367%' or b.user_login like '%3104367%' or b.phone like '%3104367%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

[2023-12-11 16:37:28.294]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

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

[2023-12-11 16:39:35.877]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%51086561%' or a.order_no  like '%51086561%' or b.user_login like '%51086561%' or b.phone like '%51086561%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 16:40:54.941]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:41:45.771]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 16:41:51.146]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%98060239%' or a.order_no  like '%98060239%' or b.user_login like '%98060239%' or b.phone like '%98060239%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

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

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

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

[2023-12-11 16:55:16.881]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%95846818%' or a.order_no  like '%95846818%' or b.user_login like '%95846818%' or b.phone like '%95846818%') 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 16:58:11.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  order by a.create_time desc 
  LIMIT 0, 25; 

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

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

[2023-12-11 16:58:29.272]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d 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>='2023-12-11' 
and a.create_time <='2023-12-12' 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 2147483647; 

[2023-12-11 17:03:01.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.transactionID like '%97835949%' or a.order_no  like '%97835949%' or b.user_login like '%97835949%' or b.phone like '%97835949%') 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 17:03:53.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.transactionID like '%95846818%' or a.order_no  like '%95846818%' or b.user_login like '%95846818%' or b.phone like '%95846818%') 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 17:04:32.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  and (a.transactionID like '%97835949%' or a.order_no  like '%97835949%' or b.user_login like '%97835949%' or b.phone like '%97835949%') 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 17:05:16.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; 

[2023-12-11 17:05:17.344]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 17:06:07.786]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%97835949%' or a.order_no  like '%97835949%' or b.user_login like '%97835949%' or b.phone like '%97835949%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 17:07:10.240]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%53214084%' or a.order_no  like '%53214084%' or b.user_login like '%53214084%' or b.phone like '%53214084%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 17:11:33.694]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%23887889%' or a.order_no  like '%23887889%' or b.user_login like '%23887889%' or b.phone like '%23887889%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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

[2023-12-11 17:51:23.272]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 17:51:40.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.create_time>='2023-12-11' 
and a.create_time <='2023-12-12' 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 18:12:00.218]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (a.transactionID like '%3100902%' or a.order_no  like '%3100902%' or b.user_login like '%3100902%' or b.phone like '%3100902%') 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 18:33:22.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  and (a.transactionID like '%97604510%' or a.order_no  like '%97604510%' or b.user_login like '%97604510%' or b.phone like '%97604510%') 
 order by a.create_time desc 
  LIMIT 0, 25; 

[2023-12-11 21:02:57.350]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 21:03:04.835]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 a.source='Pos'  ) order by a.create_time desc 
  LIMIT 0, 100; 

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

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

[2023-12-11 23:26:45.900]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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; 

[2023-12-11 23:27:11.253]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1 and a.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 23:34:28.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.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 23:34:46.089]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1 and a.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 23:36:27.224]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1 and a.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 23:52:26.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 and a.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 order by a.create_time desc 
  LIMIT 0, 100; 

[2023-12-11 23:55:32.407]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1 and a.create_time>='2023-09-24' 
and a.create_time <='2023-12-05' 
 and (
 a.source='Pos'  ) order by a.create_time desc 
  LIMIT 0, 100;