Query Metrics

42 Database Queries
9 Different statements
14.53 ms Query time
2 Invalid entities
30 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 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.70 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-16 00:00:00"
  "2026-03-23 00:00:00"
]
3 0.41 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œÓ\x06V{~»¹Éfû\x18\x18¦Ç"
]
4 0.39 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œÓ\x06V{~»¹Éfû\x18\x18¦Ç"
]
5 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œÓ\x06V{~»¹Éfû\x18\x18¦Ç"
]
6 0.37 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œÓa\x18m\x7F\x18Ò±Å¿ï’"
]
7 0.28 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œÓa\x18m\x7F\x18Ò±Å¿ï’"
]
8 0.37 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œÓa\x18m\x7F\x18Ò±Å¿ï’"
]
9 0.31 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œÝ\x0FV\x18w9¥µž­Ï»\x01\x0E"
]
10 0.29 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œÝ\x0FV\x18w9¥µž­Ï»\x01\x0E"
]
11 0.34 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œÝ\x0FV\x18w9¥µž­Ï»\x01\x0E"
]
12 0.35 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œâ4Ÿ\x1Dzô§\x01Ö%¦ÒË®"
]
13 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œâ4Ÿ\x1Dzô§\x01Ö%¦ÒË®"
]
14 0.32 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œâ4Ÿ\x1Dzô§\x01Ö%¦ÒË®"
]
15 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œâq†[\x7F\x13–Kžjah;"
]
16 0.28 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œâq†[\x7F\x13–Kžjah;"
]
17 0.33 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œâq†[\x7F\x13–Kžjah;"
]
18 0.27 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œæM\x1FepבåŸV±\x0E'“"
]
19 0.29 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œæM\x1FepבåŸV±\x0E'“"
]
20 0.34 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œæM\x1FepבåŸV±\x0E'“"
]
21 0.29 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îE}\x0F· S:‚´øÚ"
]
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œç\vîE}\x0F· S:‚´øÚ"
]
23 0.35 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îE}\x0F· S:‚´øÚ"
]
24 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œñpõåv\x0E³[©'˜ŒCU"
]
25 0.25 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œñpõåv\x0E³[©'˜ŒCU"
]
26 0.32 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œñpõåv\x0E³[©'˜ŒCU"
]
27 0.39 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\x14Ðl\x01x7¥\'çuÛäî"
]
28 0.28 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\x14Ðl\x01x7¥\'çuÛäî"
]
29 0.31 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\x14Ðl\x01x7¥\'çuÛäî"
]
30 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œÒùüÆxy¿µùù\x7F\x15\x08"
]
31 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"
]
32 0.30 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œÒûÅ}~¼tðb~w»"
]
33 0.50 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œÜ/Îdrع\x02w6«@¾à"
]
34 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œ™Œ;¸|FÀÍoü[a²"
]
35 0.32 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œ˜ý©à{5\x06Z÷˜DC<"
]
36 0.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œæ?f\x07u¤‡0òó;ÇÕK"
]
37 0.28 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œ×s°xvW©^à\x15œÑá\x01"
]
38 0.31 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„­·‹"
]
39 0.50 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-16 00:00:00"
  "2026-03-23 00:00:00"
]
40 0.34 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_technical_visit_uuid AS appointment_technical_visit_uuid_5 FROM appointment_technical_visit_cancelled t0 WHERE t0.appointment_technical_visit_uuid = ?
Parameters:
[
  b"\x01œæê\x05)|G¨Dv†)MŰ"
]
41 0.54 ms
SELECT t0.uuid AS uuid_1, t0.date_start AS date_start_2, t0.date_end AS date_end_3, t0.description AS description_4, t0.address AS address_5, t0.postal_code AS postal_code_6, t0.city AS city_7, t0.country AS country_8, t0.status AS status_9, t0.customer_uuid AS customer_uuid_10, t0.lead_uuid AS lead_uuid_11, t0.sale_rep_uuid AS sale_rep_uuid_12, t13.uuid AS uuid_14, t13.comment AS comment_15, t13.created_at AS created_at_16, t13.updated_at AS updated_at_17, t13.appointment_uuid AS appointment_uuid_18, t19.uuid AS uuid_20, t19.reason AS reason_21, t19.created_at AS created_at_22, t19.updated_at AS updated_at_23, t19.appointment_uuid AS appointment_uuid_24, t19.appointment_technical_visit_uuid AS appointment_technical_visit_uuid_25, t26.uuid AS uuid_27, t26.comment AS comment_28, t26.date_start AS date_start_29, t26.date_end AS date_end_30, t26.created_at AS created_at_31, t26.updated_at AS updated_at_32, t26.status AS status_33, t26.address AS address_34, t26.postal_code AS postal_code_35, t26.city AS city_36, t26.country AS country_37, t26.appointment_uuid AS appointment_uuid_38, t0.created_by_uuid AS created_by_uuid_39, t0.assigned_to_uuid AS assigned_to_uuid_40 FROM appointment t0 LEFT JOIN appointment_signed t13 ON t13.appointment_uuid = t0.uuid LEFT JOIN appointment_cancelled t19 ON t19.appointment_uuid = t0.uuid LEFT JOIN appointment_technical_visit t26 ON t26.appointment_uuid = t0.uuid WHERE t0.uuid = ?
Parameters:
[
  b"\x01œz­G0z¥ƒ0\x19QÅ6¶&"
]
42 0.37 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œMy)\x1Cp'‡V\x1EÏ~µgø"
]

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 10
App\Infrastructure\Persistence\Doctrine\Entity\Customer 9
App\Infrastructure\Persistence\Doctrine\Entity\Lead 6
App\Infrastructure\Persistence\Doctrine\Entity\User 2
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentSigned 2
App\Infrastructure\Persistence\Doctrine\Entity\AppointmentTechnicalVisit 1

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.