Query Metrics
3
Database Queries
2
Different statements
5.85 ms
Query time
0
Invalid entities
57
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.01 ms (68.57%) |
1 |
SELECT a0_.id AS id_0, a0_.note AS note_1, a0_.commentaire AS commentaire_2, a0_.categories AS categories_3, a0_.note_plateforme AS note_plateforme_4, a0_.commentaire_plateforme AS commentaire_plateforme_5, a0_.categories_plateforme AS categories_plateforme_6, a0_.consentement_marketing AS consentement_marketing_7, a0_.consentement_marketing_date AS consentement_marketing_date_8, a0_.statut AS statut_9, a0_.statut_plateforme AS statut_plateforme_10, a0_.mis_en_avant AS mis_en_avant_11, a0_.mis_en_avant_plateforme AS mis_en_avant_plateforme_12, a0_.date_moderation AS date_moderation_13, a0_.reponse_organisateur AS reponse_organisateur_14, a0_.date_reponse AS date_reponse_15, a0_.created_at AS created_at_16, a0_.updated_at AS updated_at_17, u1_.id AS id_18, u1_.public_id AS public_id_19, u1_.email AS email_20, u1_.pseudo AS pseudo_21, u1_.licence AS licence_22, u1_.id_dupr AS id_dupr_23, u1_.genre AS genre_24, u1_.nom AS nom_25, u1_.prenom AS prenom_26, u1_.date_de_naissance AS date_de_naissance_27, u1_.ville AS ville_28, u1_.description AS description_29, u1_.telephone AS telephone_30, u1_.instagram AS instagram_31, u1_.linkedin AS linkedin_32, u1_.tiktok AS tiktok_33, u1_.twitter AS twitter_34, u1_.facebook AS facebook_35, u1_.statut AS statut_36, u1_.roles AS roles_37, u1_.password AS password_38, u1_.indicateur AS indicateur_39, u1_.createur AS createur_40, u1_.stripe_account_id AS stripe_account_id_41, u1_.stripe_onboarding_complete AS stripe_onboarding_complete_42, u1_.stripe_account_created_at AS stripe_account_created_at_43, u1_.stripe_account_type AS stripe_account_type_44, u1_.is_admin AS is_admin_45, u1_.commission_defaut AS commission_defaut_46, u1_.dupr_user_token AS dupr_user_token_47, u1_.dupr_refresh_token AS dupr_refresh_token_48, u1_.dupr_token_expires_at AS dupr_token_expires_at_49, u1_.dupr_sso_connected_at AS dupr_sso_connected_at_50, u1_.dupr_rating_singles AS dupr_rating_singles_51, u1_.dupr_rating_doubles AS dupr_rating_doubles_52, u1_.dupr_ratings_updated_at AS dupr_ratings_updated_at_53, u1_.dupr_basic_entitlement AS dupr_basic_entitlement_54, u1_.dupr_entitlement_checked_at AS dupr_entitlement_checked_at_55, u1_.newsletter_consent AS newsletter_consent_56, u1_.newsletter_consent_date AS newsletter_consent_date_57, u1_.traitement_limite AS traitement_limite_58, u1_.traitement_limite_date AS traitement_limite_date_59, u1_.traitement_limite_motif AS traitement_limite_motif_60, e2_.id AS id_61, e2_.ordre_circuit AS ordre_circuit_62, e2_.is_master_final AS is_master_final_63, e2_.sur_invitation AS sur_invitation_64, e2_.points_assiduite AS points_assiduite_65, e2_.titre AS titre_66, e2_.description AS description_67, e2_.creation AS creation_68, e2_.termine AS termine_69, e2_.date_creation AS date_creation_70, e2_.encours AS encours_71, e2_.publier AS publier_72, e2_.inscriptions_ouvertes AS inscriptions_ouvertes_73, e2_.homologuer_fft AS homologuer_fft_74, e2_.demander_id_dupr AS demander_id_dupr_75, e2_.require_dupr_plus AS require_dupr_plus_76, e2_.require_dupr_verified AS require_dupr_verified_77, e2_.inscription_privee AS inscription_privee_78, e2_.code_pin_inscription AS code_pin_inscription_79, e2_.etat_actuel AS etat_actuel_80, e2_.commission_plateforme AS commission_plateforme_81, a0_.auteur_id AS auteur_id_82, a0_.evenement_id AS evenement_id_83, a0_.modere_par_id AS modere_par_id_84, u1_.pays_id AS pays_id_85, u1_.niveau_simple_id AS niveau_simple_id_86, u1_.niveau_double_id AS niveau_double_id_87, u1_.niveau_mixte_id AS niveau_mixte_id_88, e2_.config_id AS config_id_89, e2_.organisateur_id AS organisateur_id_90, e2_.style_id AS style_id_91, e2_.circuit_id AS circuit_id_92 FROM avis a0_ LEFT JOIN `user` u1_ ON a0_.auteur_id = u1_.id LEFT JOIN evenement e2_ ON a0_.evenement_id = e2_.id WHERE a0_.note_plateforme IS NOT NULL AND a0_.statut_plateforme = ? ORDER BY a0_.mis_en_avant DESC, a0_.created_at DESC
Parameters:
[
"valide"
]
|
||||||||||||||||||||||||||||
|
1.84 ms (31.43%) |
2 |
SELECT COUNT(a0_.id) AS sclr_0, AVG(a0_.note_plateforme) AS sclr_1, SUM(CASE WHEN a0_.note_plateforme >= 4 THEN 1 ELSE 0 END) AS sclr_2 FROM avis a0_ WHERE a0_.note_plateforme IS NOT NULL AND a0_.statut_plateforme = ?
Parameters:
[
"valide"
]
|
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\User | 26 |
| App\Entity\Avis | 24 |
| App\Entity\Niveau | 4 |
| App\Entity\Evenement | 1 |
| App\Entity\Config | 1 |
| App\Entity\Style | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Avis | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Niveau | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\Style | No errors. |
| App\Entity\UserSelection | No errors. |
| App\Entity\Payment | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\EvenementInformation | No errors. |
| App\Entity\Playoff | No errors. |