# 1
#
# Time: 210707 15:39:36
# User@Host: 1703313381[1703313381] @ [136.243.53.188] Id: 1138102510
# Schema: xxxxxx Last_errno: 0 Killed: 0
# Query_time: 2.182754 Lock_time: 0.000120 Rows_sent: 0 Rows_examined: 324036 Rows_affected: 0
# Bytes_sent: 20494
SET timestamp=1625661576;
SELECT f.*, t.*, p.*, u.*, tt.mark_time AS topic_mark_time, ft.mark_time AS forum_mark_time FROM (phpbb_posts p CROSS JOIN phpbb_users u CROSS JOIN phpbb_topics t) LEFT JOIN phpbb_forums f ON (t.forum_id = f.forum_id) LEFT JOIN phpbb_topics_track tt ON (t.topic_id = tt.topic_id AND tt.user_id = 659822) LEFT JOIN phpbb_forums_track ft ON (f.forum_id = ft.forum_id AND ft.user_id = 659822) WHERE p.topic_id = t.topic_id
AND p.poster_id = u.user_id
AND p.post_time > 1625660099
AND p.forum_id = 326
AND p.post_approved = 1 ORDER BY t.topic_last_post_time DESC, p.post_time
LIMIT 100;
# 2
#
# Time: 210707 15:38:11
# User@Host: 1703313381[1703313381] @ [136.243.53.188] Id: 1138100591
# Schema: xxxxxx Last_errno: 0 Killed: 0
# Query_time: 9.259469 Lock_time: 0.000015 Rows_sent: 0 Rows_examined: 948209 Rows_affected: 0
# Bytes_sent: 11
SET timestamp=1625661491;
DELETE FROM phpbb_post_revisions
WHERE post_id = 10472158;
# 3
#
# Time: 210707 15:32:18
# User@Host: 1703313381[1703313381] @ [136.243.53.188] Id: 1138094492
# Schema: xxxxxx Last_errno: 0 Killed: 0
# Query_time: 1.113014 Lock_time: 0.000187 Rows_sent: 7 Rows_examined: 521597 Rows_affected: 0
# Bytes_sent: 178150
SET timestamp=1625661138;
SELECT f.*, t.*, p.*, u.*, tt.mark_time AS topic_mark_time, ft.mark_time AS forum_mark_time FROM (phpbb_posts p CROSS JOIN phpbb_users u CROSS JOIN phpbb_topics t) LEFT JOIN phpbb_forums f ON (t.forum_id = f.forum_id) LEFT JOIN phpbb_topics_track tt ON (t.topic_id = tt.topic_id AND tt.user_id = 427441) LEFT JOIN phpbb_forums_track ft ON (f.forum_id = ft.forum_id AND ft.user_id = 427441) WHERE p.topic_id = t.topic_id
AND p.poster_id = u.user_id
AND p.post_time > 1625656199
AND p.forum_id IN (326, 527, 544, 1102)
AND p.post_approved = 1 ORDER BY t.topic_last_post_time DESC, p.post_time
LIMIT 18446744073709551615;
# 4
#
# Time: 210707 15:27:56
# User@Host: 1703313381[1703313381] @ [136.243.53.188] Id: 1138089558
# Schema: xxxxxx Last_errno: 0 Killed: 0
# Query_time: 4.682828 Lock_time: 0.000171 Rows_sent: 1 Rows_examined: 2457916 Rows_affected: 0
# Bytes_sent: 43233
SET timestamp=1625660876;
SELECT f.*, t.*, p.*, u.*, tt.mark_time AS topic_mark_time, ft.mark_time AS forum_mark_time FROM (phpbb_posts p CROSS JOIN phpbb_users u CROSS JOIN phpbb_topics t) LEFT JOIN phpbb_forums f ON (t.forum_id = f.forum_id) LEFT JOIN phpbb_topics_track tt ON (t.topic_id = tt.topic_id AND tt.user_id = 69079) LEFT JOIN phpbb_forums_track ft ON (f.forum_id = ft.forum_id AND ft.user_id = 69079) WHERE p.topic_id = t.topic_id
AND p.poster_id = u.user_id
AND p.post_time > 1625660599
AND p.forum_id IN (9, 16, 17, 28, 36, 42, 55, 60, 65, 790, 64, 66, 110, 116, 837, 833, 133, 134, 135, 137, 143, 158, 823, 810, 788, 208, 211, 212, 213, 215, 216, 217, 218, 220, 221, 223, 224, 822, 836, 236, 238, 241, 242, 243, 270, 776, 291, 293, 294, 296, 292, 210, 40, 227, 239, 863, 781, 865, 548, 551, 552, 553, 554, 852, 851, 839, 550, 868, 884, 890, 909, 914, 916, 898, 896, 936, 937, 939, 969, 970, 982, 983, 989, 997, 92, 1076, 1124, 1130, 240, 1197, 1198, 1209, 1327, 1341, 1345, 1363, 1364, 1365, 1366, 1367, 1368, 1371, 1372, 1373, 1374, 1375, 1376, 1377, 1378, 1370, 1404, 1405, 1406, 1407, 1416, 1417, 1418, 1419, 1423, 1424, 1441, 1442, 1443, 1461, 1481, 1490, 1495, 1496, 1497, 1508, 1524, 1536, 1541, 1542, 119)
AND p.post_approved = 1 ORDER BY t.topic_last_post_time DESC, p.post_time
LIMIT 18446744073709551615;