2025-03-17 04:42:33
UPDATE log_app_device_stats: 12
UPDATE log_daily_new_app_device_list: 0

    UPDATE user u JOIN log_app l USING (user_id)
    SET last_login_time=created_at
    WHERE last_login_time < created_at AND l.id > 6719691556

UPDATE user last_login_time: 275
UPDATE user log_user_by_day: 517
UPDATE user log_user_model_active: 0
UPDATE user log_web_user_by_day: 15
DELETE page_visits_record: 4743
# 
        UPDATE jingcai_tuan t
        JOIN (SELECT tuan_id, COUNT(*) as incc FROM jingcai_tuan_view WHERE id > 3761732 AND id <= 3761739 GROUP BY tuan_id) v
        ON t.id=v.tuan_id
        SET view_times = view_times + incc
    
UPDATE jingcai_tuan_view: 1