Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

417.96 ms Query time

0 Invalid entities

11 Managed entities

Time▼

Count

Info

417.60 ms
(99.92%)

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 37)
6	App\Controller\ErpController->getCompaniesData (line 147)
7	App\Controller\ErpController->renderFormPage (line 137)
8	App\Controller\ErpController->requestion (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.35 ms
(0.08%)

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM purchase_department t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category_name AS category_name_2
FROM
  purchase_department t0

SELECT t0.id AS id_1, t0.category_name AS category_name_2 FROM purchase_department 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 42)
6	App\Controller\ErpController->getPurchaseDepData (line 148)
7	App\Controller\ErpController->renderFormPage (line 137)
8	App\Controller\ErpController->requestion (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)

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\PurchaseDepartment	6
App\Entity\CompanyMaster	5

Class	Mapping errors
App\Entity\CompanyMaster	No errors.
App\Entity\PurchaseDepartment	No errors.