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

Query Metrics

29 Database Queries
8 Different statements
11.07 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.08 ms
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM events e0_ WHERE e0_.published = 1
Parameters:
[]
2 0.38 ms
SELECT DISTINCT e0_.id AS id_0, e0_.start_date AS start_date_1 FROM events e0_ WHERE e0_.published = 1 ORDER BY e0_.start_date ASC LIMIT 6
Parameters:
[]
3 0.68 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_.published = 1 AND e0_.id IN (?, ?, ?, ?) ORDER BY e0_.start_date ASC
Parameters:
[
  27
  26
  29
  30
]
4 1.52 ms
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.label AS label_2, t0_.taxonomy_id AS taxonomy_id_3 FROM taxonomy_value t0_ INNER JOIN taxonomy t1_ ON t0_.taxonomy_id = t1_.id WHERE t1_.name = ? ORDER BY t0_.label ASC
Parameters:
[
  "Modalidad"
]
5 0.38 ms
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.label AS label_2, t0_.taxonomy_id AS taxonomy_id_3 FROM taxonomy_value t0_ INNER JOIN taxonomy t1_ ON t0_.taxonomy_id = t1_.id WHERE t1_.name = ? ORDER BY t0_.label ASC
Parameters:
[
  "Area Tematica"
]
6 0.31 ms
SELECT MIN(e0_.hours) AS sclr_0, MAX(e0_.hours) AS sclr_1 FROM events e0_ WHERE e0_.hours IS NOT NULL
Parameters:
[]
7 0.85 ms
SELECT h0_.id AS id_0, h0_.position AS position_1, h0_.enabled AS enabled_2, h0_.event_id AS event_id_3 FROM home_slider h0_ WHERE h0_.enabled = 1 ORDER BY h0_.position ASC
Parameters:
[]
8 0.35 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"
]
9 0.28 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"
]
10 0.28 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"
]
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:
[
  "LOGO_LOGIN"
]
12 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:
[
  "LOGO_LOGIN_WIDTH"
]
13 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"
]
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:
[
  "PRIMARY_COLOR"
]
15 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:
[
  "SECONDARY_COLOR"
]
16 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:
[
  "SECONDARY_COLOR"
]
17 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:
[
  "TITLE_COLORS"
]
18 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:
[
  "TITLE_COLORS"
]
19 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"
]
20 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:
[
  "BACKGROUND_IMG_LOGIN"
]
21 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"
]
22 0.28 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"
]
23 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:
[
  "FAVICON_URL"
]
24 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:
[
  "PROJECT_NAME"
]
25 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"
]
26 0.55 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:
[
  27
]
27 0.31 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
]
28 0.29 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:
[
  29
]
29 0.27 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:
[
  30
]

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