{% extends 'silk/base/base.html' %}
{% load silk_filters %}
{% load silk_inclusion %}
{% load silk_urls %}

{% block pagetitle %}Silky - SQL - {% if silk_request %}{{ silk_request.path }}{% elif profile %}{{ profile.name|default:profile.func_name }}{% endif %}{% endblock %}

{% block menu %}
    {% if profile %}{% profile_menu request profile silk_request %}{% elif silk_request %}{% request_menu request silk_request %}{% endif %}
{% endblock %}

{% block data %}
<div class="rd-overview">
    <div class="req-head">
        <div>
            {% if silk_request and not profile %}
            <h1>SQL</h1>
            <p class="sub"><span class="badge m-{{ silk_request.method }}">{{ silk_request.method }}</span> <code>{{ silk_request.path }}</code> ran {{ silk_request.num_sql_queries }} quer{{ silk_request.num_sql_queries|pluralize:"y,ies" }} in {{ silk_request.time_spent_on_sql_queries|dur }} of {{ silk_request.time_taken|dur }}.</p>
            {% else %}
            <h1>Queries</h1>
            <p class="sub">{{ profile.name|default:profile.func_name }} ran {{ items.paginator.count }} quer{{ items.paginator.count|pluralize:"y,ies" }} in {{ profile.time_spent_on_sql_queries|dur }}.</p>
            {% endif %}
        </div>
        <form method="get" class="menu">
            <label class="menu__label" for="per-page">Show</label>
            <select id="per-page" name="per_page" class="input input--sm" onchange="this.form.submit()">
                {% for option in options_page_size %}<option value="{{ option }}"{% if option == per_page %} selected{% endif %}>{{ option }}</option>{% endfor %}
            </select>
        </form>
    </div>

    {% if n_plus_one and n_plus_one.has_n_plus_one %}
    <div class="alert alert--warn"><span><b>{{ n_plus_one.groups|length }} repeated pattern{{ n_plus_one.groups|length|pluralize }}</b> account for {{ n_plus_one.flagged_query_ids|length }} queries. Batch them with <code>select_related()</code> or <code>prefetch_related()</code>; the Overview tab suggests the fix.</span></div>
    <div class="groups rd-groups">
        {% for group in n_plus_one.groups %}
        <a class="group" href="{% url 'silk:sql' %}?p={{ group.representative.pattern_hash }}" title="See this pattern across requests">
            <span class="group__n is-hot">{{ group.count }}×</span>
            <span class="wf__sql"><span class="sqltype t-{{ group.representative.query|sql_type }}">{{ group.representative.query|sql_type }}</span> <span class="muted">{{ group.representative.query|truncatechars:140 }}</span></span>
            <span class="wf__ms">{{ group.total_time_taken|dur }}</span>
        </a>
        {% endfor %}
    </div>
    {% endif %}

    {% if items %}
    <div class="tablewrap">
        <table class="reqs">
            <thead><tr><th class="c-90">At</th><th>Query</th><th class="num c-80">Joins</th><th class="num c-140">Time</th></tr></thead>
            <tbody>
            {% for q in items %}
            {% sql_detail_url silk_request profile q as detail_url %}
            <tr{% if n_plus_one_ids and q.pk in n_plus_one_ids %} class="is-repeat"{% endif %}>
                {% with at=q.offset_ms|offset %}<td class="mono small nowrap" title="{% if at %}Started this long after the request{% else %}Start time falls outside the request{% endif %}">{{ at|default:"·" }}</td>{% endwith %}
                <td class="c-path-cell">
                    <a class="row-link pat" href="{{ detail_url }}"><span class="sqltype t-{{ q.query|sql_type }}">{{ q.query|sql_type }}</span><code>{{ q.tables_involved|join:", "|default:"·" }}</code>{% if n_plus_one_ids and q.pk in n_plus_one_ids %} <span class="flag">repeated</span>{% endif %}</a>
                    <div class="pat__sql">{{ q.query|truncatechars:200 }}</div>
                </td>
                <td class="num mono">{{ q.num_joins }}</td>
                <td class="num"><div class="timecell t-{% if q.time_taken >= 100 %}bad{% elif q.time_taken >= 20 %}ok{% else %}good{% endif %}"><b>{{ q.time_taken|dur }}</b><span class="timebar"><i style="width:{% widthratio q.time_taken max_ms 100 %}%"></i></span></div></td>
            </tr>
            {% endfor %}
            </tbody>
        </table>
    </div>
    {% if items.paginator.num_pages > 1 %}
    <nav class="pager" aria-label="Pages">
        <span class="muted">{{ items.start_index }}–{{ items.end_index }} of {{ items.paginator.count }}</span>
        <div class="pager__links">
            {% if items.has_previous %}<a class="btn btn--sm" href="?page={{ items.previous_page_number }}&amp;per_page={{ per_page }}">‹ Previous</a>{% endif %}
            <span class="muted">Page {{ items.number }} of {{ items.paginator.num_pages }}</span>
            {% if items.has_next %}<a class="btn btn--sm" href="?page={{ items.next_page_number }}&amp;per_page={{ per_page }}">Next ›</a>{% endif %}
        </div>
    </nav>
    {% endif %}
    {% else %}
    <div class="empty"><p><strong>No SQL queries.</strong></p><p class="muted">This {% if profile %}block{% else %}request{% endif %} did not run any queries.</p></div>
    {% endif %}
</div>
{% endblock %}