<div class="page-header">
    <h3>Query overview</h3>
</div>

<div class="row">
    <div class="span6">

        <div># Queries: {count}</div>
        <div>Time span: {deltaTime} ({fromTime} - {toTime})</div>
        <div>Avg. time/query: {avgTime}</div>
    </div>
    <div class="span2 offset3">
        <a onclick="submit('record')" class="btn {if(recording)}btn-warning{else}btn-info{endif} btn-large">{if(recording)}Recording{else}Not&nbsp;recording{endif}</a>
    </div>
    <div class="span1 ">
        <a onclick="submit('clear')" class="btn btn-danger btn-large">Clear</a>
    </div>
</div>

<ul class="nav nav-pills">
    <li {if(sortTotalTime)}class="active"{endif}><a onclick="submit('sortTotalTime')">Total time</a></li>
    <li {if(sortAvgTime)}class="active"{endif}><a onclick="submit('sortAvgTime')">Avg. time</a></li>
    <li {if(sortTotalCalls)}class="active"{endif}><a onclick="submit('sortTotalCalls')"># Calls</a></li>
</ul>

<table class="table table-condensed table-striped " id="overview">
    <thead>
    <tr>
        <th> </th>
        <th>Total time (ms)</th>
        <th>Avg. time (ms)</th>
        <th># Calls</th>
        <th>Sql</th>
    </tr>
    </thead>
    <tbody>
    {foreach(queries as q)}
    <tr>
        <td><a onclick="submit('select', '{q.hash}')"><i class=" icon-zoom-in"></i></a></td>
        <td>{q.total}</td>
        <td>{q.formattedNano}</td>
        <td>{q.count}</td>
        <td>{q.sql}</td>
    </tr>
    {eachend}
    </tbody>
</table>