Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 32
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client 1
• Doctrine
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT n0_.id AS id_0, n0_.uuid AS uuid_1, n0_.message AS message_2, n0_.link_to AS link_to_3, n0_.status AS status_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.unread AS unread_7, n0_.permission AS permission_8, n0_.document_id AS document_id_9, n0_.order_group_id AS order_group_id_10, n0_.station_id AS station_id_11, n0_.owner_id AS owner_id_12, n0_.ticket_id AS ticket_id_13, n0_.user_id AS user_id_14, n0_.operation_id AS operation_id_15, n0_.bank_reconciliation_id AS bank_reconciliation_id_16, n0_.inventaire_id AS inventaire_id_17 FROM notification n0_ WHERE (n0_.owner_id IS NULL OR n0_.owner_id <> ?) AND (n0_.user_id IS NULL OR n0_.user_id = ?) AND n0_.permission IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND n0_.unread = 1

[
  2
  2
  "ROLE_STATION"
  "ROLE_MANAGER"
  "ROLE_PRODUCT"
  "ROLE_TIERS"
  "ROLE_CLUSTER"
  "ROLE_BANK"
  "ROLE_ACCOUNT"
  "ROLE_CREATE_ORDER"
  "ROLE_VIEW_ORDER"
  "ROLE_VALIDATE_ORDER"
  "ROLE_CREATE_ORDER_GROUP"
  "ROLE_VIEW_ORDER_GROUP"
  "ROLE_VALIDATE_ORDER_GROUP"
  "ROLE_CREATE_DELIVERY"
  "ROLE_VIEW_DELIVERY"
  "ROLE_VALIDATE_DELIVERY"
  "ROLE_CREATE_INVOICE"
  "ROLE_VIEW_INVOICE"
  "ROLE_VALIDATE_INVOICE"
  "ROLE_CREATE_PAY"
  "ROLE_VIEW_PAY"
  "ROLE_VALIDATE_PAY"
  "ROLE_CONFIRM_ORDER"
  "ROLE_CONFIRM_ORDER_GROUP"
  "ROLE_CONFIRM_DELIVERY"
  "ROLE_CREATE_IA"
  "ROLE_VIEW_IA"
  "ROLE_VALIDATE_IA"
  "ROLE_CASH"
  "ROLE_VALIDATE_ORDER_ACHAT"
  "ROLE_CREATE_DECAISSEMENT"
  "ROLE_VALIDATE_DECAISSEMENT"
  "ROLE_CREATE_RECONCILIATION"
  "ROLE_VALIDATE_RECONCILIATION"
  "ROLE_CREATE_ENCAISSEMENT"
  "ROLE_VALIDATE_ENCAISSEMENT"
  "ROLE_CREATE_INVOICE_SUPPLIER"
  "ROLE_VALIDATE_INVOICE_SUPPLIER"
  "ROLE_CREATE_CHECK_DEPOSIT"
  "ROLE_VALIDATE_CHECK_DEPOSIT"
  "ROLE_CREATE_TRANSFERT"
  "ROLE_VALIDATE_TRANSFERT"
  "ROLE_VIEW_FACTURE_MANAGER"
  "ROLE_CREATE_TRANSFER_STOCK"
  "ROLE_VIEW_TRANSFER_STOCK"
  "ROLE_VALIDATE_TRANSFER_STOCK"
  "ROLE_CREATE_BANK_EXPENSE"
  "ROLE_ADMIN"
]

SELECT
  n0_.id AS id_0,
  n0_.uuid AS uuid_1,
  n0_.message AS message_2,
  n0_.link_to AS link_to_3,
  n0_.status AS status_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.unread AS unread_7,
  n0_.permission AS permission_8,
  n0_.document_id AS document_id_9,
  n0_.order_group_id AS order_group_id_10,
  n0_.station_id AS station_id_11,
  n0_.owner_id AS owner_id_12,
  n0_.ticket_id AS ticket_id_13,
  n0_.user_id AS user_id_14,
  n0_.operation_id AS operation_id_15,
  n0_.bank_reconciliation_id AS bank_reconciliation_id_16,
  n0_.inventaire_id AS inventaire_id_17
FROM
  notification n0_
WHERE
  (
    n0_.owner_id IS NULL
    OR n0_.owner_id <> ?
  )
  AND (
    n0_.user_id IS NULL
    OR n0_.user_id = ?
  )
  AND n0_.permission IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND n0_.unread = 1

SELECT n0_.id AS id_0, n0_.uuid AS uuid_1, n0_.message AS message_2, n0_.link_to AS link_to_3, n0_.status AS status_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.unread AS unread_7, n0_.permission AS permission_8, n0_.document_id AS document_id_9, n0_.order_group_id AS order_group_id_10, n0_.station_id AS station_id_11, n0_.owner_id AS owner_id_12, n0_.ticket_id AS ticket_id_13, n0_.user_id AS user_id_14, n0_.operation_id AS operation_id_15, n0_.bank_reconciliation_id AS bank_reconciliation_id_16, n0_.inventaire_id AS inventaire_id_17 FROM notification n0_ WHERE (n0_.owner_id IS NULL OR n0_.owner_id <> 2) AND (n0_.user_id IS NULL OR n0_.user_id = 2) AND n0_.permission IN ('ROLE_STATION', 'ROLE_MANAGER', 'ROLE_PRODUCT', 'ROLE_TIERS', 'ROLE_CLUSTER', 'ROLE_BANK', 'ROLE_ACCOUNT', 'ROLE_CREATE_ORDER', 'ROLE_VIEW_ORDER', 'ROLE_VALIDATE_ORDER', 'ROLE_CREATE_ORDER_GROUP', 'ROLE_VIEW_ORDER_GROUP', 'ROLE_VALIDATE_ORDER_GROUP', 'ROLE_CREATE_DELIVERY', 'ROLE_VIEW_DELIVERY', 'ROLE_VALIDATE_DELIVERY', 'ROLE_CREATE_INVOICE', 'ROLE_VIEW_INVOICE', 'ROLE_VALIDATE_INVOICE', 'ROLE_CREATE_PAY', 'ROLE_VIEW_PAY', 'ROLE_VALIDATE_PAY', 'ROLE_CONFIRM_ORDER', 'ROLE_CONFIRM_ORDER_GROUP', 'ROLE_CONFIRM_DELIVERY', 'ROLE_CREATE_IA', 'ROLE_VIEW_IA', 'ROLE_VALIDATE_IA', 'ROLE_CASH', 'ROLE_VALIDATE_ORDER_ACHAT', 'ROLE_CREATE_DECAISSEMENT', 'ROLE_VALIDATE_DECAISSEMENT', 'ROLE_CREATE_RECONCILIATION', 'ROLE_VALIDATE_RECONCILIATION', 'ROLE_CREATE_ENCAISSEMENT', 'ROLE_VALIDATE_ENCAISSEMENT', 'ROLE_CREATE_INVOICE_SUPPLIER', 'ROLE_VALIDATE_INVOICE_SUPPLIER', 'ROLE_CREATE_CHECK_DEPOSIT', 'ROLE_VALIDATE_CHECK_DEPOSIT', 'ROLE_CREATE_TRANSFERT', 'ROLE_VALIDATE_TRANSFERT', 'ROLE_VIEW_FACTURE_MANAGER', 'ROLE_CREATE_TRANSFER_STOCK', 'ROLE_VIEW_TRANSFER_STOCK', 'ROLE_VALIDATE_TRANSFER_STOCK', 'ROLE_CREATE_BANK_EXPENSE', 'ROLE_ADMIN') AND n0_.unread = 1;

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone_number AS phone_number_6, t0.enabled AS enabled_7, t0.email AS email_8, t0.is_admin AS is_admin_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12, t0.cash_id AS cash_id_13 FROM user t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone_number AS phone_number_6,
  t0.enabled AS enabled_7,
  t0.email AS email_8,
  t0.is_admin AS is_admin_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12,
  t0.cash_id AS cash_id_13
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone_number AS phone_number_6, t0.enabled AS enabled_7, t0.email AS email_8, t0.is_admin AS is_admin_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12, t0.cash_id AS cash_id_13 FROM user t0 WHERE t0.id = 2;

SELECT s0_.id AS id_0, s0_.raison_social AS raison_social_1, s0_.forme AS forme_2, s0_.activity AS activity_3, s0_.numero_cc AS numero_cc_4, s0_.siege AS siege_5, s0_.telephone AS telephone_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.uuid AS uuid_9 FROM societe s0_ ORDER BY s0_.id DESC LIMIT 1

[]

SELECT
  s0_.id AS id_0,
  s0_.raison_social AS raison_social_1,
  s0_.forme AS forme_2,
  s0_.activity AS activity_3,
  s0_.numero_cc AS numero_cc_4,
  s0_.siege AS siege_5,
  s0_.telephone AS telephone_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.uuid AS uuid_9
FROM
  societe s0_
ORDER BY
  s0_.id DESC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.raison_social AS raison_social_1, s0_.forme AS forme_2, s0_.activity AS activity_3, s0_.numero_cc AS numero_cc_4, s0_.siege AS siege_5, s0_.telephone AS telephone_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.uuid AS uuid_9 FROM societe s0_ ORDER BY s0_.id DESC LIMIT 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uuid AS uuid_7 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_default AS is_default_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.uuid AS uuid_7
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_default AS is_default_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uuid AS uuid_7 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.uuid AS uuid_6
FROM
  permission t0
  INNER JOIN role_permission ON t0.id = role_permission.permission_id
WHERE
  role_permission.role_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN role_permission ON t0.id = role_permission.permission_id WHERE role_permission.role_id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.uuid AS uuid_6
FROM
  permission t0
  INNER JOIN user_permission ON t0.id = user_permission.permission_id
WHERE
  user_permission.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6 FROM permission t0 INNER JOIN user_permission ON t0.id = user_permission.permission_id WHERE user_permission.user_id = 2;