Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.nombre AS nombre_1,
  v0_.descripcion AS descripcion_2,
  v0_.descripcion_larga AS descripcion_larga_3,
  v0_.formacion_academica AS formacion_academica_4,
  v0_.experiencia_laboral AS experiencia_laboral_5,
  v0_.conocimientos AS conocimientos_6,
  v0_.fecha_vigencia AS fecha_vigencia_7,
  c1_.nombre AS nombre_8,
  (
    CURRENT_DATE - v0_.fecha_publicacion
  ) AS sclr_9
FROM
  vacante v0_
  INNER JOIN ciudad c1_ ON v0_.id_ciudad = c1_.id
WHERE
  v0_.estado = true
  AND v0_.fecha_vigencia >= ?
ORDER BY
  sclr_9 ASC

SELECT v0_.id AS id_0, v0_.nombre AS nombre_1, v0_.descripcion AS descripcion_2, v0_.descripcion_larga AS descripcion_larga_3, v0_.formacion_academica AS formacion_academica_4, v0_.experiencia_laboral AS experiencia_laboral_5, v0_.conocimientos AS conocimientos_6, v0_.fecha_vigencia AS fecha_vigencia_7, c1_.nombre AS nombre_8, (CURRENT_DATE - v0_.fecha_publicacion) AS sclr_9 FROM vacante v0_ INNER JOIN ciudad c1_ ON v0_.id_ciudad = c1_.id WHERE v0_.estado = true AND v0_.fecha_vigencia >= '2026-07-04' ORDER BY sclr_9 ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND p1_.cat1 = e0_.id
  AND p1_.status_eCommerce = 1
  AND p1_.status_infor = 1
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND p1_.cat1 = e0_.id AND p1_.status_eCommerce = 1 AND p1_.status_infor = 1 ORDER BY e0_.Nombres ASC;

SELECT
  count(f0_.id) AS sclr_0
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna <> 'C'
  AND f0_.mostrar = ?

SELECT count(f0_.id) AS sclr_0 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.mensaje_agradecimiento AS mensaje_agradecimiento_3,
  t0.view_banner_top AS view_banner_top_4,
  t0.banner_top AS banner_top_5
FROM
  trabaje_con_nosotros t0

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.mensaje_agradecimiento AS mensaje_agradecimiento_3, t0.view_banner_top AS view_banner_top_4, t0.banner_top AS banner_top_5 FROM trabaje_con_nosotros t0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  universidades t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM universidades t0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  areas_estudios t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM areas_estudios t0;

SELECT
  t0.id AS id_1,
  t0.descripcion AS descripcion_2,
  t0.url AS url_3,
  t0.tipoAperturaUrl AS tipoaperturaurl_4,
  t0.footer_column_id AS footer_column_id_5
FROM
  footer_column_texto t0
WHERE
  t0.footer_column_id = ?

SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.url AS url_3, t0.tipoAperturaUrl AS tipoaperturaurl_4, t0.footer_column_id AS footer_column_id_5 FROM footer_column_texto t0 WHERE t0.footer_column_id = 2;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  estados_carrera t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM estados_carrera t0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  idioma t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM idioma t0 WHERE t0.estado = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  pais t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM pais t0 WHERE t0.estado = 1;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 198
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 198 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 212
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 212 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  provincia t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM provincia t0 WHERE t0.estado = 'A';

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  grado_academico t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM grado_academico t0 WHERE t0.estado = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  tipos_discapacidades t0

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM tipos_discapacidades t0;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  nivel_cargo t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM nivel_cargo t0 WHERE t0.estado = 1;

SELECT
  t0.id AS id_1,
  t0.imgNombreServidor AS imgnombreservidor_2,
  t0.imgNombreAlternativo AS imgnombrealternativo_3,
  t0.url AS url_4,
  t0.tipoAperturaUrl AS tipoaperturaurl_5,
  t0.texto_alternativo_imagen AS texto_alternativo_imagen_6,
  t0.footer_column_id AS footer_column_id_7
FROM
  footer_column_imagen t0
WHERE
  t0.footer_column_id = ?

SELECT t0.id AS id_1, t0.imgNombreServidor AS imgnombreservidor_2, t0.imgNombreAlternativo AS imgnombrealternativo_3, t0.url AS url_4, t0.tipoAperturaUrl AS tipoaperturaurl_5, t0.texto_alternativo_imagen AS texto_alternativo_imagen_6, t0.footer_column_id AS footer_column_id_7 FROM footer_column_imagen t0 WHERE t0.footer_column_id = 5;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.estado AS estado_3
FROM
  nivel_idioma t0
WHERE
  t0.estado = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.estado AS estado_3 FROM nivel_idioma t0 WHERE t0.estado = 1;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 199
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 199 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 201
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 201 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  DISTINCT e0_.Nombres AS nombres_0,
  e0_.id AS id_1
FROM
  estructura_ecommerce_es e0_,
  producto_es p1_
WHERE
  e0_.Status = 1
  AND e0_.Nivel = 2
  AND p1_.cat1 = 200
  AND p1_.cat2 = e0_.id
ORDER BY
  e0_.Nombres ASC

SELECT DISTINCT e0_.Nombres AS nombres_0, e0_.id AS id_1 FROM estructura_ecommerce_es e0_, producto_es p1_ WHERE e0_.Status = 1 AND e0_.Nivel = 2 AND p1_.cat1 = 200 AND p1_.cat2 = e0_.id ORDER BY e0_.Nombres ASC;

SELECT
  f0_.id AS id_0,
  f0_.posicion AS posicion_1,
  f0_.mostrar AS mostrar_2,
  f0_.nombreColumna AS nombrecolumna_3,
  f0_.estado AS estado_4,
  f0_.fechaCreacion AS fechacreacion_5,
  f0_.fechaActualizacion AS fechaactualizacion_6,
  f0_.tipoColumna AS tipocolumna_7
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna = ?
  AND f0_.mostrar = ?

SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna = 'C' AND f0_.mostrar = 1;

SELECT
  f0_.id AS id_0,
  f0_.posicion AS posicion_1,
  f0_.mostrar AS mostrar_2,
  f0_.nombreColumna AS nombrecolumna_3,
  f0_.estado AS estado_4,
  f0_.fechaCreacion AS fechacreacion_5,
  f0_.fechaActualizacion AS fechaactualizacion_6,
  f0_.tipoColumna AS tipocolumna_7
FROM
  footer_column f0_
WHERE
  f0_.estado = ?
  AND f0_.tipoColumna <> 'C'
  AND f0_.mostrar = ?
ORDER BY
  f0_.posicion ASC

SELECT f0_.id AS id_0, f0_.posicion AS posicion_1, f0_.mostrar AS mostrar_2, f0_.nombreColumna AS nombrecolumna_3, f0_.estado AS estado_4, f0_.fechaCreacion AS fechacreacion_5, f0_.fechaActualizacion AS fechaactualizacion_6, f0_.tipoColumna AS tipocolumna_7 FROM footer_column f0_ WHERE f0_.estado = 'A' AND f0_.tipoColumna <> 'C' AND f0_.mostrar = 1 ORDER BY f0_.posicion ASC;