Symfony Profiler

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

Query Metrics

SELECT COUNT(*) as total 
                    FROM xvba17_orders o
                    LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                    WHERE 1=1

[]

SELECT
  COUNT(*) as total
FROM
  xvba17_orders o
  LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
WHERE
  1 = 1

SELECT COUNT(*) as total 
                    FROM xvba17_orders o
                    LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                    WHERE 1=1;

SELECT o.id_order, c.email, o.total_paid
                     FROM xvba17_orders o
                     LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                     WHERE 1=1

[]

SELECT
  o.id_order,
  c.email,
  o.total_paid
FROM
  xvba17_orders o
  LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
WHERE
  1 = 1

SELECT o.id_order, c.email, o.total_paid
                     FROM xvba17_orders o
                     LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                     WHERE 1=1;

SELECT 
                    o.id_order,
                    o.reference,
                    o.id_customer,
                    o.total_paid,
                    o.date_add,
                    os.name as order_status,
                    CONCAT(c.firstname, ' ', c.lastname) as customer_name,
                    c.email as customer_email
                FROM xvba17_orders o
                LEFT JOIN xvba17_order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = 1
                LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                WHERE 1=1 ORDER BY o.id_order DESC LIMIT ? OFFSET ?

[
  50
  50
]

SELECT
  o.id_order,
  o.reference,
  o.id_customer,
  o.total_paid,
  o.date_add,
  os.name as order_status,
  CONCAT(c.firstname, ' ', c.lastname) as customer_name,
  c.email as customer_email
FROM
  xvba17_orders o
  LEFT JOIN xvba17_order_state_lang os ON o.current_state = os.id_order_state
  AND os.id_lang = 1
  LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
WHERE
  1 = 1
ORDER BY
  o.id_order DESC
LIMIT
  ?
OFFSET
  ?

SELECT 
                    o.id_order,
                    o.reference,
                    o.id_customer,
                    o.total_paid,
                    o.date_add,
                    os.name as order_status,
                    CONCAT(c.firstname, ' ', c.lastname) as customer_name,
                    c.email as customer_email
                FROM xvba17_orders o
                LEFT JOIN xvba17_order_state_lang os ON o.current_state = os.id_order_state AND os.id_lang = 1
                LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                WHERE 1=1 ORDER BY o.id_order DESC LIMIT 50 OFFSET 50;

SELECT COUNT(*) as total
                         FROM xvba17_orders o
                         LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                         WHERE 1=1

[]

SELECT
  COUNT(*) as total
FROM
  xvba17_orders o
  LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
WHERE
  1 = 1

SELECT COUNT(*) as total
                         FROM xvba17_orders o
                         LEFT JOIN xvba17_customer c ON o.id_customer = c.id_customer
                         WHERE 1=1;

SELECT customer_email, grand_total
            FROM sales_order

[]

SELECT
  customer_email,
  grand_total
FROM
  sales_order

SELECT customer_email, grand_total
            FROM sales_order
        ;

SELECT 
                o.entity_id,
                o.increment_id,
                o.customer_email,
                o.customer_firstname,
                o.customer_lastname,
                o.grand_total,
                o.status,
                o.created_at
            FROM sales_order o
            ORDER BY o.entity_id DESC

[]

SELECT
  o.entity_id,
  o.increment_id,
  o.customer_email,
  o.customer_firstname,
  o.customer_lastname,
  o.grand_total,
  o.status,
  o.created_at
FROM
  sales_order o
ORDER BY
  o.entity_id DESC

SELECT 
                o.entity_id,
                o.increment_id,
                o.customer_email,
                o.customer_firstname,
                o.customer_lastname,
                o.grand_total,
                o.status,
                o.created_at
            FROM sales_order o
            ORDER BY o.entity_id DESC
        ;