Query Metrics
161
Database Queries
27
Different statements
28.18 ms
Query time
0
Invalid entities
288
Managed entities
Grouped Statements
master connection
| Time▼ | Count | Info |
|---|---|---|
|
0.62 ms (2.21%) |
1 |
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:
[
"9UGF5"
]
|
|
0.30 ms (1.06%) |
1 |
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:
[
"5"
]
|
|
0.24 ms (0.85%) |
1 |
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:
[
5
]
|
slave connection
| Time▼ | Count | Info |
|---|---|---|
|
4.23 ms (15.00%) |
30 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.slug AS slug_3, t0.priority AS priority_4, t0.category_id AS category_id_5 FROM bee_s_permission t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2.85 ms (10.10%) |
16 |
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:
[
73
]
|
|
2.57 ms (9.11%) |
16 |
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:
[
73
]
|
|
2.56 ms (9.08%) |
16 |
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:
[
73
]
|
|
2.56 ms (9.08%) |
16 |
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:
[
73
]
|
|
2.36 ms (8.36%) |
16 |
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:
[
73
]
|
|
2.35 ms (8.32%) |
16 |
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:
[
73
]
|
|
2.31 ms (8.19%) |
16 |
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:
[
73
]
|
|
1.08 ms (3.83%) |
1 |
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 >= ?) AND b6_.id = ? ORDER BY b0_.start_date DESC
Parameters:
[ 0 "2026-03-17 15:01:04" "4" ] |
|
0.83 ms (2.94%) |
1 |
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 < ?) AND b6_.id = ? ORDER BY b0_.start_date DESC
Parameters:
[ 0 "2026-03-17 15:01:04" "4" ] |
|
0.53 ms (1.87%) |
1 |
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 b6_.id = ? ORDER BY b0_.start_date DESC
Parameters:
[ 1 "4" ] |
|
0.33 ms (1.16%) |
1 |
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:
[] |
|
0.31 ms (1.11%) |
1 |
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:
[] |
|
0.30 ms (1.06%) |
1 |
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:
[] |
|
0.24 ms (0.86%) |
1 |
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:
[
"mfolegatti@rpgmultimedia.it"
]
|
|
0.24 ms (0.85%) |
1 |
SELECT t0.id AS id_1, t0.rw AS rw_2, t0.permission_id AS permission_id_3, t0.staff_id AS staff_id_4 FROM bee_s_jt_staff_permission t0 WHERE t0.staff_id = ?
Parameters:
[
4
]
|
|
0.23 ms (0.81%) |
1 |
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:
[] |
|
0.20 ms (0.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_procedure t0
Parameters:
[] |
|
0.19 ms (0.67%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2 FROM bee_s_performance_type t0
Parameters:
[] |
|
0.17 ms (0.60%) |
1 |
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:
[] |
|
0.16 ms (0.57%) |
1 |
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:
[] |
|
0.15 ms (0.53%) |
1 |
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_performance_type b0_ ORDER BY b0_.value ASC
Parameters:
[] |
|
0.15 ms (0.52%) |
1 |
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:
[] |
|
0.15 ms (0.52%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.color AS color_3 FROM bee_s_tag t0
Parameters:
[] |
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 | 102 |
| App\Entity\Slave\JoinTableStaffPerformance | 48 |
| App\Entity\Slave\JoinTableStaffPermission | 30 |
| App\Entity\Slave\Permission | 30 |
| App\Entity\Slave\Performance | 23 |
| App\Entity\Slave\Marker | 16 |
| App\Entity\Slave\Tag | 13 |
| App\Entity\Slave\Procedure | 7 |
| App\Entity\Slave\Staff | 6 |
| App\Entity\Slave\PermissionCategory | 5 |
| App\Entity\Slave\PerformanceType | 5 |
Entities Mapping
master entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Master\Company | No errors. |
| App\Entity\Master\CompanyType | No errors. |
| App\Entity\Master\CompanyContact | No errors. |
| App\Entity\Master\License | No errors. |
| App\Entity\Master\JoinTableCompanyUser | No errors. |
| App\Entity\Master\LicenseType | No errors. |