Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.24 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.50 ms

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.fecha_emision AS fecha_emision_4, t0.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_5, t0.razon_social_sujeto AS razon_social_sujeto_6, t0.identificacion_sujeto AS identificacion_sujeto_7, t0.periodo_fiscal AS periodo_fiscal_8, t0.concept AS concept_9, t0.tax_amount AS tax_amount_10, t0.retencion_iva AS retencion_iva_11, t0.dates104 AS dates104_12, t0.doc_related_type AS doc_related_type_13, t0.doc_related_date AS doc_related_date_14, t0.doc_related_serie AS doc_related_serie_15, t0.doc_related_sequence AS doc_related_sequence_16, t0.doc_related_auth AS doc_related_auth_17, t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_18, t0.parte_rel AS parte_rel_19, t0.sri_info_id AS sri_info_id_20, t0.created_by_id AS created_by_id_21, t22.id AS id_23, t22.clave_accesso AS clave_accesso_24, t22.secuencial AS secuencial_25, t22.estado AS estado_26, t22.error AS error_27, t22.serie1 AS serie1_28, t22.serie2 AS serie2_29, t22.cancel AS cancel_30, t22.has_fetch_error AS has_fetch_error_31, t22.invoice_id AS invoice_id_32, t22.retention_id AS retention_id_33, t22.remission_guide_id AS remission_guide_id_34, t22.debit_note_id AS debit_note_id_35, t0.sucursal_id AS sucursal_id_36, t0.provider_id AS provider_id_37, t0.import_id AS import_id_38 FROM retencion t0 LEFT JOIN sri_document t22 ON t22.retention_id = t0.id WHERE t0.id = ?

Parameters:

[
  "20580"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.fecha_emision AS fecha_emision_4,
  t0.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_5,
  t0.razon_social_sujeto AS razon_social_sujeto_6,
  t0.identificacion_sujeto AS identificacion_sujeto_7,
  t0.periodo_fiscal AS periodo_fiscal_8,
  t0.concept AS concept_9,
  t0.tax_amount AS tax_amount_10,
  t0.retencion_iva AS retencion_iva_11,
  t0.dates104 AS dates104_12,
  t0.doc_related_type AS doc_related_type_13,
  t0.doc_related_date AS doc_related_date_14,
  t0.doc_related_serie AS doc_related_serie_15,
  t0.doc_related_sequence AS doc_related_sequence_16,
  t0.doc_related_auth AS doc_related_auth_17,
  t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_18,
  t0.parte_rel AS parte_rel_19,
  t0.sri_info_id AS sri_info_id_20,
  t0.created_by_id AS created_by_id_21,
  t22.id AS id_23,
  t22.clave_accesso AS clave_accesso_24,
  t22.secuencial AS secuencial_25,
  t22.estado AS estado_26,
  t22.error AS error_27,
  t22.serie1 AS serie1_28,
  t22.serie2 AS serie2_29,
  t22.cancel AS cancel_30,
  t22.has_fetch_error AS has_fetch_error_31,
  t22.invoice_id AS invoice_id_32,
  t22.retention_id AS retention_id_33,
  t22.remission_guide_id AS remission_guide_id_34,
  t22.debit_note_id AS debit_note_id_35,
  t0.sucursal_id AS sucursal_id_36,
  t0.provider_id AS provider_id_37,
  t0.import_id AS import_id_38
FROM
  retencion t0
  LEFT JOIN sri_document t22 ON t22.retention_id = t0.id
WHERE
  t0.id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.fecha_emision AS fecha_emision_4, t0.tipo_identificacion_sujeto AS tipo_identificacion_sujeto_5, t0.razon_social_sujeto AS razon_social_sujeto_6, t0.identificacion_sujeto AS identificacion_sujeto_7, t0.periodo_fiscal AS periodo_fiscal_8, t0.concept AS concept_9, t0.tax_amount AS tax_amount_10, t0.retencion_iva AS retencion_iva_11, t0.dates104 AS dates104_12, t0.doc_related_type AS doc_related_type_13, t0.doc_related_date AS doc_related_date_14, t0.doc_related_serie AS doc_related_serie_15, t0.doc_related_sequence AS doc_related_sequence_16, t0.doc_related_auth AS doc_related_auth_17, t0.tipo_sujeto_retenido AS tipo_sujeto_retenido_18, t0.parte_rel AS parte_rel_19, t0.sri_info_id AS sri_info_id_20, t0.created_by_id AS created_by_id_21, t22.id AS id_23, t22.clave_accesso AS clave_accesso_24, t22.secuencial AS secuencial_25, t22.estado AS estado_26, t22.error AS error_27, t22.serie1 AS serie1_28, t22.serie2 AS serie2_29, t22.cancel AS cancel_30, t22.has_fetch_error AS has_fetch_error_31, t22.invoice_id AS invoice_id_32, t22.retention_id AS retention_id_33, t22.remission_guide_id AS remission_guide_id_34, t22.debit_note_id AS debit_note_id_35, t0.sucursal_id AS sucursal_id_36, t0.provider_id AS provider_id_37, t0.import_id AS import_id_38 FROM retencion t0 LEFT JOIN sri_document t22 ON t22.retention_id = t0.id WHERE t0.id = '20580';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
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 5)

0.29 ms

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emition_date AS emition_date_4, t0.motive AS motive_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.total AS total_8, t0.sri_info_id AS sri_info_id_9, t0.client_id AS client_id_10, t0.invoice_id AS invoice_id_11, t0.sri_document_id AS sri_document_id_12, t0.user_id AS user_id_13, t0.sucursal_id AS sucursal_id_14 FROM credit_note t0 WHERE t0.sri_document_id = ?

Parameters:

[
  23707
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.emition_date AS emition_date_4,
  t0.motive AS motive_5,
  t0.total_without_tax AS total_without_tax_6,
  t0.total_discount AS total_discount_7,
  t0.total AS total_8,
  t0.sri_info_id AS sri_info_id_9,
  t0.client_id AS client_id_10,
  t0.invoice_id AS invoice_id_11,
  t0.sri_document_id AS sri_document_id_12,
  t0.user_id AS user_id_13,
  t0.sucursal_id AS sucursal_id_14
FROM
  credit_note t0
WHERE
  t0.sri_document_id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emition_date AS emition_date_4, t0.motive AS motive_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.total AS total_8, t0.sri_info_id AS sri_info_id_9, t0.client_id AS client_id_10, t0.invoice_id AS invoice_id_11, t0.sri_document_id AS sri_document_id_12, t0.user_id AS user_id_13, t0.sucursal_id AS sucursal_id_14 FROM credit_note t0 WHERE t0.sri_document_id = 23707;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 848)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 445)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
11	Doctrine\ORM\EntityManager->find (line 197)
12	Doctrine\ORM\EntityRepository->find (line 116)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.28 ms

SELECT t0.id AS id_1, t0.cod_sustento AS cod_sustento_2, t0.cod_doc_sustento AS cod_doc_sustento_3, t0.num_doc_sustento AS num_doc_sustento_4, t0.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_5, t0.num_aut_doc_sustento AS num_aut_doc_sustento_6, t0.total_sin_impuestos AS total_sin_impuestos_7, t0.total AS total_8, t0.pago_loc_ext AS pago_loc_ext_9, t0.other_value AS other_value_10, t0.fecha_caducidad AS fecha_caducidad_11, t0.retencion_id AS retencion_id_12, t0.pago_loc_id AS pago_loc_id_13 FROM doc_sustento t0 WHERE t0.retencion_id IN (?)

Parameters:

[
  20580
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cod_sustento AS cod_sustento_2,
  t0.cod_doc_sustento AS cod_doc_sustento_3,
  t0.num_doc_sustento AS num_doc_sustento_4,
  t0.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_5,
  t0.num_aut_doc_sustento AS num_aut_doc_sustento_6,
  t0.total_sin_impuestos AS total_sin_impuestos_7,
  t0.total AS total_8,
  t0.pago_loc_ext AS pago_loc_ext_9,
  t0.other_value AS other_value_10,
  t0.fecha_caducidad AS fecha_caducidad_11,
  t0.retencion_id AS retencion_id_12,
  t0.pago_loc_id AS pago_loc_id_13
FROM
  doc_sustento t0
WHERE
  t0.retencion_id IN (?)

SELECT t0.id AS id_1, t0.cod_sustento AS cod_sustento_2, t0.cod_doc_sustento AS cod_doc_sustento_3, t0.num_doc_sustento AS num_doc_sustento_4, t0.fecha_emision_doc_sustento AS fecha_emision_doc_sustento_5, t0.num_aut_doc_sustento AS num_aut_doc_sustento_6, t0.total_sin_impuestos AS total_sin_impuestos_7, t0.total AS total_8, t0.pago_loc_ext AS pago_loc_ext_9, t0.other_value AS other_value_10, t0.fecha_caducidad AS fecha_caducidad_11, t0.retencion_id AS retencion_id_12, t0.pago_loc_id AS pago_loc_id_13 FROM doc_sustento t0 WHERE t0.retencion_id IN (20580);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3244)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3218)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 68)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 270)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 848)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 445)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
14	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
15	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
16	Doctrine\ORM\EntityManager->find (line 197)
17	Doctrine\ORM\EntityRepository->find (line 116)
18	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
19	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
20	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
21	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
22	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.17 ms

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emit_date AS emit_date_4, t0.total AS total_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.provider_id AS provider_id_8, t0.company_id AS company_id_9, t0.sucursal_id AS sucursal_id_10, t0.user_id AS user_id_11, t0.sri_document_id AS sri_document_id_12 FROM liquidacion_compra t0 WHERE t0.sri_document_id = ?

Parameters:

[
  23707
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.creation_date AS creation_date_1,
  t0.date_update AS date_update_2,
  t0.id AS id_3,
  t0.emit_date AS emit_date_4,
  t0.total AS total_5,
  t0.total_without_tax AS total_without_tax_6,
  t0.total_discount AS total_discount_7,
  t0.provider_id AS provider_id_8,
  t0.company_id AS company_id_9,
  t0.sucursal_id AS sucursal_id_10,
  t0.user_id AS user_id_11,
  t0.sri_document_id AS sri_document_id_12
FROM
  liquidacion_compra t0
WHERE
  t0.sri_document_id = ?

SELECT t0.creation_date AS creation_date_1, t0.date_update AS date_update_2, t0.id AS id_3, t0.emit_date AS emit_date_4, t0.total AS total_5, t0.total_without_tax AS total_without_tax_6, t0.total_discount AS total_discount_7, t0.provider_id AS provider_id_8, t0.company_id AS company_id_9, t0.sucursal_id AS sucursal_id_10, t0.user_id AS user_id_11, t0.sri_document_id AS sri_document_id_12 FROM liquidacion_compra t0 WHERE t0.sri_document_id = 23707;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 848)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 445)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
11	Doctrine\ORM\EntityManager->find (line 197)
12	Doctrine\ORM\EntityRepository->find (line 116)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
14	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
16	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
17	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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.

Entities Mapping

Class	Mapping errors
App\Entity\InvoiceSuperClass	No errors.
App\Entity\Retencion	No errors.
App\Entity\SriInfo	No errors.
App\Entity\User	No errors.
App\Entity\SriDocument	No errors.
App\Entity\Invoice	The field 'App\Entity\Invoice#totalWithoutTax' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Invoice#totalDiscount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Invoice#propina' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\RemissionGuide	No errors.
App\Entity\DebitNote	No errors.
App\Entity\Sucursal	No errors.
App\Entity\Provider	No errors.
App\Entity\RetentionImport	No errors.
App\Entity\RetentionImpuesto	No errors.
App\Entity\AditionalField	No errors.
App\Entity\DocSustento	No errors.
App\Entity\Reembolso	No errors.
App\Entity\CreditNote	No errors.
App\Entity\Client	No errors.
App\Entity\PagoLocExt	No errors.
App\Entity\InvoiceTaxes	No errors.
App\Entity\DocSustentoImpuesto	No errors.
App\Entity\SriPayment	No errors.
App\Entity\LiquidacionCompra	No errors.

Symfony Profiler

GET https://sitacweb.com/retention/info/20580

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping