GET https://entreprise.jeromelaguel.fr/

Query Metrics

1 Database Queries
1 Different statements
9.12 ms Query time
3 Invalid entities
8 Managed entities

Queries

Group similar statements

# 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
  • The field 'App\Entity\Promo#prix' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Selection
  • The field 'App\Entity\Selection#prix' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Contact
  • The field App\Entity\Contact#configs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Config#contacts does not contain the required 'inversedBy="configs"' attribute.