Symfony Profiler

Query Metrics

117 Database Queries

13 Different statements

335.82 ms Query time

0 Invalid entities

816 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

95.65 ms
(28.48%)

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?))) AND u0_.category IN ('USER', 'VIDEOGRAPHER')

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  (
    EXISTS (
      SELECT
        1
      FROM
        user_game u1_
      WHERE
        u1_.user_id = u0_.id
        AND u1_.web_site_id IN (?)
    )
  )
  AND u0_.category IN ('USER', 'VIDEOGRAPHER')

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (1))) AND u0_.category IN ('USER', 'VIDEOGRAPHER');

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 89)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerG5jHOJY\PaginatorProxyBa079e5->paginate (line 20)
15	App\Service\Filter\PlayerListService->getItems (line 49)
16	App\Controller\PlayerController->list (line 24)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
19	Symfony\Component\HttpKernel\Kernel->handle (line 205)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

89.04 ms
(26.51%)

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id WHERE c0_.displayed = 1 AND c0_.slug IS NOT NULL AND c0_.current_price IS NOT NULL AND c0_.cardnexus_current_price IS NOT NULL AND c0_.website_id = ? AND c0_.cardnexus_current_price < c0_.current_price

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
WHERE
  c0_.displayed = 1
  AND c0_.slug IS NOT NULL
  AND c0_.current_price IS NOT NULL
  AND c0_.cardnexus_current_price IS NOT NULL
  AND c0_.website_id = ?
  AND c0_.cardnexus_current_price < c0_.current_price

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id WHERE c0_.displayed = 1 AND c0_.slug IS NOT NULL AND c0_.current_price IS NOT NULL AND c0_.cardnexus_current_price IS NOT NULL AND c0_.website_id = 1 AND c0_.cardnexus_current_price < c0_.current_price;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\CardRepository->findNbCardnexusBestDeals (line 1776)
8	App\Service\Deals\DealsService->hasDeals (line 18)
9	Twig\Extension\CoreExtension->getAttribute (line 1996)
10	__TwigTemplate_e2b63b6c02924c21da1eda0306a816e9::doDisplay (line 247)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 168)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
15	Twig\Template->yield (line 461)
16	Twig\Template->display (line 416)
17	Twig\Template->render (line 431)
18	Twig\TemplateWrapper->render (line 53)
19	Twig\Environment->render (line 343)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\PlayerController->list (line 20)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
26	Symfony\Component\HttpKernel\Kernel->handle (line 205)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
28	require_once (line 32)
29	require_once (line 5)

52.10 ms
(15.51%)

SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = ? ORDER BY t0.finish_date DESC

Parameters:

[
  9932
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.score AS score_2,
  t0.completion AS completion_3,
  t0.finished AS finished_4,
  t0.finish_date AS finish_date_5,
  t0.notified AS notified_6,
  t0.achievement_id AS achievement_id_7,
  t0.user_id AS user_id_8
FROM
  achievement_user t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.finish_date DESC

SELECT t0.id AS id_1, t0.score AS score_2, t0.completion AS completion_3, t0.finished AS finished_4, t0.finish_date AS finish_date_5, t0.notified AS notified_6, t0.achievement_id AS achievement_id_7, t0.user_id AS user_id_8 FROM achievement_user t0 WHERE t0.user_id = 9932 ORDER BY t0.finish_date DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
7	App\Entity\User->getNbUnlockedAchievements (line 733)
8	App\Model\Item\UserItemBuilder->buildInfos (line 73)
9	App\Model\Item\ItemDirector->constructItem (line 36)
10	App\Twig\ItemRuntime->getItemData (line 135)
11	App\Twig\ItemRuntime->displayItem (line 51)
12	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_56cf0463043669960a4e4e16329e3632->block_body (line 191)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
21	Twig\Template->yield (line 461)
22	Twig\Template->display (line 416)
23	Twig\Template->render (line 431)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Environment->render (line 343)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\PlayerController->list (line 20)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
32	Symfony\Component\HttpKernel\Kernel->handle (line 205)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 5)

30.52 ms
(9.09%)

SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = ? AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  deck d0_
WHERE
  d0_.creator_id = ?
  AND d0_.private = 0
  AND d0_.invalid = 0
  AND d0_.deleted = 0
  AND d0_.website_id = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM deck d0_ WHERE d0_.creator_id = 9932 AND d0_.private = 0 AND d0_.invalid = 0 AND d0_.deleted = 0 AND d0_.website_id = 1;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\DeckRepository->findNbDecksOfUser (line 233)
8	App\Model\Item\UserItemBuilder->buildInfos (line 63)
9	App\Model\Item\ItemDirector->constructItem (line 36)
10	App\Twig\ItemRuntime->getItemData (line 135)
11	App\Twig\ItemRuntime->displayItem (line 51)
12	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_56cf0463043669960a4e4e16329e3632->block_body (line 191)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
21	Twig\Template->yield (line 461)
22	Twig\Template->display (line 416)
23	Twig\Template->render (line 431)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Environment->render (line 343)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\PlayerController->list (line 20)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
32	Symfony\Component\HttpKernel\Kernel->handle (line 205)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 5)

30.32 ms
(9.03%)

SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = ? AND t0.website_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.owner_id AS owner_id_1,
  t0.avatar_id AS avatar_id_2,
  t0.website_id AS website_id_3
FROM
  avatar_web_site t0
WHERE
  t0.owner_id = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.owner_id AS owner_id_1, t0.avatar_id AS avatar_id_2, t0.website_id AS website_id_3 FROM avatar_web_site t0 WHERE t0.owner_id = 9932 AND t0.website_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
4	App\Model\Item\UserItemBuilder->buildImage (line 41)
5	App\Model\Item\ItemDirector->constructItem (line 35)
6	App\Twig\ItemRuntime->getItemData (line 135)
7	App\Twig\ItemRuntime->displayItem (line 51)
8	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
9	Twig\Template->yield (line 461)
10	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_56cf0463043669960a4e4e16329e3632->block_body (line 191)
13	Twig\Template->yieldBlock (line 493)
14	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
17	Twig\Template->yield (line 461)
18	Twig\Template->display (line 416)
19	Twig\Template->render (line 431)
20	Twig\TemplateWrapper->render (line 53)
21	Twig\Environment->render (line 343)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\PlayerController->list (line 20)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
28	Symfony\Component\HttpKernel\Kernel->handle (line 205)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

12.06 ms
(3.59%)

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.play_id AS play_id_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.reset_password_link AS reset_password_link_6, u0_.last_login_date AS last_login_date_7, u0_.facebook_id AS facebook_id_8, u0_.facebook_access_token AS facebook_access_token_9, u0_.google_id AS google_id_10, u0_.discord_id AS discord_id_11, u0_.seller_name AS seller_name_12, u0_.achievements_points AS achievements_points_13, u0_.nb_logins AS nb_logins_14, u0_.nb_logins_in_arow AS nb_logins_in_arow_15, u0_.max_logins_in_arow AS max_logins_in_arow_16, u0_.capsule_count AS capsule_count_17, u0_.api_id AS api_id_18, u0_.credits AS credits_19, u0_.cardnexus_mail AS cardnexus_mail_20, u0_.creation_date AS creation_date_21, u0_.update_date AS update_date_22, u0_.youtube_channel AS youtube_channel_23, u0_.category AS category_24, u0_.avatar_id AS avatar_id_25, u0_.data_player_id AS data_player_id_26, u0_.country_id AS country_id_27, u0_.department_id AS department_id_28, u0_.website_id AS website_id_29 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?)) AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.pseudo AS pseudo_2,
  u0_.play_id AS play_id_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.reset_password_link AS reset_password_link_6,
  u0_.last_login_date AS last_login_date_7,
  u0_.facebook_id AS facebook_id_8,
  u0_.facebook_access_token AS facebook_access_token_9,
  u0_.google_id AS google_id_10,
  u0_.discord_id AS discord_id_11,
  u0_.seller_name AS seller_name_12,
  u0_.achievements_points AS achievements_points_13,
  u0_.nb_logins AS nb_logins_14,
  u0_.nb_logins_in_arow AS nb_logins_in_arow_15,
  u0_.max_logins_in_arow AS max_logins_in_arow_16,
  u0_.capsule_count AS capsule_count_17,
  u0_.api_id AS api_id_18,
  u0_.credits AS credits_19,
  u0_.cardnexus_mail AS cardnexus_mail_20,
  u0_.creation_date AS creation_date_21,
  u0_.update_date AS update_date_22,
  u0_.youtube_channel AS youtube_channel_23,
  u0_.category AS category_24,
  u0_.avatar_id AS avatar_id_25,
  u0_.data_player_id AS data_player_id_26,
  u0_.country_id AS country_id_27,
  u0_.department_id AS department_id_28,
  u0_.website_id AS website_id_29
FROM
  user u0_
WHERE
  (
    EXISTS (
      SELECT
        1
      FROM
        user_game u1_
      WHERE
        u1_.user_id = u0_.id
        AND u1_.web_site_id IN (?)
    )
    AND u0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
    )
  )
  AND u0_.category IN ('USER', 'VIDEOGRAPHER')
ORDER BY
  u0_.pseudo ASC

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.pseudo AS pseudo_2, u0_.play_id AS play_id_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.reset_password_link AS reset_password_link_6, u0_.last_login_date AS last_login_date_7, u0_.facebook_id AS facebook_id_8, u0_.facebook_access_token AS facebook_access_token_9, u0_.google_id AS google_id_10, u0_.discord_id AS discord_id_11, u0_.seller_name AS seller_name_12, u0_.achievements_points AS achievements_points_13, u0_.nb_logins AS nb_logins_14, u0_.nb_logins_in_arow AS nb_logins_in_arow_15, u0_.max_logins_in_arow AS max_logins_in_arow_16, u0_.capsule_count AS capsule_count_17, u0_.api_id AS api_id_18, u0_.credits AS credits_19, u0_.cardnexus_mail AS cardnexus_mail_20, u0_.creation_date AS creation_date_21, u0_.update_date AS update_date_22, u0_.youtube_channel AS youtube_channel_23, u0_.category AS category_24, u0_.avatar_id AS avatar_id_25, u0_.data_player_id AS data_player_id_26, u0_.country_id AS country_id_27, u0_.department_id AS department_id_28, u0_.website_id AS website_id_29 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (1)) AND u0_.id IN (9932, 3491, 8738, 12760, 4125, 8599, 12102, 5971, 4006, 17567, 14026, 12065, 19991, 16811, 3262, 13611, 11628, 6377, 2428, 1, 8651, 4352, 4067, 11663, 6444, 12981, 6202, 15350, 6295, 9766)) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo 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	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 172)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Knp\Component\Pager\Paginator->paginate (line 97)
15	ContainerG5jHOJY\PaginatorProxyBa079e5->paginate (line 20)
16	App\Service\Filter\PlayerListService->getItems (line 49)
17	App\Controller\PlayerController->list (line 24)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
20	Symfony\Component\HttpKernel\Kernel->handle (line 205)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

9.38 ms
(2.79%)

SELECT DISTINCT u0_.id AS id_0, u0_.pseudo AS pseudo_1 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (?))) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo ASC LIMIT 30

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.pseudo AS pseudo_1
FROM
  user u0_
WHERE
  (
    EXISTS (
      SELECT
        1
      FROM
        user_game u1_
      WHERE
        u1_.user_id = u0_.id
        AND u1_.web_site_id IN (?)
    )
  )
  AND u0_.category IN ('USER', 'VIDEOGRAPHER')
ORDER BY
  u0_.pseudo ASC
LIMIT
  30

SELECT DISTINCT u0_.id AS id_0, u0_.pseudo AS pseudo_1 FROM user u0_ WHERE (EXISTS (SELECT 1 FROM user_game u1_ WHERE u1_.user_id = u0_.id AND u1_.web_site_id IN (1))) AND u0_.category IN ('USER', 'VIDEOGRAPHER') ORDER BY u0_.pseudo ASC LIMIT 30;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 154)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Knp\Component\Pager\Paginator->paginate (line 97)
15	ContainerG5jHOJY\PaginatorProxyBa079e5->paginate (line 20)
16	App\Service\Filter\PlayerListService->getItems (line 49)
17	App\Controller\PlayerController->list (line 24)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
20	Symfony\Component\HttpKernel\Kernel->handle (line 205)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	require_once (line 5)

8.13 ms
(2.42%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = ?

Parameters:

[
  59
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3,
  t0.path AS path_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.country_id AS country_id_7,
  t0.region_id AS region_id_8
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.path AS path_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7, t0.region_id AS region_id_8 FROM department t0 WHERE t0.id = 59;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\Map\Department::getDisplayedName (line 180)
5	App\Model\Item\UserItemBuilder->buildInfos (line 59)
6	App\Model\Item\ItemDirector->constructItem (line 36)
7	App\Twig\ItemRuntime->getItemData (line 135)
8	App\Twig\ItemRuntime->displayItem (line 51)
9	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_56cf0463043669960a4e4e16329e3632->block_body (line 191)
14	Twig\Template->yieldBlock (line 493)
15	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
18	Twig\Template->yield (line 461)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\PlayerController->list (line 20)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
29	Symfony\Component\HttpKernel\Kernel->handle (line 205)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

4.90 ms
(1.46%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = ?

Parameters:

[
  30
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unlocked AS unlocked_3,
  t0.slug AS slug_4,
  t0.slug_en AS slug_en_5,
  t0.displayed AS displayed_6,
  t0.rarity_id AS rarity_id_7,
  t0.groupment_id AS groupment_id_8,
  t0.website_id AS website_id_9
FROM
  avatar t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unlocked AS unlocked_3, t0.slug AS slug_4, t0.slug_en AS slug_en_5, t0.displayed AS displayed_6, t0.rarity_id AS rarity_id_7, t0.groupment_id AS groupment_id_8, t0.website_id AS website_id_9 FROM avatar t0 WHERE t0.id = 30;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():259} (line 265)
4	App\Entity\Avatar\Avatar::getSlug (line 20)
5	App\Model\Item\UserItemBuilder->buildImage (line 44)
6	App\Model\Item\ItemDirector->constructItem (line 35)
7	App\Twig\ItemRuntime->getItemData (line 135)
8	App\Twig\ItemRuntime->displayItem (line 51)
9	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_56cf0463043669960a4e4e16329e3632->block_body (line 191)
14	Twig\Template->yieldBlock (line 493)
15	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
18	Twig\Template->yield (line 461)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\PlayerController->list (line 20)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
29	Symfony\Component\HttpKernel\Kernel->handle (line 205)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
31	require_once (line 32)
32	require_once (line 5)

1.19 ms
(0.35%)

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.name_vo AS name_vo_3, c0_.french AS french_4, c0_.view_box AS view_box_5, c0_.department_label AS department_label_6, c0_.displayed AS displayed_7 FROM country c0_ WHERE c0_.displayed = 1 ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name AS name_2,
  c0_.name_vo AS name_vo_3,
  c0_.french AS french_4,
  c0_.view_box AS view_box_5,
  c0_.department_label AS department_label_6,
  c0_.displayed AS displayed_7
FROM
  country c0_
WHERE
  c0_.displayed = 1
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.name_vo AS name_vo_3, c0_.french AS french_4, c0_.view_box AS view_box_5, c0_.department_label AS department_label_6, c0_.displayed AS displayed_7 FROM country c0_ WHERE c0_.displayed = 1 ORDER BY c0_.name 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\PlayerController->list (line 22)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
23	Symfony\Component\HttpKernel\Kernel->handle (line 205)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
25	require_once (line 32)
26	require_once (line 5)

1.03 ms
(0.31%)

SELECT t0.id AS id_1, t0.max_same_cards AS max_same_cards_2, t0.leader AS leader_3, t0.start_hand_length AS start_hand_length_4, t0.leader_first AS leader_first_5, t0.mulligan AS mulligan_6, t0.nb_max_cards AS nb_max_cards_7, t0.default_deck_area_id AS default_deck_area_id_8, t0.website_id AS website_id_9 FROM deckbuilder t0 WHERE t0.website_id = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.max_same_cards AS max_same_cards_2,
  t0.leader AS leader_3,
  t0.start_hand_length AS start_hand_length_4,
  t0.leader_first AS leader_first_5,
  t0.mulligan AS mulligan_6,
  t0.nb_max_cards AS nb_max_cards_7,
  t0.default_deck_area_id AS default_deck_area_id_8,
  t0.website_id AS website_id_9
FROM
  deckbuilder t0
WHERE
  t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.max_same_cards AS max_same_cards_2, t0.leader AS leader_3, t0.start_hand_length AS start_hand_length_4, t0.leader_first AS leader_first_5, t0.mulligan AS mulligan_6, t0.nb_max_cards AS nb_max_cards_7, t0.default_deck_area_id AS default_deck_area_id_8, t0.website_id AS website_id_9 FROM deckbuilder t0 WHERE t0.website_id = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
4	App\Service\Decks\DeckBuilderService->__construct (line 63)
5	ContainerG5jHOJY\getDeckBuilderServiceService->do (line 44)
6	ContainerG5jHOJY\App_KernelDevDebugContainer::load (line 745)
7	ContainerG5jHOJY\getCardRepositoryService->do (line 44)
8	ContainerG5jHOJY\App_KernelDevDebugContainer::load (line 745)
9	Symfony\Component\DependencyInjection\Container->getService (line 403)
10	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 36)
11	Doctrine\Bundle\DoctrineBundle\Repository\ContainerRepositoryFactory->getRepository (line 56)
12	Doctrine\ORM\EntityManager->getRepository (line 520)
13	App\Service\Deals\DealsService->hasDeals (line 18)
14	Twig\Extension\CoreExtension->getAttribute (line 1996)
15	__TwigTemplate_e2b63b6c02924c21da1eda0306a816e9::doDisplay (line 247)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 168)
18	Twig\Template->yield (line 461)
19	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
20	Twig\Template->yield (line 461)
21	Twig\Template->display (line 416)
22	Twig\Template->render (line 431)
23	Twig\TemplateWrapper->render (line 53)
24	Twig\Environment->render (line 343)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\PlayerController->list (line 20)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
31	Symfony\Component\HttpKernel\Kernel->handle (line 205)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
33	require_once (line 32)
34	require_once (line 5)

0.83 ms
(0.25%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.extended_name AS extended_name_4, t0.domain AS domain_5, t0.item_image_prefix AS item_image_prefix_6, t0.image_prefix AS image_prefix_7, t0.image_enprefix AS image_enprefix_8, t0.facebook AS facebook_9, t0.discord AS discord_10, t0.instagram AS instagram_11, t0.decks AS decks_12, t0.wishlists AS wishlists_13, t0.achievements AS achievements_14, t0.blog AS blog_15, t0.shops AS shops_16, t0.ranking AS ranking_17, t0.rules AS rules_18, t0.videos AS videos_19, t0.eras AS eras_20, t0.characters AS characters_21, t0.grading AS grading_22, t0.year AS year_23, t0.game AS game_24, t0.game_condensed AS game_condensed_25, t0.static_folder AS static_folder_26, t0.untap_ccg_type AS untap_ccg_type_27, t0.rarity_iconable AS rarity_iconable_28, t0.description AS description_29, t0.cardmarket_game_id AS cardmarket_game_id_30, t0.cardnexus_game_key AS cardnexus_game_key_31, t0.displayed AS displayed_32, t0.sort_order AS sort_order_33, t0.default_language_id AS default_language_id_34, t0.form_filters_id AS form_filters_id_35 FROM web_site t0 WHERE t0.reference = ? LIMIT 1

Parameters:

[
  "dbscards"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.extended_name AS extended_name_4,
  t0.domain AS domain_5,
  t0.item_image_prefix AS item_image_prefix_6,
  t0.image_prefix AS image_prefix_7,
  t0.image_enprefix AS image_enprefix_8,
  t0.facebook AS facebook_9,
  t0.discord AS discord_10,
  t0.instagram AS instagram_11,
  t0.decks AS decks_12,
  t0.wishlists AS wishlists_13,
  t0.achievements AS achievements_14,
  t0.blog AS blog_15,
  t0.shops AS shops_16,
  t0.ranking AS ranking_17,
  t0.rules AS rules_18,
  t0.videos AS videos_19,
  t0.eras AS eras_20,
  t0.characters AS characters_21,
  t0.grading AS grading_22,
  t0.year AS year_23,
  t0.game AS game_24,
  t0.game_condensed AS game_condensed_25,
  t0.static_folder AS static_folder_26,
  t0.untap_ccg_type AS untap_ccg_type_27,
  t0.rarity_iconable AS rarity_iconable_28,
  t0.description AS description_29,
  t0.cardmarket_game_id AS cardmarket_game_id_30,
  t0.cardnexus_game_key AS cardnexus_game_key_31,
  t0.displayed AS displayed_32,
  t0.sort_order AS sort_order_33,
  t0.default_language_id AS default_language_id_34,
  t0.form_filters_id AS form_filters_id_35
FROM
  web_site t0
WHERE
  t0.reference = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.extended_name AS extended_name_4, t0.domain AS domain_5, t0.item_image_prefix AS item_image_prefix_6, t0.image_prefix AS image_prefix_7, t0.image_enprefix AS image_enprefix_8, t0.facebook AS facebook_9, t0.discord AS discord_10, t0.instagram AS instagram_11, t0.decks AS decks_12, t0.wishlists AS wishlists_13, t0.achievements AS achievements_14, t0.blog AS blog_15, t0.shops AS shops_16, t0.ranking AS ranking_17, t0.rules AS rules_18, t0.videos AS videos_19, t0.eras AS eras_20, t0.characters AS characters_21, t0.grading AS grading_22, t0.year AS year_23, t0.game AS game_24, t0.game_condensed AS game_condensed_25, t0.static_folder AS static_folder_26, t0.untap_ccg_type AS untap_ccg_type_27, t0.rarity_iconable AS rarity_iconable_28, t0.description AS description_29, t0.cardmarket_game_id AS cardmarket_game_id_30, t0.cardnexus_game_key AS cardnexus_game_key_31, t0.displayed AS displayed_32, t0.sort_order AS sort_order_33, t0.default_language_id AS default_language_id_34, t0.form_filters_id AS form_filters_id_35 FROM web_site t0 WHERE t0.reference = 'dbscards' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
4	App\Service\WebSiteManager->getCurrentWebSite (line 37)
5	App\Service\ListItem\ListItemService->hydrateFilterModel (line 59)
6	App\Service\Filter\PlayerListService->initFilter (line 15)
7	App\Controller\PlayerController->list (line 18)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.68 ms
(0.20%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.sort_order AS sort_order_4 FROM language t0 INNER JOIN web_site_language ON t0.id = web_site_language.language_id WHERE web_site_language.web_site_id = ? ORDER BY t0.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.name AS name_3,
  t0.sort_order AS sort_order_4
FROM
  language t0
  INNER JOIN web_site_language ON t0.id = web_site_language.language_id
WHERE
  web_site_language.web_site_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.sort_order AS sort_order_4 FROM language t0 INNER JOIN web_site_language ON t0.id = web_site_language.language_id WHERE web_site_language.web_site_id = 1 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 34)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_e2b63b6c02924c21da1eda0306a816e9::doDisplay (line 299)
10	Twig\Template->yield (line 461)
11	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 168)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_56cf0463043669960a4e4e16329e3632->doDisplay (line 62)
14	Twig\Template->yield (line 461)
15	Twig\Template->display (line 416)
16	Twig\Template->render (line 431)
17	Twig\TemplateWrapper->render (line 53)
18	Twig\Environment->render (line 343)
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\Controller\PlayerController->list (line 20)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
25	Symfony\Component\HttpKernel\Kernel->handle (line 205)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Achievement\AchievementUser	658
App\Entity\Achievement\Achievement	76
App\Entity\User	30
App\Entity\Map\Department	11
App\Entity\Avatar\Avatar	10
App\Entity\Avatar\AvatarWebSite	9
App\Entity\Map\Region	6
App\Entity\WebSite	4
App\Entity\Map\Country	3
App\Entity\Language	2
App\Entity\Shop\ShopTournamentPlayer	2
App\Entity\Avatar\AvatarRarity	2
App\Entity\Settings\FormFilter	1
App\Entity\Deckbuilder\Deckbuilder	1
App\Entity\Deckbuilder\DeckArea	1

Entities Mapping

Class	Mapping errors
App\Entity\WebSite	No errors.
App\Entity\Language	No errors.
App\Entity\Settings\FormFilter	No errors.
App\Entity\User	No errors.
App\Entity\Support\Ticket	No errors.
App\Entity\Map\Country	No errors.
App\Entity\Map\Department	No errors.
App\Entity\Shop\Shop	No errors.
App\Entity\Map\Region	No errors.
App\Entity\Video\Videographer	No errors.
App\Entity\Avatar\Avatar	No errors.
App\Entity\Shop\ShopTournamentPlayer	No errors.
App\Entity\Wishlist	No errors.
App\Entity\Deck	No errors.
App\Entity\CardOwned	No errors.
App\Entity\Product\ProductOwned	No errors.
App\Entity\Partnership\CardmarketClick	No errors.
App\Entity\Achievement\AchievementUser	No errors.
App\Entity\Avatar\AvatarUser	No errors.
App\Entity\User\UserLogin	No errors.
App\Entity\User\CapsuleMovement	No errors.
App\Entity\Partnership\GoupiyaClick	No errors.
App\Entity\Search\UserSearch	No errors.
App\Entity\User\CardSale	No errors.
App\Entity\User\UserSettings	No errors.
App\Entity\User\UserTutorial	No errors.
App\Entity\Video\VideoReview	No errors.
App\Entity\User\Friend\Request	No errors.
App\Entity\User\LeagueStats	No errors.
App\Entity\Card	No errors.
App\Entity\Deckbuilder\Deckbuilder	No errors.
App\Entity\Deckbuilder\DeckArea	No errors.
App\Entity\Deckbuilder\DeckBuilderSkill	No errors.
App\Entity\Serie	No errors.
App\Entity\Avatar\AvatarWebSite	No errors.
App\Entity\Avatar\AvatarRarity	No errors.
App\Entity\Avatar\AvatarGroup	No errors.
App\Entity\Achievement\Achievement	No errors.

Symfony Profiler

GET https://dev.tcgcards.fr/players

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping