Symfony Profiler

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_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
  theme t0
WHERE
  t0.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 theme t0 WHERE t0.id = 3;

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 = 54745;

SELECT
  t0.id AS id_1,
  t0.dateBegin AS dateBegin_2,
  t0.dateEnd AS dateEnd_3,
  t0.scheduleMorn AS scheduleMorn_4,
  t0.scheduleAfter AS scheduleAfter_5,
  t0.hourNumberMorn AS hourNumberMorn_6,
  t0.hourNumberAfter AS hourNumberAfter_7,
  t0.place AS place_8,
  t0.session_id AS session_id_9
FROM
  date_session t0
WHERE
  t0.session_id = ?
ORDER BY
  t0.dateBegin ASC

SELECT t0.id AS id_1, t0.dateBegin AS dateBegin_2, t0.dateEnd AS dateEnd_3, t0.scheduleMorn AS scheduleMorn_4, t0.scheduleAfter AS scheduleAfter_5, t0.hourNumberMorn AS hourNumberMorn_6, t0.hourNumberAfter AS hourNumberAfter_7, t0.place AS place_8, t0.session_id AS session_id_9 FROM date_session t0 WHERE t0.session_id = 6575 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 = ?
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 = 54745 ORDER BY t0.dateBegin ASC;

SELECT
  t0.count AS count_1,
  t0.session_id AS session_id_2,
  t0.publictype_id AS publictype_id_3
FROM
  participants_summary t0
WHERE
  t0.session_id = ?

SELECT t0.count AS count_1, t0.session_id AS session_id_2, t0.publictype_id AS publictype_id_3 FROM participants_summary t0 WHERE t0.session_id = 6556;

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.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
  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.trainee_id AS trainee_id_3,
  t0.session_id AS session_id_4
FROM
  alert t0
WHERE
  t0.session_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.trainee_id AS trainee_id_3, t0.session_id AS session_id_4 FROM alert t0 WHERE t0.session_id = 6575;

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.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');

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 = 2811;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.trainee_id AS trainee_id_3,
  t0.session_id AS session_id_4
FROM
  alert t0
WHERE
  t0.trainee_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.trainee_id AS trainee_id_3, t0.session_id AS session_id_4 FROM alert t0 WHERE t0.trainee_id = 30609;

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_3,
  t0.name AS name_4,
  t0.training_id AS training_id_5,
  t0.session_id AS session_id_6,
  t0.type,
  t1.url AS url_7,
  t2.file_path AS file_path_8,
  t2.file_name AS file_name_9,
  t2.uploaded AS uploaded_10
FROM
  material t0
  LEFT JOIN link_material t1 ON t0.id = t1.id
  LEFT JOIN file_material t2 ON t0.id = t2.id
WHERE
  t0.training_id = ?

SELECT t0.id AS id_3, t0.name AS name_4, t0.training_id AS training_id_5, t0.session_id AS session_id_6, t0.type, t1.url AS url_7, t2.file_path AS file_path_8, t2.file_name AS file_name_9, t2.uploaded AS uploaded_10 FROM material t0 LEFT JOIN link_material t1 ON t0.id = t1.id LEFT JOIN file_material t2 ON t0.id = t2.id WHERE t0.training_id = 2811;

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
  tag t0
  INNER JOIN training__training_tag ON t0.id = training__training_tag.tag_id
WHERE
  training__training_tag.training_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 tag t0 INNER JOIN training__training_tag ON t0.id = training__training_tag.tag_id WHERE training__training_tag.training_id = 2811;

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_3,
  t0.name AS name_4,
  t0.training_id AS training_id_5,
  t0.session_id AS session_id_6,
  t0.type,
  t1.url AS url_7,
  t2.file_path AS file_path_8,
  t2.file_name AS file_name_9,
  t2.uploaded AS uploaded_10
FROM
  material t0
  LEFT JOIN link_material t1 ON t0.id = t1.id
  LEFT JOIN file_material t2 ON t0.id = t2.id
WHERE
  t0.session_id = ?

SELECT t0.id AS id_3, t0.name AS name_4, t0.training_id AS training_id_5, t0.session_id AS session_id_6, t0.type, t1.url AS url_7, t2.file_path AS file_path_8, t2.file_name AS file_name_9, t2.uploaded AS uploaded_10 FROM material t0 LEFT JOIN link_material t1 ON t0.id = t1.id LEFT JOIN file_material t2 ON t0.id = t2.id WHERE t0.session_id = 6575;

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_publictyperestrict ON t0.id = internship__internship_publictyperestrict.publictyperestrict_id
WHERE
  internship__internship_publictyperestrict.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_publictyperestrict ON t0.id = internship__internship_publictyperestrict.publictyperestrict_id WHERE internship__internship_publictyperestrict.intership_id = 2811;

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
  evaluation_criterion t0
WHERE
  t0.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 evaluation_criterion t0 WHERE t0.id = 12;

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