Symfony Profiler

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

Query Metrics

SELECT p1.shopid as shopid, p1.productid as productid, p1.productprice as productprice
                                FROM prodproductprice p1
                                WHERE p1.id = (
                                    SELECT MAX(p2.id)
                                    FROM prodproductprice p2
                                    WHERE p2.shopid = p1.shopid AND p2.productid = p1.productid 
                                ) AND shopid IN ('8597665') AND productid IN ('400098936')

[]

SELECT
  p1.shopid as shopid,
  p1.productid as productid,
  p1.productprice as productprice
FROM
  prodproductprice p1
WHERE
  p1.id = (
    SELECT
      MAX(p2.id)
    FROM
      prodproductprice p2
    WHERE
      p2.shopid = p1.shopid
      AND p2.productid = p1.productid
  )
  AND shopid IN ('8597665')
  AND productid IN ('400098936')

SELECT p1.shopid as shopid, p1.productid as productid, p1.productprice as productprice
                                FROM prodproductprice p1
                                WHERE p1.id = (
                                    SELECT MAX(p2.id)
                                    FROM prodproductprice p2
                                    WHERE p2.shopid = p1.shopid AND p2.productid = p1.productid 
                                ) AND shopid IN ('8597665') AND productid IN ('400098936') ;

select * from  cart
            JOIN shop ON shop.shopid = cart.establishmentid 
            where cart.userid = '22270733'

[]

select
  *
from
  cart
  JOIN shop ON shop.shopid = cart.establishmentid
where
  cart.userid = '22270733'

select * from  cart
            JOIN shop ON shop.shopid = cart.establishmentid 
            where cart.userid = '22270733';