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-04 16:55:47' AND m0_.ending_date > '2025-07-04 16:55:47' 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-04 16:55:47' AND m0_.ending_date > '2025-07-04 16:55:47' AND m0_.is_completed = 0;

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

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

SELECT
  u0_.id AS id_0,
  u0_.displayName AS displayName_1,
  u0_.username AS username_2,
  u0_.password AS password_3,
  u0_.salt AS salt_4,
  u0_.created_at AS created_at_5,
  u0_.last_active AS last_active_6,
  u0_.data AS data_7,
  u0_.google_id AS google_id_8,
  u0_.`character` AS character_9,
  u0_.version AS version_10,
  u0_.anonymized_at AS anonymized_at_11,
  u0_.anonymization_status AS anonymization_status_12,
  u0_.isValidEmail AS isValidEmail_13,
  u0_.firstName AS firstName_14,
  u0_.lastName AS lastName_15,
  u0_.schoolName AS schoolName_16,
  u0_.schoolBoardName AS schoolBoardName_17,
  u0_.isFromAnotherCountry AS isFromAnotherCountry_18,
  u0_.isNanomonx AS isNanomonx_19,
  u0_.newsletter AS newsletter_20,
  u0_.free_trial_used AS free_trial_used_21,
  u0_.stripe_customer_id AS stripe_customer_id_22,
  u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23,
  u0_.linked_email AS linked_email_24,
  u0_.type AS type_25,
  u0_.country_id AS country_id_26,
  u0_.onBoarding_status AS onBoarding_status_27,
  u0_.educatonal_pathway_id AS educatonal_pathway_id_28,
  u0_.usage_type_id AS usage_type_id_29,
  u0_.user_region_id AS user_region_id_30,
  u0_.educational_institution AS educational_institution_31,
  u0_.language_id AS language_id_32,
  u0_.language_id AS language_id_33
FROM
  `User` u0_
WHERE
  (
    u0_.id IN (?)
  )
  AND u0_.type IN (
    'ROLE_MANAGER', 'ROLE_STUDENT', 'ROLE_SUPPORT_GUY',
    'ROLE_SUPPORT_LANG'
  )

SELECT u0_.id AS id_0, u0_.displayName AS displayName_1, u0_.username AS username_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.created_at AS created_at_5, u0_.last_active AS last_active_6, u0_.data AS data_7, u0_.google_id AS google_id_8, u0_.`character` AS character_9, u0_.version AS version_10, u0_.anonymized_at AS anonymized_at_11, u0_.anonymization_status AS anonymization_status_12, u0_.isValidEmail AS isValidEmail_13, u0_.firstName AS firstName_14, u0_.lastName AS lastName_15, u0_.schoolName AS schoolName_16, u0_.schoolBoardName AS schoolBoardName_17, u0_.isFromAnotherCountry AS isFromAnotherCountry_18, u0_.isNanomonx AS isNanomonx_19, u0_.newsletter AS newsletter_20, u0_.free_trial_used AS free_trial_used_21, u0_.stripe_customer_id AS stripe_customer_id_22, u0_.is_evaluated_as_freemium AS is_evaluated_as_freemium_23, u0_.linked_email AS linked_email_24, u0_.type AS type_25, u0_.country_id AS country_id_26, u0_.onBoarding_status AS onBoarding_status_27, u0_.educatonal_pathway_id AS educatonal_pathway_id_28, u0_.usage_type_id AS usage_type_id_29, u0_.user_region_id AS user_region_id_30, u0_.educational_institution AS educational_institution_31, u0_.language_id AS language_id_32, u0_.language_id AS language_id_33 FROM `User` u0_ WHERE (u0_.id IN (1969)) AND u0_.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 = 1969;

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