Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.is_active AS is_active_2,
  t0_.is_default AS is_default_3,
  t0_.page_background_color AS page_background_color_4,
  t0_.page_title_color AS page_title_color_5,
  t0_.board_background_color AS board_background_color_6,
  t0_.board_border_color AS board_border_color_7,
  t0_.board_title_color AS board_title_color_8,
  t0_.board_texture AS board_texture_9,
  t0_.vignettes AS vignettes_10,
  t0_.top_left_image AS top_left_image_11,
  t0_.top_right_image AS top_right_image_12,
  t0_.bottom_right_image AS bottom_right_image_13,
  t0_.bottom_left_image AS bottom_left_image_14,
  t0_.scrollbar_track AS scrollbar_track_15,
  t0_.scrollbar_thumb AS scrollbar_thumb_16,
  t0_.thumbnail AS thumbnail_17,
  t0_.version AS version_18
FROM
  `troub_BabillardTheme` t0_
WHERE
  t0_.is_active = ?

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.is_active AS is_active_2, t0_.is_default AS is_default_3, t0_.page_background_color AS page_background_color_4, t0_.page_title_color AS page_title_color_5, t0_.board_background_color AS board_background_color_6, t0_.board_border_color AS board_border_color_7, t0_.board_title_color AS board_title_color_8, t0_.board_texture AS board_texture_9, t0_.vignettes AS vignettes_10, t0_.top_left_image AS top_left_image_11, t0_.top_right_image AS top_right_image_12, t0_.bottom_right_image AS bottom_right_image_13, t0_.bottom_left_image AS bottom_left_image_14, t0_.scrollbar_track AS scrollbar_track_15, t0_.scrollbar_thumb AS scrollbar_thumb_16, t0_.thumbnail AS thumbnail_17, t0_.version AS version_18 FROM `troub_BabillardTheme` t0_ WHERE t0_.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.teacherComment AS teacherComment_3,
  t0.date AS date_4,
  t0.is_marked_as_deleted AS is_marked_as_deleted_5,
  t0.deleted_at AS deleted_at_6,
  t0.textEntryId AS textEntryId_7,
  t0.userID AS userID_8
FROM
  `troub_Revision` t0
WHERE
  t0.textEntryId = ?
ORDER BY
  t0.date ASC

SELECT t0.id AS id_1, t0.text AS text_2, t0.teacherComment AS teacherComment_3, t0.date AS date_4, t0.is_marked_as_deleted AS is_marked_as_deleted_5, t0.deleted_at AS deleted_at_6, t0.textEntryId AS textEntryId_7, t0.userID AS userID_8 FROM `troub_Revision` t0 WHERE t0.textEntryId = 2862 ORDER BY t0.date ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_marked_as_deleted AS is_marked_as_deleted_3,
  t0.deleted_at AS deleted_at_4,
  t0.status AS status_5,
  t0.work_block_id AS work_block_id_6,
  t0.type,
  t0.world_object_id AS world_object_id_7
FROM
  `troub_TextEntry` t0
WHERE
  t0.work_block_id = ?
  AND t0.type IN (
    'TYPE_NARRATION', 'TYPE_ASSET', 'TYPE_TITLE'
  )

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.status AS status_5, t0.work_block_id AS work_block_id_6, t0.type, t0.world_object_id AS world_object_id_7 FROM `troub_TextEntry` t0 WHERE t0.work_block_id = 1766 AND t0.type IN ('TYPE_NARRATION', 'TYPE_ASSET', 'TYPE_TITLE');

"COMMIT"

"COMMIT";

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;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_marked_as_deleted AS is_marked_as_deleted_3,
  t0.deleted_at AS deleted_at_4,
  t0.userChallenge_id AS userChallenge_id_5,
  t6.id AS id_7,
  t6.position AS position_8,
  t6.is_marked_as_deleted AS is_marked_as_deleted_9,
  t6.deleted_at AS deleted_at_10,
  t6.work_block_id AS work_block_id_11,
  t6.background_id AS background_id_12,
  t6.floor_id AS floor_id_13,
  t6.foreground_id AS foreground_id_14,
  t6.back_color_id AS back_color_id_15
FROM
  `troub_WorkBlock` t0
  LEFT JOIN `troub_World` t6 ON t6.work_block_id = t0.id
WHERE
  t0.userChallenge_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_marked_as_deleted AS is_marked_as_deleted_3, t0.deleted_at AS deleted_at_4, t0.userChallenge_id AS userChallenge_id_5, t6.id AS id_7, t6.position AS position_8, t6.is_marked_as_deleted AS is_marked_as_deleted_9, t6.deleted_at AS deleted_at_10, t6.work_block_id AS work_block_id_11, t6.background_id AS background_id_12, t6.floor_id AS floor_id_13, t6.foreground_id AS foreground_id_14, t6.back_color_id AS back_color_id_15 FROM `troub_WorkBlock` t0 LEFT JOIN `troub_World` t6 ON t6.work_block_id = t0.id WHERE t0.userChallenge_id = 512 ORDER BY t0.position ASC;

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
  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.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
  INNER JOIN babillard_userChallenge ON t0.id = babillard_userChallenge.user_challenge_id
WHERE
  babillard_userChallenge.babillard_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 INNER JOIN babillard_userChallenge ON t0.id = babillard_userChallenge.user_challenge_id WHERE babillard_userChallenge.babillard_id = 69;

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
  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.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.id = 641;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_shared AS is_shared_3,
  t0.is_marked_as_deleted AS is_marked_as_deleted_4,
  t0.deleted_at AS deleted_at_5,
  t0.manager_id AS manager_id_6,
  t0.theme_id AS theme_id_7,
  t8.id AS id_9,
  t8.name AS name_10,
  t8.code AS code_11,
  t8.type AS type_12,
  t8.has_seen_guided_tutorial AS has_seen_guided_tutorial_13,
  t8.is_marked_as_deleted AS is_marked_as_deleted_14,
  t8.deleted_at AS deleted_at_15,
  t8.family_id AS family_id_16,
  t8.babillard_id AS babillard_id_17
FROM
  `troub_Babillard` t0
  LEFT JOIN `FamilyMember` t8 ON t8.babillard_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_shared AS is_shared_3, t0.is_marked_as_deleted AS is_marked_as_deleted_4, t0.deleted_at AS deleted_at_5, t0.manager_id AS manager_id_6, t0.theme_id AS theme_id_7, t8.id AS id_9, t8.name AS name_10, t8.code AS code_11, t8.type AS type_12, t8.has_seen_guided_tutorial AS has_seen_guided_tutorial_13, t8.is_marked_as_deleted AS is_marked_as_deleted_14, t8.deleted_at AS deleted_at_15, t8.family_id AS family_id_16, t8.babillard_id AS babillard_id_17 FROM `troub_Babillard` t0 LEFT JOIN `FamilyMember` t8 ON t8.babillard_id = t0.id WHERE t0.id = 69;

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

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
  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
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.rules AS rules_2,
  c0_.access_code AS access_code_3,
  c0_.allow_public_access AS allow_public_access_4,
  c0_.google_course_id AS google_course_id_5,
  c0_.created_at AS created_at_6,
  c0_.is_marked_as_deleted AS is_marked_as_deleted_7,
  c0_.deleted_at AS deleted_at_8
FROM
  `Classroom` c0_
WHERE
  c0_.manager_id = ?
  AND c0_.is_marked_as_deleted = 0

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.rules AS rules_2, c0_.access_code AS access_code_3, c0_.allow_public_access AS allow_public_access_4, c0_.google_course_id AS google_course_id_5, c0_.created_at AS created_at_6, c0_.is_marked_as_deleted AS is_marked_as_deleted_7, c0_.deleted_at AS deleted_at_8 FROM `Classroom` c0_ WHERE c0_.manager_id = 89 AND c0_.is_marked_as_deleted = 0;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.targets AS targets_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.color AS color_5,
  c0_.image AS image_6,
  c0_.with_button AS with_button_7,
  c0_.button_label AS button_label_8,
  c0_.button_url AS button_url_9,
  c0_.text_size AS text_size_10,
  c0_.title AS title_11,
  c0_.content AS content_12,
  c0_.language_id AS language_id_13
FROM
  `CommunicationPopup` c0_
WHERE
  (
    c0_.start_date < ?
    OR c0_.start_date IS NULL
  )
  AND (
    c0_.end_date >= ?
    OR c0_.end_date IS NULL
  )
  AND c0_.language_id = ?
ORDER BY
  c0_.end_date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.targets AS targets_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.color AS color_5, c0_.image AS image_6, c0_.with_button AS with_button_7, c0_.button_label AS button_label_8, c0_.button_url AS button_url_9, c0_.text_size AS text_size_10, c0_.title AS title_11, c0_.content AS content_12, c0_.language_id AS language_id_13 FROM `CommunicationPopup` c0_ WHERE (c0_.start_date < '2024-12-18 10:58:01' OR c0_.start_date IS NULL) AND (c0_.end_date >= '2024-12-18 10:58:01' OR c0_.end_date IS NULL) AND c0_.language_id = 14 ORDER BY c0_.end_date ASC;

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.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.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.family_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.family_id = 1;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.stripe_price_id AS stripe_price_id_2,
  t0.price AS price_3,
  t0.seats AS seats_4,
  t0.is_default_price AS is_default_price_5,
  t0.payment_interval AS payment_interval_6,
  t0.package_id AS package_id_7,
  t0.country_id AS country_id_8
FROM
  `Price` t0
WHERE
  t0.package_id = ?

SELECT t0.id AS id_1, t0.stripe_price_id AS stripe_price_id_2, t0.price AS price_3, t0.seats AS seats_4, t0.is_default_price AS is_default_price_5, t0.payment_interval AS payment_interval_6, t0.package_id AS package_id_7, t0.country_id AS country_id_8 FROM `Price` t0 WHERE t0.package_id = 4;

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