Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_cargo p0_
  LEFT JOIN gh_peril_cargo g1_ ON p0_.id = g1_.cargo_id
  LEFT JOIN par_estado p2_ ON g1_.estado_id = p2_.id
  LEFT JOIN par_nivel_autoridad p3_ ON g1_.par_nivel_autoridad_id = p3_.id
WHERE
  (
    p3_.id IN (3, 4)
    AND p2_.id <> 3
  )
  OR p0_.id = ?
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_cargo p0_ LEFT JOIN gh_peril_cargo g1_ ON p0_.id = g1_.cargo_id LEFT JOIN par_estado p2_ ON g1_.estado_id = p2_.id LEFT JOIN par_nivel_autoridad p3_ ON g1_.par_nivel_autoridad_id = p3_.id WHERE (p3_.id IN (3, 4) AND p2_.id <> 3) OR p0_.id = 0 ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_cargo p0_
  LEFT JOIN gh_peril_cargo g1_ ON p0_.id = g1_.cargo_id
  LEFT JOIN par_nivel_autoridad p2_ ON g1_.par_nivel_autoridad_id = p2_.id
  LEFT JOIN par_estado p3_ ON g1_.estado_id = p3_.id
WHERE
  (
    p2_.id IN (3, 4)
    AND p3_.id <> 3
  )
  OR p0_.id = ?
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_cargo p0_ LEFT JOIN gh_peril_cargo g1_ ON p0_.id = g1_.cargo_id LEFT JOIN par_nivel_autoridad p2_ ON g1_.par_nivel_autoridad_id = p2_.id LEFT JOIN par_estado p3_ ON g1_.estado_id = p3_.id WHERE (p2_.id IN (3, 4) AND p3_.id <> 3) OR p0_.id = 0 ORDER BY p0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.etiqueta AS etiqueta_3,
  t0.ruta AS ruta_4,
  t0.ruta_auxiliar AS ruta_auxiliar_5,
  t0.orden AS orden_6,
  t0.create_at AS create_at_7,
  t0.update_at AS update_at_8,
  t0.icono AS icono_9,
  t0.class AS class_10,
  t0.endpoint AS endpoint_11,
  t0.tipo AS tipo_12,
  t0.parametrica AS parametrica_13,
  t0.grupo AS grupo_14,
  t0.sub_grupo AS sub_grupo_15,
  t0.funcion_id AS funcion_id_16
FROM
  sec_accion t0
WHERE
  t0.ruta = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.etiqueta AS etiqueta_3, t0.ruta AS ruta_4, t0.ruta_auxiliar AS ruta_auxiliar_5, t0.orden AS orden_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.icono AS icono_9, t0.class AS class_10, t0.endpoint AS endpoint_11, t0.tipo AS tipo_12, t0.parametrica AS parametrica_13, t0.grupo AS grupo_14, t0.sub_grupo AS sub_grupo_15, t0.funcion_id AS funcion_id_16 FROM sec_accion t0 WHERE t0.ruta = 'gh_perfil_cargo_new' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_cargo p0_
  LEFT JOIN par_proceso_par_cargo p2_ ON p0_.id = p2_.par_cargo_id
  LEFT JOIN par_proceso p1_ ON p1_.id = p2_.par_proceso_id
  LEFT JOIN ghperfil_cargo_par_cargo g4_ ON p0_.id = g4_.par_cargo_id
  LEFT JOIN gh_peril_cargo g3_ ON g3_.id = g4_.ghperfil_cargo_id
WHERE
  (
    g3_.id IS NULL
    OR g3_.estado_id IS NOT NULL
  )
  AND p1_.id = ?
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_cargo p0_ LEFT JOIN par_proceso_par_cargo p2_ ON p0_.id = p2_.par_cargo_id LEFT JOIN par_proceso p1_ ON p1_.id = p2_.par_proceso_id LEFT JOIN ghperfil_cargo_par_cargo g4_ ON p0_.id = g4_.par_cargo_id LEFT JOIN gh_peril_cargo g3_ ON g3_.id = g4_.ghperfil_cargo_id WHERE (g3_.id IS NULL OR g3_.estado_id IS NOT NULL) AND p1_.id = 0 ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.descripcion AS descripcion_2
FROM
  par_competencia_organizacional p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2 FROM par_competencia_organizacional p0_ ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.tipo_permisos AS tipo_permisos_2,
  p0_.estado_id AS estado_id_3,
  p0_.proceso_responsable_id AS proceso_responsable_id_4
FROM
  par_sistema_informatico p0_
WHERE
  p0_.estado_id = 1
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.tipo_permisos AS tipo_permisos_2, p0_.estado_id AS estado_id_3, p0_.proceso_responsable_id AS proceso_responsable_id_4 FROM par_sistema_informatico p0_ WHERE p0_.estado_id = 1 ORDER BY p0_.nombre ASC;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.direccion AS direccion_2,
  t0_.telefono AS telefono_3,
  t0_.correo AS correo_4,
  t0_.logo AS logo_5,
  t0_.create_at AS create_at_6,
  t0_.create_user AS create_user_7,
  t0_.update_at AS update_at_8,
  t0_.update_user AS update_user_9,
  t0_.nit AS nit_10,
  t0_.digito_verificacion AS digito_verificacion_11,
  t0_.representante_legal AS representante_legal_12,
  t0_.abreviatura AS abreviatura_13
FROM
  ter_empresa t0_
ORDER BY
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.direccion AS direccion_2, t0_.telefono AS telefono_3, t0_.correo AS correo_4, t0_.logo AS logo_5, t0_.create_at AS create_at_6, t0_.create_user AS create_user_7, t0_.update_at AS update_at_8, t0_.update_user AS update_user_9, t0_.nit AS nit_10, t0_.digito_verificacion AS digito_verificacion_11, t0_.representante_legal AS representante_legal_12, t0_.abreviatura AS abreviatura_13 FROM ter_empresa t0_ ORDER BY t0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.subproceso AS subproceso_1,
  p0_.create_at AS create_at_2,
  p0_.create_user AS create_user_3,
  p0_.update_at AS update_at_4,
  p0_.update_user AS update_user_5,
  p0_.codigo_tr AS codigo_tr_6,
  p0_.documentos_tr AS documentos_tr_7,
  p0_.proceso_id AS proceso_id_8
FROM
  par_subproceso p0_
ORDER BY
  p0_.subproceso ASC

SELECT p0_.id AS id_0, p0_.subproceso AS subproceso_1, p0_.create_at AS create_at_2, p0_.create_user AS create_user_3, p0_.update_at AS update_at_4, p0_.update_user AS update_user_5, p0_.codigo_tr AS codigo_tr_6, p0_.documentos_tr AS documentos_tr_7, p0_.proceso_id AS proceso_id_8 FROM par_subproceso p0_ ORDER BY p0_.subproceso ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_cargo p0_
  LEFT JOIN par_proceso_par_cargo p2_ ON p0_.id = p2_.par_cargo_id
  LEFT JOIN par_proceso p1_ ON p1_.id = p2_.par_proceso_id
WHERE
  p0_.id IS NULL
  OR p1_.id = ?
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_cargo p0_ LEFT JOIN par_proceso_par_cargo p2_ ON p0_.id = p2_.par_cargo_id LEFT JOIN par_proceso p1_ ON p1_.id = p2_.par_proceso_id WHERE p0_.id IS NULL OR p1_.id = 0 ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.proceso_id AS proceso_id_2
FROM
  par_recursos_perfil p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.proceso_id AS proceso_id_2 FROM par_recursos_perfil p0_ ORDER BY p0_.nombre ASC;

SELECT
  t0_.id AS id_0,
  t0_.nombre AS nombre_1,
  t0_.comportamiento AS comportamiento_2
FROM
  ter_sede_empresa t0_
  LEFT JOIN ter_sede_empresa_ter_empresa t2_ ON t0_.id = t2_.ter_sede_empresa_id
  LEFT JOIN ter_empresa t1_ ON t1_.id = t2_.ter_empresa_id
WHERE
  t0_.nombre IS NULL
  OR t1_.id IN (?)
ORDER BY
  t0_.nombre ASC

SELECT t0_.id AS id_0, t0_.nombre AS nombre_1, t0_.comportamiento AS comportamiento_2 FROM ter_sede_empresa t0_ LEFT JOIN ter_sede_empresa_ter_empresa t2_ ON t0_.id = t2_.ter_sede_empresa_id LEFT JOIN ter_empresa t1_ ON t1_.id = t2_.ter_empresa_id WHERE t0_.nombre IS NULL OR t1_.id IN (0) ORDER BY t0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.descripcion AS descripcion_2
FROM
  par_competencia_funcional p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2 FROM par_competencia_funcional p0_ ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nivel_educativo AS nivel_educativo_1
FROM
  par_nivel_educativo p0_

SELECT p0_.id AS id_0, p0_.nivel_educativo AS nivel_educativo_1 FROM par_nivel_educativo p0_;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.codigo_rf AS codigo_rf_2,
  p0_.fuente_datos_rffuid AS fuente_datos_rffuid_3,
  p0_.activa_tabla_retencion AS activa_tabla_retencion_4
FROM
  par_proceso p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.codigo_rf AS codigo_rf_2, p0_.fuente_datos_rffuid AS fuente_datos_rffuid_3, p0_.activa_tabla_retencion AS activa_tabla_retencion_4 FROM par_proceso p0_ ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.perfil AS perfil_1
FROM
  par_tipo_perfil p0_

SELECT p0_.id AS id_0, p0_.perfil AS perfil_1 FROM par_tipo_perfil p0_;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.descripcion AS descripcion_2
FROM
  par_nivel_autoridad p0_

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.descripcion AS descripcion_2 FROM par_nivel_autoridad p0_;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_tipo_contrato p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_tipo_contrato p0_ ORDER BY p0_.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1
FROM
  par_tipo_vinculacion p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1 FROM par_tipo_vinculacion p0_ ORDER BY p0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_login AS last_login_5,
  t0.request_token_change AS request_token_change_6,
  t0.last_request_token AS last_request_token_7,
  t0.enabled AS enabled_8,
  t0.email AS email_9,
  t0.attempt_fail_login AS attempt_fail_login_10,
  t0.persona_id AS persona_id_11
FROM
  sec_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.last_login AS last_login_5, t0.request_token_change AS request_token_change_6, t0.last_request_token AS last_request_token_7, t0.enabled AS enabled_8, t0.email AS email_9, t0.attempt_fail_login AS attempt_fail_login_10, t0.persona_id AS persona_id_11 FROM sec_user t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.fecha_consulta AS fecha_consulta_2
FROM
  seg_control_clientes_vencidos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.fecha_consulta AS fecha_consulta_2 FROM seg_control_clientes_vencidos t0 WHERE t0.id = 1;