Query Metrics
9
Database Queries
4
Different statements
1.24 ms
Query time
0
Invalid entities
14
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.15 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.position AS position_7, t0.user_group AS user_group_8, t0.email AS email_9, t0.created_at AS created_at_10, t0.created_by_name AS created_by_name_11, t0.is_active AS is_active_12 FROM users t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.17 ms |
SELECT e0_.id AS id_0, e0_.first_name AS first_name_1, e0_.last_name AS last_name_2, e0_.position AS position_3, e0_.department AS department_4, e0_.employment_type AS employment_type_5, e0_.hourly_rate AS hourly_rate_6, e0_.currency AS currency_7, e0_.agreed_rate AS agreed_rate_8, e0_.agreed_currency AS agreed_currency_9, e0_.email AS email_10, e0_.phone AS phone_11, e0_.hire_date AS hire_date_12, e0_.birth_date AS birth_date_13, e0_.notes AS notes_14, e0_.is_active AS is_active_15, e0_.created_at AS created_at_16, e0_.created_by_name AS created_by_name_17, e0_.medical_exam_date AS medical_exam_date_18, e0_.bhp_date AS bhp_date_19, e0_.registered_country AS registered_country_20, e0_.registered_city AS registered_city_21, e0_.registered_address AS registered_address_22, e0_.registered_postal_code AS registered_postal_code_23, e0_.mailing_country AS mailing_country_24, e0_.mailing_city AS mailing_city_25, e0_.mailing_address AS mailing_address_26, e0_.mailing_postal_code AS mailing_postal_code_27, e0_.id_card_number AS id_card_number_28, e0_.passport_number AS passport_number_29, e0_.insurance_name AS insurance_name_30, e0_.insurance_expiry AS insurance_expiry_31, e0_.marital_status AS marital_status_32, e0_.pesel AS pesel_33, e0_.nip AS nip_34, e0_.bank_account AS bank_account_35, e0_.bank_name AS bank_name_36, e0_.emergency_contact AS emergency_contact_37, e0_.emergency_phone AS emergency_phone_38, e0_.nationality AS nationality_39, e0_.gross_rate AS gross_rate_40, e0_.company_id AS company_id_41 FROM employees e0_ ORDER BY e0_.last_name ASC
Parameters:
[] |
| 3 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.is_subcontractor AS is_subcontractor_5, t0.address AS address_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.nip AS nip_9, t0.email AS email_10, t0.phone AS phone_11, t0.contact_person AS contact_person_12, t0.country AS country_13 FROM companies t0 WHERE t0.is_active = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
3
]
|
| 5 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
5
]
|
| 6 | 0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
6
]
|
| 7 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
2
]
|
| 8 | 0.08 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
4
]
|
| 9 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.expiry_date AS expiry_date_3, t0.employee_id AS employee_id_4 FROM employee_qualifications t0 WHERE t0.employee_id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Employee | 6 |
| App\Entity\EmployeeQualification | 4 |
| App\Entity\Company | 3 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Employee | No errors. |
| App\Entity\EmployeeQualification | No errors. |
| App\Entity\EmployeeDocument | No errors. |
| App\Entity\EmployeeDeduction | No errors. |