Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.`content` AS content_1,
  t0_.lastTranslationUpdate AS lastTranslationUpdate_2,
  t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3,
  t0_.lastTranslationPageToken AS lastTranslationPageToken_4,
  t0_.firstTranslationUpdate AS firstTranslationUpdate_5
FROM
  `TranslationFile` t0_
ORDER BY
  t0_.id DESC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.`content` AS content_1, t0_.lastTranslationUpdate AS lastTranslationUpdate_2, t0_.lastTranslationPageAccess AS lastTranslationPageAccess_3, t0_.lastTranslationPageToken AS lastTranslationPageToken_4, t0_.firstTranslationUpdate AS firstTranslationUpdate_5 FROM `TranslationFile` t0_ ORDER BY t0_.id DESC LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-17 16:27:54' AND m0_.ending_date > '2025-12-17 16:27:54' AND m0_.is_completed = 0;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'nano_ca_dev_merged'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_;

SELECT
  m0_.id AS id_0,
  m0_.starting_date AS starting_date_1,
  m0_.ending_date AS ending_date_2,
  m0_.is_completed AS is_completed_3
FROM
  `Maintenance` m0_
WHERE
  m0_.starting_date < ?
  AND m0_.ending_date > ?
  AND m0_.is_completed = 0

SELECT m0_.id AS id_0, m0_.starting_date AS starting_date_1, m0_.ending_date AS ending_date_2, m0_.is_completed AS is_completed_3 FROM `Maintenance` m0_ WHERE m0_.starting_date < '2025-12-17 16:27:54' AND m0_.ending_date > '2025-12-17 16:27:54' AND m0_.is_completed = 0;

SELECT
  l0_.id AS id_0,
  l0_.language AS language_1,
  l0_.displayName AS displayName_2,
  l0_.tag AS tag_3,
  l0_.isActive AS isActive_4,
  l0_.noun_sample AS noun_sample_5,
  l0_.adjective_sample AS adjective_sample_6
FROM
  `Language` l0_
WHERE
  l0_.isActive = ?

SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.displayName AS displayName_2, l0_.tag AS tag_3, l0_.isActive AS isActive_4, l0_.noun_sample AS noun_sample_5, l0_.adjective_sample AS adjective_sample_6 FROM `Language` l0_ WHERE l0_.isActive = 1;

SELECT
  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

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 = 'alex.gray@nanomonx.com') AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1;

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 = ?

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 = 1950;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO event_log (
  timestamp, type, data, primary_user_id,
  secondary_user_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO event_log (timestamp, type, data, primary_user_id, secondary_user_id) VALUES ('2025-12-17 21:27:56', 'login', '{\"login_method\":\"website - google\"}', 1950, NULL);

"COMMIT"

"COMMIT";

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

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 = 1950 AND c0_.is_marked_as_deleted = 0;

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 = ?

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 = 1950;

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')

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 = 153 AND t0.type IN ('redeem', 'gift');

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')

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 = 169 AND t0.type IN ('redeem', 'gift');

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')

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 = 170 AND t0.type IN ('redeem', 'gift');

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

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 = 1950 AND c0_.is_marked_as_deleted = 0;

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

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 = 1 AND t0_.is_marked_as_deleted = 0;

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 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 (536, 537) AND t2_.id IN (1, 2);

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

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 = '106792430983192295350' LIMIT 1;

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 = ?

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 = 536;

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'
  )

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 (1680, 2274) AND t0.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG');

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

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 = 'quentin.debest@nanomonx.com') AND u0_.type IN ('ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY', 'ROLE_SUPPORT_LANG') LIMIT 1;

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 = ?

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 = 89;

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 (?, ?)
      )
    )
  )

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 = 1950 AND t0_.status = 'CLOSE' AND t0_.created_at < '2025-09-17 21:27:57' 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 ('CONFIRMED', 'PENDING'))));