Symfony Profiler

Query Metrics

13 Database Queries

5 Different statements

4.33 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.93 ms
(44.69%)

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.period AS period_3, t0.total AS total_4, t0.sealed AS sealed_5, t0.saas_configuration_id AS saas_configuration_id_6 FROM saas_doc_allowed t0 WHERE t0.doc_type = ? AND t0.saas_configuration_id = ? LIMIT 1

Parameters:

[
  "retencion"
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.doc_type AS doc_type_2,
  t0.period AS period_3,
  t0.total AS total_4,
  t0.sealed AS sealed_5,
  t0.saas_configuration_id AS saas_configuration_id_6
FROM
  saas_doc_allowed t0
WHERE
  t0.doc_type = ?
  AND t0.saas_configuration_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.doc_type AS doc_type_2, t0.period AS period_3, t0.total AS total_4, t0.sealed AS sealed_5, t0.saas_configuration_id AS saas_configuration_id_6 FROM saas_doc_allowed t0 WHERE t0.doc_type = 'retencion' AND t0.saas_configuration_id = 13 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 92)
4	App\Controller\SriInfoController->isInvoiceAllowed (line 170)
5	App\Controller\RetentionController->checkDocLimit (line 185)
6	App\Controller\RetentionController->create (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.98 ms
(22.72%)

SELECT t0.id AS id_1, t0.value AS value_2, t0.valid_from AS valid_from_3, t0.valid_to AS valid_to_4, t0.tax_id AS tax_id_5 FROM tax_range t0 WHERE t0.tax_id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.valid_from AS valid_from_3,
  t0.valid_to AS valid_to_4,
  t0.tax_id AS tax_id_5
FROM
  tax_range t0
WHERE
  t0.tax_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.valid_from AS valid_from_3, t0.valid_to AS valid_to_4, t0.tax_id AS tax_id_5 FROM tax_range t0 WHERE t0.tax_id = 30;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 109)
8	App\twig\AppExtension->taxesToJs (line 1240)
9	__TwigTemplate_455c87c15794351a72fb271ff069878a->block_js (line 171)
10	Twig\Template->displayBlock (line 158)
11	__TwigTemplate_7451852113630d7e22dbb448a2110448->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 49)
14	__TwigTemplate_6d0f75dbd785a6d1b06592b70688c381->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 56)
17	__TwigTemplate_455c87c15794351a72fb271ff069878a->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 379)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 280)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 368)
26	App\Controller\RetentionController->create (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.60 ms
(13.80%)

SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.ruc AS ruc_3, t0.direction AS direction_4, t0.email AS email_5, t0.serie1 AS serie1_6, t0.serie2 AS serie2_7, t0.obligado_contabilidad AS obligado_contabilidad_8, t0.logo AS logo_9, t0.agente_retencion AS agente_retencion_10, t0.contribuyente_rimpe AS contribuyente_rimpe_11, t0.contribuyente_especial AS contribuyente_especial_12, t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13, t0.phone AS phone_14, t0.iess AS iess_15, t0.period103 AS period103_16, t0.user_id AS user_id_17, t0.certificate_id AS certificate_id_18, t19.id AS id_20, t19.company_created AS company_created_21, t19.sri_info_id AS sri_info_id_22, t23.id AS id_24, t23.host AS host_25, t23.email AS email_26, t23.password AS password_27, t23.name AS name_28, t23.port AS port_29, t23.auto_send AS auto_send_30, t23.sri_info_id AS sri_info_id_31, t32.id AS id_33, t32.show_transporter AS show_transporter_34, t32.sucursal_limit AS sucursal_limit_35, t32.should_print332_pdf AS should_print332_pdf_36, t32.company_id AS company_id_37, t0.disabled_by_id AS disabled_by_id_38, t39.id AS id_40, t39.email AS email_41, t39.sri_info_id AS sri_info_id_42 FROM sri_info t0 LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id WHERE t0.user_id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.razon_social AS razon_social_2,
  t0.ruc AS ruc_3,
  t0.direction AS direction_4,
  t0.email AS email_5,
  t0.serie1 AS serie1_6,
  t0.serie2 AS serie2_7,
  t0.obligado_contabilidad AS obligado_contabilidad_8,
  t0.logo AS logo_9,
  t0.agente_retencion AS agente_retencion_10,
  t0.contribuyente_rimpe AS contribuyente_rimpe_11,
  t0.contribuyente_especial AS contribuyente_especial_12,
  t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13,
  t0.phone AS phone_14,
  t0.iess AS iess_15,
  t0.period103 AS period103_16,
  t0.user_id AS user_id_17,
  t0.certificate_id AS certificate_id_18,
  t19.id AS id_20,
  t19.company_created AS company_created_21,
  t19.sri_info_id AS sri_info_id_22,
  t23.id AS id_24,
  t23.host AS host_25,
  t23.email AS email_26,
  t23.password AS password_27,
  t23.name AS name_28,
  t23.port AS port_29,
  t23.auto_send AS auto_send_30,
  t23.sri_info_id AS sri_info_id_31,
  t32.id AS id_33,
  t32.show_transporter AS show_transporter_34,
  t32.sucursal_limit AS sucursal_limit_35,
  t32.should_print332_pdf AS should_print332_pdf_36,
  t32.company_id AS company_id_37,
  t0.disabled_by_id AS disabled_by_id_38,
  t39.id AS id_40,
  t39.email AS email_41,
  t39.sri_info_id AS sri_info_id_42
FROM
  sri_info t0
  LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id
  LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id
  LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id
  LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.razon_social AS razon_social_2, t0.ruc AS ruc_3, t0.direction AS direction_4, t0.email AS email_5, t0.serie1 AS serie1_6, t0.serie2 AS serie2_7, t0.obligado_contabilidad AS obligado_contabilidad_8, t0.logo AS logo_9, t0.agente_retencion AS agente_retencion_10, t0.contribuyente_rimpe AS contribuyente_rimpe_11, t0.contribuyente_especial AS contribuyente_especial_12, t0.contribuyente_rimpe_text AS contribuyente_rimpe_text_13, t0.phone AS phone_14, t0.iess AS iess_15, t0.period103 AS period103_16, t0.user_id AS user_id_17, t0.certificate_id AS certificate_id_18, t19.id AS id_20, t19.company_created AS company_created_21, t19.sri_info_id AS sri_info_id_22, t23.id AS id_24, t23.host AS host_25, t23.email AS email_26, t23.password AS password_27, t23.name AS name_28, t23.port AS port_29, t23.auto_send AS auto_send_30, t23.sri_info_id AS sri_info_id_31, t32.id AS id_33, t32.show_transporter AS show_transporter_34, t32.sucursal_limit AS sucursal_limit_35, t32.should_print332_pdf AS should_print332_pdf_36, t32.company_id AS company_id_37, t0.disabled_by_id AS disabled_by_id_38, t39.id AS id_40, t39.email AS email_41, t39.sri_info_id AS sri_info_id_42 FROM sri_info t0 LEFT JOIN sri_edwin t19 ON t19.sri_info_id = t0.id LEFT JOIN email_configuration t23 ON t23.sri_info_id = t0.id LEFT JOIN saas_configuration t32 ON t32.company_id = t0.id LEFT JOIN email_extra_config t39 ON t39.sri_info_id = t0.id WHERE t0.user_id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1891)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1832)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3298)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 711)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 461)
8	Doctrine\ORM\PersistentCollection->count (line 26)
9	App\Voters\DisabledUserVoter->voteOnAttribute (line 48)
10	Symfony\Component\Security\Core\Authorization\Voter\Voter->vote (line 38)
11	Symfony\Component\Security\Core\Authorization\Voter\TraceableVoter->vote (line 70)
12	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->collectResults (line 37)
13	Symfony\Component\Security\Core\Authorization\Strategy\UnanimousStrategy->decide (line 60)
14	Symfony\Component\Security\Core\Authorization\AccessDecisionManager->decide (line 60)
15	Symfony\Component\Security\Core\Authorization\TraceableAccessDecisionManager->decide (line 48)
16	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 65)
17	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 116)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 176)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.58 ms
(13.33%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.name AS name_6, t0.lastname AS lastname_7, t0.reset_password_key AS reset_password_key_8, t9.id AS id_10, t9.phone AS phone_11, t9.can_report_main_sucursal AS can_report_main_sucursal_12, t9.user_id AS user_id_13, t9.sri_info_id AS sri_info_id_14, t9.sucursal_id AS sucursal_id_15, t0.disabled_by_id AS disabled_by_id_16 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.name AS name_6,
  t0.lastname AS lastname_7,
  t0.reset_password_key AS reset_password_key_8,
  t9.id AS id_10,
  t9.phone AS phone_11,
  t9.can_report_main_sucursal AS can_report_main_sucursal_12,
  t9.user_id AS user_id_13,
  t9.sri_info_id AS sri_info_id_14,
  t9.sucursal_id AS sucursal_id_15,
  t0.disabled_by_id AS disabled_by_id_16
FROM
  user t0
  LEFT JOIN employee t9 ON t9.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.name AS name_6, t0.lastname AS lastname_7, t0.reset_password_key AS reset_password_key_8, t9.id AS id_10, t9.phone AS phone_11, t9.can_report_main_sucursal AS can_report_main_sucursal_12, t9.user_id AS user_id_13, t9.sri_info_id AS sri_info_id_14, t9.sucursal_id AS sucursal_id_15, t0.disabled_by_id AS disabled_by_id_16 FROM user t0 LEFT JOIN employee t9 ON t9.user_id = t0.id WHERE t0.id = 25;

#	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 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 65)
14	Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener->onKernelControllerArguments (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 176)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.24 ms
(5.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.amount AS amount_3, t0.valid_until AS valid_until_4, t0.is_default AS is_default_5, t0.sri_info_id AS sri_info_id_6 FROM tax t0 WHERE t0.sri_info_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.amount AS amount_3,
  t0.valid_until AS valid_until_4,
  t0.is_default AS is_default_5,
  t0.sri_info_id AS sri_info_id_6
FROM
  tax t0
WHERE
  t0.sri_info_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.amount AS amount_3, t0.valid_until AS valid_until_4, t0.is_default AS is_default_5, t0.sri_info_id AS sri_info_id_6 FROM tax t0 WHERE t0.sri_info_id = 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 194)
4	App\Controller\RetentionController->create (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Employee	No errors.
App\Entity\SriInfo	No errors.
App\Entity\Sucursal	No 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\Retencion	No errors.
App\Entity\CreditNote	No errors.
App\Entity\Transporter	No errors.
App\Entity\RemissionGuide	No errors.
App\Entity\DebitNote	No errors.
App\Entity\LiquidacionCompra	No errors.
App\Entity\Ats	No errors.
App\Entity\RetentionImport	No errors.
App\Entity\Certificate	No errors.
App\Entity\SriEdwin	No errors.
App\Entity\EmailConfiguration	No errors.
App\Entity\SaasConfiguration	No errors.
App\Entity\EmailExtraConfig	No errors.
App\Entity\Sequence	No errors.
App\Entity\Tax	No errors.
App\Entity\Product	No errors.
App\Entity\Client	No errors.
App\Entity\TransporterRemissionGuide	No errors.
App\Entity\Provider	No errors.
App\Entity\DisabledRetentionCode	No errors.
App\Entity\Trabajador	No errors.
App\Entity\Report103	No errors.
App\Entity\ReportIva	No errors.
App\Entity\EmailTemplate	No errors.
App\Entity\SaasDocAllowed	No errors.
App\Entity\TaxRange	No errors.
App\Entity\AditionalField	No errors.
App\Entity\Reembolso	No errors.
App\Entity\DocSustento	No errors.
App\Entity\RetentionCodeList	No errors.
App\Entity\SriPayment	No errors.

Symfony Profiler

GET https://sitacweb.com/retention/create

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping