GET https://sigexpe.srv.neoknow.es/es/acciones-formativas/TEST-S-001

Query Metrics

21 Database Queries
4 Different statements
6.73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 ms
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"
]
2 0.71 ms
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"
]
3 0.29 ms
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"
]
4 0.29 ms
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_LOGIN"
]
5 0.25 ms
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_LOGIN"
]
6 0.23 ms
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_LOGIN_WIDTH"
]
7 0.24 ms
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:
[
  "PRIMARY_COLOR"
]
8 0.23 ms
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:
[
  "PRIMARY_COLOR"
]
9 0.24 ms
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:
[
  "SECONDARY_COLOR"
]
10 0.27 ms
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:
[
  "SECONDARY_COLOR"
]
11 0.26 ms
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:
[
  "TITLE_COLORS"
]
12 0.25 ms
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:
[
  "TITLE_COLORS"
]
13 0.20 ms
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:
[
  "CIRCLE_MENU_ICONS"
]
14 0.22 ms
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:
[
  "BACKGROUND_IMG_LOGIN"
]
15 0.20 ms
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:
[
  "BACKGROUND_IMG_LOGIN"
]
16 0.20 ms
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:
[
  "FAVICON_URL"
]
17 0.22 ms
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:
[
  "FAVICON_URL"
]
18 0.23 ms
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:
[
  "PROJECT_NAME"
]
19 0.21 ms
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:
[
  "PROJECT_NAME"
]
20 0.40 ms
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
]
21 0.42 ms
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
]

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.