Symfony Profiler

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

Query Metrics

SELECT pl.*
FROM products_listing pl
INNER JOIN (
    SELECT DISTINCT product_id AS pid
    FROM shopping_cart
    WHERE product_id IS NOT NULL AND product_id > 0
) sc ON pl.id = sc.pid
ORDER BY pl.date_of_creating DESC

[]

SELECT
  pl.*
FROM
  products_listing pl
  INNER JOIN (
    SELECT
      DISTINCT product_id AS pid
    FROM
      shopping_cart
    WHERE
      product_id IS NOT NULL
      AND product_id > 0
  ) sc ON pl.id = sc.pid
ORDER BY
  pl.date_of_creating DESC

SELECT pl.*
FROM products_listing pl
INNER JOIN (
    SELECT DISTINCT product_id AS pid
    FROM shopping_cart
    WHERE product_id IS NOT NULL AND product_id > 0
) sc ON pl.id = sc.pid
ORDER BY pl.date_of_creating DESC;