FM / profiling

/home/sharedstore/public_html/prestashop.sharedstore.ma/tools/profiling/

/home/sharedstore/public_html/prestashop.sharedstore.ma/tools/profiling

Name	Size	Mode	Actions
templates/	-	0755	rm
.htaccess	170	0644	edit dl rm
Controller.php	4758	0644	edit dl rm
Db.php	3683	0644	edit dl rm
Hook.php	3124	0644	edit dl rm
index.php	1372	0644	edit dl rm
Module.php	1664	0644	edit dl rm
ObjectModel.php	2219	0644	edit dl rm
Profiler.php	11186	0644	edit dl rm
Tools.php	3959	0644	edit dl rm

Edit: /home/sharedstore/public_html/prestashop.sharedstore.ma/tools/profiling/Db.php (3683B)

<?php
/**
 * Copyright since 2007 PrestaShop SA and Contributors
 * PrestaShop is an International Registered Trademark & Property of PrestaShop SA
 *
 * NOTICE OF LICENSE
 *
 * This source file is subject to the Open Software License (OSL 3.0)
 * that is bundled with this package in the file LICENSE.md.
 * It is also available through the world-wide-web at this URL:
 * https://opensource.org/licenses/OSL-3.0
 * If you did not receive a copy of the license and are unable to
 * obtain it through the world-wide-web, please send an email
 * to license@prestashop.com so we can send you a copy immediately.
 *
 * DISCLAIMER
 *
 * Do not edit or add to this file if you wish to upgrade PrestaShop to newer
 * versions in the future. If you wish to customize PrestaShop for your
 * needs please refer to https://devdocs.prestashop.com/ for more information.
 *
 * @author    PrestaShop SA and Contributors <contact@prestashop.com>
 * @copyright Since 2007 PrestaShop SA and Contributors
 * @license   https://opensource.org/licenses/OSL-3.0 Open Software License (OSL 3.0)
 */
abstract class Db extends DbCore
{
    /**
     * Add SQL_NO_CACHE in SELECT queries
     *
     * @var bool
     */
    public $disableCache = true;

/**
     * Total of queries
     *
     * @var int
     */
    public $count = 0;

/**
     * List of queries
     *
     * @var array
     */
    public $queries = [];

/**
     * List of uniq queries (replace numbers by XX)
     *
     * @var array
     */
    public $uniqQueries = [];

/**
     * List of tables
     *
     * @var array
     */
    public $tables = [];

/**
     * Execute the query and log some informations
     *
     * @see DbCore::query()
     */
    public function query($sql)
    {
        $explain = false;
        if (preg_match('/^\s*explain\s+/i', $sql)) {
            $explain = true;
        }

if (!$explain) {
            $uniqSql = preg_replace('/[\'"][a-f0-9]{32}[\'"]/', 'XX', $sql);
            $uniqSql = preg_replace('/[0-9]+/', 'XX', $uniqSql);
            if (!isset($this->uniqQueries[$uniqSql])) {
                $this->uniqQueries[$uniqSql] = 0;
            }

++$this->uniqQueries[$uniqSql];

// No cache for query
            if ($this->disableCache && !stripos($sql, 'SQL_NO_CACHE')) {
                $sql = preg_replace('/^\s*select\s+/i', 'SELECT SQL_NO_CACHE ', trim($sql));
            }

// Get tables in query
            preg_match_all('/(from|join)\s+`?' . _DB_PREFIX_ . '([a-z0-9_-]+)/ui', $sql, $matches);
            foreach ($matches[2] as $table) {
                if (!isset($this->tables[$table])) {
                    $this->tables[$table] = 0;
                }
                ++$this->tables[$table];
            }

$start = microtime(true);
        }

// Execute query
        $result = parent::query($sql);

if (!$explain) {
            $end = microtime(true);

$stack = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS);
            while (preg_match('@[/\\\\]classes[/\\\\]db[/\\\\]@i', $stack[0]['file'])) {
                array_shift($stack);
            }
            $stack_light = [];
            foreach ($stack as $call) {
                $stack_light[] = [
                    'file' => $call['file'] ?? 'undefined',
                    'line' => $call['line'] ?? 'undefined',
                    'function' => $call['function'],
                ];
            }

$this->queries[] = [
                'query' => $sql,
                'time' => $end - $start,
                'stack' => $stack_light,
            ];
        }

return $result;
    }
}

cmd: