https://dev2.datoscontinuos.net/1618/symfony5/bts_interno/public/ws/search_agent_vehicle Return to referer URL

Query Metrics

2 Database Queries
2 Different statements
5.30 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.96 ms
SELECT t0.employee_id AS employee_id_1, t0.name AS name_2, t0.alias AS alias_3, t0.citizen_id AS citizen_id_4, t0.avatar_path AS avatar_path_5, t0.created_at AS created_at_6, t0.birthdate AS birthdate_7, t0.firearm_credential AS firearm_credential_8, t0.firearm_expiration AS firearm_expiration_9, t0.assigned_at AS assigned_at_10, t0.sync_by_system AS sync_by_system_11, t0.updated_at AS updated_at_12, t0.expiration_date AS expiration_date_13, t0.app_status AS app_status_14, t0.app_status_updated_at AS app_status_updated_at_15, t0.token AS token_16, t0.app_status_description AS app_status_description_17, t0.phone AS phone_18, t0.address AS address_19, t0.start_work_date AS start_work_date_20, t0.salary AS salary_21, t0.job_position_id AS job_position_id_22, t0.employee_status_id AS employee_status_id_23, t0.assigned_location_id AS assigned_location_id_24, t0.created_by AS created_by_25, t0.assigned_by_employee_id AS assigned_by_employee_id_26, t0.assigned_location_position_id AS assigned_location_position_id_27, t0.assigned_supervision_id AS assigned_supervision_id_28, t0.headquarter_id AS headquarter_id_29, t0.company_id AS company_id_30, t0.appointment_type_id AS appointment_type_id_31 FROM employee t0 WHERE t0.citizen_id = ? AND t0.employee_status_id = ? LIMIT 1
Parameters:
[
  "2421056370101"
  1
]
2 0.34 ms
SELECT t0.job_position_id AS job_position_id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4, t0.sync_ids AS sync_ids_5, t0.created_by AS created_by_6 FROM job_position t0 WHERE t0.job_position_id = ?
Parameters:
[
  34
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Employee No errors.
App\Entity\JobPosition No errors.
App\Entity\EmployeeStatus No errors.
App\Entity\Location No errors.
App\Entity\User No errors.
App\Entity\LocationPosition No errors.
App\Entity\Supervision No errors.
App\Entity\Headquarter No errors.
App\Entity\Company No errors.
App\Entity\AppointmentType No errors.