GET https://damien.preprod.tournoispickleball.fr/tournois?page=1

Response
200 OK
IP
216.73.217.62
Profiled on
Token
5ba72a

Query Metrics

5 Database Queries
4 Different statements
2.98 ms Query time
3 Invalid entities
11 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.44 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM age t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.95 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, 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
]
View formatted query    View runnable query    Explain query
3 0.60 ms 
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: 
[]
View formatted query    View runnable query    Explain query
4 0.56 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
]
View formatted query    View runnable query    Explain query
5 0.43 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
]
View formatted query    View runnable query    Explain query

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.