update

    1. SELECT T.user_id,amount/100000000 AS 'amount',address,op_time,A.total_deposit AS 'deposit',A.times_deposit AS 'times_d'
    2. FROM management.t_deposit T
    3. LEFT JOIN (SELECT SUM(amount/1e8) AS total_deposit, COUNT(1) AS times_deposit, USER_ID FROM management.t_deposit WHERE status = '1' GROUP BY USER_ID) AS A
    4. ON A.user_id = T.USER_ID 
    5. where op_time>=(NOW() - interval 24 hour)
    6. order by updated_at desc
    1. SELECT *
    2. FROM management.t_deposit
    3. where op_time>=(NOW() - interval 24 hour)
    4. order by updated_at desc