Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0."passwordHash" AS passwordhash_3,
  t0."systemKey" AS systemkey_4,
  t0.status AS status_5,
  t0."forcePasswordChange" AS forcepasswordchange_6,
  t0."lastLoginAt" AS lastloginat_7,
  t0."failedLoginAttempts" AS failedloginattempts_8,
  t0."firstName" AS firstname_9,
  t0."lastName" AS lastname_10,
  t0."avatarData" AS avatardata_11,
  t0."createdAt" AS createdat_12,
  t0."updatedAt" AS updatedat_13,
  t0.locale AS locale_14,
  t0."roleId" AS roleid_15,
  t16.id AS id_17,
  t16."employeeNumber" AS employeenumber_18,
  t16.position AS position_19,
  t16.department AS department_20,
  t16."employmentDate" AS employmentdate_21,
  t16."employmentStatus" AS employmentstatus_22,
  t16."contractEndDate" AS contractenddate_23,
  t16."contractType" AS contracttype_24,
  t16."salaryGross" AS salarygross_25,
  t16."workHoursPerWeek" AS workhoursperweek_26,
  t16."annualLeaveLimit" AS annualleavelimit_27,
  t16."hrmCanViewTeam" AS hrmcanviewteam_28,
  t16."hrmCanApproveLeave" AS hrmcanapproveleave_29,
  t16."hrmCanManageSick" AS hrmcanmanagesick_30,
  t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31,
  t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32,
  t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33,
  t16."hrmCanApproveTime" AS hrmcanapprovetime_34,
  t16."hrmCanEditTime" AS hrmcanedittime_35,
  t16."createdAt" AS createdat_36,
  t16."updatedAt" AS updatedat_37,
  t16."userId" AS userid_38,
  t16."managerId" AS managerid_39
FROM
  "CRM_Pro_Users" t0
  LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = 'izab' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_."startDate" AS startdate_1,
  t0_."endDate" AS enddate_2,
  t0_."daysRequested" AS daysrequested_3,
  t0_.status AS status_4,
  t0_."approvedAt" AS approvedat_5,
  t0_.comment AS comment_6,
  t0_."createdAt" AS createdat_7,
  t0_."updatedAt" AS updatedat_8,
  t1_.id AS id_9,
  t1_.name AS name_10,
  t1_."annualLimitDays" AS annuallimitdays_11,
  t1_."requiresApproval" AS requiresapproval_12,
  t1_."approverRoles" AS approverroles_13,
  t1_.color AS color_14,
  t1_."isActive" AS isactive_15,
  t1_."nameTranslations" AS nametranslations_16,
  t1_."createdAt" AS createdat_17,
  t1_."updatedAt" AS updatedat_18,
  t0_."userId" AS userid_19,
  t0_."leaveTypeId" AS leavetypeid_20,
  t0_."approvedBy" AS approvedby_21
FROM
  "CRM_Pro_HRM_LeaveRequests" t0_
  LEFT JOIN "CRM_Pro_HRM_LeaveTypes" t1_ ON t0_."leaveTypeId" = t1_.id
WHERE
  t0_."userId" = ?
ORDER BY
  t0_."startDate" DESC

SELECT t0_.id AS id_0, t0_."startDate" AS startdate_1, t0_."endDate" AS enddate_2, t0_."daysRequested" AS daysrequested_3, t0_.status AS status_4, t0_."approvedAt" AS approvedat_5, t0_.comment AS comment_6, t0_."createdAt" AS createdat_7, t0_."updatedAt" AS updatedat_8, t1_.id AS id_9, t1_.name AS name_10, t1_."annualLimitDays" AS annuallimitdays_11, t1_."requiresApproval" AS requiresapproval_12, t1_."approverRoles" AS approverroles_13, t1_.color AS color_14, t1_."isActive" AS isactive_15, t1_."nameTranslations" AS nametranslations_16, t1_."createdAt" AS createdat_17, t1_."updatedAt" AS updatedat_18, t0_."userId" AS userid_19, t0_."leaveTypeId" AS leavetypeid_20, t0_."approvedBy" AS approvedby_21 FROM "CRM_Pro_HRM_LeaveRequests" t0_ LEFT JOIN "CRM_Pro_HRM_LeaveTypes" t1_ ON t0_."leaveTypeId" = t1_.id WHERE t0_."userId" = 5 ORDER BY t0_."startDate" DESC;

SELECT
  t0.id AS id_1,
  t0."companyEmail" AS companyemail_2,
  t0."privateEmail" AS privateemail_3,
  t0."companyPhone" AS companyphone_4,
  t0."privatePhone" AS privatephone_5,
  t0.location AS location_6,
  t0."emergencyName" AS emergencyname_7,
  t0."emergencyPhone" AS emergencyphone_8,
  t0."updatedAt" AS updatedat_9,
  t0."profileId" AS profileid_10
FROM
  "CRM_Pro_EmployeeContacts" t0
WHERE
  t0."profileId" = ?

SELECT t0.id AS id_1, t0."companyEmail" AS companyemail_2, t0."privateEmail" AS privateemail_3, t0."companyPhone" AS companyphone_4, t0."privatePhone" AS privatephone_5, t0.location AS location_6, t0."emergencyName" AS emergencyname_7, t0."emergencyPhone" AS emergencyphone_8, t0."updatedAt" AS updatedat_9, t0."profileId" AS profileid_10 FROM "CRM_Pro_EmployeeContacts" t0 WHERE t0."profileId" = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  "CRM_Pro_Roles" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM "CRM_Pro_Roles" t0 WHERE t0.id = 1;