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_clone"
    "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 {#2156
      +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-04-11 00:22:22"
    2 => "2025-04-11 00:22:22"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2156}
  ]
]

[
  "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 {#2156
      +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-04-11 00:22:22"
    2 => "2025-04-11 00:22:22"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2156}
  ]
]

[
  "route" => "troubadour_rest_classroom_user_challenges_updated"
  "route_parameters" => [
    "_route" => "troubadour_rest_classroom_user_challenges_updated"
    "_controller" => "App\Controller\Rest\Troubadour\ClassroomRestController::ClassroomUserChallengesUpdated"
    "classroomId" => "542"
  ]
  "request_uri" => "https://troubadour.constellation.cool/rest/classroom/542/user-challenges/updated?hash=8d5ca4c829ad2137bf28f6d646090bc1"
  "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 {#2277
      +name: "BOOLEAN"
    }
  ]
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.created_at AS created_at_6, t0.last_active AS last_active_7, t0.data AS data_8, t0.google_id AS google_id_9, t0.`character` AS character_10, t0.version AS version_11, t0.anonymized_at AS anonymized_at_12, t0.anonymization_status AS anonymization_status_13, t0.country_id AS country_id_14, t0.onBoarding_status AS onBoarding_status_15, t0.type, t0.isValidEmail AS isValidEmail_16, t0.firstName AS firstName_17, t0.lastName AS lastName_18, t0.schoolName AS schoolName_19, t0.schoolBoardName AS schoolBoardName_20, t0.isFromAnotherCountry AS isFromAnotherCountry_21, t0.isNanomonx AS isNanomonx_22, t0.newsletter AS newsletter_23, t0.free_trial_used AS free_trial_used_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.is_evaluated_as_freemium AS is_evaluated_as_freemium_26, t0.educatonal_pathway_id AS educatonal_pathway_id_27, t0.usage_type_id AS usage_type_id_28, t0.user_region_id AS user_region_id_29, t0.educational_institution AS educational_institution_30, t0.language_id AS language_id_31, t0.linked_email AS linked_email_32, t0.language_id AS language_id_33 FROM `User` t0 WHERE t0.id = ? AND t0.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG')"
  "params" => [
    1 => 1970
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "seb99"
]

[
  "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_.revoked AS revoked_0, l0_.token AS token_1, l0_.expires_at AS expires_at_2, l0_.created_at AS created_at_3, l0_.user_id AS user_id_4 FROM `LoginToken` l0_ WHERE l0_.token = ? LIMIT 1"
  "params" => [
    1 => "521fbde9ec738f8ea1c36e7d6ce2f1b183ba9c622918ad91d5e7edd069bdc8e9"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.rules AS rules_2, c0_.access_code AS access_code_3, c0_.allow_public_access AS allow_public_access_4, c0_.google_course_id AS google_course_id_5, c0_.created_at AS created_at_6, c0_.is_marked_as_deleted AS is_marked_as_deleted_7, c0_.deleted_at AS deleted_at_8, c0_.language_id AS language_id_9, c0_.manager_id AS manager_id_10, c0_.grade_level_id AS grade_level_id_11 FROM `Classroom` c0_ WHERE c0_.id = ? AND c0_.is_marked_as_deleted = 0"
  "params" => [
    1 => "542"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.created_at AS created_at_6, t0.last_active AS last_active_7, t0.data AS data_8, t0.google_id AS google_id_9, t0.`character` AS character_10, t0.version AS version_11, t0.anonymized_at AS anonymized_at_12, t0.anonymization_status AS anonymization_status_13, t0.country_id AS country_id_14, t0.onBoarding_status AS onBoarding_status_15, t0.type, t0.isValidEmail AS isValidEmail_16, t0.firstName AS firstName_17, t0.lastName AS lastName_18, t0.schoolName AS schoolName_19, t0.schoolBoardName AS schoolBoardName_20, t0.isFromAnotherCountry AS isFromAnotherCountry_21, t0.isNanomonx AS isNanomonx_22, t0.newsletter AS newsletter_23, t0.free_trial_used AS free_trial_used_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.is_evaluated_as_freemium AS is_evaluated_as_freemium_26, t0.educatonal_pathway_id AS educatonal_pathway_id_27, t0.usage_type_id AS usage_type_id_28, t0.user_region_id AS user_region_id_29, t0.educational_institution AS educational_institution_30, t0.language_id AS language_id_31, t0.linked_email AS linked_email_32, t0.language_id AS language_id_33 FROM `User` t0 WHERE t0.id IN (?) AND t0.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG')"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.plguser_state AS plguser_state_2, t0.plgusage_status AS plgusage_status_3, t0.plguser_state_family AS plguser_state_family_4, t0.plgusage_status_family AS plgusage_status_family_5, t0.plgonboarding_step AS plgonboarding_step_6, t0.job_title AS job_title_7, t0.organization_type AS organization_type_8, t0.province AS province_9, t0.landing_page_origin AS landing_page_origin_10, t0.is_decision_maker AS is_decision_maker_11, t0.is_troubadour_user AS is_troubadour_user_12, t0.subscription_pending AS subscription_pending_13, t0.subscriptions_used AS subscriptions_used_14, t0.has_valid_subscription AS has_valid_subscription_15, t0.is_freemium AS is_freemium_16, t0.is_school_user AS is_school_user_17, t0.is_family_user AS is_family_user_18, t0.is_dirty AS is_dirty_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.using_activation_code AS using_activation_code_22, t0.has_valid_family_subscription AS has_valid_family_subscription_23, t0.manager AS manager_24, t0.pending_account AS pending_account_25 FROM ZohoState t0 WHERE t0.manager = ?"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.rules AS rules_2, c0_.access_code AS access_code_3, c0_.allow_public_access AS allow_public_access_4, c0_.google_course_id AS google_course_id_5, c0_.created_at AS created_at_6, c0_.is_marked_as_deleted AS is_marked_as_deleted_7, c0_.deleted_at AS deleted_at_8 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.startingDate AS startingDate_2, l0_.endingDate AS endingDate_3, l0_.duration AS duration_4, l0_.price AS price_5, l0_.total_price AS total_price_6, l0_.amount AS amount_7, l0_.reduction AS reduction_8, l0_.total_reduction AS total_reduction_9, l0_.effectiveDate AS effectiveDate_10, l0_.purchase_end_date AS purchase_end_date_11, l0_.`translations` AS translations_12, l0_.`description_translations` AS description_translations_13, l0_.zoho_name AS zoho_name_14, l0_.is_free_trial AS is_free_trial_15, l0_.image AS image_16, l0_.is_private AS is_private_17, l0_.country_id AS country_id_18 FROM `LicenceType` l0_ WHERE l0_.is_free_trial = 0 AND l0_.startingDate <= ? AND l0_.endingDate >= ?"
  "params" => [
    1 => "2025-04-11 00:22:22"
    2 => "2025-04-11 00:22:22"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2156}
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, count(l0_.id) AS sclr_1 FROM `GroupLicence` g1_ INNER JOIN `LicenceType` l0_ ON (l0_.id = g1_.type_id) WHERE g1_.owner_id = ? AND g1_.type_id IN (NULL) GROUP BY l0_.id"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, count(l0_.id) AS sclr_1 FROM `GroupLicence` g1_ INNER JOIN `LicenceType` l0_ ON (l0_.id = g1_.type_id) WHERE g1_.current_user_id = ? AND g1_.type_id IN (NULL) GROUP BY l0_.id"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT l0_.id AS id_0, count(l0_.id) AS sclr_1 FROM `GroupLicence` g1_ INNER JOIN `LicenceType` l0_ ON (l0_.id = g1_.type_id) WHERE g1_.buyer_id = ? AND g1_.type_id IN (NULL) GROUP BY l0_.id"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT g0_.id AS id_0, g0_.created_at AS created_at_1, g0_.expired_at AS expired_at_2, g0_.free_trial_duration AS free_trial_duration_3, g0_.buyer_id AS buyer_id_4, g0_.owner_id AS owner_id_5, g0_.current_user_id AS current_user_id_6, g0_.type_id AS type_id_7 FROM `GroupLicence` g0_ INNER JOIN `LicenceType` l1_ ON (l1_.id = g0_.type_id) WHERE g0_.owner_id = ? AND l1_.is_free_trial = 1"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM `ClassRegistration` c0_ LEFT JOIN `Classroom` c1_ ON c0_.classroom_id = c1_.id WHERE c1_.id IN (?) AND c0_.status IN (?, ?)"
  "params" => [
    1 => 542
    2 => "CONFIRMED"
    3 => "PENDING"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#2156}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s1_.granted_seats AS granted_seats_3, s1_.grants_family_mode_access AS grants_family_mode_access_4, s1_.expiry_date AS expiry_date_5, s3_.expiry_date AS expiry_date_6, s4_.stripe_subscription_id AS stripe_subscription_id_7, s4_.stripe_subscription_status AS stripe_subscription_status_8, s4_.canceled_at AS canceled_at_9, s0_.discr AS discr_10, s0_.owner_id AS owner_id_11, s0_.current_user_id AS current_user_id_12, s2_.type_id AS type_id_13, s2_.buyer_id AS buyer_id_14, s2_.country_id AS country_id_15, s4_.type_id AS type_id_16, s4_.buyer_id AS buyer_id_17, s4_.country_id AS country_id_18 FROM Subscription_Base s0_ LEFT JOIN Subscription_Custom s1_ ON s0_.id = s1_.id LEFT JOIN Subscription_Package s2_ ON s0_.id = s2_.id LEFT JOIN Subscription_FreeTrial s3_ ON s0_.id = s3_.id LEFT JOIN Subscription_Recurring s4_ ON s0_.id = s4_.id WHERE s0_.current_user_id = ?"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.is_valid AS is_valid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.redeemed_at AS redeemed_at_6, t0.subscription_id AS subscription_id_7, t0.type, t0.emission_id AS emission_id_8, t0.package_id AS package_id_9, t0.cart_id AS cart_id_10 FROM `Code` t0 WHERE t0.subscription_id = ? AND t0.type IN ('redeem', 'gift')"
  "params" => [
    1 => 164
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.rules AS rules_2, c0_.access_code AS access_code_3, c0_.allow_public_access AS allow_public_access_4, c0_.google_course_id AS google_course_id_5, c0_.created_at AS created_at_6, c0_.is_marked_as_deleted AS is_marked_as_deleted_7, c0_.deleted_at AS deleted_at_8 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
  "params" => [
    1 => 1969
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(c0_.id) AS sclr_0 FROM `ClassRegistration` c0_ LEFT JOIN `Classroom` c1_ ON c0_.classroom_id = c1_.id WHERE c1_.id IN (?) AND c0_.status IN (?, ?)"
  "params" => [
    1 => 542
    2 => "CONFIRMED"
    3 => "PENDING"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2156
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#2156}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.date_added AS date_added_2, c0_.date_confirmed AS date_confirmed_3, c0_.date_removed AS date_removed_4, c0_.date_rejected AS date_rejected_5, c0_.classroom_id AS classroom_id_6, c0_.student_id AS student_id_7 FROM `ClassRegistration` c0_ WHERE c0_.student_id = ? AND c0_.classroom_id = ? ORDER BY c0_.date_added DESC"
  "params" => [
    1 => 1970
    2 => 542
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2158}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.student_instructions AS student_instructions_3, t0_.historical AS historical_4, t0_.status AS status_5, t0_.premium_status AS premium_status_6, t0_.is_highlighted AS is_highlighted_7, t0_.starting_blocks AS starting_blocks_8, t0_.conclusion AS conclusion_9, t0_.created_at AS created_at_10, t0_.updated_at AS updated_at_11, t0_.is_marked_as_deleted AS is_marked_as_deleted_12, t0_.deleted_at AS deleted_at_13, t0_.classroom_id AS classroom_id_14, t0_.source_template_id AS source_template_id_15, t0_.step_id AS step_id_16, t0_.family_member_id AS family_member_id_17 FROM `troub_Challenge` t0_ WHERE t0_.classroom_id = ? AND t0_.is_marked_as_deleted = 0 ORDER BY t0_.id DESC"
  "params" => [
    1 => 542
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.comments AS comments_1, t0_.thumbnail AS thumbnail_2, t0_.is_highlighted AS is_highlighted_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.completed_at AS completed_at_6, t0_.construction_status AS construction_status_7, t0_.correction_status AS correction_status_8, t0_.is_shared AS is_shared_9, t0_.is_in_portfolio AS is_in_portfolio_10, t0_.last_portfolio_update AS last_portfolio_update_11, t0_.recently_unassigned AS recently_unassigned_12, t0_.last_unassigned_update AS last_unassigned_update_13, t0_.marked_as_done AS marked_as_done_14, t0_.marked_as_in_correction AS marked_as_in_correction_15, t0_.is_favorite AS is_favorite_16, t0_.last_favorite_update AS last_favorite_update_17, t0_.is_in_trash AS is_in_trash_18, t0_.last_trash_update AS last_trash_update_19, t0_.is_marked_as_deleted AS is_marked_as_deleted_20, t0_.deleted_at AS deleted_at_21, t0_.student_id AS student_id_22, t0_.family_member_id AS family_member_id_23, t0_.challenge_id AS challenge_id_24 FROM `troub_UserChallenge` t0_ LEFT JOIN `troub_Challenge` t1_ ON t0_.challenge_id = t1_.id WHERE t0_.student_id = ? AND t1_.id IN (?, ?, ?) AND t0_.is_marked_as_deleted = 0 ORDER BY t0_.id DESC"
  "params" => [
    1 => 1970
    2 => 725
    3 => 724
    4 => 707
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2158}
    3 => Doctrine\DBAL\ParameterType {#2158}
    4 => Doctrine\DBAL\ParameterType {#2158}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comments AS comments_2, t0.thumbnail AS thumbnail_3, t0.is_highlighted AS is_highlighted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.completed_at AS completed_at_7, t0.construction_status AS construction_status_8, t0.correction_status AS correction_status_9, t0.is_shared AS is_shared_10, t0.is_in_portfolio AS is_in_portfolio_11, t0.last_portfolio_update AS last_portfolio_update_12, t0.recently_unassigned AS recently_unassigned_13, t0.last_unassigned_update AS last_unassigned_update_14, t0.marked_as_done AS marked_as_done_15, t0.marked_as_in_correction AS marked_as_in_correction_16, t0.is_favorite AS is_favorite_17, t0.last_favorite_update AS last_favorite_update_18, t0.is_in_trash AS is_in_trash_19, t0.last_trash_update AS last_trash_update_20, t0.is_marked_as_deleted AS is_marked_as_deleted_21, t0.deleted_at AS deleted_at_22, t0.student_id AS student_id_23, t0.family_member_id AS family_member_id_24, t25.id AS id_26, t25.name AS name_27, t25.code AS code_28, t25.type AS type_29, t25.has_seen_guided_tutorial AS has_seen_guided_tutorial_30, t25.is_marked_as_deleted AS is_marked_as_deleted_31, t25.deleted_at AS deleted_at_32, t25.family_id AS family_id_33, t25.babillard_id AS babillard_id_34, t0.challenge_id AS challenge_id_35 FROM `troub_UserChallenge` t0 LEFT JOIN `FamilyMember` t25 ON t0.family_member_id = t25.id WHERE t0.challenge_id = ?"
  "params" => [
    1 => 725
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.date_added AS date_added_3, t0.date_confirmed AS date_confirmed_4, t0.date_removed AS date_removed_5, t0.date_rejected AS date_rejected_6, t0.classroom_id AS classroom_id_7, t0.student_id AS student_id_8 FROM `ClassRegistration` t0 WHERE t0.classroom_id = ?"
  "params" => [
    1 => 542
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.created_at AS created_at_6, t0.last_active AS last_active_7, t0.data AS data_8, t0.google_id AS google_id_9, t0.`character` AS character_10, t0.version AS version_11, t0.anonymized_at AS anonymized_at_12, t0.anonymization_status AS anonymization_status_13, t0.country_id AS country_id_14, t0.onBoarding_status AS onBoarding_status_15, t0.type, t0.isValidEmail AS isValidEmail_16, t0.firstName AS firstName_17, t0.lastName AS lastName_18, t0.schoolName AS schoolName_19, t0.schoolBoardName AS schoolBoardName_20, t0.isFromAnotherCountry AS isFromAnotherCountry_21, t0.isNanomonx AS isNanomonx_22, t0.newsletter AS newsletter_23, t0.free_trial_used AS free_trial_used_24, t0.stripe_customer_id AS stripe_customer_id_25, t0.is_evaluated_as_freemium AS is_evaluated_as_freemium_26, t0.educatonal_pathway_id AS educatonal_pathway_id_27, t0.usage_type_id AS usage_type_id_28, t0.user_region_id AS user_region_id_29, t0.educational_institution AS educational_institution_30, t0.language_id AS language_id_31, t0.linked_email AS linked_email_32, t0.language_id AS language_id_33 FROM `User` t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?) AND t0.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG')"
  "params" => [
    1 => 1971
    2 => 1972
    3 => 1973
    4 => 1974
    5 => 1975
    6 => 1976
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#2158}
    3 => Doctrine\DBAL\ParameterType {#2158}
    4 => Doctrine\DBAL\ParameterType {#2158}
    5 => Doctrine\DBAL\ParameterType {#2158}
    6 => Doctrine\DBAL\ParameterType {#2158}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comments AS comments_2, t0.thumbnail AS thumbnail_3, t0.is_highlighted AS is_highlighted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.completed_at AS completed_at_7, t0.construction_status AS construction_status_8, t0.correction_status AS correction_status_9, t0.is_shared AS is_shared_10, t0.is_in_portfolio AS is_in_portfolio_11, t0.last_portfolio_update AS last_portfolio_update_12, t0.recently_unassigned AS recently_unassigned_13, t0.last_unassigned_update AS last_unassigned_update_14, t0.marked_as_done AS marked_as_done_15, t0.marked_as_in_correction AS marked_as_in_correction_16, t0.is_favorite AS is_favorite_17, t0.last_favorite_update AS last_favorite_update_18, t0.is_in_trash AS is_in_trash_19, t0.last_trash_update AS last_trash_update_20, t0.is_marked_as_deleted AS is_marked_as_deleted_21, t0.deleted_at AS deleted_at_22, t0.student_id AS student_id_23, t0.family_member_id AS family_member_id_24, t25.id AS id_26, t25.name AS name_27, t25.code AS code_28, t25.type AS type_29, t25.has_seen_guided_tutorial AS has_seen_guided_tutorial_30, t25.is_marked_as_deleted AS is_marked_as_deleted_31, t25.deleted_at AS deleted_at_32, t25.family_id AS family_id_33, t25.babillard_id AS babillard_id_34, t0.challenge_id AS challenge_id_35 FROM `troub_UserChallenge` t0 LEFT JOIN `FamilyMember` t25 ON t0.family_member_id = t25.id WHERE t0.challenge_id = ?"
  "params" => [
    1 => 724
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.message AS message_2, t0.date AS date_3, t0.month AS month_4, t0.day AS day_5, t0.is_marked_as_deleted AS is_marked_as_deleted_6, t0.deleted_at AS deleted_at_7, t0.learning_path AS learning_path_8, t0.template_id AS template_id_9 FROM `troub_LearningPathChallengeStep` t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.comments AS comments_2, t0.thumbnail AS thumbnail_3, t0.is_highlighted AS is_highlighted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.completed_at AS completed_at_7, t0.construction_status AS construction_status_8, t0.correction_status AS correction_status_9, t0.is_shared AS is_shared_10, t0.is_in_portfolio AS is_in_portfolio_11, t0.last_portfolio_update AS last_portfolio_update_12, t0.recently_unassigned AS recently_unassigned_13, t0.last_unassigned_update AS last_unassigned_update_14, t0.marked_as_done AS marked_as_done_15, t0.marked_as_in_correction AS marked_as_in_correction_16, t0.is_favorite AS is_favorite_17, t0.last_favorite_update AS last_favorite_update_18, t0.is_in_trash AS is_in_trash_19, t0.last_trash_update AS last_trash_update_20, t0.is_marked_as_deleted AS is_marked_as_deleted_21, t0.deleted_at AS deleted_at_22, t0.student_id AS student_id_23, t0.family_member_id AS family_member_id_24, t25.id AS id_26, t25.name AS name_27, t25.code AS code_28, t25.type AS type_29, t25.has_seen_guided_tutorial AS has_seen_guided_tutorial_30, t25.is_marked_as_deleted AS is_marked_as_deleted_31, t25.deleted_at AS deleted_at_32, t25.family_id AS family_id_33, t25.babillard_id AS babillard_id_34, t0.challenge_id AS challenge_id_35 FROM `troub_UserChallenge` t0 LEFT JOIN `FamilyMember` t25 ON t0.family_member_id = t25.id WHERE t0.challenge_id = ?"
  "params" => [
    1 => 707
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.date AS date_3, t0.userChallenge_id AS userChallenge_id_4 FROM `troub_UserChallengeStatus` t0 WHERE t0.userChallenge_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 612
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.created_at AS created_at_6, t0.last_active AS last_active_7, t0.data AS data_8, t0.google_id AS google_id_9, t0.`character` AS character_10, t0.version AS version_11, t0.anonymized_at AS anonymized_at_12, t0.anonymization_status AS anonymization_status_13, t0.linked_email AS linked_email_14, t0.country_id AS country_id_15, t0.onBoarding_status AS onBoarding_status_16, t0.language_id AS language_id_17, t0.type FROM `User` t0 INNER JOIN troub_student_challenge ON t0.id = troub_student_challenge.challenge_id WHERE troub_student_challenge.student_id = ? AND t0.type IN ('ROLE_STUDENT')"
  "params" => [
    1 => 724
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.userChallenge_id AS userChallenge_id_5, t6.id AS id_7, t6.position AS position_8, t6.is_marked_as_deleted AS is_marked_as_deleted_9, t6.deleted_at AS deleted_at_10, t6.work_block_id AS work_block_id_11, t6.background_id AS background_id_12, t6.floor_id AS floor_id_13, t6.foreground_id AS foreground_id_14, t6.back_color_id AS back_color_id_15 FROM `troub_WorkBlock` t0 LEFT JOIN `troub_World` t6 ON t6.work_block_id = t0.id WHERE t0.userChallenge_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 612
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.work_block_id AS work_block_id_6, t0.type, t0.world_object_id AS world_object_id_7 FROM `troub_TextEntry` t0 WHERE t0.work_block_id = ? AND t0.type IN ('TYPE_NARRATION', 'TYPE_ASSET', 'TYPE_TITLE')"
  "params" => [
    1 => 2017
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.text AS text_2, t0.teacherComment AS teacherComment_3, t0.date AS date_4, t0.is_marked_as_deleted AS is_marked_as_deleted_5, t0.deleted_at AS deleted_at_6, t0.textEntryId AS textEntryId_7, t0.userID AS userID_8 FROM `troub_Revision` t0 WHERE t0.textEntryId = ? ORDER BY t0.date ASC"
  "params" => [
    1 => 3290
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.text AS text_2, t0.date AS date_3, t0.is_marked_as_deleted AS is_marked_as_deleted_4, t0.deleted_at AS deleted_at_5, t0.revisionId AS revisionId_6 FROM `troub_RevisionHistory` t0 WHERE t0.revisionId = ? ORDER BY t0.date ASC"
  "params" => [
    1 => 1262
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.date AS date_3, t0.userChallenge_id AS userChallenge_id_4 FROM `troub_UserChallengeStatus` t0 WHERE t0.userChallenge_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 607
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.displayName AS displayName_2, t0.username AS username_3, t0.password AS password_4, t0.salt AS salt_5, t0.created_at AS created_at_6, t0.last_active AS last_active_7, t0.data AS data_8, t0.google_id AS google_id_9, t0.`character` AS character_10, t0.version AS version_11, t0.anonymized_at AS anonymized_at_12, t0.anonymization_status AS anonymization_status_13, t0.linked_email AS linked_email_14, t0.country_id AS country_id_15, t0.onBoarding_status AS onBoarding_status_16, t0.language_id AS language_id_17, t0.type FROM `User` t0 INNER JOIN troub_student_challenge ON t0.id = troub_student_challenge.challenge_id WHERE troub_student_challenge.student_id = ? AND t0.type IN ('ROLE_STUDENT')"
  "params" => [
    1 => 707
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.userChallenge_id AS userChallenge_id_5, t6.id AS id_7, t6.position AS position_8, t6.is_marked_as_deleted AS is_marked_as_deleted_9, t6.deleted_at AS deleted_at_10, t6.work_block_id AS work_block_id_11, t6.background_id AS background_id_12, t6.floor_id AS floor_id_13, t6.foreground_id AS foreground_id_14, t6.back_color_id AS back_color_id_15 FROM `troub_WorkBlock` t0 LEFT JOIN `troub_World` t6 ON t6.work_block_id = t0.id WHERE t0.userChallenge_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 607
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.work_block_id AS work_block_id_6, t0.type, t0.world_object_id AS world_object_id_7 FROM `troub_TextEntry` t0 WHERE t0.work_block_id = ? AND t0.type IN ('TYPE_NARRATION', 'TYPE_ASSET', 'TYPE_TITLE')"
  "params" => [
    1 => 2004
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.text AS text_2, t0.teacherComment AS teacherComment_3, t0.date AS date_4, t0.is_marked_as_deleted AS is_marked_as_deleted_5, t0.deleted_at AS deleted_at_6, t0.textEntryId AS textEntryId_7, t0.userID AS userID_8 FROM `troub_Revision` t0 WHERE t0.textEntryId = ? ORDER BY t0.date ASC"
  "params" => [
    1 => 3268
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2158
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]