Symfony Profiler

Query Metrics

36 Database Queries

32 Different statements

420.55 ms Query time

0 Invalid entities

785 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

92.53 ms
(22.00%)

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_4a2f2b2227ad8844c077c32bb531ddb7->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\SerieController->view (line 136)
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)

70.42 ms
(16.74%)

SELECT DISTINCT c0_.id AS id_0, c0_.end_of_serie AS end_of_serie_1, s1_.release_date AS release_date_2, s1_.reference AS reference_3, c0_.number AS number_4, r2_.sort_order AS sort_order_5, c0_.serial_number AS serial_number_6, c0_.version_number AS version_number_7, c0_.reprint_category AS reprint_category_8 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = ? AND (c0_.serie_id = ? OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (?))) AND c0_.lang = ? AND c0_.reprint = 0 ORDER BY c0_.end_of_serie ASC, s1_.release_date ASC, s1_.reference DESC, c0_.number ASC, r2_.sort_order ASC, c0_.serial_number ASC, c0_.version_number ASC, c0_.reprint_category ASC LIMIT 30

Parameters:

[
  1
  76
  76
  "FR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.end_of_serie AS end_of_serie_1,
  s1_.release_date AS release_date_2,
  s1_.reference AS reference_3,
  c0_.number AS number_4,
  r2_.sort_order AS sort_order_5,
  c0_.serial_number AS serial_number_6,
  c0_.version_number AS version_number_7,
  c0_.reprint_category AS reprint_category_8
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
  INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id
WHERE
  c0_.displayed = 1
  AND s1_.displayed = 1
  AND s1_.release_date IS NOT NULL
  AND c0_.slug IS NOT NULL
  AND c0_.website_id = ?
  AND (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c3_
      WHERE
        c3_.card_id = c0_.id
        AND c3_.serie_id IN (?)
    )
  )
  AND c0_.lang = ?
  AND c0_.reprint = 0
ORDER BY
  c0_.end_of_serie ASC,
  s1_.release_date ASC,
  s1_.reference DESC,
  c0_.number ASC,
  r2_.sort_order ASC,
  c0_.serial_number ASC,
  c0_.version_number ASC,
  c0_.reprint_category ASC
LIMIT
  30

SELECT DISTINCT c0_.id AS id_0, c0_.end_of_serie AS end_of_serie_1, s1_.release_date AS release_date_2, s1_.reference AS reference_3, c0_.number AS number_4, r2_.sort_order AS sort_order_5, c0_.serial_number AS serial_number_6, c0_.version_number AS version_number_7, c0_.reprint_category AS reprint_category_8 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = 1 AND (c0_.serie_id = 76 OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (76))) AND c0_.lang = 'FR' AND c0_.reprint = 0 ORDER BY c0_.end_of_serie ASC, s1_.release_date ASC, s1_.reference DESC, c0_.number ASC, r2_.sort_order ASC, c0_.serial_number ASC, c0_.version_number ASC, c0_.reprint_category 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\CardListService->getItems (line 98)
17	App\Controller\SerieController->view (line 144)
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)

63.40 ms
(15.08%)

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = ? AND (c0_.serie_id = ? OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (?))) AND c0_.lang = ? AND c0_.reprint = 0

Parameters:

[
  1
  76
  76
  "FR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
  INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id
WHERE
  c0_.displayed = 1
  AND s1_.displayed = 1
  AND s1_.release_date IS NOT NULL
  AND c0_.slug IS NOT NULL
  AND c0_.website_id = ?
  AND (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c3_
      WHERE
        c3_.card_id = c0_.id
        AND c3_.serie_id IN (?)
    )
  )
  AND c0_.lang = ?
  AND c0_.reprint = 0

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = 1 AND (c0_.serie_id = 76 OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (76))) AND c0_.lang = 'FR' AND c0_.reprint = 0;

#	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\CardListService->getItems (line 98)
16	App\Controller\SerieController->view (line 144)
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)

61.63 ms
(14.65%)

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ WHERE (c0_.serie_id = ? OR EXISTS (SELECT 1 FROM card_additional_serie c1_ WHERE c1_.card_id = c0_.id AND c1_.serie_id IN (?))) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 AND c0_.reprint = 0 AND c0_.lang = ?

Parameters:

[
  76
  76
  "FR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  card c0_
WHERE
  (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c1_
      WHERE
        c1_.card_id = c0_.id
        AND c1_.serie_id IN (?)
    )
  )
  AND c0_.slug IS NOT NULL
  AND c0_.displayed = 1
  AND c0_.reprint = 0
  AND c0_.lang = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM card c0_ WHERE (c0_.serie_id = 76 OR EXISTS (SELECT 1 FROM card_additional_serie c1_ WHERE c1_.card_id = c0_.id AND c1_.serie_id IN (76))) AND c0_.slug IS NOT NULL AND c0_.displayed = 1 AND c0_.reprint = 0 AND c0_.lang = 'FR';

#	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->getNbCardsInSerieWithoutReprint (line 1082)
8	App\Controller\SerieController->view (line 116)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
11	Symfony\Component\HttpKernel\Kernel->handle (line 205)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
13	require_once (line 32)
14	require_once (line 5)

54.54 ms
(12.97%)

SELECT DISTINCT (c0_.secondary_cost) AS sclr_0 FROM card c0_ WHERE c0_.secondary_cost IS NOT NULL AND c0_.website_id = ? ORDER BY c0_.secondary_cost ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT (c0_.secondary_cost) AS sclr_0
FROM
  card c0_
WHERE
  c0_.secondary_cost IS NOT NULL
  AND c0_.website_id = ?
ORDER BY
  c0_.secondary_cost ASC

SELECT DISTINCT (c0_.secondary_cost) AS sclr_0 FROM card c0_ WHERE c0_.secondary_cost IS NOT NULL AND c0_.website_id = 1 ORDER BY c0_.secondary_cost 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\CardRepository->findAllSecondaryCosts (line 1286)
7	App\Form\Type\Range\SecondaryCostType->configureOptions (line 27)
8	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 138)
9	Symfony\Component\Form\ResolvedFormType->createBuilder (line 77)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 72)
12	Symfony\Component\Form\FormBuilder->create (line 80)
13	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
14	Symfony\Component\Form\FormBuilder->getForm (line 160)
15	Symfony\Component\Form\FormFactory->create (line 37)
16	App\Service\Filter\CardListService->initForm (line 79)
17	App\Service\Filter\CardListService->initFilter (line 24)
18	App\Controller\SerieController->view (line 122)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
21	Symfony\Component\HttpKernel\Kernel->handle (line 205)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

53.45 ms
(12.71%)

SELECT DISTINCT (c0_.front_energy_cost) AS sclr_0 FROM card c0_ WHERE c0_.front_energy_cost IS NOT NULL AND c0_.website_id = ? ORDER BY c0_.front_energy_cost ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT (c0_.front_energy_cost) AS sclr_0
FROM
  card c0_
WHERE
  c0_.front_energy_cost IS NOT NULL
  AND c0_.website_id = ?
ORDER BY
  c0_.front_energy_cost ASC

SELECT DISTINCT (c0_.front_energy_cost) AS sclr_0 FROM card c0_ WHERE c0_.front_energy_cost IS NOT NULL AND c0_.website_id = 1 ORDER BY c0_.front_energy_cost 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\CardRepository->findAllEnergyCosts (line 1274)
7	App\Form\Type\Range\EnergyCostType->configureOptions (line 25)
8	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 138)
9	Symfony\Component\Form\ResolvedFormType->createBuilder (line 77)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 72)
12	Symfony\Component\Form\FormBuilder->create (line 80)
13	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
14	Symfony\Component\Form\FormBuilder->getForm (line 160)
15	Symfony\Component\Form\FormFactory->create (line 37)
16	App\Service\Filter\CardListService->initForm (line 79)
17	App\Service\Filter\CardListService->initFilter (line 24)
18	App\Controller\SerieController->view (line 122)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
21	Symfony\Component\HttpKernel\Kernel->handle (line 205)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

3.36 ms
(0.80%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.slug = ? AND t0.website_id = ? LIMIT 1

Parameters:

[
  "tk-jeton-token"
  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.name_en AS name_en_4,
  t0.description AS description_5,
  t0.total_price AS total_price_6,
  t0.list_ready AS list_ready_7,
  t0.timeline_excluded AS timeline_excluded_8,
  t0.creation_date AS creation_date_9,
  t0.update_date AS update_date_10,
  t0.displayed AS displayed_11,
  t0.slug AS slug_12,
  t0.slug_en AS slug_en_13,
  t0.lang AS lang_14,
  t0.release_date AS release_date_15,
  t0.cmid AS cmid_16,
  t0.url AS url_17,
  t0.image AS image_18,
  t0.current_price AS current_price_19,
  t0.yesterday_price AS yesterday_price_20,
  t0.last_price_update AS last_price_update_21,
  t0.cardnexus_id AS cardnexus_id_22,
  t0.cardnexus_current_price AS cardnexus_current_price_23,
  t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24,
  t0.cardnexus_last_price_update AS cardnexus_last_price_update_25,
  t0.type_id AS type_id_26,
  t0.website_id AS website_id_27
FROM
  serie t0
WHERE
  t0.slug = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.slug = 'tk-jeton-token' 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\Service\Breadcrumb\BreadcrumbBuilder->build (line 63)
5	Twig\Extension\CoreExtension->getAttribute (line 1996)
6	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519::block_breadcrumb (line 480)
7	Twig\Template->yieldBlock (line 493)
8	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 180)
9	Twig\Template->yield (line 461)
10	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7->doDisplay (line 62)
11	Twig\Template->yield (line 461)
12	Twig\Template->display (line 416)
13	Twig\Template->render (line 431)
14	Twig\TemplateWrapper->render (line 53)
15	Twig\Environment->render (line 343)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
19	App\Controller\SerieController->view (line 136)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
22	Symfony\Component\HttpKernel\Kernel->handle (line 205)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
24	require_once (line 32)
25	require_once (line 5)

2.00 ms
(0.47%)

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.total_price AS total_price_5, s0_.list_ready AS list_ready_6, s0_.timeline_excluded AS timeline_excluded_7, s0_.creation_date AS creation_date_8, s0_.update_date AS update_date_9, s0_.displayed AS displayed_10, s0_.slug AS slug_11, s0_.slug_en AS slug_en_12, s0_.lang AS lang_13, s0_.release_date AS release_date_14, s0_.cmid AS cmid_15, s0_.url AS url_16, s0_.image AS image_17, s0_.current_price AS current_price_18, s0_.yesterday_price AS yesterday_price_19, s0_.last_price_update AS last_price_update_20, s0_.cardnexus_id AS cardnexus_id_21, s0_.cardnexus_current_price AS cardnexus_current_price_22, s0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_23, s0_.cardnexus_last_price_update AS cardnexus_last_price_update_24, s0_.type_id AS type_id_25, s0_.website_id AS website_id_26 FROM serie s0_ WHERE s0_.displayed = 1 AND s0_.website_id = ? ORDER BY s0_.lang DESC, s0_.release_date DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.name AS name_2,
  s0_.name_en AS name_en_3,
  s0_.description AS description_4,
  s0_.total_price AS total_price_5,
  s0_.list_ready AS list_ready_6,
  s0_.timeline_excluded AS timeline_excluded_7,
  s0_.creation_date AS creation_date_8,
  s0_.update_date AS update_date_9,
  s0_.displayed AS displayed_10,
  s0_.slug AS slug_11,
  s0_.slug_en AS slug_en_12,
  s0_.lang AS lang_13,
  s0_.release_date AS release_date_14,
  s0_.cmid AS cmid_15,
  s0_.url AS url_16,
  s0_.image AS image_17,
  s0_.current_price AS current_price_18,
  s0_.yesterday_price AS yesterday_price_19,
  s0_.last_price_update AS last_price_update_20,
  s0_.cardnexus_id AS cardnexus_id_21,
  s0_.cardnexus_current_price AS cardnexus_current_price_22,
  s0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_23,
  s0_.cardnexus_last_price_update AS cardnexus_last_price_update_24,
  s0_.type_id AS type_id_25,
  s0_.website_id AS website_id_26
FROM
  serie s0_
WHERE
  s0_.displayed = 1
  AND s0_.website_id = ?
ORDER BY
  s0_.lang DESC,
  s0_.release_date DESC

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.description AS description_4, s0_.total_price AS total_price_5, s0_.list_ready AS list_ready_6, s0_.timeline_excluded AS timeline_excluded_7, s0_.creation_date AS creation_date_8, s0_.update_date AS update_date_9, s0_.displayed AS displayed_10, s0_.slug AS slug_11, s0_.slug_en AS slug_en_12, s0_.lang AS lang_13, s0_.release_date AS release_date_14, s0_.cmid AS cmid_15, s0_.url AS url_16, s0_.image AS image_17, s0_.current_price AS current_price_18, s0_.yesterday_price AS yesterday_price_19, s0_.last_price_update AS last_price_update_20, s0_.cardnexus_id AS cardnexus_id_21, s0_.cardnexus_current_price AS cardnexus_current_price_22, s0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_23, s0_.cardnexus_last_price_update AS cardnexus_last_price_update_24, s0_.type_id AS type_id_25, s0_.website_id AS website_id_26 FROM serie s0_ WHERE s0_.displayed = 1 AND s0_.website_id = 1 ORDER BY s0_.lang DESC, s0_.release_date DESC;

#	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\SerieController->view (line 142)
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.83 ms
(0.43%)

SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, s1_.id AS id_77, s1_.reference AS reference_78, s1_.name AS name_79, s1_.name_en AS name_en_80, s1_.description AS description_81, s1_.total_price AS total_price_82, s1_.list_ready AS list_ready_83, s1_.timeline_excluded AS timeline_excluded_84, s1_.creation_date AS creation_date_85, s1_.update_date AS update_date_86, s1_.displayed AS displayed_87, s1_.slug AS slug_88, s1_.slug_en AS slug_en_89, s1_.lang AS lang_90, s1_.release_date AS release_date_91, s1_.cmid AS cmid_92, s1_.url AS url_93, s1_.image AS image_94, s1_.current_price AS current_price_95, s1_.yesterday_price AS yesterday_price_96, s1_.last_price_update AS last_price_update_97, s1_.cardnexus_id AS cardnexus_id_98, s1_.cardnexus_current_price AS cardnexus_current_price_99, s1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_100, s1_.cardnexus_last_price_update AS cardnexus_last_price_update_101, r2_.id AS id_102, r2_.reference AS reference_103, r2_.name AS name_104, r2_.name_en AS name_en_105, r2_.sort_order AS sort_order_106, r2_.special AS special_107, r2_.displayed AS displayed_108, c0_.front_era_id AS front_era_id_109, c0_.back_era_id AS back_era_id_110, c0_.type_id AS type_id_111, c0_.serie_id AS serie_id_112, c0_.rarity_id AS rarity_id_113, c0_.group_version_id AS group_version_id_114, c0_.avatar_id AS avatar_id_115, c0_.version_id AS version_id_116, c0_.auto_play_id AS auto_play_id_117, c0_.version_annotation_id AS version_annotation_id_118, c0_.website_id AS website_id_119, s1_.type_id AS type_id_120, s1_.website_id AS website_id_121, r2_.website_id AS website_id_122 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = ? AND (c0_.serie_id = ? OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (?))) AND c0_.lang = ? AND c0_.reprint = 0 AND c0_.id IN (?, ?, ?, ?, ?) ORDER BY c0_.end_of_serie ASC, s1_.release_date ASC, s1_.reference DESC, c0_.number ASC, r2_.sort_order ASC, c0_.serial_number ASC, c0_.version_number ASC, c0_.reprint_category ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.number AS number_1,
  c0_.serial_number AS serial_number_2,
  c0_.front_name AS front_name_3,
  c0_.front_description AS front_description_4,
  c0_.front_energy_cost AS front_energy_cost_5,
  c0_.secondary_cost AS secondary_cost_6,
  c0_.front_energy_cost_alias AS front_energy_cost_alias_7,
  c0_.front_energy_color_cost AS front_energy_color_cost_8,
  c0_.back_energy_color_cost AS back_energy_color_cost_9,
  c0_.front_combo_cost AS front_combo_cost_10,
  c0_.front_combo_power AS front_combo_power_11,
  c0_.front_power AS front_power_12,
  c0_.front_defense AS front_defense_13,
  c0_.back_name AS back_name_14,
  c0_.back_description AS back_description_15,
  c0_.back_power AS back_power_16,
  c0_.back_power2 AS back_power2_17,
  c0_.back_defense AS back_defense_18,
  c0_.back_defense2 AS back_defense2_19,
  c0_.img_ready AS img_ready_20,
  c0_.image_ready AS image_ready_21,
  c0_.multicolor AS multicolor_22,
  c0_.limited AS limited_23,
  c0_.banned AS banned_24,
  c0_.unlimited_in_deck AS unlimited_in_deck_25,
  c0_.limitation_in_deck AS limitation_in_deck_26,
  c0_.reprint AS reprint_27,
  c0_.foil AS foil_28,
  c0_.reprint_category AS reprint_category_29,
  c0_.animated AS animated_30,
  c0_.version_number AS version_number_31,
  c0_.front_name_alias AS front_name_alias_32,
  c0_.front_name_en AS front_name_en_33,
  c0_.back_name_en AS back_name_en_34,
  c0_.front_description_en AS front_description_en_35,
  c0_.back_description_en AS back_description_en_36,
  c0_.english_only AS english_only_37,
  c0_.redirect_english_slug AS redirect_english_slug_38,
  c0_.position_serie_list AS position_serie_list_39,
  c0_.lore AS lore_40,
  c0_.subname AS subname_41,
  c0_.illustrator AS illustrator_42,
  c0_.energyzable AS energyzable_43,
  c0_.weakness AS weakness_44,
  c0_.resistance AS resistance_45,
  c0_.sub_description AS sub_description_46,
  c0_.exclusive AS exclusive_47,
  c0_.end_of_serie AS end_of_serie_48,
  c0_.verso AS verso_49,
  c0_.additional_data AS additional_data_50,
  c0_.ocr_keywords_count AS ocr_keywords_count_51,
  c0_.beta AS beta_52,
  c0_.level AS level_53,
  c0_.price_alert AS price_alert_54,
  c0_.creation_date AS creation_date_55,
  c0_.update_date AS update_date_56,
  c0_.displayed AS displayed_57,
  c0_.slug AS slug_58,
  c0_.slug_en AS slug_en_59,
  c0_.view_count AS view_count_60,
  c0_.cmid AS cmid_61,
  c0_.url AS url_62,
  c0_.image AS image_63,
  c0_.current_price AS current_price_64,
  c0_.yesterday_price AS yesterday_price_65,
  c0_.last_price_update AS last_price_update_66,
  c0_.cardnexus_id AS cardnexus_id_67,
  c0_.cardnexus_current_price AS cardnexus_current_price_68,
  c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69,
  c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70,
  c0_.lang AS lang_71,
  c0_.release_date AS release_date_72,
  c0_.complete AS complete_73,
  c0_.bandai_tcgid AS bandai_tcgid_74,
  c0_.checked AS checked_75,
  c0_.indexable AS indexable_76,
  s1_.id AS id_77,
  s1_.reference AS reference_78,
  s1_.name AS name_79,
  s1_.name_en AS name_en_80,
  s1_.description AS description_81,
  s1_.total_price AS total_price_82,
  s1_.list_ready AS list_ready_83,
  s1_.timeline_excluded AS timeline_excluded_84,
  s1_.creation_date AS creation_date_85,
  s1_.update_date AS update_date_86,
  s1_.displayed AS displayed_87,
  s1_.slug AS slug_88,
  s1_.slug_en AS slug_en_89,
  s1_.lang AS lang_90,
  s1_.release_date AS release_date_91,
  s1_.cmid AS cmid_92,
  s1_.url AS url_93,
  s1_.image AS image_94,
  s1_.current_price AS current_price_95,
  s1_.yesterday_price AS yesterday_price_96,
  s1_.last_price_update AS last_price_update_97,
  s1_.cardnexus_id AS cardnexus_id_98,
  s1_.cardnexus_current_price AS cardnexus_current_price_99,
  s1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_100,
  s1_.cardnexus_last_price_update AS cardnexus_last_price_update_101,
  r2_.id AS id_102,
  r2_.reference AS reference_103,
  r2_.name AS name_104,
  r2_.name_en AS name_en_105,
  r2_.sort_order AS sort_order_106,
  r2_.special AS special_107,
  r2_.displayed AS displayed_108,
  c0_.front_era_id AS front_era_id_109,
  c0_.back_era_id AS back_era_id_110,
  c0_.type_id AS type_id_111,
  c0_.serie_id AS serie_id_112,
  c0_.rarity_id AS rarity_id_113,
  c0_.group_version_id AS group_version_id_114,
  c0_.avatar_id AS avatar_id_115,
  c0_.version_id AS version_id_116,
  c0_.auto_play_id AS auto_play_id_117,
  c0_.version_annotation_id AS version_annotation_id_118,
  c0_.website_id AS website_id_119,
  s1_.type_id AS type_id_120,
  s1_.website_id AS website_id_121,
  r2_.website_id AS website_id_122
FROM
  card c0_
  INNER JOIN serie s1_ ON c0_.serie_id = s1_.id
  INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id
WHERE
  c0_.displayed = 1
  AND s1_.displayed = 1
  AND s1_.release_date IS NOT NULL
  AND c0_.slug IS NOT NULL
  AND c0_.website_id = ?
  AND (
    c0_.serie_id = ?
    OR EXISTS (
      SELECT
        1
      FROM
        card_additional_serie c3_
      WHERE
        c3_.card_id = c0_.id
        AND c3_.serie_id IN (?)
    )
  )
  AND c0_.lang = ?
  AND c0_.reprint = 0
  AND c0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  c0_.end_of_serie ASC,
  s1_.release_date ASC,
  s1_.reference DESC,
  c0_.number ASC,
  r2_.sort_order ASC,
  c0_.serial_number ASC,
  c0_.version_number ASC,
  c0_.reprint_category ASC

SELECT c0_.id AS id_0, c0_.number AS number_1, c0_.serial_number AS serial_number_2, c0_.front_name AS front_name_3, c0_.front_description AS front_description_4, c0_.front_energy_cost AS front_energy_cost_5, c0_.secondary_cost AS secondary_cost_6, c0_.front_energy_cost_alias AS front_energy_cost_alias_7, c0_.front_energy_color_cost AS front_energy_color_cost_8, c0_.back_energy_color_cost AS back_energy_color_cost_9, c0_.front_combo_cost AS front_combo_cost_10, c0_.front_combo_power AS front_combo_power_11, c0_.front_power AS front_power_12, c0_.front_defense AS front_defense_13, c0_.back_name AS back_name_14, c0_.back_description AS back_description_15, c0_.back_power AS back_power_16, c0_.back_power2 AS back_power2_17, c0_.back_defense AS back_defense_18, c0_.back_defense2 AS back_defense2_19, c0_.img_ready AS img_ready_20, c0_.image_ready AS image_ready_21, c0_.multicolor AS multicolor_22, c0_.limited AS limited_23, c0_.banned AS banned_24, c0_.unlimited_in_deck AS unlimited_in_deck_25, c0_.limitation_in_deck AS limitation_in_deck_26, c0_.reprint AS reprint_27, c0_.foil AS foil_28, c0_.reprint_category AS reprint_category_29, c0_.animated AS animated_30, c0_.version_number AS version_number_31, c0_.front_name_alias AS front_name_alias_32, c0_.front_name_en AS front_name_en_33, c0_.back_name_en AS back_name_en_34, c0_.front_description_en AS front_description_en_35, c0_.back_description_en AS back_description_en_36, c0_.english_only AS english_only_37, c0_.redirect_english_slug AS redirect_english_slug_38, c0_.position_serie_list AS position_serie_list_39, c0_.lore AS lore_40, c0_.subname AS subname_41, c0_.illustrator AS illustrator_42, c0_.energyzable AS energyzable_43, c0_.weakness AS weakness_44, c0_.resistance AS resistance_45, c0_.sub_description AS sub_description_46, c0_.exclusive AS exclusive_47, c0_.end_of_serie AS end_of_serie_48, c0_.verso AS verso_49, c0_.additional_data AS additional_data_50, c0_.ocr_keywords_count AS ocr_keywords_count_51, c0_.beta AS beta_52, c0_.level AS level_53, c0_.price_alert AS price_alert_54, c0_.creation_date AS creation_date_55, c0_.update_date AS update_date_56, c0_.displayed AS displayed_57, c0_.slug AS slug_58, c0_.slug_en AS slug_en_59, c0_.view_count AS view_count_60, c0_.cmid AS cmid_61, c0_.url AS url_62, c0_.image AS image_63, c0_.current_price AS current_price_64, c0_.yesterday_price AS yesterday_price_65, c0_.last_price_update AS last_price_update_66, c0_.cardnexus_id AS cardnexus_id_67, c0_.cardnexus_current_price AS cardnexus_current_price_68, c0_.cardnexus_yesterday_price AS cardnexus_yesterday_price_69, c0_.cardnexus_last_price_update AS cardnexus_last_price_update_70, c0_.lang AS lang_71, c0_.release_date AS release_date_72, c0_.complete AS complete_73, c0_.bandai_tcgid AS bandai_tcgid_74, c0_.checked AS checked_75, c0_.indexable AS indexable_76, s1_.id AS id_77, s1_.reference AS reference_78, s1_.name AS name_79, s1_.name_en AS name_en_80, s1_.description AS description_81, s1_.total_price AS total_price_82, s1_.list_ready AS list_ready_83, s1_.timeline_excluded AS timeline_excluded_84, s1_.creation_date AS creation_date_85, s1_.update_date AS update_date_86, s1_.displayed AS displayed_87, s1_.slug AS slug_88, s1_.slug_en AS slug_en_89, s1_.lang AS lang_90, s1_.release_date AS release_date_91, s1_.cmid AS cmid_92, s1_.url AS url_93, s1_.image AS image_94, s1_.current_price AS current_price_95, s1_.yesterday_price AS yesterday_price_96, s1_.last_price_update AS last_price_update_97, s1_.cardnexus_id AS cardnexus_id_98, s1_.cardnexus_current_price AS cardnexus_current_price_99, s1_.cardnexus_yesterday_price AS cardnexus_yesterday_price_100, s1_.cardnexus_last_price_update AS cardnexus_last_price_update_101, r2_.id AS id_102, r2_.reference AS reference_103, r2_.name AS name_104, r2_.name_en AS name_en_105, r2_.sort_order AS sort_order_106, r2_.special AS special_107, r2_.displayed AS displayed_108, c0_.front_era_id AS front_era_id_109, c0_.back_era_id AS back_era_id_110, c0_.type_id AS type_id_111, c0_.serie_id AS serie_id_112, c0_.rarity_id AS rarity_id_113, c0_.group_version_id AS group_version_id_114, c0_.avatar_id AS avatar_id_115, c0_.version_id AS version_id_116, c0_.auto_play_id AS auto_play_id_117, c0_.version_annotation_id AS version_annotation_id_118, c0_.website_id AS website_id_119, s1_.type_id AS type_id_120, s1_.website_id AS website_id_121, r2_.website_id AS website_id_122 FROM card c0_ INNER JOIN serie s1_ ON c0_.serie_id = s1_.id INNER JOIN rarity r2_ ON c0_.rarity_id = r2_.id WHERE c0_.displayed = 1 AND s1_.displayed = 1 AND s1_.release_date IS NOT NULL AND c0_.slug IS NOT NULL AND c0_.website_id = 1 AND (c0_.serie_id = 76 OR EXISTS (SELECT 1 FROM card_additional_serie c3_ WHERE c3_.card_id = c0_.id AND c3_.serie_id IN (76))) AND c0_.lang = 'FR' AND c0_.reprint = 0 AND c0_.id IN (5230, 5231, 5229, 5232, 5233) ORDER BY c0_.end_of_serie ASC, s1_.release_date ASC, s1_.reference DESC, c0_.number ASC, r2_.sort_order ASC, c0_.serial_number ASC, c0_.version_number ASC, c0_.reprint_category 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\CardListService->getItems (line 98)
17	App\Controller\SerieController->view (line 144)
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)

1.32 ms
(0.31%)

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.name_jp AS name_jp_4, s0_.color AS color_5, s0_.description AS description_6, s0_.keyword AS keyword_7, s0_.bandai_tcgtext AS bandai_tcgtext_8, s0_.bandai_tcgtext_en AS bandai_tcgtext_en_9, s0_.displayed AS displayed_10, s0_.parent_id AS parent_id_11, s0_.website_id AS website_id_12 FROM skill s0_ WHERE s0_.displayed = 1 AND s0_.website_id = ? ORDER BY s0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.name AS name_2,
  s0_.name_en AS name_en_3,
  s0_.name_jp AS name_jp_4,
  s0_.color AS color_5,
  s0_.description AS description_6,
  s0_.keyword AS keyword_7,
  s0_.bandai_tcgtext AS bandai_tcgtext_8,
  s0_.bandai_tcgtext_en AS bandai_tcgtext_en_9,
  s0_.displayed AS displayed_10,
  s0_.parent_id AS parent_id_11,
  s0_.website_id AS website_id_12
FROM
  skill s0_
WHERE
  s0_.displayed = 1
  AND s0_.website_id = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.name_en AS name_en_3, s0_.name_jp AS name_jp_4, s0_.color AS color_5, s0_.description AS description_6, s0_.keyword AS keyword_7, s0_.bandai_tcgtext AS bandai_tcgtext_8, s0_.bandai_tcgtext_en AS bandai_tcgtext_en_9, s0_.displayed AS displayed_10, s0_.parent_id AS parent_id_11, s0_.website_id AS website_id_12 FROM skill s0_ WHERE s0_.displayed = 1 AND s0_.website_id = 1 ORDER BY s0_.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	Symfony\Component\Form\Form->createView (line 895)
21	App\Controller\SerieController->view (line 142)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
24	Symfony\Component\HttpKernel\Kernel->handle (line 205)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

1.24 ms
(0.30%)

SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = ? AND t0.user_id IS NULL LIMIT 1

Parameters:

[
  5230
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.quantity AS quantity_1,
  t0.card_id AS card_id_2,
  t0.user_id AS user_id_3
FROM
  card_owned t0
WHERE
  t0.card_id = ?
  AND t0.user_id IS NULL
LIMIT
  1

SELECT t0.quantity AS quantity_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM card_owned t0 WHERE t0.card_id = 5230 AND t0.user_id IS NULL 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\CardItemBuilder->buildGlobal (line 33)
5	App\Model\Item\ItemDirector->constructItem (line 33)
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_4a2f2b2227ad8844c077c32bb531ddb7->block_body (line 351)
13	Twig\Template->yieldBlock (line 493)
14	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7->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\SerieController->view (line 136)
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)

1.14 ms
(0.27%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.website_id = ? AND t0.slug = ? LIMIT 1

Parameters:

[
  1
  "tk-jeton-token"
]

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.name_en AS name_en_4,
  t0.description AS description_5,
  t0.total_price AS total_price_6,
  t0.list_ready AS list_ready_7,
  t0.timeline_excluded AS timeline_excluded_8,
  t0.creation_date AS creation_date_9,
  t0.update_date AS update_date_10,
  t0.displayed AS displayed_11,
  t0.slug AS slug_12,
  t0.slug_en AS slug_en_13,
  t0.lang AS lang_14,
  t0.release_date AS release_date_15,
  t0.cmid AS cmid_16,
  t0.url AS url_17,
  t0.image AS image_18,
  t0.current_price AS current_price_19,
  t0.yesterday_price AS yesterday_price_20,
  t0.last_price_update AS last_price_update_21,
  t0.cardnexus_id AS cardnexus_id_22,
  t0.cardnexus_current_price AS cardnexus_current_price_23,
  t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24,
  t0.cardnexus_last_price_update AS cardnexus_last_price_update_25,
  t0.type_id AS type_id_26,
  t0.website_id AS website_id_27
FROM
  serie t0
WHERE
  t0.website_id = ?
  AND t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.description AS description_5, t0.total_price AS total_price_6, t0.list_ready AS list_ready_7, t0.timeline_excluded AS timeline_excluded_8, t0.creation_date AS creation_date_9, t0.update_date AS update_date_10, t0.displayed AS displayed_11, t0.slug AS slug_12, t0.slug_en AS slug_en_13, t0.lang AS lang_14, t0.release_date AS release_date_15, t0.cmid AS cmid_16, t0.url AS url_17, t0.image AS image_18, t0.current_price AS current_price_19, t0.yesterday_price AS yesterday_price_20, t0.last_price_update AS last_price_update_21, t0.cardnexus_id AS cardnexus_id_22, t0.cardnexus_current_price AS cardnexus_current_price_23, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_24, t0.cardnexus_last_price_update AS cardnexus_last_price_update_25, t0.type_id AS type_id_26, t0.website_id AS website_id_27 FROM serie t0 WHERE t0.website_id = 1 AND t0.slug = 'tk-jeton-token' 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\Controller\SerieController->view (line 110)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
7	Symfony\Component\HttpKernel\Kernel->handle (line 205)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

1.13 ms
(0.27%)

SELECT t0.number AS number_1, t0.sort_order AS sort_order_2, t0.serie_id AS serie_id_3, t0.rarity_id AS rarity_id_4 FROM serie_rarity t0 WHERE t0.serie_id = ? ORDER BY t0.sort_order ASC

Parameters:

[
  76
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.number AS number_1,
  t0.sort_order AS sort_order_2,
  t0.serie_id AS serie_id_3,
  t0.rarity_id AS rarity_id_4
FROM
  serie_rarity t0
WHERE
  t0.serie_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.number AS number_1, t0.sort_order AS sort_order_2, t0.serie_id AS serie_id_3, t0.rarity_id AS rarity_id_4 FROM serie_rarity t0 WHERE t0.serie_id = 76 ORDER BY t0.sort_order ASC;

#	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->count (line 34)
7	Doctrine\ORM\PersistentCollection->count (line 393)
8	Twig\Extension\CoreExtension->length (line 1299)
9	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7::block_illustration (line 181)
10	Twig\Template->yieldBlock (line 493)
11	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 177)
12	Twig\Template->yield (line 461)
13	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7->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\SerieController->view (line 136)
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)

1.11 ms
(0.26%)

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = ?) AND c0_.type IN ('UTILITY') ORDER BY c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('UTILITY')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('UTILITY') 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\SerieController->view (line 142)
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.10 ms
(0.26%)

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_en AS name_en_2, e0_.description AS description_3, e0_.slug AS slug_4, e0_.slug_en AS slug_en_5, e0_.creation_date AS creation_date_6, e0_.update_date AS update_date_7, e0_.website_id AS website_id_8 FROM era e0_ WHERE e0_.website_id = ? ORDER BY e0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.name_en AS name_en_2,
  e0_.description AS description_3,
  e0_.slug AS slug_4,
  e0_.slug_en AS slug_en_5,
  e0_.creation_date AS creation_date_6,
  e0_.update_date AS update_date_7,
  e0_.website_id AS website_id_8
FROM
  era e0_
WHERE
  e0_.website_id = ?
ORDER BY
  e0_.name ASC

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.name_en AS name_en_2, e0_.description AS description_3, e0_.slug AS slug_4, e0_.slug_en AS slug_en_5, e0_.creation_date AS creation_date_6, e0_.update_date AS update_date_7, e0_.website_id AS website_id_8 FROM era e0_ WHERE e0_.website_id = 1 ORDER BY e0_.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\SerieController->view (line 142)
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.00 ms
(0.24%)

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = ?) AND c0_.type IN ('THEME') ORDER BY c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('THEME')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('THEME') 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\SerieController->view (line 142)
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)

0.81 ms
(0.19%)

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = ?) AND c0_.type IN ('COMPLEMENTARITY') ORDER BY c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.description AS description_4,
  c0_.type AS type_5,
  c0_.website_id AS website_id_6
FROM
  card_tag c0_
WHERE
  (c0_.website_id = ?)
  AND c0_.type IN ('COMPLEMENTARITY')
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.description AS description_4, c0_.type AS type_5, c0_.website_id AS website_id_6 FROM card_tag c0_ WHERE (c0_.website_id = 1) AND c0_.type IN ('COMPLEMENTARITY') 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\SerieController->view (line 142)
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)

0.77 ms
(0.18%)

SELECT t0.id AS id_1, t0.color AS color_2, t0.multicolor AS multicolor_3, t0.ink AS ink_4, t0.attribute AS attribute_5, t0.special_trait AS special_trait_6, t0.era AS era_7, t0.sub_type AS sub_type_8, t0.energy_cost AS energy_cost_9, t0.power AS power_10, t0.version AS version_11, t0.theme AS theme_12, t0.serie_type AS serie_type_13, t0.`character` AS character_14, t0.character_label AS character_label_15, t0.character_icon AS character_icon_16, t0.special_trait_label AS special_trait_label_17, t0.special_trait_icon AS special_trait_icon_18, t0.special_trait_priority AS special_trait_priority_19, t0.era_label AS era_label_20, t0.era_icon AS era_icon_21, t0.energy_cost_label AS energy_cost_label_22, t0.energy_cost_icon AS energy_cost_icon_23, t0.timing AS timing_24, t0.attribute_label AS attribute_label_25, t0.attribute_icon AS attribute_icon_26, t0.attribute_img_size AS attribute_img_size_27, t0.sub_type_label AS sub_type_label_28, t0.sub_type_icon AS sub_type_icon_29, t0.defense AS defense_30, t0.defense_label AS defense_label_31, t0.defense_icon AS defense_icon_32, t0.power_label AS power_label_33, t0.power_icon AS power_icon_34, t0.secondary_cost AS secondary_cost_35, t0.secondary_cost_label AS secondary_cost_label_36, t0.secondary_cost_icon AS secondary_cost_icon_37, t0.leader_label AS leader_label_38, t0.skill_label AS skill_label_39, t0.additional_data_label AS additional_data_label_40, t0.additional_data_icon AS additional_data_icon_41, t42.id AS id_43, t42.reference AS reference_44, t42.name AS name_45, t42.extended_name AS extended_name_46, t42.domain AS domain_47, t42.item_image_prefix AS item_image_prefix_48, t42.image_prefix AS image_prefix_49, t42.image_enprefix AS image_enprefix_50, t42.facebook AS facebook_51, t42.discord AS discord_52, t42.instagram AS instagram_53, t42.decks AS decks_54, t42.wishlists AS wishlists_55, t42.achievements AS achievements_56, t42.blog AS blog_57, t42.shops AS shops_58, t42.ranking AS ranking_59, t42.rules AS rules_60, t42.videos AS videos_61, t42.eras AS eras_62, t42.characters AS characters_63, t42.grading AS grading_64, t42.year AS year_65, t42.game AS game_66, t42.game_condensed AS game_condensed_67, t42.static_folder AS static_folder_68, t42.untap_ccg_type AS untap_ccg_type_69, t42.rarity_iconable AS rarity_iconable_70, t42.description AS description_71, t42.cardmarket_game_id AS cardmarket_game_id_72, t42.cardnexus_game_key AS cardnexus_game_key_73, t42.displayed AS displayed_74, t42.sort_order AS sort_order_75, t42.default_language_id AS default_language_id_76, t42.form_filters_id AS form_filters_id_77 FROM form_filter t0 LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.multicolor AS multicolor_3,
  t0.ink AS ink_4,
  t0.attribute AS attribute_5,
  t0.special_trait AS special_trait_6,
  t0.era AS era_7,
  t0.sub_type AS sub_type_8,
  t0.energy_cost AS energy_cost_9,
  t0.power AS power_10,
  t0.version AS version_11,
  t0.theme AS theme_12,
  t0.serie_type AS serie_type_13,
  t0.`character` AS character_14,
  t0.character_label AS character_label_15,
  t0.character_icon AS character_icon_16,
  t0.special_trait_label AS special_trait_label_17,
  t0.special_trait_icon AS special_trait_icon_18,
  t0.special_trait_priority AS special_trait_priority_19,
  t0.era_label AS era_label_20,
  t0.era_icon AS era_icon_21,
  t0.energy_cost_label AS energy_cost_label_22,
  t0.energy_cost_icon AS energy_cost_icon_23,
  t0.timing AS timing_24,
  t0.attribute_label AS attribute_label_25,
  t0.attribute_icon AS attribute_icon_26,
  t0.attribute_img_size AS attribute_img_size_27,
  t0.sub_type_label AS sub_type_label_28,
  t0.sub_type_icon AS sub_type_icon_29,
  t0.defense AS defense_30,
  t0.defense_label AS defense_label_31,
  t0.defense_icon AS defense_icon_32,
  t0.power_label AS power_label_33,
  t0.power_icon AS power_icon_34,
  t0.secondary_cost AS secondary_cost_35,
  t0.secondary_cost_label AS secondary_cost_label_36,
  t0.secondary_cost_icon AS secondary_cost_icon_37,
  t0.leader_label AS leader_label_38,
  t0.skill_label AS skill_label_39,
  t0.additional_data_label AS additional_data_label_40,
  t0.additional_data_icon AS additional_data_icon_41,
  t42.id AS id_43,
  t42.reference AS reference_44,
  t42.name AS name_45,
  t42.extended_name AS extended_name_46,
  t42.domain AS domain_47,
  t42.item_image_prefix AS item_image_prefix_48,
  t42.image_prefix AS image_prefix_49,
  t42.image_enprefix AS image_enprefix_50,
  t42.facebook AS facebook_51,
  t42.discord AS discord_52,
  t42.instagram AS instagram_53,
  t42.decks AS decks_54,
  t42.wishlists AS wishlists_55,
  t42.achievements AS achievements_56,
  t42.blog AS blog_57,
  t42.shops AS shops_58,
  t42.ranking AS ranking_59,
  t42.rules AS rules_60,
  t42.videos AS videos_61,
  t42.eras AS eras_62,
  t42.characters AS characters_63,
  t42.grading AS grading_64,
  t42.year AS year_65,
  t42.game AS game_66,
  t42.game_condensed AS game_condensed_67,
  t42.static_folder AS static_folder_68,
  t42.untap_ccg_type AS untap_ccg_type_69,
  t42.rarity_iconable AS rarity_iconable_70,
  t42.description AS description_71,
  t42.cardmarket_game_id AS cardmarket_game_id_72,
  t42.cardnexus_game_key AS cardnexus_game_key_73,
  t42.displayed AS displayed_74,
  t42.sort_order AS sort_order_75,
  t42.default_language_id AS default_language_id_76,
  t42.form_filters_id AS form_filters_id_77
FROM
  form_filter t0
  LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.multicolor AS multicolor_3, t0.ink AS ink_4, t0.attribute AS attribute_5, t0.special_trait AS special_trait_6, t0.era AS era_7, t0.sub_type AS sub_type_8, t0.energy_cost AS energy_cost_9, t0.power AS power_10, t0.version AS version_11, t0.theme AS theme_12, t0.serie_type AS serie_type_13, t0.`character` AS character_14, t0.character_label AS character_label_15, t0.character_icon AS character_icon_16, t0.special_trait_label AS special_trait_label_17, t0.special_trait_icon AS special_trait_icon_18, t0.special_trait_priority AS special_trait_priority_19, t0.era_label AS era_label_20, t0.era_icon AS era_icon_21, t0.energy_cost_label AS energy_cost_label_22, t0.energy_cost_icon AS energy_cost_icon_23, t0.timing AS timing_24, t0.attribute_label AS attribute_label_25, t0.attribute_icon AS attribute_icon_26, t0.attribute_img_size AS attribute_img_size_27, t0.sub_type_label AS sub_type_label_28, t0.sub_type_icon AS sub_type_icon_29, t0.defense AS defense_30, t0.defense_label AS defense_label_31, t0.defense_icon AS defense_icon_32, t0.power_label AS power_label_33, t0.power_icon AS power_icon_34, t0.secondary_cost AS secondary_cost_35, t0.secondary_cost_label AS secondary_cost_label_36, t0.secondary_cost_icon AS secondary_cost_icon_37, t0.leader_label AS leader_label_38, t0.skill_label AS skill_label_39, t0.additional_data_label AS additional_data_label_40, t0.additional_data_icon AS additional_data_icon_41, t42.id AS id_43, t42.reference AS reference_44, t42.name AS name_45, t42.extended_name AS extended_name_46, t42.domain AS domain_47, t42.item_image_prefix AS item_image_prefix_48, t42.image_prefix AS image_prefix_49, t42.image_enprefix AS image_enprefix_50, t42.facebook AS facebook_51, t42.discord AS discord_52, t42.instagram AS instagram_53, t42.decks AS decks_54, t42.wishlists AS wishlists_55, t42.achievements AS achievements_56, t42.blog AS blog_57, t42.shops AS shops_58, t42.ranking AS ranking_59, t42.rules AS rules_60, t42.videos AS videos_61, t42.eras AS eras_62, t42.characters AS characters_63, t42.grading AS grading_64, t42.year AS year_65, t42.game AS game_66, t42.game_condensed AS game_condensed_67, t42.static_folder AS static_folder_68, t42.untap_ccg_type AS untap_ccg_type_69, t42.rarity_iconable AS rarity_iconable_70, t42.description AS description_71, t42.cardmarket_game_id AS cardmarket_game_id_72, t42.cardnexus_game_key AS cardnexus_game_key_73, t42.displayed AS displayed_74, t42.sort_order AS sort_order_75, t42.default_language_id AS default_language_id_76, t42.form_filters_id AS form_filters_id_77 FROM form_filter t0 LEFT JOIN web_site t42 ON t42.form_filters_id = t0.id WHERE t0.id = 1;

#	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\Settings\FormFilter::isSubType (line 221)
5	App\Form\FilterType\CardFilterType->buildForm (line 88)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
9	Symfony\Component\Form\FormFactory->createBuilder (line 58)
10	Symfony\Component\Form\FormFactory->create (line 37)
11	App\Service\Filter\CardListService->initForm (line 79)
12	App\Service\Filter\CardListService->initFilter (line 24)
13	App\Controller\SerieController->view (line 122)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
16	Symfony\Component\HttpKernel\Kernel->handle (line 205)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.76 ms
(0.18%)

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_4a2f2b2227ad8844c077c32bb531ddb7->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\SerieController->view (line 136)
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)

0.74 ms
(0.18%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.website_id AS website_id_3 FROM special_trait s0_ WHERE s0_.website_id = ? ORDER BY s0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_en AS name_en_2,
  s0_.website_id AS website_id_3
FROM
  special_trait s0_
WHERE
  s0_.website_id = ?
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_en AS name_en_2, s0_.website_id AS website_id_3 FROM special_trait s0_ WHERE s0_.website_id = 1 ORDER BY s0_.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\SerieController->view (line 142)
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)

0.67 ms
(0.16%)

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 WHERE t0.id = ?

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
WHERE
  t0.id = ?

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 WHERE t0.id = 1;

#	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	ReflectionClass::initializeLazyObject (line 3296)
5	Doctrine\ORM\UnitOfWork->initializeObject (line 3296)
6	Doctrine\ORM\EntityManager->initializeObject (line 587)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 89)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->{closure:Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader::loadValuesForChoices():49} (line 49)
9	array_map (line 49)
10	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader::loadValuesForChoices (line 49)
11	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 81)
12	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 32)
13	Symfony\Component\Form\Form->normToView (line 984)
14	Symfony\Component\Form\Form->setData (line 299)
15	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 50)
16	Symfony\Component\Form\Form->setData (line 321)
17	Symfony\Component\Form\Form->initialize (line 410)
18	Symfony\Component\Form\FormBuilder->getForm (line 171)
19	Symfony\Component\Form\FormFactory->create (line 37)
20	App\Service\Filter\CardListService->initForm (line 79)
21	App\Service\Filter\CardListService->initFilter (line 24)
22	App\Controller\SerieController->view (line 122)
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)

0.64 ms
(0.15%)

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 WHERE t0.reference = ? LIMIT 1

Parameters:

[
  "FR"
]

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
WHERE
  t0.reference = ?
LIMIT
  1

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 WHERE t0.reference = 'FR' 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\Filter\CardListService->setSeriePreferences (line 49)
5	App\Controller\SerieController->view (line 123)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
8	Symfony\Component\HttpKernel\Kernel->handle (line 205)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.61 ms
(0.15%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.sort_order AS sort_order_3, c0_.deck_sort_order AS deck_sort_order_4, c0_.leader AS leader_5, c0_.displayed AS displayed_6, c0_.website_id AS website_id_7 FROM card_type c0_ WHERE c0_.displayed = 1 AND c0_.website_id = ? ORDER BY c0_.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_en AS name_en_2,
  c0_.sort_order AS sort_order_3,
  c0_.deck_sort_order AS deck_sort_order_4,
  c0_.leader AS leader_5,
  c0_.displayed AS displayed_6,
  c0_.website_id AS website_id_7
FROM
  card_type c0_
WHERE
  c0_.displayed = 1
  AND c0_.website_id = ?
ORDER BY
  c0_.sort_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.sort_order AS sort_order_3, c0_.deck_sort_order AS deck_sort_order_4, c0_.leader AS leader_5, c0_.displayed AS displayed_6, c0_.website_id AS website_id_7 FROM card_type c0_ WHERE c0_.displayed = 1 AND c0_.website_id = 1 ORDER BY c0_.sort_order 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->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
20	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
21	Symfony\Component\Form\FormBuilder->create (line 80)
22	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
23	Symfony\Component\Form\FormBuilder->getForm (line 160)
24	Symfony\Component\Form\FormBuilder->getForm (line 166)
25	Symfony\Component\Form\FormFactory->create (line 37)
26	App\Service\Filter\CardListService->initForm (line 79)
27	App\Service\Filter\CardListService->initFilter (line 24)
28	App\Controller\SerieController->view (line 122)
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.56 ms
(0.13%)

SELECT l0_.id AS id_0, l0_.reference AS reference_1, l0_.name AS name_2, l0_.sort_order AS sort_order_3 FROM language l0_ WHERE EXISTS (SELECT 1 FROM web_site_language w1_ WHERE w1_.language_id = l0_.id AND w1_.web_site_id IN (?)) ORDER BY l0_.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.reference AS reference_1,
  l0_.name AS name_2,
  l0_.sort_order AS sort_order_3
FROM
  language l0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      web_site_language w1_
    WHERE
      w1_.language_id = l0_.id
      AND w1_.web_site_id IN (?)
  )
ORDER BY
  l0_.sort_order ASC

SELECT l0_.id AS id_0, l0_.reference AS reference_1, l0_.name AS name_2, l0_.sort_order AS sort_order_3 FROM language l0_ WHERE EXISTS (SELECT 1 FROM web_site_language w1_ WHERE w1_.language_id = l0_.id AND w1_.web_site_id IN (1)) ORDER BY l0_.sort_order 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\SerieController->view (line 142)
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)

0.54 ms
(0.13%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sort_order AS sort_order_2, c0_.website_id AS website_id_3 FROM card_version c0_ WHERE c0_.website_id = ? ORDER BY c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.sort_order AS sort_order_2,
  c0_.website_id AS website_id_3
FROM
  card_version c0_
WHERE
  c0_.website_id = ?
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sort_order AS sort_order_2, c0_.website_id AS website_id_3 FROM card_version c0_ WHERE c0_.website_id = 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->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
20	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
21	Symfony\Component\Form\FormBuilder->create (line 80)
22	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
23	Symfony\Component\Form\FormBuilder->getForm (line 160)
24	Symfony\Component\Form\FormBuilder->getForm (line 166)
25	Symfony\Component\Form\FormFactory->create (line 37)
26	App\Service\Filter\CardListService->initForm (line 79)
27	App\Service\Filter\CardListService->initFilter (line 24)
28	App\Controller\SerieController->view (line 122)
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.53 ms
(0.13%)

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.website_id AS website_id_3 FROM serie_type s0_ WHERE s0_.website_id = ? ORDER BY s0_.reference ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.reference AS reference_1,
  s0_.name AS name_2,
  s0_.website_id AS website_id_3
FROM
  serie_type s0_
WHERE
  s0_.website_id = ?
ORDER BY
  s0_.reference ASC

SELECT s0_.id AS id_0, s0_.reference AS reference_1, s0_.name AS name_2, s0_.website_id AS website_id_3 FROM serie_type s0_ WHERE s0_.website_id = 1 ORDER BY s0_.reference 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->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
20	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
21	Symfony\Component\Form\FormBuilder->create (line 80)
22	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
23	Symfony\Component\Form\FormBuilder->getForm (line 160)
24	Symfony\Component\Form\FormFactory->create (line 37)
25	App\Service\Filter\CardListService->initForm (line 79)
26	App\Service\Filter\CardListService->initFilter (line 24)
27	App\Controller\SerieController->view (line 122)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
30	Symfony\Component\HttpKernel\Kernel->handle (line 205)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

0.53 ms
(0.13%)

SELECT v0_.value AS value_0, v0_.label AS label_1 FROM views_data v0_ WHERE v0_.data_type = ? AND v0_.website_id = ?

Parameters:

[
  "POWER"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.value AS value_0,
  v0_.label AS label_1
FROM
  views_data v0_
WHERE
  v0_.data_type = ?
  AND v0_.website_id = ?

SELECT v0_.value AS value_0, v0_.label AS label_1 FROM views_data v0_ WHERE v0_.data_type = 'POWER' AND v0_.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->getResult (line 688)
6	App\Repository\Utils\ViewsDataRepository->findFilterValues (line 34)
7	App\Form\Type\Range\PowerType->configureOptions (line 26)
8	Symfony\Component\Form\ResolvedFormType->getOptionsResolver (line 138)
9	Symfony\Component\Form\ResolvedFormType->createBuilder (line 77)
10	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->createBuilder (line 58)
11	Symfony\Component\Form\FormFactory->createNamedBuilder (line 72)
12	Symfony\Component\Form\FormBuilder->create (line 80)
13	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
14	Symfony\Component\Form\FormBuilder->getForm (line 160)
15	Symfony\Component\Form\FormFactory->create (line 37)
16	App\Service\Filter\CardListService->initForm (line 79)
17	App\Service\Filter\CardListService->initFilter (line 24)
18	App\Controller\SerieController->view (line 122)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
21	Symfony\Component\HttpKernel\Kernel->handle (line 205)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.51 ms
(0.12%)

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\Controller\SerieController->view (line 108)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
8	Symfony\Component\HttpKernel\Kernel->handle (line 205)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
10	require_once (line 32)
11	require_once (line 5)

0.50 ms
(0.12%)

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.sort_order AS sort_order_4, c0_.hexadecimal AS hexadecimal_5, c0_.website_id AS website_id_6 FROM color c0_ WHERE c0_.website_id = ? ORDER BY c0_.sort_order ASC, c0_.name ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.name AS name_2,
  c0_.name_en AS name_en_3,
  c0_.sort_order AS sort_order_4,
  c0_.hexadecimal AS hexadecimal_5,
  c0_.website_id AS website_id_6
FROM
  color c0_
WHERE
  c0_.website_id = ?
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.name AS name_2, c0_.name_en AS name_en_3, c0_.sort_order AS sort_order_4, c0_.hexadecimal AS hexadecimal_5, c0_.website_id AS website_id_6 FROM color c0_ WHERE c0_.website_id = 1 ORDER BY c0_.sort_order ASC, 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->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
19	Symfony\Component\Form\FormBuilder->create (line 80)
20	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
21	Symfony\Component\Form\FormBuilder->getForm (line 160)
22	Symfony\Component\Form\FormBuilder->getForm (line 166)
23	Symfony\Component\Form\FormFactory->create (line 37)
24	App\Service\Filter\CardListService->initForm (line 79)
25	App\Service\Filter\CardListService->initFilter (line 24)
26	App\Controller\SerieController->view (line 122)
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)

0.43 ms
(0.10%)

SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.name AS name_2, r0_.name_en AS name_en_3, r0_.sort_order AS sort_order_4, r0_.special AS special_5, r0_.displayed AS displayed_6, r0_.website_id AS website_id_7 FROM rarity r0_ WHERE r0_.displayed = 1 AND r0_.website_id = ? ORDER BY r0_.sort_order ASC, r0_.reference ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.reference AS reference_1,
  r0_.name AS name_2,
  r0_.name_en AS name_en_3,
  r0_.sort_order AS sort_order_4,
  r0_.special AS special_5,
  r0_.displayed AS displayed_6,
  r0_.website_id AS website_id_7
FROM
  rarity r0_
WHERE
  r0_.displayed = 1
  AND r0_.website_id = ?
ORDER BY
  r0_.sort_order ASC,
  r0_.reference ASC

SELECT r0_.id AS id_0, r0_.reference AS reference_1, r0_.name AS name_2, r0_.name_en AS name_en_3, r0_.sort_order AS sort_order_4, r0_.special AS special_5, r0_.displayed AS displayed_6, r0_.website_id AS website_id_7 FROM rarity r0_ WHERE r0_.displayed = 1 AND r0_.website_id = 1 ORDER BY r0_.sort_order ASC, r0_.reference 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->buildForm (line 84)
14	Symfony\Component\Form\ResolvedFormType->buildForm (line 100)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
16	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
18	Symfony\Component\Form\ResolvedFormType->buildForm (line 98)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
20	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
21	Symfony\Component\Form\FormBuilder->create (line 80)
22	Symfony\Component\Form\FormBuilder->resolveChildren (line 207)
23	Symfony\Component\Form\FormBuilder->getForm (line 160)
24	Symfony\Component\Form\FormFactory->create (line 37)
25	App\Service\Filter\CardListService->initForm (line 79)
26	App\Service\Filter\CardListService->initFilter (line 24)
27	App\Controller\SerieController->view (line 122)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
30	Symfony\Component\HttpKernel\Kernel->handle (line 205)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

0.41 ms
(0.10%)

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\Controller\SerieController->view (line 116)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
16	Symfony\Component\HttpKernel\Kernel->handle (line 205)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
18	require_once (line 32)
19	require_once (line 5)

0.35 ms
(0.08%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.sort_order AS sort_order_4,
  t0.deck_sort_order AS deck_sort_order_5,
  t0.leader AS leader_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  card_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.sort_order AS sort_order_4, t0.deck_sort_order AS deck_sort_order_5, t0.leader AS leader_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM card_type t0 WHERE t0.id = 2;

#	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\CardType::getName (line 54)
5	App\Service\Images\ImageManager->isItemRotatable (line 178)
6	App\Twig\ImageRuntime->isItemRotatable (line 38)
7	__TwigTemplate_de4baf1418af2082bad19041dafd0da3->doDisplay (line 239)
8	Twig\Template->yield (line 461)
9	__TwigTemplate_f455ae11a5f3296620af40d15e2d18e5->doDisplay (line 116)
10	Twig\Template->yield (line 461)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 343)
15	App\Twig\ItemRuntime->displayItem (line 61)
16	__TwigTemplate_ace1e3fc981a10cdcb723683b26d48aa->doDisplay (line 154)
17	Twig\Template->yield (line 461)
18	__TwigTemplate_dbeba0e6d1ea351a8e7a354665014495->doDisplay (line 143)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7->block_body (line 351)
21	Twig\Template->yieldBlock (line 493)
22	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
23	Twig\Template->yield (line 461)
24	__TwigTemplate_4a2f2b2227ad8844c077c32bb531ddb7->doDisplay (line 62)
25	Twig\Template->yield (line 461)
26	Twig\Template->display (line 416)
27	Twig\Template->render (line 431)
28	Twig\TemplateWrapper->render (line 53)
29	Twig\Environment->render (line 343)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
33	App\Controller\SerieController->view (line 136)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
36	Symfony\Component\HttpKernel\Kernel->handle (line 205)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
38	require_once (line 32)
39	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\CardTag	261
App\Entity\Serie	205
App\Entity\SpecialTrait	98
App\Entity\Skill	76
App\Entity\Era	48
App\Entity\Rarity	27
App\Entity\CardVersion	22
App\Entity\Serie\SerieType	16
App\Entity\CardType	10
App\Entity\Color	6
App\Entity\Card	5
App\Entity\GroupVersion	5
App\Entity\Language	2
App\Entity\WebSite	1
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\Serie	No errors.
App\Entity\Serie\SerieType	No errors.
App\Entity\Card	No errors.
App\Entity\SerieRarity	No errors.
App\Entity\Product\Product	No errors.
App\Entity\Deckbuilder\Deckbuilder	No errors.
App\Entity\Deckbuilder\DeckArea	No errors.
App\Entity\Deckbuilder\DeckBuilderSkill	No errors.
App\Entity\Character	No errors.
App\Entity\SpecialTrait	No errors.
App\Entity\Era	No errors.
App\Entity\Utils\ViewsData	No errors.
App\Entity\Rarity	No errors.
App\Entity\CardTag	No errors.
App\Entity\CardTag\Utility	No errors.
App\Entity\CardTag\Complementarity	No errors.
App\Entity\CardTag\Theme	No errors.
App\Entity\CardType	No errors.
App\Entity\Color	No errors.
App\Entity\CardVersion	No errors.
App\Entity\Skill	No errors.
App\Entity\GroupVersion	No errors.
App\Entity\Avatar\Avatar	No errors.
App\Entity\Card\CardVersionAnnotation	No errors.
App\Entity\Snapshot	No errors.
App\Entity\Card\Timing	No errors.
App\Entity\Deck	No errors.
App\Entity\Deckbuilder\DeckAreaCard	No errors.
App\Entity\CardOwned	No errors.
App\Entity\WishlistCard	No errors.
App\Entity\Partnership\CardmarketClick	No errors.
App\Entity\FAQ	No errors.
App\Entity\Errata	No errors.
App\Entity\CardAssociation	No errors.
App\Entity\View\CardView	No errors.
App\Entity\User\CardSale	No errors.
App\Entity\Card\Ink	No errors.
App\Entity\Card\Attribute	No errors.
App\Entity\SubCardType	No errors.
App\Entity\Stream\DisplayerHistory	No errors.
App\Entity\Card\Digivolution	No errors.

Symfony Profiler

GET https://dev.tcgcards.fr/series/tk-jeton-token

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping