Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Redis
• Configuration

Query Metrics

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_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 TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

[
  "nano_ca_dev_merged"
]

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_ WHERE m0_.starting_date < ? AND m0_.ending_date > ? AND m0_.is_completed = 0

[
  "2024-12-18 12:37:46"
  "2024-12-18 12:37:46"
]

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 12:37:46' AND m0_.ending_date > '2024-12-18 12:37:46' AND m0_.is_completed = 0;

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

[
  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_.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_;

SELECT DATABASE()

[]

SELECT
  DATABASE()

SELECT DATABASE();

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