Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

127.91 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

64.14 ms
(50.15%)

EXEC [UP_UPD_MP_IMPORTADOS_DETALLE_BAPRO] @idCabeza = ?

Parameters:

[
  3250
]

View formatted query View runnable query Explain query View query backtrace

EXEC [UP_UPD_MP_IMPORTADOS_DETALLE_BAPRO] @idCabeza = ?

EXEC [UP_UPD_MP_IMPORTADOS_DETALLE_BAPRO] @idCabeza = 3250;

#	File/Call
1	App\Controller\MediosDePagoController->preimportar (line 384)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 197)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 29)
7	require_once (line 5)

22.49 ms
(17.58%)

SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.tipo AS tipo_3, t0.tipoimportacion AS tipoimportacion_4, t0.cantidad AS cantidad_5, t0.descripcion AS descripcion_6, t0.fechacontabilizacion AS fechacontabilizacion_7, t0.usuario AS usuario_8, t0.fechahora AS fechahora_9, t0.importetotal AS importetotal_10, t0.estado AS estado_11, t0.observaciones AS observaciones_12, t0.fecha AS fecha_13 FROM mp_importados t0 WHERE t0.archivo = ? AND t0.tipo = ? AND t0.estado = ?

Parameters:

[
  "PN_ColMartillerosDolores_20261026.txt"
  "BAPRO"
  "PROCESADO"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.archivo AS archivo_2,
  t0.tipo AS tipo_3,
  t0.tipoimportacion AS tipoimportacion_4,
  t0.cantidad AS cantidad_5,
  t0.descripcion AS descripcion_6,
  t0.fechacontabilizacion AS fechacontabilizacion_7,
  t0.usuario AS usuario_8,
  t0.fechahora AS fechahora_9,
  t0.importetotal AS importetotal_10,
  t0.estado AS estado_11,
  t0.observaciones AS observaciones_12,
  t0.fecha AS fecha_13
FROM
  mp_importados t0
WHERE
  t0.archivo = ?
  AND t0.tipo = ?
  AND t0.estado = ?

SELECT t0.id AS id_1, t0.archivo AS archivo_2, t0.tipo AS tipo_3, t0.tipoimportacion AS tipoimportacion_4, t0.cantidad AS cantidad_5, t0.descripcion AS descripcion_6, t0.fechacontabilizacion AS fechacontabilizacion_7, t0.usuario AS usuario_8, t0.fechahora AS fechahora_9, t0.importetotal AS importetotal_10, t0.estado AS estado_11, t0.observaciones AS observaciones_12, t0.fecha AS fecha_13 FROM mp_importados t0 WHERE t0.archivo = 'PN_ColMartillerosDolores_20261026.txt' AND t0.tipo = 'BAPRO' AND t0.estado = 'PROCESADO';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MediosDePagoController->preimportar (line 322)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

16.25 ms
(12.70%)

SELECT t0.id AS id_1, t0.id_boton AS id_boton_2, t0.activo AS activo_3, t0.tipo AS tipo_4, t0.procedimiento AS procedimiento_5 FROM mp_procedimientos t0 WHERE t0.id_boton = ? AND t0.tipo = ? AND t0.activo = ?

Parameters:

[
  2
  "PREIMPORTACION"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id_boton AS id_boton_2,
  t0.activo AS activo_3,
  t0.tipo AS tipo_4,
  t0.procedimiento AS procedimiento_5
FROM
  mp_procedimientos t0
WHERE
  t0.id_boton = ?
  AND t0.tipo = ?
  AND t0.activo = ?

SELECT t0.id AS id_1, t0.id_boton AS id_boton_2, t0.activo AS activo_3, t0.tipo AS tipo_4, t0.procedimiento AS procedimiento_5 FROM mp_procedimientos t0 WHERE t0.id_boton = 2 AND t0.tipo = 'PREIMPORTACION' AND t0.activo = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\MediosDePagoController->preimportar (line 368)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

15.57 ms
(12.17%)

INSERT INTO mp_importados_detalle (id_cabeza, id_deuda, id_concepto, id_usuario, importe, fechapago, discrecional, id_cliente, id_ctacte, observaciones, codigo, apyn, leyenda, saldo_ant, saldo_act, observado) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  3250
  null
  null
  null
  60000.0
  "2026-10-23 00:00:00.000000"
  null
  1573
  435366
  null
  null
  null
  null
  null
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO mp_importados_detalle (
  id_cabeza, id_deuda, id_concepto,
  id_usuario, importe, fechapago, discrecional,
  id_cliente, id_ctacte, observaciones,
  codigo, apyn, leyenda, saldo_ant,
  saldo_act, observado
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO mp_importados_detalle (id_cabeza, id_deuda, id_concepto, id_usuario, importe, fechapago, discrecional, id_cliente, id_ctacte, observaciones, codigo, apyn, leyenda, saldo_ant, saldo_act, observado) VALUES (3250, NULL, NULL, NULL, 60000, '2026-10-23 00:00:00.000000', NULL, 1573, 435366, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\MediosDePagoController->preimportar (line 365)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

3.39 ms
(2.65%)

INSERT INTO mp_importados (archivo, tipo, tipoimportacion, cantidad, descripcion, fechacontabilizacion, usuario, fechahora, importetotal, estado, observaciones, fecha) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "PN_ColMartillerosDolores_20261026.txt"
  "BAPRO"
  "EXTRACT"
  "1"
  null
  null
  "ADMIN"
  "2026-11-03 09:57:09.457993"
  "60000"
  "PROVISORIO"
  null
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO mp_importados (
  archivo, tipo, tipoimportacion, cantidad,
  descripcion, fechacontabilizacion,
  usuario, fechahora, importetotal,
  estado, observaciones, fecha
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO mp_importados (archivo, tipo, tipoimportacion, cantidad, descripcion, fechacontabilizacion, usuario, fechahora, importetotal, estado, observaciones, fecha) VALUES ('PN_ColMartillerosDolores_20261026.txt', 'BAPRO', 'EXTRACT', '1', NULL, NULL, 'ADMIN', '2026-11-03 09:57:09.457993', '60000', 'PROVISORIO', NULL, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\MediosDePagoController->preimportar (line 344)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

2.62 ms
(2.05%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\MediosDePagoController->preimportar (line 344)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

2.20 ms
(1.72%)

SELECT t0.id AS id_1, t0.id_cabeza AS id_cabeza_2, t0.id_deuda AS id_deuda_3, t0.id_concepto AS id_concepto_4, t0.id_usuario AS id_usuario_5, t0.importe AS importe_6, t0.fechapago AS fechapago_7, t0.discrecional AS discrecional_8, t0.id_cliente AS id_cliente_9, t0.id_ctacte AS id_ctacte_10, t0.observaciones AS observaciones_11, t0.codigo AS codigo_12, t0.apyn AS apyn_13, t0.leyenda AS leyenda_14, t0.saldo_ant AS saldo_ant_15, t0.saldo_act AS saldo_act_16, t0.observado AS observado_17 FROM mp_importados_detalle t0 WHERE t0.id = ?

Parameters:

[
  17800
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.id_cabeza AS id_cabeza_2,
  t0.id_deuda AS id_deuda_3,
  t0.id_concepto AS id_concepto_4,
  t0.id_usuario AS id_usuario_5,
  t0.importe AS importe_6,
  t0.fechapago AS fechapago_7,
  t0.discrecional AS discrecional_8,
  t0.id_cliente AS id_cliente_9,
  t0.id_ctacte AS id_ctacte_10,
  t0.observaciones AS observaciones_11,
  t0.codigo AS codigo_12,
  t0.apyn AS apyn_13,
  t0.leyenda AS leyenda_14,
  t0.saldo_ant AS saldo_ant_15,
  t0.saldo_act AS saldo_act_16,
  t0.observado AS observado_17
FROM
  mp_importados_detalle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_cabeza AS id_cabeza_2, t0.id_deuda AS id_deuda_3, t0.id_concepto AS id_concepto_4, t0.id_usuario AS id_usuario_5, t0.importe AS importe_6, t0.fechapago AS fechapago_7, t0.discrecional AS discrecional_8, t0.id_cliente AS id_cliente_9, t0.id_ctacte AS id_ctacte_10, t0.observaciones AS observaciones_11, t0.codigo AS codigo_12, t0.apyn AS apyn_13, t0.leyenda AS leyenda_14, t0.saldo_ant AS saldo_ant_15, t0.saldo_act AS saldo_act_16, t0.observado AS observado_17 FROM mp_importados_detalle t0 WHERE t0.id = 17800;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->refresh (line 853)
2	Doctrine\ORM\UnitOfWork->doRefresh (line 2019)
3	Doctrine\ORM\UnitOfWork->refresh (line 1980)
4	Doctrine\ORM\EntityManager->refresh (line 466)
5	App\Controller\MediosDePagoController->preimportar (line 388)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

1.26 ms
(0.99%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\MediosDePagoController->preimportar (line 344)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\MpImportados	1
App\Entity\MpImportadosDetalle	1
App\Entity\MpProcedimientos	1

Entities Mapping

Class	Mapping errors
App\Entity\MpImportados	No errors.
App\Entity\MpImportadosDetalle	No errors.
App\Entity\MpProcedimientos	No errors.

Symfony Profiler

POST https://comado.mp.frontiniyasoc.com.ar/preimportar

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping