Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 137
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• Doctrine 1
• Migrations 3
• Debug
• Messages
• Emails
• Workflow
• Redis
• VichUploader
• Payum
• Configuration

Query Metrics

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.password AS password_2, a0_.role AS role_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6 FROM administrators a0_ WHERE a0_.email = ?

[
  "admin@admin.com"
]

SELECT
  a0_.id AS id_0,
  a0_.email AS email_1,
  a0_.password AS password_2,
  a0_.role AS role_3,
  a0_.active AS active_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6
FROM
  administrators a0_
WHERE
  a0_.email = ?

SELECT a0_.id AS id_0, a0_.email AS email_1, a0_.password AS password_2, a0_.role AS role_3, a0_.active AS active_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6 FROM administrators a0_ WHERE a0_.email = 'admin@admin.com';

SHOW TIME ZONE

[]

SHOW TIME ZONE

SHOW TIME ZONE;

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1, u1_.name AS name_2 FROM payments p0_ LEFT JOIN sites s2_ ON p0_.site_id = s2_.id LEFT JOIN payment_gateway_configs p3_ ON s2_.payment_gateway_config_id = p3_.id LEFT JOIN user_payment_info u1_ ON p0_.id = u1_.payment_id ORDER BY p0_.created_at DESC, u1_.name DESC LIMIT 10

[]

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  u1_.name AS name_2
FROM
  payments p0_
  LEFT JOIN sites s2_ ON p0_.site_id = s2_.id
  LEFT JOIN payment_gateway_configs p3_ ON s2_.payment_gateway_config_id = p3_.id
  LEFT JOIN user_payment_info u1_ ON p0_.id = u1_.payment_id
ORDER BY
  p0_.created_at DESC,
  u1_.name DESC
LIMIT
  10

SELECT DISTINCT p0_.id AS id_0, p0_.created_at AS created_at_1, u1_.name AS name_2 FROM payments p0_ LEFT JOIN sites s2_ ON p0_.site_id = s2_.id LEFT JOIN payment_gateway_configs p3_ ON s2_.payment_gateway_config_id = p3_.id LEFT JOIN user_payment_info u1_ ON p0_.id = u1_.payment_id ORDER BY p0_.created_at DESC, u1_.name DESC LIMIT 10;

SELECT p0_.id || '' AS sclr_0, p0_.external_id || '' AS sclr_1, p0_.payment_type AS payment_type_2, p0_.pisp_status AS pisp_status_3, p0_.bank_status AS bank_status_4, p0_.amount / 100 AS sclr_5, p0_.id AS id_6, p0_.currency AS currency_7, p0_.created_at AS created_at_8, s1_.id AS id_9, s1_.name AS name_10, p2_.id AS id_11, p2_.factory_name AS factory_name_12, u3_.id AS id_13, u3_.ip_address AS ip_address_14, u3_.name AS name_15 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.created_at DESC, u3_.name DESC

[
  "2eb42be5-2c37-4328-903e-03b39dbbaefa"
  "e81d9b9a-80b6-425a-810d-8e82ec97eac8"
  "2b933838-d2b9-422b-a387-674bdc66f9cf"
  "fc3ee427-c63b-4f2e-b132-a375e326e196"
  "f9ab672d-31bd-4494-bc7c-ded5b04edb5c"
  "6e198567-3054-444d-bfa7-7834d1752929"
  "98266db0-3865-45f7-8500-2fc56c1481f8"
  "21b556d5-1d92-4224-8704-a05b936bf858"
  "c20bee1f-0282-4d65-920d-9a0b7ffc7971"
  "2b89adb0-8d4e-4ee4-8d18-eaf4e33db6e0"
]

SELECT
  p0_.id || '' AS sclr_0,
  p0_.external_id || '' AS sclr_1,
  p0_.payment_type AS payment_type_2,
  p0_.pisp_status AS pisp_status_3,
  p0_.bank_status AS bank_status_4,
  p0_.amount / 100 AS sclr_5,
  p0_.id AS id_6,
  p0_.currency AS currency_7,
  p0_.created_at AS created_at_8,
  s1_.id AS id_9,
  s1_.name AS name_10,
  p2_.id AS id_11,
  p2_.factory_name AS factory_name_12,
  u3_.id AS id_13,
  u3_.ip_address AS ip_address_14,
  u3_.name AS name_15
FROM
  payments p0_
  LEFT JOIN sites s1_ ON p0_.site_id = s1_.id
  LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id
  LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id
WHERE
  p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.created_at DESC,
  u3_.name DESC

SELECT p0_.id || '' AS sclr_0, p0_.external_id || '' AS sclr_1, p0_.payment_type AS payment_type_2, p0_.pisp_status AS pisp_status_3, p0_.bank_status AS bank_status_4, p0_.amount / 100 AS sclr_5, p0_.id AS id_6, p0_.currency AS currency_7, p0_.created_at AS created_at_8, s1_.id AS id_9, s1_.name AS name_10, p2_.id AS id_11, p2_.factory_name AS factory_name_12, u3_.id AS id_13, u3_.ip_address AS ip_address_14, u3_.name AS name_15 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id WHERE p0_.id IN ('2eb42be5-2c37-4328-903e-03b39dbbaefa', 'e81d9b9a-80b6-425a-810d-8e82ec97eac8', '2b933838-d2b9-422b-a387-674bdc66f9cf', 'fc3ee427-c63b-4f2e-b132-a375e326e196', 'f9ab672d-31bd-4494-bc7c-ded5b04edb5c', '6e198567-3054-444d-bfa7-7834d1752929', '98266db0-3865-45f7-8500-2fc56c1481f8', '21b556d5-1d92-4224-8704-a05b936bf858', 'c20bee1f-0282-4d65-920d-9a0b7ffc7971', '2b89adb0-8d4e-4ee4-8d18-eaf4e33db6e0') ORDER BY p0_.created_at DESC, u3_.name DESC;

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id

[]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  payments p0_
  LEFT JOIN sites s1_ ON p0_.site_id = s1_.id
  LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id
  LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id;

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id

[]

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  payments p0_
  LEFT JOIN sites s1_ ON p0_.site_id = s1_.id
  LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id
  LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM payments p0_ LEFT JOIN sites s1_ ON p0_.site_id = s1_.id LEFT JOIN payment_gateway_configs p2_ ON s1_.payment_gateway_config_id = p2_.id LEFT JOIN user_payment_info u3_ ON p0_.id = u3_.payment_id;