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 = 'mon-titre-de-formation-tres-long-pour-voir-si-ca-passe-sur-3-lignes-ou-plus-je-ne-sais-pas-a-voir' 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 = 387 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.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 = 387 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 = 387;

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 = 9 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 23 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 21 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 20 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 16 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 15 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 22 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 14 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 13 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.embed_code AS embed_code_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.embed_code AS embed_code_14, t0.instructions AS instructions_15 FROM chapter_item t0 LEFT JOIN elearning_chapter t5 ON t5.item_id = t0.id WHERE t0.id = 9 AND t0.type IN ('text', 'quiz', 'audio', 'video', 'deliverable');