Query Metrics
19
Database Queries
7
Different statements
6.22 ms
Query time
0
Invalid entities
33
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.12 ms (50.14%) |
10 |
SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = ?
Parameters:
[
187
]
|
0.61 ms (9.81%) |
1 |
SELECT count(r0_.id) AS sclr_0 FROM ressources r0_ LEFT JOIN type t1_ ON r0_.type_id = t1_.id LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id LEFT JOIN format f4_ ON r0_.format_id = f4_.id LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id
Parameters:
[] |
0.59 ms (9.44%) |
3 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = ?
Parameters:
[
3
]
|
0.58 ms (9.39%) |
1 |
SELECT t0.id AS id_1, t0.lien AS lien_2, t0.description AS description_3 FROM lien_externe t0
Parameters:
[] |
0.58 ms (9.29%) |
1 |
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.description AS description_2, r0_.fichier AS fichier_3, r0_.updated_at AS updated_at_4, r0_.lien_externe AS lien_externe_5, r0_.type_id AS type_id_6, r0_.categorie_id AS categorie_id_7, r0_.ressource_ephemerides_id AS ressource_ephemerides_id_8, r0_.format_id AS format_id_9 FROM ressources r0_ LEFT JOIN type t1_ ON r0_.type_id = t1_.id LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id LEFT JOIN format f4_ ON r0_.format_id = f4_.id LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id ORDER BY r0_.nom DESC LIMIT 10 OFFSET 80
Parameters:
[] |
0.49 ms (7.81%) |
2 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
7
]
|
0.26 ms (4.12%) |
1 |
SELECT t0.id AS id_1, t0.format AS format_2 FROM format t0 WHERE t0.id = ?
Parameters:
[
71
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Ressource | 10 |
App\Entity\LienExterne | 7 |
App\Entity\NumeroSemaine | 5 |
App\Entity\Ephemeride | 5 |
App\Entity\Categorie | 3 |
App\Entity\Type | 2 |
App\Entity\Format | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\LienExterne | No errors. |
App\Entity\Ressource | No errors. |
App\Entity\Type | No errors. |
App\Entity\NumeroSemaine | No errors. |
App\Entity\Format | No errors. |
App\Entity\Categorie | No errors. |
App\Entity\Ephemeride | No errors. |
App\Entity\Calendrier | No errors. |
App\Entity\EphemerideNote | No errors. |
App\Entity\Topic | No errors. |
App\Entity\Avis | No errors. |
App\Entity\Fichiers | No errors. |