Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.40 ms Query time

0 Invalid entities

41 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.54 ms

SELECT DISTINCT n0_.id AS id_0, n0_.ls_name AS ls_name_1, n0_.id AS id_2 FROM name n0_ ORDER BY n0_.ls_name ASC, n0_.id DESC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.ls_name AS ls_name_1,
  n0_.id AS id_2
FROM
  name n0_
ORDER BY
  n0_.ls_name ASC,
  n0_.id DESC
LIMIT
  50

SELECT DISTINCT n0_.id AS id_0, n0_.ls_name AS ls_name_1, n0_.id AS id_2 FROM name n0_ ORDER BY n0_.ls_name ASC, n0_.id DESC LIMIT 50;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 105)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
9	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
10	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
12	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

0.67 ms

SELECT n0_.id AS id_0, n0_.sku AS sku_1, n0_.ls_name AS ls_name_2, n0_.alloy_name AS alloy_name_3, n0_.mmt_name AS mmt_name_4, n0_.ds_name AS ds_name_5, n0_.ds_alternative_title AS ds_alternative_title_6, n0_.dd_name AS dd_name_7, n0_.synnex_name AS synnex_name_8, n0_.icecat_name AS icecat_name_9, n0_.icecat_title AS icecat_title_10, n0_.icecat_short_name AS icecat_short_name_11 FROM name n0_ WHERE n0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.ls_name ASC, n0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.sku AS sku_1,
  n0_.ls_name AS ls_name_2,
  n0_.alloy_name AS alloy_name_3,
  n0_.mmt_name AS mmt_name_4,
  n0_.ds_name AS ds_name_5,
  n0_.ds_alternative_title AS ds_alternative_title_6,
  n0_.dd_name AS dd_name_7,
  n0_.synnex_name AS synnex_name_8,
  n0_.icecat_name AS icecat_name_9,
  n0_.icecat_title AS icecat_title_10,
  n0_.icecat_short_name AS icecat_short_name_11
FROM
  name n0_
WHERE
  n0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  n0_.ls_name ASC,
  n0_.id DESC

SELECT n0_.id AS id_0, n0_.sku AS sku_1, n0_.ls_name AS ls_name_2, n0_.alloy_name AS alloy_name_3, n0_.mmt_name AS mmt_name_4, n0_.ds_name AS ds_name_5, n0_.ds_alternative_title AS ds_alternative_title_6, n0_.dd_name AS dd_name_7, n0_.synnex_name AS synnex_name_8, n0_.icecat_name AS icecat_name_9, n0_.icecat_title AS icecat_title_10, n0_.icecat_short_name AS icecat_short_name_11 FROM name n0_ WHERE n0_.id IN (37, 9, 27, 26, 34, 4, 20, 22, 6, 19, 30, 23, 38, 13, 35, 14, 12, 10, 18, 11, 41, 29, 15, 36, 5, 16, 24, 32, 25, 28, 40, 33, 39, 8, 7, 1, 21, 3, 2, 31, 17) ORDER BY n0_.ls_name ASC, n0_.id DESC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
4	Doctrine\ORM\Query->_doExecute (line 296)
5	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
6	Doctrine\ORM\AbstractQuery->execute (line 886)
7	Doctrine\ORM\AbstractQuery->getResult (line 688)
8	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
9	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 68)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
11	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 191)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

0.19 ms

SELECT count(*) AS sclr_0 FROM name n0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  name n0_

SELECT count(*) AS sclr_0 FROM name n0_;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 105)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
9	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
10	EasyCorp\Bundle\EasyAdminBundle\Orm\EntityPaginator->paginate (line 69)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
12	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->index (line 138)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 191)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	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\Name	41

Entities Mapping

Class	Mapping errors
App\Entity\Name	No errors.

Symfony Profiler

GET https://manage.syberinfo.com.au/admin/name?page=1&sort%5BlsName%5D=ASC

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping