[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