Titre du sujet : Re: Surcharge serveur
par escrime-info sur 15/10/2011 23:52:14
Infomaniak (on peut citer ?) fourni notamment des slowlog, exactement comme ceux en lien dans mon premier post. Exemple :
# Time: 111015 6:47:39
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 841836
use escrime-infocom2;
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280200, 10;
# Time: 111015 6:54:50
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 32 Lock_time: 0 Rows_sent: 1 Rows_examined: 844238
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281410, 10;
# Time: 111015 6:57:16
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 38 Lock_time: 0 Rows_sent: 10 Rows_examined: 841556
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280060, 10;
# Time: 111015 7:02:36
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 34 Lock_time: 0 Rows_sent: 10 Rows_examined: 842316
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280440, 10;
# Time: 111015 7:09:43
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 838876
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 278720, 10;
# Time: 111015 7:30:17
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 776756
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 247660, 10;
# Time: 111015 7:42:18
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 10 Rows_examined: 821296
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 269930, 10;
# Time: 111015 8:04:06
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 5 Rows_examined: 562994
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%srecki%' OR pt.post_text LIKE '%srecki%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 8:05:55
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 5 Rows_examined: 563083
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%sicar%' OR pt.post_text LIKE '%sicar%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 8:08:41
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 2 Rows_examined: 844241
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281410, 10;
# Time: 111015 8:11:26
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 3 Rows_examined: 844244
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 281410, 10;
# Time: 111015 8:15:55
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 838918
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 278740, 10;
# Time: 111015 8:55:39
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 818518
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268540, 10;
# Time: 111015 9:02:16
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 835198
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 276880, 10;
# Time: 111015 9:07:33
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 844058
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281310, 10;
# Time: 111015 9:29:09
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 818858
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268710, 10;
# Time: 111015 9:29:33
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 829358
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 273960, 10;
# Time: 111015 9:56:57
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 829540
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 274050, 10;
# Time: 111015 9:57:14
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 837160
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277860, 10;
# Time: 111015 9:59:12
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 841660
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280110, 10;
# Time: 111015 10:00:58
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 811180
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 264870, 10;
# Time: 111015 10:51:27
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 837142
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277850, 10;
# Time: 111015 10:54:18
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 837203
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277880, 10;
# Time: 111015 10:55:37
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 10 Rows_examined: 734703
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 226630, 10;
# Time: 111015 10:57:14
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 837223
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277890, 10;
# Time: 111015 11:10:41
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 821923
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 270240, 10;
# Time: 111015 11:49:38
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 35 Lock_time: 0 Rows_sent: 10 Rows_examined: 805604
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262080, 10;
# Time: 111015 12:02:44
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 843805
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281180, 10;
# Time: 111015 12:20:08
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 809007
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 263780, 10;
# Time: 111015 12:24:08
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 818748
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268650, 10;
# Time: 111015 12:50:39
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 841530
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280040, 10;
# Time: 111015 12:51:01
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 841831
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280190, 10;
# Time: 111015 13:00:15
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 822992
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 270770, 10;
# Time: 111015 13:06:39
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 818753
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268650, 10;
# Time: 111015 13:23:12
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 822917
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 270730, 10;
# Time: 111015 13:32:30
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 814700
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 266620, 10;
# Time: 111015 13:55:54
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 5 Rows_examined: 563310
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%maraging%' OR pt.post_text LIKE '%maraging%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 13:56:26
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 20 Rows_examined: 563325
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%maraging%' OR pt.post_text LIKE '%maraging%')) ORDER BY p.post_time DESC LIMIT 0, 20;
# Time: 111015 13:56:35
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 563326
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%maraging%' OR pt.post_text LIKE '%maraging%')) ORDER BY p.post_time DESC LIMIT 20, 1;
# Time: 111015 13:57:08
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 844301
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281420, 10;
# Time: 111015 14:42:11
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 734724
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 226630, 10;
# Time: 111015 15:15:14
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 17 Lock_time: 0 Rows_sent: 5 Rows_examined: 563361
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%resto%' OR pt.post_text LIKE '%resto%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 15:15:17
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 16 Lock_time: 0 Rows_sent: 5 Rows_examined: 563361
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%resto%' OR pt.post_text LIKE '%resto%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 15:16:04
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 5 Rows_examined: 563033
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%petit%' OR pt.post_text LIKE '%petit%') AND (p.subject LIKE '%resto%' OR pt.post_text LIKE '%resto%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 15:48:11
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 818770
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268650, 10;
# Time: 111015 15:54:05
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 281470
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 0, 10;
# Time: 111015 15:54:30
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 10 Rows_examined: 818830
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268680, 10;
# Time: 111015 15:59:48
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 5 Rows_examined: 844340
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281440, 10;
# Time: 111015 15:59:58
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 19 Lock_time: 0 Rows_sent: 5 Rows_examined: 844340
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281440, 10;
# Time: 111015 16:03:05
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 5 Rows_examined: 566501
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%calendrier%' OR pt.post_text LIKE '%calendrier%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 16:03:10
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 5 Rows_examined: 566501
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%calendrier%' OR pt.post_text LIKE '%calendrier%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 16:16:46
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 673850
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 196190, 10;
# Time: 111015 16:21:20
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 823231
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 270880, 10;
# Time: 111015 16:31:48
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 16 Lock_time: 0 Rows_sent: 10 Rows_examined: 809177
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 263850, 10;
# Time: 111015 16:34:17
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 748539
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 233530, 10;
# Time: 111015 16:47:24
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 819201
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 268860, 10;
# Time: 111015 17:28:29
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 813853
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 266180, 10;
# Time: 111015 18:07:33
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 675337
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 196920, 10;
# Time: 111015 18:34:30
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 673839
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 196170, 10;
# Time: 111015 19:23:53
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 820161
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 269330, 10;
# Time: 111015 19:54:29
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 800301
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 259400, 10;
# Time: 111015 19:59:09
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 804701
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 261600, 10;
# Time: 111015 20:06:08
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 842201
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 280350, 10;
# Time: 111015 20:44:49
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 827532
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 273010, 10;
# Time: 111015 20:48:44
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 6 Lock_time: 0 Rows_sent: 5 Rows_examined: 563421
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%luxembourg%' OR pt.post_text LIKE '%luxembourg%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 20:52:26
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 5 Rows_examined: 563040
SELECT p.uid,f.forum_id, p.topic_id, p.poster_name, p.post_time, f.forum_name, p.post_id, p.subject
FROM XXXXX_bb_posts p,
XXXXX_bb_posts_text pt,
XXXXX_bb_forums f WHERE p.post_id = pt.post_id AND p.approved = 1 AND p.forum_id = f.forum_id AND f.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND ((p.subject LIKE '%touvet%' OR pt.post_text LIKE '%touvet%')) ORDER BY p.post_time DESC LIMIT 0, 5;
# Time: 111015 21:27:45
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 836025
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277250, 10;
# Time: 111015 21:51:41
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 827607
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 273040, 10;
# Time: 111015 21:59:16
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 9 Lock_time: 0 Rows_sent: 10 Rows_examined: 844491
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 281480, 10;
# Time: 111015 22:03:49
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 836373
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277420, 10;
# Time: 111015 22:03:51
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 836373
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277420, 10;
# Time: 111015 22:04:03
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 836393
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277430, 10;
# Time: 111015 22:08:46
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 836434
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277450, 10;
# Time: 111015 22:08:56
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 835954
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277210, 10;
# Time: 111015 22:09:03
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 835934
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277200, 10;
# Time: 111015 22:15:17
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 835976
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277220, 10;
# Time: 111015 22:20:39
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 836756
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277610, 10;
# Time: 111015 22:20:57
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 836056
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277260, 10;
# Time: 111015 22:21:00
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 836796
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277630, 10;
# Time: 111015 22:21:11
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 835996
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277230, 10;
# Time: 111015 22:21:15
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 836016
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277240, 10;
# Time: 111015 22:21:27
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 836716
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277590, 10;
# Time: 111015 22:21:35
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 10 Rows_examined: 836716
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277590, 10;
# Time: 111015 22:21:44
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 10 Rows_examined: 806596
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262530, 10;
# Time: 111015 22:30:55
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 10 Lock_time: 0 Rows_sent: 10 Rows_examined: 806656
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262560, 10;
# Time: 111015 22:31:06
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 16 Lock_time: 0 Rows_sent: 10 Rows_examined: 837056
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277760, 10;
# Time: 111015 22:31:15
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 836456
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277460, 10;
# Time: 111015 22:31:25
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 806616
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262540, 10;
# Time: 111015 22:31:27
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 836996
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277730, 10;
# Time: 111015 22:31:43
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 835876
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277170, 10;
# Time: 111015 22:31:45
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 806576
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262520, 10;
# Time: 111015 22:31:56
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 12 Lock_time: 0 Rows_sent: 10 Rows_examined: 836976
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277720, 10;
# Time: 111015 22:31:59
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 10 Rows_examined: 806636
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 262550, 10;
# Time: 111015 22:32:18
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 16 Lock_time: 0 Rows_sent: 10 Rows_examined: 837257
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277860, 10;
# Time: 111015 22:32:18
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 15 Lock_time: 0 Rows_sent: 10 Rows_examined: 837277
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277870, 10;
# Time: 111015 22:32:35
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 10 Rows_examined: 837277
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time ASC LIMIT 277870, 10;
# Time: 111015 22:34:55
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 10 Rows_examined: 819857
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 269160, 10;
# Time: 111015 22:46:19
# User@Host: XXXXX[XXXXX] @ localhost []
# Query_time: 8 Lock_time: 0 Rows_sent: 10 Rows_examined: 836722
SELECT p.*, t.* FROM XXXXX_bb_posts AS p LEFT JOIN XXXXX_bb_posts_text AS t ON t.post_id = p.post_id WHERE (p.forum_id IN (16,50,53,54,2,9,7,10,12,14,17,19,24,30,34,35,36,46,1,4,6,44,45,5,21,40,25,28,29,47,13,23,22,49,26,42,8) AND p.approved = '1') ORDER BY p.post_time DESC LIMIT 277590, 10;
Donc ça semble concerner principalement le forum.
Mais je pense que les problèmes viennent surtout des robots qui scannent. Mais pas facile de cerner les problèmes qui semblent multiples...
Question au passage : le bannissement des IPs par protector, c'est efficace ? Je n'arrive pas à réduire la charge du serveur. La courbe reste très élevée, avec des pics à 100 % d'utilisation du CPU 
|
