GET https://festival.winecta.com/es/evento/wiener-philharmoniker-2025-2

Query Metrics

12 Database Queries
12 Different statements
21.73 ms Query time
1 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.08 ms
SELECT e0_.id AS id_0, e0_.titulo AS titulo_1, e0_.link_entradas AS link_entradas_2, e0_.enrollment_link AS enrollment_link_3, e0_.imagen AS imagen_4, e0_.copyright_foto AS copyright_foto_5, e0_.fecha AS fecha_6, e0_.costo AS costo_7, e0_.descripcion AS descripcion_8, e0_.fecha_inicio AS fecha_inicio_9, e0_.fecha_fin AS fecha_fin_10, e0_.facultad AS facultad_11, e0_.materiales AS materiales_12, e0_.calendario AS calendario_13, e0_.sede AS sede_14, e0_.numero_horas AS numero_horas_15, e0_.plazas AS plazas_16, e0_.precio_inicial AS precio_inicial_17, e0_.precio_final AS precio_final_18, e0_.condiciones_matricula AS condiciones_matricula_19, e0_.deleted_at AS deleted_at_20, e0_.slug AS slug_21, e0_.id_wp AS id_wp_22, e0_.id_t3 AS id_t3_23, e0_.titulo_ingles AS titulo_ingles_24, e0_.descripcion_ingles AS descripcion_ingles_25, e0_.imagen_optimizada AS imagen_optimizada_26, e0_.publico AS publico_27, e0_.condiciones_matricula_ingles AS condiciones_matricula_ingles_28, e0_.genero_id AS genero_id_29, e0_.escenario_id AS escenario_id_30, e0_.tipo_evento_id AS tipo_evento_id_31 FROM evento e0_ WHERE e0_.slug = ? AND e0_.deleted_at IS NULL AND e0_.publico = 1 LIMIT 1
Parameters:
[
  "wiener-philharmoniker-2025-2"
]
2 2.03 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.pdf AS pdf_3, t0.descripcion AS descripcion_4, t0.deleted_at AS deleted_at_5, t0.nombre_ingles AS nombre_ingles_6, t0.descripcion_ingles AS descripcion_ingles_7, t0.evento_id AS evento_id_8 FROM programa t0 WHERE t0.evento_id = ?
Parameters:
[
  18530
]
3 6.82 ms
SELECT a0_.id AS id_0, a0_.deleted_at AS deleted_at_1, a0_.programa_id AS programa_id_2, a0_.obra_id AS obra_id_3, a0_.artista_id AS artista_id_4 FROM artista_obra_programa a0_ INNER JOIN artista a1_ ON a0_.artista_id = a1_.id INNER JOIN programa p2_ ON a0_.programa_id = p2_.id WHERE a0_.deleted_at IS NULL AND a1_.deleted_at IS NULL AND p2_.evento_id = ?
Parameters:
[
  18530
]
4 5.41 ms
SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.programa_id AS programa_id_2, o0_.obra_id AS obra_id_3 FROM obra_programa o0_ WHERE o0_.deleted_at IS NULL AND o0_.programa_id = ?
Parameters:
[
  7999
]
5 0.82 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.deleted_at AS deleted_at_3, t0.nombre_ingles AS nombre_ingles_4 FROM tipo_patrocinio t0 WHERE t0.deleted_at IS NULL
Parameters:
[]
6 0.35 ms
SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, r0_.link AS link_2 FROM red_social r0_ WHERE r0_.nombre = ?
Parameters:
[
  "spotify"
]
7 0.89 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.deleted_at AS deleted_at_3, t0.id_wp AS id_wp_4, t0.nombre_ingles AS nombre_ingles_5 FROM genero t0 WHERE t0.id = ?
Parameters:
[
  4790
]
8 1.19 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.imagen AS imagen_3, t0.descripcion AS descripcion_4, t0.deleted_at AS deleted_at_5, t0.longitud AS longitud_6, t0.latitud AS latitud_7, t0.map_place AS map_place_8, t0.video AS video_9, t0.id_wp AS id_wp_10, t0.nombre_ingles AS nombre_ingles_11, t0.descripcion_ingles AS descripcion_ingles_12, t0.imagen_optimizada AS imagen_optimizada_13 FROM escenario t0 WHERE t0.id = ?
Parameters:
[
  462
]
9 0.87 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.deleted_at AS deleted_at_3, t0.tipo AS tipo_4 FROM tipo_evento t0 WHERE t0.id = ?
Parameters:
[
  1970
]
10 0.73 ms
SELECT t0.id AS id_1, t0.zona AS zona_2, t0.precio AS precio_3, t0.deleted_at AS deleted_at_4, t0.evento_id AS evento_id_5 FROM precio t0 WHERE t0.evento_id = ?
Parameters:
[
  18530
]
11 0.81 ms
SELECT t0.id AS id_1, t0.fecha AS fecha_2, t0.deleted_at AS deleted_at_3, t0.evento_id AS evento_id_4, t0.patrocinador_id AS patrocinador_id_5, t0.tipo_patrocinio_id AS tipo_patrocinio_id_6, t0.elemento_footer_id AS elemento_footer_id_7 FROM tipo_patrocinio_evento_patrocinador t0 WHERE t0.evento_id = ?
Parameters:
[
  18530
]
12 0.74 ms
SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.evento_id AS evento_id_3, t0.profesor_id AS profesor_id_4 FROM profesor_evento t0 WHERE t0.evento_id = ?
Parameters:
[
  18530
]

Database Connections

Name Service
default doctrine.dbal.default_connection
old_wp doctrine.dbal.old_wp_connection
old_t3 doctrine.dbal.old_t3_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\Evento No errors.
App\Entity\Genero No errors.
App\Entity\Escenario No errors.
App\Entity\TipoEvento No errors.
App\Entity\CondicionesEspeciales No errors.
App\Entity\ProfesorEvento No errors.
App\Entity\Precio No errors.
App\Entity\TipoPatrocinioEventoPatrocinador No errors.
App\Entity\Programa No errors.
App\Entity\ObraPrograma No errors.
App\Entity\ArtistaObraPrograma
  • The association App\Entity\ArtistaObraPrograma#artistas refers to the owning side field App\Entity\Artista#artistaObraPrograma which does not exist.
App\Entity\Retransmision No errors.
App\Entity\Artista No errors.
App\Entity\Obra No errors.
App\Entity\TipoPatrocinio No errors.
App\Entity\RedSocial No errors.
App\Entity\FotoEscenario No errors.
App\Entity\Patrocinador No errors.
App\Entity\ElementoFooter No errors.
App\Entity\Profesor No errors.