Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.10 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.70 ms
(63.81%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_default AS is_default_3 FROM support_ticket_status s0_ WHERE s0_.is_default = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.code AS code_2,
  s0_.is_default AS is_default_3
FROM
  support_ticket_status s0_
WHERE
  s0_.is_default = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.is_default AS is_default_3 FROM support_ticket_status s0_ WHERE s0_.is_default = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\SupportBundle\Repository\SupportTicketStatusRepository->findDefault (line 26)
7	App\Controller\LandingController->__invoke (line 39)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.40 ms
(36.19%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.description AS description_3, s0_.is_active AS is_active_4 FROM support_ticket_category s0_ WHERE s0_.is_active = ? ORDER BY s0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.code AS code_2,
  s0_.description AS description_3,
  s0_.is_active AS is_active_4
FROM
  support_ticket_category s0_
WHERE
  s0_.is_active = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.code AS code_2, s0_.description AS description_3, s0_.is_active AS is_active_4 FROM support_ticket_category s0_ WHERE s0_.is_active = 1 ORDER BY s0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\LandingController->__invoke (line 61)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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\SupportBundle\Entity\SupportTicketCategory	3
App\SupportBundle\Entity\SupportTicketStatus	1

Entities Mapping

Class	Mapping errors
App\SupportBundle\Entity\SupportTicketCategory	No errors.
App\SupportBundle\Entity\SupportTicketStatus	No errors.
App\SupportBundle\Entity\SupportTicket	No errors.

Symfony Profiler

GET https://unitel.codeplus.es/

Configuration Settings

Theme

Page Width