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 {#2077
      +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 => "2024-12-19 02:52:33"
    2 => "2024-12-19 02:52:33"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2077
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2077}
  ]
]

[
  "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 {#2077
      +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 => "2024-12-19 02:52:33"
    2 => "2024-12-19 02:52:33"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2077
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2077}
  ]
]

[
  "route" => "constellation_site_catalog_"
  "route_parameters" => [
    "_route" => "constellation_site_catalog_"
    "flow" => "catalog"
    "id" => "72"
    "_controller" => "App\Controller\Site\Constellation\CatalogController::GetCatalog"
    "_locale" => "fr-CA"
  ]
  "request_uri" => "https://constellation.constellation.cool/catalogue/72?language=14"
  "method" => "GET"
]

[
  "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 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 => "fr-CA"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2077
      +name: "STRING"
    }
  ]
]

[
  "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 {#2077
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.`translations` AS translations_2 FROM `Subject` 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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +name: "INTEGER"
    }
  ]
]

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

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

[
  "sql" => "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 = ?"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2079
      +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 challengeTemplateAssociation_difficultyLevel ON t0.id = challengeTemplateAssociation_difficultyLevel.association_id WHERE challengeTemplateAssociation_difficultyLevel.difficulty_level_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +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 {#2079
      +name: "INTEGER"
    }
  ]
]