https://pruebassl1.cultura.gob.cl/api/admin/secure/postulaciones/seleccion

Query Metrics

3 Database Queries
3 Different statements
6.34 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.81 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombres AS nombres_5, t0.activo AS activo_6, t0.super_admin AS super_admin_7, t0.region_id AS region_id_8 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "dcqy.95@gmail.com"
]
2 0.70 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.orden AS orden_3 FROM region t0 INNER JOIN user_region ON t0.id = user_region.region_id WHERE user_region.user_id = ?
Parameters:
[
  150
]
3 4.83 ms
SELECT p0_.id AS id_0, p0_.monto_requerido AS monto_requerido_1, p0_.formulario_postulacion AS formulario_postulacion_2, p0_.documentos_postulacion AS documentos_postulacion_3, p0_.certificado_postulacion AS certificado_postulacion_4, p0_.resultado_admisibilidad AS resultado_admisibilidad_5, p0_.estado_admisibilidad AS estado_admisibilidad_6, p0_.formulario_admisibilidad AS formulario_admisibilidad_7, p0_.nota_final_evaluacion AS nota_final_evaluacion_8, p0_.formulario_evaluacion AS formulario_evaluacion_9, p0_.estado_evaluacion AS estado_evaluacion_10, p0_.formulario_seleccion AS formulario_seleccion_11, p0_.estado_seleccion AS estado_seleccion_12, p0_.resultado_seleccion AS resultado_seleccion_13, p0_.monto_adjudicado AS monto_adjudicado_14, p0_.documentos AS documentos_15, p0_.estado AS estado_16, p0_.created_at AS created_at_17, p0_.updated_at AS updated_at_18, p0_.postulated_at AS postulated_at_19, p0_.admisibilidad_at AS admisibilidad_at_20, p0_.evaluacion_at AS evaluacion_at_21, p0_.seleccion_at AS seleccion_at_22, p1_.id AS id_23, p1_.nombre AS nombre_24, p1_.resenia AS resenia_25, p1_.region AS region_26, p1_.comuna AS comuna_27, p1_.direccion AS direccion_28, p1_.georeferencia AS georeferencia_29, p1_.nombre_contacto AS nombre_contacto_30, p1_.email_contacto AS email_contacto_31, p1_.redes_sociales AS redes_sociales_32, p1_.certificado_punto AS certificado_punto_33, p1_.nombre_persona_juridica AS nombre_persona_juridica_34, p1_.nombre_representante_legal AS nombre_representante_legal_35, p1_.rut_persona_juridica AS rut_persona_juridica_36, p1_.rut_representante_legal AS rut_representante_legal_37, p1_.direccion_postal AS direccion_postal_38, p1_.correo_electronico_1 AS correo_electronico_1_39, p1_.correo_electronico_2 AS correo_electronico_2_40, p1_.telefono_1 AS telefono_1_41, p1_.telefono_2 AS telefono_2_42, p1_.organizacion_comunitaria_id AS organizacion_comunitaria_id_43, p1_.doc_estatuto_organizacion AS doc_estatuto_organizacion_44, p1_.doc_certificado_vigencia_persona_juridica AS doc_certificado_vigencia_persona_juridica_45, p1_.doc_acredita_personeria_vigente AS doc_acredita_personeria_vigente_46, p1_.doc_listado_personas AS doc_listado_personas_47, p1_.documentos AS documentos_48, p1_.rut AS rut_49, p1_.dv AS dv_50, p1_.activo AS activo_51, p1_.verificado AS verificado_52, p1_.fecha_verificacion AS fecha_verificacion_53, p2_.id AS id_54, p2_.nombre AS nombre_55, p2_.descripcion AS descripcion_56, p2_.anio AS anio_57, p2_.bases AS bases_58, p2_.presupuesto AS presupuesto_59, p2_.puntaje_eval_corte AS puntaje_eval_corte_60, p2_.cuestionarios AS cuestionarios_61, p2_.documentos AS documentos_62, p2_.estado AS estado_63, p2_.apertura AS apertura_64, p0_.convocatoria_id AS convocatoria_id_65, p0_.punto_cultura_id AS punto_cultura_id_66, p0_.usuario_admisibilidad_id AS usuario_admisibilidad_id_67, p0_.usuario_evaluacion_id AS usuario_evaluacion_id_68, p0_.usuario_seleccion_id AS usuario_seleccion_id_69, p1_.postulacion_punto_id AS postulacion_punto_id_70 FROM pc_postulacion p0_ INNER JOIN pc_punto_cultura p1_ ON p0_.punto_cultura_id = p1_.id INNER JOIN pc_convocatorias p2_ ON p0_.convocatoria_id = p2_.id WHERE p1_.activo = ? AND p1_.verificado = ? AND p0_.estado = ? AND p0_.estado_admisibilidad = ? AND p0_.resultado_admisibilidad = ? AND p0_.estado_evaluacion = ? AND p0_.nota_final_evaluacion >= p2_.puntaje_eval_corte ORDER BY p0_.resultado_seleccion DESC
Parameters:
[
  1
  1
  "send"
  "send"
  1
  "send"
]

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

Class Mapping errors
App\Entity\User No errors.
App\Entity\Region No errors.
App\Entity\PcPostulacion
  • The mappings App\Entity\PcPostulacion#convocatoria and App\Entity\PcConvocatorias#postulacion are inconsistent with each other.
  • The association App\Entity\PcPostulacion#usuario_admisibilidad refers to the inverse side field App\Entity\User#postulacion_admisibilidad which does not exist.
  • The association App\Entity\PcPostulacion#usuario_evaluacion refers to the inverse side field App\Entity\User#postulacion_evaluacion which does not exist.
  • The association App\Entity\PcPostulacion#usuario_seleccion refers to the inverse side field App\Entity\User#postulacion_seleccion which does not exist.
App\Entity\PcPuntoCultura
  • The association App\Entity\PcPuntoCultura#postulacion refers to the owning side field App\Entity\PcPuntoCultura#puntoCultura which does not exist.
App\Entity\PcConvocatorias
  • The association App\Entity\PcConvocatorias#postulacion refers to the owning side field App\Entity\PcPuntoCultura#puntoCultura which does not exist.
App\Entity\Postulacion No errors.