Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.81 ms Query time

0 Invalid entities

5 Managed entities

Time▼

Count

Info

0.48 ms
(59.35%)

SELECT t0.id AS id_1, t0.fy_code AS fy_code_2, t0.company_name AS company_name_3 FROM company_master t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fy_code AS fy_code_2,
  t0.company_name AS company_name_3
FROM
  company_master t0

SELECT t0.id AS id_1, t0.fy_code AS fy_code_2, t0.company_name AS company_name_3 FROM company_master t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 161)
6	App\Controller\ErpController->list (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.20 ms
(24.93%)

SELECT * FROM MATERIAL_REQUEST_HEADER_tmp LIMIT 20 OFFSET 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  MATERIAL_REQUEST_HEADER_tmp
LIMIT
  20
OFFSET
  20

SELECT * FROM MATERIAL_REQUEST_HEADER_tmp LIMIT 20 OFFSET 20;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 245)
3	App\Controller\ErpController->list (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

0.13 ms
(15.72%)

SELECT COUNT(*) as total FROM MATERIAL_REQUEST_HEADER_tmp

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) as total
FROM
  MATERIAL_REQUEST_HEADER_tmp

SELECT COUNT(*) as total FROM MATERIAL_REQUEST_HEADER_tmp;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 246)
3	App\Controller\ErpController->list (line 181)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects
App\Entity\CompanyMaster	5

Class	Mapping errors
App\Entity\CompanyMaster	No errors.