Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.sub_title AS sub_title_2,
  t0_.code AS code_3,
  t0_.cut_in_blocks AS cut_in_blocks_4,
  t0_.new AS new_5,
  t0_.customizable AS customizable_6,
  t0_.objectives AS objectives_7,
  t0_.complementary_objectives AS complementary_objectives_8,
  t0_.pedagogic_content AS pedagogic_content_9,
  t0_.pluses AS pluses_10,
  t0_.concerned_persons AS concerned_persons_11,
  t0_.prerequisites AS prerequisites_12,
  t0_.price AS price_13,
  t0_.time AS time_14,
  t0_.date AS date_15,
  t0_.place AS place_16,
  t0_.terms_of_access AS terms_of_access_17,
  t0_.alternating_rythm AS alternating_rythm_18,
  t0_.teaching_methods AS teaching_methods_19,
  t0_.teaching_means AS teaching_means_20,
  t0_.education_level AS education_level_21,
  t0_.training_order AS training_order_22,
  t0_.certification_name AS certification_name_23,
  t0_.assessment_methods AS assessment_methods_24,
  t0_.target_functions AS target_functions_25,
  t0_.continuing_studies AS continuing_studies_26,
  t0_.disabled_accessibility AS disabled_accessibility_27,
  t0_.testimonials AS testimonials_28,
  t0_.accessibility_text AS accessibility_text_29,
  t0_.creation_date AS creation_date_30,
  t0_.edit_date AS edit_date_31,
  t0_.logo_display AS logo_display_32,
  t0_.which_public AS which_public_33,
  t0_.published AS published_34,
  t0_.is_fiche AS is_fiche_35,
  t0_.slug AS slug_36,
  t0_.fiche_title AS fiche_title_37,
  t0_.trainee_or_enterprise AS trainee_or_enterprise_38,
  t0_.validity_date AS validity_date_39,
  t0_.link_video AS link_video_40,
  t0_.rncp_or_rs AS rncp_or_rs_41,
  t0_.days AS days_42,
  t0_.hours AS hours_43,
  t0_.company_missions AS company_missions_44,
  t0_.validity_date_rncp AS validity_date_rncp_45,
  t0_.reset_date AS reset_date_46,
  t0_.type_id AS type_id_47,
  t0_.certification_type_id AS certification_type_id_48,
  t0_.owner_id AS owner_id_49,
  t0_.training_place_id AS training_place_id_50,
  t0_.education_level_name_id AS education_level_name_id_51,
  t0_.public_type_id AS public_type_id_52
FROM
  trainings t0_
WHERE
  t0_.is_fiche = ?
ORDER BY
  t0_.title ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.sub_title AS sub_title_2, t0_.code AS code_3, t0_.cut_in_blocks AS cut_in_blocks_4, t0_.new AS new_5, t0_.customizable AS customizable_6, t0_.objectives AS objectives_7, t0_.complementary_objectives AS complementary_objectives_8, t0_.pedagogic_content AS pedagogic_content_9, t0_.pluses AS pluses_10, t0_.concerned_persons AS concerned_persons_11, t0_.prerequisites AS prerequisites_12, t0_.price AS price_13, t0_.time AS time_14, t0_.date AS date_15, t0_.place AS place_16, t0_.terms_of_access AS terms_of_access_17, t0_.alternating_rythm AS alternating_rythm_18, t0_.teaching_methods AS teaching_methods_19, t0_.teaching_means AS teaching_means_20, t0_.education_level AS education_level_21, t0_.training_order AS training_order_22, t0_.certification_name AS certification_name_23, t0_.assessment_methods AS assessment_methods_24, t0_.target_functions AS target_functions_25, t0_.continuing_studies AS continuing_studies_26, t0_.disabled_accessibility AS disabled_accessibility_27, t0_.testimonials AS testimonials_28, t0_.accessibility_text AS accessibility_text_29, t0_.creation_date AS creation_date_30, t0_.edit_date AS edit_date_31, t0_.logo_display AS logo_display_32, t0_.which_public AS which_public_33, t0_.published AS published_34, t0_.is_fiche AS is_fiche_35, t0_.slug AS slug_36, t0_.fiche_title AS fiche_title_37, t0_.trainee_or_enterprise AS trainee_or_enterprise_38, t0_.validity_date AS validity_date_39, t0_.link_video AS link_video_40, t0_.rncp_or_rs AS rncp_or_rs_41, t0_.days AS days_42, t0_.hours AS hours_43, t0_.company_missions AS company_missions_44, t0_.validity_date_rncp AS validity_date_rncp_45, t0_.reset_date AS reset_date_46, t0_.type_id AS type_id_47, t0_.certification_type_id AS certification_type_id_48, t0_.owner_id AS owner_id_49, t0_.training_place_id AS training_place_id_50, t0_.education_level_name_id AS education_level_name_id_51, t0_.public_type_id AS public_type_id_52 FROM trainings t0_ WHERE t0_.is_fiche = 0 ORDER BY t0_.title ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.reset_password AS reset_password_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.reset_password AS reset_password_8 FROM user t0 WHERE t0.id = 36;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.media AS media_4,
  t0.description AS description_5,
  t0.media_url AS media_url_6
FROM
  domain t0
  INNER JOIN trainings_domain ON t0.id = trainings_domain.domain_id
WHERE
  trainings_domain.trainings_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.media AS media_4, t0.description AS description_5, t0.media_url AS media_url_6 FROM domain t0 INNER JOIN trainings_domain ON t0.id = trainings_domain.domain_id WHERE trainings_domain.trainings_id = 4764;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sub_title AS sub_title_3,
  t0.code AS code_4,
  t0.cut_in_blocks AS cut_in_blocks_5,
  t0.new AS new_6,
  t0.customizable AS customizable_7,
  t0.objectives AS objectives_8,
  t0.complementary_objectives AS complementary_objectives_9,
  t0.pedagogic_content AS pedagogic_content_10,
  t0.pluses AS pluses_11,
  t0.concerned_persons AS concerned_persons_12,
  t0.prerequisites AS prerequisites_13,
  t0.price AS price_14,
  t0.time AS time_15,
  t0.date AS date_16,
  t0.place AS place_17,
  t0.terms_of_access AS terms_of_access_18,
  t0.alternating_rythm AS alternating_rythm_19,
  t0.teaching_methods AS teaching_methods_20,
  t0.teaching_means AS teaching_means_21,
  t0.education_level AS education_level_22,
  t0.training_order AS training_order_23,
  t0.certification_name AS certification_name_24,
  t0.assessment_methods AS assessment_methods_25,
  t0.target_functions AS target_functions_26,
  t0.continuing_studies AS continuing_studies_27,
  t0.disabled_accessibility AS disabled_accessibility_28,
  t0.testimonials AS testimonials_29,
  t0.accessibility_text AS accessibility_text_30,
  t0.creation_date AS creation_date_31,
  t0.edit_date AS edit_date_32,
  t0.logo_display AS logo_display_33,
  t0.which_public AS which_public_34,
  t0.published AS published_35,
  t0.is_fiche AS is_fiche_36,
  t0.slug AS slug_37,
  t0.fiche_title AS fiche_title_38,
  t0.trainee_or_enterprise AS trainee_or_enterprise_39,
  t0.validity_date AS validity_date_40,
  t0.link_video AS link_video_41,
  t0.rncp_or_rs AS rncp_or_rs_42,
  t0.days AS days_43,
  t0.hours AS hours_44,
  t0.company_missions AS company_missions_45,
  t0.validity_date_rncp AS validity_date_rncp_46,
  t0.reset_date AS reset_date_47,
  t0.type_id AS type_id_48,
  t0.certification_type_id AS certification_type_id_49,
  t0.owner_id AS owner_id_50,
  t0.training_place_id AS training_place_id_51,
  t0.education_level_name_id AS education_level_name_id_52,
  t0.public_type_id AS public_type_id_53
FROM
  trainings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.code AS code_4, t0.cut_in_blocks AS cut_in_blocks_5, t0.new AS new_6, t0.customizable AS customizable_7, t0.objectives AS objectives_8, t0.complementary_objectives AS complementary_objectives_9, t0.pedagogic_content AS pedagogic_content_10, t0.pluses AS pluses_11, t0.concerned_persons AS concerned_persons_12, t0.prerequisites AS prerequisites_13, t0.price AS price_14, t0.time AS time_15, t0.date AS date_16, t0.place AS place_17, t0.terms_of_access AS terms_of_access_18, t0.alternating_rythm AS alternating_rythm_19, t0.teaching_methods AS teaching_methods_20, t0.teaching_means AS teaching_means_21, t0.education_level AS education_level_22, t0.training_order AS training_order_23, t0.certification_name AS certification_name_24, t0.assessment_methods AS assessment_methods_25, t0.target_functions AS target_functions_26, t0.continuing_studies AS continuing_studies_27, t0.disabled_accessibility AS disabled_accessibility_28, t0.testimonials AS testimonials_29, t0.accessibility_text AS accessibility_text_30, t0.creation_date AS creation_date_31, t0.edit_date AS edit_date_32, t0.logo_display AS logo_display_33, t0.which_public AS which_public_34, t0.published AS published_35, t0.is_fiche AS is_fiche_36, t0.slug AS slug_37, t0.fiche_title AS fiche_title_38, t0.trainee_or_enterprise AS trainee_or_enterprise_39, t0.validity_date AS validity_date_40, t0.link_video AS link_video_41, t0.rncp_or_rs AS rncp_or_rs_42, t0.days AS days_43, t0.hours AS hours_44, t0.company_missions AS company_missions_45, t0.validity_date_rncp AS validity_date_rncp_46, t0.reset_date AS reset_date_47, t0.type_id AS type_id_48, t0.certification_type_id AS certification_type_id_49, t0.owner_id AS owner_id_50, t0.training_place_id AS training_place_id_51, t0.education_level_name_id AS education_level_name_id_52, t0.public_type_id AS public_type_id_53 FROM trainings t0 WHERE t0.id = '4764';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sub_title AS sub_title_3,
  t0.code AS code_4,
  t0.cut_in_blocks AS cut_in_blocks_5,
  t0.new AS new_6,
  t0.customizable AS customizable_7,
  t0.objectives AS objectives_8,
  t0.complementary_objectives AS complementary_objectives_9,
  t0.pedagogic_content AS pedagogic_content_10,
  t0.pluses AS pluses_11,
  t0.concerned_persons AS concerned_persons_12,
  t0.prerequisites AS prerequisites_13,
  t0.price AS price_14,
  t0.time AS time_15,
  t0.date AS date_16,
  t0.place AS place_17,
  t0.terms_of_access AS terms_of_access_18,
  t0.alternating_rythm AS alternating_rythm_19,
  t0.teaching_methods AS teaching_methods_20,
  t0.teaching_means AS teaching_means_21,
  t0.education_level AS education_level_22,
  t0.training_order AS training_order_23,
  t0.certification_name AS certification_name_24,
  t0.assessment_methods AS assessment_methods_25,
  t0.target_functions AS target_functions_26,
  t0.continuing_studies AS continuing_studies_27,
  t0.disabled_accessibility AS disabled_accessibility_28,
  t0.testimonials AS testimonials_29,
  t0.accessibility_text AS accessibility_text_30,
  t0.creation_date AS creation_date_31,
  t0.edit_date AS edit_date_32,
  t0.logo_display AS logo_display_33,
  t0.which_public AS which_public_34,
  t0.published AS published_35,
  t0.is_fiche AS is_fiche_36,
  t0.slug AS slug_37,
  t0.fiche_title AS fiche_title_38,
  t0.trainee_or_enterprise AS trainee_or_enterprise_39,
  t0.validity_date AS validity_date_40,
  t0.link_video AS link_video_41,
  t0.rncp_or_rs AS rncp_or_rs_42,
  t0.days AS days_43,
  t0.hours AS hours_44,
  t0.company_missions AS company_missions_45,
  t0.validity_date_rncp AS validity_date_rncp_46,
  t0.reset_date AS reset_date_47,
  t0.type_id AS type_id_48,
  t0.certification_type_id AS certification_type_id_49,
  t0.owner_id AS owner_id_50,
  t0.training_place_id AS training_place_id_51,
  t0.education_level_name_id AS education_level_name_id_52,
  t0.public_type_id AS public_type_id_53
FROM
  trainings t0
  INNER JOIN trainings_trainings ON t0.id = trainings_trainings.trainings_target
WHERE
  trainings_trainings.trainings_source = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.code AS code_4, t0.cut_in_blocks AS cut_in_blocks_5, t0.new AS new_6, t0.customizable AS customizable_7, t0.objectives AS objectives_8, t0.complementary_objectives AS complementary_objectives_9, t0.pedagogic_content AS pedagogic_content_10, t0.pluses AS pluses_11, t0.concerned_persons AS concerned_persons_12, t0.prerequisites AS prerequisites_13, t0.price AS price_14, t0.time AS time_15, t0.date AS date_16, t0.place AS place_17, t0.terms_of_access AS terms_of_access_18, t0.alternating_rythm AS alternating_rythm_19, t0.teaching_methods AS teaching_methods_20, t0.teaching_means AS teaching_means_21, t0.education_level AS education_level_22, t0.training_order AS training_order_23, t0.certification_name AS certification_name_24, t0.assessment_methods AS assessment_methods_25, t0.target_functions AS target_functions_26, t0.continuing_studies AS continuing_studies_27, t0.disabled_accessibility AS disabled_accessibility_28, t0.testimonials AS testimonials_29, t0.accessibility_text AS accessibility_text_30, t0.creation_date AS creation_date_31, t0.edit_date AS edit_date_32, t0.logo_display AS logo_display_33, t0.which_public AS which_public_34, t0.published AS published_35, t0.is_fiche AS is_fiche_36, t0.slug AS slug_37, t0.fiche_title AS fiche_title_38, t0.trainee_or_enterprise AS trainee_or_enterprise_39, t0.validity_date AS validity_date_40, t0.link_video AS link_video_41, t0.rncp_or_rs AS rncp_or_rs_42, t0.days AS days_43, t0.hours AS hours_44, t0.company_missions AS company_missions_45, t0.validity_date_rncp AS validity_date_rncp_46, t0.reset_date AS reset_date_47, t0.type_id AS type_id_48, t0.certification_type_id AS certification_type_id_49, t0.owner_id AS owner_id_50, t0.training_place_id AS training_place_id_51, t0.education_level_name_id AS education_level_name_id_52, t0.public_type_id AS public_type_id_53 FROM trainings t0 INNER JOIN trainings_trainings ON t0.id = trainings_trainings.trainings_target WHERE trainings_trainings.trainings_source = 4764;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2,
  d0_.media AS media_3,
  d0_.description AS description_4,
  d0_.media_url AS media_url_5
FROM
  domain d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.media AS media_3, d0_.description AS description_4, d0_.media_url AS media_url_5 FROM domain d0_ ORDER BY d0_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.phone AS phone_6,
  u0_.reset_password AS reset_password_7
FROM
  user u0_
WHERE
  u0_.roles LIKE '%ROLE_INTERVENANT%'
  OR u0_.roles LIKE '%ROLE_COMMERCIAL%'
  OR u0_.roles LIKE '%ROLE_ADMIN%'
ORDER BY
  u0_.first_name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.phone AS phone_6, u0_.reset_password AS reset_password_7 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_INTERVENANT%' OR u0_.roles LIKE '%ROLE_COMMERCIAL%' OR u0_.roles LIKE '%ROLE_ADMIN%' ORDER BY u0_.first_name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2
FROM
  sub_domain s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM sub_domain s0_ ORDER BY s0_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.phone AS phone_6,
  u0_.reset_password AS reset_password_7
FROM
  user u0_
WHERE
  u0_.roles LIKE '%ROLE_COMMERCIAL%'
  OR u0_.roles LIKE '%ROLE_ADMIN%'
ORDER BY
  u0_.first_name ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.phone AS phone_6, u0_.reset_password AS reset_password_7 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_COMMERCIAL%' OR u0_.roles LIKE '%ROLE_ADMIN%' ORDER BY u0_.first_name ASC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.reset_password AS reset_password_8
FROM
  user t0
  INNER JOIN commercials_trainings ON t0.id = commercials_trainings.user_id
WHERE
  commercials_trainings.trainings_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.reset_password AS reset_password_8 FROM user t0 INNER JOIN commercials_trainings ON t0.id = commercials_trainings.user_id WHERE commercials_trainings.trainings_id = 4764;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  sub_domain t0
  INNER JOIN trainings_sub_domain ON t0.id = trainings_sub_domain.sub_domain_id
WHERE
  trainings_sub_domain.trainings_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM sub_domain t0 INNER JOIN trainings_sub_domain ON t0.id = trainings_sub_domain.sub_domain_id WHERE trainings_sub_domain.trainings_id = 4764;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  device_and_training t0
  INNER JOIN trainings_device_and_training ON t0.id = trainings_device_and_training.device_and_training_id
WHERE
  trainings_device_and_training.trainings_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM device_and_training t0 INNER JOIN trainings_device_and_training ON t0.id = trainings_device_and_training.device_and_training_id WHERE trainings_device_and_training.trainings_id = 4764;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.reset_password AS reset_password_8
FROM
  user t0
  INNER JOIN trainings_user ON t0.id = trainings_user.user_id
WHERE
  trainings_user.trainings_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.reset_password AS reset_password_8 FROM user t0 INNER JOIN trainings_user ON t0.id = trainings_user.user_id WHERE trainings_user.trainings_id = 4764;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2
FROM
  certification_type c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM certification_type c0_ ORDER BY c0_.name ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2
FROM
  training_place t0_
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM training_place t0_ ORDER BY t0_.name ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  device_and_training d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2 FROM device_and_training d0_ ORDER BY d0_.name ASC;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.slug AS slug_2
FROM
  education_level e0_
ORDER BY
  e0_.name ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2 FROM education_level e0_ ORDER BY e0_.name ASC;