Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 74
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Emails
• Notifications
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = ? AND t0.enabled = ? AND t0.deleted_at IS NULL LIMIT 1

[
  "developers@eboost.vn"
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.avatar_url AS avatar_url_6,
  t0.token_version AS token_version_7,
  t0.roles AS roles_8,
  t0.password_change_date AS password_change_date_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.enabled AS enabled_15
FROM
  admin t0
WHERE
  t0.username = ?
  AND t0.enabled = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = 'developers@eboost.vn' AND t0.enabled = 1 AND t0.deleted_at IS NULL LIMIT 1;

SELECT ip_address, valid
                FROM refresh_token
                WHERE username = ? AND role = ?
                ORDER BY valid DESC

[
  "developers@eboost.vn"
  "ROLE_DEVELOPER"
]

SELECT
  ip_address,
  valid
FROM
  refresh_token
WHERE
  username = ?
  AND role = ?
ORDER BY
  valid DESC

SELECT ip_address, valid
                FROM refresh_token
                WHERE username = 'developers@eboost.vn' AND role = 'ROLE_DEVELOPER'
                ORDER BY valid DESC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = ? LIMIT 1

[
  "developers@eboost.vn"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.avatar_url AS avatar_url_6,
  t0.token_version AS token_version_7,
  t0.roles AS roles_8,
  t0.password_change_date AS password_change_date_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.enabled AS enabled_15
FROM
  admin t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = 'developers@eboost.vn' LIMIT 1;

SELECT e0_.id AS id_0, e0_.order_id AS order_id_1, e0_.invoice_id AS invoice_id_2, e0_.invoice_sign_status AS invoice_sign_status_3, e0_.profile_type AS profile_type_4, e0_.external_id AS external_id_5, e0_.buyer_tax_code AS buyer_tax_code_6, e0_.buyer_email AS buyer_email_7, e0_.buyer_name AS buyer_name_8, e0_.buyer_phone_number AS buyer_phone_number_9, e0_.buyer_address AS buyer_address_10, e0_.user_id AS user_id_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.deleted_at AS deleted_at_14, e0_.entity_name AS entity_name_15, e0_.entity_id AS entity_id_16 FROM electronic_invoice e0_ WHERE e0_.order_id = ? OR e0_.invoice_id = ? OR e0_.external_id = ? ORDER BY e0_.created_at DESC

[
  "7038cd25-59c1-4234-9c1a-c52a91d5ea0a"
  "7038cd25-59c1-4234-9c1a-c52a91d5ea0a"
  "7038cd25-59c1-4234-9c1a-c52a91d5ea0a"
]

SELECT
  e0_.id AS id_0,
  e0_.order_id AS order_id_1,
  e0_.invoice_id AS invoice_id_2,
  e0_.invoice_sign_status AS invoice_sign_status_3,
  e0_.profile_type AS profile_type_4,
  e0_.external_id AS external_id_5,
  e0_.buyer_tax_code AS buyer_tax_code_6,
  e0_.buyer_email AS buyer_email_7,
  e0_.buyer_name AS buyer_name_8,
  e0_.buyer_phone_number AS buyer_phone_number_9,
  e0_.buyer_address AS buyer_address_10,
  e0_.user_id AS user_id_11,
  e0_.created_at AS created_at_12,
  e0_.updated_at AS updated_at_13,
  e0_.deleted_at AS deleted_at_14,
  e0_.entity_name AS entity_name_15,
  e0_.entity_id AS entity_id_16
FROM
  electronic_invoice e0_
WHERE
  e0_.order_id = ?
  OR e0_.invoice_id = ?
  OR e0_.external_id = ?
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.order_id AS order_id_1, e0_.invoice_id AS invoice_id_2, e0_.invoice_sign_status AS invoice_sign_status_3, e0_.profile_type AS profile_type_4, e0_.external_id AS external_id_5, e0_.buyer_tax_code AS buyer_tax_code_6, e0_.buyer_email AS buyer_email_7, e0_.buyer_name AS buyer_name_8, e0_.buyer_phone_number AS buyer_phone_number_9, e0_.buyer_address AS buyer_address_10, e0_.user_id AS user_id_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.deleted_at AS deleted_at_14, e0_.entity_name AS entity_name_15, e0_.entity_id AS entity_id_16 FROM electronic_invoice e0_ WHERE e0_.order_id = '7038cd25-59c1-4234-9c1a-c52a91d5ea0a' OR e0_.invoice_id = '7038cd25-59c1-4234-9c1a-c52a91d5ea0a' OR e0_.external_id = '7038cd25-59c1-4234-9c1a-c52a91d5ea0a' ORDER BY e0_.created_at DESC;

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.invoice_id AS invoice_id_3, t0.invoice_sign_status AS invoice_sign_status_4, t0.profile_type AS profile_type_5, t0.external_id AS external_id_6, t0.buyer_tax_code AS buyer_tax_code_7, t0.buyer_email AS buyer_email_8, t0.buyer_name AS buyer_name_9, t0.buyer_phone_number AS buyer_phone_number_10, t0.buyer_address AS buyer_address_11, t0.user_id AS user_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.entity_name AS entity_name_16, t0.entity_id AS entity_id_17 FROM electronic_invoice t0 WHERE t0.id = ?

[
  12864
]

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.invoice_id AS invoice_id_3,
  t0.invoice_sign_status AS invoice_sign_status_4,
  t0.profile_type AS profile_type_5,
  t0.external_id AS external_id_6,
  t0.buyer_tax_code AS buyer_tax_code_7,
  t0.buyer_email AS buyer_email_8,
  t0.buyer_name AS buyer_name_9,
  t0.buyer_phone_number AS buyer_phone_number_10,
  t0.buyer_address AS buyer_address_11,
  t0.user_id AS user_id_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.deleted_at AS deleted_at_15,
  t0.entity_name AS entity_name_16,
  t0.entity_id AS entity_id_17
FROM
  electronic_invoice t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.invoice_id AS invoice_id_3, t0.invoice_sign_status AS invoice_sign_status_4, t0.profile_type AS profile_type_5, t0.external_id AS external_id_6, t0.buyer_tax_code AS buyer_tax_code_7, t0.buyer_email AS buyer_email_8, t0.buyer_name AS buyer_name_9, t0.buyer_phone_number AS buyer_phone_number_10, t0.buyer_address AS buyer_address_11, t0.user_id AS user_id_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.entity_name AS entity_name_16, t0.entity_id AS entity_id_17 FROM electronic_invoice t0 WHERE t0.id = 12864;