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 * from shop 
            JOIN addresses ON addresses.addressid = shop.shopaddressid
            JOIN areamaster ON areamaster.areaname = addresses.areaname
            where areaid = '4534544' and shop.shopstatus = '0'

[]

select
  *
from
  shop
  JOIN addresses ON addresses.addressid = shop.shopaddressid
  JOIN areamaster ON areamaster.areaname = addresses.areaname
where
  areaid = '4534544'
  and shop.shopstatus = '0'

select * from shop 
            JOIN addresses ON addresses.addressid = shop.shopaddressid
            JOIN areamaster ON areamaster.areaname = addresses.areaname
            where areaid = '4534544' and shop.shopstatus = '0';

select * from shopimages where shopid IN ('6623686','6940376','8984461','5201476','5618906','2672720','8113188','6623686','6940376','8984461','5201476','5618906','2672720','8113188')

[]

select
  *
from
  shopimages
where
  shopid IN (
    '6623686', '6940376', '8984461', '5201476',
    '5618906', '2672720', '8113188',
    '6623686', '6940376', '8984461',
    '5201476', '5618906', '2672720',
    '8113188'
  )

select * from shopimages where shopid IN ('6623686','6940376','8984461','5201476','5618906','2672720','8113188','6623686','6940376','8984461','5201476','5618906','2672720','8113188');