Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.35 ms Query time

0 Invalid entities

61 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.46 ms

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.traslados_od_libres AS traslados_od_libres_3, t0.tasa_traslados_def AS tasa_traslados_def_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.link_instagram AS link_instagram_7, t0.link_whatsapp AS link_whatsapp_8, t0.contacto_telefono AS contacto_telefono_9, t0.contacto_correo AS contacto_correo_10, t0.contacto_direccion AS contacto_direccion_11, t0.comision_booking_partner AS comision_booking_partner_12, t0.enable_mercado_pago_payments AS enable_mercado_pago_payments_13, t0.enable_pay_pal_payments AS enable_pay_pal_payments_14, t0.enable_cash_payments AS enable_cash_payments_15, t0.cash_payment_instructions AS cash_payment_instructions_16, t0.language_def_id AS language_def_id_17, t0.moneda_def_id AS moneda_def_id_18, t0.credenciales_pay_pal_id AS credenciales_pay_pal_id_19, t0.credenciales_mercado_pago_id AS credenciales_mercado_pago_id_20 FROM plataforma t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.traslados_od_libres AS traslados_od_libres_3,
  t0.tasa_traslados_def AS tasa_traslados_def_4,
  t0.logo AS logo_5,
  t0.icono AS icono_6,
  t0.link_instagram AS link_instagram_7,
  t0.link_whatsapp AS link_whatsapp_8,
  t0.contacto_telefono AS contacto_telefono_9,
  t0.contacto_correo AS contacto_correo_10,
  t0.contacto_direccion AS contacto_direccion_11,
  t0.comision_booking_partner AS comision_booking_partner_12,
  t0.enable_mercado_pago_payments AS enable_mercado_pago_payments_13,
  t0.enable_pay_pal_payments AS enable_pay_pal_payments_14,
  t0.enable_cash_payments AS enable_cash_payments_15,
  t0.cash_payment_instructions AS cash_payment_instructions_16,
  t0.language_def_id AS language_def_id_17,
  t0.moneda_def_id AS moneda_def_id_18,
  t0.credenciales_pay_pal_id AS credenciales_pay_pal_id_19,
  t0.credenciales_mercado_pago_id AS credenciales_mercado_pago_id_20
FROM
  plataforma t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.traslados_od_libres AS traslados_od_libres_3, t0.tasa_traslados_def AS tasa_traslados_def_4, t0.logo AS logo_5, t0.icono AS icono_6, t0.link_instagram AS link_instagram_7, t0.link_whatsapp AS link_whatsapp_8, t0.contacto_telefono AS contacto_telefono_9, t0.contacto_correo AS contacto_correo_10, t0.contacto_direccion AS contacto_direccion_11, t0.comision_booking_partner AS comision_booking_partner_12, t0.enable_mercado_pago_payments AS enable_mercado_pago_payments_13, t0.enable_pay_pal_payments AS enable_pay_pal_payments_14, t0.enable_cash_payments AS enable_cash_payments_15, t0.cash_payment_instructions AS cash_payment_instructions_16, t0.language_def_id AS language_def_id_17, t0.moneda_def_id AS moneda_def_id_18, t0.credenciales_pay_pal_id AS credenciales_pay_pal_id_19, t0.credenciales_mercado_pago_id AS credenciales_mercado_pago_id_20 FROM plataforma t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\SecurityController->login (line 34)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.36 ms

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.habilitado AS habilitado_5, t0.plataforma_id AS plataforma_id_6, t0.moneda_def_id AS moneda_def_id_7 FROM lenguaje t0 WHERE t0.habilitado = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.codigo AS codigo_2,
  t0.nombre AS nombre_3,
  t0.icono AS icono_4,
  t0.habilitado AS habilitado_5,
  t0.plataforma_id AS plataforma_id_6,
  t0.moneda_def_id AS moneda_def_id_7
FROM
  lenguaje t0
WHERE
  t0.habilitado = ?

SELECT t0.id AS id_1, t0.codigo AS codigo_2, t0.nombre AS nombre_3, t0.icono AS icono_4, t0.habilitado AS habilitado_5, t0.plataforma_id AS plataforma_id_6, t0.moneda_def_id AS moneda_def_id_7 FROM lenguaje t0 WHERE t0.habilitado = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Services\LanguageService->getLenguajes (line 28)
5	App\Controller\SecurityController::login (line 35)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.52 ms

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.lenguaje_id AS lenguaje_id_4, t0.plataforma_id AS plataforma_id_5 FROM traduccion_plataforma t0 WHERE t0.plataforma_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.value AS value_3,
  t0.lenguaje_id AS lenguaje_id_4,
  t0.plataforma_id AS plataforma_id_5
FROM
  traduccion_plataforma t0
WHERE
  t0.plataforma_id = ?

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.value AS value_3, t0.lenguaje_id AS lenguaje_id_4, t0.plataforma_id AS plataforma_id_5 FROM traduccion_plataforma t0 WHERE t0.plataforma_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Plataforma->getTraduccionMenu (line 336)
8	Twig\Extension\CoreExtension->getAttribute (line 1909)
9	__TwigTemplate_5bc5008441fe4639a33c0a2404addd6b::doDisplay (line 97)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_00291cd42b8345f7f22e63d7b811cee5->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\SecurityController->login (line 37)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\TraduccionPlataforma	52
App\Entity\Lenguaje	3
App\Entity\Moneda	3
App\Entity\Plataforma	1
App\Entity\CredencialesPayPal	1
App\Entity\CredencialesMercadoPago	1

Entities Mapping

Class	Mapping errors
App\Entity\Plataforma	No errors.
App\Entity\Lenguaje	No errors.
App\Entity\Moneda	No errors.
App\Entity\CredencialesPayPal	No errors.
App\Entity\CredencialesMercadoPago	No errors.
App\Entity\TraduccionPlataforma	No errors.
App\Entity\TraduccionBooking	No errors.

Symfony Profiler

GET https://travelonlineagency.shophardware.com.ar/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping