Query Metrics
3
Database Queries
3
Different statements
7.99 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.58 ms (69.89%) |
1 |
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE ? OR m0_.categorie LIKE ? OR m0_.legende LIKE ? OR m0_.title LIKE ? OR a1_.nom LIKE ? OR a1_.prenom LIKE ? OR p3_.texte LIKE ?)) ORDER BY m0_.date_crea DESC
Parameters:
[ "%amstrong%" "%amstrong%" "%amstrong%" "%amstrong%" "%amstrong%" "%amstrong%" "%amstrong%" ]
|
||||||||||||||||||||||||||||
|
1.44 ms (18.05%) |
1 |
SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE ? ORDER BY n0_.date_crea DESC
Parameters:
[
"%amstrong%"
]
|
||||||||||||||||||||||||||||
|
0.96 ms (12.06%) |
1 |
SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE ? ORDER BY p0_.date_crea DESC
Parameters:
[
"%amstrong%"
]
|
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Medias | No errors. |
| App\Entity\Auteurs | No errors. |
| App\Entity\Paroles | No errors. |
| App\Entity\News | No errors. |