Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

7.86 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

7.86 ms

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 = ?

Parameters:

[
  "190373"
]

View formatted query View runnable query Explain query View query backtrace

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.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 = '190373';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 7)

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.

Symfony Profiler

GET https://efectivate.zentro.com.mx/prestamos/190373

Configuration Settings

Theme