POST https://www.beeorganized.it/staff/anagrafiche/clienti/scheda/40/scheda-prestazione/33

Query Metrics

16 Database Queries
15 Different statements
4.23 ms Query time
0 Invalid entities
16 Managed entities

Grouped Statements

Show all queries

master connection

Time Count Info
0.63 ms
(14.97%)
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:
[
  "MEFN12"
]
0.29 ms
(6.85%)
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:
[
  "12"
]
0.23 ms
(5.41%)
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:
[
  12
]

slave connection

Time Count Info
0.53 ms
(12.42%)
1
"COMMIT"
Parameters:
[]
0.43 ms
(10.13%)
2
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.name AS name_4, t0.amount AS amount_5, t0.completed_percentage AS completed_percentage_6, t0.drive_link AS drive_link_7, t0.client_notes AS client_notes_8, t0.staff_notes AS staff_notes_9, t0.archive_notes AS archive_notes_10, t0.is_archived AS is_archived_11, t0.is_ignore_sync AS is_ignore_sync_12, t0.client_id AS client_id_13, t0.type_id AS type_id_14, t0.procedure_id AS procedure_id_15, t0.marker_id AS marker_id_16 FROM bee_s_performance t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "33"
]
0.25 ms
(6.00%)
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.25 ms
(5.97%)
1
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
]
0.23 ms
(5.53%)
1
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.surname AS surname_2, b0_.phone AS phone_3, b0_.email AS email_4, b0_.password AS password_5, b0_.directory_path AS directory_path_6, b0_.role AS role_7, b0_.emergency_contact_1 AS emergency_contact_1_8, b0_.emergency_contact_2 AS emergency_contact_2_9, b0_.is_admin_active AS is_admin_active_10, b0_.is_active AS is_active_11, b0_.is_tutorial_active AS is_tutorial_active_12, b0_.datetime_creation AS datetime_creation_13, b0_.one_time_code AS one_time_code_14, b0_.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_15, b0_.image_path AS image_path_16, b0_.is_anonimized AS is_anonimized_17, b0_.is_company_admin AS is_company_admin_18 FROM bee_s_staff b0_ WHERE b0_.is_anonimized = 0
Parameters:
[]
0.22 ms
(5.27%)
1
SELECT t0.id AS id_1, t0.value AS value_2 FROM bee_s_performance_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.22 ms
(5.27%)
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:
[
  "qc@slmmilano.com"
]
0.22 ms
(5.22%)
1
UPDATE bee_s_performance SET completed_percentage = ? WHERE id = ?
Parameters:
[
  "90"
  "33"
]
0.20 ms
(4.79%)
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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "40"
]
0.19 ms
(4.49%)
1
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_performance_type b0_ WHERE b0_.id IN (?) ORDER BY b0_.value ASC
Parameters:
[
  "1"
]
0.17 ms
(3.92%)
1
"START TRANSACTION"
Parameters:
[]
0.16 ms
(3.76%)
1
SELECT b0_.id AS id_0, b0_.value AS value_1, b0_.color AS color_2 FROM bee_s_tag b0_ WHERE b0_.id IN (?) ORDER BY b0_.value ASC
Parameters:
[
  "7"
]

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\Tag 8
App\Entity\Slave\Staff 1
App\Entity\Slave\Client 1
App\Entity\Slave\Performance 1
App\Entity\Slave\PerformanceType 1
App\Entity\Slave\Procedure 1