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-04-03 16:08:24' AND m0_.ending_date > '2025-04-03 16:08:24' 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-04-03 16:08:24' AND m0_.ending_date > '2025-04-03 16:08:24' 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
  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.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
  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
  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;