Query Metrics
7
Database Queries
5
Different statements
3.09 ms
Query time
4
Invalid entities
14
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.88 ms (28.57%) |
3 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3 FROM information t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.73 ms (23.46%) |
1 |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.fin_inscription AS fin_inscription_3, t0.nb_joueur AS nb_joueur_4, t0.date_fin AS date_fin_5, t0.adresse AS adresse_6, t0.complement AS complement_7, t0.cp AS cp_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.map AS map_11, t0.nb_joueur_max AS nb_joueur_max_12, t0.nb_equipe_max AS nb_equipe_max_13, t0.terrain_interieur AS terrain_interieur_14, t0.terrain_exterieur AS terrain_exterieur_15, t0.type_balle AS type_balle_16, t0.nb_joueur_par_equipe AS nb_joueur_par_equipe_17, t0.montant_repas AS montant_repas_18, t0.devise AS devise_19, t0.nb_journee_previsionnel AS nb_journee_previsionnel_20, t0.prizepool AS prizepool_21, t0.nb_match_par_rencontre AS nb_match_par_rencontre_22, t0.datas_victoire AS datas_victoire_23, t0.points_victoire AS points_victoire_24, t0.points_defaite AS points_defaite_25, t0.points_nul AS points_nul_26, t0.categorie AS categorie_27, t28.id AS id_29, t28.titre AS titre_30, t28.description AS description_31, t28.creation AS creation_32, t28.termine AS termine_33, t28.date_creation AS date_creation_34, t28.encours AS encours_35, t28.publier AS publier_36, t28.homologuer_fft AS homologuer_fft_37, t28.demander_id_dupr AS demander_id_dupr_38, t28.etat_actuel AS etat_actuel_39, t28.config_id AS config_id_40, t28.organisateur_id AS organisateur_id_41, t28.style_id AS style_id_42 FROM config t0 LEFT JOIN evenement t28 ON t28.config_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.61 ms (19.84%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.creation AS creation_4, t0.termine AS termine_5, t0.date_creation AS date_creation_6, t0.encours AS encours_7, t0.publier AS publier_8, t0.homologuer_fft AS homologuer_fft_9, t0.demander_id_dupr AS demander_id_dupr_10, t0.etat_actuel AS etat_actuel_11, t0.config_id AS config_id_12, t0.organisateur_id AS organisateur_id_13, t0.style_id AS style_id_14 FROM evenement t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.48 ms (15.41%) |
1 |
SELECT t0.id AS id_1, t0.licence AS licence_2, t0.email AS email_3, t0.telephone AS telephone_4, t0.fonction AS fonction_5 FROM contact t0 INNER JOIN contact_config ON t0.id = contact_config.contact_id WHERE contact_config.config_id = ?
Parameters:
[
1
]
|
|
0.39 ms (12.72%) |
1 |
SELECT t0.id AS id_1, t0.information_id AS information_id_2, t0.evenement_id AS evenement_id_3 FROM evenement_information t0 WHERE t0.evenement_id = ?
Parameters:
[
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Contact | 4 |
| App\Entity\EvenementInformation | 3 |
| App\Entity\Information | 3 |
| App\Entity\Evenement | 1 |
| App\Entity\Config | 1 |
| App\Entity\User | 1 |
| App\Entity\Style | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Evenement | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\EvenementInformation | No errors. |
| App\Entity\Playoff | No errors. |
| App\Entity\Promo |
|
| App\Entity\Selection |
|
| App\Entity\Contact |
|
| App\Entity\Information |
|