Symfony Profiler

Query Metrics

34 Database Queries
17 Different statements
8.83 ms Query time
1 Invalid entities
Queries


SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date_last_update AS date_last_update_2, t0.bases AS bases_3, t0.infos_given_to_intern AS infos_given_to_intern_4, t0.infos_required_from_intern AS infos_required_from_intern_5, t0.health AS health_6, t0.health_general_principles AS health_general_principles_7, t0.health_fire_instructions AS health_fire_instructions_8, t0.health_alcohol AS health_alcohol_9, t0.health_smoke AS health_smoke_10, t0.health_animals AS health_animals_11, t0.health_accident AS health_accident_12, t0.general_discipline_follow_up AS general_discipline_follow_up_13, t0.general_discipline_attendance AS general_discipline_attendance_14, t0.general_discipline_offices_access AS general_discipline_offices_access_15, t0.general_discipline_dress AS general_discipline_dress_16, t0.general_discipline_behaviour AS general_discipline_behaviour_17, t0.general_discipline_use_equipment AS general_discipline_use_equipment_18, t0.general_discipline_participation AS general_discipline_participation_19, t0.general_discipline_copyright AS general_discipline_copyright_20, t0.discipline_penalties AS discipline_penalties_21, t0.representation_interns AS representation_interns_22, t0.publication_internal_rules AS publication_internal_rules_23, t0.complaints_procedure AS complaints_procedure_24, t0.file_path AS file_path_25, t0.organization_id AS organization_id_26 FROM internal_rules t0 WHERE t0.organization_id = ?
SELECT t0.id AS id_1, t0.date_last_update AS date_last_update_2, t0.context AS context_3, t0.definition AS definition_4, t0.commitment AS commitment_5, t0.identifying_needs AS identifying_needs_6, t0.adaptations AS adaptations_7, t0.accessibility AS accessibility_8, t0.awareness AS awareness_9, t0.referent AS referent_10, t0.network_partners AS network_partners_11, t0.file_path AS file_path_12, t0.organization_id AS organization_id_13 FROM handicap_policy t0 WHERE t0.organization_id = ?
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.slug AS slug_3, t0.organization_id AS organization_id_4 FROM website t0 WHERE t0.organization_id = ?
SELECT f0_.id AS id_0, f0_.picture_path AS picture_path_1, f0_.name AS name_2, f0_.description AS description_3, f0_.hour_duration AS hour_duration_4, f0_.day_duration AS day_duration_5, f0_.place AS place_6, f0_.intern_profile AS intern_profile_7, f0_.requirements AS requirements_8, f0_.pre_tax_price AS pre_tax_price_9, f0_.including_tax_price AS including_tax_price_10, f0_.tva AS tva_11, f0_.general_goals AS general_goals_12, f0_.training_goals AS training_goals_13, f0_.content AS content_14, f0_.access_terms AS access_terms_15, f0_.learning_resources AS learning_resources_16, f0_.technical_resources AS technical_resources_17, f0_.handicapped_access AS handicapped_access_18, f0_.organization_terms AS organization_terms_19, f0_.full_learning_resources AS full_learning_resources_20, f0_.tracking AS tracking_21, f0_.evaluation_system AS evaluation_system_22, f0_.summary AS summary_23, f0_.document_version AS document_version_24, f0_.date AS date_25, f0_.program_path AS program_path_26, f0_.color AS color_27, f0_.certification AS certification_28, f0_.infos_certification AS infos_certification_29, f0_.on_quote AS on_quote_30, f0_.former_id AS former_id_31, f0_.organization_id AS organization_id_32, f0_.website_id AS website_id_33 FROM formation f0_ WHERE f0_.organization_id = ? ORDER BY f0_.id DESC
SELECT f0_.id AS id_0, f0_.firstname AS firstname_1, f0_.lastname AS lastname_2, f0_.email AS email_3, f0_.phone AS phone_4, f0_.main_activity AS main_activity_5, f0_.title AS title_6, f0_.quality AS quality_7, f0_.business_activity AS business_activity_8, f0_.professionnal_career AS professionnal_career_9, f0_.formation AS formation_10, f0_.continuous_formation AS continuous_formation_11, f0_.cv_path AS cv_path_12, f0_.signature_path AS signature_path_13, f0_.diploma_path AS diploma_path_14, f0_.status AS status_15, f0_.organization_id AS organization_id_16 FROM former f0_ WHERE f0_.organization_id = ? ORDER BY f0_.id DESC
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.former_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.former_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.former_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_email_verification_send AS last_email_verification_send_5, t0.organization_id AS organization_id_6, t7.id AS id_8, t7.company_name AS company_name_9, t7.website AS website_10, t7.address AS address_11, t7.phone AS phone_12, t7.contact_email AS contact_email_13, t7.opening_hours AS opening_hours_14, t7.siret AS siret_15, t7.ape_naf AS ape_naf_16, t7.declaration_number AS declaration_number_17, t7.region AS region_18, t7.tva AS tva_19, t7.manager_lastname AS manager_lastname_20, t7.manager_firstname AS manager_firstname_21, t7.logo_path AS logo_path_22, t7.thumbnail_path AS thumbnail_path_23, t7.stamp_path AS stamp_path_24, t7.signature_path AS signature_path_25, t7.qualiopi_certified AS qualiopi_certified_26, t7.certificate_number AS certificate_number_27, t7.visibility AS visibility_28, t7.completed_after_registration AS completed_after_registration_29, t7.enabled AS enabled_30, t7.stripe_id AS stripe_id_31, t7.verified AS verified_32, t7.created_at AS created_at_33, t7.trial_days AS trial_days_34, t7.subscription_email AS subscription_email_35, t7.notif_sent AS notif_sent_36, t7.actions_nature AS actions_nature_37, t7.activate_qualiopi_mention AS activate_qualiopi_mention_38, t7.qualiopi_certificate_path AS qualiopi_certificate_path_39, t0.former_id AS former_id_40, t41.id AS id_42, t41.firstname AS firstname_43, t41.lastname AS lastname_44, t41.email AS email_45, t41.phone AS phone_46, t41.main_activity AS main_activity_47, t41.title AS title_48, t41.quality AS quality_49, t41.business_activity AS business_activity_50, t41.professionnal_career AS professionnal_career_51, t41.formation AS formation_52, t41.continuous_formation AS continuous_formation_53, t41.cv_path AS cv_path_54, t41.signature_path AS signature_path_55, t41.diploma_path AS diploma_path_56, t41.status AS status_57, t41.organization_id AS organization_id_58 FROM user t0 LEFT JOIN organization t7 ON t0.organization_id = t7.id LEFT JOIN former t41 ON t0.former_id = t41.id WHERE t0.organization_id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.completed AS completed_3, t0.mail_status AS mail_status_4, t0.intern_id AS intern_id_5, t0.organization_id AS organization_id_6, t0.formation_id AS formation_id_7, t0.token_access_id AS token_access_id_8, t0.evaluation_model_id AS evaluation_model_id_9, t10.id AS id_11, t10.name AS name_12, t10.organization_id AS organization_id_13 FROM satisfaction_form t0 LEFT JOIN evaluation_model t10 ON t0.evaluation_model_id = t10.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.question_id AS question_id_3, t4.id AS id_5, t4.text AS text_6, t4.type AS type_7, t4.display_order AS display_order_8, t4.evaluation_model_id AS evaluation_model_id_9, t0.satisfaction_form_id AS satisfaction_form_id_10 FROM answer t0 LEFT JOIN question t4 ON t0.question_id = t4.id WHERE t0.satisfaction_form_id IN (?, ?)
SELECT t0.id AS id_1, t0.text AS text_2, t0.type AS type_3, t0.display_order AS display_order_4, t0.evaluation_model_id AS evaluation_model_id_5 FROM question t0 WHERE t0.evaluation_model_id IN (?)
SELECT t0.id AS id_1, t0.place AS place_2, t0.address AS address_3, t0.date_terms AS date_terms_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.action_nature AS action_nature_7, t0.intern_number AS intern_number_8, t0.price AS price_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.name AS name_12, t0.former_hours AS former_hours_13, t0.formation_id AS formation_id_14, t15.id AS id_16, t15.picture_path AS picture_path_17, t15.name AS name_18, t15.description AS description_19, t15.hour_duration AS hour_duration_20, t15.day_duration AS day_duration_21, t15.place AS place_22, t15.intern_profile AS intern_profile_23, t15.requirements AS requirements_24, t15.pre_tax_price AS pre_tax_price_25, t15.including_tax_price AS including_tax_price_26, t15.tva AS tva_27, t15.general_goals AS general_goals_28, t15.training_goals AS training_goals_29, t15.content AS content_30, t15.access_terms AS access_terms_31, t15.learning_resources AS learning_resources_32, t15.technical_resources AS technical_resources_33, t15.handicapped_access AS handicapped_access_34, t15.organization_terms AS organization_terms_35, t15.full_learning_resources AS full_learning_resources_36, t15.tracking AS tracking_37, t15.evaluation_system AS evaluation_system_38, t15.summary AS summary_39, t15.document_version AS document_version_40, t15.date AS date_41, t15.program_path AS program_path_42, t15.color AS color_43, t15.certification AS certification_44, t15.infos_certification AS infos_certification_45, t15.on_quote AS on_quote_46, t15.former_id AS former_id_47, t15.organization_id AS organization_id_48, t15.website_id AS website_id_49, t0.organization_id AS organization_id_50, t0.former_id AS former_id_51, t52.id AS id_53, t52.firstname AS firstname_54, t52.lastname AS lastname_55, t52.email AS email_56, t52.phone AS phone_57, t52.main_activity AS main_activity_58, t52.title AS title_59, t52.quality AS quality_60, t52.business_activity AS business_activity_61, t52.professionnal_career AS professionnal_career_62, t52.formation AS formation_63, t52.continuous_formation AS continuous_formation_64, t52.cv_path AS cv_path_65, t52.signature_path AS signature_path_66, t52.diploma_path AS diploma_path_67, t52.status AS status_68, t52.organization_id AS organization_id_69 FROM formation_session t0 LEFT JOIN formation t15 ON t0.formation_id = t15.id LEFT JOIN former t52 ON t0.former_id = t52.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.formation_session_id AS formation_session_id_3, t0.former_id AS former_id_4, t5.id AS id_6, t5.firstname AS firstname_7, t5.lastname AS lastname_8, t5.email AS email_9, t5.phone AS phone_10, t5.main_activity AS main_activity_11, t5.title AS title_12, t5.quality AS quality_13, t5.business_activity AS business_activity_14, t5.professionnal_career AS professionnal_career_15, t5.formation AS formation_16, t5.continuous_formation AS continuous_formation_17, t5.cv_path AS cv_path_18, t5.signature_path AS signature_path_19, t5.diploma_path AS diploma_path_20, t5.status AS status_21, t5.organization_id AS organization_id_22 FROM formation_session_former t0 INNER JOIN former t5 ON t0.former_id = t5.id WHERE t0.formation_session_id IN (?, ?, ?, ?)
SELECT t0.id AS id_1, t0.date AS date_2, t0.completed AS completed_3, t0.mail_status AS mail_status_4, t0.intern_id AS intern_id_5, t0.organization_id AS organization_id_6, t0.formation_id AS formation_id_7, t0.token_access_id AS token_access_id_8, t0.evaluation_model_id AS evaluation_model_id_9, t10.id AS id_11, t10.name AS name_12, t10.organization_id AS organization_id_13 FROM satisfaction_form t0 LEFT JOIN evaluation_model t10 ON t0.evaluation_model_id = t10.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.question_id AS question_id_3, t4.id AS id_5, t4.text AS text_6, t4.type AS type_7, t4.display_order AS display_order_8, t4.evaluation_model_id AS evaluation_model_id_9, t0.satisfaction_form_id AS satisfaction_form_id_10 FROM answer t0 LEFT JOIN question t4 ON t0.question_id = t4.id WHERE t0.satisfaction_form_id IN (?, ?)
SELECT t0.id AS id_1, t0.text AS text_2, t0.type AS type_3, t0.display_order AS display_order_4, t0.evaluation_model_id AS evaluation_model_id_5 FROM question t0 WHERE t0.evaluation_model_id IN (?, ?)
SELECT t0.id AS id_1, t0.place AS place_2, t0.address AS address_3, t0.date_terms AS date_terms_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.action_nature AS action_nature_7, t0.intern_number AS intern_number_8, t0.price AS price_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.name AS name_12, t0.former_hours AS former_hours_13, t0.formation_id AS formation_id_14, t15.id AS id_16, t15.picture_path AS picture_path_17, t15.name AS name_18, t15.description AS description_19, t15.hour_duration AS hour_duration_20, t15.day_duration AS day_duration_21, t15.place AS place_22, t15.intern_profile AS intern_profile_23, t15.requirements AS requirements_24, t15.pre_tax_price AS pre_tax_price_25, t15.including_tax_price AS including_tax_price_26, t15.tva AS tva_27, t15.general_goals AS general_goals_28, t15.training_goals AS training_goals_29, t15.content AS content_30, t15.access_terms AS access_terms_31, t15.learning_resources AS learning_resources_32, t15.technical_resources AS technical_resources_33, t15.handicapped_access AS handicapped_access_34, t15.organization_terms AS organization_terms_35, t15.full_learning_resources AS full_learning_resources_36, t15.tracking AS tracking_37, t15.evaluation_system AS evaluation_system_38, t15.summary AS summary_39, t15.document_version AS document_version_40, t15.date AS date_41, t15.program_path AS program_path_42, t15.color AS color_43, t15.certification AS certification_44, t15.infos_certification AS infos_certification_45, t15.on_quote AS on_quote_46, t15.former_id AS former_id_47, t15.organization_id AS organization_id_48, t15.website_id AS website_id_49, t0.organization_id AS organization_id_50, t0.former_id AS former_id_51, t52.id AS id_53, t52.firstname AS firstname_54, t52.lastname AS lastname_55, t52.email AS email_56, t52.phone AS phone_57, t52.main_activity AS main_activity_58, t52.title AS title_59, t52.quality AS quality_60, t52.business_activity AS business_activity_61, t52.professionnal_career AS professionnal_career_62, t52.formation AS formation_63, t52.continuous_formation AS continuous_formation_64, t52.cv_path AS cv_path_65, t52.signature_path AS signature_path_66, t52.diploma_path AS diploma_path_67, t52.status AS status_68, t52.organization_id AS organization_id_69 FROM formation_session t0 LEFT JOIN formation t15 ON t0.formation_id = t15.id LEFT JOIN former t52 ON t0.former_id = t52.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.formation_session_id AS formation_session_id_3, t0.former_id AS former_id_4, t5.id AS id_6, t5.firstname AS firstname_7, t5.lastname AS lastname_8, t5.email AS email_9, t5.phone AS phone_10, t5.main_activity AS main_activity_11, t5.title AS title_12, t5.quality AS quality_13, t5.business_activity AS business_activity_14, t5.professionnal_career AS professionnal_career_15, t5.formation AS formation_16, t5.continuous_formation AS continuous_formation_17, t5.cv_path AS cv_path_18, t5.signature_path AS signature_path_19, t5.diploma_path AS diploma_path_20, t5.status AS status_21, t5.organization_id AS organization_id_22 FROM formation_session_former t0 INNER JOIN former t5 ON t0.former_id = t5.id WHERE t0.formation_session_id IN (?)
SELECT t0.id AS id_1, t0.date AS date_2, t0.completed AS completed_3, t0.mail_status AS mail_status_4, t0.intern_id AS intern_id_5, t0.organization_id AS organization_id_6, t0.formation_id AS formation_id_7, t0.token_access_id AS token_access_id_8, t0.evaluation_model_id AS evaluation_model_id_9, t10.id AS id_11, t10.name AS name_12, t10.organization_id AS organization_id_13 FROM satisfaction_form t0 LEFT JOIN evaluation_model t10 ON t0.evaluation_model_id = t10.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.question_id AS question_id_3, t4.id AS id_5, t4.text AS text_6, t4.type AS type_7, t4.display_order AS display_order_8, t4.evaluation_model_id AS evaluation_model_id_9, t0.satisfaction_form_id AS satisfaction_form_id_10 FROM answer t0 LEFT JOIN question t4 ON t0.question_id = t4.id WHERE t0.satisfaction_form_id IN (?, ?)
SELECT t0.id AS id_1, t0.text AS text_2, t0.type AS type_3, t0.display_order AS display_order_4, t0.evaluation_model_id AS evaluation_model_id_5 FROM question t0 WHERE t0.evaluation_model_id IN (?)
SELECT t0.id AS id_1, t0.place AS place_2, t0.address AS address_3, t0.date_terms AS date_terms_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.action_nature AS action_nature_7, t0.intern_number AS intern_number_8, t0.price AS price_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.name AS name_12, t0.former_hours AS former_hours_13, t0.formation_id AS formation_id_14, t15.id AS id_16, t15.picture_path AS picture_path_17, t15.name AS name_18, t15.description AS description_19, t15.hour_duration AS hour_duration_20, t15.day_duration AS day_duration_21, t15.place AS place_22, t15.intern_profile AS intern_profile_23, t15.requirements AS requirements_24, t15.pre_tax_price AS pre_tax_price_25, t15.including_tax_price AS including_tax_price_26, t15.tva AS tva_27, t15.general_goals AS general_goals_28, t15.training_goals AS training_goals_29, t15.content AS content_30, t15.access_terms AS access_terms_31, t15.learning_resources AS learning_resources_32, t15.technical_resources AS technical_resources_33, t15.handicapped_access AS handicapped_access_34, t15.organization_terms AS organization_terms_35, t15.full_learning_resources AS full_learning_resources_36, t15.tracking AS tracking_37, t15.evaluation_system AS evaluation_system_38, t15.summary AS summary_39, t15.document_version AS document_version_40, t15.date AS date_41, t15.program_path AS program_path_42, t15.color AS color_43, t15.certification AS certification_44, t15.infos_certification AS infos_certification_45, t15.on_quote AS on_quote_46, t15.former_id AS former_id_47, t15.organization_id AS organization_id_48, t15.website_id AS website_id_49, t0.organization_id AS organization_id_50, t0.former_id AS former_id_51, t52.id AS id_53, t52.firstname AS firstname_54, t52.lastname AS lastname_55, t52.email AS email_56, t52.phone AS phone_57, t52.main_activity AS main_activity_58, t52.title AS title_59, t52.quality AS quality_60, t52.business_activity AS business_activity_61, t52.professionnal_career AS professionnal_career_62, t52.formation AS formation_63, t52.continuous_formation AS continuous_formation_64, t52.cv_path AS cv_path_65, t52.signature_path AS signature_path_66, t52.diploma_path AS diploma_path_67, t52.status AS status_68, t52.organization_id AS organization_id_69 FROM formation_session t0 LEFT JOIN formation t15 ON t0.formation_id = t15.id LEFT JOIN former t52 ON t0.former_id = t52.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.formation_session_id AS formation_session_id_3, t0.former_id AS former_id_4, t5.id AS id_6, t5.firstname AS firstname_7, t5.lastname AS lastname_8, t5.email AS email_9, t5.phone AS phone_10, t5.main_activity AS main_activity_11, t5.title AS title_12, t5.quality AS quality_13, t5.business_activity AS business_activity_14, t5.professionnal_career AS professionnal_career_15, t5.formation AS formation_16, t5.continuous_formation AS continuous_formation_17, t5.cv_path AS cv_path_18, t5.signature_path AS signature_path_19, t5.diploma_path AS diploma_path_20, t5.status AS status_21, t5.organization_id AS organization_id_22 FROM formation_session_former t0 INNER JOIN former t5 ON t0.former_id = t5.id WHERE t0.formation_session_id IN (?, ?)
SELECT t0.id AS id_1, t0.date AS date_2, t0.completed AS completed_3, t0.mail_status AS mail_status_4, t0.intern_id AS intern_id_5, t0.organization_id AS organization_id_6, t0.formation_id AS formation_id_7, t0.token_access_id AS token_access_id_8, t0.evaluation_model_id AS evaluation_model_id_9, t10.id AS id_11, t10.name AS name_12, t10.organization_id AS organization_id_13 FROM satisfaction_form t0 LEFT JOIN evaluation_model t10 ON t0.evaluation_model_id = t10.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.question_id AS question_id_3, t4.id AS id_5, t4.text AS text_6, t4.type AS type_7, t4.display_order AS display_order_8, t4.evaluation_model_id AS evaluation_model_id_9, t0.satisfaction_form_id AS satisfaction_form_id_10 FROM answer t0 LEFT JOIN question t4 ON t0.question_id = t4.id WHERE t0.satisfaction_form_id IN (?, ?, ?, ?, ?, ?)
SELECT t0.id AS id_1, t0.text AS text_2, t0.type AS type_3, t0.display_order AS display_order_4, t0.evaluation_model_id AS evaluation_model_id_5 FROM question t0 WHERE t0.evaluation_model_id IN (?, ?)
SELECT t0.id AS id_1, t0.place AS place_2, t0.address AS address_3, t0.date_terms AS date_terms_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.action_nature AS action_nature_7, t0.intern_number AS intern_number_8, t0.price AS price_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.name AS name_12, t0.former_hours AS former_hours_13, t0.formation_id AS formation_id_14, t15.id AS id_16, t15.picture_path AS picture_path_17, t15.name AS name_18, t15.description AS description_19, t15.hour_duration AS hour_duration_20, t15.day_duration AS day_duration_21, t15.place AS place_22, t15.intern_profile AS intern_profile_23, t15.requirements AS requirements_24, t15.pre_tax_price AS pre_tax_price_25, t15.including_tax_price AS including_tax_price_26, t15.tva AS tva_27, t15.general_goals AS general_goals_28, t15.training_goals AS training_goals_29, t15.content AS content_30, t15.access_terms AS access_terms_31, t15.learning_resources AS learning_resources_32, t15.technical_resources AS technical_resources_33, t15.handicapped_access AS handicapped_access_34, t15.organization_terms AS organization_terms_35, t15.full_learning_resources AS full_learning_resources_36, t15.tracking AS tracking_37, t15.evaluation_system AS evaluation_system_38, t15.summary AS summary_39, t15.document_version AS document_version_40, t15.date AS date_41, t15.program_path AS program_path_42, t15.color AS color_43, t15.certification AS certification_44, t15.infos_certification AS infos_certification_45, t15.on_quote AS on_quote_46, t15.former_id AS former_id_47, t15.organization_id AS organization_id_48, t15.website_id AS website_id_49, t0.organization_id AS organization_id_50, t0.former_id AS former_id_51, t52.id AS id_53, t52.firstname AS firstname_54, t52.lastname AS lastname_55, t52.email AS email_56, t52.phone AS phone_57, t52.main_activity AS main_activity_58, t52.title AS title_59, t52.quality AS quality_60, t52.business_activity AS business_activity_61, t52.professionnal_career AS professionnal_career_62, t52.formation AS formation_63, t52.continuous_formation AS continuous_formation_64, t52.cv_path AS cv_path_65, t52.signature_path AS signature_path_66, t52.diploma_path AS diploma_path_67, t52.status AS status_68, t52.organization_id AS organization_id_69 FROM formation_session t0 LEFT JOIN formation t15 ON t0.formation_id = t15.id LEFT JOIN former t52 ON t0.former_id = t52.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.formation_session_id AS formation_session_id_3, t0.former_id AS former_id_4, t5.id AS id_6, t5.firstname AS firstname_7, t5.lastname AS lastname_8, t5.email AS email_9, t5.phone AS phone_10, t5.main_activity AS main_activity_11, t5.title AS title_12, t5.quality AS quality_13, t5.business_activity AS business_activity_14, t5.professionnal_career AS professionnal_career_15, t5.formation AS formation_16, t5.continuous_formation AS continuous_formation_17, t5.cv_path AS cv_path_18, t5.signature_path AS signature_path_19, t5.diploma_path AS diploma_path_20, t5.status AS status_21, t5.organization_id AS organization_id_22 FROM formation_session_former t0 INNER JOIN former t5 ON t0.former_id = t5.id WHERE t0.formation_session_id IN (?, ?)
SELECT t0.id AS id_1, t0.date AS date_2, t0.completed AS completed_3, t0.mail_status AS mail_status_4, t0.intern_id AS intern_id_5, t0.organization_id AS organization_id_6, t0.formation_id AS formation_id_7, t0.token_access_id AS token_access_id_8, t0.evaluation_model_id AS evaluation_model_id_9, t10.id AS id_11, t10.name AS name_12, t10.organization_id AS organization_id_13 FROM satisfaction_form t0 LEFT JOIN evaluation_model t10 ON t0.evaluation_model_id = t10.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.question_id AS question_id_3, t4.id AS id_5, t4.text AS text_6, t4.type AS type_7, t4.display_order AS display_order_8, t4.evaluation_model_id AS evaluation_model_id_9, t0.satisfaction_form_id AS satisfaction_form_id_10 FROM answer t0 LEFT JOIN question t4 ON t0.question_id = t4.id WHERE t0.satisfaction_form_id IN (?, ?)
SELECT t0.id AS id_1, t0.place AS place_2, t0.address AS address_3, t0.date_terms AS date_terms_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.action_nature AS action_nature_7, t0.intern_number AS intern_number_8, t0.price AS price_9, t0.start_date AS start_date_10, t0.end_date AS end_date_11, t0.name AS name_12, t0.former_hours AS former_hours_13, t0.formation_id AS formation_id_14, t15.id AS id_16, t15.picture_path AS picture_path_17, t15.name AS name_18, t15.description AS description_19, t15.hour_duration AS hour_duration_20, t15.day_duration AS day_duration_21, t15.place AS place_22, t15.intern_profile AS intern_profile_23, t15.requirements AS requirements_24, t15.pre_tax_price AS pre_tax_price_25, t15.including_tax_price AS including_tax_price_26, t15.tva AS tva_27, t15.general_goals AS general_goals_28, t15.training_goals AS training_goals_29, t15.content AS content_30, t15.access_terms AS access_terms_31, t15.learning_resources AS learning_resources_32, t15.technical_resources AS technical_resources_33, t15.handicapped_access AS handicapped_access_34, t15.organization_terms AS organization_terms_35, t15.full_learning_resources AS full_learning_resources_36, t15.tracking AS tracking_37, t15.evaluation_system AS evaluation_system_38, t15.summary AS summary_39, t15.document_version AS document_version_40, t15.date AS date_41, t15.program_path AS program_path_42, t15.color AS color_43, t15.certification AS certification_44, t15.infos_certification AS infos_certification_45, t15.on_quote AS on_quote_46, t15.former_id AS former_id_47, t15.organization_id AS organization_id_48, t15.website_id AS website_id_49, t0.organization_id AS organization_id_50, t0.former_id AS former_id_51, t52.id AS id_53, t52.firstname AS firstname_54, t52.lastname AS lastname_55, t52.email AS email_56, t52.phone AS phone_57, t52.main_activity AS main_activity_58, t52.title AS title_59, t52.quality AS quality_60, t52.business_activity AS business_activity_61, t52.professionnal_career AS professionnal_career_62, t52.formation AS formation_63, t52.continuous_formation AS continuous_formation_64, t52.cv_path AS cv_path_65, t52.signature_path AS signature_path_66, t52.diploma_path AS diploma_path_67, t52.status AS status_68, t52.organization_id AS organization_id_69 FROM formation_session t0 LEFT JOIN formation t15 ON t0.formation_id = t15.id LEFT JOIN former t52 ON t0.former_id = t52.id WHERE t0.formation_id = ?
SELECT t0.id AS id_1, t0.hours AS hours_2, t0.formation_session_id AS formation_session_id_3, t0.former_id AS former_id_4, t5.id AS id_6, t5.firstname AS firstname_7, t5.lastname AS lastname_8, t5.email AS email_9, t5.phone AS phone_10, t5.main_activity AS main_activity_11, t5.title AS title_12, t5.quality AS quality_13, t5.business_activity AS business_activity_14, t5.professionnal_career AS professionnal_career_15, t5.formation AS formation_16, t5.continuous_formation AS continuous_formation_17, t5.cv_path AS cv_path_18, t5.signature_path AS signature_path_19, t5.diploma_path AS diploma_path_20, t5.status AS status_21, t5.organization_id AS organization_id_22 FROM formation_session_former t0 INNER JOIN former t5 ON t0.former_id = t5.id WHERE t0.formation_session_id IN (?)
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.
Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Organization	No errors.
App\Entity\Former	No errors.
App\Entity\Ticket	No errors.
App\Entity\Message	No errors.
App\Entity\Formation	No errors.
App\Entity\Convention	No errors.
App\Entity\Intern	No errors.
App\Entity\FormationSession	No errors.
App\Entity\FormationEntry	The mappings App\Entity\FormationEntry#internList and App\Entity\Intern#formationEntries are inconsistent with each other. If association App\Entity\FormationEntry#internList is many-to-many, then the inversed side App\Entity\Intern#formationEntries has to be many-to-many as well.
App\Entity\FormationLeaving	No errors.
App\Entity\SatisfactionForm	No errors.
App\Entity\EvaluationModel	No errors.
App\Entity\Attendance	No errors.
App\Entity\Emargement	No errors.
App\Entity\Subscription	No errors.
App\Entity\InternalRules	No errors.
App\Entity\HandicapPolicy	No errors.
App\Entity\Website	No errors.
App\Entity\Report	No errors.
App\Entity\Prepositioning	No errors.
App\Entity\Document	No errors.
App\Entity\FormationSessionFormer	No errors.
App\Entity\TokenAccess	No errors.
App\Entity\Answer	No errors.
App\Entity\Question	No errors.
App\Entity\EndFormationReport	No errors.
Symfony Profiler

GET https://demo.appanaia.com/formations/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
