Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.`content` AS content_1,
  t0_.lastTranslationUpdate AS lastTranslationUpdate_2,
  t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3,
  t0_.lastTranslationPageToken AS lastTranslationPageToken_4,
  t0_.firstTranslationUpdate AS firstTranslationUpdate_5
FROM
  `TranslationFile` t0_
ORDER BY
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-17 06:40:42' AND m0_.ending_date > '2025-12-17 06:40:42' AND m0_.is_completed = 0;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-17 06:40:42' AND m0_.ending_date > '2025-12-17 06:40:42' AND m0_.is_completed = 0;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.isActive = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.isActive = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.tag AS tag_2,
  c0_.currency AS currency_3,
  c0_.currency_symbol AS currency_symbol_4,
  c0_.is_default AS is_default_5,
  c0_.`translations` AS translations_6,
  c0_.school_calendar_id AS school_calendar_id_7
FROM
  `Country` c0_
WHERE
  c0_.tag = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.tag AS tag_2, c0_.currency AS currency_3, c0_.currency_symbol AS currency_symbol_4, c0_.is_default AS is_default_5, c0_.`translations` AS translations_6, c0_.school_calendar_id AS school_calendar_id_7 FROM `Country` c0_ WHERE c0_.tag = 'US' LIMIT 1;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.tag = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.tag = 'en-CA';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.`translations` AS translations_2
FROM
  `StudiedLanguage` s0_
WHERE
  s0_.name = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_ WHERE s0_.name = 'Anglais' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.color AS color_2,
  c0_.`translations` AS translations_3
FROM
  `Concept` c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.color AS color_2, c0_.`translations` AS translations_3 FROM `Concept` c0_;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.`translations` AS translations_2
FROM
  `StudiedLanguage` s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_;

SELECT
  e0_.id AS id_0,
  e0_.display_name AS display_name_1,
  e0_.`translations` AS translations_2
FROM
  `EducationalPathway` e0_
  INNER JOIN countries_educationalPathways c2_ ON e0_.id = c2_.educational_pathway_id
  INNER JOIN `Country` c1_ ON c1_.id = c2_.country_id
WHERE
  c1_.id = ?

SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_ INNER JOIN countries_educationalPathways c2_ ON e0_.id = c2_.educational_pathway_id INNER JOIN `Country` c1_ ON c1_.id = c2_.country_id WHERE c1_.id = 2;

SELECT
  t0_.id AS id_0,
  t1_.id AS id_1,
  t1_.name AS name_2,
  t1_.description AS description_3,
  t1_.educational_intent AS educational_intent_4,
  t1_.student_instructions AS student_instructions_5,
  t1_.expected_duration AS expected_duration_6,
  t1_.note_for_teacher AS note_for_teacher_7,
  t1_.images AS images_8,
  t1_.disabled AS disabled_9,
  t1_.is_highlighted AS is_highlighted_10,
  t1_.historical AS historical_11,
  t1_.starting_blocks AS starting_blocks_12,
  t1_.conclusion AS conclusion_13,
  t1_.is_marked_as_deleted AS is_marked_as_deleted_14,
  t1_.deleted_at AS deleted_at_15,
  d2_.id AS id_16,
  d2_.display_name AS display_name_17,
  d2_.zoho_name AS zoho_name_18,
  e3_.id AS id_19,
  e3_.display_name AS display_name_20,
  e3_.`translations` AS translations_21,
  g4_.id AS id_22,
  g4_.name AS name_23,
  g4_.display_order AS display_order_24,
  g4_.translations AS translations_25,
  g4_.description AS description_26,
  t0_.challenge_template_id AS challenge_template_id_27,
  t0_.educational_pathway_id AS educational_pathway_id_28,
  t1_.challenge_type AS challenge_type_29,
  t1_.language_id AS language_id_30,
  t1_.studied_language_id AS studied_language_id_31,
  t1_.story_template_id AS story_template_id_32,
  t1_.user_challenge_id AS user_challenge_id_33,
  t1_.quiz_id AS quiz_id_34,
  g4_.educational_pathway_id AS educational_pathway_id_35
FROM
  `troub_ChallengeTemplateAssociation` t0_
  INNER JOIN troub_ChallengeTemplate t1_ ON t0_.challenge_template_id = t1_.id
  AND t1_.challenge_type IN ('writing', 'reading')
  INNER JOIN troub_challengeTemplateAssociation_difficultyLevel t5_ ON t0_.id = t5_.difficulty_level_id
  INNER JOIN `DifficultyLevel` d2_ ON d2_.id = t5_.troubadour_association_id
  INNER JOIN `EducationalPathway` e3_ ON t0_.educational_pathway_id = e3_.id
  INNER JOIN `GradeLevel` g4_ ON e3_.id = g4_.educational_pathway_id
  INNER JOIN gradeLevel_difficultyLevel g7_ ON g4_.id = g7_.grade_level_id
  INNER JOIN `DifficultyLevel` d6_ ON d6_.id = g7_.difficulty_level_id
WHERE
  t0_.educational_pathway_id = ?
  AND t1_.disabled = 0
  AND d6_.id = d2_.id

SELECT t0_.id AS id_0, t1_.id AS id_1, t1_.name AS name_2, t1_.description AS description_3, t1_.educational_intent AS educational_intent_4, t1_.student_instructions AS student_instructions_5, t1_.expected_duration AS expected_duration_6, t1_.note_for_teacher AS note_for_teacher_7, t1_.images AS images_8, t1_.disabled AS disabled_9, t1_.is_highlighted AS is_highlighted_10, t1_.historical AS historical_11, t1_.starting_blocks AS starting_blocks_12, t1_.conclusion AS conclusion_13, t1_.is_marked_as_deleted AS is_marked_as_deleted_14, t1_.deleted_at AS deleted_at_15, d2_.id AS id_16, d2_.display_name AS display_name_17, d2_.zoho_name AS zoho_name_18, e3_.id AS id_19, e3_.display_name AS display_name_20, e3_.`translations` AS translations_21, g4_.id AS id_22, g4_.name AS name_23, g4_.display_order AS display_order_24, g4_.translations AS translations_25, g4_.description AS description_26, t0_.challenge_template_id AS challenge_template_id_27, t0_.educational_pathway_id AS educational_pathway_id_28, t1_.challenge_type AS challenge_type_29, t1_.language_id AS language_id_30, t1_.studied_language_id AS studied_language_id_31, t1_.story_template_id AS story_template_id_32, t1_.user_challenge_id AS user_challenge_id_33, t1_.quiz_id AS quiz_id_34, g4_.educational_pathway_id AS educational_pathway_id_35 FROM `troub_ChallengeTemplateAssociation` t0_ INNER JOIN troub_ChallengeTemplate t1_ ON t0_.challenge_template_id = t1_.id AND t1_.challenge_type IN ('writing', 'reading') INNER JOIN troub_challengeTemplateAssociation_difficultyLevel t5_ ON t0_.id = t5_.difficulty_level_id INNER JOIN `DifficultyLevel` d2_ ON d2_.id = t5_.troubadour_association_id INNER JOIN `EducationalPathway` e3_ ON t0_.educational_pathway_id = e3_.id INNER JOIN `GradeLevel` g4_ ON e3_.id = g4_.educational_pathway_id INNER JOIN gradeLevel_difficultyLevel g7_ ON g4_.id = g7_.grade_level_id INNER JOIN `DifficultyLevel` d6_ ON d6_.id = g7_.difficulty_level_id WHERE t0_.educational_pathway_id = 2 AND t1_.disabled = 0 AND d6_.id = d2_.id;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 21;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 23;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 24;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 19;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 20;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.zoho_name AS zoho_name_3
FROM
  `DifficultyLevel` t0
  INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id
WHERE
  gradeLevel_difficultyLevel.grade_level_id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.zoho_name AS zoho_name_3 FROM `DifficultyLevel` t0 INNER JOIN gradeLevel_difficultyLevel ON t0.id = gradeLevel_difficultyLevel.difficulty_level_id WHERE gradeLevel_difficultyLevel.grade_level_id = 22;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.description AS description_2,
  t0_.educational_intent AS educational_intent_3,
  t0_.student_instructions AS student_instructions_4,
  t0_.expected_duration AS expected_duration_5,
  t0_.note_for_teacher AS note_for_teacher_6,
  t0_.images AS images_7,
  t0_.disabled AS disabled_8,
  t0_.is_highlighted AS is_highlighted_9,
  t0_.historical AS historical_10,
  t0_.starting_blocks AS starting_blocks_11,
  t0_.conclusion AS conclusion_12,
  t0_.is_marked_as_deleted AS is_marked_as_deleted_13,
  t0_.deleted_at AS deleted_at_14,
  t0_.challenge_type AS challenge_type_15,
  t0_.language_id AS language_id_16,
  t0_.studied_language_id AS studied_language_id_17,
  t0_.user_challenge_id AS user_challenge_id_18,
  t0_.quiz_id AS quiz_id_19
FROM
  troub_ChallengeTemplate t0_
WHERE
  (
    t0_.is_marked_as_deleted = ?
    AND t0_.disabled = ?
    AND t0_.is_marked_as_deleted = 0
  )
  AND t0_.challenge_type IN ('reading')

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.educational_intent AS educational_intent_3, t0_.student_instructions AS student_instructions_4, t0_.expected_duration AS expected_duration_5, t0_.note_for_teacher AS note_for_teacher_6, t0_.images AS images_7, t0_.disabled AS disabled_8, t0_.is_highlighted AS is_highlighted_9, t0_.historical AS historical_10, t0_.starting_blocks AS starting_blocks_11, t0_.conclusion AS conclusion_12, t0_.is_marked_as_deleted AS is_marked_as_deleted_13, t0_.deleted_at AS deleted_at_14, t0_.challenge_type AS challenge_type_15, t0_.language_id AS language_id_16, t0_.studied_language_id AS studied_language_id_17, t0_.user_challenge_id AS user_challenge_id_18, t0_.quiz_id AS quiz_id_19 FROM troub_ChallengeTemplate t0_ WHERE (t0_.is_marked_as_deleted = 0 AND t0_.disabled = 0 AND t0_.is_marked_as_deleted = 0) AND t0_.challenge_type IN ('reading');

SELECT
  t0_.id AS id_0,
  t1_.id AS id_1
FROM
  `troub_Thematique` t0_
  INNER JOIN thematique_category t2_ ON t0_.id = t2_.thematique_id
  INNER JOIN `troub_Category` t1_ ON t1_.id = t2_.category_id

SELECT t0_.id AS id_0, t1_.id AS id_1 FROM `troub_Thematique` t0_ INNER JOIN thematique_category t2_ ON t0_.id = t2_.thematique_id INNER JOIN `troub_Category` t1_ ON t1_.id = t2_.category_id;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.url AS url_2,
  t0_.route AS route_3,
  t0_.is_active AS is_active_4,
  t0_.display_on_first_time AS display_on_first_time_5
FROM
  `TutorialPanel` t0_
WHERE
  t0_.route = ?
  AND t0_.is_active = ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.url AS url_2, t0_.route AS route_3, t0_.is_active AS is_active_4, t0_.display_on_first_time AS display_on_first_time_5 FROM `TutorialPanel` t0_ WHERE t0_.route = 'troubadour_site_teacher_catalog_.en-CA' AND t0_.is_active = 1;

SELECT
  s0_.id AS id_0,
  s0_.environment AS environment_1,
  s0_.label AS label_2,
  s0_.url AS url_3,
  s0_.icon AS icon_4,
  s0_.flow AS flow_5,
  s0_.position AS position_6,
  s0_.is_published AS is_published_7
FROM
  `SideMenuOption` s0_
WHERE
  s0_.environment = ?
ORDER BY
  s0_.position ASC

SELECT s0_.id AS id_0, s0_.environment AS environment_1, s0_.label AS label_2, s0_.url AS url_3, s0_.icon AS icon_4, s0_.flow AS flow_5, s0_.position AS position_6, s0_.is_published AS is_published_7 FROM `SideMenuOption` s0_ WHERE s0_.environment = 'ENV_TROUBADOUR' ORDER BY s0_.position ASC;

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.text AS text_2,
  i0_.image AS image_3,
  i0_.icon_class AS icon_class_4,
  i0_.route AS route_5,
  i0_.is_active AS is_active_6,
  i0_.translations AS translations_7
FROM
  `InformationPanel` i0_
WHERE
  i0_.route = ?
  AND i0_.is_active = ?
LIMIT
  1

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.text AS text_2, i0_.image AS image_3, i0_.icon_class AS icon_class_4, i0_.route AS route_5, i0_.is_active AS is_active_6, i0_.translations AS translations_7 FROM `InformationPanel` i0_ WHERE i0_.route = 'troubadour_site_teacher_catalog_' AND i0_.is_active = 1 LIMIT 1;