ToolBox of Utility functions and ViewHelpers.
To use this extension, require it in Composer:
composer require jakota/typo3toolboxDebug your SQL queries made easy.
Dump SQL Query for createQuery
$query = $this->createQuery();
DebuggerUtility::debugQuery($query)Dump SQL Query for QueryBuilder
$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable('table')->createQueryBuilder();
$queryBuilder
->select('*')
->from('table')
->where(
$queryBuilder->expr()->eq('uid', $queryBuilder->createNamedParameter(123)),
)
->setMaxResults(1)
;
DebuggerUtility::debugQuery($queryBuilder)Add to template
<html xmlns:t3tb="http://typo3.org/ns/JAKOTA/Typo3ToolBox/ViewHelpers" data-namespace-typo3-fluid="true">{t3tb:findImageMetadataFromDB(uid:image.originalResource.properties.file,language:image.originalResource.properties.sys_language_uid)}
<t3tb:relativeDate value="{newsItem.datetime}"/>
TBD