Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

1.97 ms Query time

8 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

1.36 ms
(68.80%)

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\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Util\BusinessTime\BusinessTimeFactory->getBusiness (line 64)
4	Legacy\Helper\SlaCalculator->__construct (line 40)
5	ContainerSJheOMW\App_KernelDevDebugContainer->getSlaCalculatorService (line 1438)
6	ContainerSJheOMW\App_KernelDevDebugContainer::getTwigService (line 7294)
7	ContainerSJheOMW\getBeSurvey_Listener_SendEmailApproveDiscardListenerService::do (line 28)
8	ContainerSJheOMW\App_KernelDevDebugContainer::load (line 1307)
9	Symfony\Component\DependencyInjection\Container->getService (line 404)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
11	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 181)
12	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 92)
13	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->__construct (line 53)
14	App\Repository\CategoryPublicRepository->__construct (line 26)
15	ContainerSJheOMW\App_KernelDevDebugContainer->getCategoryPublicRepositoryService (line 3015)
16	ContainerSJheOMW\App_KernelDevDebugContainer::getProfileAccessSubscriberService (line 2741)
17	ContainerSJheOMW\App_KernelDevDebugContainer::{closure:ContainerSJheOMW\App_KernelDevDebugContainer::getEventDispatcherService():1881} (line 1881)
18	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 235)
19	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 290)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 136)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 208)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.61 ms
(31.20%)

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.code = ? LIMIT 1

Parameters:

[
  "BEX"
]

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.code = ?
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.code = 'BEX' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Legacy\Helper\SlaSECalculator->__construct (line 49)
4	ContainerSJheOMW\getSlaSECalculatorService->do (line 34)
5	ContainerSJheOMW\App_KernelDevDebugContainer::load (line 1307)
6	ContainerSJheOMW\getOutsourcingExpressionLanguageProviderService->do (line 39)
7	ContainerSJheOMW\App_KernelDevDebugContainer::load (line 1307)
8	ContainerSJheOMW\App_KernelDevDebugContainer->{closure:ContainerSJheOMW\App_KernelDevDebugContainer::getExpressionLanguageService():3292} (line 3303)
9	iterator_to_array (line 17)
10	App\Workflow\ExpressionLanguage\ExpressionLanguage::__construct (line 17)
11	ContainerSJheOMW\App_KernelDevDebugContainer->getExpressionLanguageService (line 3292)
12	ContainerSJheOMW\getFunctionProvider4Service::do (line 24)
13	ContainerSJheOMW\App_KernelDevDebugContainer::load (line 1307)
14	ContainerSJheOMW\App_KernelDevDebugContainer->{closure:ContainerSJheOMW\App_KernelDevDebugContainer::getExpressionLanguage2Service():3583} (line 3586)
15	iterator_to_array (line 17)
16	BE\ProcessBundle\Language\ExpressionLanguage::__construct (line 17)
17	ContainerSJheOMW\App_KernelDevDebugContainer->getExpressionLanguage2Service (line 3583)
18	ContainerSJheOMW\App_KernelDevDebugContainer::getTwigService (line 7336)
19	ContainerSJheOMW\getBeSurvey_Listener_SendEmailApproveDiscardListenerService::do (line 28)
20	ContainerSJheOMW\App_KernelDevDebugContainer::load (line 1307)
21	Symfony\Component\DependencyInjection\Container->getService (line 404)
22	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
23	Symfony\Bridge\Doctrine\ContainerAwareEventManager->initializeListeners (line 181)
24	Symfony\Bridge\Doctrine\ContainerAwareEventManager->getAllListeners (line 92)
25	Gedmo\Tree\Entity\Repository\AbstractTreeRepository->__construct (line 53)
26	App\Repository\CategoryPublicRepository->__construct (line 26)
27	ContainerSJheOMW\App_KernelDevDebugContainer->getCategoryPublicRepositoryService (line 3015)
28	ContainerSJheOMW\App_KernelDevDebugContainer::getProfileAccessSubscriberService (line 2741)
29	ContainerSJheOMW\App_KernelDevDebugContainer::{closure:ContainerSJheOMW\App_KernelDevDebugContainer::getEventDispatcherService():1881} (line 1881)
30	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 235)
31	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 290)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 136)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 208)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	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	2

Entities Mapping

Class	Mapping errors
App\Entity\CategoryPublic	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\Module\Helpdesk\Entity\Category	No errors.
BE\ProcessBundle\Entity\ProcessUnitConfig	No errors.
BE\UniformBundle\Entity\UniformMeasure	No errors.
BE\UniformBundle\Entity\UniformGarment	No errors.
BE\UniformBundle\Entity\EstimateDelivery	No errors.
App\Module\KnowledgeBase\Entity\Category	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingOfficeConfig	No errors.
BE\ProcessBundle\Entity\ProcessMain	No errors.
BE\ProcessBundle\Entity\ProcessUnitRole	No errors.
App\Entity\Service	No errors.
App\Entity\Product	No errors.
BE\ControlBundle\Entity\ControlSurprise	No errors.
App\Entity\User	No errors.
App\Entity\OUProfile	No errors.
App\Entity\DPA	No errors.
BE\AccountingRecordBundle\Entity\AccountingOfficeCategory	No errors.
App\Entity\ContractOU	No errors.
BE\ControlBundle\Entity\ControlPlanned	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\ProfilePosition	No errors.
App\Entity\WorkflowState	No errors.
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\Module\Helpdesk\Entity\CategoryAgent	No errors.
App\Module\Helpdesk\Entity\EmbeddedForm	No errors.
BE\ProcessBundle\Entity\ProcessUnitWorkflow	No errors.
BE\UniformBundle\Entity\UniformSizeTable	No errors.
BE\UniformBundle\Entity\UniformGarmentProduct	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Module\KnowledgeBase\Entity\Article	No errors.
BE\ProcessBundle\Entity\ProcessState	No errors.
BE\ProcessBundle\Entity\ProcessAttribute	No errors.
BE\ProcessBundle\Entity\ProcessProfile	No errors.
App\Entity\Holiday	No errors.
App\Entity\ServiceSla	No errors.
App\Entity\ProfileUser	No errors.
App\Entity\ServiceFamily	No errors.
App\Entity\InterchangeableProfile	No errors.
App\Entity\StandardCheckRate	No errors.
App\Entity\ProductSla	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\UserPositionChangeRequest	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.
App\Entity\SupplierDocumentCompany	No errors.
App\Entity\GuardiasServiceRate	No errors.
App\Entity\WorkflowProcessNode	No errors.
App\Entity\WorkflowProcessAction	No errors.
App\Entity\PostalPackageBatch	No errors.
App\Entity\ExecutiveVisitCategory	No errors.
App\Entity\ReportExport	No errors.
App\Entity\SupplierDocument	No errors.
App\Entity\APIRequestLog	No errors.
App\Entity\ProcessCategory	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\SpecialCheckRate	No errors.
App\Entity\DashboardFilter	No errors.
App\Entity\PostalPackageBatchItem	No errors.
App\Entity\RealstatePropertyImage	No errors.
App\Entity\ProcessMailSentLog	No errors.
App\Entity\Job	No errors.
App\Entity\SupplierDocumentFamily	No errors.
App\Entity\RealstatePropertyHistory	No errors.
App\Entity\SupplierDocumentSubcontractor	No errors.
App\Entity\OUManager	No errors.
App\Entity\News	No errors.
App\Entity\UserApproval	No errors.
App\Entity\SummaryWorkflowDaily	No errors.
App\Entity\WorkflowProcessCallback	No errors.
App\Entity\VerificationCode	No errors.
App\Entity\GuardiasBilling	No errors.
App\Entity\RoleAssignmentProposal	No errors.
App\Entity\ProfileRedirect	No errors.
App\Entity\RealstateProperty	No errors.
App\Entity\SupplierDocumentEmployee	No errors.
Gedmo\Tree\Entity\MappedSuperclass\AbstractClosure	No errors.
App\Api\Entity\ApiToken	No errors.
App\Api\Entity\ApiClient	No errors.
App\Module\Helpdesk\Entity\Agent	No errors.
App\Module\Helpdesk\Entity\IssueMember	No errors.
App\Module\Helpdesk\Entity\Vip	No errors.
App\Module\Helpdesk\Entity\IssueTransitionHistory	No errors.
App\Module\Helpdesk\Entity\IssueComment	No errors.
App\Module\Helpdesk\Entity\Notification	No errors.
App\Module\Helpdesk\Entity\ResponseTemplate	No errors.
App\Module\Helpdesk\Entity\Issue	No errors.
App\Module\KnowledgeBase\Entity\Tag	No errors.
App\Module\KnowledgeBase\Entity\Comment	No errors.
App\Module\KnowledgeBase\Entity\Rating	No errors.
App\Module\KnowledgeBase\Entity\ArticleSection	No errors.
App\Module\KnowledgeBase\Entity\SearchQuery	No errors.
App\Module\KnowledgeBase\Entity\Faq	No errors.
App\Module\KnowledgeBase\Entity\SearchQueryDetails	No errors.
BE\ProcessBundle\Entity\ProcessAssignee	No errors.
BE\ProcessBundle\Entity\ProcessProfileSLA	No errors.
BE\ProcessBundle\Entity\ProcessSequence	No errors.
BE\ProcessBundle\Entity\ProcessSurrogationLog	No errors.
Tionvel\RecoveryBundle\Entity\MoneyRecovery	No errors.
BE\Document\CustodyBundle\Entity\RequestBatchItem	No errors.
BE\Document\CustodyBundle\Entity\RequestBatch	No errors.
BE\Document\CustodyBundle\Entity\TransportRule	No errors.
BE\Document\CustodyBundle\Entity\DocumentBox	No errors.
BE\Document\CustodyBundle\Entity\Requester	No errors.
BE\Document\CustodyBundle\Entity\SlaOfficeType	No errors.
BE\Document\CustodyBundle\Entity\BoxLimit	No errors.
BE\Document\CustodyBundle\Entity\SlaOfficeClasification	No errors.
BE\Document\CustodyBundle\Entity\CustodyRule	No errors.
BE\Document\CustodyBundle\Entity\PartitionOffice	No errors.
BE\Document\CustodyBundle\Entity\DocumentCatalog	No errors.
BE\Document\CustodyBundle\Entity\Ley21694Manager	No errors.
BE\AccountingRecordBundle\Entity\AccountingRequester	No errors.
BE\AccountingRecordBundle\Entity\AccountingRecordT131CCN	No errors.
BE\ControlBundle\Entity\ControlPlannedRecord	No errors.
BE\ControlBundle\Entity\ControlPlannedRequester	No errors.
BE\ControlBundle\Entity\ControlPlannedRecordHistory	No errors.
Tionvel\WorkflowBundle\Entity\WorkflowState	No errors.
Tionvel\WorkflowBundle\Entity\WorkflowAssignee	No errors.
Tionvel\WorkflowBundle\Entity\WorkflowSequence	No errors.
Tionvel\WorkflowBundle\Entity\WorkflowAttribute	No errors.
Tionvel\WorkflowBundle\Entity\WorkflowProcess	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingPrevaluatorMotive	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingMotive	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingPrevaluator	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingOfficeMonthlyLimit	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingRequester	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingReferred	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingCausal	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingApprover	No errors.
Tionvel\OutsourcingBundle\Entity\OutsourcingVariant	No errors.
BE\Outsourcing\DifferenceCashBundle\Entity\DifferenceCashSla	No errors.
BE\Outsourcing\DifferenceCashBundle\Entity\Requirement	No errors.
BE\UniformBundle\Entity\UniformAlternativeProduct	No errors.
BE\UniformBundle\Entity\UniformUser	The association BE\UniformBundle\Entity\UniformUser#user refers to the inverse side field App\Entity\User#uniformProducts which does not exist. The association BE\UniformBundle\Entity\UniformUser#product refers to the inverse side field App\Entity\Product#uniformUsers which does not exist.
BE\UniformBundle\Entity\UniformAlternative	No errors.
BE\UniformBundle\Entity\MassiveAcceptationGroup	No errors.
BE\UniformBundle\Entity\MassiveCertificationGroup	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsConditionalAmount	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsUtGg	The association BE\Bidding\InterventionsBundle\Entity\InterventionsUtGg#office refers to the inverse side field App\Entity\OrganizationalUnit#interventionsSupplier which does not exist.
BE\Bidding\InterventionsBundle\Entity\InterventionsTipoObra	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsServiceCategory	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsSupplier	The association BE\Bidding\InterventionsBundle\Entity\InterventionsSupplier#office refers to the inverse side field App\Entity\OrganizationalUnit#interventionsSupplier which does not exist.
BE\Bidding\InterventionsBundle\Entity\InterventionsItem	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsRequester	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsUnidadMedida	No errors.
BE\Bidding\InterventionsBundle\Entity\InterventionsItemsPrice	No errors.
BE\Outsourcing\CorporateBundle\Entity\Solicitante	No errors.
BE\Outsourcing\CorporateBundle\Entity\CorporateRequestBatchItem	No errors.
BE\Outsourcing\CorporateBundle\Entity\CorporateRequestBatch	No errors.
BE\Outsourcing\CorporateBundle\Entity\OutsourcingCorporatePreEvaluationConfig	No errors.
BE\Outsourcing\CorporateBundle\Entity\CargoExterno	No errors.
BE\Outsourcing\CorporateBundle\Entity\Referido	No errors.
BE\Outsourcing\CorporateBundle\Entity\OutsourcingCorporatePreEvaluationRule	No errors.
BE\Outsourcing\CorporateBundle\Entity\PositionSupplier	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\Solicitante	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\CorporateRequestBatchItem	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\CorporateRequestBatch	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\CargoExterno	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\OutsourcingServiciosProfesionalesPreEvaluationRule	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\Referido	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\OutsourcingServiciosProfesionalesPreEvaluationConfig	No errors.
BE\Outsourcing\ServiciosProfesionalesBundle\Entity\PositionSupplier	No errors.
BE\SurveyBundle\Entity\SurveyAnswer	The association BE\SurveyBundle\Entity\SurveyAnswer#itemsAnswer refers to the owning side field BE\SurveyBundle\Entity\ItemAnswer#survey_item_answer which does not exist.
BE\SurveyBundle\Entity\ItemAnswer	The mappings BE\SurveyBundle\Entity\ItemAnswer#surveyAnswer and BE\SurveyBundle\Entity\SurveyAnswer#itemsAnswer are inconsistent with each other.
BE\SurveyBundle\Entity\Page	The association BE\SurveyBundle\Entity\Page#survey refers to the inverse side field BE\SurveyBundle\Entity\Survey#Pages which does not exist. The mappings BE\SurveyBundle\Entity\Page#questions and BE\SurveyBundle\Entity\Question#page are inconsistent with each other.
BE\SurveyBundle\Entity\Item	No errors.
BE\SurveyBundle\Entity\Survey	The mappings BE\SurveyBundle\Entity\Survey#pages and BE\SurveyBundle\Entity\Page#survey are inconsistent with each other.
BE\SurveyBundle\Entity\Role	No errors.
BE\SurveyBundle\Entity\AuthUser	No errors.
BE\SurveyBundle\Entity\User	No errors.
BE\SurveyBundle\Entity\Question	The association BE\SurveyBundle\Entity\Question#page refers to the inverse side field BE\SurveyBundle\Entity\Page#Questions which does not exist.
BE\SurveyBundle\Entity\SurveyDiscardRequest	No errors.

Symfony Profiler

GET https://srcdev.ifxsrc.cl/robots.txt

Configuration Settings

Theme

Page Width