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 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
             INNER JOIN product_category pc ON pc.product_id = p.id
             LEFT JOIN product_description pd ON pd.product_id = p.id AND pd.language_id = ?
             WHERE p.site_id = ? AND p.status = 1 AND pc.category_id = ?
             ORDER BY p.sort_order ASC, p.price ASC, p.id ASC

[
  "en"
  26
  294
]

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
  INNER JOIN product_category pc ON pc.product_id = p.id
  LEFT JOIN product_description pd ON pd.product_id = p.id
  AND pd.language_id = ?
WHERE
  p.site_id = ?
  AND p.status = 1
  AND pc.category_id = ?
ORDER BY
  p.sort_order ASC,
  p.price ASC,
  p.id ASC

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
             INNER JOIN product_category pc ON pc.product_id = p.id
             LEFT JOIN product_description pd ON pd.product_id = p.id AND pd.language_id = 'en'
             WHERE p.site_id = 26 AND p.status = 1 AND pc.category_id = 294
             ORDER BY p.sort_order ASC, p.price ASC, p.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 = ?
             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;

SELECT c.id, c.parent_id, c.image, c.sort_order,
                    cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword
             FROM category c
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = ?
             WHERE c.id = ? AND c.site_id = ? AND c.status = 1
             LIMIT 1

[
  "en"
  294
  26
]

SELECT
  c.id,
  c.parent_id,
  c.image,
  c.sort_order,
  cd.name,
  cd.description,
  cd.meta_title,
  cd.meta_description,
  cd.meta_keyword
FROM
  category c
  LEFT JOIN category_description cd ON cd.category_id = c.id
  AND cd.language_id = ?
WHERE
  c.id = ?
  AND c.site_id = ?
  AND c.status = 1
LIMIT
  1

SELECT c.id, c.parent_id, c.image, c.sort_order,
                    cd.name, cd.description, cd.meta_title, cd.meta_description, cd.meta_keyword
             FROM category c
             LEFT JOIN category_description cd ON cd.category_id = c.id AND cd.language_id = 'en'
             WHERE c.id = 294 AND c.site_id = 26 AND c.status = 1
             LIMIT 1;