[2024-03-20 08:24:35.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  order by a.create_time desc 
  LIMIT 0, 100; 

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

[2024-03-20 09:46:02.671]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-03-20 09:46:02.952]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-03-20 09:49:51.511]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and a.user_id in (select id from user where user_login like '%90391193%' or phone like '%90391193%')
 order by a.create_time desc 
  LIMIT 0, 25; 

[2024-03-20 09:52:55.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  and a.user_id in (select id from user where user_login like '%90391193%' or phone like '%90391193%')
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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

[2024-03-20 10:16:56.876]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-03-20 12:07:34.878]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-03-20 12:08:15.081]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_type d on a.payment_type_id = d.p_id
                            left join user_role e on e.id = b.role_id
                            where 1=1  and (
 a.status_id=11  )and a.create_time>='2024-03-19' 
and a.create_time <='2024-03-20' 
 and (
 (a.source is null || a.source = '')  ) order by a.create_time desc 
  LIMIT 0, 25; 

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