Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.88 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

mysql connection

#▲

Time

Info

0.29 ms

SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) = -1 ORDER BY s0_.idsorteo ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.idsorteo AS idsorteo_0,
  s0_.periodo AS periodo_1,
  s0_.anio AS anio_2,
  s0_.mes AS mes_3,
  s0_.nrosorteo1 AS nrosorteo1_4,
  s0_.nrosorteo2 AS nrosorteo2_5,
  s0_.nrosorteo3 AS nrosorteo3_6,
  s0_.fechasorteo AS fechasorteo_7,
  s0_.sorteopor AS sorteopor_8,
  s0_.fechaprovisoria AS fechaprovisoria_9
FROM
  sorteos s0_
WHERE
  COALESCE(s0_.nrosorteo1, -1) = -1
ORDER BY
  s0_.idsorteo ASC
LIMIT
  1

SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) = -1 ORDER BY s0_.idsorteo ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 49)
7	App\Repository\SorteosRepository->getProximoSorteo (line 36)
8	App\Controller\DefaultController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.20 ms

SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) >= 0 ORDER BY s0_.periodo DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.idsorteo AS idsorteo_0,
  s0_.periodo AS periodo_1,
  s0_.anio AS anio_2,
  s0_.mes AS mes_3,
  s0_.nrosorteo1 AS nrosorteo1_4,
  s0_.nrosorteo2 AS nrosorteo2_5,
  s0_.nrosorteo3 AS nrosorteo3_6,
  s0_.fechasorteo AS fechasorteo_7,
  s0_.sorteopor AS sorteopor_8,
  s0_.fechaprovisoria AS fechaprovisoria_9
FROM
  sorteos s0_
WHERE
  COALESCE(s0_.nrosorteo1, -1) >= 0
ORDER BY
  s0_.periodo DESC
LIMIT
  1

SELECT s0_.idsorteo AS idsorteo_0, s0_.periodo AS periodo_1, s0_.anio AS anio_2, s0_.mes AS mes_3, s0_.nrosorteo1 AS nrosorteo1_4, s0_.nrosorteo2 AS nrosorteo2_5, s0_.nrosorteo3 AS nrosorteo3_6, s0_.fechasorteo AS fechasorteo_7, s0_.sorteopor AS sorteopor_8, s0_.fechaprovisoria AS fechaprovisoria_9 FROM sorteos s0_ WHERE COALESCE(s0_.nrosorteo1, -1) >= 0 ORDER BY s0_.periodo DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 37)
7	App\Repository\SorteosRepository->getUltimoSorteo (line 37)
8	App\Controller\DefaultController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.19 ms

SELECT s0_.anio AS anio_0 FROM sorteos s0_ GROUP BY s0_.anio ORDER BY s0_.anio DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.anio AS anio_0
FROM
  sorteos s0_
GROUP BY
  s0_.anio
ORDER BY
  s0_.anio DESC

SELECT s0_.anio AS anio_0 FROM sorteos s0_ GROUP BY s0_.anio ORDER BY s0_.anio DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 60)
7	App\Repository\SorteosRepository->getAnios (line 38)
8	App\Controller\DefaultController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.20 ms

SELECT t0.id AS id_1, t0.nombreparametro AS nombreparametro_2, t0.valor AS valor_3 FROM dc_tparamsistema t0 WHERE t0.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombreparametro AS nombreparametro_2,
  t0.valor AS valor_3
FROM
  dc_tparamsistema t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombreparametro AS nombreparametro_2, t0.valor AS valor_3 FROM dc_tparamsistema t0 WHERE t0.id = 9;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 40)
4	App\Controller\DefaultController->indexAction (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)

mssql connection

#▲

Time

Info

2.00 ms

SELECT e0_.idEntidadRecaudadora AS idEntidadRecaudadora_0, e0_.link AS link_1, e0_.conBoleta AS conBoleta_2, e0_.nombreWeb AS nombreWeb_3, e0_.imagen AS imagen_4 FROM WEB.entidades_recaudadoras e0_ WHERE e0_.vigente = 1 ORDER BY e0_.conBoleta ASC, e0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.idEntidadRecaudadora AS idEntidadRecaudadora_0,
  e0_.link AS link_1,
  e0_.conBoleta AS conBoleta_2,
  e0_.nombreWeb AS nombreWeb_3,
  e0_.imagen AS imagen_4
FROM
  WEB.entidades_recaudadoras e0_
WHERE
  e0_.vigente = 1
ORDER BY
  e0_.conBoleta ASC,
  e0_.orden ASC

SELECT e0_.idEntidadRecaudadora AS idEntidadRecaudadora_0, e0_.link AS link_1, e0_.conBoleta AS conBoleta_2, e0_.nombreWeb AS nombreWeb_3, e0_.imagen AS imagen_4 FROM WEB.entidades_recaudadoras e0_ WHERE e0_.vigente = 1 ORDER BY e0_.conBoleta ASC, e0_.orden ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 30)
7	App\Repository\EntidadesRecaudadorasRepository->getEntidadesRecaudadoras (line 42)
8	App\Controller\DefaultController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
mssql	doctrine.dbal.mssql_connection
mysql	doctrine.dbal.mysql_connection

Entity Managers

Name	Service
mssql	doctrine.orm.mssql_entity_manager
mysql	doctrine.orm.mysql_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

mssql entity manager

Class	Amount of managed objects

mysql entity manager

Class	Amount of managed objects
App\Entity\MySQL\Sorteos	2
App\Entity\MySQL\DcTparamsistema	1

Entities Mapping

mssql entity manager

Class	Mapping errors
App\Entity\MSSQL\EntidadesRecaudadoras	No errors.

mysql entity manager

Class	Mapping errors
App\Entity\MySQL\Sorteos	No errors.
App\Entity\MySQL\DcTparamsistema	No errors.

Symfony Profiler

GET http://testing.esco.net.ar/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

mysql connection

mssql connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

mssql entity manager

mysql entity manager

Entities Mapping

mssql entity manager

mysql entity manager