Symfony Profiler

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

Query Metrics

SELECT 
                pv.id AS product_variant_id,
                pv.variant_name,
                pv.price,
                pv.description,
                pv.promo_status,
                pv.promo_percentage,
                
                p.id AS product_id,
                p.name,
                p.label,

                pi.image_name

            FROM product_variant pv
            JOIN product p ON pv.product_id = p.id
            JOIN (
                SELECT pi1.*
                FROM product_image pi1
                JOIN (
                    SELECT product_id, MIN(id) AS min_id
                    FROM product_image
                    GROUP BY product_id
                ) AS first_images ON pi1.id = first_images.min_id
            ) AS pi ON pi.product_id = p.id
            JOIN (
                SELECT product_variant_id
                FROM order_item
                GROUP BY product_variant_id
                ORDER BY COUNT(*) DESC
                LIMIT 3
            ) AS top_products ON pv.id = top_products.product_variant_id

[]

SELECT
  pv.id AS product_variant_id,
  pv.variant_name,
  pv.price,
  pv.description,
  pv.promo_status,
  pv.promo_percentage,
  p.id AS product_id,
  p.name,
  p.label,
  pi.image_name
FROM
  product_variant pv
  JOIN product p ON pv.product_id = p.id
  JOIN (
    SELECT
      pi1.*
    FROM
      product_image pi1
      JOIN (
        SELECT
          product_id,
          MIN(id) AS min_id
        FROM
          product_image
        GROUP BY
          product_id
      ) AS first_images ON pi1.id = first_images.min_id
  ) AS pi ON pi.product_id = p.id
  JOIN (
    SELECT
      product_variant_id
    FROM
      order_item
    GROUP BY
      product_variant_id
    ORDER BY
      COUNT(*) DESC
    LIMIT
      3
  ) AS top_products ON pv.id = top_products.product_variant_id

SELECT 
                pv.id AS product_variant_id,
                pv.variant_name,
                pv.price,
                pv.description,
                pv.promo_status,
                pv.promo_percentage,
                
                p.id AS product_id,
                p.name,
                p.label,

                pi.image_name

            FROM product_variant pv
            JOIN product p ON pv.product_id = p.id
            JOIN (
                SELECT pi1.*
                FROM product_image pi1
                JOIN (
                    SELECT product_id, MIN(id) AS min_id
                    FROM product_image
                    GROUP BY product_id
                ) AS first_images ON pi1.id = first_images.min_id
            ) AS pi ON pi.product_id = p.id
            JOIN (
                SELECT product_variant_id
                FROM order_item
                GROUP BY product_variant_id
                ORDER BY COUNT(*) DESC
                LIMIT 3
            ) AS top_products ON pv.id = top_products.product_variant_id
        ;