You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Daniel Seifert f6f9ddc7e7
adjust documentation
1 day ago
example allow newlines in cli output, add FirePHP handler to browser console log 1 year ago
img remove Query Status Monitor, complete implementation 10 months ago
src adjust documentation 1 day ago
.gitattributes change line endings for easy patching 9 months ago
.gitignore Initial commit 1 year ago adjust documentation 1 day ago
LICENSE Initial commit 1 year ago adjust documentation 1 day ago
composer.json fix non https url in composer.json 8 months ago

Oxid eShop SQL Logger

Returns all SQL queries into console of a Browser.


composer require --dev d3/oxid-sql-logger


Just set the function D3StartSQLLog() somewhere and from that point on all SQLs will be logged.

\D3StartSQLLog('specific log message');

$db = \OxidEsales\Eshop\Core\DatabaseProvider::getDb(\OxidEsales\Eshop\Core\DatabaseProvider::FETCH_MODE_ASSOC);
$list = $db->getAll('SELECT * FROM oxarticles WHERE oxprice < ? LIMIT 100', [49.99]);




Example all sqls


Example CLI


Add the sections to the of the shop if needed:

$this->SqlLoggerGUIHandlers = [

Standard handlers are BrowserConsoleHandler and d3FirePHPHandler.

$this->SqlLoggerCLIHandlers = [

Standard handler is StreamHandler.

$this->d3FirePHPOptions = [


Many thanks to Tobias Matthaiou for his inspiration.