Query Metrics
1
Database Queries
1
Different statements
9.12 ms
Query time
3
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 9.12 ms |
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, p1_.id AS id_11, p1_.url AS url_12, p1_.description AS description_13, p1_.created_at AS created_at_14, p1_.updated_at AS updated_at_15, p1_.nom AS nom_16, p1_.extension AS extension_17, c2_.id AS id_18, c2_.date_debut AS date_debut_19, c2_.fin_inscription AS fin_inscription_20, c2_.nb_joueur AS nb_joueur_21, c2_.date_fin AS date_fin_22, c2_.adresse AS adresse_23, c2_.complement AS complement_24, c2_.cp AS cp_25, c2_.ville AS ville_26, c2_.pays AS pays_27, c2_.map AS map_28, c2_.nb_joueur_max AS nb_joueur_max_29, c2_.nb_equipe_max AS nb_equipe_max_30, c2_.terrain_interieur AS terrain_interieur_31, c2_.terrain_exterieur AS terrain_exterieur_32, c2_.type_balle AS type_balle_33, c2_.nb_joueur_par_equipe AS nb_joueur_par_equipe_34, c2_.montant_repas AS montant_repas_35, c2_.devise AS devise_36, c2_.nb_journee_previsionnel AS nb_journee_previsionnel_37, c2_.prizepool AS prizepool_38, c2_.nb_match_par_rencontre AS nb_match_par_rencontre_39, c2_.datas_victoire AS datas_victoire_40, c2_.points_victoire AS points_victoire_41, c2_.points_defaite AS points_defaite_42, c2_.points_nul AS points_nul_43, c2_.categorie AS categorie_44, e0_.config_id AS config_id_45, e0_.organisateur_id AS organisateur_id_46, e0_.style_id AS style_id_47, p1_.evenement_id AS evenement_id_48, p1_.joueur_id AS joueur_id_49 FROM evenement e0_ LEFT JOIN photo p1_ ON e0_.id = p1_.evenement_id LEFT JOIN config c2_ ON e0_.config_id = c2_.id WHERE e0_.etat_actuel IN (?, ?, ?, ?, ?, ?, ?, ?) AND e0_.publier = ? ORDER BY c2_.date_debut ASC
Parameters:
[ "inscriptions_ouvertes" "inscriptions_closes" "poules_generees" "planning_en_cours" "planning_etabli" "matchs_en_cours" "poules_terminees" "phases_finales_generees" 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\Evenement | 2 |
| App\Entity\Photo | 2 |
| App\Entity\Config | 2 |
| App\Entity\User | 1 |
| App\Entity\Style | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Evenement | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\EvenementInformation | No errors. |
| App\Entity\Playoff | No errors. |
| App\Entity\Promo |
|
| App\Entity\Selection |
|
| App\Entity\Contact |
|