Query Metrics
18
Database Queries
13
Different statements
25.24 ms
Query time
7
Invalid entities
20
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
9.76 ms (38.68%) |
1 |
SELECT m0_.id AS id_0, m0_.idtoken AS idtoken_1, m0_.titre AS titre_2, m0_.contenu AS contenu_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.deleted AS deleted_6, m0_.societe_id AS societe_id_7, m0_.projet_id AS projet_id_8, m0_.created_by_id AS created_by_id_9, m0_.updated_by_id AS updated_by_id_10 FROM modele m0_ WHERE m0_.deleted = ? AND m0_.projet_id = ?
Parameters:
[ 0 5 ]
|
||||||||||||||||||||||||||||||||
|
4.48 ms (17.76%) |
6 |
SELECT a0_.id AS id_0, a0_.context_token AS context_token_1, a0_.kind AS kind_2, a0_.all_projects AS all_projects_3, a0_.permissions AS permissions_4, a0_.business_role AS business_role_5, a0_.status AS status_6, a0_.professional_email AS professional_email_7, a0_.active_scope_key AS active_scope_key_8, a0_.created_at AS created_at_9, a0_.accepted_at AS accepted_at_10, a0_.expires_at AS expires_at_11, a0_.revoked_at AS revoked_at_12, a0_.user_id AS user_id_13, a0_.organization_id AS organization_id_14, a0_.partner_id AS partner_id_15, a0_.project_id AS project_id_16, a0_.contact_profile_id AS contact_profile_id_17, a0_.created_by_id AS created_by_id_18 FROM access_membership a0_ WHERE a0_.user_id = ? AND a0_.context_token = ? AND a0_.status = ? AND ((a0_.expires_at IS NULL OR a0_.expires_at > ?))
Parameters:
[ 222 "dabbdce6ed13458f4c72c6d3e93632629d3fcc197d052efefa61ae1042292582" "active" "2026-10-06 13:15:30" ] |
||||||||||||||||||||||||||||||||
|
1.76 ms (6.98%) |
1 |
SELECT p0_.id AS id_0, p0_.idtoken AS idtoken_1, p0_.cle AS cle_2, p0_.valeur AS valeur_3, p0_.projet_id AS projet_id_4 FROM parametre_projet p0_ WHERE p0_.projet_id = ? AND p0_.cle = ?
Parameters:
[ 5 "customConventionDates" ]
|
||||||||||||||||||||||||||||||||
|
1.55 ms (6.16%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_commercial AS nom_commercial_3, t0.type AS type_4, t0.adresse AS adresse_5, t0.code_postal AS code_postal_6, t0.ville AS ville_7, t0.pays AS pays_8, t0.email AS email_9, t0.telephone AS telephone_10, t0.site AS site_11, t0.linkedin AS linkedin_12, t0.siren AS siren_13, t0.siret AS siret_14, t0.numero_tva AS numero_tva_15, t0.naf AS naf_16, t0.numero_rcs AS numero_rcs_17, t0.registre_commerce AS registre_commerce_18, t0.capital AS capital_19, t0.logo AS logo_20, t0.logo_crop AS logo_crop_21, t0.idtoken AS idtoken_22, t0.presentation AS presentation_23, t0.deleted AS deleted_24, t0.forme_juridique_id AS forme_juridique_id_25, t0.contact_id AS contact_id_26, t27.id AS id_28, t27.capsule_client_id AS capsule_client_id_29, t27.nom AS nom_30, t27.adresse AS adresse_31, t27.code_postal AS code_postal_32, t27.ville AS ville_33, t27.pays AS pays_34, t27.email AS email_35, t27.telephone AS telephone_36, t27.site AS site_37, t27.siren AS siren_38, t27.siret AS siret_39, t27.tva AS tva_40, t27.rcs AS rcs_41, t27.numero_rcs AS numero_rcs_42, t27.capital AS capital_43, t27.numero_tva AS numero_tva_44, t27.logo AS logo_45, t27.logo_crop AS logo_crop_46, t27.token AS token_47, t27.type_societe AS type_societe_48, t27.objet AS objet_49, t27.autre AS autre_50, t27.signature AS signature_51, t27.signature_auto AS signature_auto_52, t27.linkedin AS linkedin_53, t27.presentation AS presentation_54, t27.date1 AS date1_55, t27.date2 AS date2_56, t27.date3 AS date3_57, t27.deleted AS deleted_58, t27.mecene AS mecene_59, t27.dossier AS dossier_60, t27.is_trial AS is_trial_61, t27.trial_ends_at AS trial_ends_at_62, t27.stripe_customer_id AS stripe_customer_id_63, t27.stripe_subscription_id AS stripe_subscription_id_64, t27.subscription_status AS subscription_status_65, t27.current_period_ends_at AS current_period_ends_at_66, t27.has_valid_subscription AS has_valid_subscription_67, t27.quota_user AS quota_user_68, t27.quota_partner AS quota_partner_69, t27.created_at AS created_at_70, t27.forme_juridique_id AS forme_juridique_id_71, t27.contact_id AS contact_id_72, t27.linked_mecene_id AS linked_mecene_id_73, t27.banque_id AS banque_id_74, t27.pack_id AS pack_id_75, t27.type_id AS type_id_76, t27.sub_category_id AS sub_category_id_77, t27.departement_id AS departement_id_78, t27.secteur_id AS secteur_id_79, t0.secteur_id AS secteur_id_80, t0.departement_id AS departement_id_81 FROM mecene t0 LEFT JOIN societe t27 ON t27.linked_mecene_id = t0.id WHERE t0.id = ?
Parameters:
[
28
]
|
||||||||||||||||||||||||||||||||
|
1.25 ms (4.94%) |
1 |
SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.type AS type_3, t0.nom AS nom_4, t0.valeur AS valeur_5, t0.amount_input_mode AS amount_input_mode_6, t0.donation_amount_mode AS donation_amount_mode_7, t0.donation_rounding AS donation_rounding_8, t0.sponsoring_base_amount AS sponsoring_base_amount_9, t0.sponsoring_base_vat_rate AS sponsoring_base_vat_rate_10, t0.sponsoring_vat_breakdown AS sponsoring_vat_breakdown_11, t0.vat_rate AS vat_rate_12, t0.amount_ht AS amount_ht_13, t0.amount_vat AS amount_vat_14, t0.amount_ttc AS amount_ttc_15, t0.deduction_fiscale AS deduction_fiscale_16, t0.description AS description_17, t0.personnalise AS personnalise_18, t0.flex AS flex_19, t0.valeur_contrepartie AS valeur_contrepartie_20, t0.valeur_utilisee AS valeur_utilisee_21, t0.compliance_status AS compliance_status_22, t0.compliance_summary AS compliance_summary_23, t0.compliance_analyzed_at AS compliance_analyzed_at_24, t0.compliance_issues AS compliance_issues_25, t0.compliance_ratio AS compliance_ratio_26, t0.compliance_counterpart_value AS compliance_counterpart_value_27, t0.compliance_formula_amount AS compliance_formula_amount_28, t0.compliance_checked_at AS compliance_checked_at_29, t0.created_at AS created_at_30, t0.deleted AS deleted_31, t0.societe_id AS societe_id_32, t0.projet_id AS projet_id_33, t0.niveau_id AS niveau_id_34 FROM formule t0 WHERE t0.id = ?
Parameters:
[
37
]
|
||||||||||||||||||||||||||||||||
|
1.19 ms (4.73%) |
1 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.deadline AS deadline_6, t0.statut AS statut_7, t0.created_at AS created_at_8, t0.objectif_financier AS objectif_financier_9, t0.montant_prevu AS montant_prevu_10, t0.montant_recu AS montant_recu_11, t0.archive AS archive_12, t0.logo AS logo_13, t0.affiche AS affiche_14, t0.presentation_file_path AS presentation_file_path_15, t0.presentation_file_original_name AS presentation_file_original_name_16, t0.presentation_file_size AS presentation_file_size_17, t0.presentation_file_mime_type AS presentation_file_mime_type_18, t0.presentation_file_uploaded_at AS presentation_file_uploaded_at_19, t0.visuel_principal AS visuel_principal_20, t0.public AS public_21, t0.deleted AS deleted_22, t0.idtoken AS idtoken_23, t0.gains AS gains_24, t0.depenses AS depenses_25, t0.import_convention AS import_convention_26, t0.import_formule AS import_formule_27, t0.import_modele AS import_modele_28, t0.import_contrepartie AS import_contrepartie_29, t0.import AS import_30, t0.edition_label AS edition_label_31, t0.edition_number AS edition_number_32, t0.reopened_at AS reopened_at_33, t0.reopen_reason AS reopen_reason_34, t0.created_by_id AS created_by_id_35, t0.presentation_file_uploaded_by_id AS presentation_file_uploaded_by_id_36, t0.societe_id AS societe_id_37, t0.signataire_id AS signataire_id_38, t0.responsable_id AS responsable_id_39, t0.parent_id AS parent_id_40, t0.presentation_id AS presentation_id_41, t0.espace_id AS espace_id_42, t43.id AS id_44, t43.is_enabled AS is_enabled_45, t43.welcome_message AS welcome_message_46, t43.created_at AS created_at_47, t43.updated_at AS updated_at_48, t43.project_id AS project_id_49, t0.edition_series_id AS edition_series_id_50, t0.previous_edition_id AS previous_edition_id_51, t0.next_edition_id AS next_edition_id_52 FROM projet t0 LEFT JOIN project_onboarding t43 ON t43.project_id = t0.id WHERE t0.id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
|
0.93 ms (3.70%) |
1 |
SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.code AS code_2, p0_.title AS title_3, p0_.summary AS summary_4, p0_.content AS content_5, p0_.slides AS slides_6, p0_.form_definition AS form_definition_7, p0_.status AS status_8, p0_.priority AS priority_9, p0_.starts_at AS starts_at_10, p0_.ends_at AS ends_at_11, p0_.published_at AS published_at_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p1_.id AS id_15, p1_.audience AS audience_16, p1_.mode AS mode_17, p1_.form_handler_key AS form_handler_key_18, p1_.submit_label AS submit_label_19, p1_.required_capability AS required_capability_20, p1_.targeting_configuration AS targeting_configuration_21, p1_.content_override AS content_override_22, p1_.created_at AS created_at_23, p1_.updated_at AS updated_at_24, p0_.created_by_id AS created_by_id_25, p1_.platform_update_id AS platform_update_id_26 FROM platform_update p0_ INNER JOIN platform_update_audience_configuration p1_ ON p0_.id = p1_.platform_update_id AND (p1_.audience = ?) LEFT JOIN organizer_update_completion o2_ ON (o2_.platform_update_id = p0_.id AND o2_.company_id = ? AND o2_.status = ?) WHERE p0_.status = ? AND (p0_.starts_at IS NULL OR p0_.starts_at <= ?) AND (p0_.ends_at IS NULL OR p0_.ends_at > ?) AND o2_.id IS NULL ORDER BY p0_.priority DESC, p0_.published_at ASC, p0_.id ASC, p1_.audience ASC
Parameters:
[ "organizer" 2 "completed" "published" "2026-10-06 13:15:30" "2026-10-06 13:15:30" ] |
||||||||||||||||||||||||||||||||
|
0.83 ms (3.30%) |
1 |
SELECT t0.id AS id_1, t0.idtoken AS idtoken_2, t0.numero AS numero_3, t0.valeur AS valeur_4, t0.formula_amount_input_mode AS formula_amount_input_mode_5, t0.formula_input_amount AS formula_input_amount_6, t0.formula_vat_rate AS formula_vat_rate_7, t0.formula_vat_breakdown AS formula_vat_breakdown_8, t0.formula_amount_ht AS formula_amount_ht_9, t0.formula_amount_vat AS formula_amount_vat_10, t0.formula_amount_ttc AS formula_amount_ttc_11, t0.formula_donation_amount AS formula_donation_amount_12, t0.apport_financier AS apport_financier_13, t0.apport_nature AS apport_nature_14, t0.apport_financier_recu AS apport_financier_recu_15, t0.apport_nature_recu AS apport_nature_recu_16, t0.note AS note_17, t0.mode_realisation_don AS mode_realisation_don_18, t0.don_description AS don_description_19, t0.created_at AS created_at_20, t0.start_date AS start_date_21, t0.end_date AS end_date_22, t0.duration_value AS duration_value_23, t0.duration_unit AS duration_unit_24, t0.period_mode AS period_mode_25, t0.period_requires_regeneration AS period_requires_regeneration_26, t0.schedule_requires_recalculation AS schedule_requires_recalculation_27, t0.paiement_recu AS paiement_recu_28, t0.signature_document AS signature_document_29, t0.statut AS statut_30, t0.avancement AS avancement_31, t0.progression AS progression_32, t0.deleted AS deleted_33, t0.allow_partner_flex_edit_after_signature AS allow_partner_flex_edit_after_signature_34, t0.compliance_status AS compliance_status_35, t0.compliance_summary AS compliance_summary_36, t0.compliance_analyzed_at AS compliance_analyzed_at_37, t0.date_derniere_relance AS date_derniere_relance_38, t0.societe_id AS societe_id_39, t0.projet_id AS projet_id_40, t0.mecene_id AS mecene_id_41, t0.referent_contact_id AS referent_contact_id_42, t0.adresse_convention_id AS adresse_convention_id_43, t0.formule_id AS formule_id_44, t0.niveau_id AS niveau_id_45, t0.type_id AS type_id_46, t0.parent_id AS parent_id_47, t0.created_by_id AS created_by_id_48, t0.document_id AS document_id_49, t0.recu_id AS recu_id_50 FROM convention t0 WHERE t0.id = ?
Parameters:
[
"32"
]
|
||||||||||||||||||||||||||||||||
|
0.79 ms (3.14%) |
1 |
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.qrcode AS qrcode_5, t0.qr_token AS qr_token_6, t0.user_type AS user_type_7, t0.is_admin AS is_admin_8, t0.email AS email_9, t0.password AS password_10, t0.image AS image_11, t0.signature_path AS signature_path_12, t0.signature_uploaded_at AS signature_uploaded_at_13, t0.signature_auto_enabled AS signature_auto_enabled_14, t0.statut AS statut_15, t0.fonction AS fonction_16, t0.adresse AS adresse_17, t0.code_postal AS code_postal_18, t0.ville AS ville_19, t0.pays AS pays_20, t0.telephone AS telephone_21, t0.token AS token_22, t0.deleted AS deleted_23, t0.archive AS archive_24, t0.telephone_fixe AS telephone_fixe_25, t0.entreprise AS entreprise_26, t0.linkedin AS linkedin_27, t0.siteweb AS siteweb_28, t0.idtoken AS idtoken_29, t0.role_id AS role_id_30, t0.mecene_id AS mecene_id_31, t0.soc_id AS soc_id_32 FROM user t0 WHERE t0.id = ?
Parameters:
[
222
]
|
||||||||||||||||||||||||||||||||
|
0.74 ms (2.92%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.metadata AS metadata_4, t0.user_id AS user_id_5 FROM parametre_user t0 WHERE t0.user_id = ? AND t0.type = ? LIMIT 1
Parameters:
[ 222 "accept_cgu" ] |
||||||||||||||||||||||||||||||||
|
0.68 ms (2.68%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = ?
Parameters:
[
222
]
|
||||||||||||||||||||||||||||||||
|
0.65 ms (2.56%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.permissions AS permissions_3, t0.deleted AS deleted_4, t0.idtoken AS idtoken_5, t0.societe_id AS societe_id_6 FROM role t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.62 ms (2.46%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.groupe AS groupe_4 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_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\Bundle\AppBundle\Entity\User | 2 |
| App\Bundle\ProjetBundle\Entity\Projet | 2 |
| App\Bundle\ProjetBundle\Entity\Modele | 2 |
| App\Bundle\AppBundle\Entity\Role | 1 |
| App\Bundle\AdminBundle\Entity\Societe | 1 |
| App\Bundle\AppBundle\Entity\ParametreUser | 1 |
| App\Bundle\AppBundle\Entity\AccessMembership | 1 |
| App\Bundle\ProjetBundle\Entity\Convention | 1 |
| App\Bundle\ProjetBundle\Entity\Mecene | 1 |
| App\Bundle\ProjetBundle\Entity\MeceneAdresse | 1 |
| App\Bundle\ProjetBundle\Entity\Formule | 1 |
| App\Bundle\ProjetBundle\Entity\NiveauMecenat | 1 |
| App\Bundle\ProjetBundle\Entity\TypeMecenat | 1 |
| App\Bundle\PortailBundle\Entity\Espace | 1 |
| App\Bundle\ProjetBundle\Entity\ProjectEditionSeries | 1 |
| App\Bundle\AdminBundle\Entity\FormeJuridique | 1 |
| App\Bundle\AdminBundle\Entity\SecteurActivite | 1 |