Query Metrics
14
Database Queries
7
Different statements
4.36 ms
Query time
0
Invalid entities
28
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.56 ms |
SELECT t0.id AS id_1, t0.lien AS lien_2, t0.description AS description_3 FROM lien_externe t0
Parameters:
[] |
2 | 0.58 ms |
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:
[] |
3 | 0.57 ms |
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 LIMIT 10 OFFSET 210
Parameters:
[] |
4 | 0.45 ms |
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:
[
250
]
|
5 | 0.21 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = ?
Parameters:
[
6
]
|
6 | 0.19 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
8
]
|
7 | 0.19 ms |
SELECT t0.id AS id_1, t0.format AS format_2 FROM format t0 WHERE t0.id = ?
Parameters:
[
75
]
|
8 | 0.27 ms |
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:
[
251
]
|
9 | 0.27 ms |
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:
[
252
]
|
10 | 0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = ?
Parameters:
[
3
]
|
11 | 0.18 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type t0 WHERE t0.id = ?
Parameters:
[
7
]
|
12 | 0.26 ms |
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:
[
253
]
|
13 | 0.27 ms |
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:
[
254
]
|
14 | 0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\LienExterne | 7 |
App\Entity\Ressource | 5 |
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. |