[TYPO3-ttnews] tt_news generating slow queries

Piotr Burda pburda at typo3job.com
Fri Dec 10 09:40:14 CET 2010


Hi
In my slowlog i have a large number of this query:
SELECT * FROM tt_news WHERE tt_news.pid IN (798) AND tt_news.deleted=0 
AND tt_news.t3ver_state<=0 AND tt_news.hidden=0 AND 
tt_news.starttime<=1291935420 AND (tt_news.endtime=0 OR 
tt_news.endtime>1291935420) AND (tt_news.fe_group='' OR tt_news.fe_group 
IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR 
tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR 
tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR 
tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR 
tt_news.fe_group='-1')) AND sys_language_uid IN (0,-1);

all parameters are same, only starttime and endtime are changing.
Which part or tt_news is generating it and why?

Regards
Piotr


More information about the TYPO3-project-tt-news mailing list