GET https://entreprise.jeromelaguel.fr/tournois?page=1

Query Metrics

7 Database Queries
5 Different statements
20.85 ms Query time
3 Invalid entities
11 Managed entities

Queries

Group similar statements

# Time Info
1 4.62 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0
Parameters:
[]
2 5.58 ms
SELECT DISTINCT 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, e0_.config_id AS config_id_11, e0_.organisateur_id AS organisateur_id_12, e0_.style_id AS style_id_13 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id LEFT JOIN selection s2_ ON c1_.id = s2_.config_id WHERE e0_.publier = ? ORDER BY c1_.date_debut DESC LIMIT 6
Parameters:
[
  1
]
3 2.06 ms
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id LEFT JOIN selection s2_ ON c1_.id = s2_.config_id WHERE e0_.encours = 1 AND e0_.publier = 1
Parameters:
[]
4 1.76 ms
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
]
5 2.55 ms
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:
[
  2
]
6 1.63 ms
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:
[
  1
]
7 2.65 ms
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
]

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
  • 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\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
  • 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\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.