73 lines
2.5 KiB
Smarty
73 lines
2.5 KiB
Smarty
{**
|
|
* 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)
|
|
*}
|
|
<div class="row">
|
|
<h2>
|
|
<a name="stopwatch">
|
|
Stopwatch SQL - {$summary.nbQueries} queries
|
|
</a>
|
|
</h2>
|
|
|
|
<table class="table table-condensed table-bordered sortable">
|
|
<thead>
|
|
<tr>
|
|
<th>Query</th>
|
|
<th>Time (ms)</th>
|
|
<th>Rows</th>
|
|
<th>Filesort</th>
|
|
<th>Group By</th>
|
|
<th>Location</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody>
|
|
{foreach $stopwatchQueries as $data}
|
|
{$callstack = implode('<br>', $data['stack'])}
|
|
{$callstack_md5 = md5($callstack)}
|
|
<tr>
|
|
<td class="pre"><pre>{preg_replace("/(^[\s]*)/m", "", htmlspecialchars($data['query'], ENT_NOQUOTES, 'utf-8', false))}</pre></td>
|
|
<td data-value="{$data['time']}">
|
|
{load_time data=($data['time'] * 1000)}
|
|
</td>
|
|
|
|
<td>{$data['rows']}</td>
|
|
<td data-value="{$data['filesort']}">
|
|
{if $data['filesort']}
|
|
<span class="danger">Yes</span>
|
|
{/if}
|
|
</td>
|
|
<td data-value="{$data['group_by']}">
|
|
{if $data['group_by']}
|
|
<span class="danger"">Yes</span>
|
|
{/if}
|
|
</td>
|
|
<td data-value="{$data['location']}">
|
|
<a href="javascript:void(0);" onclick="$('#callstack_{$callstack_md5}').toggle();">{$data['location']}</a>
|
|
<div id="callstack_{$callstack_md5}" style="display:none">{implode('<br>', $data['stack'])}</div>
|
|
</td>
|
|
</tr>
|
|
{/foreach}
|
|
</tbody>
|
|
</table>
|
|
</div>
|