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 < '2024-12-18 10:57:59' AND m0_.ending_date > '2024-12-18 10:57:59' 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 < '2024-12-18 10:58:00' AND m0_.ending_date > '2024-12-18 10:58:00' AND m0_.is_completed = 0;

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

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

SELECT
  t0.id AS id_1,
  t0.plguser_state AS plguser_state_2,
  t0.plgusage_status AS plgusage_status_3,
  t0.plgonboarding_step AS plgonboarding_step_4,
  t0.job_title AS job_title_5,
  t0.organization_type AS organization_type_6,
  t0.province AS province_7,
  t0.landing_page_origin AS landing_page_origin_8,
  t0.is_decision_maker AS is_decision_maker_9,
  t0.is_troubadour_user AS is_troubadour_user_10,
  t0.subscription_pending AS subscription_pending_11,
  t0.subscriptions_used AS subscriptions_used_12,
  t0.has_valid_subscription AS has_valid_subscription_13,
  t0.is_freemium AS is_freemium_14,
  t0.is_school_user AS is_school_user_15,
  t0.is_family_user AS is_family_user_16,
  t0.is_dirty AS is_dirty_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.using_activation_code AS using_activation_code_20,
  t0.manager AS manager_21,
  t0.pending_account AS pending_account_22
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.plgonboarding_step AS plgonboarding_step_4, t0.job_title AS job_title_5, t0.organization_type AS organization_type_6, t0.province AS province_7, t0.landing_page_origin AS landing_page_origin_8, t0.is_decision_maker AS is_decision_maker_9, t0.is_troubadour_user AS is_troubadour_user_10, t0.subscription_pending AS subscription_pending_11, t0.subscriptions_used AS subscriptions_used_12, t0.has_valid_subscription AS has_valid_subscription_13, t0.is_freemium AS is_freemium_14, t0.is_school_user AS is_school_user_15, t0.is_family_user AS is_family_user_16, t0.is_dirty AS is_dirty_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.using_activation_code AS using_activation_code_20, t0.manager AS manager_21, t0.pending_account AS pending_account_22 FROM ZohoState t0 WHERE t0.manager = 89;

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 = 89 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 = ?
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 = 89 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE `ManagerStats` SET last_product_used = 'family.constellation.cool' WHERE id = 3;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.displayName AS displayName_3,
  t0.tag AS tag_4,
  t0.isActive AS isActive_5,
  t0.noun_sample AS noun_sample_6,
  t0.adjective_sample AS adjective_sample_7
FROM
  `Language` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.displayName AS displayName_3, t0.tag AS tag_4, t0.isActive AS isActive_5, t0.noun_sample AS noun_sample_6, t0.adjective_sample AS adjective_sample_7 FROM `Language` t0 WHERE t0.id = 15;

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

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

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  `User`
SET
  language_id = ?
WHERE
  id = ?

UPDATE `User` SET language_id = 14 WHERE id = 89;

"COMMIT"

"COMMIT";

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.isValidEmail AS isValidEmail_14,
  t0.firstName AS firstName_15,
  t0.lastName AS lastName_16,
  t0.schoolName AS schoolName_17,
  t0.schoolBoardName AS schoolBoardName_18,
  t0.isFromAnotherCountry AS isFromAnotherCountry_19,
  t0.isNanomonx AS isNanomonx_20,
  t0.newsletter AS newsletter_21,
  t0.free_trial_used AS free_trial_used_22,
  t0.stripe_customer_id AS stripe_customer_id_23,
  t0.is_evaluated_as_freemium AS is_evaluated_as_freemium_24,
  t0.country_id AS country_id_25,
  t0.onBoarding_status AS onBoarding_status_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,
  t31.id AS id_30,
  t31.plguser_state AS plguser_state_32,
  t31.plgusage_status AS plgusage_status_33,
  t31.plgonboarding_step AS plgonboarding_step_34,
  t31.job_title AS job_title_35,
  t31.organization_type AS organization_type_36,
  t31.province AS province_37,
  t31.landing_page_origin AS landing_page_origin_38,
  t31.is_decision_maker AS is_decision_maker_39,
  t31.is_troubadour_user AS is_troubadour_user_40,
  t31.subscription_pending AS subscription_pending_41,
  t31.subscriptions_used AS subscriptions_used_42,
  t31.has_valid_subscription AS has_valid_subscription_43,
  t31.is_freemium AS is_freemium_44,
  t31.is_school_user AS is_school_user_45,
  t31.is_family_user AS is_family_user_46,
  t31.is_dirty AS is_dirty_47,
  t31.created_at AS created_at_48,
  t31.updated_at AS updated_at_49,
  t31.using_activation_code AS using_activation_code_50,
  t31.manager AS manager_51,
  t31.pending_account AS pending_account_52,
  t0.educational_institution AS educational_institution_53,
  t0.language_id AS language_id_54,
  t0.type
FROM
  `User` t0
  LEFT JOIN ZohoState t31 ON t31.manager = t0.id
WHERE
  t0.id = ?
  AND t0.type IN ('ROLE_MANAGER')

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.isValidEmail AS isValidEmail_14, t0.firstName AS firstName_15, t0.lastName AS lastName_16, t0.schoolName AS schoolName_17, t0.schoolBoardName AS schoolBoardName_18, t0.isFromAnotherCountry AS isFromAnotherCountry_19, t0.isNanomonx AS isNanomonx_20, t0.newsletter AS newsletter_21, t0.free_trial_used AS free_trial_used_22, t0.stripe_customer_id AS stripe_customer_id_23, t0.is_evaluated_as_freemium AS is_evaluated_as_freemium_24, t0.country_id AS country_id_25, t0.onBoarding_status AS onBoarding_status_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, t31.id AS id_30, t31.plguser_state AS plguser_state_32, t31.plgusage_status AS plgusage_status_33, t31.plgonboarding_step AS plgonboarding_step_34, t31.job_title AS job_title_35, t31.organization_type AS organization_type_36, t31.province AS province_37, t31.landing_page_origin AS landing_page_origin_38, t31.is_decision_maker AS is_decision_maker_39, t31.is_troubadour_user AS is_troubadour_user_40, t31.subscription_pending AS subscription_pending_41, t31.subscriptions_used AS subscriptions_used_42, t31.has_valid_subscription AS has_valid_subscription_43, t31.is_freemium AS is_freemium_44, t31.is_school_user AS is_school_user_45, t31.is_family_user AS is_family_user_46, t31.is_dirty AS is_dirty_47, t31.created_at AS created_at_48, t31.updated_at AS updated_at_49, t31.using_activation_code AS using_activation_code_50, t31.manager AS manager_51, t31.pending_account AS pending_account_52, t0.educational_institution AS educational_institution_53, t0.language_id AS language_id_54, t0.type FROM `User` t0 LEFT JOIN ZohoState t31 ON t31.manager = t0.id WHERE t0.id = 89 AND t0.type IN ('ROLE_MANAGER');

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

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

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_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
FROM
  `troub_Challenge` t0
WHERE
  t0.family_member_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_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 FROM `troub_Challenge` t0 WHERE t0.family_member_id = 2;

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

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

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

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

SELECT
  DISTINCT t0_.id AS id_0
FROM
  `troub_Challenge` t1_
  INNER JOIN `troub_ChallengeTemplate` t0_ ON t1_.source_template_id = t0_.id
WHERE
  t1_.family_member_id = ?
  AND t1_.source_template_id IS NOT NULL

SELECT DISTINCT t0_.id AS id_0 FROM `troub_Challenge` t1_ INNER JOIN `troub_ChallengeTemplate` t0_ ON t1_.source_template_id = t0_.id WHERE t1_.family_member_id = 2 AND t1_.source_template_id IS NOT NULL;

SELECT
  f0_.id AS id_0,
  f0_.start_date AS start_date_1,
  f0_.end_date AS end_date_2,
  f0_.premium_only AS premium_only_3,
  f0_.name_translations AS name_translations_4,
  f0_.description_translations AS description_translations_5,
  f0_.instructions_translations AS instructions_translations_6,
  f0_.is_marked_as_deleted AS is_marked_as_deleted_7,
  f0_.deleted_at AS deleted_at_8
FROM
  `fmly_StoryTemplate` f0_
  INNER JOIN `troub_ChallengeTemplate` t1_ ON f0_.id = t1_.story_template_id
WHERE
  (
    f0_.start_date < ?
    OR f0_.start_date IS NULL
  )
  AND (
    f0_.end_date >= ?
    OR f0_.end_date IS NULL
  )
ORDER BY
  f0_.end_date ASC

SELECT f0_.id AS id_0, f0_.start_date AS start_date_1, f0_.end_date AS end_date_2, f0_.premium_only AS premium_only_3, f0_.name_translations AS name_translations_4, f0_.description_translations AS description_translations_5, f0_.instructions_translations AS instructions_translations_6, f0_.is_marked_as_deleted AS is_marked_as_deleted_7, f0_.deleted_at AS deleted_at_8 FROM `fmly_StoryTemplate` f0_ INNER JOIN `troub_ChallengeTemplate` t1_ ON f0_.id = t1_.story_template_id WHERE (f0_.start_date < '2024-12-18 10:58:01' OR f0_.start_date IS NULL) AND (f0_.end_date >= '2024-12-18 10:58:01' OR f0_.end_date IS NULL) ORDER BY f0_.end_date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.is_reading_challenge AS is_reading_challenge_4,
  t0.educational_intent AS educational_intent_5,
  t0.student_instructions AS student_instructions_6,
  t0.expected_duration AS expected_duration_7,
  t0.note_for_teacher AS note_for_teacher_8,
  t0.images AS images_9,
  t0.disabled AS disabled_10,
  t0.is_highlighted AS is_highlighted_11,
  t0.historical AS historical_12,
  t0.starting_blocks AS starting_blocks_13,
  t0.conclusion AS conclusion_14,
  t0.is_marked_as_deleted AS is_marked_as_deleted_15,
  t0.deleted_at AS deleted_at_16,
  t0.language_id AS language_id_17,
  t0.studied_language_id AS studied_language_id_18,
  t0.story_template_id AS story_template_id_19
FROM
  `troub_ChallengeTemplate` t0
WHERE
  t0.story_template_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_reading_challenge AS is_reading_challenge_4, t0.educational_intent AS educational_intent_5, t0.student_instructions AS student_instructions_6, t0.expected_duration AS expected_duration_7, t0.note_for_teacher AS note_for_teacher_8, t0.images AS images_9, t0.disabled AS disabled_10, t0.is_highlighted AS is_highlighted_11, t0.historical AS historical_12, t0.starting_blocks AS starting_blocks_13, t0.conclusion AS conclusion_14, t0.is_marked_as_deleted AS is_marked_as_deleted_15, t0.deleted_at AS deleted_at_16, t0.language_id AS language_id_17, t0.studied_language_id AS studied_language_id_18, t0.story_template_id AS story_template_id_19 FROM `troub_ChallengeTemplate` t0 WHERE t0.story_template_id = 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 troub_challengeTemplate_category ON t0.id = troub_challengeTemplate_category.challenge_template_id
WHERE
  troub_challengeTemplate_category.category_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 troub_challengeTemplate_category ON t0.id = troub_challengeTemplate_category.challenge_template_id WHERE troub_challengeTemplate_category.category_id = 7;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO `troub_Challenge` (
  name, description, student_instructions,
  historical, status, premium_status,
  is_highlighted, starting_blocks,
  conclusion, created_at, updated_at,
  is_marked_as_deleted, deleted_at,
  classroom_id, source_template_id,
  step_id, family_member_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO `troub_Challenge` (name, description, student_instructions, historical, status, premium_status, is_highlighted, starting_blocks, conclusion, created_at, updated_at, is_marked_as_deleted, deleted_at, classroom_id, source_template_id, step_id, family_member_id) VALUES ('Family Template', 'Family Template', NULL, 0, 'CLOSE', NULL, 0, NULL, 0, '2024-12-18 10:58:01', '2024-12-18 10:58:01', 0, NULL, NULL, 7, NULL, 2);