|
/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;
|