Query Metrics
36
Database Queries
17
Different statements
7.19 ms
Query time
1
Invalid entities
Queries
| #▲ | 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 |
|
| 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. |