Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

15.07 ms Query time

0 Invalid entities

126 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

10.76 ms
(71.40%)

SELECT e0_.id AS id_0, e0_.image_name AS image_name_1, e0_.is_active AS is_active_2, e0_.hightlight AS hightlight_3, e0_.display_order AS display_order_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.rsi_id AS rsi_id_8, r1_.name AS name_9, r1_.type AS type_10, r1_.banner_image AS banner_image_11, r1_.link AS link_12, r1_.created_at AS created_at_13, r1_.updated_at AS updated_at_14, t2_.id AS id_15, t2_.name AS name_16, t2_.created_at AS created_at_17, t2_.updated_at AS updated_at_18, r3_.id AS id_19, r3_.rsi_id AS rsi_id_20, r3_.name AS name_21, r3_.rsi_image_name AS rsi_image_name_22, r3_.image_name AS image_name_23, r3_.created_at AS created_at_24, r3_.updated_at AS updated_at_25, e0_.taken_by_id AS taken_by_id_26, e0_.created_by AS created_by_27, e0_.updated_by AS updated_by_28, r1_.manufacturer_id AS manufacturer_id_29, t2_.created_by AS created_by_30, t2_.updated_by AS updated_by_31 FROM exploit e0_ LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id ORDER BY e0_.display_order ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.image_name AS image_name_1,
  e0_.is_active AS is_active_2,
  e0_.hightlight AS hightlight_3,
  e0_.display_order AS display_order_4,
  e0_.created_at AS created_at_5,
  e0_.updated_at AS updated_at_6,
  r1_.id AS id_7,
  r1_.rsi_id AS rsi_id_8,
  r1_.name AS name_9,
  r1_.type AS type_10,
  r1_.banner_image AS banner_image_11,
  r1_.link AS link_12,
  r1_.created_at AS created_at_13,
  r1_.updated_at AS updated_at_14,
  t2_.id AS id_15,
  t2_.name AS name_16,
  t2_.created_at AS created_at_17,
  t2_.updated_at AS updated_at_18,
  r3_.id AS id_19,
  r3_.rsi_id AS rsi_id_20,
  r3_.name AS name_21,
  r3_.rsi_image_name AS rsi_image_name_22,
  r3_.image_name AS image_name_23,
  r3_.created_at AS created_at_24,
  r3_.updated_at AS updated_at_25,
  e0_.taken_by_id AS taken_by_id_26,
  e0_.created_by AS created_by_27,
  e0_.updated_by AS updated_by_28,
  r1_.manufacturer_id AS manufacturer_id_29,
  t2_.created_by AS created_by_30,
  t2_.updated_by AS updated_by_31
FROM
  exploit e0_
  LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id
  LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id
  LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id
  LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id
  LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id
ORDER BY
  e0_.display_order ASC

SELECT e0_.id AS id_0, e0_.image_name AS image_name_1, e0_.is_active AS is_active_2, e0_.hightlight AS hightlight_3, e0_.display_order AS display_order_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, r1_.id AS id_7, r1_.rsi_id AS rsi_id_8, r1_.name AS name_9, r1_.type AS type_10, r1_.banner_image AS banner_image_11, r1_.link AS link_12, r1_.created_at AS created_at_13, r1_.updated_at AS updated_at_14, t2_.id AS id_15, t2_.name AS name_16, t2_.created_at AS created_at_17, t2_.updated_at AS updated_at_18, r3_.id AS id_19, r3_.rsi_id AS rsi_id_20, r3_.name AS name_21, r3_.rsi_image_name AS rsi_image_name_22, r3_.image_name AS image_name_23, r3_.created_at AS created_at_24, r3_.updated_at AS updated_at_25, e0_.taken_by_id AS taken_by_id_26, e0_.created_by AS created_by_27, e0_.updated_by AS updated_by_28, r1_.manufacturer_id AS manufacturer_id_29, t2_.created_by AS created_by_30, t2_.updated_by AS updated_by_31 FROM exploit e0_ LEFT JOIN exploit_ship e4_ ON e0_.id = e4_.exploit_id LEFT JOIN rsi_ship r1_ ON r1_.id = e4_.ship_id LEFT JOIN exploit_tag e5_ ON e0_.id = e5_.exploit_id LEFT JOIN tag t2_ ON t2_.id = e5_.tag_id LEFT JOIN rsi_manufacturer r3_ ON r1_.manufacturer_id = r3_.id ORDER BY e0_.display_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 50)
7	App\Repository\Exploit\ExploitRepository->getLastExploit (line 20)
8	App\Controller\ExploitController->exploits (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
14	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 437)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 335)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 213)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 173)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

2.48 ms
(16.48%)

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_active AS is_active_3, t0.hightlight AS hightlight_4, t0.display_order AS display_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.taken_by_id AS taken_by_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM exploit t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_name AS image_name_2,
  t0.is_active AS is_active_3,
  t0.hightlight AS hightlight_4,
  t0.display_order AS display_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.taken_by_id AS taken_by_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10
FROM
  exploit t0

SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.is_active AS is_active_3, t0.hightlight AS hightlight_4, t0.display_order AS display_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.taken_by_id AS taken_by_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM exploit t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 42)
6	App\Twig\Components\Exploit\ExploitsListingComponent->mount (line 1)
7	ReflectionMethod->invoke (line 171)
8	Symfony\UX\TwigComponent\ComponentFactory->mount (line 93)
9	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
10	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
11	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
12	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 82)
13	__TwigTemplate_0048ceff5b44b12c528c61198faca4d1->block_body (line 432)
14	Twig\Template->yieldBlock (line 103)
15	__TwigTemplate_e8f0ef7b4bc4c437496ccdf262de15a7->doDisplay (line 388)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_0048ceff5b44b12c528c61198faca4d1->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 50)
26	App\Controller\ExploitController->exploits (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 86)
30	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
31	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
32	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 437)
33	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 335)
34	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 213)
35	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 173)
36	Symfony\Component\HttpKernel\Kernel->handle (line 35)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
38	require_once (line 5)

1.83 ms
(12.12%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, e1_.id AS id_4, e1_.image_name AS image_name_5, e1_.is_active AS is_active_6, e1_.hightlight AS hightlight_7, e1_.display_order AS display_order_8, e1_.created_at AS created_at_9, e1_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, e1_.taken_by_id AS taken_by_id_13, e1_.created_by AS created_by_14, e1_.updated_by AS updated_by_15 FROM tag t0_ LEFT JOIN exploit_tag e2_ ON t0_.id = e2_.tag_id LEFT JOIN exploit e1_ ON e1_.id = e2_.exploit_id HAVING e1_.id >= 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.created_at AS created_at_2,
  t0_.updated_at AS updated_at_3,
  e1_.id AS id_4,
  e1_.image_name AS image_name_5,
  e1_.is_active AS is_active_6,
  e1_.hightlight AS hightlight_7,
  e1_.display_order AS display_order_8,
  e1_.created_at AS created_at_9,
  e1_.updated_at AS updated_at_10,
  t0_.created_by AS created_by_11,
  t0_.updated_by AS updated_by_12,
  e1_.taken_by_id AS taken_by_id_13,
  e1_.created_by AS created_by_14,
  e1_.updated_by AS updated_by_15
FROM
  tag t0_
  LEFT JOIN exploit_tag e2_ ON t0_.id = e2_.tag_id
  LEFT JOIN exploit e1_ ON e1_.id = e2_.exploit_id
HAVING
  e1_.id >= 1

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3, e1_.id AS id_4, e1_.image_name AS image_name_5, e1_.is_active AS is_active_6, e1_.hightlight AS hightlight_7, e1_.display_order AS display_order_8, e1_.created_at AS created_at_9, e1_.updated_at AS updated_at_10, t0_.created_by AS created_by_11, t0_.updated_by AS updated_by_12, e1_.taken_by_id AS taken_by_id_13, e1_.created_by AS created_by_14, e1_.updated_by AS updated_by_15 FROM tag t0_ LEFT JOIN exploit_tag e2_ ON t0_.id = e2_.tag_id LEFT JOIN exploit e1_ ON e1_.id = e2_.exploit_id HAVING e1_.id >= 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 31)
7	App\Repository\Exploit\TagRepository->getTagsWithExploits (line 55)
8	App\Controller\ExploitController->exploits (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 460)
13	Symfony\Component\HttpKernel\HttpCache\HttpCache->forward (line 68)
14	Symfony\Bundle\FrameworkBundle\HttpCache\HttpCache->forward (line 437)
15	Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch (line 335)
16	Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup (line 213)
17	Symfony\Component\HttpKernel\HttpCache\HttpCache->handle (line 173)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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\Exploit\Exploit	125
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Exploit\Exploit	No errors.
App\Entity\Rsi\Ship\Ship	No errors.
App\Entity\Exploit\Tag	No errors.
App\Entity\Rsi\Ship\Manufacturer	No errors.
App\Entity\Member\Member	No errors.
App\Entity\User	No errors.
App\Entity\Location	No errors.

Symfony Profiler

GET https://preprod.initiative-omega.fr/exploits

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping