/usr/sbin/mysqld, Version: 8.0.39-0ubuntu0.24.04.2 ((Ubuntu)). started with:
Tcp port: 3306  Unix socket: /run/mysqld/mysqld.sock
Time                 Id Command    Argument
# Time: 2024-10-28T00:00:07.790057Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13630
# Query_time: 5.458535  Lock_time: 0.000005 Rows_sent: 1  Rows_examined: 3474582
use ttsopenai_prd;
SET timestamp=1730073602;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T00:00:12.698812Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13630
# Query_time: 4.677347  Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 3474582
SET timestamp=1730073608;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T00:00:19.291855Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 11188
# Query_time: 3.544285  Lock_time: 3.543830 Rows_sent: 0  Rows_examined: 1
SET timestamp=1730073615;
UPDATE tts_histories SET tts_result='flare_uploaded/371046/20241027_235937_677720/Avez_vous_deja_ressenti_le_desir_de_proteger_c_inferred.mp3', status='2', status_desc='Inference callback tts-text \n completed \n ', status_percentage=100, error_message=NULL, updated_at=now() WHERE tts_histories.id = 8002678;
# Time: 2024-10-28T00:00:19.291855Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13023
# Query_time: 3.486391  Lock_time: 3.485959 Rows_sent: 0  Rows_examined: 1
SET timestamp=1730073615;
UPDATE tts_histories SET used_credit=1173, updated_at=now() WHERE tts_histories.id = 8002679;
# Time: 2024-10-28T00:00:19.312197Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13633
# Query_time: 9.865590  Lock_time: 0.000004 Rows_sent: 0  Rows_examined: 3525644
SET timestamp=1730073609;
DELETE FROM story_blocks
                WHERE history_id IN (
                    SELECT id FROM tts_histories
                    WHERE created_at < DATE_SUB(NOW(), INTERVAL 60 DAY)
                );
# Time: 2024-10-28T00:00:29.103511Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13633
# Query_time: 9.789049  Lock_time: 0.000002 Rows_sent: 0  Rows_examined: 3474587
SET timestamp=1730073619;
DELETE FROM tts_histories WHERE created_at < DATE_SUB(NOW(), INTERVAL 60 DAY);
# Time: 2024-10-28T01:00:04.850880Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13913
# Query_time: 3.094366  Lock_time: 0.000003 Rows_sent: 2  Rows_examined: 3426167
SET timestamp=1730077201;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T01:00:07.749145Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 13913
# Query_time: 2.787258  Lock_time: 0.000002 Rows_sent: 0  Rows_examined: 3426165
SET timestamp=1730077204;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T02:00:05.138238Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 14422
# Query_time: 3.582329  Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 3428478
SET timestamp=1730080801;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T03:00:04.888509Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 15702
# Query_time: 3.434857  Lock_time: 0.000004 Rows_sent: 1  Rows_examined: 3431872
SET timestamp=1730084401;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T03:00:07.952288Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 15702
# Query_time: 2.923231  Lock_time: 0.000003 Rows_sent: 0  Rows_examined: 3431875
SET timestamp=1730084405;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T04:00:04.946578Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 16312
# Query_time: 3.081503  Lock_time: 0.000004 Rows_sent: 0  Rows_examined: 3435381
SET timestamp=1730088001;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T04:35:22.780850Z
# User@Host: readonly[readonly] @  [88.222.213.182]  Id: 16716
# Query_time: 3.155384  Lock_time: 0.000003 Rows_sent: 61  Rows_examined: 3437208
SET timestamp=1730090119;
select date(created_at) as dates,sum(openai_credit) as total_credits FROM tts_histories where status=2 group by date(created_at) order by dates desc
LIMIT 0, 5000;
# Time: 2024-10-28T04:42:14.432254Z
# User@Host: readonly[readonly] @  [88.222.213.182]  Id: 16716
# Query_time: 2.818180  Lock_time: 0.000004 Rows_sent: 61  Rows_examined: 3437516
SET timestamp=1730090531;
select date(created_at) as dates,sum(openai_credit) as total_credits FROM tts_histories where status=2 group by date(created_at) order by dates desc
LIMIT 0, 5000;
# Time: 2024-10-28T05:00:04.682953Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 16891
# Query_time: 3.178293  Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 3438301
SET timestamp=1730091601;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T06:00:04.739409Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 17945
# Query_time: 3.213459  Lock_time: 0.000006 Rows_sent: 1  Rows_examined: 3441183
SET timestamp=1730095201;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T06:00:08.036769Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 17945
# Query_time: 3.195965  Lock_time: 0.000001 Rows_sent: 0  Rows_examined: 3441183
SET timestamp=1730095204;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T07:00:04.629615Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 18350
# Query_time: 3.182798  Lock_time: 0.000004 Rows_sent: 3  Rows_examined: 3444488
SET timestamp=1730098801;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T07:00:07.535365Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 18350
# Query_time: 2.749595  Lock_time: 0.000002 Rows_sent: 0  Rows_examined: 3444484
SET timestamp=1730098804;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T08:00:05.130787Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 19489
# Query_time: 3.559980  Lock_time: 0.000004 Rows_sent: 13  Rows_examined: 3448143
SET timestamp=1730102401;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T08:00:08.320508Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 19489
# Query_time: 2.824476  Lock_time: 0.000002 Rows_sent: 0  Rows_examined: 3448120
SET timestamp=1730102405;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T08:00:16.755040Z
# User@Host: ttsopenai[ttsopenai] @  [88.222.213.182]  Id: 19153
# Query_time: 3.466935  Lock_time: 0.000004 Rows_sent: 52  Rows_examined: 6033270
SET timestamp=1730102413;
select date(created_at) as dates, count(distinct(user_id)) as active_users from tts_histories   where id>5000000  group by(dates) order by(dates) desc
LIMIT 0, 1000;
# Time: 2024-10-28T08:42:33.869060Z
# User@Host: readonly[readonly] @  [88.222.213.182]  Id: 16716
# Query_time: 2.733879  Lock_time: 0.000003 Rows_sent: 61  Rows_examined: 3450529
SET timestamp=1730104951;
select date(created_at) as dates,sum(openai_credit) as total_credits FROM tts_histories where status=2 group by date(created_at) order by dates desc
LIMIT 0, 5000;
# Time: 2024-10-28T09:00:05.120244Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 20160
# Query_time: 3.353162  Lock_time: 0.000005 Rows_sent: 5  Rows_examined: 3451679
SET timestamp=1730106001;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T09:00:08.289772Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 20160
# Query_time: 2.954971  Lock_time: 0.000004 Rows_sent: 0  Rows_examined: 3451673
SET timestamp=1730106005;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T10:00:05.272075Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 20626
# Query_time: 3.484294  Lock_time: 0.000005 Rows_sent: 7  Rows_examined: 3454798
SET timestamp=1730109601;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T10:00:08.834813Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 20626
# Query_time: 3.238524  Lock_time: 0.000002 Rows_sent: 0  Rows_examined: 3454784
SET timestamp=1730109605;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T11:00:05.305810Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 21786
# Query_time: 3.724791  Lock_time: 0.000006 Rows_sent: 21  Rows_examined: 3457760
SET timestamp=1730113201;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T11:00:09.623279Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 21786
# Query_time: 2.996630  Lock_time: 0.000003 Rows_sent: 0  Rows_examined: 3457723
SET timestamp=1730113206;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T11:41:56.706382Z
# User@Host: readonly[readonly] @  [88.222.213.182]  Id: 21996
# Query_time: 2.811433  Lock_time: 0.000003 Rows_sent: 61  Rows_examined: 3460106
SET timestamp=1730115713;
select date(created_at) as dates,sum(openai_credit) as total_credits FROM tts_histories where status=2 group by date(created_at) order by dates desc
LIMIT 0, 5000;
# Time: 2024-10-28T12:00:05.490082Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 22072
# Query_time: 3.939258  Lock_time: 0.000005 Rows_sent: 0  Rows_examined: 3460946
SET timestamp=1730116801;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T13:00:05.068280Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 23098
# Query_time: 3.499934  Lock_time: 0.000003 Rows_sent: 10  Rows_examined: 3464255
SET timestamp=1730120401;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T13:00:08.478505Z
# User@Host: ttsopenai[ttsopenai] @  [145.223.118.41]  Id: 23098
# Query_time: 2.832095  Lock_time: 0.000003 Rows_sent: 0  Rows_examined: 3464238
SET timestamp=1730120405;
SELECT tth.id, 
                    tth.tts_input,
                    tth.uuid, 
                    tth.estimated_credit, 
                    user_credit.locked_credit, 
                    user_credit.user_uuid,
                    user_credit.user_id,
                    users.email
                    FROM tts_histories tth
                    JOIN users ON tth.user_id = users.id
                    LEFT JOIN user_credit ON tth.user_id = user_credit.user_id
                    WHERE tth.status IN (1, 11, 12) 
                    AND tth.created_at < DATE_SUB(NOW(), INTERVAL 5 HOUR)
                    ORDER BY tth.id LIMIT 5000;
# Time: 2024-10-28T13:26:45.674499Z
# User@Host: readonly[readonly] @  [88.222.213.182]  Id: 23965
# Query_time: 2.788407  Lock_time: 0.000003 Rows_sent: 61  Rows_examined: 3465872
SET timestamp=1730122002;
select date(created_at) as dates,sum(openai_credit) as total_credits FROM tts_histories where status=2 group by date(created_at) order by dates desc
LIMIT 0, 5000;