Query Metrics
16
Database Queries
15
Different statements
4.23 ms
Query time
0
Invalid entities
16
Managed entities
Grouped Statements
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 |
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. |
slave entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Slave\Staff | No errors. |
| App\Entity\Slave\JoinTableStaffPermission | No errors. |
| App\Entity\Slave\Reimbursement | No errors. |
| App\Entity\Slave\Activity | No errors. |
| App\Entity\Slave\Log | No errors. |
| App\Entity\Slave\Reminder | No errors. |
| App\Entity\Slave\JoinTableStaffPerformance | No errors. |
| App\Entity\Slave\PerformancePhase | No errors. |
| App\Entity\Slave\PerformanceRequirement | No errors. |
| App\Entity\Slave\JoinTablePerformanceMessageStaff | No errors. |
| App\Entity\Slave\Client | No errors. |
| App\Entity\Slave\Location | No errors. |
| App\Entity\Slave\JoinTableClientReferent | No errors. |
| App\Entity\Slave\Performance | No errors. |
| App\Entity\Slave\PerformanceType | No errors. |
| App\Entity\Slave\Procedure | No errors. |
| App\Entity\Slave\Marker | No errors. |
| App\Entity\Slave\Cost | No errors. |
| App\Entity\Slave\PerformanceMessage | No errors. |
| App\Entity\Slave\Tag | No errors. |