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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[2024-04-02 11:47:01.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.user_id in (select id from user where user_login like '%64752999%' or phone like '%64752999%')
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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

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

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

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

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

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

[2024-04-02 12:23:21.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.user_id in (select id from user where user_login like '%64752999%' or phone like '%64752999%')
 order by a.create_time desc 
  LIMIT 0, 25; 

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

[2024-04-02 12:23:28.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; 

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

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

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

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

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

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

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

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

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

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

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

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

[2024-04-02 18:00:21.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  and a.user_id in (select id from user where user_login like '%92878290%' or phone like '%92878290%')
 order by a.create_time desc 
  LIMIT 0, 25; 

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