Symfony Profiler

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

Query Metrics

SELECT c.id, cd.name
             FROM product_category pc
             INNER JOIN category c ON c.id = pc.category_id
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = ?
             WHERE pc.product_id = ? AND c.site_id = ? AND c.status = 1
             ORDER BY c.sort_order ASC, c.id ASC
             LIMIT 1

[
  "en"
  43111
  26
]

SELECT
  c.id,
  cd.name
FROM
  product_category pc
  INNER JOIN category c ON c.id = pc.category_id
  LEFT JOIN category_description cd ON cd.category_id = c.id
  AND cd.language_id = ?
WHERE
  pc.product_id = ?
  AND c.site_id = ?
  AND c.status = 1
ORDER BY
  c.sort_order ASC,
  c.id ASC
LIMIT
  1

SELECT c.id, cd.name
             FROM product_category pc
             INNER JOIN category c ON c.id = pc.category_id
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = 'en'
             WHERE pc.product_id = 43111 AND c.site_id = 26 AND c.status = 1
             ORDER BY c.sort_order ASC, c.id ASC
             LIMIT 1;

SELECT p.id, p.site_id, p.model, p.image, p.price, p.currency_id, p.sort_order,
                    pd.name, pd.description, pd.meta_title, pd.meta_description, pd.meta_keyword
             FROM product p
             LEFT JOIN product_description pd ON pd.product_id = p.id AND pd.language_id = ?
             WHERE p.id = ? AND p.site_id = ? AND p.status = 1
             LIMIT 1

[
  "en"
  43111
  26
]

SELECT
  p.id,
  p.site_id,
  p.model,
  p.image,
  p.price,
  p.currency_id,
  p.sort_order,
  pd.name,
  pd.description,
  pd.meta_title,
  pd.meta_description,
  pd.meta_keyword
FROM
  product p
  LEFT JOIN product_description pd ON pd.product_id = p.id
  AND pd.language_id = ?
WHERE
  p.id = ?
  AND p.site_id = ?
  AND p.status = 1
LIMIT
  1

SELECT p.id, p.site_id, p.model, p.image, p.price, p.currency_id, p.sort_order,
                    pd.name, pd.description, pd.meta_title, pd.meta_description, pd.meta_keyword
             FROM product p
             LEFT JOIN product_description pd ON pd.product_id = p.id AND pd.language_id = 'en'
             WHERE p.id = 43111 AND p.site_id = 26 AND p.status = 1
             LIMIT 1;

SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description
             FROM category c
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = ?
             WHERE c.site_id = ? AND c.status = 1
             ORDER BY c.sort_order ASC, c.id ASC

[
  "en"
  26
]

SELECT
  c.id,
  c.parent_id,
  c.image,
  c.sort_order,
  cd.name,
  cd.description
FROM
  category c
  LEFT JOIN category_description cd ON cd.category_id = c.id
  AND cd.language_id = ?
WHERE
  c.site_id = ?
  AND c.status = 1
ORDER BY
  c.sort_order ASC,
  c.id ASC

SELECT c.id, c.parent_id, c.image, c.sort_order, cd.name, cd.description
             FROM category c
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = 'en'
             WHERE c.site_id = 26 AND c.status = 1
             ORDER BY c.sort_order ASC, c.id ASC;