Symfony Profiler

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

SELECT * FROM training WHERE type = 'professional' AND (slug = 'formation-developper-sur-la-blockchain-smart-contracts-dapps-et-web3' OR EXISTS (
                SELECT 1 FROM json_each(slug_history) WHERE value = 'formation-developper-sur-la-blockchain-smart-contracts-dapps-et-web3'
            ));

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.slug AS slug_17,
  t0.sub_title AS sub_title_18,
  t0.show_on_home_page AS show_on_home_page_19,
  t0.format AS format_20,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_21,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_22,
  t0.individual_videoconference_hours AS individual_videoconference_hours_23,
  t0.collective_videoconference_hours AS collective_videoconference_hours_24,
  t0.elearning_hours AS elearning_hours_25,
  t0.face_to_face_hours_text AS face_to_face_hours_text_26,
  t0.min_period AS min_period_27,
  t0.max_period AS max_period_28,
  t0.public AS public_29,
  t0.prerequisites AS prerequisites_30,
  t0.cpf AS cpf_31,
  t0.cpf_link AS cpf_link_32,
  t0.pdf_name AS pdf_name_33,
  t0.pdf_mime_type AS pdf_mime_type_34,
  t0.created_by_id AS created_by_id_35,
  t0.category_id AS category_id_36,
  t0.certification_id AS certification_id_37,
  t0.type
FROM
  training t0
WHERE
  t0.id = ?
  AND t0.type IN ('professional')

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.slug AS slug_17, t0.sub_title AS sub_title_18, t0.show_on_home_page AS show_on_home_page_19, t0.format AS format_20, t0.collective_face_to_face_hours AS collective_face_to_face_hours_21, t0.individual_face_to_face_hours AS individual_face_to_face_hours_22, t0.individual_videoconference_hours AS individual_videoconference_hours_23, t0.collective_videoconference_hours AS collective_videoconference_hours_24, t0.elearning_hours AS elearning_hours_25, t0.face_to_face_hours_text AS face_to_face_hours_text_26, t0.min_period AS min_period_27, t0.max_period AS max_period_28, t0.public AS public_29, t0.prerequisites AS prerequisites_30, t0.cpf AS cpf_31, t0.cpf_link AS cpf_link_32, t0.pdf_name AS pdf_name_33, t0.pdf_mime_type AS pdf_mime_type_34, t0.created_by_id AS created_by_id_35, t0.category_id AS category_id_36, t0.certification_id AS certification_id_37, t0.type FROM training t0 WHERE t0.id = 189 AND t0.type IN ('professional');

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
  )
  AND (
    c.type IS NULL -- For specific questions not linked to a category
    OR c.type = ?
    OR c.type = ?
  )
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 = 189 OR f.training_id IS NULL)
                AND (
                    c.type IS NULL -- For specific questions not linked to a category
                    OR c.type = 'BOTH' 
                    OR c.type = 'PROFESSIONAL'
                )
                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 = 189;

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

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.code AS code_3,
  t0.slug_history AS slug_history_4,
  t0.description AS description_5,
  t0.price AS price_6,
  t0.status AS status_7,
  t0.satisfaction_rate AS satisfaction_rate_8,
  t0.completion_rate AS completion_rate_9,
  t0.featured_on_search AS featured_on_search_10,
  t0.pixels AS pixels_11,
  t0.updated_at AS updated_at_12,
  t0.seo_title AS seo_title_13,
  t0.seo_description AS seo_description_14,
  t0.seo_canonical AS seo_canonical_15,
  t0.seo_indexed AS seo_indexed_16,
  t0.created_by_id AS created_by_id_17,
  t0.category_id AS category_id_18,
  t0.type,
  t0.slug AS slug_19,
  t0.sub_title AS sub_title_20,
  t0.show_on_home_page AS show_on_home_page_21,
  t0.format AS format_22,
  t0.collective_face_to_face_hours AS collective_face_to_face_hours_23,
  t0.individual_face_to_face_hours AS individual_face_to_face_hours_24,
  t0.individual_videoconference_hours AS individual_videoconference_hours_25,
  t0.collective_videoconference_hours AS collective_videoconference_hours_26,
  t0.elearning_hours AS elearning_hours_27,
  t0.face_to_face_hours_text AS face_to_face_hours_text_28,
  t0.min_period AS min_period_29,
  t0.max_period AS max_period_30,
  t0.public AS public_31,
  t0.prerequisites AS prerequisites_32,
  t0.cpf AS cpf_33,
  t0.cpf_link AS cpf_link_34,
  t0.pdf_name AS pdf_name_35,
  t0.pdf_mime_type AS pdf_mime_type_36,
  t0.certification_id AS certification_id_37,
  t0.slug AS slug_38,
  t0.level AS level_39,
  t0.language AS language_40,
  t0.hours AS hours_41,
  t0.additional_students AS additional_students_42,
  t0.listing_image_name AS listing_image_name_43,
  t0.show_image_name AS show_image_name_44
FROM
  training t0
  INNER JOIN training_related ON t0.id = training_related.training_target
WHERE
  training_related.training_source = ?
  AND t0.type IN ('professional', 'elearning')

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.slug_history AS slug_history_4, t0.description AS description_5, t0.price AS price_6, t0.status AS status_7, t0.satisfaction_rate AS satisfaction_rate_8, t0.completion_rate AS completion_rate_9, t0.featured_on_search AS featured_on_search_10, t0.pixels AS pixels_11, t0.updated_at AS updated_at_12, t0.seo_title AS seo_title_13, t0.seo_description AS seo_description_14, t0.seo_canonical AS seo_canonical_15, t0.seo_indexed AS seo_indexed_16, t0.created_by_id AS created_by_id_17, t0.category_id AS category_id_18, t0.type, t0.slug AS slug_19, t0.sub_title AS sub_title_20, t0.show_on_home_page AS show_on_home_page_21, t0.format AS format_22, t0.collective_face_to_face_hours AS collective_face_to_face_hours_23, t0.individual_face_to_face_hours AS individual_face_to_face_hours_24, t0.individual_videoconference_hours AS individual_videoconference_hours_25, t0.collective_videoconference_hours AS collective_videoconference_hours_26, t0.elearning_hours AS elearning_hours_27, t0.face_to_face_hours_text AS face_to_face_hours_text_28, t0.min_period AS min_period_29, t0.max_period AS max_period_30, t0.public AS public_31, t0.prerequisites AS prerequisites_32, t0.cpf AS cpf_33, t0.cpf_link AS cpf_link_34, t0.pdf_name AS pdf_name_35, t0.pdf_mime_type AS pdf_mime_type_36, t0.certification_id AS certification_id_37, t0.slug AS slug_38, t0.level AS level_39, t0.language AS language_40, t0.hours AS hours_41, t0.additional_students AS additional_students_42, t0.listing_image_name AS listing_image_name_43, t0.show_image_name AS show_image_name_44 FROM training t0 INNER JOIN training_related ON t0.id = training_related.training_target WHERE training_related.training_source = 189 AND t0.type IN ('professional', 'elearning');

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

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

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_professional_financing ON t0.id = training_professional_financing.financing_id
WHERE
  training_professional_financing.training_professional_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_professional_financing ON t0.id = training_professional_financing.financing_id WHERE training_professional_financing.training_professional_id = 189;