GET http://crm.proadvice-marketing.de/dashboard/upcoming-events

Response
200 OK
Browse referrer URL
IP
185.13.187.247
Profiled on
Token
f9efc8

Query Metrics

5 Database Queries
4 Different statements
5.99 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.81 ms 
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
Parameters: 
[
  "izab"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.50 ms 
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" = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.18 ms 
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
Parameters: 
[
  "izab"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.37 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM "CRM_Pro_Roles" t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.13 ms 
SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.type AS type_2, t0_."startAt" AS startat_3, t0_."endAt" AS endat_4, t0_."allDay" AS allday_5, t0_.description AS description_6, t0_.location AS location_7, t0_.color AS color_8, t0_.status AS status_9, t0_.attendees AS attendees_10, t0_."teamsLink" AS teamslink_11, t0_."hrmLeaveId" AS hrmleaveid_12, t0_."reminderSentAt" AS remindersentat_13, t0_."mandatory" AS mandatory_14, t0_."acceptedBy" AS acceptedby_15, t0_."createdAt" AS createdat_16, t0_."updatedAt" AS updatedat_17, t0_."createdById" AS createdbyid_18 FROM "CRM_Pro_Calendar_Events" t0_ WHERE t0_.status = ? AND t0_."startAt" >= ? AND t0_."startAt" <= ? AND t0_.type NOT IN (?, ?) ORDER BY t0_."startAt" ASC LIMIT 3
Parameters: 
[
  "active"
  "2026-04-20 00:00:00"
  "2026-04-27 00:00:00"
  "LEAVE"
  "SICK"
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 1
App\Entity\Role 1
App\Entity\EmployeeProfile 1
App\Entity\EmployeeContact 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\EmployeeProfile No errors.
App\Entity\Session No errors.
App\Entity\EmployeeContact No errors.
App\Entity\Permission No errors.
App\Entity\CalendarEvent No errors.