Symfony Profiler

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.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 = '4562';

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

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

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

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

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

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

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_
WHERE
  d0_.id IN (?)
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_ WHERE d0_.id IN ('16') 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_
WHERE
  d0_.id IN (?)
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_ WHERE d0_.id IN ('16') ORDER BY d0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2
FROM
  sub_domain s0_
WHERE
  s0_.id IN (?)
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_ WHERE s0_.id IN ('17') 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_
WHERE
  s0_.id IN (?)
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_ WHERE s0_.id IN ('17') ORDER BY s0_.name ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.slug AS slug_2
FROM
  device_and_training d0_
WHERE
  d0_.id IN (?)
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_ WHERE d0_.id IN ('9') 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_
WHERE
  d0_.id IN (?)
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_ WHERE d0_.id IN ('4') 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_
WHERE
  d0_.id IN (?, ?)
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_ WHERE d0_.id IN ('9', '4') 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%'
  )
  AND u0_.id IN (?)
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%') AND u0_.id IN ('7') 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%'
  )
  AND u0_.id IN (?)
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%') AND u0_.id IN ('7') 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%'
  )
  AND u0_.id IN (?)
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%') AND u0_.id IN ('7') 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%'
  )
  AND u0_.id IN (?)
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%') AND u0_.id IN ('7') ORDER BY u0_.first_name ASC;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  trainings
SET
  price = ?,
  date = ?,
  edit_date = ?,
  trainee_or_enterprise = ?,
  validity_date = ?
WHERE
  id = ?

UPDATE trainings SET price = '1 500 € HT pour le groupe en Intra.', date = '23 et 24 décembre 2024 de 8h00 à 16h00', edit_date = '2024-11-25', trainee_or_enterprise = '1 groupe de salariés du CENTRE DE LOISIRS LA TREFFORTINE', validity_date = '2024-12-25' WHERE id = 4562;

"COMMIT"

"COMMIT";