Query Metrics
2
Database Queries
2
Different statements
4.02 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.98 ms (74.10%) |
1 |
SELECT e0_.id AS id_0, e0_.ordre_circuit AS ordre_circuit_1, e0_.is_master_final AS is_master_final_2, e0_.sur_invitation AS sur_invitation_3, e0_.points_assiduite AS points_assiduite_4, e0_.titre AS titre_5, e0_.description AS description_6, e0_.creation AS creation_7, e0_.termine AS termine_8, e0_.date_creation AS date_creation_9, e0_.encours AS encours_10, e0_.publier AS publier_11, e0_.homologuer_fft AS homologuer_fft_12, e0_.demander_id_dupr AS demander_id_dupr_13, e0_.etat_actuel AS etat_actuel_14, e0_.commission_plateforme AS commission_plateforme_15, c1_.id AS id_16, c1_.date_debut AS date_debut_17, c1_.fin_inscription AS fin_inscription_18, c1_.nb_joueur AS nb_joueur_19, c1_.date_fin AS date_fin_20, c1_.adresse AS adresse_21, c1_.complement AS complement_22, c1_.cp AS cp_23, c1_.ville AS ville_24, c1_.pays AS pays_25, c1_.map AS map_26, c1_.nb_joueur_max AS nb_joueur_max_27, c1_.nb_equipe_max AS nb_equipe_max_28, c1_.terrain_interieur AS terrain_interieur_29, c1_.terrain_exterieur AS terrain_exterieur_30, c1_.type_balle AS type_balle_31, c1_.nb_joueur_par_equipe AS nb_joueur_par_equipe_32, c1_.montant_repas AS montant_repas_33, c1_.devise AS devise_34, c1_.nb_journee_previsionnel AS nb_journee_previsionnel_35, c1_.prizepool AS prizepool_36, c1_.nb_match_par_rencontre AS nb_match_par_rencontre_37, c1_.datas_victoire AS datas_victoire_38, c1_.points_victoire AS points_victoire_39, c1_.points_defaite AS points_defaite_40, c1_.points_nul AS points_nul_41, c1_.categorie AS categorie_42, p2_.id AS id_43, p2_.url AS url_44, p2_.description AS description_45, p2_.created_at AS created_at_46, p2_.updated_at AS updated_at_47, p2_.nom AS nom_48, p2_.extension AS extension_49, e0_.config_id AS config_id_50, e0_.organisateur_id AS organisateur_id_51, e0_.style_id AS style_id_52, e0_.circuit_id AS circuit_id_53, p2_.evenement_id AS evenement_id_54, p2_.joueur_id AS joueur_id_55 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s3_ ON e0_.style_id = s3_.id LEFT JOIN photo p2_ ON e0_.id = p2_.evenement_id WHERE s3_.nom = ? AND e0_.publier = ? ORDER BY c1_.date_debut DESC LIMIT 6
Parameters:
[ "Circuit" 1 ]
|
||||||||||||||||||||||||||||||
|
1.04 ms (25.90%) |
1 |
SELECT COUNT(DISTINCT e0_.id) AS sclr_0 FROM evenement e0_ INNER JOIN config c1_ ON e0_.config_id = c1_.id INNER JOIN style s2_ ON e0_.style_id = s2_.id WHERE s2_.nom = ? AND e0_.publier = ?
Parameters:
[ "Circuit" 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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Evenement | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\User | No errors. |