Symfony Profiler

[
  "route" => "hrm_leave_requests_list"
  "route_parameters" => [
    "_route" => "hrm_leave_requests_list"
    "_controller" => "App\Controller\HrmController::leaveRequests"
  ]
  "request_uri" => "http://crm.proadvice-marketing.de/hrm/leave/requests?scope=team"
  "method" => "GET"
]

[
  "firewall_name" => "api"
  "authenticators" => 1
]

[
  "firewall_name" => "api"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 5432
    "user" => "crm_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "15"
    "defaultTableOptions" => []
    "dbname" => "crm"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "izab"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#699
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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" = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#701
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "izab"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#699
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM "CRM_Pro_Roles" t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#701
      +name: "INTEGER"
    }
  ]
]

[
  "token" => Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\Token\JWTPostAuthenticationToken {#867
    -user: App\Entity\User {#711 …}
    -roleNames: [
      "ROLE_ADMIN"
    ]
    -attributes: []
    -firewallName: "api"
    -token: "eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NzY3MTE4NzUsImV4cCI6MTc3Njc0MDY3NSwiaXNzIjoiY3JtLWhybS1wcm8iLCJhdWQiOiJjcm0taHJtLXByby1hcGkiLCJyb2xlcyI6WyJST0xFX0FETUlOIl0sInVzZXJuYW1lIjoiaXphYiIsInN5c3RlbUtleSI6ImU1MzY1N2ZkYjlmNzhmMWExOWQ1M2FmMDU4YmYyY2ZjMzQzMjljN2VkMmJhM2Y1YmFlNzliZTg5NTZmYWYxODgiLCJlbWFpbCI6Iml6YWIiLCJyb2xlIjoiQURNSU4ifQ.EiDnmTt0ziVZarIWZu2eYw8eZyyh8q50HPhOJwvJPNBJn-3fgEm-jsx896Bk9OFemEdpVcAD1Yif2JBJ2WRRU-H-YcZJCSc1H7T7U70vFh_UfA2kyrpmS_FAKsxgTMTWrxtnsadqYYAEa_km_HOayrKDUtkYYzCBPQLNUs6sDPNm7vSEYfNGJ2pLtYAXNvhFuN-7dJTZeoWOdP1OUQasj9hmvFbbxRXqTVf5N9QTD3qpixS1rVqZppxbP2E2ZEjMxgk5AnP33Lvrs6vWw9oUd3u4lSTz3an50RM_452wCmwCUPqZRMybeXITPZJ5n5wz9syBv3twvOJsfwAs9404xCdByGtqsAcgxKf7zWOgQjVGuxHCY7k0gh0Y58xYNLwDlY68tgH2yl-DMhJ34kiCsbM07_i5KR0MXtldUiWlM95v85OId73zcCr1jU3W04W2PNSonI6bXxUATKkO8x_Aw4DPEU_mlxbpewUB4Y9mYwnZs3IeXJR82IFVkRk4EBYMJrRiA4MN4kkbMaUm3KH-NYZVg0n5CneljUcFuFmuHhQUJ_2ApL8EVvIzqAHVo4InBbZIVokFUBeE3dJiTRVNihrXJwVnf-nXPYq-d3zDmJ58BdZMhLpldQDRr6ShZo1y2_wxxn8i1B29dGRiDdfgvJl7ldJ0Gk-8fye0fYTdjlk"
  }
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "authenticator" => "Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator"
]

[
  "sql" => "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_.email AS email_10, t1_."passwordHash" AS passwordhash_11, t1_."systemKey" AS systemkey_12, t1_.status AS status_13, t1_."forcePasswordChange" AS forcepasswordchange_14, t1_."lastLoginAt" AS lastloginat_15, t1_."failedLoginAttempts" AS failedloginattempts_16, t1_."firstName" AS firstname_17, t1_."lastName" AS lastname_18, t1_."avatarData" AS avatardata_19, t1_."createdAt" AS createdat_20, t1_."updatedAt" AS updatedat_21, t1_.locale AS locale_22, t2_.id AS id_23, t2_."employeeNumber" AS employeenumber_24, t2_.position AS position_25, t2_.department AS department_26, t2_."employmentDate" AS employmentdate_27, t2_."employmentStatus" AS employmentstatus_28, t2_."contractEndDate" AS contractenddate_29, t2_."contractType" AS contracttype_30, t2_."salaryGross" AS salarygross_31, t2_."workHoursPerWeek" AS workhoursperweek_32, t2_."annualLeaveLimit" AS annualleavelimit_33, t2_."hrmCanViewTeam" AS hrmcanviewteam_34, t2_."hrmCanApproveLeave" AS hrmcanapproveleave_35, t2_."hrmCanManageSick" AS hrmcanmanagesick_36, t2_."hrmCanUploadPayslip" AS hrmcanuploadpayslip_37, t2_."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_38, t2_."hrmCanManageEmployees" AS hrmcanmanageemployees_39, t2_."hrmCanApproveTime" AS hrmcanapprovetime_40, t2_."hrmCanEditTime" AS hrmcanedittime_41, t2_."createdAt" AS createdat_42, t2_."updatedAt" AS updatedat_43, t3_.id AS id_44, t3_.name AS name_45, t3_."annualLimitDays" AS annuallimitdays_46, t3_."requiresApproval" AS requiresapproval_47, t3_."approverRoles" AS approverroles_48, t3_.color AS color_49, t3_."isActive" AS isactive_50, t3_."nameTranslations" AS nametranslations_51, t3_."createdAt" AS createdat_52, t3_."updatedAt" AS updatedat_53, t0_."userId" AS userid_54, t0_."leaveTypeId" AS leavetypeid_55, t0_."approvedBy" AS approvedby_56, t1_."roleId" AS roleid_57, t2_."userId" AS userid_58, t2_."managerId" AS managerid_59 FROM "CRM_Pro_HRM_LeaveRequests" t0_ LEFT JOIN "CRM_Pro_Users" t1_ ON t0_."userId" = t1_.id LEFT JOIN "CRM_Pro_EmployeeProfiles" t2_ ON t1_.id = t2_."userId" LEFT JOIN "CRM_Pro_HRM_LeaveTypes" t3_ ON t0_."leaveTypeId" = t3_.id ORDER BY t0_."startDate" DESC"
]

[
  "sql" => "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" = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#701
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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" = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#701
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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" = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#701
      +name: "INTEGER"
    }
  ]
]