https://cimef-international.org/mediatheque/albums

Query Metrics

5 Database Queries
5 Different statements
4.53 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.18 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.statut AS statut_3, a0_.adminsid AS adminsid_4, a0_.createdat AS createdat_5, a0_.updatedat AS updatedat_6, a0_.nom AS nom_7, a0_.slug AS slug_8, MIN(g1_.img_gal) AS sclr_9 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = ? GROUP BY a0_.id ORDER BY a0_.createdat DESC
Parameters:
[
  "Publié"
]
2 0.73 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = ? GROUP BY a0_.id
Parameters:
[
  "Publié"
]
3 0.54 ms
SELECT DISTINCT a0_.id AS id_0, a0_.createdat AS createdat_1 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = ? GROUP BY a0_.id ORDER BY a0_.createdat DESC LIMIT 12
Parameters:
[
  "Publié"
]
4 0.64 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.statut AS statut_3, a0_.adminsid AS adminsid_4, a0_.createdat AS createdat_5, a0_.updatedat AS updatedat_6, a0_.nom AS nom_7, a0_.slug AS slug_8, MIN(g1_.img_gal) AS sclr_9 FROM albums a0_ INNER JOIN galeries g1_ ON (a0_.slug = g1_.nom) WHERE a0_.statut = ? AND a0_.id IN (?, ?) GROUP BY a0_.id ORDER BY a0_.createdat DESC
Parameters:
[
  "Publié"
  4
  3
]
5 0.44 ms
SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_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\Albums No errors.
App\Entity\Galeries No errors.
App\Entity\Mentions No errors.