Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 156
• Events
• Routing
• Cache
• Translation 5
• Security
• Twig
• Doctrine
• 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';

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM merchants m0_ ORDER BY m0_.created_at DESC LIMIT 10

[]

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.created_at AS created_at_1
FROM
  merchants m0_
ORDER BY
  m0_.created_at DESC
LIMIT
  10

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM merchants m0_ ORDER BY m0_.created_at DESC LIMIT 10;

SELECT m0_.id AS id_0, m0_.email AS email_1, m0_.active AS active_2, m0_.created_at AS created_at_3, (SELECT COUNT(s1_.id) AS sclr_5 FROM sites s1_ WHERE s1_.merchant_id = m0_.id) AS sclr_4 FROM merchants m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.created_at DESC

[
  "33ca5cfc-83ba-4c25-8c3a-ea401b563632"
  "80941300-6f59-4beb-88e1-aae0b126c7ad"
  "a5689c07-e3a1-4764-8787-a5b21799da75"
  "c711be87-04f0-4ada-a64d-4eeb77dfdd07"
  "d22bdd89-dd1c-4211-ad1a-41eaf24967fa"
  "74d03c2b-70f0-4ddf-995b-59ee4cc8577f"
  "7a72893f-a3a5-43f7-952c-a336e2042466"
  "8ffa23a6-4865-42a1-b126-0e00bb0a9cb2"
  "fc2bead6-8800-44a1-bf90-4a4f84d72f36"
  "cd62fade-2d12-4355-85a0-11f444ffb989"
]

SELECT
  m0_.id AS id_0,
  m0_.email AS email_1,
  m0_.active AS active_2,
  m0_.created_at AS created_at_3,
  (
    SELECT
      COUNT(s1_.id) AS sclr_5
    FROM
      sites s1_
    WHERE
      s1_.merchant_id = m0_.id
  ) AS sclr_4
FROM
  merchants m0_
WHERE
  m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.email AS email_1, m0_.active AS active_2, m0_.created_at AS created_at_3, (SELECT COUNT(s1_.id) AS sclr_5 FROM sites s1_ WHERE s1_.merchant_id = m0_.id) AS sclr_4 FROM merchants m0_ WHERE m0_.id IN ('33ca5cfc-83ba-4c25-8c3a-ea401b563632', '80941300-6f59-4beb-88e1-aae0b126c7ad', 'a5689c07-e3a1-4764-8787-a5b21799da75', 'c711be87-04f0-4ada-a64d-4eeb77dfdd07', 'd22bdd89-dd1c-4211-ad1a-41eaf24967fa', '74d03c2b-70f0-4ddf-995b-59ee4cc8577f', '7a72893f-a3a5-43f7-952c-a336e2042466', '8ffa23a6-4865-42a1-b126-0e00bb0a9cb2', 'fc2bead6-8800-44a1-bf90-4a4f84d72f36', 'cd62fade-2d12-4355-85a0-11f444ffb989') ORDER BY m0_.created_at DESC;

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM merchants m0_

[]

SELECT
  count(DISTINCT m0_.id) AS sclr_0
FROM
  merchants m0_

SELECT count(DISTINCT m0_.id) AS sclr_0 FROM merchants m0_;