Symfony Profiler

Query Metrics

26 Database Queries

3 Different statements

19.89 ms Query time

0 Invalid entities

42 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

16.21 ms
(81.51%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = ? ORDER BY t0.position ASC, t0.created_at ASC

Parameters:

[
  711
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.done AS done_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.ticket_id AS ticket_id_6
FROM
  ticket_task t0
WHERE
  t0.ticket_id = ?
ORDER BY
  t0.position ASC,
  t0.created_at ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.done AS done_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.ticket_id AS ticket_id_6 FROM ticket_task t0 WHERE t0.ticket_id = 711 ORDER BY t0.position ASC, t0.created_at ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_b0c5c56132fc8419d8d7b3a52f343263::block_content (line 327)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_854a9e8af4d4352b77e266e5a82ff314->block_body (line 338)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_854a9e8af4d4352b77e266e5a82ff314->doDisplay (line 122)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_b0c5c56132fc8419d8d7b3a52f343263->doDisplay (line 60)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
24	App\Controller\TicketsController->userTicketList (line 39)
25	App\Controller\TicketsController->eddy (line 57)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.67 ms
(13.44%)

SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = ? ORDER BY t0_.last_updated DESC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.ticket_number AS ticket_number_1,
  t0_.jira_link AS jira_link_2,
  t0_.last_updated AS last_updated_3,
  t0_.subject AS subject_4,
  t0_.short_description AS short_description_5,
  t0_.long_description AS long_description_6,
  t0_.owner AS owner_7,
  t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8,
  t0_.ticket_title AS ticket_title_9,
  t0_.assign_jira AS assign_jira_10,
  t0_.ticket_creator AS ticket_creator_11,
  t0_.os AS os_12,
  t0_.priority AS priority_13,
  t0_.status AS status_14,
  t0_.ticket_type AS ticket_type_15,
  t0_.last_automation_pass AS last_automation_pass_16,
  t0_.show_preparation AS show_preparation_17
FROM
  tickets t0_
  INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id
  INNER JOIN user u1_ ON u1_.id = t2_.user_id
WHERE
  u1_.id = ?
ORDER BY
  t0_.last_updated DESC

SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ INNER JOIN tickets_user t2_ ON t0_.id = t2_.tickets_id INNER JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = 5 ORDER BY t0_.last_updated DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TicketsRepository->findByAssignedUserWithFilters (line 69)
7	App\Controller\TicketsController->userTicketList (line 40)
8	App\Controller\TicketsController->eddy (line 57)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.00 ms
(5.05%)

SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ WHERE t0_.priority IN (?, ?, ?) AND t0_.status NOT IN (?, ?, ?) ORDER BY t0_.last_updated DESC LIMIT 10

Parameters:

[
  "Haute"
  "Critical"
  "Urgente"
  "Fermé"
  "Résolu"
  "Closed"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.ticket_number AS ticket_number_1,
  t0_.jira_link AS jira_link_2,
  t0_.last_updated AS last_updated_3,
  t0_.subject AS subject_4,
  t0_.short_description AS short_description_5,
  t0_.long_description AS long_description_6,
  t0_.owner AS owner_7,
  t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8,
  t0_.ticket_title AS ticket_title_9,
  t0_.assign_jira AS assign_jira_10,
  t0_.ticket_creator AS ticket_creator_11,
  t0_.os AS os_12,
  t0_.priority AS priority_13,
  t0_.status AS status_14,
  t0_.ticket_type AS ticket_type_15,
  t0_.last_automation_pass AS last_automation_pass_16,
  t0_.show_preparation AS show_preparation_17
FROM
  tickets t0_
WHERE
  t0_.priority IN (?, ?, ?)
  AND t0_.status NOT IN (?, ?, ?)
ORDER BY
  t0_.last_updated DESC
LIMIT
  10

SELECT t0_.id AS id_0, t0_.ticket_number AS ticket_number_1, t0_.jira_link AS jira_link_2, t0_.last_updated AS last_updated_3, t0_.subject AS subject_4, t0_.short_description AS short_description_5, t0_.long_description AS long_description_6, t0_.owner AS owner_7, t0_.after_sales_service_volumetry AS after_sales_service_volumetry_8, t0_.ticket_title AS ticket_title_9, t0_.assign_jira AS assign_jira_10, t0_.ticket_creator AS ticket_creator_11, t0_.os AS os_12, t0_.priority AS priority_13, t0_.status AS status_14, t0_.ticket_type AS ticket_type_15, t0_.last_automation_pass AS last_automation_pass_16, t0_.show_preparation AS show_preparation_17 FROM tickets t0_ WHERE t0_.priority IN ('Haute', 'Critical', 'Urgente') AND t0_.status NOT IN ('Fermé', 'Résolu', 'Closed') ORDER BY t0_.last_updated DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TicketsRepository->findHighPriority (line 85)
7	App\Twig\Components\Top->getHighPriorityTickets (line 21)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_1ea9af390f3f2bf45ed1423ada804747::doDisplay (line 88)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 77)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 56)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 51)
16	__TwigTemplate_854a9e8af4d4352b77e266e5a82ff314->block_body (line 281)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_854a9e8af4d4352b77e266e5a82ff314->doDisplay (line 122)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_b0c5c56132fc8419d8d7b3a52f343263->doDisplay (line 60)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
29	App\Controller\TicketsController->userTicketList (line 39)
30	App\Controller\TicketsController->eddy (line 57)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 191)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	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\Entity\Tickets	28
App\Entity\TicketTask	14

Entities Mapping

Class	Mapping errors
App\Entity\Tickets	No errors.
App\Entity\User	No errors.
App\Entity\Chapeau	No errors.
App\Entity\TicketComment	No errors.
App\Entity\TicketTask	No errors.

Symfony Profiler

GET https://app-test.fr/tickets/eddy

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping