Query Metrics

32 Database Queries
7 Different statements
20.32 ms Query time
2 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.note_start_display AS note_start_display_9, t0.display_previous_notes AS display_previous_notes_10, t0.calendar_color AS calendar_color_11 FROM `user` t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œ\x15ׂÅrÊ‚\x10³?Ó›q¹"
]
2 0.82 ms
SELECT a0_.uuid AS uuid_0, a0_.date_start AS date_start_1, a0_.date_end AS date_end_2, a0_.description AS description_3, a0_.address AS address_4, a0_.postal_code AS postal_code_5, a0_.city AS city_6, a0_.country AS country_7, a0_.status AS status_8, a0_.customer_uuid AS customer_uuid_9, a0_.lead_uuid AS lead_uuid_10, a0_.sale_rep_uuid AS sale_rep_uuid_11, a0_.created_by_uuid AS created_by_uuid_12, a0_.assigned_to_uuid AS assigned_to_uuid_13 FROM appointment a0_ INNER JOIN `user` u1_ ON a0_.sale_rep_uuid = u1_.uuid WHERE a0_.status NOT IN (?, ?, ?) AND u1_.uuid = ? AND (a0_.date_start BETWEEN ? AND ?)
Parameters:
[
  "aborded"
  "postponed"
  "cancelled"
  b"\x01œ\x15ׂÅrÊ‚\x10³?Ó›q¹"
  "2026-03-23 00:00:00"
  "2026-03-30 00:00:00"
]
3 0.40 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œŠ\x05úóp\x1F°Á¡µV\0˜"
]
4 0.38 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œŠ\x05úóp\x1F°Á¡µV\0˜"
]
5 0.68 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œŠ\x05úóp\x1F°Á¡µV\0˜"
]
6 0.42 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œá™|4p4¾­ü \x03xx"
]
7 0.30 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œá™|4p4¾­ü \x03xx"
]
8 0.43 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œá™|4p4¾­ü \x03xx"
]
9 0.33 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œ÷\r\x11tL®‹RI\x1Eœe"
]
10 0.27 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œ÷\r\x11tL®‹RI\x1Eœe"
]
11 0.36 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œ÷\r\x11tL®‹RI\x1Eœe"
]
12 0.33 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œøÐ_ÌrÚ©¿6¤®\x03£i"
]
13 0.44 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œøÐ_ÌrÚ©¿6¤®\x03£i"
]
14 0.38 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œøÐ_ÌrÚ©¿6¤®\x03£i"
]
15 1.19 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œü{vðpñ†ñ\eX\x05[—Ž"
]
16 0.33 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œü{vðpñ†ñ\eX\x05[—Ž"
]
17 0.38 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01œü{vðpñ†ñ\eX\x05[—Ž"
]
18 0.28 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x00zBzÖá²×ˆÈ˜"
]
19 0.26 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x00zBzÖá²×ˆÈ˜"
]
20 0.42 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x00zBzÖá²×ˆÈ˜"
]
21 0.25 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5 FROM appointment_signed t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x05Ž ÷uٝmÚ5:kFr"
]
22 0.27 ms
SELECT t0.uuid AS uuid_1, t0.reason AS reason_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.appointment_uuid AS appointment_uuid_5, t0.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_6 FROM appointment_cancelled t0 WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x05Ž ÷uٝmÚ5:kFr"
]
23 0.36 ms
SELECT t0.uuid AS uuid_1, t0.comment AS comment_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.address AS address_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.country AS country_11, t0.appointment_uuid AS appointment_uuid_12, t13.uuid AS uuid_14, t13.reason AS reason_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_18 FROM appointment_technical_visit t0 LEFT JOIN appointment_technical_visit_cancelled t13 ON t13.appointment_technical_visit_uuid = t0.uuid WHERE t0.appointment_uuid = ?
Parameters:
[
  b"\x01\x05Ž ÷uٝmÚ5:kFr"
]
24 0.34 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œzb{‘s1¥-[\x05j¡*\x1E"
]
25 0.34 ms
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.note_start_display AS note_start_display_9, t0.display_previous_notes AS display_previous_notes_10, t0.calendar_color AS calendar_color_11 FROM `user` t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œ\x1ARéÌp²žb5|ÎäK\x01"
]
26 0.33 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œá‹R/q=„ðKF_¥[0"
]
27 1.93 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œ÷|°xr˃|*&ëëZ}"
]
28 1.12 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œ½¹ƒŸpÿ‡—º\x17„­·‹"
]
29 1.03 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01œüpÒ\x17{øšê8Èã¤\x1CJ"
]
30 0.39 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01\x00l—È}öÀÁ>¥g"
]
31 4.29 ms
SELECT t0.uuid AS uuid_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.phone AS phone_4, t0.address AS address_5, t0.city AS city_6, t0.postal_code AS postal_code_7, t0.country AS country_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.sales_rep_uuid AS sales_rep_uuid_12, t0.telemarketer_uuid AS telemarketer_uuid_13 FROM customer t0 WHERE t0.uuid = ?
Parameters:
[
  b"\x01\x05yà7~•¨`%\x05¢sí\v"
]
32 0.76 ms
SELECT a0_.uuid AS uuid_0, a0_.comment AS comment_1, a0_.date_start AS date_start_2, a0_.date_end AS date_end_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.status AS status_6, a0_.address AS address_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.appointment_uuid AS appointment_uuid_11 FROM appointment_technical_visit a0_ INNER JOIN appointment a1_ ON a0_.appointment_uuid = a1_.uuid INNER JOIN `user` u2_ ON a1_.sale_rep_uuid = u2_.uuid WHERE a0_.date_start IS NOT NULL AND a0_.date_end IS NOT NULL AND a0_.status NOT IN (?, ?) AND u2_.uuid = ? AND (a0_.date_start BETWEEN ? AND ?)
Parameters:
[
  "aborded"
  "postponed"
  b"\x01œ\x15ׂÅrÊ‚\x10³?Ó›q¹"
  "2026-03-23 00:00:00"
  "2026-03-30 00:00:00"
]

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\Infrastructure\Persistence\Doctrine\Entity\Appointment 7
App\Infrastructure\Persistence\Doctrine\Entity\Customer 7
App\Infrastructure\Persistence\Doctrine\Entity\Lead 5
App\Infrastructure\Persistence\Doctrine\Entity\User 2

Entities Mapping

Class Mapping errors
App\Infrastructure\Persistence\Doctrine\Entity\User
  • The mappings App\Infrastructure\Persistence\Doctrine\Entity\User#appointements and App\Infrastructure\Persistence\Doctrine\Entity\Appointment#assignedTo are inconsistent with each other.
App\Infrastructure\Persistence\Doctrine\Entity\Platform No errors.
App\Infrastructure\Persistence\Doctrine\Entity\Lead No errors.
App\Infrastructure\Persistence\Doctrine\Entity\Appointment
  • The association App\Infrastructure\Persistence\Doctrine\Entity\Appointment#createdBy refers to the inverse side field App\Infrastructure\Persistence\Doctrine\Entity\User#appointmentsCreated which does not exist.
  • The association App\Infrastructure\Persistence\Doctrine\Entity\Appointment#assignedTo refers to the inverse side field App\Infrastructure\Persistence\Doctrine\Entity\User#appointments which does not exist.
App\Infrastructure\Persistence\Doctrine\Entity\Customer No errors.
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentSigned No errors.
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentCancelled No errors.
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentTechnicalVisit No errors.
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentTechnicalVisitCancelled No errors.
App\Infrastructure\Persistence\Doctrine\Entity\Note No errors.
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentPostponed No errors.