Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Debug
• Serializer
• Configuration

Query Metrics

SELECT email FROM xvba17_customer c WHERE c.deleted = 0

[]

SELECT
  email
FROM
  xvba17_customer c
WHERE
  c.deleted = 0

SELECT email FROM xvba17_customer c WHERE c.deleted = 0;

SELECT COUNT(*) as total FROM xvba17_customer c WHERE c.deleted = 0

[]

SELECT
  COUNT(*) as total
FROM
  xvba17_customer c
WHERE
  c.deleted = 0

SELECT COUNT(*) as total FROM xvba17_customer c WHERE c.deleted = 0;

SELECT COUNT(*) as total
                         FROM xvba17_customer c
                         WHERE c.deleted = 0

[]

SELECT
  COUNT(*) as total
FROM
  xvba17_customer c
WHERE
  c.deleted = 0

SELECT COUNT(*) as total
                         FROM xvba17_customer c
                         WHERE c.deleted = 0;

SELECT 
                    c.id_customer,
                    c.firstname,
                    c.lastname,
                    c.email,
                    c.id_gender,
                    c.active,
                    c.date_add,
                    gl.name as group_name,
                    c.id_default_group
                FROM xvba17_customer c
                LEFT JOIN xvba17_group_lang gl ON c.id_default_group = gl.id_group AND gl.id_lang = 1
                WHERE c.deleted = 0 ORDER BY c.id_customer ASC LIMIT ? OFFSET ?

[
  50
  0
]

SELECT
  c.id_customer,
  c.firstname,
  c.lastname,
  c.email,
  c.id_gender,
  c.active,
  c.date_add,
  gl.name as group_name,
  c.id_default_group
FROM
  xvba17_customer c
  LEFT JOIN xvba17_group_lang gl ON c.id_default_group = gl.id_group
  AND gl.id_lang = 1
WHERE
  c.deleted = 0
ORDER BY
  c.id_customer ASC
LIMIT
  ?
OFFSET
  ?

SELECT 
                    c.id_customer,
                    c.firstname,
                    c.lastname,
                    c.email,
                    c.id_gender,
                    c.active,
                    c.date_add,
                    gl.name as group_name,
                    c.id_default_group
                FROM xvba17_customer c
                LEFT JOIN xvba17_group_lang gl ON c.id_default_group = gl.id_group AND gl.id_lang = 1
                WHERE c.deleted = 0 ORDER BY c.id_customer ASC LIMIT 50 OFFSET 0;

SELECT g.id_group, gl.name 
             FROM xvba17_group g
             LEFT JOIN xvba17_group_lang gl ON g.id_group = gl.id_group AND gl.id_lang = 1
             ORDER BY gl.name

[]

SELECT
  g.id_group,
  gl.name
FROM
  xvba17_group g
  LEFT JOIN xvba17_group_lang gl ON g.id_group = gl.id_group
  AND gl.id_lang = 1
ORDER BY
  gl.name

SELECT g.id_group, gl.name 
             FROM xvba17_group g
             LEFT JOIN xvba17_group_lang gl ON g.id_group = gl.id_group AND gl.id_lang = 1
             ORDER BY gl.name;

SELECT LOWER(TRIM(email)) as email FROM customer_entity

[]

SELECT
  LOWER(
    TRIM(email)
  ) as email
FROM
  customer_entity

SELECT LOWER(TRIM(email)) as email FROM customer_entity;

SELECT 
                e.entity_id,
                e.email,
                e.firstname,
                e.lastname,
                e.gender,
                e.group_id,
                e.website_id,
                e.store_id,
                e.created_at,
                cg.customer_group_code as group_name
            FROM customer_entity e
            LEFT JOIN customer_group cg ON e.group_id = cg.customer_group_id

[]

SELECT
  e.entity_id,
  e.email,
  e.firstname,
  e.lastname,
  e.gender,
  e.group_id,
  e.website_id,
  e.store_id,
  e.created_at,
  cg.customer_group_code as group_name
FROM
  customer_entity e
  LEFT JOIN customer_group cg ON e.group_id = cg.customer_group_id

SELECT 
                e.entity_id,
                e.email,
                e.firstname,
                e.lastname,
                e.gender,
                e.group_id,
                e.website_id,
                e.store_id,
                e.created_at,
                cg.customer_group_code as group_name
            FROM customer_entity e
            LEFT JOIN customer_group cg ON e.group_id = cg.customer_group_id
        ;