[2024-01-06 10:46:55.171]	sql=SELECT  a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name 
                            FROM dbd100.p_product_master_order a
                            left join user b on a.user_id = b.ID
                            left join p_product c on a.product_id = c.id
                            left join payment_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-01-06 12:55:55.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  and a.user_id in (select id from user where user_login like '%3100912%' or phone like '%3100912%')
 order by a.create_time desc 
  LIMIT 0, 25; 

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

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