[2024-11-02 03:29:42.071] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-11-02 03:31:29.085] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8052 ) order by a.create_time desc LIMIT 0, 25; [2024-11-02 03:31:40.382] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8072 ) order by a.create_time desc LIMIT 0, 25; [2024-11-02 03:31:47.585] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=8062 ) order by a.create_time desc LIMIT 0, 25; [2024-11-02 03:34:26.826] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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=7842 ) order by a.create_time desc LIMIT 0, 25; [2024-11-02 03:35:09.636] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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-11-02 10:42:52.438] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_type d on a.payment_type_id = d.p_id left join user_role e on e.id = b.role_id where 1=1 order by a.create_time desc LIMIT 0, 25; [2024-11-02 10:43:01.549] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%62891463%' or phone like '%62891463%') order by a.create_time desc LIMIT 0, 25; [2024-11-02 13:59:53.901] sql=SELECT a.*,b.user_email,b.address, b.phone, b.user_login as user_login_name, b.phone, c.name as product_name,d.p_name as payment_type_text,e.name as user_role, b.display_name as user_display_name FROM dbd100.p_product_master_order a left join user b on a.user_id = b.ID left join p_product c on a.product_id = c.id left join payment_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 '%93617421%' or phone like '%93617421%') order by a.create_time desc LIMIT 0, 25; [2024-11-02 17:02: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.user_id in (select id from user where user_login like '%10217%' or phone like '%10217%') order by a.create_time desc LIMIT 0, 25;