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-07-27 14:25:54' AND m0_.ending_date > '2025-07-27 14:25: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-07-27 14:25:54' AND m0_.ending_date > '2025-07-27 14:25: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_.type AS type_24,
  u0_.country_id AS country_id_25,
  u0_.onBoarding_status AS onBoarding_status_26,
  u0_.educatonal_pathway_id AS educatonal_pathway_id_27,
  u0_.usage_type_id AS usage_type_id_28,
  u0_.user_region_id AS user_region_id_29,
  u0_.educational_institution AS educational_institution_30,
  u0_.language_id AS language_id_31
FROM
  `User` u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN ('ROLE_MANAGER')
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_.type AS type_24, u0_.country_id AS country_id_25, u0_.onBoarding_status AS onBoarding_status_26, u0_.educatonal_pathway_id AS educatonal_pathway_id_27, u0_.usage_type_id AS usage_type_id_28, u0_.user_region_id AS user_region_id_29, u0_.educational_institution AS educational_institution_30, u0_.language_id AS language_id_31 FROM `User` u0_ WHERE (u0_.username = 'Demo_Teacher_User_en-CA') AND u0_.type IN ('ROLE_MANAGER') 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 = 1440;

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_.linked_email AS linked_email_13,
  u0_.type AS type_14,
  u0_.country_id AS country_id_15,
  u0_.onBoarding_status AS onBoarding_status_16,
  u0_.language_id AS language_id_17
FROM
  `User` u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN ('ROLE_STUDENT')
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_.linked_email AS linked_email_13, u0_.type AS type_14, u0_.country_id AS country_id_15, u0_.onBoarding_status AS onBoarding_status_16, u0_.language_id AS language_id_17 FROM `User` u0_ WHERE (u0_.username = 'Demo_Student_User_en-CA') AND u0_.type IN ('ROLE_STUDENT') 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.student_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.student_id = 1910;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rules AS rules_3,
  t0.access_code AS access_code_4,
  t0.allow_public_access AS allow_public_access_5,
  t0.skip_until_school_year AS skip_until_school_year_6,
  t0.google_course_id AS google_course_id_7,
  t0.created_at AS created_at_8,
  t0.is_marked_as_deleted AS is_marked_as_deleted_9,
  t0.deleted_at AS deleted_at_10,
  t0.language_id AS language_id_11,
  t0.manager_id AS manager_id_12,
  t0.grade_level_id AS grade_level_id_13
FROM
  `Classroom` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rules AS rules_3, t0.access_code AS access_code_4, t0.allow_public_access AS allow_public_access_5, t0.skip_until_school_year AS skip_until_school_year_6, t0.google_course_id AS google_course_id_7, t0.created_at AS created_at_8, t0.is_marked_as_deleted AS is_marked_as_deleted_9, t0.deleted_at AS deleted_at_10, t0.language_id AS language_id_11, t0.manager_id AS manager_id_12, t0.grade_level_id AS grade_level_id_13 FROM `Classroom` t0 WHERE t0.id = 521;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.student_instructions AS student_instructions_4,
  t0.historical AS historical_5,
  t0.status AS status_6,
  t0.premium_status AS premium_status_7,
  t0.is_highlighted AS is_highlighted_8,
  t0.starting_blocks AS starting_blocks_9,
  t0.conclusion AS conclusion_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.is_story AS is_story_13,
  t0.is_marked_as_deleted AS is_marked_as_deleted_14,
  t0.deleted_at AS deleted_at_15,
  t0.classroom_id AS classroom_id_16,
  t0.source_template_id AS source_template_id_17,
  t0.step_id AS step_id_18,
  t0.family_member_id AS family_member_id_19
FROM
  `troub_Challenge` t0
WHERE
  t0.classroom_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.student_instructions AS student_instructions_4, t0.historical AS historical_5, t0.status AS status_6, t0.premium_status AS premium_status_7, t0.is_highlighted AS is_highlighted_8, t0.starting_blocks AS starting_blocks_9, t0.conclusion AS conclusion_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.is_story AS is_story_13, t0.is_marked_as_deleted AS is_marked_as_deleted_14, t0.deleted_at AS deleted_at_15, t0.classroom_id AS classroom_id_16, t0.source_template_id AS source_template_id_17, t0.step_id AS step_id_18, t0.family_member_id AS family_member_id_19 FROM `troub_Challenge` t0 WHERE t0.classroom_id = 521;

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_.type AS type_24,
  u0_.country_id AS country_id_25,
  u0_.onBoarding_status AS onBoarding_status_26,
  u0_.educatonal_pathway_id AS educatonal_pathway_id_27,
  u0_.usage_type_id AS usage_type_id_28,
  u0_.user_region_id AS user_region_id_29,
  u0_.educational_institution AS educational_institution_30,
  u0_.language_id AS language_id_31
FROM
  `User` u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN ('ROLE_MANAGER')
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_.type AS type_24, u0_.country_id AS country_id_25, u0_.onBoarding_status AS onBoarding_status_26, u0_.educatonal_pathway_id AS educatonal_pathway_id_27, u0_.usage_type_id AS usage_type_id_28, u0_.user_region_id AS user_region_id_29, u0_.educational_institution AS educational_institution_30, u0_.language_id AS language_id_31 FROM `User` u0_ WHERE (u0_.username = 'Demo_Teacher_User_en-CA') AND u0_.type IN ('ROLE_MANAGER') 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_.linked_email AS linked_email_13,
  u0_.type AS type_14,
  u0_.country_id AS country_id_15,
  u0_.onBoarding_status AS onBoarding_status_16,
  u0_.language_id AS language_id_17
FROM
  `User` u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN ('ROLE_STUDENT')
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_.linked_email AS linked_email_13, u0_.type AS type_14, u0_.country_id AS country_id_15, u0_.onBoarding_status AS onBoarding_status_16, u0_.language_id AS language_id_17 FROM `User` u0_ WHERE (u0_.username = 'Demo_Student_User_en-CA') AND u0_.type IN ('ROLE_STUDENT') LIMIT 1;

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_
WHERE
  t0_.student_id = ?
  AND t0_.challenge_id = ?
  AND t0_.is_marked_as_deleted = 0
LIMIT
  1

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_ WHERE t0_.student_id = 1910 AND t0_.challenge_id = 536 AND t0_.is_marked_as_deleted = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.type AS type_4,
  t0.has_seen_guided_tutorial AS has_seen_guided_tutorial_5,
  t0.is_marked_as_deleted AS is_marked_as_deleted_6,
  t0.deleted_at AS deleted_at_7,
  t0.family_id AS family_id_8,
  t0.babillard_id AS babillard_id_9
FROM
  `FamilyMember` t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.type AS type_4, t0.has_seen_guided_tutorial AS has_seen_guided_tutorial_5, t0.is_marked_as_deleted AS is_marked_as_deleted_6, t0.deleted_at AS deleted_at_7, t0.family_id AS family_id_8, t0.babillard_id AS babillard_id_9 FROM `FamilyMember` t0 WHERE t0.id IN (56);

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.expired_at AS expired_at_3,
  t0.free_trial_duration AS free_trial_duration_4,
  t0.buyer_id AS buyer_id_5,
  t0.owner_id AS owner_id_6,
  t0.current_user_id AS current_user_id_7,
  t0.type_id AS type_id_8
FROM
  `GroupLicence` t0
WHERE
  t0.current_user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.expired_at AS expired_at_3, t0.free_trial_duration AS free_trial_duration_4, t0.buyer_id AS buyer_id_5, t0.owner_id AS owner_id_6, t0.current_user_id AS current_user_id_7, t0.type_id AS type_id_8 FROM `GroupLicence` t0 WHERE t0.current_user_id = 1440;

SELECT
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.owner_id AS owner_id_8,
  t0.current_user_id AS current_user_id_9,
  t0.discr,
  t1.granted_seats AS granted_seats_10,
  t1.grants_family_mode_access AS grants_family_mode_access_11,
  t1.expiry_date AS expiry_date_12,
  t2.type_id AS type_id_13,
  t2.buyer_id AS buyer_id_14,
  t2.country_id AS country_id_15,
  t3.expiry_date AS expiry_date_16,
  t4.stripe_subscription_id AS stripe_subscription_id_17,
  t4.stripe_subscription_status AS stripe_subscription_status_18,
  t4.canceled_at AS canceled_at_19,
  t4.type_id AS type_id_20,
  t4.buyer_id AS buyer_id_21,
  t4.country_id AS country_id_22
FROM
  Subscription_Base t0
  LEFT JOIN Subscription_Custom t1 ON t0.id = t1.id
  LEFT JOIN Subscription_Package t2 ON t0.id = t2.id
  LEFT JOIN Subscription_FreeTrial t3 ON t0.id = t3.id
  LEFT JOIN Subscription_Recurring t4 ON t0.id = t4.id
WHERE
  t0.current_user_id = ?

SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.owner_id AS owner_id_8, t0.current_user_id AS current_user_id_9, t0.discr, t1.granted_seats AS granted_seats_10, t1.grants_family_mode_access AS grants_family_mode_access_11, t1.expiry_date AS expiry_date_12, t2.type_id AS type_id_13, t2.buyer_id AS buyer_id_14, t2.country_id AS country_id_15, t3.expiry_date AS expiry_date_16, t4.stripe_subscription_id AS stripe_subscription_id_17, t4.stripe_subscription_status AS stripe_subscription_status_18, t4.canceled_at AS canceled_at_19, t4.type_id AS type_id_20, t4.buyer_id AS buyer_id_21, t4.country_id AS country_id_22 FROM Subscription_Base t0 LEFT JOIN Subscription_Custom t1 ON t0.id = t1.id LEFT JOIN Subscription_Package t2 ON t0.id = t2.id LEFT JOIN Subscription_FreeTrial t3 ON t0.id = t3.id LEFT JOIN Subscription_Recurring t4 ON t0.id = t4.id WHERE t0.current_user_id = 1440;

SELECT
  m0_.id AS id_0,
  m0_.lastChallengeSubmitted AS lastChallengeSubmitted_1,
  m0_.lastUserChallengeParticipation AS lastUserChallengeParticipation_2,
  m0_.last_challenge_created AS last_challenge_created_3,
  m0_.last_user_challenge_review AS last_user_challenge_review_4,
  m0_.last_product_used AS last_product_used_5,
  m0_.manager_id AS manager_id_6
FROM
  `ManagerStats` m0_
WHERE
  m0_.manager_id = ?
LIMIT
  1

SELECT m0_.id AS id_0, m0_.lastChallengeSubmitted AS lastChallengeSubmitted_1, m0_.lastUserChallengeParticipation AS lastUserChallengeParticipation_2, m0_.last_challenge_created AS last_challenge_created_3, m0_.last_user_challenge_review AS last_user_challenge_review_4, m0_.last_product_used AS last_product_used_5, m0_.manager_id AS manager_id_6 FROM `ManagerStats` m0_ WHERE m0_.manager_id = 1440 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  `ManagerStats`
SET
  lastUserChallengeParticipation = ?
WHERE
  id = ?

UPDATE `ManagerStats` SET lastUserChallengeParticipation = '2025-07-27 14:25:54' WHERE id = 38;

"COMMIT"

"COMMIT";

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.created_at AS created_at_2,
  f0_.is_marked_as_group AS is_marked_as_group_3,
  f0_.manager_id AS manager_id_4,
  f0_.active_member_id AS active_member_id_5
FROM
  `Family` f0_
WHERE
  f0_.manager_id IS NULL
LIMIT
  1

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.created_at AS created_at_2, f0_.is_marked_as_group AS is_marked_as_group_3, f0_.manager_id AS manager_id_4, f0_.active_member_id AS active_member_id_5 FROM `Family` f0_ WHERE f0_.manager_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.texture_key AS texture_key_2,
  t0.display_name AS display_name_3,
  t0.translations AS translations_4,
  t0.atlas_json AS atlas_json_5,
  t0.historical AS historical_6,
  t0.icon AS icon_7,
  t0.is_hidden AS is_hidden_8,
  t0.atlas_image AS atlas_image_9,
  t0.version AS version_10
FROM
  `troub_Category` t0
  INNER JOIN challenge_category ON t0.id = challenge_category.category_id
WHERE
  challenge_category.challenge_id = ?

SELECT t0.id AS id_1, t0.texture_key AS texture_key_2, t0.display_name AS display_name_3, t0.translations AS translations_4, t0.atlas_json AS atlas_json_5, t0.historical AS historical_6, t0.icon AS icon_7, t0.is_hidden AS is_hidden_8, t0.atlas_image AS atlas_image_9, t0.version AS version_10 FROM `troub_Category` t0 INNER JOIN challenge_category ON t0.id = challenge_category.category_id WHERE challenge_category.challenge_id = 536;

SELECT
  t0_.id AS id_0,
  t0_.sprite AS sprite_1,
  t0_.icon AS icon_2,
  t0_.is_default AS is_default_3,
  t0_.version AS version_4,
  t0_.is_marked_as_deleted AS is_marked_as_deleted_5,
  t0_.deleted_at AS deleted_at_6
FROM
  `troub_Floor` t0_
  LEFT JOIN category_floor c2_ ON t0_.id = c2_.floor_id
  LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id
WHERE
  t1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND t0_.is_marked_as_deleted = 0

SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Floor` t0_ LEFT JOIN category_floor c2_ ON t0_.id = c2_.floor_id LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id WHERE t1_.id IN (84, 87, 88, 89, 91, 92, 94, 95, 96, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 124, 125, 127, 128, 129, 131, 137, 139, 147) AND t0_.is_marked_as_deleted = 0;

SELECT
  t0_.id AS id_0,
  t0_.sprite AS sprite_1,
  t0_.icon AS icon_2,
  t0_.is_default AS is_default_3,
  t0_.version AS version_4,
  t0_.is_marked_as_deleted AS is_marked_as_deleted_5,
  t0_.deleted_at AS deleted_at_6
FROM
  `troub_Foreground` t0_
  LEFT JOIN category_foreground c2_ ON t0_.id = c2_.foreground_id
  LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id
WHERE
  t1_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND t0_.is_marked_as_deleted = 0

SELECT t0_.id AS id_0, t0_.sprite AS sprite_1, t0_.icon AS icon_2, t0_.is_default AS is_default_3, t0_.version AS version_4, t0_.is_marked_as_deleted AS is_marked_as_deleted_5, t0_.deleted_at AS deleted_at_6 FROM `troub_Foreground` t0_ LEFT JOIN category_foreground c2_ ON t0_.id = c2_.foreground_id LEFT JOIN `troub_Category` t1_ ON t1_.id = c2_.category_id WHERE t1_.id IN (84, 87, 88, 89, 91, 92, 94, 95, 96, 98, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 121, 122, 124, 125, 127, 128, 129, 131, 137, 139, 147) AND t0_.is_marked_as_deleted = 0;