The "Symfony\Component\HttpKernel\DependencyInjection\Extension" class is considered internal since Symfony 7.1, to be deprecated in 8.1; use Symfony\Component\DependencyInjection\Extension\Extension instead. It may change without further notice. You should not use it from "Bugsnag\BugsnagBundle\DependencyInjection\BugsnagExtension".
The "App\Security\Voters\BabillardVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\ChallengeStatusVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\ChallengeVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\ClassroomVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\CreationVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyAccessVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyChallengeVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyCreationVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyMemberVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyModeVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\FamilyUserChallengeVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\ReadingChallengeAccessVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\StudentStoryVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\UserChallengeVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
The "App\Security\Voters\UserVoter::voteOnAttribute()" method will require a new "Vote|null $vote" argument in the next major version of its parent class "Symfony\Component\Security\Core\Authorization\Voter\Voter", not defining it is deprecated.
User Deprecated: Class "Doctrine\ORM\Proxy\Autoloader" is deprecated. Use native lazy objects instead. (Autoloader.php:74 called by DoctrineBundle.php:130, https://github.com/doctrine/orm/pull/12005, package doctrine/orm)
"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"
doctrine
[
"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"
]
debug
Executing query:
"SELECT DATABASE()"
doctrine
[
"sql" => "SELECT DATABASE()"
]
debug
Executing statement:
"""
SELECT TABLE_NAME\nFROM information_schema.TABLES\nWHERE TABLE_SCHEMA = ?\n AND TABLE_TYPE = 'BASE TABLE'\nORDER 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_"
doctrine
[
"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_"
]
"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_"
doctrine
[
"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_"
]
"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 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 u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.linked_email AS linked_email_24, u0_.type AS type_25, u0_.country_id AS country_id_26, u0_.onBoarding_status AS onBoarding_status_27, u0_.educatonal_pathway_id AS educatonal_pathway_id_28, u0_.usage_type_id AS usage_type_id_29, u0_.user_region_id AS user_region_id_30, u0_.educational_institution AS educational_institution_31, u0_.language_id AS language_id_32, u0_.language_id AS language_id_33 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1"
[
"sql" => "SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.linked_email AS linked_email_24, u0_.type AS type_25, u0_.country_id AS country_id_26, u0_.onBoarding_status AS onBoarding_status_27, u0_.educatonal_pathway_id AS educatonal_pathway_id_28, u0_.usage_type_id AS usage_type_id_29, u0_.user_region_id AS user_region_id_30, u0_.educational_institution AS educational_institution_31, u0_.language_id AS language_id_32, u0_.language_id AS language_id_33 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1"
"params" => [1 => "alex.gray@nanomonx.com"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#2430
+name: "STRING"
}
]
]
deprecation
User Deprecated: Since symfony/var-exporter 7.3: Using ProxyHelper::generateLazyGhost() is deprecated, use native lazy objects instead.
User Deprecated: Since symfony/var-exporter 7.3: The "Symfony\Component\VarExporter\LazyGhostTrait" trait is deprecated, use native lazy objects instead.
"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 = ?"
[
"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 => 1950]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
deprecation
User Deprecated: Since symfony/security-http 7.3: Implementing "App\Entity\Manager::eraseCredentials()" is deprecated since Symfony 7.3; add the #[\Deprecated] attribute on the method to signal its either empty or that you moved the logic elsewhere, typically to the "__serialize()" method.
"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_.skip_until_school_year AS skip_until_school_year_5, c0_.google_course_id AS google_course_id_6, c0_.created_at AS created_at_7, c0_.is_marked_as_deleted AS is_marked_as_deleted_8, c0_.deleted_at AS deleted_at_9, c0_.language_id AS language_id_10, c0_.manager_id AS manager_id_11, c0_.grade_level_id AS grade_level_id_12 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
[
"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_.skip_until_school_year AS skip_until_school_year_5, c0_.google_course_id AS google_course_id_6, c0_.created_at AS created_at_7, c0_.is_marked_as_deleted AS is_marked_as_deleted_8, c0_.deleted_at AS deleted_at_9, c0_.language_id AS language_id_10, c0_.manager_id AS manager_id_11, c0_.grade_level_id AS grade_level_id_12 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
"params" => [1 => 1950]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"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 = ?"
[
"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 => 1950]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"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')"
[
"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 => 153]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"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')"
[
"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 => 169]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"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')"
[
"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 => 170]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
"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_.skip_until_school_year AS skip_until_school_year_5, c0_.google_course_id AS google_course_id_6, c0_.created_at AS created_at_7, c0_.is_marked_as_deleted AS is_marked_as_deleted_8, c0_.deleted_at AS deleted_at_9, c0_.language_id AS language_id_10, c0_.manager_id AS manager_id_11, c0_.grade_level_id AS grade_level_id_12 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
[
"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_.skip_until_school_year AS skip_until_school_year_5, c0_.google_course_id AS google_course_id_6, c0_.created_at AS created_at_7, c0_.is_marked_as_deleted AS is_marked_as_deleted_8, c0_.deleted_at AS deleted_at_9, c0_.language_id AS language_id_10, c0_.manager_id AS manager_id_11, c0_.grade_level_id AS grade_level_id_12 FROM `Classroom` c0_ WHERE c0_.manager_id = ? AND c0_.is_marked_as_deleted = 0"
"params" => [1 => 1950]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.image AS image_3, t0_.creation_date AS creation_date_4, t0_.is_freemium AS is_freemium_5, t0_.is_marked_as_deleted AS is_marked_as_deleted_6, t0_.deleted_at AS deleted_at_7, t0_.language_id AS language_id_8 FROM `troub_LearningPath` t0_ WHERE t0_.is_freemium = ? AND t0_.is_marked_as_deleted = 0"
[
"sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.image AS image_3, t0_.creation_date AS creation_date_4, t0_.is_freemium AS is_freemium_5, t0_.is_marked_as_deleted AS is_marked_as_deleted_6, t0_.deleted_at AS deleted_at_7, t0_.language_id AS language_id_8 FROM `troub_LearningPath` t0_ WHERE t0_.is_freemium = ? AND t0_.is_marked_as_deleted = 0"
"params" => [1 => 1]
"types" => [1 => Doctrine\DBAL\ParameterType {#2531
+name: "BOOLEAN"
}
]
]
debug
Executing statement:
"SELECT COUNT(t0_.id) AS sclr_0 FROM `troub_LearningPathAssignment` t0_ LEFT JOIN `Classroom` c1_ ON t0_.classroom_id = c1_.id LEFT JOIN `troub_LearningPath` t2_ ON t0_.learning_path_id = t2_.id WHERE c1_.id IN (?, ?) AND t2_.id IN (?, ?)"
"SELECT g0_.token AS token_0, g0_.google_id AS google_id_1, g0_.created_at AS created_at_2, g0_.user_id AS user_id_3 FROM GoogleRefreshToken g0_ WHERE g0_.google_id = ? LIMIT 1"
[
"sql" => "SELECT g0_.token AS token_0, g0_.google_id AS google_id_1, g0_.created_at AS created_at_2, g0_.user_id AS user_id_3 FROM GoogleRefreshToken g0_ WHERE g0_.google_id = ? LIMIT 1"
"params" => [1 => "106792430983192295350"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#2430
+name: "STRING"
}
]
]
debug
Executing statement:
"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 = ?"
[
"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 => 536]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"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')"
[
"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 => 16802 => 2274]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
2 => Doctrine\DBAL\ParameterType {#2432}
]
]
debug
Executing statement:
"SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.linked_email AS linked_email_24, u0_.type AS type_25, u0_.country_id AS country_id_26, u0_.onBoarding_status AS onBoarding_status_27, u0_.educatonal_pathway_id AS educatonal_pathway_id_28, u0_.usage_type_id AS usage_type_id_29, u0_.user_region_id AS user_region_id_30, u0_.educational_institution AS educational_institution_31, u0_.language_id AS language_id_32, u0_.language_id AS language_id_33 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1"
[
"sql" => "SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.linked_email AS linked_email_24, u0_.type AS type_25, u0_.country_id AS country_id_26, u0_.onBoarding_status AS onBoarding_status_27, u0_.educatonal_pathway_id AS educatonal_pathway_id_28, u0_.usage_type_id AS usage_type_id_29, u0_.user_region_id AS user_region_id_30, u0_.educational_institution AS educational_institution_31, u0_.language_id AS language_id_32, u0_.language_id AS language_id_33 FROM `User` u0_ WHERE (u0_.username = ?) AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1"
"params" => [1 => "quentin.debest@nanomonx.com"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#2430
+name: "STRING"
}
]
]
debug
Executing statement:
"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 = ?"
[
"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 => 89]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
"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_story AS is_story_12, t0_.is_marked_as_deleted AS is_marked_as_deleted_13, t0_.deleted_at AS deleted_at_14, t0_.classroom_id AS classroom_id_15, t0_.source_template_id AS source_template_id_16, t0_.step_id AS step_id_17, t0_.family_member_id AS family_member_id_18, t0_.student_id AS student_id_19, t0_.module_activation_id AS module_activation_id_20 FROM `troub_Challenge` t0_ LEFT JOIN `Classroom` c1_ ON t0_.classroom_id = c1_.id LEFT JOIN `troub_UserChallenge` t2_ ON t0_.id = t2_.challenge_id LEFT JOIN `User` u3_ ON t2_.student_id = u3_.id AND u3_.type IN ('ROLE_STUDENT') LEFT JOIN `ClassRegistration` c4_ ON u3_.id = c4_.student_id AND (c4_.classroom_id = c1_.id) WHERE c1_.manager_id = ? AND t0_.status = ? AND t0_.created_at < ? AND t0_.deleted_at IS NULL AND ((t2_.id IS NULL) OR (t2_.id IS NOT NULL AND (c4_.id IS NULL OR c4_.status NOT IN (?, ?))))"
[
"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_story AS is_story_12, t0_.is_marked_as_deleted AS is_marked_as_deleted_13, t0_.deleted_at AS deleted_at_14, t0_.classroom_id AS classroom_id_15, t0_.source_template_id AS source_template_id_16, t0_.step_id AS step_id_17, t0_.family_member_id AS family_member_id_18, t0_.student_id AS student_id_19, t0_.module_activation_id AS module_activation_id_20 FROM `troub_Challenge` t0_ LEFT JOIN `Classroom` c1_ ON t0_.classroom_id = c1_.id LEFT JOIN `troub_UserChallenge` t2_ ON t0_.id = t2_.challenge_id LEFT JOIN `User` u3_ ON t2_.student_id = u3_.id AND u3_.type IN ('ROLE_STUDENT') LEFT JOIN `ClassRegistration` c4_ ON u3_.id = c4_.student_id AND (c4_.classroom_id = c1_.id) WHERE c1_.manager_id = ? AND t0_.status = ? AND t0_.created_at < ? AND t0_.deleted_at IS NULL AND ((t2_.id IS NULL) OR (t2_.id IS NOT NULL AND (c4_.id IS NULL OR c4_.status NOT IN (?, ?))))"
"params" => [1 => 19502 => "CLOSE"
3 => "2025-09-17 21:27:57"
4 => "CONFIRMED"
5 => "PENDING"
]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
2 => Doctrine\DBAL\ParameterType {#2430
+name: "STRING"
}
3 => Doctrine\DBAL\ParameterType {#2430}
4 => Doctrine\DBAL\ParameterType {#2430}
5 => Doctrine\DBAL\ParameterType {#2430}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.status AS status_2, t0.product AS product_3, t0.step AS step_4, t0.completed_onboarding_paths AS completed_onboarding_paths_5, t0.completed_steps AS completed_steps_6, t0.user AS user_7, t0.manager_type AS manager_type_8 FROM `OnBoardingStatus` t0 WHERE t0.id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.product AS product_3, t0.step AS step_4, t0.completed_onboarding_paths AS completed_onboarding_paths_5, t0.completed_steps AS completed_steps_6, t0.user AS user_7, t0.manager_type AS manager_type_8 FROM `OnBoardingStatus` t0 WHERE t0.id = ?"
"params" => [1 => 236]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.previous_username AS previous_username_2, t0.new_username AS new_username_3, t0.is_valid AS is_valid_4, t0.date AS date_5, t0.is_marked_as_deleted AS is_marked_as_deleted_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM `UsernameChange` t0 WHERE t0.user_id = ?"
[
"sql" => "SELECT t0.id AS id_1, t0.previous_username AS previous_username_2, t0.new_username AS new_username_3, t0.is_valid AS is_valid_4, t0.date AS date_5, t0.is_marked_as_deleted AS is_marked_as_deleted_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM `UsernameChange` t0 WHERE t0.user_id = ?"
"params" => [1 => 1950]
"types" => [1 => Doctrine\DBAL\ParameterType {#2432
+name: "INTEGER"
}
]
]
debug
Executing statement:
"SELECT e0_.id AS id_0, e0_.timestamp AS timestamp_1, e0_.type AS type_2, e0_.data AS data_3, e0_.primary_user_id AS primary_user_id_4, e0_.secondary_user_id AS secondary_user_id_5 FROM event_log e0_ WHERE e0_.primary_user_id = ? AND e0_.type IN (?, ?) ORDER BY e0_.timestamp DESC LIMIT 2"