Query Metrics

104 Database Queries
25 Different statements
19.54 ms Query time
0 Invalid entities
195 Managed entities

Queries

Group similar statements

master connection

# Time Info
1 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.email AS email_4, t0.city AS city_5, t0.zip AS zip_6, t0.province AS province_7, t0.vat_country AS vat_country_8, t0.vat AS vat_9, t0.fiscal_code AS fiscal_code_10, t0.sdi AS sdi_11, t0.directory_path AS directory_path_12, t0.logo_path AS logo_path_13, t0.creation_date AS creation_date_14, t0.db_name AS db_name_15, t0.code AS code_16, t0.slug AS slug_17, t0.is_admin_active AS is_admin_active_18, t0.type_id AS type_id_19 FROM bee_m_company t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "MEFN12"
]
2 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.email AS email_4, t0.city AS city_5, t0.zip AS zip_6, t0.province AS province_7, t0.vat_country AS vat_country_8, t0.vat AS vat_9, t0.fiscal_code AS fiscal_code_10, t0.sdi AS sdi_11, t0.directory_path AS directory_path_12, t0.logo_path AS logo_path_13, t0.creation_date AS creation_date_14, t0.db_name AS db_name_15, t0.code AS code_16, t0.slug AS slug_17, t0.is_admin_active AS is_admin_active_18, t0.type_id AS type_id_19 FROM bee_m_company t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "12"
]
3 0.25 ms
SELECT t0.id AS id_1, t0.date_invoice AS date_invoice_2, t0.date_start AS date_start_3, t0.date_expiration AS date_expiration_4, t0.is_active AS is_active_5, t0.type_id AS type_id_6, t0.company_id AS company_id_7 FROM bee_m_license t0 WHERE t0.company_id = ?
Parameters:
[
  12
]

slave connection

# Time Info
1 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.directory_path AS directory_path_7, t0.role AS role_8, t0.emergency_contact_1 AS emergency_contact_1_9, t0.emergency_contact_2 AS emergency_contact_2_10, t0.is_admin_active AS is_admin_active_11, t0.is_active AS is_active_12, t0.is_tutorial_active AS is_tutorial_active_13, t0.datetime_creation AS datetime_creation_14, t0.one_time_code AS one_time_code_15, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16, t0.image_path AS image_path_17, t0.is_anonimized AS is_anonimized_18, t0.is_company_admin AS is_company_admin_19 FROM bee_s_staff t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "qc@slmmilano.com"
]
2 0.62 ms
SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.name AS name_3, b0_.amount AS amount_4, b0_.completed_percentage AS completed_percentage_5, b0_.drive_link AS drive_link_6, b0_.client_notes AS client_notes_7, b0_.staff_notes AS staff_notes_8, b0_.archive_notes AS archive_notes_9, b0_.is_archived AS is_archived_10, b0_.is_ignore_sync AS is_ignore_sync_11, b0_.client_id AS client_id_12, b0_.type_id AS type_id_13, b0_.procedure_id AS procedure_id_14, b0_.marker_id AS marker_id_15 FROM bee_s_performance b0_ LEFT JOIN bee_s_client b1_ ON b0_.client_id = b1_.id LEFT JOIN bee_s_marker b2_ ON b0_.marker_id = b2_.id LEFT JOIN bee_s_performance_type b3_ ON b0_.type_id = b3_.id LEFT JOIN bee_s_procedure b4_ ON b0_.procedure_id = b4_.id LEFT JOIN bee_s_jt_staff_performance b5_ ON b0_.id = b5_.performance_id LEFT JOIN bee_s_staff b6_ ON b5_.staff_id = b6_.id LEFT JOIN bee_s_jt_performance_tag b8_ ON b0_.id = b8_.performance_id LEFT JOIN bee_s_tag b7_ ON b7_.id = b8_.tag_id LEFT JOIN bee_s_jt_client_referent b9_ ON b1_.id = b9_.client_id WHERE b0_.is_archived = ? AND (b0_.completed_percentage < 100 OR b0_.completed_percentage IS NULL) AND (b0_.end_date IS NULL OR b0_.end_date >= ?) ORDER BY b0_.start_date DESC
Parameters:
[
  0
  "2026-03-17 18:32:11"
]
3 0.47 ms
SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.name AS name_3, b0_.amount AS amount_4, b0_.completed_percentage AS completed_percentage_5, b0_.drive_link AS drive_link_6, b0_.client_notes AS client_notes_7, b0_.staff_notes AS staff_notes_8, b0_.archive_notes AS archive_notes_9, b0_.is_archived AS is_archived_10, b0_.is_ignore_sync AS is_ignore_sync_11, b0_.client_id AS client_id_12, b0_.type_id AS type_id_13, b0_.procedure_id AS procedure_id_14, b0_.marker_id AS marker_id_15 FROM bee_s_performance b0_ LEFT JOIN bee_s_client b1_ ON b0_.client_id = b1_.id LEFT JOIN bee_s_marker b2_ ON b0_.marker_id = b2_.id LEFT JOIN bee_s_performance_type b3_ ON b0_.type_id = b3_.id LEFT JOIN bee_s_procedure b4_ ON b0_.procedure_id = b4_.id LEFT JOIN bee_s_jt_staff_performance b5_ ON b0_.id = b5_.performance_id LEFT JOIN bee_s_staff b6_ ON b5_.staff_id = b6_.id LEFT JOIN bee_s_jt_performance_tag b8_ ON b0_.id = b8_.performance_id LEFT JOIN bee_s_tag b7_ ON b7_.id = b8_.tag_id LEFT JOIN bee_s_jt_client_referent b9_ ON b1_.id = b9_.client_id WHERE b0_.is_archived = ? AND (b0_.completed_percentage = 100 OR b0_.end_date < ?) ORDER BY b0_.start_date DESC
Parameters:
[
  0
  "2026-03-17 18:32:11"
]
4 0.34 ms
SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.name AS name_3, b0_.amount AS amount_4, b0_.completed_percentage AS completed_percentage_5, b0_.drive_link AS drive_link_6, b0_.client_notes AS client_notes_7, b0_.staff_notes AS staff_notes_8, b0_.archive_notes AS archive_notes_9, b0_.is_archived AS is_archived_10, b0_.is_ignore_sync AS is_ignore_sync_11, b0_.client_id AS client_id_12, b0_.type_id AS type_id_13, b0_.procedure_id AS procedure_id_14, b0_.marker_id AS marker_id_15 FROM bee_s_performance b0_ LEFT JOIN bee_s_client b1_ ON b0_.client_id = b1_.id LEFT JOIN bee_s_marker b2_ ON b0_.marker_id = b2_.id LEFT JOIN bee_s_performance_type b3_ ON b0_.type_id = b3_.id LEFT JOIN bee_s_procedure b4_ ON b0_.procedure_id = b4_.id LEFT JOIN bee_s_jt_staff_performance b5_ ON b0_.id = b5_.performance_id LEFT JOIN bee_s_staff b6_ ON b5_.staff_id = b6_.id LEFT JOIN bee_s_jt_performance_tag b8_ ON b0_.id = b8_.performance_id LEFT JOIN bee_s_tag b7_ ON b7_.id = b8_.tag_id LEFT JOIN bee_s_jt_client_referent b9_ ON b1_.id = b9_.client_id WHERE b0_.is_archived = ? ORDER BY b0_.start_date DESC
Parameters:
[
  1
]
5 0.29 ms
SELECT b0_.id AS id_0, b0_.value AS value_1, b0_.color AS color_2 FROM bee_s_tag b0_ ORDER BY b0_.value ASC
Parameters:
[]
6 0.23 ms
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.vat AS vat_3, t0.fiscal_code AS fiscal_code_4, t0.sdi AS sdi_5 FROM bee_s_client t0
Parameters:
[]
7 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2 FROM bee_s_performance_type t0
Parameters:
[]
8 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_procedure t0
Parameters:
[]
9 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.directory_path AS directory_path_7, t0.role AS role_8, t0.emergency_contact_1 AS emergency_contact_1_9, t0.emergency_contact_2 AS emergency_contact_2_10, t0.is_admin_active AS is_admin_active_11, t0.is_active AS is_active_12, t0.is_tutorial_active AS is_tutorial_active_13, t0.datetime_creation AS datetime_creation_14, t0.one_time_code AS one_time_code_15, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16, t0.image_path AS image_path_17, t0.is_anonimized AS is_anonimized_18, t0.is_company_admin AS is_company_admin_19 FROM bee_s_staff t0
Parameters:
[]
10 0.14 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0
Parameters:
[]
11 0.15 ms
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.value AS value_3, t0.color AS color_4, t0.is_alarm AS is_alarm_5 FROM bee_s_marker t0
Parameters:
[]
12 0.22 ms
SELECT b0_.id AS id_0, b0_.business_name AS business_name_1, b0_.vat AS vat_2, b0_.fiscal_code AS fiscal_code_3, b0_.sdi AS sdi_4 FROM bee_s_client b0_ ORDER BY b0_.business_name ASC
Parameters:
[]
13 0.15 ms
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_performance_type b0_ ORDER BY b0_.value ASC
Parameters:
[]
14 0.18 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.description AS description_2 FROM bee_s_procedure b0_ ORDER BY b0_.name ASC
Parameters:
[]
15 0.16 ms
SELECT b0_.id AS id_0, b0_.priority AS priority_1, b0_.value AS value_2, b0_.color AS color_3, b0_.is_alarm AS is_alarm_4 FROM bee_s_marker b0_ ORDER BY b0_.priority ASC
Parameters:
[]
16 0.27 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  33
]
17 0.21 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  33
]
18 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  33
]
19 0.17 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  32
]
20 0.21 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  32
]
21 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  32
]
22 0.19 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  30
]
23 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  30
]
24 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  30
]
25 0.19 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  29
]
26 0.16 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  29
]
27 0.21 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  29
]
28 0.21 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  35
]
29 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  35
]
30 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  35
]
31 0.20 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  26
]
32 0.21 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  26
]
33 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  26
]
34 0.16 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  27
]
35 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  27
]
36 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  27
]
37 0.18 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  25
]
38 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  25
]
39 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  25
]
40 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  25
]
41 0.16 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  25
]
42 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  25
]
43 0.17 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  13
]
44 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  13
]
45 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  13
]
46 0.16 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  3
]
47 0.18 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  3
]
48 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  3
]
49 0.13 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  4
]
50 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  4
]
51 0.21 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  4
]
52 0.20 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  6
]
53 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  6
]
54 0.23 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  6
]
55 0.17 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  11
]
56 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  11
]
57 0.18 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  11
]
58 0.17 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  22
]
59 0.22 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  22
]
60 0.21 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  22
]
61 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  22
]
62 0.18 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  22
]
63 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  22
]
64 0.15 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
65 0.19 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  31
]
66 0.21 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
67 0.19 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
68 0.15 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
69 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
70 0.14 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.notes AS notes_3, t0.performance_id AS performance_id_4, t0.type_id AS type_id_5 FROM bee_s_cost t0 WHERE t0.performance_id = ?
Parameters:
[
  31
]
71 0.15 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
72 0.16 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  2
]
73 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
74 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
75 0.13 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
76 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
77 0.13 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.notes AS notes_3, t0.performance_id AS performance_id_4, t0.type_id AS type_id_5 FROM bee_s_cost t0 WHERE t0.performance_id = ?
Parameters:
[
  2
]
78 0.13 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  7
]
79 0.14 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  7
]
80 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  7
]
81 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  7
]
82 0.10 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  7
]
83 0.10 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  7
]
84 0.14 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  23
]
85 0.15 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  23
]
86 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  23
]
87 0.12 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  23
]
88 0.13 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  23
]
89 0.13 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  23
]
90 0.13 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  8
]
91 0.17 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  8
]
92 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  8
]
93 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  8
]
94 0.13 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  8
]
95 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  8
]
96 0.13 ms
SELECT t0.id AS id_1, t0.performance_id AS performance_id_2, t0.staff_id AS staff_id_3 FROM bee_s_jt_staff_performance t0 WHERE t0.performance_id = ?
Parameters:
[
  9
]
97 0.15 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0 INNER JOIN bee_s_jt_performance_tag ON t0.id = bee_s_jt_performance_tag.tag_id WHERE bee_s_jt_performance_tag.performance_id = ?
Parameters:
[
  9
]
98 0.17 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.is_hour AS is_hour_4, t0.amount AS amount_5, t0.notes AS notes_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_activity t0 WHERE t0.performance_id = ?
Parameters:
[
  9
]
99 0.14 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.notes AS notes_4, t0.is_approved AS is_approved_5, t0.is_paid AS is_paid_6, t0.staff_id AS staff_id_7, t0.performance_id AS performance_id_8, t0.type_id AS type_id_9 FROM bee_s_reimbursement t0 WHERE t0.performance_id = ?
Parameters:
[
  9
]
100 0.13 ms
SELECT t0.id AS id_1, t0.text AS text_2, t0.datetime AS datetime_3, t0.id_sender AS id_sender_4, t0.performance_id AS performance_id_5 FROM bee_s_performance_message t0 WHERE t0.performance_id = ?
Parameters:
[
  9
]
101 0.10 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.performance_id = ?
Parameters:
[
  9
]

Database Connections

Name Service
master doctrine.dbal.master_connection
slave doctrine.dbal.slave_connection

Entity Managers

Name Service
master doctrine.orm.master_entity_manager
slave doctrine.orm.slave_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

master entity manager

Class Amount of managed objects
App\Entity\Master\Company 1
App\Entity\Master\License 1
App\Entity\Master\LicenseType 1

slave entity manager

Class Amount of managed objects
App\Entity\Slave\Client 42
App\Entity\Slave\Performance 35
App\Entity\Slave\Activity 30
App\Entity\Slave\Procedure 20
App\Entity\Slave\JoinTableStaffPerformance 20
App\Entity\Slave\ActivityType 14
App\Entity\Slave\Marker 10
App\Entity\Slave\Tag 8
App\Entity\Slave\Reminder 7
App\Entity\Slave\PerformanceType 5
App\Entity\Slave\Staff 1