Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "constellation-web.cluster-ctnrcl0n8o8r.ca-central-1.rds.amazonaws.com"
    "dbname" => "nano_ca_dev_merged"
    "user" => "nano_ca_dev"
    "password" => "<redacted>"
    "port" => "3306"
    "idle_connection_ttl" => 600
    "driverOptions" => [
      1009 => "/code/config/keys/ca-central-1-bundle.pem"
    ]
    "serverVersion" => "8.0.39"
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
    ]
  ]
]

[
  "sql" => "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"
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "nano_ca_dev_merged"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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_"
]

[
  "sql" => "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"
  "params" => [
    1 => "2025-07-27 10:02:35"
    2 => "2025-07-27 10:02:35"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2255}
  ]
]

[
  "sql" => "SELECT DATABASE()"
]

[
  "sql" => """
    SELECT TABLE_NAME\n
    FROM information_schema.TABLES\n
    WHERE TABLE_SCHEMA = ?\n
      AND TABLE_TYPE = 'BASE TABLE'\n
    ORDER BY TABLE_NAME
    """
  "params" => [
    1 => "nano_ca_dev_merged"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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_"
]

[
  "sql" => "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"
  "params" => [
    1 => "2025-07-27 10:02:36"
    2 => "2025-07-27 10:02:36"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2255}
  ]
]

[
  "route" => "troubadour_site_teacher_catalog_"
  "route_parameters" => [
    "_route" => "troubadour_site_teacher_catalog_"
    "flow" => "catalog"
    "id" => null
    "_controller" => "App\Controller\Site\Troubadour\Teacher\CatalogController::GetCatalog"
    "_locale" => "en-CA"
  ]
  "request_uri" => "https://troubadour.constellation.cool/catalog"
  "method" => "GET"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2353
      +name: "BOOLEAN"
    }
  ]
]

[
  "firewall_name" => "main"
  "authenticators" => 4
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "US"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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_"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "en-CA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_ WHERE s0_.name = ? LIMIT 1"
  "params" => [
    1 => "Anglais"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2255
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.color AS color_2, c0_.`translations` AS translations_3 FROM `Concept` c0_"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `StudiedLanguage` s0_"
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.display_name AS display_name_1, e0_.`translations` AS translations_2 FROM `EducationalPathway` e0_"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.challenge_template_id AS challenge_template_id_1, t0_.educational_pathway_id AS educational_pathway_id_2 FROM `troub_ChallengeTemplateAssociation` t0_ WHERE t0_.educational_pathway_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 30
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 55
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 troub_challengeTemplateAssociation_difficultyLevel ON t0.id = troub_challengeTemplateAssociation_difficultyLevel.troubadour_association_id WHERE troub_challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 67
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.`translations` AS translations_4 FROM `Concept` t0 INNER JOIN troub_challengeTemplate_concept ON t0.id = troub_challengeTemplate_concept.concept_id WHERE troub_challengeTemplate_concept.template_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.`translations` AS translations_4 FROM `Concept` t0 INNER JOIN troub_challengeTemplate_concept ON t0.id = troub_challengeTemplate_concept.concept_id WHERE troub_challengeTemplate_concept.template_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.`translations` AS translations_4 FROM `Concept` t0 INNER JOIN troub_challengeTemplate_concept ON t0.id = troub_challengeTemplate_concept.concept_id WHERE troub_challengeTemplate_concept.template_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.color AS color_3, t0.`translations` AS translations_4 FROM `Concept` t0 INNER JOIN troub_challengeTemplate_concept ON t0.id = troub_challengeTemplate_concept.concept_id WHERE troub_challengeTemplate_concept.template_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2257
      +name: "INTEGER"
    }
  ]
]