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 AES_DECRYPT(unhex(:Val), SHA2(:AesKey,:blockSize)) AS val

[
  "Val" => "1"
  "AesKey" => "2323232323"
  "blockSize" => "256"
]

SELECT
  AES_DECRYPT(
    unhex(:Val),
    SHA2(:AesKey, :blockSize)
  ) AS val

SELECT AES_DECRYPT(unhex('1'), SHA2('2323232323','256')) AS val;

SELECT t0.USR_UserNum AS USR_UserNum_1, t0.USR_UserId AS USR_UserId_2, t0.USR_UserName AS USR_UserName_3, t0.USR_Password AS USR_Password_4, t0.USR_Modules AS USR_Modules_5, t0.USR_Parts AS USR_Parts_6, t0.USR_Add AS USR_Add_7, t0.USR_Update AS USR_Update_8, t0.USR_List AS USR_List_9, t0.USR_Del AS USR_Del_10, t0.USR_LicenseCode AS USR_LicenseCode_11, t0.USR_LicenseVerifyCode AS USR_LicenseVerifyCode_12, t0.USR_LicenseTime AS USR_LicenseTime_13, t0.USR_alma AS USR_alma_14, t0.USR_kim AS USR_kim_15, t0.USR_timestamp AS USR_timestamp_16 FROM sp_users t0 WHERE t0.USR_UserId IS NULL AND t0.USR_UserName IS NULL AND t0.USR_Password IS NULL

[]

SELECT
  t0.USR_UserNum AS USR_UserNum_1,
  t0.USR_UserId AS USR_UserId_2,
  t0.USR_UserName AS USR_UserName_3,
  t0.USR_Password AS USR_Password_4,
  t0.USR_Modules AS USR_Modules_5,
  t0.USR_Parts AS USR_Parts_6,
  t0.USR_Add AS USR_Add_7,
  t0.USR_Update AS USR_Update_8,
  t0.USR_List AS USR_List_9,
  t0.USR_Del AS USR_Del_10,
  t0.USR_LicenseCode AS USR_LicenseCode_11,
  t0.USR_LicenseVerifyCode AS USR_LicenseVerifyCode_12,
  t0.USR_LicenseTime AS USR_LicenseTime_13,
  t0.USR_alma AS USR_alma_14,
  t0.USR_kim AS USR_kim_15,
  t0.USR_timestamp AS USR_timestamp_16
FROM
  sp_users t0
WHERE
  t0.USR_UserId IS NULL
  AND t0.USR_UserName IS NULL
  AND t0.USR_Password IS NULL

SELECT t0.USR_UserNum AS USR_UserNum_1, t0.USR_UserId AS USR_UserId_2, t0.USR_UserName AS USR_UserName_3, t0.USR_Password AS USR_Password_4, t0.USR_Modules AS USR_Modules_5, t0.USR_Parts AS USR_Parts_6, t0.USR_Add AS USR_Add_7, t0.USR_Update AS USR_Update_8, t0.USR_List AS USR_List_9, t0.USR_Del AS USR_Del_10, t0.USR_LicenseCode AS USR_LicenseCode_11, t0.USR_LicenseVerifyCode AS USR_LicenseVerifyCode_12, t0.USR_LicenseTime AS USR_LicenseTime_13, t0.USR_alma AS USR_alma_14, t0.USR_kim AS USR_kim_15, t0.USR_timestamp AS USR_timestamp_16 FROM sp_users t0 WHERE t0.USR_UserId IS NULL AND t0.USR_UserName IS NULL AND t0.USR_Password IS NULL;