Symfony Profiler

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

Query Metrics

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

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

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

SELECT AES_DECRYPT(unhex('EBCDEED684C2AD433033C6605F7A42B25C2AD89A2428FEB1AF391A37973E5F6B6C9359FC6C8A35E08C654550E759A4FF'), 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;

SELECT t0.PGS_PageNum AS PGS_PageNum_1, t0.PGS_PageId AS PGS_PageId_2, t0.PGS_ModulePartId AS PGS_ModulePartId_3, t0.PGS_TopPageId AS PGS_TopPageId_4, t0.PGS_Page AS PGS_Page_5, t0.PGS_PageLink AS PGS_PageLink_6, t0.PGS_Ico AS PGS_Ico_7, t0.PGS_alma AS PGS_alma_8, t0.PGS_timestamp AS PGS_timestamp_9, t0.PGS_RolesId AS PGS_RolesId_10 FROM sp_pages t0 WHERE t0.PGS_PageLink = ? AND (t0.PGS_alma IN (?, ?) OR t0.PGS_alma IS NULL)

[
  "personelguncelle"
  ""
  null
]

SELECT
  t0.PGS_PageNum AS PGS_PageNum_1,
  t0.PGS_PageId AS PGS_PageId_2,
  t0.PGS_ModulePartId AS PGS_ModulePartId_3,
  t0.PGS_TopPageId AS PGS_TopPageId_4,
  t0.PGS_Page AS PGS_Page_5,
  t0.PGS_PageLink AS PGS_PageLink_6,
  t0.PGS_Ico AS PGS_Ico_7,
  t0.PGS_alma AS PGS_alma_8,
  t0.PGS_timestamp AS PGS_timestamp_9,
  t0.PGS_RolesId AS PGS_RolesId_10
FROM
  sp_pages t0
WHERE
  t0.PGS_PageLink = ?
  AND (
    t0.PGS_alma IN (?, ?)
    OR t0.PGS_alma IS NULL
  )

SELECT t0.PGS_PageNum AS PGS_PageNum_1, t0.PGS_PageId AS PGS_PageId_2, t0.PGS_ModulePartId AS PGS_ModulePartId_3, t0.PGS_TopPageId AS PGS_TopPageId_4, t0.PGS_Page AS PGS_Page_5, t0.PGS_PageLink AS PGS_PageLink_6, t0.PGS_Ico AS PGS_Ico_7, t0.PGS_alma AS PGS_alma_8, t0.PGS_timestamp AS PGS_timestamp_9, t0.PGS_RolesId AS PGS_RolesId_10 FROM sp_pages t0 WHERE t0.PGS_PageLink = 'personelguncelle' AND (t0.PGS_alma IN ('', NULL) OR t0.PGS_alma IS NULL);

SELECT t0.MDP_ModulePartNum AS MDP_ModulePartNum_1, t0.MDP_ModulePartId AS MDP_ModulePartId_2, t0.MDP_ModulePart AS MDP_ModulePart_3, t0.MDP_PartLink AS MDP_PartLink_4, t0.MDP_Queue AS MDP_Queue_5, t0.MDP_Ico AS MDP_Ico_6, t0.MDP_Video AS MDP_Video_7, t0.MDP_ActivePage AS MDP_ActivePage_8, t0.MDP_alma AS MDP_alma_9, t0.MDP_kim AS MDP_kim_10, t0.MDP_timestamp AS MDP_timestamp_11, t0.MDP_ModuleId AS MDP_ModuleId_12 FROM sp_moduleparts t0 WHERE t0.MDP_ModulePartId = ? AND (t0.MDP_alma IN (?, ?) OR t0.MDP_alma IS NULL) LIMIT 1

[
  100015
  ""
  null
]

SELECT
  t0.MDP_ModulePartNum AS MDP_ModulePartNum_1,
  t0.MDP_ModulePartId AS MDP_ModulePartId_2,
  t0.MDP_ModulePart AS MDP_ModulePart_3,
  t0.MDP_PartLink AS MDP_PartLink_4,
  t0.MDP_Queue AS MDP_Queue_5,
  t0.MDP_Ico AS MDP_Ico_6,
  t0.MDP_Video AS MDP_Video_7,
  t0.MDP_ActivePage AS MDP_ActivePage_8,
  t0.MDP_alma AS MDP_alma_9,
  t0.MDP_kim AS MDP_kim_10,
  t0.MDP_timestamp AS MDP_timestamp_11,
  t0.MDP_ModuleId AS MDP_ModuleId_12
FROM
  sp_moduleparts t0
WHERE
  t0.MDP_ModulePartId = ?
  AND (
    t0.MDP_alma IN (?, ?)
    OR t0.MDP_alma IS NULL
  )
LIMIT
  1

SELECT t0.MDP_ModulePartNum AS MDP_ModulePartNum_1, t0.MDP_ModulePartId AS MDP_ModulePartId_2, t0.MDP_ModulePart AS MDP_ModulePart_3, t0.MDP_PartLink AS MDP_PartLink_4, t0.MDP_Queue AS MDP_Queue_5, t0.MDP_Ico AS MDP_Ico_6, t0.MDP_Video AS MDP_Video_7, t0.MDP_ActivePage AS MDP_ActivePage_8, t0.MDP_alma AS MDP_alma_9, t0.MDP_kim AS MDP_kim_10, t0.MDP_timestamp AS MDP_timestamp_11, t0.MDP_ModuleId AS MDP_ModuleId_12 FROM sp_moduleparts t0 WHERE t0.MDP_ModulePartId = 100015 AND (t0.MDP_alma IN ('', NULL) OR t0.MDP_alma IS NULL) LIMIT 1;