Symfony Profiler

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.level AS level_18,
  t0.language AS language_19,
  t0.hours AS hours_20,
  t0.additional_students AS additional_students_21,
  t0.listing_image_name AS listing_image_name_22,
  t0.show_image_name AS show_image_name_23,
  t0.created_by_id AS created_by_id_24,
  t0.category_id AS category_id_25,
  t0.type
FROM
  training t0
WHERE
  t0.slug = ?
  AND t0.type IN ('elearning')
LIMIT
  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.slug AS slug_17, t0.level AS level_18, t0.language AS language_19, t0.hours AS hours_20, t0.additional_students AS additional_students_21, t0.listing_image_name AS listing_image_name_22, t0.show_image_name AS show_image_name_23, t0.created_by_id AS created_by_id_24, t0.category_id AS category_id_25, t0.type FROM training t0 WHERE t0.slug = 'efefefe' AND t0.type IN ('elearning') LIMIT 1;

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 = 386 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 = 'E_LEARNING'
                )
                ORDER BY c.id, f.question;

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.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.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.certifications AS certifications_6,
  t0.status AS status_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t0.available AS available_10,
  t0.nda_status AS nda_status_11,
  t0.joined_at AS joined_at_12,
  t0.is_senza_trainer AS is_senza_trainer_13,
  t0.data_gouv_link AS data_gouv_link_14,
  t0.level AS level_15,
  t0.languages AS languages_16,
  t0.total_trainings AS total_trainings_17,
  t0.quality_chart_signed AS quality_chart_signed_18,
  t0.senza_training_validated AS senza_training_validated_19,
  t0.expert AS expert_20,
  t0.siret AS siret_21,
  t0.nda_number AS nda_number_22,
  t0.email_hash AS email_hash_23,
  t0.user_id AS user_id_24
FROM
  trainer t0
  INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id
WHERE
  training_trainer.training_id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.slug AS slug_4, t0.description AS description_5, t0.certifications AS certifications_6, t0.status AS status_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t0.available AS available_10, t0.nda_status AS nda_status_11, t0.joined_at AS joined_at_12, t0.is_senza_trainer AS is_senza_trainer_13, t0.data_gouv_link AS data_gouv_link_14, t0.level AS level_15, t0.languages AS languages_16, t0.total_trainings AS total_trainings_17, t0.quality_chart_signed AS quality_chart_signed_18, t0.senza_training_validated AS senza_training_validated_19, t0.expert AS expert_20, t0.siret AS siret_21, t0.nda_number AS nda_number_22, t0.email_hash AS email_hash_23, t0.user_id AS user_id_24 FROM trainer t0 INNER JOIN training_trainer ON t0.id = training_trainer.trainer_id WHERE training_trainer.training_id = 386;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.training_elearning_id AS training_elearning_id_4
FROM
  elearning_module t0
WHERE
  t0.training_elearning_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.training_elearning_id AS training_elearning_id_4 FROM elearning_module t0 WHERE t0.training_elearning_id = 386 ORDER BY t0.position ASC;

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

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.duration AS duration_3,
  t0.position AS position_4,
  t0.module_id AS module_id_5,
  t0.item_id AS item_id_6
FROM
  elearning_chapter t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.duration AS duration_3, t0.position AS position_4, t0.module_id AS module_id_5, t0.item_id AS item_id_6 FROM elearning_chapter t0 WHERE t0.module_id = 5 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 4 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.duration AS duration_3,
  t0.position AS position_4,
  t0.module_id AS module_id_5,
  t0.item_id AS item_id_6
FROM
  elearning_chapter t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.duration AS duration_3, t0.position AS position_4, t0.module_id AS module_id_5, t0.item_id AS item_id_6 FROM elearning_chapter t0 WHERE t0.module_id = 6 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 8 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 7 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 6 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t5.id AS id_4,
  t5.title AS title_6,
  t5.duration AS duration_7,
  t5.position AS position_8,
  t5.module_id AS module_id_9,
  t5.item_id AS item_id_10,
  t0.type,
  t0.content AS content_11,
  t0.quiz_id AS quiz_id_12,
  t0.audio_name AS audio_name_13,
  t0.video_url AS video_url_14,
  t0.instructions AS instructions_15
FROM
  chapter_item t0
  LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id
WHERE
  t0.id = ?
  AND t0.type IN (
    'text', 'quiz', 'audio', 'video', 'deliverable'
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t5.id AS id_4, t5.title AS title_6, t5.duration AS duration_7, t5.position AS position_8, t5.module_id AS module_id_9, t5.item_id AS item_id_10, t0.type, t0.content AS content_11, t0.quiz_id AS quiz_id_12, t0.audio_name AS audio_name_13, t0.video_url AS video_url_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 5 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.duration AS duration_3,
  t0.position AS position_4,
  t0.module_id AS module_id_5,
  t0.item_id AS item_id_6
FROM
  elearning_chapter t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.duration AS duration_3, t0.position AS position_4, t0.module_id AS module_id_5, t0.item_id AS item_id_6 FROM elearning_chapter t0 WHERE t0.module_id = 7 ORDER BY t0.position ASC;