Query Metrics
1
Database Queries
1
Different statements
6.16 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6.16 ms (100.00%) |
1 |
SELECT p0_.id AS id_0, p0_.jour AS jour_1, p0_.source AS source_2, p0_.description AS description_3, p0_.compteur AS compteur_4, p0_.favori AS favori_5, p0_.publication AS publication_6, p0_.titre AS titre_7, p0_.uuid AS uuid_8, p0_.search_titre AS search_titre_9, p0_.search_description AS search_description_10, p0_.duree AS duree_11, e1_.id AS id_12, e1_.titre AS titre_13, e1_.description AS description_14, e1_.slug AS slug_15, e1_.image AS image_16, e1_.publication AS publication_17, e1_.images AS images_18, t2_.id AS id_19, t2_.nom AS nom_20, t2_.slug AS slug_21, p0_.emission_id AS emission_id_22 FROM podcast p0_ INNER JOIN emission e1_ ON p0_.emission_id = e1_.id LEFT JOIN podcast_theme p3_ ON p0_.id = p3_.podcast_id LEFT JOIN theme t2_ ON t2_.id = p3_.theme_id WHERE e1_.slug = ? AND p0_.publication = ? ORDER BY p0_.jour DESC, t2_.nom ASC LIMIT 1
Parameters:
[ "bonjour-charisma" 1 ]
|
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\Podcast | No errors. |
App\Entity\Emission | No errors. |
App\Entity\Theme | No errors. |