Symfony Profiler

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.id = ?

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.id = 44;

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.name AS name_2,
  t0.idp AS idp_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.address_type AS address_type_6,
  t0.address AS address_7,
  t0.zip AS zip_8,
  t0.city AS city_9,
  t0.email AS email_10,
  t0.phone_number AS phone_number_11,
  t0.fax_number AS fax_number_12,
  t0.website AS website_13,
  t0.type
FROM
  institution t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'abstractinstitution', 'institution'
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.idp AS idp_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.address_type AS address_type_6, t0.address AS address_7, t0.zip AS zip_8, t0.city AS city_9, t0.email AS email_10, t0.phone_number AS phone_number_11, t0.fax_number AS fax_number_12, t0.website AS website_13, t0.type FROM institution t0 WHERE t0.id = 1 AND t0.type IN ('abstractinstitution', 'institution');

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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.number AS number_1,
          t0_.name AS name_2,
          t0_.program AS program_3,
          t0_.description AS description_4,
          t0_.teaching_methods AS teaching_methods_5,
          t0_.interventionType AS interventionType_6,
          t0_.externalInitiative AS externalInitiative_7,
          t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8,
          t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9,
          t0_.comments AS comments_10,
          t0_.created_at AS created_at_11,
          t0_.updated_at AS updated_at_12,
          i1_.prerequisites AS prerequisites_13,
          i1_.designated_public AS designated_public_14,
          t0_.type AS type_15
        FROM
          internship i1_
          INNER JOIN training t0_ ON i1_.id = t0_.id
          LEFT JOIN training__training_tag t3_ ON t0_.id = t3_.training_id
          LEFT JOIN tag t2_ ON t2_.id = t3_.tag_id
          INNER JOIN organization o4_ ON t0_.organization_id = o4_.id
          AND o4_.type IN (
            'abstractorganization', 'organization'
          )
          AND (o4_.id = t0_.organization_id)
          INNER JOIN session s5_ ON (s5_.training_id = t0_.id)
          AND s5_.type IN ('session')
        WHERE
          (
            (
              t0_.name LIKE ?
              OR t0_.number = ?
            )
            OR t2_.name LIKE ?
          )
          AND o4_.name IN (?)
          AND YEAR(s5_.dateBegin) IN (?)
          AND (
            MONTH(s5_.dateBegin) BETWEEN ?
            AND ?
          )
        ORDER BY
          t0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT t0_.id AS id_0, t0_.number AS number_1, t0_.name AS name_2, t0_.program AS program_3, t0_.description AS description_4, t0_.teaching_methods AS teaching_methods_5, t0_.interventionType AS interventionType_6, t0_.externalInitiative AS externalInitiative_7, t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8, t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9, t0_.comments AS comments_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, i1_.prerequisites AS prerequisites_13, i1_.designated_public AS designated_public_14, t0_.type AS type_15 FROM internship i1_ INNER JOIN training t0_ ON i1_.id = t0_.id LEFT JOIN training__training_tag t3_ ON t0_.id = t3_.training_id LEFT JOIN tag t2_ ON t2_.id = t3_.tag_id INNER JOIN organization o4_ ON t0_.organization_id = o4_.id AND o4_.type IN ('abstractorganization', 'organization') AND (o4_.id = t0_.organization_id) INNER JOIN session s5_ ON (s5_.training_id = t0_.id) AND s5_.type IN ('session') WHERE ((t0_.name LIKE '%%' OR t0_.number = '') OR t2_.name LIKE '%%') AND o4_.name IN ('AMU-DRH') AND YEAR(s5_.dateBegin) IN ('2026') AND (MONTH(s5_.dateBegin) BETWEEN 0 AND 6) ORDER BY t0_.name ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      name_2
    FROM
      (
        SELECT
          t0_.id AS id_0,
          t0_.number AS number_1,
          t0_.name AS name_2,
          t0_.program AS program_3,
          t0_.description AS description_4,
          t0_.teaching_methods AS teaching_methods_5,
          t0_.interventionType AS interventionType_6,
          t0_.externalInitiative AS externalInitiative_7,
          t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8,
          t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9,
          t0_.comments AS comments_10,
          t0_.created_at AS created_at_11,
          t0_.updated_at AS updated_at_12,
          i1_.prerequisites AS prerequisites_13,
          i1_.designated_public AS designated_public_14,
          o2_.address_type AS address_type_15,
          o2_.address AS address_16,
          o2_.zip AS zip_17,
          o2_.city AS city_18,
          o2_.email AS email_19,
          o2_.phone_number AS phone_number_20,
          o2_.fax_number AS fax_number_21,
          o2_.website AS website_22,
          o2_.id AS id_23,
          o2_.name AS name_24,
          o2_.code AS code_25,
          o2_.trainee_registrable AS trainee_registrable_26,
          s3_.id AS id_27,
          s3_.promote AS promote_28,
          s3_.dateBegin AS dateBegin_29,
          s3_.dateEnd AS dateEnd_30,
          s3_.registration AS registration_31,
          s3_.status AS status_32,
          s3_.displayOnline AS displayOnline_33,
          s3_.numberOfRegistrations AS numberOfRegistrations_34,
          s3_.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_35,
          s3_.limitRegistrationDate AS limitRegistrationDate_36,
          s3_.comments AS comments_37,
          s3_.hourNumber AS hourNumber_38,
          s3_.dayNumber AS dayNumber_39,
          s3_.schedule AS schedule_40,
          s3_.place AS place_41,
          s3_.created_at AS created_at_42,
          s3_.updated_at AS updated_at_43,
          s3_.name AS name_44,
          s3_.price AS price_45,
          s3_.teaching_cost AS teaching_cost_46,
          s3_.vacation_cost AS vacation_cost_47,
          s3_.accommodation_cost AS accommodation_cost_48,
          s3_.meal_cost AS meal_cost_49,
          s3_.transport_cost AS transport_cost_50,
          s3_.material_cost AS material_cost_51,
          s3_.taking AS taking_52,
          t4_.id AS id_53,
          t4_.name AS name_54,
          t4_.private AS private_55,
          t4_.machine_name AS machine_name_56,
          t4_.position AS position_57,
          t0_.type AS type_58,
          o2_.type AS type_59,
          s3_.type AS type_60
        FROM
          internship i1_
          INNER JOIN training t0_ ON i1_.id = t0_.id
          LEFT JOIN training__training_tag t5_ ON t0_.id = t5_.training_id
          LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id
          INNER JOIN organization o2_ ON t0_.organization_id = o2_.id
          AND o2_.type IN (
            'abstractorganization', 'organization'
          )
          AND (o2_.id = t0_.organization_id)
          INNER JOIN session s3_ ON (s3_.training_id = t0_.id)
          AND s3_.type IN ('session')
        WHERE
          (
            (
              t0_.name LIKE ?
              OR t0_.number = ?
            )
            OR t4_.name LIKE ?
          )
          AND o2_.name IN (?)
          AND YEAR(s3_.dateBegin) IN (?)
          AND (
            MONTH(s3_.dateBegin) BETWEEN ?
            AND ?
          )
      ) dctrn_result_inner
    ORDER BY
      name_2 ASC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, name_2 FROM (SELECT t0_.id AS id_0, t0_.number AS number_1, t0_.name AS name_2, t0_.program AS program_3, t0_.description AS description_4, t0_.teaching_methods AS teaching_methods_5, t0_.interventionType AS interventionType_6, t0_.externalInitiative AS externalInitiative_7, t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8, t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9, t0_.comments AS comments_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, i1_.prerequisites AS prerequisites_13, i1_.designated_public AS designated_public_14, o2_.address_type AS address_type_15, o2_.address AS address_16, o2_.zip AS zip_17, o2_.city AS city_18, o2_.email AS email_19, o2_.phone_number AS phone_number_20, o2_.fax_number AS fax_number_21, o2_.website AS website_22, o2_.id AS id_23, o2_.name AS name_24, o2_.code AS code_25, o2_.trainee_registrable AS trainee_registrable_26, s3_.id AS id_27, s3_.promote AS promote_28, s3_.dateBegin AS dateBegin_29, s3_.dateEnd AS dateEnd_30, s3_.registration AS registration_31, s3_.status AS status_32, s3_.displayOnline AS displayOnline_33, s3_.numberOfRegistrations AS numberOfRegistrations_34, s3_.maximumNumberOfRegistrations AS maximumNumberOfRegistrations_35, s3_.limitRegistrationDate AS limitRegistrationDate_36, s3_.comments AS comments_37, s3_.hourNumber AS hourNumber_38, s3_.dayNumber AS dayNumber_39, s3_.schedule AS schedule_40, s3_.place AS place_41, s3_.created_at AS created_at_42, s3_.updated_at AS updated_at_43, s3_.name AS name_44, s3_.price AS price_45, s3_.teaching_cost AS teaching_cost_46, s3_.vacation_cost AS vacation_cost_47, s3_.accommodation_cost AS accommodation_cost_48, s3_.meal_cost AS meal_cost_49, s3_.transport_cost AS transport_cost_50, s3_.material_cost AS material_cost_51, s3_.taking AS taking_52, t4_.id AS id_53, t4_.name AS name_54, t4_.private AS private_55, t4_.machine_name AS machine_name_56, t4_.position AS position_57, t0_.type AS type_58, o2_.type AS type_59, s3_.type AS type_60 FROM internship i1_ INNER JOIN training t0_ ON i1_.id = t0_.id LEFT JOIN training__training_tag t5_ ON t0_.id = t5_.training_id LEFT JOIN tag t4_ ON t4_.id = t5_.tag_id INNER JOIN organization o2_ ON t0_.organization_id = o2_.id AND o2_.type IN ('abstractorganization', 'organization') AND (o2_.id = t0_.organization_id) INNER JOIN session s3_ ON (s3_.training_id = t0_.id) AND s3_.type IN ('session') WHERE ((t0_.name LIKE '%%' OR t0_.number = '') OR t4_.name LIKE '%%') AND o2_.name IN ('AMU-DRH') AND YEAR(s3_.dateBegin) IN ('2026') AND (MONTH(s3_.dateBegin) BETWEEN 0 AND 6)) dctrn_result_inner ORDER BY name_2 ASC) dctrn_result LIMIT 50;

SELECT
  t0_.id AS id_0,
  t0_.number AS number_1,
  t0_.name AS name_2,
  t0_.program AS program_3,
  t0_.description AS description_4,
  t0_.teaching_methods AS teaching_methods_5,
  t0_.interventionType AS interventionType_6,
  t0_.externalInitiative AS externalInitiative_7,
  t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8,
  t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9,
  t0_.comments AS comments_10,
  t0_.created_at AS created_at_11,
  t0_.updated_at AS updated_at_12,
  i1_.prerequisites AS prerequisites_13,
  i1_.designated_public AS designated_public_14,
  t0_.type AS type_15,
  t0_.organization_id AS organization_id_16,
  t0_.theme_id AS theme_id_17,
  t0_.institution_id AS institution_id_18,
  t0_.supervisor_id AS supervisor_id_19,
  t0_.category_id AS category_id_20
FROM
  internship i1_
  INNER JOIN training t0_ ON i1_.id = t0_.id
  LEFT JOIN training__training_tag t3_ ON t0_.id = t3_.training_id
  LEFT JOIN tag t2_ ON t2_.id = t3_.tag_id
  INNER JOIN organization o4_ ON t0_.organization_id = o4_.id
  AND o4_.type IN (
    'abstractorganization', 'organization'
  )
  AND (o4_.id = t0_.organization_id)
  INNER JOIN session s5_ ON (s5_.training_id = t0_.id)
  AND s5_.type IN ('session')
WHERE
  (
    (
      t0_.name LIKE ?
      OR t0_.number = ?
    )
    OR t2_.name LIKE ?
  )
  AND o4_.name IN (?)
  AND YEAR(s5_.dateBegin) IN (?)
  AND (
    MONTH(s5_.dateBegin) BETWEEN ?
    AND ?
  )
  AND t0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.number AS number_1, t0_.name AS name_2, t0_.program AS program_3, t0_.description AS description_4, t0_.teaching_methods AS teaching_methods_5, t0_.interventionType AS interventionType_6, t0_.externalInitiative AS externalInitiative_7, t0_.firstSessionPeriodSemester AS firstSessionPeriodSemester_8, t0_.firstSessionPeriodYear AS firstSessionPeriodYear_9, t0_.comments AS comments_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, i1_.prerequisites AS prerequisites_13, i1_.designated_public AS designated_public_14, t0_.type AS type_15, t0_.organization_id AS organization_id_16, t0_.theme_id AS theme_id_17, t0_.institution_id AS institution_id_18, t0_.supervisor_id AS supervisor_id_19, t0_.category_id AS category_id_20 FROM internship i1_ INNER JOIN training t0_ ON i1_.id = t0_.id LEFT JOIN training__training_tag t3_ ON t0_.id = t3_.training_id LEFT JOIN tag t2_ ON t2_.id = t3_.tag_id INNER JOIN organization o4_ ON t0_.organization_id = o4_.id AND o4_.type IN ('abstractorganization', 'organization') AND (o4_.id = t0_.organization_id) INNER JOIN session s5_ ON (s5_.training_id = t0_.id) AND s5_.type IN ('session') WHERE ((t0_.name LIKE '%%' OR t0_.number = '') OR t2_.name LIKE '%%') AND o4_.name IN ('AMU-DRH') AND YEAR(s5_.dateBegin) IN ('2026') AND (MONTH(s5_.dateBegin) BETWEEN 0 AND 6) AND t0_.id IN (2811, 2813, 2807, 2788, 2675, 2620, 2810, 2805, 2814) ORDER BY t0_.name ASC;

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.training_id AS training_id_18,
  t0.sessionType_id AS sessionType_id_19,
  t0.type,
  t0.name AS name_20,
  t0.price AS price_21,
  t0.teaching_cost AS teaching_cost_22,
  t0.vacation_cost AS vacation_cost_23,
  t0.accommodation_cost AS accommodation_cost_24,
  t0.meal_cost AS meal_cost_25,
  t0.transport_cost AS transport_cost_26,
  t0.material_cost AS material_cost_27,
  t0.taking AS taking_28
FROM
  session t0
WHERE
  t0.training_id = ?
  AND t0.type IN ('abstractsession', '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.training_id AS training_id_18, t0.sessionType_id AS sessionType_id_19, t0.type, t0.name AS name_20, t0.price AS price_21, t0.teaching_cost AS teaching_cost_22, t0.vacation_cost AS vacation_cost_23, t0.accommodation_cost AS accommodation_cost_24, t0.meal_cost AS meal_cost_25, t0.transport_cost AS transport_cost_26, t0.material_cost AS material_cost_27, t0.taking AS taking_28 FROM session t0 WHERE t0.training_id = 2811 AND t0.type IN ('abstractsession', 'session');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6556 AND t0.type IN ('participation');

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 = 3 AND t0.type IN ('abstracttrainer', 'trainer');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6561 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6562 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6563 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6564 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6568 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6569 AND t0.type IN ('participation');

SELECT
  t0.id AS id_1,
  t0.is_organization AS is_organization_2,
  t0.trainer_id AS trainer_id_3,
  t0.session_id AS session_id_4,
  t0.organization_id AS organization_id_5,
  t0.type
FROM
  participation t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('participation')

SELECT t0.id AS id_1, t0.is_organization AS is_organization_2, t0.trainer_id AS trainer_id_3, t0.session_id AS session_id_4, t0.organization_id AS organization_id_5, t0.type FROM participation t0 WHERE t0.session_id = 6575 AND t0.type IN ('participation');

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

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

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.motivation AS motivation_4,
  t0.message AS message_5,
  t0.refuse AS refuse_6,
  t0.dif AS dif_7,
  t0.trainee_id AS trainee_id_8,
  t0.session_id AS session_id_9,
  t0.inscription_status_id AS inscription_status_id_10,
  t0.presence_status_id AS presence_status_id_11,
  t0.actiontype_id AS actiontype_id_12,
  t0.type
FROM
  inscription t0
WHERE
  t0.session_id = ?
  AND t0.type IN ('inscription')
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.motivation AS motivation_4, t0.message AS message_5, t0.refuse AS refuse_6, t0.dif AS dif_7, t0.trainee_id AS trainee_id_8, t0.session_id AS session_id_9, t0.inscription_status_id AS inscription_status_id_10, t0.presence_status_id AS presence_status_id_11, t0.actiontype_id AS actiontype_id_12, t0.type FROM inscription t0 WHERE t0.session_id = 6556 AND t0.type IN ('inscription') ORDER BY t0.created_at DESC;

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 = 30609 AND t0.type IN ('abstracttrainee', 'trainee');