Symfony Profiler

SELECT
  t0.id AS id_4,
  t0.deleted_at AS deleted_at_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.email AS email_8,
  t0.nombre AS nombre_9,
  t0.rol
FROM
  `usuario` t0
  LEFT JOIN admin t1 ON t0.id = t1.id
  LEFT JOIN editor t2 ON t0.id = t2.id
  LEFT JOIN cliente t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.roles AS roles_6, t0.password AS password_7, t0.email AS email_8, t0.nombre AS nombre_9, t0.rol FROM `usuario` t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN editor t2 ON t0.id = t2.id LEFT JOIN cliente t3 ON t0.id = t3.id WHERE t0.id = 24;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.deleted_at AS deleted_at_2,
  t0_.tipo AS tipo_3
FROM
  tipo_evento t0_
WHERE
  t0_.deleted_at IS NULL
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.deleted_at AS deleted_at_2, t0_.tipo AS tipo_3 FROM tipo_evento t0_ WHERE t0_.deleted_at IS NULL ORDER BY t0_.id ASC;

SELECT
  g0_.id AS id_0,
  g0_.nombre AS nombre_1,
  g0_.deleted_at AS deleted_at_2,
  g0_.id_wp AS id_wp_3,
  g0_.nombre_ingles AS nombre_ingles_4
FROM
  genero g0_
WHERE
  g0_.deleted_at IS NULL
  AND g0_.id IN (?)
ORDER BY
  g0_.id ASC

SELECT g0_.id AS id_0, g0_.nombre AS nombre_1, g0_.deleted_at AS deleted_at_2, g0_.id_wp AS id_wp_3, g0_.nombre_ingles AS nombre_ingles_4 FROM genero g0_ WHERE g0_.deleted_at IS NULL AND g0_.id IN ('4788') ORDER BY g0_.id ASC;

SELECT
  e0_.id AS id_0,
  e0_.nombre AS nombre_1,
  e0_.imagen AS imagen_2,
  e0_.descripcion AS descripcion_3,
  e0_.deleted_at AS deleted_at_4,
  e0_.longitud AS longitud_5,
  e0_.latitud AS latitud_6,
  e0_.map_place AS map_place_7,
  e0_.video AS video_8,
  e0_.id_wp AS id_wp_9,
  e0_.nombre_ingles AS nombre_ingles_10,
  e0_.descripcion_ingles AS descripcion_ingles_11,
  e0_.imagen_optimizada AS imagen_optimizada_12
FROM
  escenario e0_
WHERE
  e0_.deleted_at IS NULL
  AND e0_.id IN (?)
ORDER BY
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.nombre AS nombre_1, e0_.imagen AS imagen_2, e0_.descripcion AS descripcion_3, e0_.deleted_at AS deleted_at_4, e0_.longitud AS longitud_5, e0_.latitud AS latitud_6, e0_.map_place AS map_place_7, e0_.video AS video_8, e0_.id_wp AS id_wp_9, e0_.nombre_ingles AS nombre_ingles_10, e0_.descripcion_ingles AS descripcion_ingles_11, e0_.imagen_optimizada AS imagen_optimizada_12 FROM escenario e0_ WHERE e0_.deleted_at IS NULL AND e0_.id IN ('460') ORDER BY e0_.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.pdf AS pdf_2,
  p0_.descripcion AS descripcion_3,
  p0_.deleted_at AS deleted_at_4,
  p0_.nombre_ingles AS nombre_ingles_5,
  p0_.descripcion_ingles AS descripcion_ingles_6,
  p0_.evento_id AS evento_id_7
FROM
  programa p0_
WHERE
  p0_.deleted_at IS NULL
  AND p0_.evento_id IS NULL
  AND p0_.id IN (?)
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.pdf AS pdf_2, p0_.descripcion AS descripcion_3, p0_.deleted_at AS deleted_at_4, p0_.nombre_ingles AS nombre_ingles_5, p0_.descripcion_ingles AS descripcion_ingles_6, p0_.evento_id AS evento_id_7 FROM programa p0_ WHERE p0_.deleted_at IS NULL AND p0_.evento_id IS NULL AND p0_.id IN ('9070') ORDER BY p0_.id ASC;

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

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 = 'compania-nacional-de-danza-2026-5' AND e0_.deleted_at IS NULL AND e0_.publico = 1 LIMIT 1;

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.nombre = ?
LIMIT
  1

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.nombre = '' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO evento (
  titulo, link_entradas, enrollment_link,
  imagen, copyright_foto, fecha, costo,
  descripcion, fecha_inicio, fecha_fin,
  facultad, materiales, calendario,
  sede, numero_horas, plazas, precio_inicial,
  precio_final, condiciones_matricula,
  deleted_at, slug, id_wp, id_t3, titulo_ingles,
  descripcion_ingles, imagen_optimizada,
  publico, condiciones_matricula_ingles,
  genero_id, escenario_id, tipo_evento_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO evento (titulo, link_entradas, enrollment_link, imagen, copyright_foto, fecha, costo, descripcion, fecha_inicio, fecha_fin, facultad, materiales, calendario, sede, numero_horas, plazas, precio_inicial, precio_final, condiciones_matricula, deleted_at, slug, id_wp, id_t3, titulo_ingles, descripcion_ingles, imagen_optimizada, publico, condiciones_matricula_ingles, genero_id, escenario_id, tipo_evento_id) VALUES ('Compañía Nacional de Danza', NULL, NULL, NULL, NULL, '2026-06-27 22:30:00', 0, '<p style=\"text-align: right;\"><span style=\"color: #2dc26b;\"><strong>Danza</strong></span></p>
<p><strong>Compa&ntilde;&iacute;a Nacional de Danza</strong><br><strong>Muriel Romero</strong> directora</p>
<p>&nbsp;</p>
<p><em><strong>NumEros</strong></em></p>
<p>&nbsp;</p>
<p><em>Serenade</em><span style=\"font-size: 10pt;\"> (35 minutos)</span><br><span style=\"font-size: 10pt;\">Coreograf&iacute;a: </span><strong>George Balanchine</strong> &copy; The George Balanchine Trust<br><span style=\"font-size: 10pt;\">M&uacute;sica: </span><strong>Piotr Illich Chaikovski</strong><br><span style=\"font-size: 10pt;\">Dise&ntilde;o de vestuario: </span>Karinska<br><span style=\"font-size: 10pt;\">Puesta en escena: </span>Colleen Neary<br><span style=\"font-size: 10pt;\">Realizaci&oacute;n de vestuario:</span> Estudio Tania Bakunova</p>
<p><em><span style=\"font-size: 10pt;\">Descanso</span></em></p>
<p><em>Echoes from a Restless Soul&nbsp;</em><span style=\"font-size: 10pt;\"> (26 minutos)</span><br><span style=\"font-size: 10pt;\">Coreograf&iacute;a, dise&ntilde;o de iluminaci&oacute;n y vestuario:</span> <strong>Jacopo Godani</strong><br><span style=\"font-size: 10pt;\">M&uacute;sica:</span> <strong>Maurice Ravel</strong><span style=\"font-size: 10pt;\"> (piano solista: Gustavo D&iacute;az-Jerez)</span><br><span style=\"font-size: 10pt;\">Asistentes coreogr&aacute;ficos: </span>Vincenzo de Rosa, Zoe Lenzi<br><span style=\"font-size: 10pt;\">Realizaci&oacute;n de vestuario: </span>Estudio Tania Bakunova</p>
<p>&nbsp;</p>
<p><em>Playlist (Track 1, 2)&nbsp;<span style=\"font-size: 10pt;\"> </span></em><span style=\"font-size: 10pt;\">(10 minutos)</span><br><span style=\"font-size: 10pt;\">Coreograf&iacute;a: </span><strong>William Forsythe</strong><br><span style=\"font-size: 10pt;\">M&uacute;sica: </span><strong>Peven Everett y Lion Babe</strong><br><span style=\"font-size: 10pt;\">Puesta en escena: </span>Jos&eacute; Carlos Blanco Mart&iacute;nez<br><span style=\"font-size: 10pt;\">Dise&ntilde;o de vestuario: </span>Dorothee Merg, William Forsythe<br><span style=\"font-size: 10pt;\">Dise&ntilde;o de iluminaci&oacute;n: </span>Tanja R&uuml;hl<br><span style=\"font-size: 10pt;\">Realizaci&oacute;n de vestuario:</span> I&ntilde;aki Cobos y Primer Plano Vestuario SL</p>
<p>&nbsp;</p>
<p><strong>Po&eacute;tica y deseo se unen en tres coreograf&iacute;as maestras</strong><br><em>Serenade </em>(Balanchine/Chaikovski), <em>Echoes from a Restless Soul</em> (Godani/Ravel) y <em>Playlist. Track 1, 2</em> (Forsythe/Everett/Babe) componen un programa de excelencia, porque son ejemplos de la evoluci&oacute;n de la danza acad&eacute;mica desde los &eacute;xitos de Marius Petipa en el siglo XIX y su <em>Lago de los cisnes </em>o <em>Don Quijote</em>, hasta nuestros d&iacute;as. Con el neoclasicismo de George Balanchine como n&uacute;cleo inicial, la directora de la CND, Muriel Romero, ha escogido para acompa&ntilde;ar a su obra maestra dos piezas de alto voltaje, bell&iacute;simas en sus diferentes tonos y din&aacute;micas, donde los bailarines de la compa&ntilde;&iacute;a muestran su gran momento art&iacute;stico. Coreograf&iacute;as que exigen gran t&eacute;cnica a los int&eacute;rpretes y la capacidad de transformar su temperamento desde lo l&iacute;rico a lo m&aacute;s rompedor.&nbsp;</p>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'compania-nacional-de-danza-2026-5', NULL, NULL, 'Compañía Nacional de Danza', '<p style=\"text-align: right;\"><span style=\"color: #2dc26b;\"><strong>Dance</strong></span></p>
<p><strong>Compa&ntilde;&iacute;a Nacional de Danza</strong><br><strong>Muriel Romero</strong> director</p>
<p>&nbsp;</p>
<p><em><strong>NumEros</strong></em></p>
<p>&nbsp;</p>
<p><em>Serenade </em><span style=\"font-size: 10pt;\">(35 minutes)</span><br><span style=\"font-size: 10pt;\">Choreography:&nbsp;</span><strong>George Balanchine</strong> &copy; The George Balanchine Trust<br><span style=\"font-size: 10pt;\">Music:&nbsp;</span><strong>Piotr Illich Chaikovski</strong><br><span style=\"font-size: 10pt;\">Costumes design: </span>Karinska<br><span style=\"font-size: 10pt;\">Staging:&nbsp;</span>Colleen Neary<br><span style=\"font-size: 10pt;\">Costumes:</span> Estudio Tania Bakunova</p>
<p><span style=\"font-size: 10pt;\"><em>Intermission</em></span></p>
<p><em>Echoes from a Restless Soul</em><span style=\"font-size: 10pt;\"> (26 minutes)</span><br><span style=\"font-size: 10pt;\">Choreography, lighting and costumes design:</span> <strong>Jacopo Godani</strong><br><span style=\"font-size: 10pt;\">Music:</span> <strong>Maurice Ravel</strong><span style=\"font-size: 10pt;\"> (piano soloist: Gustavo D&iacute;az-Jerez)</span><br><span style=\"font-size: 10pt;\">Choreographic asisstants:&nbsp;</span>Vincenzo de Rosa, Zoe Lenzi<br><span style=\"font-size: 10pt;\">Costumes:&nbsp;</span>Estudio Tania Bakunova</p>
<p>&nbsp;</p>
<p><em>Playlist (Track 1, 2)<span style=\"font-size: 10pt;\"> </span></em><span style=\"font-size: 10pt;\">(10 minutes)</span><br><span style=\"font-size: 10pt;\">Choreography:&nbsp;</span><strong>William Forsythe</strong><br><span style=\"font-size: 10pt;\">Music:&nbsp;</span><strong>Peven Everett, Lion Babe</strong><br><span style=\"font-size: 10pt;\">Staging:&nbsp;</span>Jos&eacute; Carlos Blanco Mart&iacute;nez<br><span style=\"font-size: 10pt;\">Costumes design:&nbsp;</span>Dorothee Merg, William Forsythe<br><span style=\"font-size: 10pt;\">Lighting design:&nbsp;</span>Tanja R&uuml;hl<br><span style=\"font-size: 10pt;\">Costumes:</span> I&ntilde;aki Cobos and Primer Plano Vestuario SL</p>
<p>&nbsp;</p>
<p class=\"MsoNormal\" style=\"margin-bottom: 10.0pt; line-height: 115%; mso-layout-grid-align: none; text-autospace: none;\"><strong style=\"mso-bidi-font-weight: normal;\"><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Poetics and Desire Unite in Three Masterful Choreographies</span></strong></p>
<p class=\"MsoNormal\" style=\"margin-bottom: 10.0pt; line-height: 115%; mso-layout-grid-align: none; text-autospace: none;\"><em style=\"mso-bidi-font-style: normal;\"><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\">Serenade</span></em><span lang=\"EN-GB\" style=\"mso-ansi-language: EN-GB;\"> (Balanchine/Tchaikovsky), <em style=\"mso-bidi-font-style: normal;\">Echoes from a Restless Soul</em> (Godani/Ravel), and <em style=\"mso-bidi-font-style: normal;\">Playlist. Track 1, 2 </em>(Forsythe/Everett/Babe) converge in a program of excellence, exemplifying the evolution of classical dance from the triumphs of Marius Petipa in the 19<sup>th</sup> century with his <em style=\"mso-bidi-font-style: normal;\">Swan Lake</em> and <em style=\"mso-bidi-font-style: normal;\">Don Quixote</em>, to the present day. With George Balanchine\'s neoclassicism as its initial core, the director of the CND, Muriel Romero, has chosen two high-voltage pieces to accompany their masterpiece, exquisitely beautiful in their different tones and dynamics, where the company\'s dancers reveal their full artistic form. These choreographies demand exceptional technique from the performers and the ability to transform their temperament from the lyrical to the most groundbreaking expression.<strong style=\"mso-bidi-font-weight: normal;\"> </strong></span></p>', NULL, 0, NULL, 4845, 460, 1970);

UPDATE
  programa
SET
  evento_id = ?
WHERE
  id = ?

UPDATE programa SET evento_id = 19591 WHERE id = 9070;

"COMMIT"

"COMMIT";