Symfony Profiler

Query Metrics

109 Database Queries
62 Different statements
51.60 ms Query time
1 Invalid entities
Queries


SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?
SET @loan = 190668; CALL prestamo_refresh(@loan);
SELECT p0_.id AS id_0, p0_.amortizacion_id AS amortizacion_id_1, p0_.tiene_abonos AS tiene_abonos_2, p0_.detalle_anterior_id AS detalle_anterior_id_3, p0_.no_pago AS no_pago_4, p0_.saldo_inicial AS saldo_inicial_5, p0_.cuota_cantidad AS cuota_cantidad_6, p0_.saldo_cuota_real AS saldo_cuota_real_7, p0_.intereses AS intereses_8, p0_.interes AS interes_9, p0_.iva AS iva_10, p0_.capital AS capital_11, p0_.capital_insoluto AS capital_insoluto_12, p0_.monto_pagado AS monto_pagado_13, p0_.interes_generado AS interes_generado_14, p0_.saldo_cuota_restante AS saldo_cuota_restante_15, p0_.saldo_insoluto_real AS saldo_insoluto_real_16, p0_.fecha_pago AS fecha_pago_17, p0_.tipo AS tipo_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.estado AS estado_21, p0_.amortizacion_id AS amortizacion_id_22 FROM prestamo_amortizaciones_detalles p0_ WHERE p0_.amortizacion_id = ? AND (p0_.saldo_cuota_real > 0 OR p0_.interes_generado > 0) ORDER BY p0_.fecha_pago ASC
SELECT t0.id AS id_1, t0.origin_id AS origin_id_2, t0.origin_model AS origin_model_3, t0.monto AS monto_4, t0.tipo_concepto AS tipo_concepto_5, t0.concepto AS concepto_6, t0.created_at AS created_at_7, t0.es_pago_directo AS es_pago_directo_8, t0.estado AS estado_9, t0.naturaleza AS naturaleza_10, t0.devuelto_total AS devuelto_total_11, t0.pago_id AS pago_id_12, t13.id AS id_14, t13.created_at AS created_at_15, t13.status AS status_16, t13.is_nc AS is_nc_17, t13.is_op_trans AS is_op_trans_18, t13.is_co_trans AS is_co_trans_19, t13.is_st_trans AS is_st_trans_20, t13.is_un_trans AS is_un_trans_21, t13.is_program AS is_program_22, t13.id_openpay AS id_openpay_23, t13.auth_openpay AS auth_openpay_24, t13.id_conecta AS id_conecta_25, t13.auth_conecta AS auth_conecta_26, t13.id_stripe AS id_stripe_27, t13.auth_stripe AS auth_stripe_28, t13.id_unlimit AS id_unlimit_29, t13.auth_unlimit AS auth_unlimit_30, t13.fec_pago AS fec_pago_31, t13.monto AS monto_32, t13.rutasoporte AS rutasoporte_33, t13.approved_at AS approved_at_34, t13.rejected_at AS rejected_at_35, t13.reject_cause AS reject_cause_36, t13.returned_at AS returned_at_37, t13.return_cause AS return_cause_38, t13.observations AS observations_39, t13.is_recurrent AS is_recurrent_40, t13.attempt_number AS attempt_number_41, t13.attempt_max AS attempt_max_42, t13.custom_recurrence AS custom_recurrence_43, t13.interval_minutes AS interval_minutes_44, t13.aplicado AS aplicado_45, t13.finiquito AS finiquito_46, t13.adjunto AS adjunto_47, t13.created_by AS created_by_48, t13.id_prestamo AS id_prestamo_49, t13.id_cuota AS id_cuota_50, t13.op_inst AS op_inst_51, t13.co_inst AS co_inst_52, t13.st_inst AS st_inst_53, t13.un_inst AS un_inst_54, t13.approved_by AS approved_by_55, t13.rejected_by AS rejected_by_56, t13.returned_by AS returned_by_57, t0.amortizacion_detalle_id AS amortizacion_detalle_id_58, t59.id AS id_60, t59.amortizacion_id AS amortizacion_id_61, t59.tiene_abonos AS tiene_abonos_62, t59.detalle_anterior_id AS detalle_anterior_id_63, t59.no_pago AS no_pago_64, t59.saldo_inicial AS saldo_inicial_65, t59.cuota_cantidad AS cuota_cantidad_66, t59.saldo_cuota_real AS saldo_cuota_real_67, t59.intereses AS intereses_68, t59.interes AS interes_69, t59.iva AS iva_70, t59.capital AS capital_71, t59.capital_insoluto AS capital_insoluto_72, t59.monto_pagado AS monto_pagado_73, t59.interes_generado AS interes_generado_74, t59.saldo_cuota_restante AS saldo_cuota_restante_75, t59.saldo_insoluto_real AS saldo_insoluto_real_76, t59.fecha_pago AS fecha_pago_77, t59.tipo AS tipo_78, t59.created_at AS created_at_79, t59.updated_at AS updated_at_80, t59.estado AS estado_81, t59.amortizacion_id AS amortizacion_id_82 FROM prestamo_amortizaciones_detalles_pagos t0 LEFT JOIN prestamo_pago t13 ON t0.pago_id = t13.id LEFT JOIN prestamo_amortizaciones_detalles t59 ON t0.amortizacion_detalle_id = t59.id WHERE t0.amortizacion_detalle_id IN (?, ?, ?, ?, ?)
SELECT p0_.id AS id_0, p0_.amortizacion_id AS amortizacion_id_1, p0_.tiene_abonos AS tiene_abonos_2, p0_.detalle_anterior_id AS detalle_anterior_id_3, p0_.no_pago AS no_pago_4, p0_.saldo_inicial AS saldo_inicial_5, p0_.cuota_cantidad AS cuota_cantidad_6, p0_.saldo_cuota_real AS saldo_cuota_real_7, p0_.intereses AS intereses_8, p0_.interes AS interes_9, p0_.iva AS iva_10, p0_.capital AS capital_11, p0_.capital_insoluto AS capital_insoluto_12, p0_.monto_pagado AS monto_pagado_13, p0_.interes_generado AS interes_generado_14, p0_.saldo_cuota_restante AS saldo_cuota_restante_15, p0_.saldo_insoluto_real AS saldo_insoluto_real_16, p0_.fecha_pago AS fecha_pago_17, p0_.tipo AS tipo_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.estado AS estado_21, p0_.amortizacion_id AS amortizacion_id_22 FROM prestamo_amortizaciones_detalles p0_ WHERE p0_.amortizacion_id = ? ORDER BY p0_.fecha_pago ASC
SELECT t0.id AS id_1, t0.origin_id AS origin_id_2, t0.origin_model AS origin_model_3, t0.monto AS monto_4, t0.tipo_concepto AS tipo_concepto_5, t0.concepto AS concepto_6, t0.created_at AS created_at_7, t0.es_pago_directo AS es_pago_directo_8, t0.estado AS estado_9, t0.naturaleza AS naturaleza_10, t0.devuelto_total AS devuelto_total_11, t0.pago_id AS pago_id_12, t13.id AS id_14, t13.created_at AS created_at_15, t13.status AS status_16, t13.is_nc AS is_nc_17, t13.is_op_trans AS is_op_trans_18, t13.is_co_trans AS is_co_trans_19, t13.is_st_trans AS is_st_trans_20, t13.is_un_trans AS is_un_trans_21, t13.is_program AS is_program_22, t13.id_openpay AS id_openpay_23, t13.auth_openpay AS auth_openpay_24, t13.id_conecta AS id_conecta_25, t13.auth_conecta AS auth_conecta_26, t13.id_stripe AS id_stripe_27, t13.auth_stripe AS auth_stripe_28, t13.id_unlimit AS id_unlimit_29, t13.auth_unlimit AS auth_unlimit_30, t13.fec_pago AS fec_pago_31, t13.monto AS monto_32, t13.rutasoporte AS rutasoporte_33, t13.approved_at AS approved_at_34, t13.rejected_at AS rejected_at_35, t13.reject_cause AS reject_cause_36, t13.returned_at AS returned_at_37, t13.return_cause AS return_cause_38, t13.observations AS observations_39, t13.is_recurrent AS is_recurrent_40, t13.attempt_number AS attempt_number_41, t13.attempt_max AS attempt_max_42, t13.custom_recurrence AS custom_recurrence_43, t13.interval_minutes AS interval_minutes_44, t13.aplicado AS aplicado_45, t13.finiquito AS finiquito_46, t13.adjunto AS adjunto_47, t13.created_by AS created_by_48, t13.id_prestamo AS id_prestamo_49, t13.id_cuota AS id_cuota_50, t13.op_inst AS op_inst_51, t13.co_inst AS co_inst_52, t13.st_inst AS st_inst_53, t13.un_inst AS un_inst_54, t13.approved_by AS approved_by_55, t13.rejected_by AS rejected_by_56, t13.returned_by AS returned_by_57, t0.amortizacion_detalle_id AS amortizacion_detalle_id_58, t59.id AS id_60, t59.amortizacion_id AS amortizacion_id_61, t59.tiene_abonos AS tiene_abonos_62, t59.detalle_anterior_id AS detalle_anterior_id_63, t59.no_pago AS no_pago_64, t59.saldo_inicial AS saldo_inicial_65, t59.cuota_cantidad AS cuota_cantidad_66, t59.saldo_cuota_real AS saldo_cuota_real_67, t59.intereses AS intereses_68, t59.interes AS interes_69, t59.iva AS iva_70, t59.capital AS capital_71, t59.capital_insoluto AS capital_insoluto_72, t59.monto_pagado AS monto_pagado_73, t59.interes_generado AS interes_generado_74, t59.saldo_cuota_restante AS saldo_cuota_restante_75, t59.saldo_insoluto_real AS saldo_insoluto_real_76, t59.fecha_pago AS fecha_pago_77, t59.tipo AS tipo_78, t59.created_at AS created_at_79, t59.updated_at AS updated_at_80, t59.estado AS estado_81, t59.amortizacion_id AS amortizacion_id_82 FROM prestamo_amortizaciones_detalles_pagos t0 LEFT JOIN prestamo_pago t13 ON t0.pago_id = t13.id LEFT JOIN prestamo_amortizaciones_detalles t59 ON t0.amortizacion_detalle_id = t59.id WHERE t0.amortizacion_detalle_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT p0_.id AS id_0, p0_.amortizacion_id AS amortizacion_id_1, p0_.tiene_abonos AS tiene_abonos_2, p0_.detalle_anterior_id AS detalle_anterior_id_3, p0_.no_pago AS no_pago_4, p0_.saldo_inicial AS saldo_inicial_5, p0_.cuota_cantidad AS cuota_cantidad_6, p0_.saldo_cuota_real AS saldo_cuota_real_7, p0_.intereses AS intereses_8, p0_.interes AS interes_9, p0_.iva AS iva_10, p0_.capital AS capital_11, p0_.capital_insoluto AS capital_insoluto_12, p0_.monto_pagado AS monto_pagado_13, p0_.interes_generado AS interes_generado_14, p0_.saldo_cuota_restante AS saldo_cuota_restante_15, p0_.saldo_insoluto_real AS saldo_insoluto_real_16, p0_.fecha_pago AS fecha_pago_17, p0_.tipo AS tipo_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.estado AS estado_21, p0_.amortizacion_id AS amortizacion_id_22 FROM prestamo_amortizaciones_detalles p0_ WHERE p0_.amortizacion_id = ? AND (p0_.saldo_cuota_real > 0 OR p0_.interes_generado > 0) AND p0_.fecha_pago >= ? ORDER BY p0_.fecha_pago ASC LIMIT 1
SELECT t0.id AS id_1, t0.amortizacion_id AS amortizacion_id_2, t0.tiene_abonos AS tiene_abonos_3, t0.detalle_anterior_id AS detalle_anterior_id_4, t0.no_pago AS no_pago_5, t0.saldo_inicial AS saldo_inicial_6, t0.cuota_cantidad AS cuota_cantidad_7, t0.saldo_cuota_real AS saldo_cuota_real_8, t0.intereses AS intereses_9, t0.interes AS interes_10, t0.iva AS iva_11, t0.capital AS capital_12, t0.capital_insoluto AS capital_insoluto_13, t0.monto_pagado AS monto_pagado_14, t0.interes_generado AS interes_generado_15, t0.saldo_cuota_restante AS saldo_cuota_restante_16, t0.saldo_insoluto_real AS saldo_insoluto_real_17, t0.fecha_pago AS fecha_pago_18, t0.tipo AS tipo_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.estado AS estado_22, t0.amortizacion_id AS amortizacion_id_23, t24.id AS id_25, t24.prestamo_solicitud_id AS prestamo_solicitud_id_26, t24.prestamo AS prestamo_27, t24.tasa_nominal AS tasa_nominal_28, t24.tasa_teorica AS tasa_teorica_29, t24.tipo_tasa_inicial AS tipo_tasa_inicial_30, t24.tasa_anual AS tasa_anual_31, t24.tasa_anual_interna AS tasa_anual_interna_32, t24.interes_anual AS interes_anual_33, t24.cantidad_periodos AS cantidad_periodos_34, t24.tasa_cantidad_periodos AS tasa_cantidad_periodos_35, t24.pago_periodo AS pago_periodo_36, t24.total_pago AS total_pago_37, t24.cat AS cat_38, t24.created_at AS created_at_39, t24.estado AS estado_40, t24.prestamo_solicitud_id AS prestamo_solicitud_id_41 FROM prestamo_amortizaciones_detalles t0 INNER JOIN prestamo_amortizaciones t24 ON t0.amortizacion_id = t24.id WHERE t0.amortizacion_id = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.tipo AS tipo_3, t0.status AS status_4, t0.fec_deposito AS fec_deposito_5, t0.monto AS monto_6, t0.observations AS observations_7, t0.pago_procesado AS pago_procesado_8, t0.latitud AS latitud_9, t0.longitud AS longitud_10, t0.created_by AS created_by_11, t0.id_prestamo AS id_prestamo_12, t0.id_pago AS id_pago_13, t14.id_stp AS id_stp_15, t14.clave_rastreo AS clave_rastreo_16, t14.estado AS estado_17, t14.fecha_estado AS fecha_estado_18, t14.fecha_operacion AS fecha_operacion_19, t14.causa_devolucion AS causa_devolucion_20, t14.monto AS monto_21, t14.tipo_cuenta_beneficiario AS tipo_cuenta_beneficiario_22, t14.nombre_beneficiario AS nombre_beneficiario_23, t14.cuenta_beneficiario AS cuenta_beneficiario_24, t14.rfc_curp_beneficiario AS rfc_curp_beneficiario_25, t14.email_beneficiario AS email_beneficiario_26, t14.concepto_pago AS concepto_pago_27, t14.referencia_numerica AS referencia_numerica_28, t14.conciliacion_data AS conciliacion_data_29, t14.last_update AS last_update_30, t14.id_prestamo_deposito AS id_prestamo_deposito_31 FROM prestamo_deposito t0 LEFT JOIN stp_transaccion t14 ON t14.id_prestamo_deposito = t0.id WHERE t0.id_prestamo = ? ORDER BY t0.fec_deposito ASC
SELECT t0.id AS id_1, t0.seccion_id AS seccion_id_2, t0.seccion_orden AS seccion_orden_3, t0.seccion AS seccion_4, t0.campo_id AS campo_id_5, t0.campo_orden AS campo_orden_6, t0.campo AS campo_7, t0.campo_valor AS campo_valor_8, t0.modified_at AS modified_at_9, t0.id_prestamo AS id_prestamo_10, t0.campo_tipo AS campo_tipo_11, t0.campo_parent AS campo_parent_12, t0.modified_by AS modified_by_13 FROM prestamo_solicitud_formulario t0 WHERE t0.id_prestamo = ? ORDER BY t0.seccion_orden ASC, t0.campo_orden ASC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '24'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '25'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '26'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '92'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '93'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '27'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '94'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '95'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '33'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '28'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '29'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '126'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '58'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '30'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '96'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '134'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '135'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '136'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '137'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '138'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '173'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '277'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT campo_id, campo_tipo, campo_valor FROM prestamo_solicitud_formulario WHERE campo_valor IS NOT NULL AND campo_id = '278'  AND id_prestamo= '190668'  ORDER BY id DESC
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.id_prestamo = ? ORDER BY t0.fec_pago ASC
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.approved_at AS approved_at_3, t0.rejected_at AS rejected_at_4, t0.reject_cause AS reject_cause_5, t0.canceled_at AS canceled_at_6, t0.cancel_cause AS cancel_cause_7, t0.paid_at AS paid_at_8, t0.status AS status_9, t0.cat_promedio AS cat_promedio_10, t0.interes_anual AS interes_anual_11, t0.cant_pagos AS cant_pagos_12, t0.tasa_interes AS tasa_interes_13, t0.interes_mora AS interes_mora_14, t0.monto AS monto_15, t0.interes_monto AS interes_monto_16, t0.total AS total_17, t0.saldo_finiquito AS saldo_finiquito_18, t0.id_producto AS id_producto_19, t0.id_usuario AS id_usuario_20, t0.approved_by AS approved_by_21, t0.rejected_by AS rejected_by_22, t0.canceled_by AS canceled_by_23, t0.pay_op_inst AS pay_op_inst_24, t0.pay_co_inst AS pay_co_inst_25, t0.pay_st_inst AS pay_st_inst_26, t0.pay_un_inst AS pay_un_inst_27, t0.id_frecuencia_pago AS id_frecuencia_pago_28, t29.id AS id_30, t29.prestamo_solicitud_id AS prestamo_solicitud_id_31, t29.prestamo AS prestamo_32, t29.tasa_nominal AS tasa_nominal_33, t29.tasa_teorica AS tasa_teorica_34, t29.tipo_tasa_inicial AS tipo_tasa_inicial_35, t29.tasa_anual AS tasa_anual_36, t29.tasa_anual_interna AS tasa_anual_interna_37, t29.interes_anual AS interes_anual_38, t29.cantidad_periodos AS cantidad_periodos_39, t29.tasa_cantidad_periodos AS tasa_cantidad_periodos_40, t29.pago_periodo AS pago_periodo_41, t29.total_pago AS total_pago_42, t29.cat AS cat_43, t29.created_at AS created_at_44, t29.estado AS estado_45, t29.prestamo_solicitud_id AS prestamo_solicitud_id_46, t47.id AS id_48, t47.fecha_transaccion AS fecha_transaccion_49, t47.nombre AS nombre_50, t47.apellido_paterno AS apellido_paterno_51, t47.apellido_materno AS apellido_materno_52, t47.fecha_nacimiento AS fecha_nacimiento_53, t47.genero AS genero_54, t47.rfc AS rfc_55, t47.telf_movil AS telf_movil_56, t47.pais_nacimiento AS pais_nacimiento_57, t47.direccion AS direccion_58, t47.estado AS estado_59, t47.ciudad AS ciudad_60, t47.colonia AS colonia_61, t47.id_prestamo AS id_prestamo_62 FROM prestamo_solicitud t0 LEFT JOIN prestamo_amortizaciones t29 ON t29.prestamo_solicitud_id = t0.id LEFT JOIN prestamo_solicitud_buro_credito t47 ON t47.id_prestamo = t0.id WHERE t0.id_usuario = ?
SELECT t0.id AS id_1, t0.pago_id AS pago_id_2, t0.naturaleza AS naturaleza_3, t0.monto AS monto_4, t0.monto_devuelto AS monto_devuelto_5, t0.created_at AS created_at_6, t0.prestamo_id AS prestamo_id_7 FROM prestamo_pago_excedente t0 WHERE t0.prestamo_id = ?
SELECT t0.id AS id_1, t0.fec_vencimiento AS fec_vencimiento_2, t0.monto AS monto_3, t0.vencida AS vencida_4, t0.moras AS moras_5, t0.pagada AS pagada_6, t0.updated_at AS updated_at_7, t0.id_prestamo AS id_prestamo_8, t0.updated_by AS updated_by_9 FROM prestamo_cuota t0 WHERE t0.id_prestamo = ? ORDER BY t0.fec_vencimiento ASC
SELECT t0.id AS id_1, t0.activo AS activo_2, t0.descripcion AS descripcion_3, t0.mto_minimo AS mto_minimo_4, t0.mto_maximo AS mto_maximo_5, t0.cat_promedio AS cat_promedio_6, t0.interes_anual AS interes_anual_7, t0.tasa_interes AS tasa_interes_8, t0.plazo_minimo AS plazo_minimo_9, t0.plazo_maximo AS plazo_maximo_10, t0.interes_mora AS interes_mora_11, t0.primer_prestamo AS primer_prestamo_12, t0.id_categoria_producto AS id_categoria_producto_13 FROM producto t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.resena AS resena_3 FROM producto_categoria t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.enabled AS enabled_3, t0.id_openpay AS id_openpay_4, t0.id_conecta AS id_conecta_5, t0.id_stripe AS id_stripe_6, t0.id_stripe_setup_intent AS id_stripe_setup_intent_7, t0.has_to_validate_bureau AS has_to_validate_bureau_8, t0.image AS image_9, t0.image_size AS image_size_10, t0.updated_at AS updated_at_11, t0.created_at AS created_at_12, t0.last_login AS last_login_13, t0.pass_expiration_date AS pass_expiration_date_14, t0.dark_mode AS dark_mode_15, t0.nombres AS nombres_16, t0.apellidos AS apellidos_17, t0.telefono AS telefono_18, t0.cod_postal AS cod_postal_19, t0.estado AS estado_20, t0.ciudad AS ciudad_21, t0.direccion AS direccion_22, t0.roles AS roles_23, t0.2fa_enabled AS 2fa_enabled_24, t0.password AS password_25, t0.fetch_id AS fetch_id_26, t27.id AS id_28, t27.user_id AS user_id_29, t27.secret AS secret_30, t27.created_at AS created_at_31, t27.user_id AS user_id_32 FROM usuario t0 LEFT JOIN usuario_auth t27 ON t27.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.numero_dias AS numero_dias_3 FROM frecuencia_pago t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.ruta_archivo AS ruta_archivo_2, t0.id_documento_requerido AS id_documento_requerido_3, t0.id_prestamo AS id_prestamo_4 FROM prestamo_solicitud_documentos t0 WHERE t0.id_prestamo = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.requiere_archivo AS requiere_archivo_3 FROM formulario_documento_requerido t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.op_inst = ? ORDER BY t0.fec_pago DESC
SELECT t0.id AS id_1, t0.id_conecta AS id_conecta_2, t0.type AS type_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.created_at AS created_at_8, t0.last4 AS last4_9, t0.bin AS bin_10, t0.exp_month AS exp_month_11, t0.exp_year AS exp_year_12, t0.brand AS brand_13, t0.bank_code AS bank_code_14, t0.bank_name AS bank_name_15, t0.name AS name_16, t0.customer_id AS customer_id_17, t0.is_default AS is_default_18, t0.visible_on_checkout AS visible_on_checkout_19, t0.t AS t_20, t0.n AS n_21, t0.k AS k_22, t0.id_usuario AS id_usuario_23 FROM conecta_instrumentos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.co_inst = ? ORDER BY t0.fec_pago DESC
SELECT t0.id AS id_1, t0.id_stripe AS id_stripe_2, t0.created_at AS created_at_3, t0.object AS object_4, t0.enabled AS enabled_5, t0.validated AS validated_6, t0.validated_at AS validated_at_7, t0.validated_info AS validated_info_8, t0.bank_code AS bank_code_9, t0.bank_name AS bank_name_10, t0.brand AS brand_11, t0.card_type AS card_type_12, t0.country AS country_13, t0.customer_id AS customer_id_14, t0.last4 AS last4_15, t0.exp_month AS exp_month_16, t0.exp_year AS exp_year_17, t0.payment_method_id AS payment_method_id_18, t0.t AS t_19, t0.n AS n_20, t0.k AS k_21, t0.id_usuario AS id_usuario_22 FROM stripe_instrumentos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.st_inst = ? ORDER BY t0.fec_pago DESC
SELECT t0.id AS id_1, t0.id_unlimit AS id_unlimit_2, t0.type AS type_3, t0.brand AS brand_4, t0.created_at AS created_at_5, t0.enabled AS enabled_6, t0.validated AS validated_7, t0.validated_at AS validated_at_8, t0.validated_info AS validated_info_9, t0.bank_code AS bank_code_10, t0.bank_name AS bank_name_11, t0.last4 AS last4_12, t0.exp_month AS exp_month_13, t0.exp_year AS exp_year_14, t0.name AS name_15, t0.t AS t_16, t0.n AS n_17, t0.k AS k_18, t0.id_usuario AS id_usuario_19 FROM unlimit_instrumentos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.status AS status_3, t0.is_nc AS is_nc_4, t0.is_op_trans AS is_op_trans_5, t0.is_co_trans AS is_co_trans_6, t0.is_st_trans AS is_st_trans_7, t0.is_un_trans AS is_un_trans_8, t0.is_program AS is_program_9, t0.id_openpay AS id_openpay_10, t0.auth_openpay AS auth_openpay_11, t0.id_conecta AS id_conecta_12, t0.auth_conecta AS auth_conecta_13, t0.id_stripe AS id_stripe_14, t0.auth_stripe AS auth_stripe_15, t0.id_unlimit AS id_unlimit_16, t0.auth_unlimit AS auth_unlimit_17, t0.fec_pago AS fec_pago_18, t0.monto AS monto_19, t0.rutasoporte AS rutasoporte_20, t0.approved_at AS approved_at_21, t0.rejected_at AS rejected_at_22, t0.reject_cause AS reject_cause_23, t0.returned_at AS returned_at_24, t0.return_cause AS return_cause_25, t0.observations AS observations_26, t0.is_recurrent AS is_recurrent_27, t0.attempt_number AS attempt_number_28, t0.attempt_max AS attempt_max_29, t0.custom_recurrence AS custom_recurrence_30, t0.interval_minutes AS interval_minutes_31, t0.aplicado AS aplicado_32, t0.finiquito AS finiquito_33, t0.adjunto AS adjunto_34, t0.created_by AS created_by_35, t0.id_prestamo AS id_prestamo_36, t0.id_cuota AS id_cuota_37, t0.op_inst AS op_inst_38, t0.co_inst AS co_inst_39, t0.st_inst AS st_inst_40, t0.un_inst AS un_inst_41, t0.approved_by AS approved_by_42, t0.rejected_by AS rejected_by_43, t0.returned_by AS returned_by_44 FROM prestamo_pago t0 WHERE t0.un_inst = ? ORDER BY t0.fec_pago DESC
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.comentario AS comentario_3, t0.id_prestamo AS id_prestamo_4, t0.id_usuario AS id_usuario_5 FROM prestamo_comentarios t0 WHERE t0.id_prestamo = ? ORDER BY t0.created_at ASC
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.orden AS orden_3, t0.id_producto AS id_producto_4 FROM formulario_seccion t0 WHERE t0.id_producto = ? ORDER BY t0.orden ASC
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.opcion AS opcion_3, t0.config AS config_4, t0.orden AS orden_5, t0.id_seccion AS id_seccion_6, t0.id_tipo AS id_tipo_7 FROM formulario_campo t0 WHERE t0.id_seccion = ? ORDER BY t0.orden ASC
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3 FROM formulario_estados t0 WHERE t0.activo = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.activo AS activo_3, t0.id_estado AS id_estado_4 FROM formulario_ciudad t0 WHERE t0.id_estado = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.descripcion AS descripcion_2, t0.landing_show AS landing_show_3, t0.landing_name AS landing_name_4, t0.image AS image_5, t0.estado AS estado_6, t0.image_size AS image_size_7, t0.updated_at AS updated_at_8 FROM formulario_empresas_filiales t0 WHERE t0.estado = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.categoria AS categoria_2, t0.descripcion AS descripcion_3, t0.template AS template_4, t0.has_options AS has_options_5, t0.has_min_max_number AS has_min_max_number_6, t0.has_min_max_char AS has_min_max_char_7, t0.has_multiple AS has_multiple_8, t0.icon AS icon_9 FROM formulario_tipo t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0
SELECT t0.id AS id_1, t0.type AS type_2, t0.id_openpay AS id_openpay_3, t0.enabled AS enabled_4, t0.validated AS validated_5, t0.validated_at AS validated_at_6, t0.validated_info AS validated_info_7, t0.alias AS alias_8, t0.holder_name AS holder_name_9, t0.creation_date AS creation_date_10, t0.bank_code AS bank_code_11, t0.bank_name AS bank_name_12, t0.bank_clabe AS bank_clabe_13, t0.card_type AS card_type_14, t0.card_brand AS card_brand_15, t0.card_number AS card_number_16, t0.expiration_year AS expiration_year_17, t0.expiration_month AS expiration_month_18, t0.allows_charges AS allows_charges_19, t0.allows_payouts AS allows_payouts_20, t0.customer_id AS customer_id_21, t0.t AS t_22, t0.n AS n_23, t0.k AS k_24, t0.id_usuario AS id_usuario_25 FROM openpay_instrumentos t0 WHERE t0.id_usuario = ?
SELECT t0.id AS id_1, t0.id_stripe AS id_stripe_2, t0.created_at AS created_at_3, t0.object AS object_4, t0.enabled AS enabled_5, t0.validated AS validated_6, t0.validated_at AS validated_at_7, t0.validated_info AS validated_info_8, t0.bank_code AS bank_code_9, t0.bank_name AS bank_name_10, t0.brand AS brand_11, t0.card_type AS card_type_12, t0.country AS country_13, t0.customer_id AS customer_id_14, t0.last4 AS last4_15, t0.exp_month AS exp_month_16, t0.exp_year AS exp_year_17, t0.payment_method_id AS payment_method_id_18, t0.t AS t_19, t0.n AS n_20, t0.k AS k_21, t0.id_usuario AS id_usuario_22 FROM stripe_instrumentos t0 WHERE t0.id_usuario = ?
SELECT t0.id AS id_1, t0.id_unlimit AS id_unlimit_2, t0.type AS type_3, t0.brand AS brand_4, t0.created_at AS created_at_5, t0.enabled AS enabled_6, t0.validated AS validated_7, t0.validated_at AS validated_at_8, t0.validated_info AS validated_info_9, t0.bank_code AS bank_code_10, t0.bank_name AS bank_name_11, t0.last4 AS last4_12, t0.exp_month AS exp_month_13, t0.exp_year AS exp_year_14, t0.name AS name_15, t0.t AS t_16, t0.n AS n_17, t0.k AS k_18, t0.id_usuario AS id_usuario_19 FROM unlimit_instrumentos t0 WHERE t0.id_usuario = ?
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0
SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.short_name AS short_name_3, t0.descrip AS descrip_4, t0.card_register AS card_register_5, t0.stp_code AS stp_code_6 FROM formulario_bancos t0
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\Loan	No errors.
App\Entity\Producto	No errors.
App\Entity\User	No errors.
App\Entity\OpenPay\OpenPayInstrumentos	No errors.
App\Entity\Conecta\ConectaInstrumentos	No errors.
App\Entity\Stripe\StripeInstrumentos	No errors.
App\Entity\Unlimit\UnlimitInstrumentos	No errors.
App\Entity\FrecuenciaPago	No errors.
App\Entity\LoanAmortization	No errors.
App\Entity\LoanBureau	No errors.
App\Entity\LoanFee	No errors.
App\Entity\LoanPayment	No errors.
App\Entity\LoanDocument	No errors.
App\Entity\LoanComment	No errors.
App\Entity\LoanForm	No errors.
App\Entity\LoanDeposit	No errors.
App\Entity\LoanPaymentExcess	No errors.
App\Entity\LoanAmortizationDetail	The field App\Entity\LoanAmortizationDetail#payments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\LoanAmortizationDetailPayments#amortizationDetail does not contain the required 'inversedBy="payments"' attribute.
App\Entity\Auth\UserAuthentication	No errors.
App\Entity\BlogEntry	No errors.
App\Entity\Log\LoginRegister	No errors.
App\Entity\LoanAmortizationDetailPayments	No errors.
App\Entity\Stp\StpTransaction	No errors.
App\Entity\Formularios\Tipo	No errors.
App\Entity\ProductoCategoria	No errors.
App\Entity\Formularios\DocumentoRequerido	No errors.
App\Entity\Formularios\Seccion	No errors.
App\Entity\Formularios\Campo	No errors.
App\Entity\Formularios\Estado	No errors.
App\Entity\Formularios\Ciudad	No errors.
App\Entity\Formularios\EmpresasFiliales	No errors.
App\Entity\Formularios\Bancos	No errors.
Symfony Profiler

GET https://efectivate.zentro.com.mx/debugprestamos/190668

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
