Wertos
Пьянь местная
- Регистрация
- 13 Апр 2007
- Сообщения
- 178
- Реакции
- 39
- Автор темы
- #1
Код:
SELECT COUNT(distinct(t.topic_id)) AS lt_count
FROM
phpbb_topics AS t,
phpbb_users AS u,
phpbb_tracker_torrents AS tr
WHERE
( t.topic_type != 3 ) AND
tr.forum_id IN (1,2,29,30,31,32,35,70,33,10,42,43,73,78,44,45,40,41,3,18,36,37,39,4,46,47,48,49,50,51,52,53,76,6,56,57,58,59,60,61,62,63,64,65,66,5,54,55,74,7,67,68,20) AND
t.topic_poster = u.user_id AND t.topic_approved = 1 AND t.topic_id=tr.topic_id AND tr.forb < 1
Код:
SELECT COUNT(topic_id) AS num_topics
FROM phpbb_topics
WHERE ((topic_type = 3)
OR topic_type = 2)
AND topic_approved = 1
AND topic_moved_id = 0
AND (forum_id = 0 OR (forum_id <> 2 AND forum_id <> 29 AND forum_id <> 30 AND forum_id <> 31 AND forum_id <> 32 AND forum_id <> 35 AND forum_id <> 70 AND forum_id <> 33 AND forum_id <> 3 AND forum_id <> 18 AND forum_id <> 36 AND forum_id <> 37 AND forum_id <> 38 AND forum_id <> 39 AND forum_id <> 10 AND forum_id <> 40 AND forum_id <> 41 AND forum_id <> 42 AND forum_id <> 44 AND forum_id <> 45 AND forum_id <> 43 AND forum_id <> 4 AND forum_id <> 46 AND forum_id <> 47 AND forum_id <> 48 AND forum_id <> 49 AND forum_id <> 50 AND forum_id <> 51 AND forum_id <> 52 AND forum_id <> 53 AND forum_id <> 5 AND forum_id <> 54 AND forum_id <> 55 AND forum_id <> 6 AND forum_id <> 56 AND forum_id <> 57 AND forum_id <> 58 AND forum_id <> 59 AND forum_id <> 60 AND forum_id <> 61 AND forum_id <> 62 AND forum_id <> 63 AND forum_id <> 64 AND forum_id <> 65 AND forum_id <> 66 AND forum_id <> 7 AND forum_id <> 67 AND forum_id <> 68 AND forum_id <> 20 AND forum_id <> 17 AND forum_id <> 69))
Последний запрос очень долгий ! База 6Гб
Может индексов не хватает каких нибудь