2025-03-16 09:08:03
UPDATE log_app_device_stats: 54
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 > 6706388622

UPDATE user last_login_time: 2621
UPDATE user log_user_by_day: 5168
UPDATE user log_user_model_active: 0
UPDATE user log_web_user_by_day: 81
DELETE page_visits_record: 8172
# 
        UPDATE jingcai_tuan t
        JOIN (SELECT tuan_id, COUNT(*) as incc FROM jingcai_tuan_view WHERE id > 3761474 AND id <= 3761621 GROUP BY tuan_id) v
        ON t.id=v.tuan_id
        SET view_times = view_times + incc
    
UPDATE jingcai_tuan_view: 1