Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.anio AS anio_4,
  t0.bases AS bases_5,
  t0.presupuesto AS presupuesto_6,
  t0.puntaje_eval_corte AS puntaje_eval_corte_7,
  t0.cuestionarios AS cuestionarios_8,
  t0.documentos AS documentos_9,
  t0.estado AS estado_10,
  t0.apertura AS apertura_11
FROM
  pc_convocatorias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.anio AS anio_4, t0.bases AS bases_5, t0.presupuesto AS presupuesto_6, t0.puntaje_eval_corte AS puntaje_eval_corte_7, t0.cuestionarios AS cuestionarios_8, t0.documentos AS documentos_9, t0.estado AS estado_10, t0.apertura AS apertura_11 FROM pc_convocatorias t0 WHERE t0.id = 1;

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.resenia AS resenia_2,
  p0_.region AS region_3,
  p0_.comuna AS comuna_4,
  p0_.direccion AS direccion_5,
  p0_.georeferencia AS georeferencia_6,
  p0_.nombre_contacto AS nombre_contacto_7,
  p0_.email_contacto AS email_contacto_8,
  p0_.redes_sociales AS redes_sociales_9,
  p0_.certificado_punto AS certificado_punto_10,
  p0_.nombre_persona_juridica AS nombre_persona_juridica_11,
  p0_.nombre_representante_legal AS nombre_representante_legal_12,
  p0_.rut_persona_juridica AS rut_persona_juridica_13,
  p0_.rut_representante_legal AS rut_representante_legal_14,
  p0_.direccion_postal AS direccion_postal_15,
  p0_.correo_electronico_1 AS correo_electronico_1_16,
  p0_.correo_electronico_2 AS correo_electronico_2_17,
  p0_.telefono_1 AS telefono_1_18,
  p0_.telefono_2 AS telefono_2_19,
  p0_.organizacion_comunitaria_id AS organizacion_comunitaria_id_20,
  p0_.doc_estatuto_organizacion AS doc_estatuto_organizacion_21,
  p0_.doc_certificado_vigencia_persona_juridica AS doc_certificado_vigencia_persona_juridica_22,
  p0_.doc_acredita_personeria_vigente AS doc_acredita_personeria_vigente_23,
  p0_.doc_listado_personas AS doc_listado_personas_24,
  p0_.documentos AS documentos_25,
  p0_.rut AS rut_26,
  p0_.dv AS dv_27,
  p0_.activo AS activo_28,
  p0_.verificado AS verificado_29,
  p0_.fecha_verificacion AS fecha_verificacion_30,
  p0_.postulacion_punto_id AS postulacion_punto_id_31
FROM
  pc_punto_cultura p0_
WHERE
  p0_.id = ?
  AND p0_.rut = ?
  AND p0_.dv = ?
  AND p0_.activo = ?
  AND p0_.verificado = ?

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.resenia AS resenia_2, p0_.region AS region_3, p0_.comuna AS comuna_4, p0_.direccion AS direccion_5, p0_.georeferencia AS georeferencia_6, p0_.nombre_contacto AS nombre_contacto_7, p0_.email_contacto AS email_contacto_8, p0_.redes_sociales AS redes_sociales_9, p0_.certificado_punto AS certificado_punto_10, p0_.nombre_persona_juridica AS nombre_persona_juridica_11, p0_.nombre_representante_legal AS nombre_representante_legal_12, p0_.rut_persona_juridica AS rut_persona_juridica_13, p0_.rut_representante_legal AS rut_representante_legal_14, p0_.direccion_postal AS direccion_postal_15, p0_.correo_electronico_1 AS correo_electronico_1_16, p0_.correo_electronico_2 AS correo_electronico_2_17, p0_.telefono_1 AS telefono_1_18, p0_.telefono_2 AS telefono_2_19, p0_.organizacion_comunitaria_id AS organizacion_comunitaria_id_20, p0_.doc_estatuto_organizacion AS doc_estatuto_organizacion_21, p0_.doc_certificado_vigencia_persona_juridica AS doc_certificado_vigencia_persona_juridica_22, p0_.doc_acredita_personeria_vigente AS doc_acredita_personeria_vigente_23, p0_.doc_listado_personas AS doc_listado_personas_24, p0_.documentos AS documentos_25, p0_.rut AS rut_26, p0_.dv AS dv_27, p0_.activo AS activo_28, p0_.verificado AS verificado_29, p0_.fecha_verificacion AS fecha_verificacion_30, p0_.postulacion_punto_id AS postulacion_punto_id_31 FROM pc_punto_cultura p0_ WHERE p0_.id = 1 AND p0_.rut = '44444444' AND p0_.dv = '4' AND p0_.activo = 1 AND p0_.verificado = 1;

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_
  LEFT JOIN pc_punto_cultura p1_ ON p0_.punto_cultura_id = p1_.id
  LEFT JOIN pc_convocatorias p2_ ON p0_.convocatoria_id = p2_.id
WHERE
  p1_.id = ?
  AND p1_.rut = ?
  AND p1_.dv = ?
  AND p2_.id = ?
  AND p1_.activo = ?
  AND p1_.verificado = ?

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_ LEFT JOIN pc_punto_cultura p1_ ON p0_.punto_cultura_id = p1_.id LEFT JOIN pc_convocatorias p2_ ON p0_.convocatoria_id = p2_.id WHERE p1_.id = 1 AND p1_.rut = '44444444' AND p1_.dv = '4' AND p2_.id = 1 AND p1_.activo = 1 AND p1_.verificado = 1;

SELECT
  t0.id AS id_1,
  t0.peso AS peso_2,
  t0.convocatorias_id AS convocatorias_id_3,
  t0.criterios_id AS criterios_id_4
FROM
  pc_criterios_convocatorias t0
WHERE
  t0.convocatorias_id = ?

SELECT t0.id AS id_1, t0.peso AS peso_2, t0.convocatorias_id AS convocatorias_id_3, t0.criterios_id AS criterios_id_4 FROM pc_criterios_convocatorias t0 WHERE t0.convocatorias_id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.puntajes AS puntajes_4
FROM
  pc_criterios t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.puntajes AS puntajes_4 FROM pc_criterios t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.descripcion AS descripcion_3,
  t0.puntajes AS puntajes_4
FROM
  pc_criterios t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.puntajes AS puntajes_4 FROM pc_criterios t0 WHERE t0.id = 2;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO pc_postulacion (
  monto_requerido, formulario_postulacion,
  documentos_postulacion, certificado_postulacion,
  resultado_admisibilidad, estado_admisibilidad,
  formulario_admisibilidad, nota_final_evaluacion,
  formulario_evaluacion, estado_evaluacion,
  formulario_seleccion, estado_seleccion,
  resultado_seleccion, monto_adjudicado,
  documentos, estado, created_at, updated_at,
  postulated_at, admisibilidad_at,
  evaluacion_at, seleccion_at, convocatoria_id,
  punto_cultura_id, usuario_admisibilidad_id,
  usuario_evaluacion_id, usuario_seleccion_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO pc_postulacion (monto_requerido, formulario_postulacion, documentos_postulacion, certificado_postulacion, resultado_admisibilidad, estado_admisibilidad, formulario_admisibilidad, nota_final_evaluacion, formulario_evaluacion, estado_evaluacion, formulario_seleccion, estado_seleccion, resultado_seleccion, monto_adjudicado, documentos, estado, created_at, updated_at, postulated_at, admisibilidad_at, evaluacion_at, seleccion_at, convocatoria_id, punto_cultura_id, usuario_admisibilidad_id, usuario_evaluacion_id, usuario_seleccion_id) VALUES (0, '[{\"type\":\"text\",\"order\":1,\"title\":\"Pregunta 1\",\"textHelp\":\"ingrese respuesta a pregunta 1\",\"isRequired\":true,\"description\":\"esta es la pregunta #1\",\"valor\":null},{\"type\":\"textarea\",\"order\":2,\"title\":\"Pregunta 2\",\"textHelp\":\"ingrese respuesta pregunta #2\",\"isRequired\":false,\"description\":\"Pregunta #2\",\"valor\":null}]', '[{\"file\":{\"path\":\"\\/documentos\\/pcconvocatorias\\/convocatoria_1\\/dummy.pdf-68c81ca68041e.pdf\",\"new_filename\":\"dummy.pdf-68c81ca68041e.pdf\",\"original_name\":\"dummy.pdf\"},\"order\":1,\"title\":\"documento #1 \",\"textHelp\":\"baje el documento, rellene, firme, y escanee y adjunte \",\"isRequired\":false,\"description\":\"ingrese el documento #1\",\"valor\":null}]', NULL, NULL, NULL, '{\"1\":{\"pregunta\":\"\\u00bfAdmisibilidad?\",\"tipo\":\"opcion\",\"opciones\":[\"Si\",\"No\"],\"respuesta\":\"\"},\"2\":{\"pregunta\":\"Observaciones internas\",\"tipo\":\"texarea\",\"respuesta\":\"\"},\"3\":{\"pregunta\":\"Observaciones publicas\",\"tipo\":\"texarea\",\"respuesta\":\"\"}}', NULL, '[{\"tipo\":\"criterio\",\"id\":7,\"nombre\":\"criterio erojasc 1\",\"descripcion\":\"criterio 1\",\"peso\":60,\"puntajes\":[{\"puntaje\":1,\"descripcion\":\"bajo\"},{\"puntaje\":3,\"descripcion\":\"medio\"},{\"puntaje\":5,\"descripcion\":\"alto\"},{\"puntaje\":7,\"descripcion\":\"perfecto\"}],\"valor\":null,\"justificacion\":\"\"},{\"tipo\":\"criterio\",\"id\":8,\"nombre\":\"criterio erojasc 2\",\"descripcion\":\"asdfdsaf\",\"peso\":40,\"puntajes\":[{\"puntaje\":1,\"descripcion\":\"malo\"},{\"puntaje\":3,\"descripcion\":\"regultar\"},{\"puntaje\":5,\"descripcion\":\"bueno\"},{\"puntaje\":7,\"descripcion\":\"muy bueno\"}],\"valor\":null,\"justificacion\":\"\"},{\"tipo\":\"texarea\",\"pregunta\":\"Justificaci\\u00f3n general\",\"respuesta\":\"\"}]', NULL, '{\"1\":{\"pregunta\":\"\",\"tipo\":\"opcion\",\"opciones\":[\"Seleccionado\",\"No seleccionado\"],\"respuesta\":\"\"},\"2\":{\"pregunta\":\"Monto adjudicado\",\"tipo\":\"text\",\"respuesta\":\"\"},\"3\":{\"pregunta\":\"Observaciones\",\"tipo\":\"texarea\",\"respuesta\":\"\"}}', NULL, NULL, NULL, '[]', 'save', '2025-09-15 11:05:56', '2025-09-15 11:05:56', NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL);

"COMMIT"

"COMMIT";