Query Metrics
164
Database Queries
37
Different statements
26.73 ms
Query time
0
Invalid entities
393
Managed entities
Grouped Statements
master connection
| Time▼ | Count | Info |
|---|---|---|
|
0.72 ms (2.68%) |
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.28 ms (1.04%) |
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.22 ms (0.83%) |
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 |
|---|---|---|
|
7.83 ms (29.28%) |
64 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.is_completion_date_required AS is_completion_date_required_3, t0.is_date_client_visible AS is_date_client_visible_4 FROM bee_s_requirement t0 WHERE t0.id = ?
Parameters:
[
46
]
|
|
5.28 ms (19.76%) |
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
]
|
|
1.92 ms (7.17%) |
8 |
SELECT t0.id AS id_1, t0.completed_date AS completed_date_2, t0.name AS name_3, t0.priority AS priority_4, t0.is_completed AS is_completed_5, t0.completed_by_staff_id AS completed_by_staff_id_6, t0.performance_id AS performance_id_7, t0.required_for_performance_phase_id AS required_for_performance_phase_id_8, t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9, t0.requirement_id AS requirement_id_10 FROM bee_s_performance_requirement t0 WHERE t0.required_for_performance_phase_id = ?
Parameters:
[
2464
]
|
|
1.76 ms (6.57%) |
8 |
SELECT t0.id AS id_1, t0.completed_date AS completed_date_2, t0.name AS name_3, t0.priority AS priority_4, t0.is_completed AS is_completed_5, t0.completed_by_staff_id AS completed_by_staff_id_6, t0.performance_id AS performance_id_7, t0.required_for_performance_phase_id AS required_for_performance_phase_id_8, t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9, t0.requirement_id AS requirement_id_10 FROM bee_s_performance_requirement t0 WHERE t0.optional_for_performance_phase_id = ?
Parameters:
[
2464
]
|
|
1.11 ms (4.14%) |
8 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.requirement_id AS requirement_id_4 FROM bee_s_jt_phase_required_requirements t0 WHERE t0.phase_id = ?
Parameters:
[
10
]
|
|
1.05 ms (3.95%) |
8 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.requirement_id AS requirement_id_4 FROM bee_s_jt_phase_optional_requirements t0 WHERE t0.phase_id = ?
Parameters:
[
10
]
|
|
0.87 ms (3.24%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_phase t0 WHERE t0.id = ?
Parameters:
[
10
]
|
|
0.33 ms (1.24%) |
1 |
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.time AS time_2, b0_.is_hour AS is_hour_3, b0_.amount AS amount_4, b0_.notes AS notes_5, b0_.staff_id AS staff_id_6, b0_.performance_id AS performance_id_7, b0_.type_id AS type_id_8 FROM bee_s_activity b0_ INNER JOIN bee_s_performance b1_ ON b0_.performance_id = b1_.id WHERE b1_.id = ? ORDER BY b0_.date DESC
Parameters:
[
"85"
]
|
|
0.32 ms (1.19%) |
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.30 ms (1.11%) |
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.29 ms (1.10%) |
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:
[
85
]
|
|
0.27 ms (1.02%) |
1 |
SELECT b0_.id AS id_0, b0_.priority AS priority_1, b0_.name AS name_2, b0_.start_date AS start_date_3, b0_.completed_date AS completed_date_4, b0_.is_completed AS is_completed_5, b0_.is_hidden AS is_hidden_6, b0_.completed_by_staff_id AS completed_by_staff_id_7, b0_.performance_id AS performance_id_8 FROM bee_s_performance_phase b0_ WHERE b0_.performance_id = ? ORDER BY b0_.priority ASC
Parameters:
[
"85"
]
|
|
0.26 ms (0.98%) |
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.25 ms (0.95%) |
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.89%) |
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:
[
"76"
]
|
|
0.24 ms (0.89%) |
1 |
SELECT b0_.id AS id_0, b0_.amount AS amount_1, b0_.notes AS notes_2, b0_.performance_id AS performance_id_3, b0_.type_id AS type_id_4 FROM bee_s_cost b0_ INNER JOIN bee_s_performance b1_ ON b0_.performance_id = b1_.id WHERE b1_.id = ? ORDER BY b0_.amount ASC
Parameters:
[
"85"
]
|
|
0.24 ms (0.89%) |
1 |
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.amount AS amount_2, b0_.notes AS notes_3, b0_.is_approved AS is_approved_4, b0_.is_paid AS is_paid_5, b0_.staff_id AS staff_id_6, b0_.performance_id AS performance_id_7, b0_.type_id AS type_id_8 FROM bee_s_reimbursement b0_ INNER JOIN bee_s_performance b1_ ON b0_.performance_id = b1_.id WHERE b1_.id = ? ORDER BY b0_.date ASC
Parameters:
[
"85"
]
|
|
0.23 ms (0.87%) |
1 |
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:
[
"85"
]
|
|
0.23 ms (0.85%) |
1 |
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 IS NULL LIMIT 1
Parameters:
[] |
|
0.22 ms (0.83%) |
1 |
SELECT b0_.id AS id_0, b0_.date AS date_1, b0_.message AS message_2, b0_.staff_owner_id AS staff_owner_id_3, b0_.performance_id AS performance_id_4 FROM bee_s_reminder b0_ INNER JOIN bee_s_performance b1_ ON b0_.performance_id = b1_.id WHERE b1_.id = ?
Parameters:
[
"85"
]
|
|
0.22 ms (0.83%) |
1 |
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.staff_id = ?
Parameters:
[
4
]
|
|
0.20 ms (0.77%) |
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.20 ms (0.76%) |
1 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.completed_date AS completed_date_5, t0.is_completed AS is_completed_6, t0.is_hidden AS is_hidden_7, t0.completed_by_staff_id AS completed_by_staff_id_8, t0.performance_id AS performance_id_9 FROM bee_s_performance_phase t0 WHERE t0.performance_id = ?
Parameters:
[
85
]
|
|
0.19 ms (0.71%) |
1 |
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.procedure_id AS procedure_id_4 FROM bee_s_jt_phase_procedure t0 WHERE t0.procedure_id = ?
Parameters:
[
7
]
|
|
0.16 ms (0.59%) |
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.16 ms (0.58%) |
1 |
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_activity_type b0_ ORDER BY b0_.value ASC
Parameters:
[] |
|
0.15 ms (0.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_procedure t0
Parameters:
[] |
|
0.15 ms (0.57%) |
1 |
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.id IS NULL LIMIT 1
Parameters:
[] |
|
0.15 ms (0.56%) |
1 |
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.id IS NULL LIMIT 1
Parameters:
[] |
|
0.15 ms (0.55%) |
1 |
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_reimbursement_type b0_ ORDER BY b0_.value ASC
Parameters:
[] |
|
0.15 ms (0.55%) |
1 |
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.id IS NULL LIMIT 1
Parameters:
[] |
|
0.14 ms (0.54%) |
1 |
SELECT b0_.id AS id_0, b0_.value AS value_1 FROM bee_s_cost_type b0_ ORDER BY b0_.value ASC
Parameters:
[] |
|
0.14 ms (0.52%) |
1 |
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.id IS NULL LIMIT 1
Parameters:
[] |
|
0.11 ms (0.42%) |
1 |
SELECT t0.id AS id_1, t0.job_position AS job_position_2, t0.client_id AS client_id_3, t0.referent_id AS referent_id_4 FROM bee_s_jt_client_referent t0 WHERE t0.client_id = ?
Parameters:
[
76
]
|
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\PerformanceRequirement | 71 |
| App\Entity\Slave\Requirement | 64 |
| App\Entity\Slave\JoinTablePhaseRequiredRequirements | 64 |
| App\Entity\Slave\JoinTableStaffPermission | 30 |
| App\Entity\Slave\Permission | 30 |
| App\Entity\Slave\JoinTableStaffPerformance | 23 |
| App\Entity\Slave\Performance | 23 |
| App\Entity\Slave\Marker | 16 |
| App\Entity\Slave\Tag | 13 |
| App\Entity\Slave\PerformancePhase | 8 |
| App\Entity\Slave\JoinTablePhaseProcedure | 8 |
| App\Entity\Slave\Phase | 8 |
| App\Entity\Slave\Procedure | 7 |
| App\Entity\Slave\JoinTablePhaseOptionalRequirements | 7 |
| App\Entity\Slave\Staff | 6 |
| App\Entity\Slave\PermissionCategory | 5 |
| App\Entity\Slave\PerformanceType | 5 |
| App\Entity\Slave\Client | 1 |
| App\Entity\Slave\ActivityType | 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. |