Skip to content
This repository has been archived by the owner on Sep 9, 2020. It is now read-only.

SQL трекер

John edited this page Feb 22, 2017 · 2 revisions
<?php 
use Bitrix\Main\Application;
$connection = Application::getConnection();
/*sql requests will be run*/
$connection->startTracker(false);
// code any queries
$connection->stopTracker();
$sql = $rsData->getTrackerQuery()->getSql();
/*sql requests will not  be run*/
// stop queries 
$connection->disableQueryExecuting();
// code any queries
// runq ueries
$connection->enableQueryExecuting();
/*all disabled queries */
$queries = $connection->getDisabledQueryExecutingDump();
$sqlTracker = $connection->getTracker();
$sqlTracker->getTime(); //Время выполнения запросов
$sqlTracker->getCounter(); //Кол-во запросов
$sqlTracker->getQueries(); //Запросы
Clone this wiki locally