Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          i0_.id AS id_0,
          i0_.created_at AS created_at_1,
          i0_.updated_at AS updated_at_2,
          i0_.motivation AS motivation_3,
          i0_.message AS message_4,
          i0_.refuse AS refuse_5,
          i0_.dif AS dif_6,
          i0_.type AS type_7
        FROM
          inscription i0_
          INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id
          AND t1_.type IN ('abstracttrainee', 'trainee')
          AND (t1_.id = i0_.trainee_id)
          INNER JOIN session s2_ ON i0_.session_id = s2_.id
          AND s2_.type IN ('session')
          AND (s2_.id = i0_.session_id)
          INNER JOIN (
            training t3_
            LEFT JOIN internship i4_ ON t3_.id = i4_.id
          ) ON s2_.training_id = t3_.id
          AND (t3_.id = s2_.training_id)
          LEFT JOIN training__training_tag t6_ ON t3_.id = t6_.training_id
          LEFT JOIN tag t5_ ON t5_.id = t6_.tag_id
          INNER JOIN organization o7_ ON t3_.organization_id = o7_.id
          AND o7_.type IN (
            'abstractorganization', 'organization'
          )
          AND (o7_.id = t3_.organization_id)
          INNER JOIN inscription_status i8_ ON i0_.inscription_status_id = i8_.id
          AND (
            i8_.id = i0_.inscription_status_id
          )
        WHERE
          (
            (
              (
                (
                  t1_.first_name LIKE ?
                  OR t1_.last_name LIKE ?
                  OR t3_.name LIKE ?
                )
                AND i0_.trainee_id = t1_.id
                AND s2_.training_id = t3_.id
                AND i0_.session_id = s2_.id
              )
              OR t5_.name LIKE ?
            )
            AND o7_.name IN (?)
            AND i8_.name IN (?)
          )
          AND i0_.type IN ('inscription')
        ORDER BY
          i0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.motivation AS motivation_3, i0_.message AS message_4, i0_.refuse AS refuse_5, i0_.dif AS dif_6, i0_.type AS type_7 FROM inscription i0_ INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id AND t1_.type IN ('abstracttrainee', 'trainee') AND (t1_.id = i0_.trainee_id) INNER JOIN session s2_ ON i0_.session_id = s2_.id AND s2_.type IN ('session') AND (s2_.id = i0_.session_id) INNER JOIN (training t3_ LEFT JOIN internship i4_ ON t3_.id = i4_.id) ON s2_.training_id = t3_.id AND (t3_.id = s2_.training_id) LEFT JOIN training__training_tag t6_ ON t3_.id = t6_.training_id LEFT JOIN tag t5_ ON t5_.id = t6_.tag_id INNER JOIN organization o7_ ON t3_.organization_id = o7_.id AND o7_.type IN ('abstractorganization', 'organization') AND (o7_.id = t3_.organization_id) INNER JOIN inscription_status i8_ ON i0_.inscription_status_id = i8_.id AND (i8_.id = i0_.inscription_status_id) WHERE ((((t1_.first_name LIKE '%%' OR t1_.last_name LIKE '%%' OR t3_.name LIKE '%%') AND i0_.trainee_id = t1_.id AND s2_.training_id = t3_.id AND i0_.session_id = s2_.id) OR t5_.name LIKE '%%') AND o7_.name IN ('AMU-DRH') AND i8_.name IN ('Désistement')) AND i0_.type IN ('inscription') ORDER BY i0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      updated_at_2
    FROM
      (
        SELECT
          i0_.id AS id_0,
          i0_.created_at AS created_at_1,
          i0_.updated_at AS updated_at_2,
          i0_.motivation AS motivation_3,
          i0_.message AS message_4,
          i0_.refuse AS refuse_5,
          i0_.dif AS dif_6,
          t1_.id AS id_7,
          t1_.created_at AS created_at_8,
          t1_.updated_at AS updated_at_9,
          t1_.salt AS salt_10,
          t1_.password AS password_11,
          t1_.is_active AS is_active_12,
          t1_.shibboleth_persistent_id AS shibboleth_persistent_id_13,
          t1_.data AS data_14,
          t1_.first_name AS first_name_15,
          t1_.last_name AS last_name_16,
          t1_.address_type AS address_type_17,
          t1_.address AS address_18,
          t1_.zip AS zip_19,
          t1_.city AS city_20,
          t1_.email AS email_21,
          t1_.phone_number AS phone_number_22,
          t1_.fax_number AS fax_number_23,
          t1_.website AS website_24,
          t1_.service AS service_25,
          t1_.is_paying AS is_paying_26,
          t1_.status AS status_27,
          t1_.birth_date AS birth_date_28,
          t1_.amu_statut AS amu_statut_29,
          t1_.bap AS bap_30,
          t1_.corps AS corps_31,
          t1_.category AS category_32,
          t1_.campus AS campus_33,
          t1_.first_name_sup AS first_name_sup_34,
          t1_.last_name_sup AS last_name_sup_35,
          t1_.email_sup AS email_sup_36,
          t1_.first_name_corr AS first_name_corr_37,
          t1_.last_name_corr AS last_name_corr_38,
          t1_.email_corr AS email_corr_39,
          t1_.fonction AS fonction_40,
          s2_.id AS id_41,
          s2_.promote AS promote_42,
          s2_.dateBegin AS dateBegin_43,
          s2_.dateEnd AS dateEnd_44,
          s2_.registration AS registration_45,
          s2_.status AS status_46,
          s2_.displayOnline AS displayOnline_47,
          s2_.numberOfRegistrations AS numberOfRegistrations_48,
          s2_.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_49,
          s2_.limitRegistrationDate AS limitRegistrationDate_50,
          s2_.comments AS comments_51,
          s2_.hourNumber AS hourNumber_52,
          s2_.dayNumber AS dayNumber_53,
          s2_.schedule AS schedule_54,
          s2_.place AS place_55,
          s2_.created_at AS created_at_56,
          s2_.updated_at AS updated_at_57,
          s2_.name AS name_58,
          s2_.price AS price_59,
          s2_.teaching_cost AS teaching_cost_60,
          s2_.vacation_cost AS vacation_cost_61,
          s2_.accommodation_cost AS accommodation_cost_62,
          s2_.meal_cost AS meal_cost_63,
          s2_.transport_cost AS transport_cost_64,
          s2_.material_cost AS material_cost_65,
          s2_.taking AS taking_66,
          t3_.id AS id_67,
          t3_.number AS number_68,
          t3_.name AS name_69,
          t3_.program AS program_70,
          t3_.description AS description_71,
          t3_.teaching_methods AS teaching_methods_72,
          t3_.interventionType AS interventionType_73,
          t3_.externalInitiative AS externalInitiative_74,
          t3_.firstSessionPeriodSemester AS firstSessionPeriodSemester_75,
          t3_.firstSessionPeriodYear AS firstSessionPeriodYear_76,
          t3_.comments AS comments_77,
          t3_.created_at AS created_at_78,
          t3_.updated_at AS updated_at_79,
          i4_.prerequisites AS prerequisites_80,
          i4_.designated_public AS designated_public_81,
          o5_.address_type AS address_type_82,
          o5_.address AS address_83,
          o5_.zip AS zip_84,
          o5_.city AS city_85,
          o5_.email AS email_86,
          o5_.phone_number AS phone_number_87,
          o5_.fax_number AS fax_number_88,
          o5_.website AS website_89,
          o5_.id AS id_90,
          o5_.name AS name_91,
          o5_.code AS code_92,
          o5_.trainee_registrable AS trainee_registrable_93,
          i6_.id AS id_94,
          i6_.name AS name_95,
          i6_.private AS private_96,
          i6_.machine_name AS machine_name_97,
          i6_.position AS position_98,
          i6_.status AS status_99,
          i6_.notify AS notify_100,
          t7_.id AS id_101,
          t7_.name AS name_102,
          t7_.private AS private_103,
          t7_.machine_name AS machine_name_104,
          t7_.position AS position_105,
          i0_.type AS type_106,
          t1_.type AS type_107,
          s2_.type AS type_108,
          t3_.type AS type_109,
          o5_.type AS type_110
        FROM
          inscription i0_
          INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id
          AND t1_.type IN ('abstracttrainee', 'trainee')
          AND (t1_.id = i0_.trainee_id)
          INNER JOIN session s2_ ON i0_.session_id = s2_.id
          AND s2_.type IN ('session')
          AND (s2_.id = i0_.session_id)
          INNER JOIN (
            training t3_
            LEFT JOIN internship i4_ ON t3_.id = i4_.id
          ) ON s2_.training_id = t3_.id
          AND (t3_.id = s2_.training_id)
          LEFT JOIN training__training_tag t8_ ON t3_.id = t8_.training_id
          LEFT JOIN tag t7_ ON t7_.id = t8_.tag_id
          INNER JOIN organization o5_ ON t3_.organization_id = o5_.id
          AND o5_.type IN (
            'abstractorganization', 'organization'
          )
          AND (o5_.id = t3_.organization_id)
          INNER JOIN inscription_status i6_ ON i0_.inscription_status_id = i6_.id
          AND (
            i6_.id = i0_.inscription_status_id
          )
        WHERE
          (
            (
              (
                (
                  t1_.first_name LIKE ?
                  OR t1_.last_name LIKE ?
                  OR t3_.name LIKE ?
                )
                AND i0_.trainee_id = t1_.id
                AND s2_.training_id = t3_.id
                AND i0_.session_id = s2_.id
              )
              OR t7_.name LIKE ?
            )
            AND o5_.name IN (?)
            AND i6_.name IN (?)
          )
          AND i0_.type IN ('inscription')
      ) dctrn_result_inner
    ORDER BY
      updated_at_2 DESC
  ) dctrn_result
LIMIT
  5

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, updated_at_2 FROM (SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.motivation AS motivation_3, i0_.message AS message_4, i0_.refuse AS refuse_5, i0_.dif AS dif_6, t1_.id AS id_7, t1_.created_at AS created_at_8, t1_.updated_at AS updated_at_9, t1_.salt AS salt_10, t1_.password AS password_11, t1_.is_active AS is_active_12, t1_.shibboleth_persistent_id AS shibboleth_persistent_id_13, t1_.data AS data_14, t1_.first_name AS first_name_15, t1_.last_name AS last_name_16, t1_.address_type AS address_type_17, t1_.address AS address_18, t1_.zip AS zip_19, t1_.city AS city_20, t1_.email AS email_21, t1_.phone_number AS phone_number_22, t1_.fax_number AS fax_number_23, t1_.website AS website_24, t1_.service AS service_25, t1_.is_paying AS is_paying_26, t1_.status AS status_27, t1_.birth_date AS birth_date_28, t1_.amu_statut AS amu_statut_29, t1_.bap AS bap_30, t1_.corps AS corps_31, t1_.category AS category_32, t1_.campus AS campus_33, t1_.first_name_sup AS first_name_sup_34, t1_.last_name_sup AS last_name_sup_35, t1_.email_sup AS email_sup_36, t1_.first_name_corr AS first_name_corr_37, t1_.last_name_corr AS last_name_corr_38, t1_.email_corr AS email_corr_39, t1_.fonction AS fonction_40, s2_.id AS id_41, s2_.promote AS promote_42, s2_.dateBegin AS dateBegin_43, s2_.dateEnd AS dateEnd_44, s2_.registration AS registration_45, s2_.status AS status_46, s2_.displayOnline AS displayOnline_47, s2_.numberOfRegistrations AS numberOfRegistrations_48, s2_.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_49, s2_.limitRegistrationDate AS limitRegistrationDate_50, s2_.comments AS comments_51, s2_.hourNumber AS hourNumber_52, s2_.dayNumber AS dayNumber_53, s2_.schedule AS schedule_54, s2_.place AS place_55, s2_.created_at AS created_at_56, s2_.updated_at AS updated_at_57, s2_.name AS name_58, s2_.price AS price_59, s2_.teaching_cost AS teaching_cost_60, s2_.vacation_cost AS vacation_cost_61, s2_.accommodation_cost AS accommodation_cost_62, s2_.meal_cost AS meal_cost_63, s2_.transport_cost AS transport_cost_64, s2_.material_cost AS material_cost_65, s2_.taking AS taking_66, t3_.id AS id_67, t3_.number AS number_68, t3_.name AS name_69, t3_.program AS program_70, t3_.description AS description_71, t3_.teaching_methods AS teaching_methods_72, t3_.interventionType AS interventionType_73, t3_.externalInitiative AS externalInitiative_74, t3_.firstSessionPeriodSemester AS firstSessionPeriodSemester_75, t3_.firstSessionPeriodYear AS firstSessionPeriodYear_76, t3_.comments AS comments_77, t3_.created_at AS created_at_78, t3_.updated_at AS updated_at_79, i4_.prerequisites AS prerequisites_80, i4_.designated_public AS designated_public_81, o5_.address_type AS address_type_82, o5_.address AS address_83, o5_.zip AS zip_84, o5_.city AS city_85, o5_.email AS email_86, o5_.phone_number AS phone_number_87, o5_.fax_number AS fax_number_88, o5_.website AS website_89, o5_.id AS id_90, o5_.name AS name_91, o5_.code AS code_92, o5_.trainee_registrable AS trainee_registrable_93, i6_.id AS id_94, i6_.name AS name_95, i6_.private AS private_96, i6_.machine_name AS machine_name_97, i6_.position AS position_98, i6_.status AS status_99, i6_.notify AS notify_100, t7_.id AS id_101, t7_.name AS name_102, t7_.private AS private_103, t7_.machine_name AS machine_name_104, t7_.position AS position_105, i0_.type AS type_106, t1_.type AS type_107, s2_.type AS type_108, t3_.type AS type_109, o5_.type AS type_110 FROM inscription i0_ INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id AND t1_.type IN ('abstracttrainee', 'trainee') AND (t1_.id = i0_.trainee_id) INNER JOIN session s2_ ON i0_.session_id = s2_.id AND s2_.type IN ('session') AND (s2_.id = i0_.session_id) INNER JOIN (training t3_ LEFT JOIN internship i4_ ON t3_.id = i4_.id) ON s2_.training_id = t3_.id AND (t3_.id = s2_.training_id) LEFT JOIN training__training_tag t8_ ON t3_.id = t8_.training_id LEFT JOIN tag t7_ ON t7_.id = t8_.tag_id INNER JOIN organization o5_ ON t3_.organization_id = o5_.id AND o5_.type IN ('abstractorganization', 'organization') AND (o5_.id = t3_.organization_id) INNER JOIN inscription_status i6_ ON i0_.inscription_status_id = i6_.id AND (i6_.id = i0_.inscription_status_id) WHERE ((((t1_.first_name LIKE '%%' OR t1_.last_name LIKE '%%' OR t3_.name LIKE '%%') AND i0_.trainee_id = t1_.id AND s2_.training_id = t3_.id AND i0_.session_id = s2_.id) OR t7_.name LIKE '%%') AND o5_.name IN ('AMU-DRH') AND i6_.name IN ('Désistement')) AND i0_.type IN ('inscription')) dctrn_result_inner ORDER BY updated_at_2 DESC) dctrn_result LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.last_login AS last_login_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.access_rights AS access_rights_7,
  t0.organization_id AS organization_id_8
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.last_login AS last_login_4, t0.roles AS roles_5, t0.password AS password_6, t0.access_rights AS access_rights_7, t0.organization_id AS organization_id_8 FROM user t0 WHERE t0.username = 'jlidi.m@univ-amu.fr' LIMIT 1;

SELECT
  t0.address_type AS address_type_1,
  t0.address AS address_2,
  t0.zip AS zip_3,
  t0.city AS city_4,
  t0.email AS email_5,
  t0.phone_number AS phone_number_6,
  t0.fax_number AS fax_number_7,
  t0.website AS website_8,
  t0.id AS id_9,
  t0.name AS name_10,
  t0.code AS code_11,
  t0.trainee_registrable AS trainee_registrable_12,
  t0.institution_id AS institution_id_13,
  t0.type
FROM
  organization t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'abstractorganization', 'organization'
  )

SELECT t0.address_type AS address_type_1, t0.address AS address_2, t0.zip AS zip_3, t0.city AS city_4, t0.email AS email_5, t0.phone_number AS phone_number_6, t0.fax_number AS fax_number_7, t0.website AS website_8, t0.id AS id_9, t0.name AS name_10, t0.code AS code_11, t0.trainee_registrable AS trainee_registrable_12, t0.institution_id AS institution_id_13, t0.type FROM organization t0 WHERE t0.id = 1 AND t0.type IN ('abstractorganization', 'organization');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.shibboleth_persistent_id AS shibboleth_persistent_id_7,
  t0.data AS data_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.address_type AS address_type_11,
  t0.address AS address_12,
  t0.zip AS zip_13,
  t0.city AS city_14,
  t0.email AS email_15,
  t0.phone_number AS phone_number_16,
  t0.fax_number AS fax_number_17,
  t0.website AS website_18,
  t0.service AS service_19,
  t0.is_paying AS is_paying_20,
  t0.status AS status_21,
  t0.institution_id AS institution_id_22,
  t0.title_id AS title_id_23,
  t0.publictype_id AS publictype_id_24,
  t0.type,
  t0.birth_date AS birth_date_25,
  t0.amu_statut AS amu_statut_26,
  t0.bap AS bap_27,
  t0.corps AS corps_28,
  t0.category AS category_29,
  t0.campus AS campus_30,
  t0.first_name_sup AS first_name_sup_31,
  t0.last_name_sup AS last_name_sup_32,
  t0.email_sup AS email_sup_33,
  t0.first_name_corr AS first_name_corr_34,
  t0.last_name_corr AS last_name_corr_35,
  t0.email_corr AS email_corr_36,
  t0.fonction AS fonction_37
FROM
  trainee t0
WHERE
  t0.id = ?
  AND t0.type IN ('abstracttrainee', 'trainee')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.salt AS salt_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.shibboleth_persistent_id AS shibboleth_persistent_id_7, t0.data AS data_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.address_type AS address_type_11, t0.address AS address_12, t0.zip AS zip_13, t0.city AS city_14, t0.email AS email_15, t0.phone_number AS phone_number_16, t0.fax_number AS fax_number_17, t0.website AS website_18, t0.service AS service_19, t0.is_paying AS is_paying_20, t0.status AS status_21, t0.institution_id AS institution_id_22, t0.title_id AS title_id_23, t0.publictype_id AS publictype_id_24, t0.type, t0.birth_date AS birth_date_25, t0.amu_statut AS amu_statut_26, t0.bap AS bap_27, t0.corps AS corps_28, t0.category AS category_29, t0.campus AS campus_30, t0.first_name_sup AS first_name_sup_31, t0.last_name_sup AS last_name_sup_32, t0.email_sup AS email_sup_33, t0.first_name_corr AS first_name_corr_34, t0.last_name_corr AS last_name_corr_35, t0.email_corr AS email_corr_36, t0.fonction AS fonction_37 FROM trainee t0 WHERE t0.id = 12 AND t0.type IN ('abstracttrainee', 'trainee');

SELECT
  COUNT(*)
FROM
  inscription t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('inscription')

SELECT COUNT(*) FROM inscription t0 WHERE t0.session_id = 54 AND t0.type IN ('inscription');

SELECT
  t0.id AS id_1,
  t0.is_archived AS is_archived_2,
  t0.is_allow_send_mail AS is_allow_send_mail_3,
  t0.is_organization AS is_organization_4,
  t0.is_public AS is_public_5,
  t0.comments AS comments_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.address_type AS address_type_11,
  t0.address AS address_12,
  t0.zip AS zip_13,
  t0.city AS city_14,
  t0.email AS email_15,
  t0.phone_number AS phone_number_16,
  t0.fax_number AS fax_number_17,
  t0.website AS website_18,
  t0.service AS service_19,
  t0.is_paying AS is_paying_20,
  t0.status AS status_21,
  t0.organization_id AS organization_id_22,
  t0.trainer_type_id AS trainer_type_id_23,
  t0.title_id AS title_id_24,
  t0.institution_id AS institution_id_25,
  t0.publictype_id AS publictype_id_26,
  t0.type
FROM
  trainer t0
WHERE
  t0.id = ?
  AND t0.type IN ('abstracttrainer', 'trainer')

SELECT t0.id AS id_1, t0.is_archived AS is_archived_2, t0.is_allow_send_mail AS is_allow_send_mail_3, t0.is_organization AS is_organization_4, t0.is_public AS is_public_5, t0.comments AS comments_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.address_type AS address_type_11, t0.address AS address_12, t0.zip AS zip_13, t0.city AS city_14, t0.email AS email_15, t0.phone_number AS phone_number_16, t0.fax_number AS fax_number_17, t0.website AS website_18, t0.service AS service_19, t0.is_paying AS is_paying_20, t0.status AS status_21, t0.organization_id AS organization_id_22, t0.trainer_type_id AS trainer_type_id_23, t0.title_id AS title_id_24, t0.institution_id AS institution_id_25, t0.publictype_id AS publictype_id_26, t0.type FROM trainer t0 WHERE t0.id = 6 AND t0.type IN ('abstracttrainer', 'trainer');

SELECT
  t0.id AS id_1,
  t0.note AS note_2,
  t0.inscription_id AS inscription_id_3,
  t0.criterion_id AS criterion_id_4
FROM
  evaluation_noted_criterion t0
WHERE
  t0.inscription_id = ?

SELECT t0.id AS id_1, t0.note AS note_2, t0.inscription_id AS inscription_id_3, t0.criterion_id AS criterion_id_4 FROM evaluation_noted_criterion t0 WHERE t0.inscription_id = 41;

SELECT
  i0_.id AS id_0,
  i0_.created_at AS created_at_1,
  i0_.updated_at AS updated_at_2,
  i0_.motivation AS motivation_3,
  i0_.message AS message_4,
  i0_.refuse AS refuse_5,
  i0_.dif AS dif_6,
  i0_.type AS type_7,
  i0_.trainee_id AS trainee_id_8,
  i0_.session_id AS session_id_9,
  i0_.inscription_status_id AS inscription_status_id_10,
  i0_.presence_status_id AS presence_status_id_11,
  i0_.actiontype_id AS actiontype_id_12
FROM
  inscription i0_
  INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id
  AND t1_.type IN ('abstracttrainee', 'trainee')
  AND (t1_.id = i0_.trainee_id)
  INNER JOIN session s2_ ON i0_.session_id = s2_.id
  AND s2_.type IN ('session')
  AND (s2_.id = i0_.session_id)
  INNER JOIN (
    training t3_
    LEFT JOIN internship i4_ ON t3_.id = i4_.id
  ) ON s2_.training_id = t3_.id
  AND (t3_.id = s2_.training_id)
  LEFT JOIN training__training_tag t6_ ON t3_.id = t6_.training_id
  LEFT JOIN tag t5_ ON t5_.id = t6_.tag_id
  INNER JOIN organization o7_ ON t3_.organization_id = o7_.id
  AND o7_.type IN (
    'abstractorganization', 'organization'
  )
  AND (o7_.id = t3_.organization_id)
  INNER JOIN inscription_status i8_ ON i0_.inscription_status_id = i8_.id
  AND (
    i8_.id = i0_.inscription_status_id
  )
WHERE
  (
    (
      (
        (
          t1_.first_name LIKE ?
          OR t1_.last_name LIKE ?
          OR t3_.name LIKE ?
        )
        AND i0_.trainee_id = t1_.id
        AND s2_.training_id = t3_.id
        AND i0_.session_id = s2_.id
      )
      OR t5_.name LIKE ?
    )
    AND o7_.name IN (?)
    AND i8_.name IN (?)
    AND i0_.id IN (?, ?, ?, ?, ?)
  )
  AND i0_.type IN ('inscription')
ORDER BY
  i0_.updated_at DESC

SELECT i0_.id AS id_0, i0_.created_at AS created_at_1, i0_.updated_at AS updated_at_2, i0_.motivation AS motivation_3, i0_.message AS message_4, i0_.refuse AS refuse_5, i0_.dif AS dif_6, i0_.type AS type_7, i0_.trainee_id AS trainee_id_8, i0_.session_id AS session_id_9, i0_.inscription_status_id AS inscription_status_id_10, i0_.presence_status_id AS presence_status_id_11, i0_.actiontype_id AS actiontype_id_12 FROM inscription i0_ INNER JOIN trainee t1_ ON i0_.trainee_id = t1_.id AND t1_.type IN ('abstracttrainee', 'trainee') AND (t1_.id = i0_.trainee_id) INNER JOIN session s2_ ON i0_.session_id = s2_.id AND s2_.type IN ('session') AND (s2_.id = i0_.session_id) INNER JOIN (training t3_ LEFT JOIN internship i4_ ON t3_.id = i4_.id) ON s2_.training_id = t3_.id AND (t3_.id = s2_.training_id) LEFT JOIN training__training_tag t6_ ON t3_.id = t6_.training_id LEFT JOIN tag t5_ ON t5_.id = t6_.tag_id INNER JOIN organization o7_ ON t3_.organization_id = o7_.id AND o7_.type IN ('abstractorganization', 'organization') AND (o7_.id = t3_.organization_id) INNER JOIN inscription_status i8_ ON i0_.inscription_status_id = i8_.id AND (i8_.id = i0_.inscription_status_id) WHERE ((((t1_.first_name LIKE '%%' OR t1_.last_name LIKE '%%' OR t3_.name LIKE '%%') AND i0_.trainee_id = t1_.id AND s2_.training_id = t3_.id AND i0_.session_id = s2_.id) OR t5_.name LIKE '%%') AND o7_.name IN ('AMU-DRH') AND i8_.name IN ('Désistement') AND i0_.id IN (41, 52726, 53756, 54145, 52725)) AND i0_.type IN ('inscription') ORDER BY i0_.updated_at DESC;

SELECT
  t0.id AS id_1,
  t0.promote AS promote_2,
  t0.dateBegin AS dateBegin_3,
  t0.dateEnd AS dateEnd_4,
  t0.registration AS registration_5,
  t0.status AS status_6,
  t0.displayOnline AS displayOnline_7,
  t0.numberOfRegistrations AS numberOfRegistrations_8,
  t0.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_9,
  t0.limitRegistrationDate AS limitRegistrationDate_10,
  t0.comments AS comments_11,
  t0.hourNumber AS hourNumber_12,
  t0.dayNumber AS dayNumber_13,
  t0.schedule AS schedule_14,
  t0.place AS place_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.name AS name_18,
  t0.price AS price_19,
  t0.teaching_cost AS teaching_cost_20,
  t0.vacation_cost AS vacation_cost_21,
  t0.accommodation_cost AS accommodation_cost_22,
  t0.meal_cost AS meal_cost_23,
  t0.transport_cost AS transport_cost_24,
  t0.material_cost AS material_cost_25,
  t0.taking AS taking_26,
  t0.training_id AS training_id_27,
  t0.sessionType_id AS sessionType_id_28,
  t0.type
FROM
  session t0
WHERE
  t0.id = ?
  AND t0.type IN ('session')

SELECT t0.id AS id_1, t0.promote AS promote_2, t0.dateBegin AS dateBegin_3, t0.dateEnd AS dateEnd_4, t0.registration AS registration_5, t0.status AS status_6, t0.displayOnline AS displayOnline_7, t0.numberOfRegistrations AS numberOfRegistrations_8, t0.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_9, t0.limitRegistrationDate AS limitRegistrationDate_10, t0.comments AS comments_11, t0.hourNumber AS hourNumber_12, t0.dayNumber AS dayNumber_13, t0.schedule AS schedule_14, t0.place AS place_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.name AS name_18, t0.price AS price_19, t0.teaching_cost AS teaching_cost_20, t0.vacation_cost AS vacation_cost_21, t0.accommodation_cost AS accommodation_cost_22, t0.meal_cost AS meal_cost_23, t0.transport_cost AS transport_cost_24, t0.material_cost AS material_cost_25, t0.taking AS taking_26, t0.training_id AS training_id_27, t0.sessionType_id AS sessionType_id_28, t0.type FROM session t0 WHERE t0.id = 54 AND t0.type IN ('session');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.private AS private_3,
  t0.machine_name AS machine_name_4,
  t0.position AS position_5,
  t0.organization_id AS organization_id_6
FROM
  publictype t0
  INNER JOIN internship__internship_publictype ON t0.id = internship__internship_publictype.publictype_id
WHERE
  internship__internship_publictype.intership_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.private AS private_3, t0.machine_name AS machine_name_4, t0.position AS position_5, t0.organization_id AS organization_id_6 FROM publictype t0 INNER JOIN internship__internship_publictype ON t0.id = internship__internship_publictype.publictype_id WHERE internship__internship_publictype.intership_id = 33;

SELECT
  t0.id AS id_1,
  t0.dateBegin AS dateBegin_2,
  t0.morning AS morning_3,
  t0.afternoon AS afternoon_4,
  t0.inscription_id AS inscription_id_5
FROM
  presence t0
WHERE
  t0.inscription_id = ?
ORDER BY
  t0.dateBegin ASC

SELECT t0.id AS id_1, t0.dateBegin AS dateBegin_2, t0.morning AS morning_3, t0.afternoon AS afternoon_4, t0.inscription_id AS inscription_id_5 FROM presence t0 WHERE t0.inscription_id = 41 ORDER BY t0.dateBegin ASC;