Symfony Profiler

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

Query Metrics

SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = ? ORDER BY i0_.cat_creation_date DESC

[
  417
]

SELECT
  i0_.cat_id AS cat_id_0,
  i0_.cat_name AS cat_name_1,
  i0_.cat_page_number AS cat_page_number_2,
  i0_.cat_creation_date AS cat_creation_date_3,
  i0_.cat_update_date AS cat_update_date_4,
  i1_.feat_products_list AS feat_products_list_5,
  i1_.feat_statistics_plus AS feat_statistics_plus_6,
  i1_.feat_form AS feat_form_7,
  i1_.feat_email_extract AS feat_email_extract_8
FROM
  itm_catalog i0_
  LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id)
  LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id
WHERE
  i2_.sub_id = ?
ORDER BY
  i0_.cat_creation_date DESC

SELECT i0_.cat_id AS cat_id_0, i0_.cat_name AS cat_name_1, i0_.cat_page_number AS cat_page_number_2, i0_.cat_creation_date AS cat_creation_date_3, i0_.cat_update_date AS cat_update_date_4, i1_.feat_products_list AS feat_products_list_5, i1_.feat_statistics_plus AS feat_statistics_plus_6, i1_.feat_form AS feat_form_7, i1_.feat_email_extract AS feat_email_extract_8 FROM itm_catalog i0_ LEFT JOIN itm_subscription i2_ ON (i0_.sub_id = i2_.sub_id) LEFT JOIN itm_feature i1_ ON i2_.feat_id = i1_.feat_id WHERE i2_.sub_id = 417 ORDER BY i0_.cat_creation_date DESC;

SELECT i0_.sub_id AS sub_id_0, i0_.sub_name AS sub_name_1, i0_.sub_creation_date AS sub_creation_date_2, i0_.sub_expiration_date AS sub_expiration_date_3, i0_.sub_archive AS sub_archive_4, i0_.sub_temporary AS sub_temporary_5, i0_.sub_document_number AS sub_document_number_6, i0_.sub_page_number AS sub_page_number_7, i0_.sub_download_number AS sub_download_number_8, i0_.sub_download_done AS sub_download_done_9, i0_.sub_validate AS sub_validate_10, COUNT(i1_.cat_id) AS sclr_11, MAX(i1_.cat_page_number) AS sclr_12, i0_.feat_id AS sclr_13 FROM itm_subscription i0_ LEFT JOIN itm_catalog i1_ ON (i1_.sub_id = i0_.sub_id) WHERE i0_.cust_id = ? GROUP BY i0_.sub_id ORDER BY i0_.sub_id ASC

[
  1
]

SELECT
  i0_.sub_id AS sub_id_0,
  i0_.sub_name AS sub_name_1,
  i0_.sub_creation_date AS sub_creation_date_2,
  i0_.sub_expiration_date AS sub_expiration_date_3,
  i0_.sub_archive AS sub_archive_4,
  i0_.sub_temporary AS sub_temporary_5,
  i0_.sub_document_number AS sub_document_number_6,
  i0_.sub_page_number AS sub_page_number_7,
  i0_.sub_download_number AS sub_download_number_8,
  i0_.sub_download_done AS sub_download_done_9,
  i0_.sub_validate AS sub_validate_10,
  COUNT(i1_.cat_id) AS sclr_11,
  MAX(i1_.cat_page_number) AS sclr_12,
  i0_.feat_id AS sclr_13
FROM
  itm_subscription i0_
  LEFT JOIN itm_catalog i1_ ON (i1_.sub_id = i0_.sub_id)
WHERE
  i0_.cust_id = ?
GROUP BY
  i0_.sub_id
ORDER BY
  i0_.sub_id ASC

SELECT i0_.sub_id AS sub_id_0, i0_.sub_name AS sub_name_1, i0_.sub_creation_date AS sub_creation_date_2, i0_.sub_expiration_date AS sub_expiration_date_3, i0_.sub_archive AS sub_archive_4, i0_.sub_temporary AS sub_temporary_5, i0_.sub_document_number AS sub_document_number_6, i0_.sub_page_number AS sub_page_number_7, i0_.sub_download_number AS sub_download_number_8, i0_.sub_download_done AS sub_download_done_9, i0_.sub_validate AS sub_validate_10, COUNT(i1_.cat_id) AS sclr_11, MAX(i1_.cat_page_number) AS sclr_12, i0_.feat_id AS sclr_13 FROM itm_subscription i0_ LEFT JOIN itm_catalog i1_ ON (i1_.sub_id = i0_.sub_id) WHERE i0_.cust_id = 1 GROUP BY i0_.sub_id ORDER BY i0_.sub_id ASC;

SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_id = ?

[
  369
]

SELECT
  t0.use_id AS use_id_1,
  t0.use_login AS use_login_2,
  t0.use_password AS use_password_3,
  t0.roles AS roles_4,
  t0.use_first_name AS use_first_name_5,
  t0.use_last_name AS use_last_name_6,
  t0.use_email AS use_email_7,
  t0.use_id_parent AS use_id_parent_8,
  t0.last_connection AS last_connection_9,
  t0.count_connection AS count_connection_10,
  t0.password_last_changed AS password_last_changed_11,
  t0.require_password_change AS require_password_change_12,
  t0.two_factor_secret AS two_factor_secret_13,
  t0.two_factor_method AS two_factor_method_14,
  t0.two_factor_enabled AS two_factor_enabled_15,
  t0.two_factor_email_code AS two_factor_email_code_16,
  t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17,
  t0.failed_login_attempts AS failed_login_attempts_18,
  t0.locked_until AS locked_until_19,
  t0.cust_id AS cust_id_20,
  t0.priv_id AS priv_id_21
FROM
  itm_user t0
WHERE
  t0.use_id = ?

SELECT t0.use_id AS use_id_1, t0.use_login AS use_login_2, t0.use_password AS use_password_3, t0.roles AS roles_4, t0.use_first_name AS use_first_name_5, t0.use_last_name AS use_last_name_6, t0.use_email AS use_email_7, t0.use_id_parent AS use_id_parent_8, t0.last_connection AS last_connection_9, t0.count_connection AS count_connection_10, t0.password_last_changed AS password_last_changed_11, t0.require_password_change AS require_password_change_12, t0.two_factor_secret AS two_factor_secret_13, t0.two_factor_method AS two_factor_method_14, t0.two_factor_enabled AS two_factor_enabled_15, t0.two_factor_email_code AS two_factor_email_code_16, t0.two_factor_email_code_expiry AS two_factor_email_code_expiry_17, t0.failed_login_attempts AS failed_login_attempts_18, t0.locked_until AS locked_until_19, t0.cust_id AS cust_id_20, t0.priv_id AS priv_id_21 FROM itm_user t0 WHERE t0.use_id = 369;