Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.90 ms Query time

0 Invalid entities

270 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.81 ms
(81.55%)

SELECT t0.id AS id_1, t0.ticket_number AS ticket_number_2, t0.jira_link AS jira_link_3, t0.last_updated AS last_updated_4, t0.subject AS subject_5, t0.short_description AS short_description_6, t0.long_description AS long_description_7, t0.owner AS owner_8, t0.after_sales_service_volumetry AS after_sales_service_volumetry_9, t0.ticket_title AS ticket_title_10, t0.assign_jira AS assign_jira_11, t0.ticket_creator AS ticket_creator_12, t0.os AS os_13, t0.priority AS priority_14, t0.status AS status_15, t0.ticket_type AS ticket_type_16, t0.last_automation_pass AS last_automation_pass_17 FROM tickets t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ticket_number AS ticket_number_2,
  t0.jira_link AS jira_link_3,
  t0.last_updated AS last_updated_4,
  t0.subject AS subject_5,
  t0.short_description AS short_description_6,
  t0.long_description AS long_description_7,
  t0.owner AS owner_8,
  t0.after_sales_service_volumetry AS after_sales_service_volumetry_9,
  t0.ticket_title AS ticket_title_10,
  t0.assign_jira AS assign_jira_11,
  t0.ticket_creator AS ticket_creator_12,
  t0.os AS os_13,
  t0.priority AS priority_14,
  t0.status AS status_15,
  t0.ticket_type AS ticket_type_16,
  t0.last_automation_pass AS last_automation_pass_17
FROM
  tickets t0

SELECT t0.id AS id_1, t0.ticket_number AS ticket_number_2, t0.jira_link AS jira_link_3, t0.last_updated AS last_updated_4, t0.subject AS subject_5, t0.short_description AS short_description_6, t0.long_description AS long_description_7, t0.owner AS owner_8, t0.after_sales_service_volumetry AS after_sales_service_volumetry_9, t0.ticket_title AS ticket_title_10, t0.assign_jira AS assign_jira_11, t0.ticket_creator AS ticket_creator_12, t0.os AS os_13, t0.priority AS priority_14, t0.status AS status_15, t0.ticket_type AS ticket_type_16, t0.last_automation_pass AS last_automation_pass_17 FROM tickets t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\TicketsController->index (line 25)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.09 ms
(18.45%)

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 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
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 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 32)
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 280)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_854a9e8af4d4352b77e266e5a82ff314->doDisplay (line 121)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_2894d0609cdfcccccf075821640864db->doDisplay (line 54)
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->index (line 24)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 191)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	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	270

Entities Mapping

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

Symfony Profiler

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

Configuration Settings

Theme

Page Width