Query Metrics

10 Database Queries
4 Different statements
52.52 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 3.37 ms
SELECT r0_.id AS id_0, r0_.comment AS comment_1, r0_.note AS note_2, r0_.answer AS answer_3, r0_.published AS published_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.user AS user_7 FROM review r0_ WHERE r0_.published = ? ORDER BY r0_.updated_at DESC LIMIT 30
Parameters:
[
  1
]
2 10.97 ms
SELECT AVG(r0_.note) AS sclr_0 FROM review r0_
Parameters:
[]
3 7.62 ms
SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_
Parameters:
[]
4 6.14 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "google.verif_tag.enabled"
]
5 3.11 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "bing.verif_tag.enabled"
]
6 6.88 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "cookiebot.id"
]
7 5.16 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "matomo.url"
]
8 3.16 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "kameleoon_ab_testing.enabled"
]
9 3.05 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "tracking.tag_manager"
]
10 3.06 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "yandex_metrica.enabled"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
tarif doctrine.dbal.tarif_connection
autovista doctrine.dbal.autovista_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Review No errors.
FOS\UserBundle\Model\User No errors.
App\Entity\User No errors.
App\Entity\Parameter No errors.