Symfony Profiler

Query Metrics

15 Database Queries

5 Different statements

4.18 ms Query time

0 Invalid entities

150 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

2.83 ms
(67.66%)

SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = ? ORDER BY t0.sort_order ASC, t0.endpoint_name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.endpoint_id AS endpoint_id_2,
  t0.route_name AS route_name_3,
  t0.route_path AS route_path_4,
  t0.route_controller AS route_controller_5,
  t0.tecdoc_sql_name AS tecdoc_sql_name_6,
  t0.method AS method_7,
  t0.description AS description_8,
  t0.long_description AS long_description_9,
  t0.deprecated AS deprecated_10,
  t0.version AS version_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.endpoint_name AS endpoint_name_14,
  t0.active AS active_15,
  t0.param_media_type AS param_media_type_16,
  t0.sort_order AS sort_order_17,
  t0.track_usage AS track_usage_18,
  t0.endpoint_group_id AS endpoint_group_id_19
FROM
  endpoint t0
WHERE
  t0.endpoint_group_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.endpoint_name ASC

SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_group_id = 1 ORDER BY t0.sort_order ASC, t0.endpoint_name 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->getIterator (line 315)
7	__TwigTemplate_efbbe7dd5254f7a55db9ea1fd304d602->doDisplay (line 63)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
16	App\Playground\Controller\PlaygroundController->renderEndpointGroups (line 52)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
20	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
21	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
22	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
23	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
24	__TwigTemplate_16deb48df4ed89fb8a00b0f360b4dfda->doDisplay (line 108)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Extension\CoreExtension->include (line 1526)
30	__TwigTemplate_affefa7d4bf58e9a3da6c1822d974b26::block_body (line 133)
31	Twig\Template->yieldBlock (line 446)
32	__TwigTemplate_a074d4db815f8f802d1c25489e993409->doDisplay (line 88)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_affefa7d4bf58e9a3da6c1822d974b26->doDisplay (line 55)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
43	App\Playground\Controller\PlaygroundController->index (line 133)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 193)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 32)
49	require_once (line 5)

0.61 ms
(14.53%)

SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "API-GAR-004-V2"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.endpoint_id AS endpoint_id_2,
  t0.route_name AS route_name_3,
  t0.route_path AS route_path_4,
  t0.route_controller AS route_controller_5,
  t0.tecdoc_sql_name AS tecdoc_sql_name_6,
  t0.method AS method_7,
  t0.description AS description_8,
  t0.long_description AS long_description_9,
  t0.deprecated AS deprecated_10,
  t0.version AS version_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.endpoint_name AS endpoint_name_14,
  t0.active AS active_15,
  t0.param_media_type AS param_media_type_16,
  t0.sort_order AS sort_order_17,
  t0.track_usage AS track_usage_18,
  t0.endpoint_group_id AS endpoint_group_id_19
FROM
  endpoint t0
WHERE
  t0.endpoint_id = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.endpoint_id AS endpoint_id_2, t0.route_name AS route_name_3, t0.route_path AS route_path_4, t0.route_controller AS route_controller_5, t0.tecdoc_sql_name AS tecdoc_sql_name_6, t0.method AS method_7, t0.description AS description_8, t0.long_description AS long_description_9, t0.deprecated AS deprecated_10, t0.version AS version_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.endpoint_name AS endpoint_name_14, t0.active AS active_15, t0.param_media_type AS param_media_type_16, t0.sort_order AS sort_order_17, t0.track_usage AS track_usage_18, t0.endpoint_group_id AS endpoint_group_id_19 FROM endpoint t0 WHERE t0.endpoint_id = 'API-GAR-004-V2' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Playground\Controller\PlaygroundController->index (line 103)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.30 ms
(7.06%)

SELECT t0.id AS id_1, t0.param_name AS param_name_2, t0.param_type AS param_type_3, t0.param_value AS param_value_4, t0.is_required AS is_required_5, t0.param_description AS param_description_6, t0.param_location AS param_location_7, t0.endpoint_id AS endpoint_id_8 FROM endpoint_params t0 WHERE t0.endpoint_id = ?

Parameters:

[
  108
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.param_name AS param_name_2,
  t0.param_type AS param_type_3,
  t0.param_value AS param_value_4,
  t0.is_required AS is_required_5,
  t0.param_description AS param_description_6,
  t0.param_location AS param_location_7,
  t0.endpoint_id AS endpoint_id_8
FROM
  endpoint_params t0
WHERE
  t0.endpoint_id = ?

SELECT t0.id AS id_1, t0.param_name AS param_name_2, t0.param_type AS param_type_3, t0.param_value AS param_value_4, t0.is_required AS is_required_5, t0.param_description AS param_description_6, t0.param_location AS param_location_7, t0.endpoint_id AS endpoint_id_8 FROM endpoint_params t0 WHERE t0.endpoint_id = 108;

#	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->getIterator (line 315)
7	App\Playground\Service\EndpointCodeSampleGenerator->generate (line 43)
8	App\Playground\Controller\PlaygroundController->index (line 124)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.23 ms
(5.39%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.sort_order AS sort_order_3 FROM endpoint_group t0 ORDER BY t0.sort_order ASC, t0.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.sort_order AS sort_order_3
FROM
  endpoint_group t0
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.sort_order AS sort_order_3 FROM endpoint_group t0 ORDER BY t0.sort_order ASC, t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Playground\Controller\PlaygroundController->renderEndpointGroups (line 39)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_16deb48df4ed89fb8a00b0f360b4dfda->doDisplay (line 108)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Extension\CoreExtension->include (line 1526)
18	__TwigTemplate_affefa7d4bf58e9a3da6c1822d974b26::block_body (line 133)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_a074d4db815f8f802d1c25489e993409->doDisplay (line 88)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_affefa7d4bf58e9a3da6c1822d974b26->doDisplay (line 55)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Playground\Controller\PlaygroundController->index (line 133)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

0.22 ms
(5.36%)

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.endpoint_id AS endpoint_id_4 FROM endpoint_comments t0 WHERE t0.endpoint_id = ?

Parameters:

[
  108
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.created_at AS created_at_3,
  t0.endpoint_id AS endpoint_id_4
FROM
  endpoint_comments t0
WHERE
  t0.endpoint_id = ?

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.endpoint_id AS endpoint_id_4 FROM endpoint_comments t0 WHERE t0.endpoint_id = 108;

#	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_affefa7d4bf58e9a3da6c1822d974b26::block_body (line 315)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_a074d4db815f8f802d1c25489e993409->doDisplay (line 88)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_affefa7d4bf58e9a3da6c1822d974b26->doDisplay (line 55)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Playground\Controller\PlaygroundController->index (line 133)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
tecdoc	doctrine.dbal.tecdoc_connection
tecdoc2026q2	doctrine.dbal.tecdoc2026q2_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\Endpoint	137
App\Entity\EndpointGroup	10
App\Entity\EndpointParams	3

Entities Mapping

Class	Mapping errors
App\Entity\Endpoint	No errors.
App\Entity\EndpointGroup	No errors.
App\Entity\EndpointComments	No errors.
App\Entity\EndpointParams	No errors.

Symfony Profiler

GET https://manea0104.go.ro/playground/API-GAR-004-V2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping