[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