Query Metrics
21
Database Queries
4
Different statements
6.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.75 ms (70.57%) |
18 |
SELECT t0.id AS id_1, t0.param AS param_2, t0.value AS value_3, t0.section AS section_4, t0.info AS info_5 FROM params t0 WHERE t0.param = ? LIMIT 1
Parameters:
[
"LOGO_MENU"
]
|
|
1.16 ms (17.29%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.ext_code AS ext_code_2, e0_.published AS published_3, e0_.start_date AS start_date_4, e0_.end_date AS end_date_5, e0_.inscripciones_inicio AS inscripciones_inicio_6, e0_.inscripciones_fin AS inscripciones_fin_7, e0_.start_time AS start_time_8, e0_.end_time AS end_time_9, e0_.max_registrations AS max_registrations_10, e0_.created AS created_11, e0_.updated AS updated_12, e0_.generation_qr AS generation_qr_13, e0_.status AS status_14, e0_.hours AS hours_15, e0_.participants AS participants_16, e0_.target_groups AS target_groups_17, e0_.target_admin AS target_admin_18, e0_.total_days AS total_days_19, e0_.shift AS shift_20, e0_.number_checkings AS number_checkings_21, e0_.min_compliance AS min_compliance_22, e0_.image AS image_23, e0_.description AS description_24, e0_.objetives AS objetives_25, e0_.skills AS skills_26, e0_.contents AS contents_27, e0_.planned_materials AS planned_materials_28, e0_.internal_observations AS internal_observations_29, e0_.control_asistencias AS control_asistencias_30, e0_.cuestionario_conocimiento AS cuestionario_conocimiento_31, e0_.actividades_practicas AS actividades_practicas_32, e0_.evaluacion_certificacion_interna AS evaluacion_certificacion_interna_33, e0_.prerequisites AS prerequisites_34, e0_.technical_requirements AS technical_requirements_35, e0_.date_and_time AS date_and_time_36, e0_.location AS location_37, e0_.center_id AS center_id_38, e0_.modality_id AS modality_id_39 FROM events e0_ WHERE e0_.ext_code = ? AND e0_.published = 1
Parameters:
[
"TEST-S-001"
]
|
|
0.42 ms (6.20%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.taxonomy_id AS taxonomy_id_4 FROM taxonomy_value t0 INNER JOIN events_taxonomy_value ON t0.id = events_taxonomy_value.taxonomy_value_id WHERE events_taxonomy_value.events_id = ?
Parameters:
[
26
]
|
|
0.40 ms (5.95%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.taxonomy_id AS taxonomy_id_4 FROM taxonomy_value t0 WHERE t0.id = ?
Parameters:
[
7
]
|
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\Events | No errors. |
| App\Entity\Centers | No errors. |
| App\Entity\TaxonomyValue | No errors. |
| App\Entity\Registrations | No errors. |
| App\Entity\User | No errors. |
| App\Entity\EventRequest | No errors. |
| App\Entity\RegistrationQualification | No errors. |
| App\Entity\Params | No errors. |
| App\Entity\Taxonomy | No errors. |