Symfony Profiler

SELECT
  *
FROM
  training
WHERE
  slug = :slug
  OR EXISTS (
    SELECT
      1
    FROM
      json_each(slug_history)
    WHERE
      value = :slug
  )

SELECT * FROM training WHERE slug = 'vba' OR EXISTS (
                SELECT 1 FROM json_each(slug_history) WHERE value = 'vba'
            );

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.pdf_name AS pdf_name_4,
  t0.pdf_mime_type AS pdf_mime_type_5,
  t0.updated_at AS updated_at_6,
  t0.show_on_home_page AS show_on_home_page_7,
  t0.featured_on_search AS featured_on_search_8,
  t0.price AS price_9,
  t0.cpf AS cpf_10,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_11,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_12,
  t0.individual_videoconference_hours AS individual_videoconference_hours_13,
  t0.collective_videoconference_hours AS collective_videoconference_hours_14,
  t0.elearning_hours AS elearning_hours_15,
  t0.format AS format_16,
  t0.description AS description_17,
  t0.min_period AS min_period_18,
  t0.max_period AS max_period_19,
  t0.public AS public_20,
  t0.prerequisites AS prerequisites_21,
  t0.code AS code_22,
  t0.face_to_face_hours_text AS face_to_face_hours_text_23,
  t0.satisfaction_rate AS satisfaction_rate_24,
  t0.cpf_link AS cpf_link_25,
  t0.completion_rate AS completion_rate_26,
  t0.slug_history AS slug_history_27,
  t0.sub_title AS sub_title_28,
  t0.pixels AS pixels_29,
  t0.status AS status_30,
  t0.seo_title AS seo_title_31,
  t0.seo_description AS seo_description_32,
  t0.seo_canonical AS seo_canonical_33,
  t0.seo_indexed AS seo_indexed_34,
  t0.certification_id AS certification_id_35,
  t0.category_id AS category_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  training t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 WHERE t0.id = 51;

SELECT
  f.id,
  f.question,
  f.answer,
  f.category_id,
  c.label AS category_label
FROM
  faq f
  LEFT JOIN faqcategory c ON f.category_id = c.id
WHERE
  f.training_id = ?
  OR f.training_id IS NULL
ORDER BY
  c.id,
  f.question

SELECT f.id, f.question, f.answer, f.category_id, c.label AS category_label
                FROM faq f
                LEFT JOIN faqcategory c ON f.category_id = c.id
                WHERE f.training_id = 51 OR f.training_id IS NULL
                ORDER BY c.id, f.question;

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.full AS full_4,
  t0.training_id AS training_id_5
FROM
  session t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.full AS full_4, t0.training_id AS training_id_5 FROM session t0 WHERE t0.training_id = 51;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.success_rate AS success_rate_3,
  t0.url AS url_4,
  t0.number AS number_5,
  t0.certifier_url AS certifier_url_6,
  t0.certifier AS certifier_7,
  t0.objectives AS objectives_8,
  t0.evaluation AS evaluation_9,
  t0.registration_limit_date AS registration_limit_date_10,
  t0.type AS type_11
FROM
  certification t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.success_rate AS success_rate_3, t0.url AS url_4, t0.number AS number_5, t0.certifier_url AS certifier_url_6, t0.certifier AS certifier_7, t0.objectives AS objectives_8, t0.evaluation AS evaluation_9, t0.registration_limit_date AS registration_limit_date_10, t0.type AS type_11 FROM certification t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image_name AS image_name_3,
  t0.updated_at AS updated_at_4,
  t0.total_trainings AS total_trainings_5
FROM
  training_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_name AS image_name_3, t0.updated_at AS updated_at_4, t0.total_trainings AS total_trainings_5 FROM training_category t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.training_id AS training_id_3
FROM
  training_objective t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.training_id AS training_id_3 FROM training_objective t0 WHERE t0.training_id = 51;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.training_id AS training_id_4
FROM
  training_program_part t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.training_id AS training_id_4 FROM training_program_part t0 WHERE t0.training_id = 51;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.enable AS enable_4,
  t0.updated_at AS updated_at_5,
  t0.seo_title AS seo_title_6,
  t0.seo_description AS seo_description_7,
  t0.seo_canonical AS seo_canonical_8,
  t0.seo_indexed AS seo_indexed_9
FROM
  cms_page t0
WHERE
  t0.enable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.enable AS enable_4, t0.updated_at AS updated_at_5, t0.seo_title AS seo_title_6, t0.seo_description AS seo_description_7, t0.seo_canonical AS seo_canonical_8, t0.seo_indexed AS seo_indexed_9 FROM cms_page t0 WHERE t0.enable = 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.pdf_name AS pdf_name_4,
  t0.pdf_mime_type AS pdf_mime_type_5,
  t0.updated_at AS updated_at_6,
  t0.show_on_home_page AS show_on_home_page_7,
  t0.featured_on_search AS featured_on_search_8,
  t0.price AS price_9,
  t0.cpf AS cpf_10,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_11,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_12,
  t0.individual_videoconference_hours AS individual_videoconference_hours_13,
  t0.collective_videoconference_hours AS collective_videoconference_hours_14,
  t0.elearning_hours AS elearning_hours_15,
  t0.format AS format_16,
  t0.description AS description_17,
  t0.min_period AS min_period_18,
  t0.max_period AS max_period_19,
  t0.public AS public_20,
  t0.prerequisites AS prerequisites_21,
  t0.code AS code_22,
  t0.face_to_face_hours_text AS face_to_face_hours_text_23,
  t0.satisfaction_rate AS satisfaction_rate_24,
  t0.cpf_link AS cpf_link_25,
  t0.completion_rate AS completion_rate_26,
  t0.slug_history AS slug_history_27,
  t0.sub_title AS sub_title_28,
  t0.pixels AS pixels_29,
  t0.status AS status_30,
  t0.seo_title AS seo_title_31,
  t0.seo_description AS seo_description_32,
  t0.seo_canonical AS seo_canonical_33,
  t0.seo_indexed AS seo_indexed_34,
  t0.certification_id AS certification_id_35,
  t0.category_id AS category_id_36,
  t0.created_by_id AS created_by_id_37
FROM
  training t0
  INNER JOIN training_related ON t0.id = training_related.training_target
WHERE
  training_related.training_source = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.pdf_name AS pdf_name_4, t0.pdf_mime_type AS pdf_mime_type_5, t0.updated_at AS updated_at_6, t0.show_on_home_page AS show_on_home_page_7, t0.featured_on_search AS featured_on_search_8, t0.price AS price_9, t0.cpf AS cpf_10, t0.collective_face_to_face_hours AS collective_face_to_face_hours_11, t0.individual_face_to_face_hours AS individual_face_to_face_hours_12, t0.individual_videoconference_hours AS individual_videoconference_hours_13, t0.collective_videoconference_hours AS collective_videoconference_hours_14, t0.elearning_hours AS elearning_hours_15, t0.format AS format_16, t0.description AS description_17, t0.min_period AS min_period_18, t0.max_period AS max_period_19, t0.public AS public_20, t0.prerequisites AS prerequisites_21, t0.code AS code_22, t0.face_to_face_hours_text AS face_to_face_hours_text_23, t0.satisfaction_rate AS satisfaction_rate_24, t0.cpf_link AS cpf_link_25, t0.completion_rate AS completion_rate_26, t0.slug_history AS slug_history_27, t0.sub_title AS sub_title_28, t0.pixels AS pixels_29, t0.status AS status_30, t0.seo_title AS seo_title_31, t0.seo_description AS seo_description_32, t0.seo_canonical AS seo_canonical_33, t0.seo_indexed AS seo_indexed_34, t0.certification_id AS certification_id_35, t0.category_id AS category_id_36, t0.created_by_id AS created_by_id_37 FROM training t0 INNER JOIN training_related ON t0.id = training_related.training_target WHERE training_related.training_source = 51;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.short_name AS short_name_3,
  t0.description AS description_4,
  t0.image_name AS image_name_5,
  t0.updated_at AS updated_at_6
FROM
  financing t0
  INNER JOIN training_financing ON t0.id = training_financing.financing_id
WHERE
  training_financing.training_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.short_name AS short_name_3, t0.description AS description_4, t0.image_name AS image_name_5, t0.updated_at AS updated_at_6 FROM financing t0 INNER JOIN training_financing ON t0.id = training_financing.financing_id WHERE training_financing.training_id = 51;