Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.95 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.52 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.propina AS propina_8, t0.paid_amount AS paid_amount_9, t0.form_of_payment AS form_of_payment_10, t0.external_id AS external_id_11, t0.is_received AS is_received_12, t0.sell_type AS sell_type_13, t0.payment_type AS payment_type_14, t0.sri_info_id AS sri_info_id_15, t0.user_id AS user_id_16, t0.client_id AS client_id_17, t18.id AS id_19, t18.clave_accesso AS clave_accesso_20, t18.secuencial AS secuencial_21, t18.estado AS estado_22, t18.error AS error_23, t18.serie1 AS serie1_24, t18.serie2 AS serie2_25, t18.cancel AS cancel_26, t18.has_fetch_error AS has_fetch_error_27, t18.invoice_id AS invoice_id_28, t18.retention_id AS retention_id_29, t18.remission_guide_id AS remission_guide_id_30, t18.debit_note_id AS debit_note_id_31, t0.transporter_id AS transporter_id_32, t0.sucursal_id AS sucursal_id_33, t34.id AS id_35, t34.motive AS motive_36, t34.route AS route_37, t34.remission_guide_id AS remission_guide_id_38, t34.invoice_id AS invoice_id_39, t0.provider_id AS provider_id_40 FROM invoice t0 LEFT JOIN sri_document t18 ON t18.invoice_id = t0.id LEFT JOIN remission_guide_recipient t34 ON t34.invoice_id = t0.id WHERE t0.id = ?

Parameters:

[
  "1322"
]

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.propina AS propina_8,
  t0.paid_amount AS paid_amount_9,
  t0.form_of_payment AS form_of_payment_10,
  t0.external_id AS external_id_11,
  t0.is_received AS is_received_12,
  t0.sell_type AS sell_type_13,
  t0.payment_type AS payment_type_14,
  t0.sri_info_id AS sri_info_id_15,
  t0.user_id AS user_id_16,
  t0.client_id AS client_id_17,
  t18.id AS id_19,
  t18.clave_accesso AS clave_accesso_20,
  t18.secuencial AS secuencial_21,
  t18.estado AS estado_22,
  t18.error AS error_23,
  t18.serie1 AS serie1_24,
  t18.serie2 AS serie2_25,
  t18.cancel AS cancel_26,
  t18.has_fetch_error AS has_fetch_error_27,
  t18.invoice_id AS invoice_id_28,
  t18.retention_id AS retention_id_29,
  t18.remission_guide_id AS remission_guide_id_30,
  t18.debit_note_id AS debit_note_id_31,
  t0.transporter_id AS transporter_id_32,
  t0.sucursal_id AS sucursal_id_33,
  t34.id AS id_35,
  t34.motive AS motive_36,
  t34.route AS route_37,
  t34.remission_guide_id AS remission_guide_id_38,
  t34.invoice_id AS invoice_id_39,
  t0.provider_id AS provider_id_40
FROM
  invoice t0
  LEFT JOIN sri_document t18 ON t18.invoice_id = t0.id
  LEFT JOIN remission_guide_recipient t34 ON t34.invoice_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.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.propina AS propina_8, t0.paid_amount AS paid_amount_9, t0.form_of_payment AS form_of_payment_10, t0.external_id AS external_id_11, t0.is_received AS is_received_12, t0.sell_type AS sell_type_13, t0.payment_type AS payment_type_14, t0.sri_info_id AS sri_info_id_15, t0.user_id AS user_id_16, t0.client_id AS client_id_17, t18.id AS id_19, t18.clave_accesso AS clave_accesso_20, t18.secuencial AS secuencial_21, t18.estado AS estado_22, t18.error AS error_23, t18.serie1 AS serie1_24, t18.serie2 AS serie2_25, t18.cancel AS cancel_26, t18.has_fetch_error AS has_fetch_error_27, t18.invoice_id AS invoice_id_28, t18.retention_id AS retention_id_29, t18.remission_guide_id AS remission_guide_id_30, t18.debit_note_id AS debit_note_id_31, t0.transporter_id AS transporter_id_32, t0.sucursal_id AS sucursal_id_33, t34.id AS id_35, t34.motive AS motive_36, t34.route AS route_37, t34.remission_guide_id AS remission_guide_id_38, t34.invoice_id AS invoice_id_39, t0.provider_id AS provider_id_40 FROM invoice t0 LEFT JOIN sri_document t18 ON t18.invoice_id = t0.id LEFT JOIN remission_guide_recipient t34 ON t34.invoice_id = t0.id WHERE t0.id = '1322';

#	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.25 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:

[
  13978
]

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 = 13978;

#	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.18 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:

[
  13978
]

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 = 13978;

#	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\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\SriInfo	No errors.
App\Entity\User	No errors.
App\Entity\Client	No errors.
App\Entity\SriDocument	No errors.
App\Entity\Retencion	No errors.
App\Entity\RemissionGuide	No errors.
App\Entity\DebitNote	No errors.
App\Entity\Transporter	No errors.
App\Entity\Sucursal	No errors.
App\Entity\RemissionGuideRecipient	No errors.
App\Entity\Provider	No errors.
App\Entity\InvoiceDetail	The field 'App\Entity\InvoiceDetail#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\InvoiceDetail#discount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\InvoiceDetail#totalWithoutTax' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\InvoiceDetail#price' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\InvoiceTaxes	No errors.
App\Entity\CreditNote	No errors.
App\Entity\AditionalField	No errors.
App\Entity\SriPayment	No errors.
App\Entity\LiquidacionCompra	No errors.

Symfony Profiler

GET https://www.sitacweb.com/invoive/1322

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping