Symfony Profiler

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 challengeTemplateAssociation_difficultyLevel ON t0.id = challengeTemplateAssociation_difficultyLevel.association_id
WHERE
  challengeTemplateAssociation_difficultyLevel.difficulty_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 challengeTemplateAssociation_difficultyLevel ON t0.id = challengeTemplateAssociation_difficultyLevel.association_id WHERE challengeTemplateAssociation_difficultyLevel.difficulty_level_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.teacher_description AS teacher_description_4,
  t0.educational_intent AS educational_intent_5,
  t0.additional_activities AS additional_activities_6,
  t0.expected_duration AS expected_duration_7,
  t0.is_reading_challenge AS is_reading_challenge_8,
  t0.printable_questionnaire AS printable_questionnaire_9,
  t0.answer_key AS answer_key_10,
  t0.images AS images_11,
  t0.rules AS rules_12,
  t0.disabled AS disabled_13,
  t0.island_type AS island_type_14,
  t0.is_highlighted AS is_highlighted_15,
  t0.is_marked_as_deleted AS is_marked_as_deleted_16,
  t0.deleted_at AS deleted_at_17,
  t0.language_id AS language_id_18,
  t0.content_world AS content_world_19,
  t0.original_world_id AS original_world_id_20
FROM
  `ChallengeTemplate` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.teacher_description AS teacher_description_4, t0.educational_intent AS educational_intent_5, t0.additional_activities AS additional_activities_6, t0.expected_duration AS expected_duration_7, t0.is_reading_challenge AS is_reading_challenge_8, t0.printable_questionnaire AS printable_questionnaire_9, t0.answer_key AS answer_key_10, t0.images AS images_11, t0.rules AS rules_12, t0.disabled AS disabled_13, t0.island_type AS island_type_14, t0.is_highlighted AS is_highlighted_15, t0.is_marked_as_deleted AS is_marked_as_deleted_16, t0.deleted_at AS deleted_at_17, t0.language_id AS language_id_18, t0.content_world AS content_world_19, t0.original_world_id AS original_world_id_20 FROM `ChallengeTemplate` t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.`translations` AS translations_3
FROM
  `Subject` t0
  INNER JOIN challengeTemplates_subjects ON t0.id = challengeTemplates_subjects.subject_id
WHERE
  challengeTemplates_subjects.template_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.`translations` AS translations_3 FROM `Subject` t0 INNER JOIN challengeTemplates_subjects ON t0.id = challengeTemplates_subjects.subject_id WHERE challengeTemplates_subjects.template_id = 9;

SELECT
  t0.id AS id_4,
  t0.name AS name_5,
  t0.version AS version_6,
  t0.is_marked_as_deleted AS is_marked_as_deleted_7,
  t0.deleted_at AS deleted_at_8,
  t0.discr,
  t1.student_id AS student_id_9,
  t2.public AS public_10,
  t2.description AS description_11,
  t2.island_type AS island_type_12,
  t2.created_at AS created_at_13,
  t2.manager_id AS manager_id_14,
  t2.classroom_id AS classroom_id_15,
  t2.template_id AS template_id_16,
  t3.description AS description_17,
  t3.island_type AS island_type_18,
  t3.creator_id AS creator_id_19,
  t3.template_id AS template_id_20
FROM
  `World` t0
  LEFT JOIN `StudentWorld` t1 ON t0.id = t1.id
  LEFT JOIN `TeacherWorld` t2 ON t0.id = t2.id
  LEFT JOIN `ReadingTemplateWorld` t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.name AS name_5, t0.version AS version_6, t0.is_marked_as_deleted AS is_marked_as_deleted_7, t0.deleted_at AS deleted_at_8, t0.discr, t1.student_id AS student_id_9, t2.public AS public_10, t2.description AS description_11, t2.island_type AS island_type_12, t2.created_at AS created_at_13, t2.manager_id AS manager_id_14, t2.classroom_id AS classroom_id_15, t2.template_id AS template_id_16, t3.description AS description_17, t3.island_type AS island_type_18, t3.creator_id AS creator_id_19, t3.template_id AS template_id_20 FROM `World` t0 LEFT JOIN `StudentWorld` t1 ON t0.id = t1.id LEFT JOIN `TeacherWorld` t2 ON t0.id = t2.id LEFT JOIN `ReadingTemplateWorld` t3 ON t0.id = t3.id WHERE t0.id = 6528;

SELECT
  c0_.id AS id_0,
  c0_.challenge_template_id AS challenge_template_id_1,
  c0_.educational_pathway_id AS educational_pathway_id_2
FROM
  `ChallengeTemplateAssociation` c0_
WHERE
  c0_.educational_pathway_id = ?

SELECT c0_.id AS id_0, c0_.challenge_template_id AS challenge_template_id_1, c0_.educational_pathway_id AS educational_pathway_id_2 FROM `ChallengeTemplateAssociation` c0_ WHERE c0_.educational_pathway_id = 2;

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tag AS tag_3,
  t0.currency AS currency_4,
  t0.currency_symbol AS currency_symbol_5,
  t0.is_default AS is_default_6,
  t0.`translations` AS translations_7,
  t0.school_calendar_id AS school_calendar_id_8
FROM
  `Country` t0
  INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id
WHERE
  countries_educationalPathways.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.currency AS currency_4, t0.currency_symbol AS currency_symbol_5, t0.is_default AS is_default_6, t0.`translations` AS translations_7, t0.school_calendar_id AS school_calendar_id_8 FROM `Country` t0 INNER JOIN countries_educationalPathways ON t0.id = countries_educationalPathways.country_id WHERE countries_educationalPathways.educational_pathway_id = 1;

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 = 'constellation_site_catalog_.fr-CA' AND t0_.is_active = 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.teacher_description AS teacher_description_3,
  c0_.educational_intent AS educational_intent_4,
  c0_.additional_activities AS additional_activities_5,
  c0_.expected_duration AS expected_duration_6,
  c0_.is_reading_challenge AS is_reading_challenge_7,
  c0_.printable_questionnaire AS printable_questionnaire_8,
  c0_.answer_key AS answer_key_9,
  c0_.images AS images_10,
  c0_.rules AS rules_11,
  c0_.disabled AS disabled_12,
  c0_.island_type AS island_type_13,
  c0_.is_highlighted AS is_highlighted_14,
  c0_.is_marked_as_deleted AS is_marked_as_deleted_15,
  c0_.deleted_at AS deleted_at_16,
  c0_.language_id AS language_id_17,
  c0_.content_world AS content_world_18,
  c0_.original_world_id AS original_world_id_19
FROM
  `ChallengeTemplate` c0_
WHERE
  c0_.id = ?
  AND c0_.is_marked_as_deleted = 0

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.teacher_description AS teacher_description_3, c0_.educational_intent AS educational_intent_4, c0_.additional_activities AS additional_activities_5, c0_.expected_duration AS expected_duration_6, c0_.is_reading_challenge AS is_reading_challenge_7, c0_.printable_questionnaire AS printable_questionnaire_8, c0_.answer_key AS answer_key_9, c0_.images AS images_10, c0_.rules AS rules_11, c0_.disabled AS disabled_12, c0_.island_type AS island_type_13, c0_.is_highlighted AS is_highlighted_14, c0_.is_marked_as_deleted AS is_marked_as_deleted_15, c0_.deleted_at AS deleted_at_16, c0_.language_id AS language_id_17, c0_.content_world AS content_world_18, c0_.original_world_id AS original_world_id_19 FROM `ChallengeTemplate` c0_ WHERE c0_.id = '72' AND c0_.is_marked_as_deleted = 0;

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
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.`translations` AS translations_2
FROM
  `Subject` s0_

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_order AS display_order_3,
  t0.translations AS translations_4,
  t0.description AS description_5,
  t0.educational_pathway_id AS educational_pathway_id_6
FROM
  `GradeLevel` t0
WHERE
  t0.educational_pathway_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.translations AS translations_4, t0.description AS description_5, t0.educational_pathway_id AS educational_pathway_id_6 FROM `GradeLevel` t0 WHERE t0.educational_pathway_id = 2;

SELECT
  e0_.id AS id_0,
  e0_.display_name AS display_name_1,
  e0_.`translations` AS translations_2
FROM
  `EducationalPathway` e0_

SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.is_historical AS is_historical_2,
  t0_.is_forDefaultChallenge AS is_forDefaultChallenge_3,
  t0_.`translations` AS translations_4,
  t0_.client_id AS client_id_5
FROM
  `Theme` t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_historical AS is_historical_2, t0_.is_forDefaultChallenge AS is_forDefaultChallenge_3, t0_.`translations` AS translations_4, t0_.client_id AS client_id_5 FROM `Theme` t0_;

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
  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
  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
  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_CONSTELLATION' ORDER BY s0_.position ASC;

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
  DATABASE()

SELECT DATABASE();

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 < '2024-12-19 02:52:33' AND m0_.ending_date > '2024-12-19 02:52:33' 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
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.is_crawlable AS is_crawlable_2,
  i0_.is_legal_document AS is_legal_document_3,
  i0_.asked_for_validation_on AS asked_for_validation_on_4,
  i0_.is_default_user_agreement AS is_default_user_agreement_5,
  i0_.is_default_privacy_policy AS is_default_privacy_policy_6,
  i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7,
  i0_.is_marked_as_deleted AS is_marked_as_deleted_8,
  i0_.deleted_at AS deleted_at_9
FROM
  `InformationPage` i0_
WHERE
  i0_.is_default_privacy_policy = ?
  AND i0_.is_marked_as_deleted = 0
LIMIT
  1

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_privacy_policy = 1 AND i0_.is_marked_as_deleted = 0 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_
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 = 'fr-CA';

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 = 'constellation_site_catalog_' AND i0_.is_active = 1 LIMIT 1;

SELECT
  i0_.id AS id_0,
  i0_.name AS name_1,
  i0_.is_crawlable AS is_crawlable_2,
  i0_.is_legal_document AS is_legal_document_3,
  i0_.asked_for_validation_on AS asked_for_validation_on_4,
  i0_.is_default_user_agreement AS is_default_user_agreement_5,
  i0_.is_default_privacy_policy AS is_default_privacy_policy_6,
  i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7,
  i0_.is_marked_as_deleted AS is_marked_as_deleted_8,
  i0_.deleted_at AS deleted_at_9
FROM
  `InformationPage` i0_
WHERE
  i0_.is_default_user_agreement = ?
  AND i0_.is_marked_as_deleted = 0
LIMIT
  1

SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.is_crawlable AS is_crawlable_2, i0_.is_legal_document AS is_legal_document_3, i0_.asked_for_validation_on AS asked_for_validation_on_4, i0_.is_default_user_agreement AS is_default_user_agreement_5, i0_.is_default_privacy_policy AS is_default_privacy_policy_6, i0_.is_marketing_privacy_policy AS is_marketing_privacy_policy_7, i0_.is_marked_as_deleted AS is_marked_as_deleted_8, i0_.deleted_at AS deleted_at_9 FROM `InformationPage` i0_ WHERE i0_.is_default_user_agreement = 1 AND i0_.is_marked_as_deleted = 0 LIMIT 1;