{% extends app.request.isXmlHttpRequest ? 'WebProfilerBundle:Profiler:ajax_layout.html.twig' : 'WebProfilerBundle:Profiler:layout.html.twig' %} {% block toolbar %} {% set icon %}

{% if collector.querycount > 0 %} {% endif %} {% if collector.invalidEntityCount > 0 %} {% endif %} {% endset %} {% set text %} {% endset %} {% include 'WebProfilerBundle:Profiler:toolbar_item.html.twig' with { 'link': profiler_url } %} {% endblock %} {% block menu %}

Doctrine {{ collector.querycount }} {{ '%0.0f'|format(collector.time * 1000) }} ms {% endblock %} {% block panel %} {% if 'explain' == page %} {{ render(controller('DoctrineBundle:Profiler:explain', { 'token': token, 'panel': 'db', 'connectionName': app.request.query.get('connection'), 'query': app.request.query.get('query') })) }} {% else %} {{ block('queries') }} {% endif %} {% endblock %} {% block queries %}

Queries

{% for connection, queries in collector.queries %}

Connection {{ connection }}

{% if queries is empty %}

No queries.

{% else %}

Shrink query {{ query.sql|doctrine_minify_query|raw }}
{{ query.sql|doctrine_pretty_query(i, loop.parent.loop.index)|raw }} Parameters: {{ query.params|yaml_encode }}
[Display runnable query]
Time: {{ '%0.2f'|format(query.executionMS * 1000) }} ms {% if query.explainable %} [ Explain query ] {% else %} This query cannot be explained {% endif %}
{% if query.explainable %}
{% endif %}

{% endif %} {% endfor %}

Database Connections

{% if collector.connections %} {% include 'WebProfilerBundle:Profiler:table.html.twig' with {data: collector.connections} only %} {% else %}

No connections.

{% endif %}

Entity Managers

{% if collector.managers %} {% include 'WebProfilerBundle:Profiler:table.html.twig' with {data: collector.managers} only %} {% else %}

No entity managers.

{% endif %}

Mapping

{% for manager, classes in collector.entities %}

Manager {{ manager }}

{% if classes is empty %}

No loaded entities.

{% else %} {% for class in classes %} {% endfor %}

Class	Mapping errors
{{ class }}	{% if collector.mappingErrors[manager][class] is defined %} {% for error in collector.mappingErrors[manager][class] %} {{ error }} {% endfor %} {% else %} Valid {% endif %}

{% endif %} {% endfor %} {% endblock %}