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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
2.23 ms
(39.93%)
1
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, MIN(g1_.img_gal) AS sclr_7 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é"
]
1.30 ms
(23.29%)
1
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, MIN(g1_.img_gal) AS sclr_7 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é"
  18
  17
  16
  15
  14
  13
  11
  9
  4
  3
]
0.94 ms
(16.82%)
1
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é"
]
0.82 ms
(14.74%)
1
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é"
]
0.29 ms
(5.22%)
1
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.