{% set group_queries = request.query.getBoolean('group') %}

{% if group_queries %} Grouped Statements {% else %} Queries {% endif %}

{% if not collector.queries %}

No executed queries.

{% else %} {% if group_queries %}

Show all queries

{% else %}

Group similar statements

{% endif %} {% for connection, queries in collector.queries %} {% if collector.connections|length > 1 %}

{{ connection }} connection

{% endif %} {% if queries is empty %}

No database queries were performed.

{% else %} {% if group_queries %} {% set queries = collector.groupedQueries[connection] %} {% endif %} {% if group_queries %} {% else %} {% endif %} {% for i, query in queries %} {% set i = group_queries ? query.index : i %} {% if group_queries %} {% else %} {% endif %} {% endfor %}

Time▼

Count

#▲

Time

Info

{{ '%0.2f'|format(query.executionMS * 1000) }} ms
({{ '%0.2f'|format(query.executionPercent) }}%)

{{ '%0.2f'|format(query.executionMS * 1000) }} ms

Parameters: {{ profiler_dump(query.params, 2) }}

View formatted query {% if query.runnable %} View runnable query {% endif %} {% if query.explainable %} Explain query {% endif %} {% if query.backtrace is defined %} View query backtrace {% endif %}

{% if query.runnable %} {% endif %} {% if query.explainable %}

{% endif %} {% if query.backtrace is defined %}

{% for trace in query.backtrace %} {% endfor %}

#	File/Call
{{ loop.index }}	{% set line_number = trace.line\|default(1) %} {% if trace.file is defined %} {% endif %} {{- trace.class\|default ~ (trace.class is defined ? trace.type\|default('::')) -}} {{ trace.function }} {% if trace.file is defined %} {% endif %} (line {{ line_number }})

{% endif %}

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

Database Connections

{% if not collector.connections %}

There are no configured database connections.

{% else %} {{ helper.render_simple_table('Name', 'Service', collector.connections) }} {% endif %}

Entity Managers

{% if not collector.managers %}

There are no configured entity managers.

{% else %} {{ helper.render_simple_table('Name', 'Service', collector.managers) }} {% endif %}

Second Level Cache

{% if not collector.cacheEnabled %}

Second Level Cache is not enabled.

{% else %} {% if not collector.cacheCounts %}

Second level cache information is not available.

{% else %}

{{ collector.cacheCounts.hits }} Hits

{{ collector.cacheCounts.misses }} Misses

{{ collector.cacheCounts.puts }} Puts

{% if collector.cacheRegions.hits %}

Number of cache hits

{{ helper.render_simple_table('Region', 'Hits', collector.cacheRegions.hits) }} {% endif %} {% if collector.cacheRegions.misses %}

Number of cache misses

{{ helper.render_simple_table('Region', 'Misses', collector.cacheRegions.misses) }} {% endif %} {% if collector.cacheRegions.puts %}

Number of cache puts

{{ helper.render_simple_table('Region', 'Puts', collector.cacheRegions.puts) }} {% endif %} {% endif %} {% endif %}

Entities Mapping

{% if not collector.entities %}

No mapped entities.

{% else %} {% for manager, classes in collector.entities %} {% if collector.managers|length > 1 %}

{{ manager }} entity manager

{% endif %} {% if classes is empty %}

No loaded entities.

{% else %} {% for class in classes %} {% set contains_errors = collector.mappingErrors[manager] is defined and collector.mappingErrors[manager][class.class] is defined %} {% endfor %}

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