[TYPO3-english] RealURL query
Dan Osipov
dosipov at phillyburbs.com
Wed Sep 9 21:05:37 CEST 2009
When checking processlist, I often see queries like this:
SELECT uid FROM tt_news WHERE title='fileadmin' AND deleted=0 AND hidden=0
SELECT uid FROM tt_news WHERE title='typo3' AND deleted=0 AND hidden=0
SELECT uid FROM tt_news WHERE title='typo3temp' AND deleted=0 AND hidden=0
SELECT uid FROM tt_news WHERE title='typo3conf' AND deleted=0 AND hidden=0
I think it comes from this part of the configuration:
$GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['realurl']['_DEFAULT']['postVarSets']['_DEFAULT']['article']
[snip]
array (
'GETvar' => 'tx_ttnews[tt_news]',
'lookUpTable' => array (
'table' => 'tt_news',
'id_field' => 'uid',
'alias_field' => 'title',
'addWhereClause' => ' AND deleted=0 AND hidden=0',
'useUniqueCache' => 1,
'useUniqueCache_conf' => array (
'strtolower' => 1,
'spaceCharacter' => '-',
),
),
),
But why are those queries generated? Is there a way to avoid it?
Has anyone encountered something like this?
--
Dan Osipov
Calkins Media
http://danosipov.com/blog/
More information about the TYPO3-english
mailing list