Query Metrics
5
Database Queries
4
Different statements
4.13 ms
Query time
3
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.48 ms (35.81%) |
1 |
SELECT e0_.id AS id_0, e0_.titre AS titre_1, e0_.description AS description_2, e0_.creation AS creation_3, e0_.termine AS termine_4, e0_.date_creation AS date_creation_5, e0_.encours AS encours_6, e0_.publier AS publier_7, e0_.homologuer_fft AS homologuer_fft_8, e0_.demander_id_dupr AS demander_id_dupr_9, e0_.etat_actuel AS etat_actuel_10, c1_.id AS id_11, c1_.date_debut AS date_debut_12, c1_.fin_inscription AS fin_inscription_13, c1_.nb_joueur AS nb_joueur_14, c1_.date_fin AS date_fin_15, c1_.adresse AS adresse_16, c1_.complement AS complement_17, c1_.cp AS cp_18, c1_.ville AS ville_19, c1_.pays AS pays_20, c1_.map AS map_21, c1_.nb_joueur_max AS nb_joueur_max_22, c1_.nb_equipe_max AS nb_equipe_max_23, c1_.terrain_interieur AS terrain_interieur_24, c1_.terrain_exterieur AS terrain_exterieur_25, c1_.type_balle AS type_balle_26, c1_.nb_joueur_par_equipe AS nb_joueur_par_equipe_27, c1_.montant_repas AS montant_repas_28, c1_.devise AS devise_29, c1_.nb_journee_previsionnel AS nb_journee_previsionnel_30, c1_.prizepool AS prizepool_31, c1_.nb_match_par_rencontre AS nb_match_par_rencontre_32, c1_.datas_victoire AS datas_victoire_33, c1_.points_victoire AS points_victoire_34, c1_.points_defaite AS points_defaite_35, c1_.points_nul AS points_nul_36, c1_.categorie AS categorie_37, e0_.config_id AS config_id_38, e0_.organisateur_id AS organisateur_id_39, e0_.style_id AS style_id_40 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id WHERE e0_.publier = ? ORDER BY c1_.date_debut DESC LIMIT 6
Parameters:
[
1
]
|
|
1.17 ms (28.22%) |
2 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.nom AS nom_6, t0.extension AS extension_7, t0.evenement_id AS evenement_id_8, t0.joueur_id AS joueur_id_9 FROM photo t0 WHERE t0.evenement_id = ?
Parameters:
[
2
]
|
|
0.85 ms (20.53%) |
1 |
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id WHERE e0_.encours = 1 AND e0_.publier = 1
Parameters:
[] |
|
0.64 ms (15.45%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0
Parameters:
[] |
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\Age | 3 |
| App\Entity\Evenement | 2 |
| App\Entity\Config | 2 |
| App\Entity\Photo | 2 |
| App\Entity\User | 1 |
| App\Entity\Style | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Age | No errors. |
| App\Entity\Selection |
|
| 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\Contact |
|