[s] job_id = [3594], last_id = [0]
debug[2026-04-05 22:38:47.453613] : reset_cache start with 4
SELECT album_id FROM mx_album WHERE DATEDIFF(NOW(), update_datetime) <= 100 order BY update_datetime limit 100
debug[2026-04-05 22:38:48.011482] : reset_cache for albums [0,1070141,1070142,1070143,1070144,1070145,1070146,1070147,1070148,1070149,1070150,1070151,1070152,1070155,1070156,1070157,1070158,1070162,1070166,1070167,1070168,1070169,1070171,1070173,1070174,1070175,1070176,1070178,1070179,1070180,1070182,1070153,1070154,1070160,1070183,1070163,1070184,1070185,1070186,1070189,1070164,1070165,1070159,1070161,1070181,1070172,1070170,1070177,1070191,1070192,1070193,1070194,1070197,1070198,1070199,1070202,1070187,1070188,1070190,1070195,1070196,1070200,1070201,1070203,1070204,1070205,1070206,1070207,1070208,1070209,1070210,1070211,1070212,1070214,1070215,1070217,1070218,1070220,1070219,1070221,1070222,1070223,1070225,1070226,1070227,1070216,1070229,1070224,1070228,1070230,1070231,1070233,1070234,1070239,1070240,1070241,1070232,1070235,1070236,1070237,1070238]
SELECT a.artist_id, a.update_datetime, ac.cache_datetime, TIMESTAMPDIFF(MINUTE, cache_datetime, a.update_datetime), DATEDIFF(a.update_datetime, cache_datetime) FROM maniadb.ct_artist ac INNER JOIN ( SELECT DISTINCT aar.artist_id, al.update_datetime FROM mx_album al INNER JOIN mx_album_artist_role aar ON al.album_id = aar.album_id WHERE al.album_id IN ( 0,1070141,1070142,1070143,1070144,1070145,1070146,1070147,1070148,1070149,1070150,1070151,1070152,1070155,1070156,1070157,1070158,1070162,1070166,1070167,1070168,1070169,1070171,1070173,1070174,1070175,1070176,1070178,1070179,1070180,1070182,1070153,1070154,1070160,1070183,1070163,1070184,1070185,1070186,1070189,1070164,1070165,1070159,1070161,1070181,1070172,1070170,1070177,1070191,1070192,1070193,1070194,1070197,1070198,1070199,1070202,1070187,1070188,1070190,1070195,1070196,1070200,1070201,1070203,1070204,1070205,1070206,1070207,1070208,1070209,1070210,1070211,1070212,1070214,1070215,1070217,1070218,1070220,1070219,1070221,1070222,1070223,1070225,1070226,1070227,1070216,1070229,1070224,1070228,1070230,1070231,1070233,1070234,1070239,1070240,1070241,1070232,1070235,1070236,1070237,1070238 ) UNION SELECT DISTINCT sar.artist_id, al.update_datetime FROM mx_album al INNER JOIN mx_song s ON al.album_id = s.default_album_id INNER JOIN mx_song_artist_role sar ON sar.song_id = s.song_id WHERE al.album_id IN ( 0,1070141,1070142,1070143,1070144,1070145,1070146,1070147,1070148,1070149,1070150,1070151,1070152,1070155,1070156,1070157,1070158,1070162,1070166,1070167,1070168,1070169,1070171,1070173,1070174,1070175,1070176,1070178,1070179,1070180,1070182,1070153,1070154,1070160,1070183,1070163,1070184,1070185,1070186,1070189,1070164,1070165,1070159,1070161,1070181,1070172,1070170,1070177,1070191,1070192,1070193,1070194,1070197,1070198,1070199,1070202,1070187,1070188,1070190,1070195,1070196,1070200,1070201,1070203,1070204,1070205,1070206,1070207,1070208,1070209,1070210,1070211,1070212,1070214,1070215,1070217,1070218,1070220,1070219,1070221,1070222,1070223,1070225,1070226,1070227,1070216,1070229,1070224,1070228,1070230,1070231,1070233,1070234,1070239,1070240,1070241,1070232,1070235,1070236,1070237,1070238 ) UNION SELECT DISTINCT member_artist_id, a.update_datetime FROM mx_artist_generation_lineup agl INNER JOIN ( SELECT DISTINCT aar.artist_id, aar.artist_seq_no, al.update_datetime FROM mx_album al INNER JOIN mx_album_artist_role aar ON al.album_id = aar.album_id WHERE aar.album_id IN ( 0,1070141,1070142,1070143,1070144,1070145,1070146,1070147,1070148,1070149,1070150,1070151,1070152,1070155,1070156,1070157,1070158,1070162,1070166,1070167,1070168,1070169,1070171,1070173,1070174,1070175,1070176,1070178,1070179,1070180,1070182,1070153,1070154,1070160,1070183,1070163,1070184,1070185,1070186,1070189,1070164,1070165,1070159,1070161,1070181,1070172,1070170,1070177,1070191,1070192,1070193,1070194,1070197,1070198,1070199,1070202,1070187,1070188,1070190,1070195,1070196,1070200,1070201,1070203,1070204,1070205,1070206,1070207,1070208,1070209,1070210,1070211,1070212,1070214,1070215,1070217,1070218,1070220,1070219,1070221,1070222,1070223,1070225,1070226,1070227,1070216,1070229,1070224,1070228,1070230,1070231,1070233,1070234,1070239,1070240,1070241,1070232,1070235,1070236,1070237,1070238 ) ) a ON agl.artist_id = a.artist_id AND agl.artist_seq_no = a.artist_seq_no UNION SELECT DISTINCT member_artist_id, a.update_datetime FROM mx_artist_generation_lineup agl INNER JOIN ( SELECT DISTINCT sar.artist_id, sar.artist_seq_no, al.update_datetime FROM mx_album al INNER JOIN mx_song s ON al.album_id = s.default_album_id INNER JOIN mx_song_artist_role sar ON sar.song_id = s.song_id WHERE al.album_id IN ( 0,1070141,1070142,1070143,1070144,1070145,1070146,1070147,1070148,1070149,1070150,1070151,1070152,1070155,1070156,1070157,1070158,1070162,1070166,1070167,1070168,1070169,1070171,1070173,1070174,1070175,1070176,1070178,1070179,1070180,1070182,1070153,1070154,1070160,1070183,1070163,1070184,1070185,1070186,1070189,1070164,1070165,1070159,1070161,1070181,1070172,1070170,1070177,1070191,1070192,1070193,1070194,1070197,1070198,1070199,1070202,1070187,1070188,1070190,1070195,1070196,1070200,1070201,1070203,1070204,1070205,1070206,1070207,1070208,1070209,1070210,1070211,1070212,1070214,1070215,1070217,1070218,1070220,1070219,1070221,1070222,1070223,1070225,1070226,1070227,1070216,1070229,1070224,1070228,1070230,1070231,1070233,1070234,1070239,1070240,1070241,1070232,1070235,1070236,1070237,1070238 ) ) a ON agl.artist_id = a.artist_id AND agl.artist_seq_no = a.artist_seq_no ) a ON ac.artist_id = a.artist_id WHERE TIMESTAMPDIFF(MINUTE, cache_datetime, a.update_datetime) > 0 AND ac.artist_id <> 114880 ORDER BY ac.artist_id DESC limit 100
task count = [0]
[e] job_id = [3594], last_id = [0]