Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $logger = new \Doctrine\DBAL\Logging\DebugStack();
- \Bingo::$em->getConfiguration()->setSQLLogger($logger);
- register_shutdown_function(function() use ($logger) {
- $pageUrl = \Bingo\Routing::$uri;
- $maxQueryCountData = \Bingo::$em->createQuery('SELECT l.field3 FROM Ersties\Models\Log l WHERE l.type = :type AND l.field4 = :page_url')
- ->setParameters(['type' => 'pageQueriesData', 'page_url' => $pageUrl])
- ->getOneOrNullResult();
- $maxQueryCount = !empty($maxQueryCountData) ? (int)$maxQueryCountData['field3'] : null;
- $updatePageQueriesData = false;
- if (!$maxQueryCount) {
- $updatePageQueriesData = true;
- } else {
- $currentQueryCount = count($logger->queries);
- if ($currentQueryCount > $maxQueryCount)
- $updatePageQueriesData = true;
- }
- if ($updatePageQueriesData)
- \Ersties\Models\Log::updatePageQueriesData($pageUrl, $logger->queries);
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement