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 u0_.id AS id_0, u0_.userid AS userid_1, u0_.username AS username_2, u0_.mobile AS mobile_3, u0_.email AS email_4, u0_.password AS password_5, u0_.createdtime AS createdtime_6 FROM user u0_ WHERE u0_.mobile = ? AND u0_.password = ?

[
  9597451585.0
  "checking1"
]

SELECT
  u0_.id AS id_0,
  u0_.userid AS userid_1,
  u0_.username AS username_2,
  u0_.mobile AS mobile_3,
  u0_.email AS email_4,
  u0_.password AS password_5,
  u0_.createdtime AS createdtime_6
FROM
  user u0_
WHERE
  u0_.mobile = ?
  AND u0_.password = ?

SELECT u0_.id AS id_0, u0_.userid AS userid_1, u0_.username AS username_2, u0_.mobile AS mobile_3, u0_.email AS email_4, u0_.password AS password_5, u0_.createdtime AS createdtime_6 FROM user u0_ WHERE u0_.mobile = 9597451585 AND u0_.password = 'checking1';

select areamaster.areaid as areaid, areamaster.areaname as userareaname from useraddress
                                            JOIN addresses ON addresses.addressid = useraddress.addressid
                                            JOIN areamaster ON areamaster.areaname = addresses.areaname
                                            where useraddress.userid = '22270733' and useraddress.defaultaddress = '1'

[]

select
  areamaster.areaid as areaid,
  areamaster.areaname as userareaname
from
  useraddress
  JOIN addresses ON addresses.addressid = useraddress.addressid
  JOIN areamaster ON areamaster.areaname = addresses.areaname
where
  useraddress.userid = '22270733'
  and useraddress.defaultaddress = '1'

select areamaster.areaid as areaid, areamaster.areaname as userareaname from useraddress
                                            JOIN addresses ON addresses.addressid = useraddress.addressid
                                            JOIN areamaster ON areamaster.areaname = addresses.areaname
                                            where useraddress.userid = '22270733' and useraddress.defaultaddress = '1'
                        ;

select * from useraddress where userid = '22270733' and defaultaddress = '1'

[]

select
  *
from
  useraddress
where
  userid = '22270733'
  and defaultaddress = '1'

select * from useraddress where userid = '22270733' and defaultaddress = '1';