Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

6.80 ms Query time

2 Invalid entities

1 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

4.53 ms
(66.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.date AS date_4, t0.inalienable AS inalienable_5, t0.type AS type_6, t0.laws AS laws_7 FROM core_holiday t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.comment AS comment_3,
  t0.date AS date_4,
  t0.inalienable AS inalienable_5,
  t0.type AS type_6,
  t0.laws AS laws_7
FROM
  core_holiday t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.date AS date_4, t0.inalienable AS inalienable_5, t0.type AS type_6, t0.laws AS laws_7 FROM core_holiday t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 47)
5	App\Util\Holidays\HolidayService->{closure:App\Util\Holidays\HolidayService::getHolidays():47} (line 48)
6	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():45} (line 111)
7	Symfony\Component\Cache\LockRegistry::compute (line 102)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 64)
9	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 85)
10	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 30)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 53)
12	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 47)
13	App\Util\Holidays\HolidayService->getHolidays (line 48)
14	App\Util\BusinessTime\BusinessTimeFactory->__construct (line 1839)
15	Container1xjJIme\App_KernelDevDebugContainer::getBusinessTimeFactoryService (line 1864)
16	Container1xjJIme\App_KernelDevDebugContainer::getSLACalculatorServiceService (line 4146)
17	Container1xjJIme\App_KernelDevDebugContainer::getTwigService (line 961)
18	Container1xjJIme\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 3738)
19	Container1xjJIme\App_KernelDevDebugContainer::getProfilerListenerService (line 1351)
20	Container1xjJIme\App_KernelDevDebugContainer::{closure:Container1xjJIme\App_KernelDevDebugContainer::getEventDispatcherService():1351} (line 235)
21	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
22	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
25	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.26 ms
(33.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.header_logo AS header_logo_4, t0.footer_logo AS footer_logo_5, t0.is_main AS is_main_6, t0.national_id AS national_id_7 FROM core_holding t0 WHERE t0.is_main = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.header_logo AS header_logo_4,
  t0.footer_logo AS footer_logo_5,
  t0.is_main AS is_main_6,
  t0.national_id AS national_id_7
FROM
  core_holding t0
WHERE
  t0.is_main = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.header_logo AS header_logo_4, t0.footer_logo AS footer_logo_5, t0.is_main AS is_main_6, t0.national_id AS national_id_7 FROM core_holding t0 WHERE t0.is_main = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 57)
4	App\Util\BusinessTime\BusinessTimeFactory->getBusiness (line 29)
5	App\Util\SLA\SLACalculatorService->__construct (line 1870)
6	Container1xjJIme\App_KernelDevDebugContainer::getSLACalculatorServiceService (line 4146)
7	Container1xjJIme\App_KernelDevDebugContainer::getTwigService (line 961)
8	Container1xjJIme\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 3738)
9	Container1xjJIme\App_KernelDevDebugContainer::getProfilerListenerService (line 1351)
10	Container1xjJIme\App_KernelDevDebugContainer::{closure:Container1xjJIme\App_KernelDevDebugContainer::getEventDispatcherService():1351} (line 235)
11	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
12	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 276)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 133)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 239)
15	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Holding	1

Entities Mapping

Class	Mapping errors
App\Entity\Holiday	No errors.
App\Entity\Holding	No errors.
App\Entity\OUManagement	No errors.
App\Entity\OUSubmanagement	No errors.
App\Entity\OUZone	No errors.
App\Entity\OrganizationalUnit	No errors.
App\Entity\Contract	No errors.
App\Entity\HoldingTime	No errors.
App\Entity\CostCenter	No errors.
App\Entity\Position	No errors.
App\Entity\SLA	No errors.
App\Entity\Workflow	No errors.
App\Entity\User	No errors.
App\Entity\OUProfile	No errors.
App\Entity\DPA	No errors.
App\Entity\ContractOU	No errors.
App\Entity\WorkflowOURole	No errors.
App\Entity\Location	No errors.
App\Entity\Asset	No errors.
App\Entity\Van	No errors.
App\Entity\PostalPackage	No errors.
App\Entity\FleetControl	No errors.
App\Entity\UtilitiesBillHistory	No errors.
App\Entity\Supplier	No errors.
App\Entity\ContractItem	No errors.
App\Entity\Product	No errors.
App\Entity\Service	No errors.
App\Entity\ProfilePosition	No errors.
App\Entity\WorkflowState	The association App\Entity\WorkflowState#workflowAssignees refers to the owning side field App\Entity\WorkflowAssignee#state which does not exist.
App\Entity\WorkflowProcess	No errors.
App\Entity\Bidding	No errors.
App\Entity\WorkflowHistory	No errors.
App\Entity\WorkflowAssignee	No errors.
App\Entity\Calendar	No errors.
App\Entity\WorkflowRole	No errors.
App\Entity\PostalPackageHistory	No errors.
App\Entity\PostalManifest	No errors.
App\Entity\ProfileUser	No errors.
App\Entity\CalendarAssigned	No errors.
App\Entity\FacilityLocation	No errors.
App\Entity\WorkflowRoleUser	No errors.
App\Entity\Report	No errors.
App\Entity\Webhook	No errors.
App\Entity\WorkflowProfileRole	No errors.
App\Entity\ContractItemSla	No errors.
App\Entity\FleetControlRole	No errors.
App\Entity\FleetControlHistory	No errors.
App\Entity\SupplierCategory	No errors.
App\Entity\SupplierQualitySurvey	No errors.
App\Entity\SupplierSubcontractor	No errors.
App\Entity\SupplierEmployee	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\SupplierDocumentCompany	No errors.
App\Entity\CategoryPublic	No errors.
App\Entity\ProductSla	No errors.
App\Entity\ServiceFamily	No errors.
App\Entity\InterchangeableProfile	No errors.
App\Entity\ServiceSla	No errors.
App\Entity\WorkflowProcessNode	No errors.
App\Entity\WorkflowProcessAction	No errors.
App\Entity\PostalPackageBatch	No errors.
App\Entity\ProcessCategory	No errors.
App\Entity\News	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\ProfileRedirect	No errors.
App\Entity\SupplierDocumentFamily	No errors.
App\Entity\ExecutiveVisitCategory	No errors.
App\Entity\SupplierDocumentEmployee	No errors.
App\Entity\RealstateProperty	No errors.
App\Entity\RealstatePropertyHistory	No errors.
App\Entity\ReportExport	No errors.
App\Entity\SupplierDocument	No errors.
App\Entity\SummaryWorkflowDaily	No errors.
App\Entity\SupplierDocumentSubcontractor	No errors.
App\Entity\WorkflowProcessCallback	No errors.
App\Entity\RealstatePropertyImage	No errors.
App\Entity\PostalPackageBatchItem	No errors.
App\Entity\Job	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
BE\Support\KnowledgeBaseBundle\Entity\Rating	No errors.
BE\Support\KnowledgeBaseBundle\Entity\SearchQueryDetails	No errors.
BE\Support\KnowledgeBaseBundle\Entity\Tag	No errors.
BE\Support\KnowledgeBaseBundle\Entity\Article	No errors.
BE\Support\KnowledgeBaseBundle\Entity\Category	The association BE\Support\KnowledgeBaseBundle\Entity\Category#helpdeskCategory refers to the inverse side field BE\Support\HelpdeskBundle\Entity\Category#kbCategories which does not exist.
BE\Support\KnowledgeBaseBundle\Entity\Comment	No errors.
BE\Support\KnowledgeBaseBundle\Entity\SearchQuery	No errors.
BE\Support\HelpdeskBundle\Entity\ResponseTemplate	No errors.
BE\Support\HelpdeskBundle\Entity\CategoryAgent	No errors.
BE\Support\HelpdeskBundle\Entity\Helpdesk	No errors.
BE\Support\HelpdeskBundle\Entity\IssueComment	No errors.
BE\Support\HelpdeskBundle\Entity\Issue	No errors.
BE\Support\HelpdeskBundle\Entity\IssueMember	No errors.
BE\Support\HelpdeskBundle\Entity\Agent	No errors.
BE\Support\HelpdeskBundle\Entity\Category	No errors.

Symfony Profiler

GET https://simplyflow.asurtest.cl/robots.txt

Configuration Settings

Theme

Page Width