Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.78 ms Query time

0 Invalid entities

72 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.25 ms
(59.49%)

SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.enabled AS enabled_9, c0_.order_id AS order_id_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.icon AS icon_14, c1_.activity_count AS activity_count_15, c1_.name_de AS name_de_16, c1_.name_en AS name_en_17, c1_.name_tr AS name_tr_18, c1_.name_ru AS name_ru_19, c1_.name_uk AS name_uk_20, c1_.slug AS slug_21, c1_.enabled AS enabled_22, c1_.order_id AS order_id_23, c1_.created_at AS created_at_24, c1_.updated_at AS updated_at_25, c0_.parent_id AS parent_id_26, c0_.user_id AS user_id_27, c1_.parent_id AS parent_id_28, c1_.user_id AS user_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.enabled = 1 AND (c1_.enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.icon AS icon_1,
  c0_.activity_count AS activity_count_2,
  c0_.name_de AS name_de_3,
  c0_.name_en AS name_en_4,
  c0_.name_tr AS name_tr_5,
  c0_.name_ru AS name_ru_6,
  c0_.name_uk AS name_uk_7,
  c0_.slug AS slug_8,
  c0_.enabled AS enabled_9,
  c0_.order_id AS order_id_10,
  c0_.created_at AS created_at_11,
  c0_.updated_at AS updated_at_12,
  c1_.id AS id_13,
  c1_.icon AS icon_14,
  c1_.activity_count AS activity_count_15,
  c1_.name_de AS name_de_16,
  c1_.name_en AS name_en_17,
  c1_.name_tr AS name_tr_18,
  c1_.name_ru AS name_ru_19,
  c1_.name_uk AS name_uk_20,
  c1_.slug AS slug_21,
  c1_.enabled AS enabled_22,
  c1_.order_id AS order_id_23,
  c1_.created_at AS created_at_24,
  c1_.updated_at AS updated_at_25,
  c0_.parent_id AS parent_id_26,
  c0_.user_id AS user_id_27,
  c1_.parent_id AS parent_id_28,
  c1_.user_id AS user_id_29
FROM
  category c0_
  LEFT JOIN category c1_ ON c0_.id = c1_.parent_id
WHERE
  c0_.parent_id IS NULL
  AND c0_.enabled = 1
  AND (
    c1_.enabled = 1
    OR c1_.id IS NULL
  )
ORDER BY
  c0_.order_id ASC,
  c1_.order_id ASC

SELECT c0_.id AS id_0, c0_.icon AS icon_1, c0_.activity_count AS activity_count_2, c0_.name_de AS name_de_3, c0_.name_en AS name_en_4, c0_.name_tr AS name_tr_5, c0_.name_ru AS name_ru_6, c0_.name_uk AS name_uk_7, c0_.slug AS slug_8, c0_.enabled AS enabled_9, c0_.order_id AS order_id_10, c0_.created_at AS created_at_11, c0_.updated_at AS updated_at_12, c1_.id AS id_13, c1_.icon AS icon_14, c1_.activity_count AS activity_count_15, c1_.name_de AS name_de_16, c1_.name_en AS name_en_17, c1_.name_tr AS name_tr_18, c1_.name_ru AS name_ru_19, c1_.name_uk AS name_uk_20, c1_.slug AS slug_21, c1_.enabled AS enabled_22, c1_.order_id AS order_id_23, c1_.created_at AS created_at_24, c1_.updated_at AS updated_at_25, c0_.parent_id AS parent_id_26, c0_.user_id AS user_id_27, c1_.parent_id AS parent_id_28, c1_.user_id AS user_id_29 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.parent_id WHERE c0_.parent_id IS NULL AND c0_.enabled = 1 AND (c1_.enabled = 1 OR c1_.id IS NULL) ORDER BY c0_.order_id ASC, c1_.order_id 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 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findRootCategories (line 31)
7	App\Controller\PageController->homepageAction (line 36)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.92 ms
(24.28%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.category_id AS category_id_20, a0_.user_id AS user_id_21 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.type AS type_4,
  a0_.latitude AS latitude_5,
  a0_.longitude AS longitude_6,
  a0_.street AS street_7,
  a0_.city AS city_8,
  a0_.postcode AS postcode_9,
  a0_.country AS country_10,
  a0_.google_place_id AS google_place_id_11,
  a0_.url AS url_12,
  a0_.phone_number AS phone_number_13,
  a0_.rating AS rating_14,
  a0_.reviews_count AS reviews_count_15,
  a0_.image AS image_16,
  a0_.order_id AS order_id_17,
  a0_.created_at AS created_at_18,
  a0_.updated_at AS updated_at_19,
  a0_.category_id AS category_id_20,
  a0_.user_id AS user_id_21
FROM
  activity a0_
ORDER BY
  a0_.order_id ASC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.type AS type_4, a0_.latitude AS latitude_5, a0_.longitude AS longitude_6, a0_.street AS street_7, a0_.city AS city_8, a0_.postcode AS postcode_9, a0_.country AS country_10, a0_.google_place_id AS google_place_id_11, a0_.url AS url_12, a0_.phone_number AS phone_number_13, a0_.rating AS rating_14, a0_.reviews_count AS reviews_count_15, a0_.image AS image_16, a0_.order_id AS order_id_17, a0_.created_at AS created_at_18, a0_.updated_at AS updated_at_19, a0_.category_id AS category_id_20, a0_.user_id AS user_id_21 FROM activity a0_ ORDER BY a0_.order_id ASC LIMIT 20;

#	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\ActivityRepository->findByFilter (line 32)
7	App\Service\ActivityFilterProvider->getActivitiesByFilter (line 37)
8	App\Service\ActivityFilterProvider->getHomepageActivities (line 21)
9	App\Controller\PageController->homepageAction (line 22)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.61 ms
(16.23%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	ReflectionClass::initializeLazyObject (line 111)
5	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 111)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
10	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
12	Symfony\Bridge\Twig\AppVariable->getUser (line 92)
13	Twig\Extension\CoreExtension->getAttribute (line 1922)
14	__TwigTemplate_d1f0d348cd10697618b23495a391f534::doDisplay (line 163)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_0cb9c52dd146d11bec5cc80662c92fe2->doDisplay (line 56)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_eaa5f289b4406a1d994a76d867190f21->doDisplay (line 57)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\PageController->homepageAction (line 38)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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\Category	59
App\Entity\Activity	12
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Activity	No errors.
App\Entity\Category	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://kinderhobby.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping