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

Query Metrics

36 Database Queries
17 Different statements
7.19 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 ms
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 = ?
Parameters:
[
  1
]
2 0.21 ms
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 = ?
Parameters:
[
  1
]
3 0.13 ms
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 = ?
Parameters:
[
  1
]
4 0.11 ms
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 = ?
Parameters:
[
  1
]
5 0.14 ms
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
Parameters:
[
  1
]
6 0.17 ms
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 = ?
Parameters:
[
  24
]
7 0.17 ms
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 = ?
Parameters:
[
  2
]
8 0.15 ms
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 = ?
Parameters:
[
  1
]
9 0.18 ms
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 = ?
Parameters:
[
  1
]
10 0.68 ms
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.former_id = ?
Parameters:
[
  24
]
11 0.60 ms
SELECT t0.id AS id_1, t0.hour_duration AS hour_duration_2, t0.day_duration AS day_duration_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.pre_tax_price AS pre_tax_price_6, t0.including_tax_price AS including_tax_price_7, t0.tva AS tva_8, t0.signature_date AS signature_date_9, t0.document_path AS document_path_10, t0.convention_status AS convention_status_11, t0.signed_convention_path AS signed_convention_path_12, t0.intern_signature_path AS intern_signature_path_13, t0.document_created_at AS document_created_at_14, t0.mail_status AS mail_status_15, t0.manually AS manually_16, t0.paid AS paid_17, t0.payment_date AS payment_date_18, t0.formation_session_id AS formation_session_id_19, t20.id AS id_21, t20.place AS place_22, t20.address AS address_23, t20.date_terms AS date_terms_24, t20.hour_duration AS hour_duration_25, t20.day_duration AS day_duration_26, t20.action_nature AS action_nature_27, t20.intern_number AS intern_number_28, t20.price AS price_29, t20.start_date AS start_date_30, t20.end_date AS end_date_31, t20.name AS name_32, t20.former_hours AS former_hours_33, t20.formation_id AS formation_id_34, t20.organization_id AS organization_id_35, t20.former_id AS former_id_36, t0.convention_id AS convention_id_37, t0.organization_id AS organization_id_38, t0.former_id AS former_id_39, t0.intern_id AS intern_id_40, t41.id AS id_42, t41.civility AS civility_43, t41.lastname AS lastname_44, t41.firstname AS firstname_45, t41.email AS email_46, t41.phone AS phone_47, t41.address AS address_48, t41.individual AS individual_49, t41.company AS company_50, t41.funding AS funding_51, t41.first_contact_date AS first_contact_date_52, t41.comment AS comment_53, t41.handicap AS handicap_54, t41.adaptation AS adaptation_55, t41.validation AS validation_56, t41.entry_date AS entry_date_57, t41.siret AS siret_58, t41.is_company AS is_company_59, t41.status AS status_60, t41.formation_id AS formation_id_61, t41.organization_id AS organization_id_62, t63.id AS id_64, t63.token AS token_65, t63.used AS used_66, t63.formation_entry_id AS formation_entry_id_67, t0.formation_leaving_id AS formation_leaving_id_68, t0.formation_entry_parent_id AS formation_entry_parent_id_69 FROM formation_entry t0 LEFT JOIN formation_session t20 ON t0.formation_session_id = t20.id LEFT JOIN intern t41 ON t0.intern_id = t41.id LEFT JOIN token_access t63 ON t63.formation_entry_id = t0.id WHERE t0.former_id = ?
Parameters:
[
  24
]
12 0.15 ms
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.token_access_id = ?
Parameters:
[
  170
]
13 0.17 ms
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.id IN (?)
Parameters:
[
  36
]
14 0.11 ms
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 (?)
Parameters:
[
  38
]
15 0.18 ms
SELECT t0.id AS id_1, t0.hour_duration AS hour_duration_2, t0.day_duration AS day_duration_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.pre_tax_price AS pre_tax_price_6, t0.including_tax_price AS including_tax_price_7, t0.tva AS tva_8, t0.signature_date AS signature_date_9, t0.document_path AS document_path_10, t0.convention_status AS convention_status_11, t0.signed_convention_path AS signed_convention_path_12, t0.intern_signature_path AS intern_signature_path_13, t0.document_created_at AS document_created_at_14, t0.mail_status AS mail_status_15, t0.manually AS manually_16, t0.paid AS paid_17, t0.payment_date AS payment_date_18, t0.formation_session_id AS formation_session_id_19, t20.id AS id_21, t20.place AS place_22, t20.address AS address_23, t20.date_terms AS date_terms_24, t20.hour_duration AS hour_duration_25, t20.day_duration AS day_duration_26, t20.action_nature AS action_nature_27, t20.intern_number AS intern_number_28, t20.price AS price_29, t20.start_date AS start_date_30, t20.end_date AS end_date_31, t20.name AS name_32, t20.former_hours AS former_hours_33, t20.formation_id AS formation_id_34, t20.organization_id AS organization_id_35, t20.former_id AS former_id_36, t0.convention_id AS convention_id_37, t0.organization_id AS organization_id_38, t0.former_id AS former_id_39, t0.intern_id AS intern_id_40, t41.id AS id_42, t41.civility AS civility_43, t41.lastname AS lastname_44, t41.firstname AS firstname_45, t41.email AS email_46, t41.phone AS phone_47, t41.address AS address_48, t41.individual AS individual_49, t41.company AS company_50, t41.funding AS funding_51, t41.first_contact_date AS first_contact_date_52, t41.comment AS comment_53, t41.handicap AS handicap_54, t41.adaptation AS adaptation_55, t41.validation AS validation_56, t41.entry_date AS entry_date_57, t41.siret AS siret_58, t41.is_company AS is_company_59, t41.status AS status_60, t41.formation_id AS formation_id_61, t41.organization_id AS organization_id_62, t63.id AS id_64, t63.token AS token_65, t63.used AS used_66, t63.formation_entry_id AS formation_entry_id_67, t0.formation_leaving_id AS formation_leaving_id_68, t0.formation_entry_parent_id AS formation_entry_parent_id_69 FROM formation_entry t0 LEFT JOIN formation_session t20 ON t0.formation_session_id = t20.id LEFT JOIN intern t41 ON t0.intern_id = t41.id LEFT JOIN token_access t63 ON t63.formation_entry_id = t0.id WHERE t0.intern_id IN (?)
Parameters:
[
  59
]
16 0.11 ms
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.token_access_id = ?
Parameters:
[
  171
]
17 0.32 ms
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 (?, ?)
Parameters:
[
  27
  30
]
18 0.12 ms
SELECT t0.id AS id_1, t0.sync_validated_time AS sync_validated_time_2, t0.async_validated_time AS async_validated_time_3, t0.total_validated_time AS total_validated_time_4, t0.validation_date AS validation_date_5, t0.document_path AS document_path_6, t0.signed_attendance_path AS signed_attendance_path_7, t0.intern_signature_path AS intern_signature_path_8, t0.attendance_status AS attendance_status_9, t0.mail_status AS mail_status_10, t0.manually AS manually_11, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_12, t0.copy_to_intern_sent AS copy_to_intern_sent_13, t0.intern_id AS intern_id_14, t0.former_id AS former_id_15, t0.token_access_id AS token_access_id_16, t0.formation_entry_id AS formation_entry_id_17, t0.organization_id AS organization_id_18 FROM attendance t0 WHERE t0.token_access_id = ?
Parameters:
[
  171
]
19 0.20 ms
SELECT t0.id AS id_1, t0.start_period_date AS start_period_date_2, t0.end_period_date AS end_period_date_3, t0.duration AS duration_4, t0.module AS module_5, t0.slots_number AS slots_number_6, t0.meeting_type1 AS meeting_type1_7, t0.meeting_date1 AS meeting_date1_8, t0.start_hourly1 AS start_hourly1_9, t0.end_hourly1 AS end_hourly1_10, t0.meeting_type2 AS meeting_type2_11, t0.meeting_date2 AS meeting_date2_12, t0.start_hourly2 AS start_hourly2_13, t0.end_hourly2 AS end_hourly2_14, t0.date AS date_15, t0.document_path AS document_path_16, t0.emargement_status AS emargement_status_17, t0.signed_emargement_path AS signed_emargement_path_18, t0.intern_signature_path AS intern_signature_path_19, t0.intern_signature_path2 AS intern_signature_path2_20, t0.mail_status AS mail_status_21, t0.manually AS manually_22, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_23, t0.copy_to_intern_sent AS copy_to_intern_sent_24, t0.former_id AS former_id_25, t0.intern_id AS intern_id_26, t27.id AS id_28, t27.civility AS civility_29, t27.lastname AS lastname_30, t27.firstname AS firstname_31, t27.email AS email_32, t27.phone AS phone_33, t27.address AS address_34, t27.individual AS individual_35, t27.company AS company_36, t27.funding AS funding_37, t27.first_contact_date AS first_contact_date_38, t27.comment AS comment_39, t27.handicap AS handicap_40, t27.adaptation AS adaptation_41, t27.validation AS validation_42, t27.entry_date AS entry_date_43, t27.siret AS siret_44, t27.is_company AS is_company_45, t27.status AS status_46, t27.formation_id AS formation_id_47, t27.organization_id AS organization_id_48, t0.token_access_id AS token_access_id_49, t0.formation_entry_id AS formation_entry_id_50, t51.id AS id_52, t51.hour_duration AS hour_duration_53, t51.day_duration AS day_duration_54, t51.start_date AS start_date_55, t51.end_date AS end_date_56, t51.pre_tax_price AS pre_tax_price_57, t51.including_tax_price AS including_tax_price_58, t51.tva AS tva_59, t51.signature_date AS signature_date_60, t51.document_path AS document_path_61, t51.convention_status AS convention_status_62, t51.signed_convention_path AS signed_convention_path_63, t51.intern_signature_path AS intern_signature_path_64, t51.document_created_at AS document_created_at_65, t51.mail_status AS mail_status_66, t51.manually AS manually_67, t51.paid AS paid_68, t51.payment_date AS payment_date_69, t51.formation_session_id AS formation_session_id_70, t51.convention_id AS convention_id_71, t51.organization_id AS organization_id_72, t51.former_id AS former_id_73, t51.intern_id AS intern_id_74, t51.formation_leaving_id AS formation_leaving_id_75, t51.formation_entry_parent_id AS formation_entry_parent_id_76, t0.organization_id AS organization_id_77, t0.formation_session_id AS formation_session_id_78, t0.emargement_parent_id AS emargement_parent_id_79 FROM emargement t0 LEFT JOIN intern t27 ON t0.intern_id = t27.id LEFT JOIN formation_entry t51 ON t0.formation_entry_id = t51.id WHERE t0.token_access_id = ?
Parameters:
[
  171
]
20 0.10 ms
SELECT t0.id AS id_1, t0.sync_validated_time AS sync_validated_time_2, t0.async_validated_time AS async_validated_time_3, t0.total_validated_time AS total_validated_time_4, t0.validation_date AS validation_date_5, t0.document_path AS document_path_6, t0.signed_attendance_path AS signed_attendance_path_7, t0.intern_signature_path AS intern_signature_path_8, t0.attendance_status AS attendance_status_9, t0.mail_status AS mail_status_10, t0.manually AS manually_11, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_12, t0.copy_to_intern_sent AS copy_to_intern_sent_13, t0.intern_id AS intern_id_14, t0.former_id AS former_id_15, t0.token_access_id AS token_access_id_16, t0.formation_entry_id AS formation_entry_id_17, t0.organization_id AS organization_id_18 FROM attendance t0 WHERE t0.token_access_id = ?
Parameters:
[
  170
]
21 0.13 ms
SELECT t0.id AS id_1, t0.start_period_date AS start_period_date_2, t0.end_period_date AS end_period_date_3, t0.duration AS duration_4, t0.module AS module_5, t0.slots_number AS slots_number_6, t0.meeting_type1 AS meeting_type1_7, t0.meeting_date1 AS meeting_date1_8, t0.start_hourly1 AS start_hourly1_9, t0.end_hourly1 AS end_hourly1_10, t0.meeting_type2 AS meeting_type2_11, t0.meeting_date2 AS meeting_date2_12, t0.start_hourly2 AS start_hourly2_13, t0.end_hourly2 AS end_hourly2_14, t0.date AS date_15, t0.document_path AS document_path_16, t0.emargement_status AS emargement_status_17, t0.signed_emargement_path AS signed_emargement_path_18, t0.intern_signature_path AS intern_signature_path_19, t0.intern_signature_path2 AS intern_signature_path2_20, t0.mail_status AS mail_status_21, t0.manually AS manually_22, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_23, t0.copy_to_intern_sent AS copy_to_intern_sent_24, t0.former_id AS former_id_25, t0.intern_id AS intern_id_26, t27.id AS id_28, t27.civility AS civility_29, t27.lastname AS lastname_30, t27.firstname AS firstname_31, t27.email AS email_32, t27.phone AS phone_33, t27.address AS address_34, t27.individual AS individual_35, t27.company AS company_36, t27.funding AS funding_37, t27.first_contact_date AS first_contact_date_38, t27.comment AS comment_39, t27.handicap AS handicap_40, t27.adaptation AS adaptation_41, t27.validation AS validation_42, t27.entry_date AS entry_date_43, t27.siret AS siret_44, t27.is_company AS is_company_45, t27.status AS status_46, t27.formation_id AS formation_id_47, t27.organization_id AS organization_id_48, t0.token_access_id AS token_access_id_49, t0.formation_entry_id AS formation_entry_id_50, t51.id AS id_52, t51.hour_duration AS hour_duration_53, t51.day_duration AS day_duration_54, t51.start_date AS start_date_55, t51.end_date AS end_date_56, t51.pre_tax_price AS pre_tax_price_57, t51.including_tax_price AS including_tax_price_58, t51.tva AS tva_59, t51.signature_date AS signature_date_60, t51.document_path AS document_path_61, t51.convention_status AS convention_status_62, t51.signed_convention_path AS signed_convention_path_63, t51.intern_signature_path AS intern_signature_path_64, t51.document_created_at AS document_created_at_65, t51.mail_status AS mail_status_66, t51.manually AS manually_67, t51.paid AS paid_68, t51.payment_date AS payment_date_69, t51.formation_session_id AS formation_session_id_70, t51.convention_id AS convention_id_71, t51.organization_id AS organization_id_72, t51.former_id AS former_id_73, t51.intern_id AS intern_id_74, t51.formation_leaving_id AS formation_leaving_id_75, t51.formation_entry_parent_id AS formation_entry_parent_id_76, t0.organization_id AS organization_id_77, t0.formation_session_id AS formation_session_id_78, t0.emargement_parent_id AS emargement_parent_id_79 FROM emargement t0 LEFT JOIN intern t27 ON t0.intern_id = t27.id LEFT JOIN formation_entry t51 ON t0.formation_entry_id = t51.id WHERE t0.token_access_id = ?
Parameters:
[
  170
]
22 0.10 ms
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.token_access_id = ?
Parameters:
[
  169
]
23 0.13 ms
SELECT t0.id AS id_1, t0.hour_duration AS hour_duration_2, t0.day_duration AS day_duration_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.pre_tax_price AS pre_tax_price_6, t0.including_tax_price AS including_tax_price_7, t0.tva AS tva_8, t0.signature_date AS signature_date_9, t0.document_path AS document_path_10, t0.convention_status AS convention_status_11, t0.signed_convention_path AS signed_convention_path_12, t0.intern_signature_path AS intern_signature_path_13, t0.document_created_at AS document_created_at_14, t0.mail_status AS mail_status_15, t0.manually AS manually_16, t0.paid AS paid_17, t0.payment_date AS payment_date_18, t0.formation_session_id AS formation_session_id_19, t20.id AS id_21, t20.place AS place_22, t20.address AS address_23, t20.date_terms AS date_terms_24, t20.hour_duration AS hour_duration_25, t20.day_duration AS day_duration_26, t20.action_nature AS action_nature_27, t20.intern_number AS intern_number_28, t20.price AS price_29, t20.start_date AS start_date_30, t20.end_date AS end_date_31, t20.name AS name_32, t20.former_hours AS former_hours_33, t20.formation_id AS formation_id_34, t20.organization_id AS organization_id_35, t20.former_id AS former_id_36, t0.convention_id AS convention_id_37, t0.organization_id AS organization_id_38, t0.former_id AS former_id_39, t0.intern_id AS intern_id_40, t41.id AS id_42, t41.civility AS civility_43, t41.lastname AS lastname_44, t41.firstname AS firstname_45, t41.email AS email_46, t41.phone AS phone_47, t41.address AS address_48, t41.individual AS individual_49, t41.company AS company_50, t41.funding AS funding_51, t41.first_contact_date AS first_contact_date_52, t41.comment AS comment_53, t41.handicap AS handicap_54, t41.adaptation AS adaptation_55, t41.validation AS validation_56, t41.entry_date AS entry_date_57, t41.siret AS siret_58, t41.is_company AS is_company_59, t41.status AS status_60, t41.formation_id AS formation_id_61, t41.organization_id AS organization_id_62, t63.id AS id_64, t63.token AS token_65, t63.used AS used_66, t63.formation_entry_id AS formation_entry_id_67, t0.formation_leaving_id AS formation_leaving_id_68, t0.formation_entry_parent_id AS formation_entry_parent_id_69 FROM formation_entry t0 LEFT JOIN formation_session t20 ON t0.formation_session_id = t20.id LEFT JOIN intern t41 ON t0.intern_id = t41.id LEFT JOIN token_access t63 ON t63.formation_entry_id = t0.id WHERE t0.intern_id IN (?)
Parameters:
[
  60
]
24 0.09 ms
SELECT t0.id AS id_1, t0.sync_validated_time AS sync_validated_time_2, t0.async_validated_time AS async_validated_time_3, t0.total_validated_time AS total_validated_time_4, t0.validation_date AS validation_date_5, t0.document_path AS document_path_6, t0.signed_attendance_path AS signed_attendance_path_7, t0.intern_signature_path AS intern_signature_path_8, t0.attendance_status AS attendance_status_9, t0.mail_status AS mail_status_10, t0.manually AS manually_11, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_12, t0.copy_to_intern_sent AS copy_to_intern_sent_13, t0.intern_id AS intern_id_14, t0.former_id AS former_id_15, t0.token_access_id AS token_access_id_16, t0.formation_entry_id AS formation_entry_id_17, t0.organization_id AS organization_id_18 FROM attendance t0 WHERE t0.token_access_id = ?
Parameters:
[
  169
]
25 0.13 ms
SELECT t0.id AS id_1, t0.start_period_date AS start_period_date_2, t0.end_period_date AS end_period_date_3, t0.duration AS duration_4, t0.module AS module_5, t0.slots_number AS slots_number_6, t0.meeting_type1 AS meeting_type1_7, t0.meeting_date1 AS meeting_date1_8, t0.start_hourly1 AS start_hourly1_9, t0.end_hourly1 AS end_hourly1_10, t0.meeting_type2 AS meeting_type2_11, t0.meeting_date2 AS meeting_date2_12, t0.start_hourly2 AS start_hourly2_13, t0.end_hourly2 AS end_hourly2_14, t0.date AS date_15, t0.document_path AS document_path_16, t0.emargement_status AS emargement_status_17, t0.signed_emargement_path AS signed_emargement_path_18, t0.intern_signature_path AS intern_signature_path_19, t0.intern_signature_path2 AS intern_signature_path2_20, t0.mail_status AS mail_status_21, t0.manually AS manually_22, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_23, t0.copy_to_intern_sent AS copy_to_intern_sent_24, t0.former_id AS former_id_25, t0.intern_id AS intern_id_26, t27.id AS id_28, t27.civility AS civility_29, t27.lastname AS lastname_30, t27.firstname AS firstname_31, t27.email AS email_32, t27.phone AS phone_33, t27.address AS address_34, t27.individual AS individual_35, t27.company AS company_36, t27.funding AS funding_37, t27.first_contact_date AS first_contact_date_38, t27.comment AS comment_39, t27.handicap AS handicap_40, t27.adaptation AS adaptation_41, t27.validation AS validation_42, t27.entry_date AS entry_date_43, t27.siret AS siret_44, t27.is_company AS is_company_45, t27.status AS status_46, t27.formation_id AS formation_id_47, t27.organization_id AS organization_id_48, t0.token_access_id AS token_access_id_49, t0.formation_entry_id AS formation_entry_id_50, t51.id AS id_52, t51.hour_duration AS hour_duration_53, t51.day_duration AS day_duration_54, t51.start_date AS start_date_55, t51.end_date AS end_date_56, t51.pre_tax_price AS pre_tax_price_57, t51.including_tax_price AS including_tax_price_58, t51.tva AS tva_59, t51.signature_date AS signature_date_60, t51.document_path AS document_path_61, t51.convention_status AS convention_status_62, t51.signed_convention_path AS signed_convention_path_63, t51.intern_signature_path AS intern_signature_path_64, t51.document_created_at AS document_created_at_65, t51.mail_status AS mail_status_66, t51.manually AS manually_67, t51.paid AS paid_68, t51.payment_date AS payment_date_69, t51.formation_session_id AS formation_session_id_70, t51.convention_id AS convention_id_71, t51.organization_id AS organization_id_72, t51.former_id AS former_id_73, t51.intern_id AS intern_id_74, t51.formation_leaving_id AS formation_leaving_id_75, t51.formation_entry_parent_id AS formation_entry_parent_id_76, t0.organization_id AS organization_id_77, t0.formation_session_id AS formation_session_id_78, t0.emargement_parent_id AS emargement_parent_id_79 FROM emargement t0 LEFT JOIN intern t27 ON t0.intern_id = t27.id LEFT JOIN formation_entry t51 ON t0.formation_entry_id = t51.id WHERE t0.token_access_id = ?
Parameters:
[
  169
]
26 0.50 ms
SELECT t0.id AS id_1, t0.hour_duration AS hour_duration_2, t0.day_duration AS day_duration_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.pre_tax_price AS pre_tax_price_6, t0.including_tax_price AS including_tax_price_7, t0.tva AS tva_8, t0.signature_date AS signature_date_9, t0.document_path AS document_path_10, t0.convention_status AS convention_status_11, t0.signed_convention_path AS signed_convention_path_12, t0.intern_signature_path AS intern_signature_path_13, t0.document_created_at AS document_created_at_14, t0.mail_status AS mail_status_15, t0.manually AS manually_16, t0.paid AS paid_17, t0.payment_date AS payment_date_18, t0.formation_session_id AS formation_session_id_19, t20.id AS id_21, t20.place AS place_22, t20.address AS address_23, t20.date_terms AS date_terms_24, t20.hour_duration AS hour_duration_25, t20.day_duration AS day_duration_26, t20.action_nature AS action_nature_27, t20.intern_number AS intern_number_28, t20.price AS price_29, t20.start_date AS start_date_30, t20.end_date AS end_date_31, t20.name AS name_32, t20.former_hours AS former_hours_33, t20.formation_id AS formation_id_34, t20.organization_id AS organization_id_35, t20.former_id AS former_id_36, t0.convention_id AS convention_id_37, t0.organization_id AS organization_id_38, t0.former_id AS former_id_39, t0.intern_id AS intern_id_40, t41.id AS id_42, t41.civility AS civility_43, t41.lastname AS lastname_44, t41.firstname AS firstname_45, t41.email AS email_46, t41.phone AS phone_47, t41.address AS address_48, t41.individual AS individual_49, t41.company AS company_50, t41.funding AS funding_51, t41.first_contact_date AS first_contact_date_52, t41.comment AS comment_53, t41.handicap AS handicap_54, t41.adaptation AS adaptation_55, t41.validation AS validation_56, t41.entry_date AS entry_date_57, t41.siret AS siret_58, t41.is_company AS is_company_59, t41.status AS status_60, t41.formation_id AS formation_id_61, t41.organization_id AS organization_id_62, t63.id AS id_64, t63.token AS token_65, t63.used AS used_66, t63.formation_entry_id AS formation_entry_id_67, t0.formation_leaving_id AS formation_leaving_id_68, t0.formation_entry_parent_id AS formation_entry_parent_id_69 FROM formation_entry t0 LEFT JOIN formation_session t20 ON t0.formation_session_id = t20.id LEFT JOIN intern t41 ON t0.intern_id = t41.id LEFT JOIN token_access t63 ON t63.formation_entry_id = t0.id WHERE t0.intern_id IN (?, ?)
Parameters:
[
  28
  26
]
27 0.12 ms
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.token_access_id = ?
Parameters:
[
  84
]
28 0.17 ms
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.id IN (?)
Parameters:
[
  2
]
29 0.10 ms
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 (?)
Parameters:
[
  9
]
30 0.09 ms
SELECT t0.id AS id_1, t0.sync_validated_time AS sync_validated_time_2, t0.async_validated_time AS async_validated_time_3, t0.total_validated_time AS total_validated_time_4, t0.validation_date AS validation_date_5, t0.document_path AS document_path_6, t0.signed_attendance_path AS signed_attendance_path_7, t0.intern_signature_path AS intern_signature_path_8, t0.attendance_status AS attendance_status_9, t0.mail_status AS mail_status_10, t0.manually AS manually_11, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_12, t0.copy_to_intern_sent AS copy_to_intern_sent_13, t0.intern_id AS intern_id_14, t0.former_id AS former_id_15, t0.token_access_id AS token_access_id_16, t0.formation_entry_id AS formation_entry_id_17, t0.organization_id AS organization_id_18 FROM attendance t0 WHERE t0.token_access_id = ?
Parameters:
[
  84
]
31 0.16 ms
SELECT t0.id AS id_1, t0.start_period_date AS start_period_date_2, t0.end_period_date AS end_period_date_3, t0.duration AS duration_4, t0.module AS module_5, t0.slots_number AS slots_number_6, t0.meeting_type1 AS meeting_type1_7, t0.meeting_date1 AS meeting_date1_8, t0.start_hourly1 AS start_hourly1_9, t0.end_hourly1 AS end_hourly1_10, t0.meeting_type2 AS meeting_type2_11, t0.meeting_date2 AS meeting_date2_12, t0.start_hourly2 AS start_hourly2_13, t0.end_hourly2 AS end_hourly2_14, t0.date AS date_15, t0.document_path AS document_path_16, t0.emargement_status AS emargement_status_17, t0.signed_emargement_path AS signed_emargement_path_18, t0.intern_signature_path AS intern_signature_path_19, t0.intern_signature_path2 AS intern_signature_path2_20, t0.mail_status AS mail_status_21, t0.manually AS manually_22, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_23, t0.copy_to_intern_sent AS copy_to_intern_sent_24, t0.former_id AS former_id_25, t0.intern_id AS intern_id_26, t27.id AS id_28, t27.civility AS civility_29, t27.lastname AS lastname_30, t27.firstname AS firstname_31, t27.email AS email_32, t27.phone AS phone_33, t27.address AS address_34, t27.individual AS individual_35, t27.company AS company_36, t27.funding AS funding_37, t27.first_contact_date AS first_contact_date_38, t27.comment AS comment_39, t27.handicap AS handicap_40, t27.adaptation AS adaptation_41, t27.validation AS validation_42, t27.entry_date AS entry_date_43, t27.siret AS siret_44, t27.is_company AS is_company_45, t27.status AS status_46, t27.formation_id AS formation_id_47, t27.organization_id AS organization_id_48, t0.token_access_id AS token_access_id_49, t0.formation_entry_id AS formation_entry_id_50, t51.id AS id_52, t51.hour_duration AS hour_duration_53, t51.day_duration AS day_duration_54, t51.start_date AS start_date_55, t51.end_date AS end_date_56, t51.pre_tax_price AS pre_tax_price_57, t51.including_tax_price AS including_tax_price_58, t51.tva AS tva_59, t51.signature_date AS signature_date_60, t51.document_path AS document_path_61, t51.convention_status AS convention_status_62, t51.signed_convention_path AS signed_convention_path_63, t51.intern_signature_path AS intern_signature_path_64, t51.document_created_at AS document_created_at_65, t51.mail_status AS mail_status_66, t51.manually AS manually_67, t51.paid AS paid_68, t51.payment_date AS payment_date_69, t51.formation_session_id AS formation_session_id_70, t51.convention_id AS convention_id_71, t51.organization_id AS organization_id_72, t51.former_id AS former_id_73, t51.intern_id AS intern_id_74, t51.formation_leaving_id AS formation_leaving_id_75, t51.formation_entry_parent_id AS formation_entry_parent_id_76, t0.organization_id AS organization_id_77, t0.formation_session_id AS formation_session_id_78, t0.emargement_parent_id AS emargement_parent_id_79 FROM emargement t0 LEFT JOIN intern t27 ON t0.intern_id = t27.id LEFT JOIN formation_entry t51 ON t0.formation_entry_id = t51.id WHERE t0.token_access_id = ?
Parameters:
[
  84
]
32 0.10 ms
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.token_access_id = ?
Parameters:
[
  94
]
33 0.09 ms
SELECT t0.id AS id_1, t0.sync_validated_time AS sync_validated_time_2, t0.async_validated_time AS async_validated_time_3, t0.total_validated_time AS total_validated_time_4, t0.validation_date AS validation_date_5, t0.document_path AS document_path_6, t0.signed_attendance_path AS signed_attendance_path_7, t0.intern_signature_path AS intern_signature_path_8, t0.attendance_status AS attendance_status_9, t0.mail_status AS mail_status_10, t0.manually AS manually_11, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_12, t0.copy_to_intern_sent AS copy_to_intern_sent_13, t0.intern_id AS intern_id_14, t0.former_id AS former_id_15, t0.token_access_id AS token_access_id_16, t0.formation_entry_id AS formation_entry_id_17, t0.organization_id AS organization_id_18 FROM attendance t0 WHERE t0.token_access_id = ?
Parameters:
[
  94
]
34 0.15 ms
SELECT t0.id AS id_1, t0.start_period_date AS start_period_date_2, t0.end_period_date AS end_period_date_3, t0.duration AS duration_4, t0.module AS module_5, t0.slots_number AS slots_number_6, t0.meeting_type1 AS meeting_type1_7, t0.meeting_date1 AS meeting_date1_8, t0.start_hourly1 AS start_hourly1_9, t0.end_hourly1 AS end_hourly1_10, t0.meeting_type2 AS meeting_type2_11, t0.meeting_date2 AS meeting_date2_12, t0.start_hourly2 AS start_hourly2_13, t0.end_hourly2 AS end_hourly2_14, t0.date AS date_15, t0.document_path AS document_path_16, t0.emargement_status AS emargement_status_17, t0.signed_emargement_path AS signed_emargement_path_18, t0.intern_signature_path AS intern_signature_path_19, t0.intern_signature_path2 AS intern_signature_path2_20, t0.mail_status AS mail_status_21, t0.manually AS manually_22, t0.send_signed_copy_to_intern AS send_signed_copy_to_intern_23, t0.copy_to_intern_sent AS copy_to_intern_sent_24, t0.former_id AS former_id_25, t0.intern_id AS intern_id_26, t27.id AS id_28, t27.civility AS civility_29, t27.lastname AS lastname_30, t27.firstname AS firstname_31, t27.email AS email_32, t27.phone AS phone_33, t27.address AS address_34, t27.individual AS individual_35, t27.company AS company_36, t27.funding AS funding_37, t27.first_contact_date AS first_contact_date_38, t27.comment AS comment_39, t27.handicap AS handicap_40, t27.adaptation AS adaptation_41, t27.validation AS validation_42, t27.entry_date AS entry_date_43, t27.siret AS siret_44, t27.is_company AS is_company_45, t27.status AS status_46, t27.formation_id AS formation_id_47, t27.organization_id AS organization_id_48, t0.token_access_id AS token_access_id_49, t0.formation_entry_id AS formation_entry_id_50, t51.id AS id_52, t51.hour_duration AS hour_duration_53, t51.day_duration AS day_duration_54, t51.start_date AS start_date_55, t51.end_date AS end_date_56, t51.pre_tax_price AS pre_tax_price_57, t51.including_tax_price AS including_tax_price_58, t51.tva AS tva_59, t51.signature_date AS signature_date_60, t51.document_path AS document_path_61, t51.convention_status AS convention_status_62, t51.signed_convention_path AS signed_convention_path_63, t51.intern_signature_path AS intern_signature_path_64, t51.document_created_at AS document_created_at_65, t51.mail_status AS mail_status_66, t51.manually AS manually_67, t51.paid AS paid_68, t51.payment_date AS payment_date_69, t51.formation_session_id AS formation_session_id_70, t51.convention_id AS convention_id_71, t51.organization_id AS organization_id_72, t51.former_id AS former_id_73, t51.intern_id AS intern_id_74, t51.formation_leaving_id AS formation_leaving_id_75, t51.formation_entry_parent_id AS formation_entry_parent_id_76, t0.organization_id AS organization_id_77, t0.formation_session_id AS formation_session_id_78, t0.emargement_parent_id AS emargement_parent_id_79 FROM emargement t0 LEFT JOIN intern t27 ON t0.intern_id = t27.id LEFT JOIN formation_entry t51 ON t0.formation_entry_id = t51.id WHERE t0.token_access_id = ?
Parameters:
[
  94
]
35 0.46 ms
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.former_id = ?
Parameters:
[
  2
]
36 0.38 ms
SELECT t0.id AS id_1, t0.picture_path AS picture_path_2, t0.name AS name_3, t0.description AS description_4, t0.hour_duration AS hour_duration_5, t0.day_duration AS day_duration_6, t0.place AS place_7, t0.intern_profile AS intern_profile_8, t0.requirements AS requirements_9, t0.pre_tax_price AS pre_tax_price_10, t0.including_tax_price AS including_tax_price_11, t0.tva AS tva_12, t0.general_goals AS general_goals_13, t0.training_goals AS training_goals_14, t0.content AS content_15, t0.access_terms AS access_terms_16, t0.learning_resources AS learning_resources_17, t0.technical_resources AS technical_resources_18, t0.handicapped_access AS handicapped_access_19, t0.organization_terms AS organization_terms_20, t0.full_learning_resources AS full_learning_resources_21, t0.tracking AS tracking_22, t0.evaluation_system AS evaluation_system_23, t0.summary AS summary_24, t0.document_version AS document_version_25, t0.date AS date_26, t0.program_path AS program_path_27, t0.color AS color_28, t0.certification AS certification_29, t0.infos_certification AS infos_certification_30, t0.on_quote AS on_quote_31, t0.former_id AS former_id_32, t0.organization_id AS organization_id_33, t34.id AS id_35, t34.company_name AS company_name_36, t34.website AS website_37, t34.address AS address_38, t34.phone AS phone_39, t34.contact_email AS contact_email_40, t34.opening_hours AS opening_hours_41, t34.siret AS siret_42, t34.ape_naf AS ape_naf_43, t34.declaration_number AS declaration_number_44, t34.region AS region_45, t34.tva AS tva_46, t34.manager_lastname AS manager_lastname_47, t34.manager_firstname AS manager_firstname_48, t34.logo_path AS logo_path_49, t34.thumbnail_path AS thumbnail_path_50, t34.stamp_path AS stamp_path_51, t34.signature_path AS signature_path_52, t34.qualiopi_certified AS qualiopi_certified_53, t34.certificate_number AS certificate_number_54, t34.visibility AS visibility_55, t34.completed_after_registration AS completed_after_registration_56, t34.enabled AS enabled_57, t34.stripe_id AS stripe_id_58, t34.verified AS verified_59, t34.created_at AS created_at_60, t34.trial_days AS trial_days_61, t34.subscription_email AS subscription_email_62, t34.notif_sent AS notif_sent_63, t34.actions_nature AS actions_nature_64, t34.activate_qualiopi_mention AS activate_qualiopi_mention_65, t34.qualiopi_certificate_path AS qualiopi_certificate_path_66, t0.website_id AS website_id_67 FROM formation t0 LEFT JOIN organization t34 ON t0.organization_id = t34.id WHERE t0.former_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.

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\Document No errors.
App\Entity\FormationSessionFormer No errors.
App\Entity\TokenAccess No errors.
App\Entity\Financing No errors.
App\Entity\EndFormationReport No errors.
App\Entity\InternTracking No errors.
App\Entity\Prepositioning No errors.