Symfony Profiler

Query Metrics

90 Database Queries

21 Different statements

333.94 ms Query time

0 Invalid entities

114 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

124.77 ms
(37.36%)

SELECT COUNT(d0_.ip) AS sclr_0 FROM deck_view d0_ WHERE d0_.deck_id = ? AND DATE(d0_.view_date) = ? AND d0_.ip = ?

Parameters:

[
  16221
  "2026-11-10"
  "216.73.216.191"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.ip) AS sclr_0
FROM
  deck_view d0_
WHERE
  d0_.deck_id = ?
  AND DATE(d0_.view_date) = ?
  AND d0_.ip = ?

SELECT COUNT(d0_.ip) AS sclr_0 FROM deck_view d0_ WHERE d0_.deck_id = 16221 AND DATE(d0_.view_date) = '2026-11-10' AND d0_.ip = '216.73.216.191';

#	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\View\DeckViewRepository->getIPCountViewToday (line 35)
8	App\Service\ViewManager->generateView (line 49)
9	App\Controller\DeckController->view (line 230)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
12	Symfony\Component\HttpKernel\Kernel->handle (line 205)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

82.92 ms
(24.83%)

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_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
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\DeckController->view (line 244)
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)

47.72 ms
(14.29%)

SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.website_id = ? AND t0.uniqid = ? LIMIT 1

Parameters:

[
  1
  "e1b320b5dc6f0b5e97913ff8a67074b080e9b43d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uniqid AS uniqid_2,
  t0.name AS name_3,
  t0.private AS private_4,
  t0.invalid AS invalid_5,
  t0.starter AS starter_6,
  t0.dev_team AS dev_team_7,
  t0.meta AS meta_8,
  t0.total_price AS total_price_9,
  t0.untap_click_count AS untap_click_count_10,
  t0.creation_date AS creation_date_11,
  t0.update_date AS update_date_12,
  t0.view_count AS view_count_13,
  t0.like_count AS like_count_14,
  t0.deleted AS deleted_15,
  t0.leader_id AS leader_id_16,
  t17.id AS id_18,
  t17.number AS number_19,
  t17.serial_number AS serial_number_20,
  t17.front_name AS front_name_21,
  t17.front_description AS front_description_22,
  t17.front_energy_cost AS front_energy_cost_23,
  t17.secondary_cost AS secondary_cost_24,
  t17.front_energy_cost_alias AS front_energy_cost_alias_25,
  t17.front_energy_color_cost AS front_energy_color_cost_26,
  t17.back_energy_color_cost AS back_energy_color_cost_27,
  t17.front_combo_cost AS front_combo_cost_28,
  t17.front_combo_power AS front_combo_power_29,
  t17.front_power AS front_power_30,
  t17.front_defense AS front_defense_31,
  t17.back_name AS back_name_32,
  t17.back_description AS back_description_33,
  t17.back_power AS back_power_34,
  t17.back_power2 AS back_power2_35,
  t17.back_defense AS back_defense_36,
  t17.back_defense2 AS back_defense2_37,
  t17.img_ready AS img_ready_38,
  t17.image_ready AS image_ready_39,
  t17.multicolor AS multicolor_40,
  t17.limited AS limited_41,
  t17.banned AS banned_42,
  t17.unlimited_in_deck AS unlimited_in_deck_43,
  t17.limitation_in_deck AS limitation_in_deck_44,
  t17.reprint AS reprint_45,
  t17.foil AS foil_46,
  t17.reprint_category AS reprint_category_47,
  t17.animated AS animated_48,
  t17.version_number AS version_number_49,
  t17.front_name_alias AS front_name_alias_50,
  t17.front_name_en AS front_name_en_51,
  t17.back_name_en AS back_name_en_52,
  t17.front_description_en AS front_description_en_53,
  t17.back_description_en AS back_description_en_54,
  t17.english_only AS english_only_55,
  t17.redirect_english_slug AS redirect_english_slug_56,
  t17.position_serie_list AS position_serie_list_57,
  t17.lore AS lore_58,
  t17.subname AS subname_59,
  t17.illustrator AS illustrator_60,
  t17.energyzable AS energyzable_61,
  t17.weakness AS weakness_62,
  t17.resistance AS resistance_63,
  t17.sub_description AS sub_description_64,
  t17.exclusive AS exclusive_65,
  t17.end_of_serie AS end_of_serie_66,
  t17.verso AS verso_67,
  t17.additional_data AS additional_data_68,
  t17.ocr_keywords_count AS ocr_keywords_count_69,
  t17.beta AS beta_70,
  t17.level AS level_71,
  t17.price_alert AS price_alert_72,
  t17.creation_date AS creation_date_73,
  t17.update_date AS update_date_74,
  t17.displayed AS displayed_75,
  t17.slug AS slug_76,
  t17.slug_en AS slug_en_77,
  t17.view_count AS view_count_78,
  t17.cmid AS cmid_79,
  t17.url AS url_80,
  t17.image AS image_81,
  t17.current_price AS current_price_82,
  t17.yesterday_price AS yesterday_price_83,
  t17.last_price_update AS last_price_update_84,
  t17.cardnexus_id AS cardnexus_id_85,
  t17.cardnexus_current_price AS cardnexus_current_price_86,
  t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87,
  t17.cardnexus_last_price_update AS cardnexus_last_price_update_88,
  t17.lang AS lang_89,
  t17.release_date AS release_date_90,
  t17.complete AS complete_91,
  t17.bandai_tcgid AS bandai_tcgid_92,
  t17.checked AS checked_93,
  t17.indexable AS indexable_94,
  t17.front_era_id AS front_era_id_95,
  t17.back_era_id AS back_era_id_96,
  t17.type_id AS type_id_97,
  t17.serie_id AS serie_id_98,
  t17.rarity_id AS rarity_id_99,
  t17.group_version_id AS group_version_id_100,
  t17.avatar_id AS avatar_id_101,
  t17.version_id AS version_id_102,
  t17.auto_play_id AS auto_play_id_103,
  t17.version_annotation_id AS version_annotation_id_104,
  t17.website_id AS website_id_105,
  t0.creator_id AS creator_id_106,
  t0.event_id AS event_id_107,
  t0.website_id AS website_id_108
FROM
  deck t0
  INNER JOIN card t17 ON t0.leader_id = t17.id
WHERE
  t0.website_id = ?
  AND t0.uniqid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.website_id = 1 AND t0.uniqid = 'e1b320b5dc6f0b5e97913ff8a67074b080e9b43d' 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\DeckController->view (line 225)
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)

25.76 ms
(7.71%)

SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.uniqid = ? AND t0.website_id = ? LIMIT 1

Parameters:

[
  "e1b320b5dc6f0b5e97913ff8a67074b080e9b43d"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uniqid AS uniqid_2,
  t0.name AS name_3,
  t0.private AS private_4,
  t0.invalid AS invalid_5,
  t0.starter AS starter_6,
  t0.dev_team AS dev_team_7,
  t0.meta AS meta_8,
  t0.total_price AS total_price_9,
  t0.untap_click_count AS untap_click_count_10,
  t0.creation_date AS creation_date_11,
  t0.update_date AS update_date_12,
  t0.view_count AS view_count_13,
  t0.like_count AS like_count_14,
  t0.deleted AS deleted_15,
  t0.leader_id AS leader_id_16,
  t17.id AS id_18,
  t17.number AS number_19,
  t17.serial_number AS serial_number_20,
  t17.front_name AS front_name_21,
  t17.front_description AS front_description_22,
  t17.front_energy_cost AS front_energy_cost_23,
  t17.secondary_cost AS secondary_cost_24,
  t17.front_energy_cost_alias AS front_energy_cost_alias_25,
  t17.front_energy_color_cost AS front_energy_color_cost_26,
  t17.back_energy_color_cost AS back_energy_color_cost_27,
  t17.front_combo_cost AS front_combo_cost_28,
  t17.front_combo_power AS front_combo_power_29,
  t17.front_power AS front_power_30,
  t17.front_defense AS front_defense_31,
  t17.back_name AS back_name_32,
  t17.back_description AS back_description_33,
  t17.back_power AS back_power_34,
  t17.back_power2 AS back_power2_35,
  t17.back_defense AS back_defense_36,
  t17.back_defense2 AS back_defense2_37,
  t17.img_ready AS img_ready_38,
  t17.image_ready AS image_ready_39,
  t17.multicolor AS multicolor_40,
  t17.limited AS limited_41,
  t17.banned AS banned_42,
  t17.unlimited_in_deck AS unlimited_in_deck_43,
  t17.limitation_in_deck AS limitation_in_deck_44,
  t17.reprint AS reprint_45,
  t17.foil AS foil_46,
  t17.reprint_category AS reprint_category_47,
  t17.animated AS animated_48,
  t17.version_number AS version_number_49,
  t17.front_name_alias AS front_name_alias_50,
  t17.front_name_en AS front_name_en_51,
  t17.back_name_en AS back_name_en_52,
  t17.front_description_en AS front_description_en_53,
  t17.back_description_en AS back_description_en_54,
  t17.english_only AS english_only_55,
  t17.redirect_english_slug AS redirect_english_slug_56,
  t17.position_serie_list AS position_serie_list_57,
  t17.lore AS lore_58,
  t17.subname AS subname_59,
  t17.illustrator AS illustrator_60,
  t17.energyzable AS energyzable_61,
  t17.weakness AS weakness_62,
  t17.resistance AS resistance_63,
  t17.sub_description AS sub_description_64,
  t17.exclusive AS exclusive_65,
  t17.end_of_serie AS end_of_serie_66,
  t17.verso AS verso_67,
  t17.additional_data AS additional_data_68,
  t17.ocr_keywords_count AS ocr_keywords_count_69,
  t17.beta AS beta_70,
  t17.level AS level_71,
  t17.price_alert AS price_alert_72,
  t17.creation_date AS creation_date_73,
  t17.update_date AS update_date_74,
  t17.displayed AS displayed_75,
  t17.slug AS slug_76,
  t17.slug_en AS slug_en_77,
  t17.view_count AS view_count_78,
  t17.cmid AS cmid_79,
  t17.url AS url_80,
  t17.image AS image_81,
  t17.current_price AS current_price_82,
  t17.yesterday_price AS yesterday_price_83,
  t17.last_price_update AS last_price_update_84,
  t17.cardnexus_id AS cardnexus_id_85,
  t17.cardnexus_current_price AS cardnexus_current_price_86,
  t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87,
  t17.cardnexus_last_price_update AS cardnexus_last_price_update_88,
  t17.lang AS lang_89,
  t17.release_date AS release_date_90,
  t17.complete AS complete_91,
  t17.bandai_tcgid AS bandai_tcgid_92,
  t17.checked AS checked_93,
  t17.indexable AS indexable_94,
  t17.front_era_id AS front_era_id_95,
  t17.back_era_id AS back_era_id_96,
  t17.type_id AS type_id_97,
  t17.serie_id AS serie_id_98,
  t17.rarity_id AS rarity_id_99,
  t17.group_version_id AS group_version_id_100,
  t17.avatar_id AS avatar_id_101,
  t17.version_id AS version_id_102,
  t17.auto_play_id AS auto_play_id_103,
  t17.version_annotation_id AS version_annotation_id_104,
  t17.website_id AS website_id_105,
  t0.creator_id AS creator_id_106,
  t0.event_id AS event_id_107,
  t0.website_id AS website_id_108
FROM
  deck t0
  INNER JOIN card t17 ON t0.leader_id = t17.id
WHERE
  t0.uniqid = ?
  AND t0.website_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uniqid AS uniqid_2, t0.name AS name_3, t0.private AS private_4, t0.invalid AS invalid_5, t0.starter AS starter_6, t0.dev_team AS dev_team_7, t0.meta AS meta_8, t0.total_price AS total_price_9, t0.untap_click_count AS untap_click_count_10, t0.creation_date AS creation_date_11, t0.update_date AS update_date_12, t0.view_count AS view_count_13, t0.like_count AS like_count_14, t0.deleted AS deleted_15, t0.leader_id AS leader_id_16, t17.id AS id_18, t17.number AS number_19, t17.serial_number AS serial_number_20, t17.front_name AS front_name_21, t17.front_description AS front_description_22, t17.front_energy_cost AS front_energy_cost_23, t17.secondary_cost AS secondary_cost_24, t17.front_energy_cost_alias AS front_energy_cost_alias_25, t17.front_energy_color_cost AS front_energy_color_cost_26, t17.back_energy_color_cost AS back_energy_color_cost_27, t17.front_combo_cost AS front_combo_cost_28, t17.front_combo_power AS front_combo_power_29, t17.front_power AS front_power_30, t17.front_defense AS front_defense_31, t17.back_name AS back_name_32, t17.back_description AS back_description_33, t17.back_power AS back_power_34, t17.back_power2 AS back_power2_35, t17.back_defense AS back_defense_36, t17.back_defense2 AS back_defense2_37, t17.img_ready AS img_ready_38, t17.image_ready AS image_ready_39, t17.multicolor AS multicolor_40, t17.limited AS limited_41, t17.banned AS banned_42, t17.unlimited_in_deck AS unlimited_in_deck_43, t17.limitation_in_deck AS limitation_in_deck_44, t17.reprint AS reprint_45, t17.foil AS foil_46, t17.reprint_category AS reprint_category_47, t17.animated AS animated_48, t17.version_number AS version_number_49, t17.front_name_alias AS front_name_alias_50, t17.front_name_en AS front_name_en_51, t17.back_name_en AS back_name_en_52, t17.front_description_en AS front_description_en_53, t17.back_description_en AS back_description_en_54, t17.english_only AS english_only_55, t17.redirect_english_slug AS redirect_english_slug_56, t17.position_serie_list AS position_serie_list_57, t17.lore AS lore_58, t17.subname AS subname_59, t17.illustrator AS illustrator_60, t17.energyzable AS energyzable_61, t17.weakness AS weakness_62, t17.resistance AS resistance_63, t17.sub_description AS sub_description_64, t17.exclusive AS exclusive_65, t17.end_of_serie AS end_of_serie_66, t17.verso AS verso_67, t17.additional_data AS additional_data_68, t17.ocr_keywords_count AS ocr_keywords_count_69, t17.beta AS beta_70, t17.level AS level_71, t17.price_alert AS price_alert_72, t17.creation_date AS creation_date_73, t17.update_date AS update_date_74, t17.displayed AS displayed_75, t17.slug AS slug_76, t17.slug_en AS slug_en_77, t17.view_count AS view_count_78, t17.cmid AS cmid_79, t17.url AS url_80, t17.image AS image_81, t17.current_price AS current_price_82, t17.yesterday_price AS yesterday_price_83, t17.last_price_update AS last_price_update_84, t17.cardnexus_id AS cardnexus_id_85, t17.cardnexus_current_price AS cardnexus_current_price_86, t17.cardnexus_yesterday_price AS cardnexus_yesterday_price_87, t17.cardnexus_last_price_update AS cardnexus_last_price_update_88, t17.lang AS lang_89, t17.release_date AS release_date_90, t17.complete AS complete_91, t17.bandai_tcgid AS bandai_tcgid_92, t17.checked AS checked_93, t17.indexable AS indexable_94, t17.front_era_id AS front_era_id_95, t17.back_era_id AS back_era_id_96, t17.type_id AS type_id_97, t17.serie_id AS serie_id_98, t17.rarity_id AS rarity_id_99, t17.group_version_id AS group_version_id_100, t17.avatar_id AS avatar_id_101, t17.version_id AS version_id_102, t17.auto_play_id AS auto_play_id_103, t17.version_annotation_id AS version_annotation_id_104, t17.website_id AS website_id_105, t0.creator_id AS creator_id_106, t0.event_id AS event_id_107, t0.website_id AS website_id_108 FROM deck t0 INNER JOIN card t17 ON t0.leader_id = t17.id WHERE t0.uniqid = 'e1b320b5dc6f0b5e97913ff8a67074b080e9b43d' 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 148)
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_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
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\DeckController->view (line 244)
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)

21.29 ms
(6.38%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.serial_number AS serial_number_3, t0.front_name AS front_name_4, t0.front_description AS front_description_5, t0.front_energy_cost AS front_energy_cost_6, t0.secondary_cost AS secondary_cost_7, t0.front_energy_cost_alias AS front_energy_cost_alias_8, t0.front_energy_color_cost AS front_energy_color_cost_9, t0.back_energy_color_cost AS back_energy_color_cost_10, t0.front_combo_cost AS front_combo_cost_11, t0.front_combo_power AS front_combo_power_12, t0.front_power AS front_power_13, t0.front_defense AS front_defense_14, t0.back_name AS back_name_15, t0.back_description AS back_description_16, t0.back_power AS back_power_17, t0.back_power2 AS back_power2_18, t0.back_defense AS back_defense_19, t0.back_defense2 AS back_defense2_20, t0.img_ready AS img_ready_21, t0.image_ready AS image_ready_22, t0.multicolor AS multicolor_23, t0.limited AS limited_24, t0.banned AS banned_25, t0.unlimited_in_deck AS unlimited_in_deck_26, t0.limitation_in_deck AS limitation_in_deck_27, t0.reprint AS reprint_28, t0.foil AS foil_29, t0.reprint_category AS reprint_category_30, t0.animated AS animated_31, t0.version_number AS version_number_32, t0.front_name_alias AS front_name_alias_33, t0.front_name_en AS front_name_en_34, t0.back_name_en AS back_name_en_35, t0.front_description_en AS front_description_en_36, t0.back_description_en AS back_description_en_37, t0.english_only AS english_only_38, t0.redirect_english_slug AS redirect_english_slug_39, t0.position_serie_list AS position_serie_list_40, t0.lore AS lore_41, t0.subname AS subname_42, t0.illustrator AS illustrator_43, t0.energyzable AS energyzable_44, t0.weakness AS weakness_45, t0.resistance AS resistance_46, t0.sub_description AS sub_description_47, t0.exclusive AS exclusive_48, t0.end_of_serie AS end_of_serie_49, t0.verso AS verso_50, t0.additional_data AS additional_data_51, t0.ocr_keywords_count AS ocr_keywords_count_52, t0.beta AS beta_53, t0.level AS level_54, t0.price_alert AS price_alert_55, t0.creation_date AS creation_date_56, t0.update_date AS update_date_57, t0.displayed AS displayed_58, t0.slug AS slug_59, t0.slug_en AS slug_en_60, t0.view_count AS view_count_61, t0.cmid AS cmid_62, t0.url AS url_63, t0.image AS image_64, t0.current_price AS current_price_65, t0.yesterday_price AS yesterday_price_66, t0.last_price_update AS last_price_update_67, t0.cardnexus_id AS cardnexus_id_68, t0.cardnexus_current_price AS cardnexus_current_price_69, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_70, t0.cardnexus_last_price_update AS cardnexus_last_price_update_71, t0.lang AS lang_72, t0.release_date AS release_date_73, t0.complete AS complete_74, t0.bandai_tcgid AS bandai_tcgid_75, t0.checked AS checked_76, t0.indexable AS indexable_77, t0.front_era_id AS front_era_id_78, t0.back_era_id AS back_era_id_79, t0.type_id AS type_id_80, t0.serie_id AS serie_id_81, t0.rarity_id AS rarity_id_82, t0.group_version_id AS group_version_id_83, t0.avatar_id AS avatar_id_84, t0.version_id AS version_id_85, t0.auto_play_id AS auto_play_id_86, t0.version_annotation_id AS version_annotation_id_87, t0.website_id AS website_id_88 FROM card t0 WHERE t0.id = ?

Parameters:

[
  1645
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.serial_number AS serial_number_3,
  t0.front_name AS front_name_4,
  t0.front_description AS front_description_5,
  t0.front_energy_cost AS front_energy_cost_6,
  t0.secondary_cost AS secondary_cost_7,
  t0.front_energy_cost_alias AS front_energy_cost_alias_8,
  t0.front_energy_color_cost AS front_energy_color_cost_9,
  t0.back_energy_color_cost AS back_energy_color_cost_10,
  t0.front_combo_cost AS front_combo_cost_11,
  t0.front_combo_power AS front_combo_power_12,
  t0.front_power AS front_power_13,
  t0.front_defense AS front_defense_14,
  t0.back_name AS back_name_15,
  t0.back_description AS back_description_16,
  t0.back_power AS back_power_17,
  t0.back_power2 AS back_power2_18,
  t0.back_defense AS back_defense_19,
  t0.back_defense2 AS back_defense2_20,
  t0.img_ready AS img_ready_21,
  t0.image_ready AS image_ready_22,
  t0.multicolor AS multicolor_23,
  t0.limited AS limited_24,
  t0.banned AS banned_25,
  t0.unlimited_in_deck AS unlimited_in_deck_26,
  t0.limitation_in_deck AS limitation_in_deck_27,
  t0.reprint AS reprint_28,
  t0.foil AS foil_29,
  t0.reprint_category AS reprint_category_30,
  t0.animated AS animated_31,
  t0.version_number AS version_number_32,
  t0.front_name_alias AS front_name_alias_33,
  t0.front_name_en AS front_name_en_34,
  t0.back_name_en AS back_name_en_35,
  t0.front_description_en AS front_description_en_36,
  t0.back_description_en AS back_description_en_37,
  t0.english_only AS english_only_38,
  t0.redirect_english_slug AS redirect_english_slug_39,
  t0.position_serie_list AS position_serie_list_40,
  t0.lore AS lore_41,
  t0.subname AS subname_42,
  t0.illustrator AS illustrator_43,
  t0.energyzable AS energyzable_44,
  t0.weakness AS weakness_45,
  t0.resistance AS resistance_46,
  t0.sub_description AS sub_description_47,
  t0.exclusive AS exclusive_48,
  t0.end_of_serie AS end_of_serie_49,
  t0.verso AS verso_50,
  t0.additional_data AS additional_data_51,
  t0.ocr_keywords_count AS ocr_keywords_count_52,
  t0.beta AS beta_53,
  t0.level AS level_54,
  t0.price_alert AS price_alert_55,
  t0.creation_date AS creation_date_56,
  t0.update_date AS update_date_57,
  t0.displayed AS displayed_58,
  t0.slug AS slug_59,
  t0.slug_en AS slug_en_60,
  t0.view_count AS view_count_61,
  t0.cmid AS cmid_62,
  t0.url AS url_63,
  t0.image AS image_64,
  t0.current_price AS current_price_65,
  t0.yesterday_price AS yesterday_price_66,
  t0.last_price_update AS last_price_update_67,
  t0.cardnexus_id AS cardnexus_id_68,
  t0.cardnexus_current_price AS cardnexus_current_price_69,
  t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_70,
  t0.cardnexus_last_price_update AS cardnexus_last_price_update_71,
  t0.lang AS lang_72,
  t0.release_date AS release_date_73,
  t0.complete AS complete_74,
  t0.bandai_tcgid AS bandai_tcgid_75,
  t0.checked AS checked_76,
  t0.indexable AS indexable_77,
  t0.front_era_id AS front_era_id_78,
  t0.back_era_id AS back_era_id_79,
  t0.type_id AS type_id_80,
  t0.serie_id AS serie_id_81,
  t0.rarity_id AS rarity_id_82,
  t0.group_version_id AS group_version_id_83,
  t0.avatar_id AS avatar_id_84,
  t0.version_id AS version_id_85,
  t0.auto_play_id AS auto_play_id_86,
  t0.version_annotation_id AS version_annotation_id_87,
  t0.website_id AS website_id_88
FROM
  card t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.serial_number AS serial_number_3, t0.front_name AS front_name_4, t0.front_description AS front_description_5, t0.front_energy_cost AS front_energy_cost_6, t0.secondary_cost AS secondary_cost_7, t0.front_energy_cost_alias AS front_energy_cost_alias_8, t0.front_energy_color_cost AS front_energy_color_cost_9, t0.back_energy_color_cost AS back_energy_color_cost_10, t0.front_combo_cost AS front_combo_cost_11, t0.front_combo_power AS front_combo_power_12, t0.front_power AS front_power_13, t0.front_defense AS front_defense_14, t0.back_name AS back_name_15, t0.back_description AS back_description_16, t0.back_power AS back_power_17, t0.back_power2 AS back_power2_18, t0.back_defense AS back_defense_19, t0.back_defense2 AS back_defense2_20, t0.img_ready AS img_ready_21, t0.image_ready AS image_ready_22, t0.multicolor AS multicolor_23, t0.limited AS limited_24, t0.banned AS banned_25, t0.unlimited_in_deck AS unlimited_in_deck_26, t0.limitation_in_deck AS limitation_in_deck_27, t0.reprint AS reprint_28, t0.foil AS foil_29, t0.reprint_category AS reprint_category_30, t0.animated AS animated_31, t0.version_number AS version_number_32, t0.front_name_alias AS front_name_alias_33, t0.front_name_en AS front_name_en_34, t0.back_name_en AS back_name_en_35, t0.front_description_en AS front_description_en_36, t0.back_description_en AS back_description_en_37, t0.english_only AS english_only_38, t0.redirect_english_slug AS redirect_english_slug_39, t0.position_serie_list AS position_serie_list_40, t0.lore AS lore_41, t0.subname AS subname_42, t0.illustrator AS illustrator_43, t0.energyzable AS energyzable_44, t0.weakness AS weakness_45, t0.resistance AS resistance_46, t0.sub_description AS sub_description_47, t0.exclusive AS exclusive_48, t0.end_of_serie AS end_of_serie_49, t0.verso AS verso_50, t0.additional_data AS additional_data_51, t0.ocr_keywords_count AS ocr_keywords_count_52, t0.beta AS beta_53, t0.level AS level_54, t0.price_alert AS price_alert_55, t0.creation_date AS creation_date_56, t0.update_date AS update_date_57, t0.displayed AS displayed_58, t0.slug AS slug_59, t0.slug_en AS slug_en_60, t0.view_count AS view_count_61, t0.cmid AS cmid_62, t0.url AS url_63, t0.image AS image_64, t0.current_price AS current_price_65, t0.yesterday_price AS yesterday_price_66, t0.last_price_update AS last_price_update_67, t0.cardnexus_id AS cardnexus_id_68, t0.cardnexus_current_price AS cardnexus_current_price_69, t0.cardnexus_yesterday_price AS cardnexus_yesterday_price_70, t0.cardnexus_last_price_update AS cardnexus_last_price_update_71, t0.lang AS lang_72, t0.release_date AS release_date_73, t0.complete AS complete_74, t0.bandai_tcgid AS bandai_tcgid_75, t0.checked AS checked_76, t0.indexable AS indexable_77, t0.front_era_id AS front_era_id_78, t0.back_era_id AS back_era_id_79, t0.type_id AS type_id_80, t0.serie_id AS serie_id_81, t0.rarity_id AS rarity_id_82, t0.group_version_id AS group_version_id_83, t0.avatar_id AS avatar_id_84, t0.version_id AS version_id_85, t0.auto_play_id AS auto_play_id_86, t0.version_annotation_id AS version_annotation_id_87, t0.website_id AS website_id_88 FROM card t0 WHERE t0.id = 1645;

#	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\Card::getEnglishNameWithoutReprintCategory (line 1455)
5	App\Service\Decks\DeckDataManager->getUntapData (line 133)
6	App\Twig\DeckRuntime->getUntapData (line 31)
7	__TwigTemplate_8a6f090ce389adb0329d7e583ecbcf6f->doDisplay (line 422)
8	Twig\Template->yield (line 461)
9	Twig\Template->display (line 416)
10	Twig\Template->render (line 431)
11	Twig\TemplateWrapper->render (line 53)
12	Twig\Extension\CoreExtension->include (line 1575)
13	__TwigTemplate_7504d517113533dcfd4a35f4f602a266::block_body (line 197)
14	Twig\Template->yieldBlock (line 493)
15	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
18	Twig\Template->yield (line 461)
19	Twig\Template->display (line 416)
20	Twig\Template->render (line 431)
21	Twig\TemplateWrapper->render (line 53)
22	Twig\Environment->render (line 343)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\DeckController->view (line 244)
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)

10.37 ms
(3.10%)

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:

[
  8900
]

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 = 8900 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->displayItemMultiple (line 93)
8	__TwigTemplate_5aed94e140ece298e2ba9c5d9235760a->doDisplay (line 58)
9	Twig\Template->yield (line 461)
10	Twig\Template->display (line 416)
11	Twig\Template->render (line 431)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Environment->render (line 343)
14	App\Twig\ViewBlockRuntime->displayBlock (line 20)
15	__TwigTemplate_c37a2cb69cc5ba7a7fa3b60bce2f1710->doDisplay (line 118)
16	Twig\Template->yield (line 461)
17	__TwigTemplate_ac86910efc103edbc3b0c8b7a554583c->doDisplay (line 174)
18	Twig\Template->yield (line 461)
19	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->block_body (line 200)
20	Twig\Template->yieldBlock (line 493)
21	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
22	Twig\Template->yield (line 461)
23	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
24	Twig\Template->yield (line 461)
25	Twig\Template->display (line 416)
26	Twig\Template->render (line 431)
27	Twig\TemplateWrapper->render (line 53)
28	Twig\Environment->render (line 343)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
32	App\Controller\DeckController->view (line 244)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
35	Symfony\Component\HttpKernel\Kernel->handle (line 205)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
37	require_once (line 32)
38	require_once (line 5)

3.86 ms
(1.16%)

SELECT d0_.number AS number_0, d0_.updated AS updated_1, d0_.deck_id AS deck_id_2, d0_.deck_area_id AS deck_area_id_3, d0_.card_id AS card_id_4 FROM deck_area_card d0_ INNER JOIN card c1_ ON d0_.card_id = c1_.id INNER JOIN card_type c2_ ON c1_.type_id = c2_.id INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id LEFT JOIN color_card c5_ ON c1_.id = c5_.card_id LEFT JOIN color c4_ ON c4_.id = c5_.color_id WHERE d0_.deck_id = ? AND d0_.deck_area_id = ? ORDER BY c2_.deck_sort_order ASC, c1_.front_energy_cost ASC, c1_.multicolor ASC, c4_.sort_order ASC, r3_.sort_order ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.number AS number_0,
  d0_.updated AS updated_1,
  d0_.deck_id AS deck_id_2,
  d0_.deck_area_id AS deck_area_id_3,
  d0_.card_id AS card_id_4
FROM
  deck_area_card d0_
  INNER JOIN card c1_ ON d0_.card_id = c1_.id
  INNER JOIN card_type c2_ ON c1_.type_id = c2_.id
  INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id
  LEFT JOIN color_card c5_ ON c1_.id = c5_.card_id
  LEFT JOIN color c4_ ON c4_.id = c5_.color_id
WHERE
  d0_.deck_id = ?
  AND d0_.deck_area_id = ?
ORDER BY
  c2_.deck_sort_order ASC,
  c1_.front_energy_cost ASC,
  c1_.multicolor ASC,
  c4_.sort_order ASC,
  r3_.sort_order ASC

SELECT d0_.number AS number_0, d0_.updated AS updated_1, d0_.deck_id AS deck_id_2, d0_.deck_area_id AS deck_area_id_3, d0_.card_id AS card_id_4 FROM deck_area_card d0_ INNER JOIN card c1_ ON d0_.card_id = c1_.id INNER JOIN card_type c2_ ON c1_.type_id = c2_.id INNER JOIN rarity r3_ ON c1_.rarity_id = r3_.id LEFT JOIN color_card c5_ ON c1_.id = c5_.card_id LEFT JOIN color c4_ ON c4_.id = c5_.color_id WHERE d0_.deck_id = 16221 AND d0_.deck_area_id = 1 ORDER BY c2_.deck_sort_order ASC, c1_.front_energy_cost ASC, c1_.multicolor ASC, c4_.sort_order ASC, r3_.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	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Deckbuilder\DeckAreaCardRepository->findSortedCardsOfDeck (line 61)
7	App\Model\Item\DeckViewBuilder->buildBlocks (line 29)
8	App\Model\Item\ItemViewDirector->constructItemView (line 25)
9	App\Controller\DeckController->view (line 234)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
12	Symfony\Component\HttpKernel\Kernel->handle (line 205)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

3.04 ms
(0.91%)

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

Parameters:

[
  153
]

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

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.id = 153;

#	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\Serie::getReference (line 113)
5	App\Service\Images\ImageManager->getImage (line 98)
6	App\Service\Images\ImageManager->getImageVerso (line 162)
7	App\Twig\ImageRuntime->displayVerso (line 32)
8	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->block_meta (line 110)
9	Twig\Template->yieldBlock (line 493)
10	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 137)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
13	Twig\Template->yield (line 461)
14	Twig\Template->display (line 416)
15	Twig\Template->render (line 431)
16	Twig\TemplateWrapper->render (line 53)
17	Twig\Environment->render (line 343)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\DeckController->view (line 244)
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)

2.72 ms
(0.82%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.sort_order AS sort_order_5, t0.special AS special_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM rarity t0 WHERE t0.id = ?

Parameters:

[
  10
]

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.sort_order AS sort_order_5,
  t0.special AS special_6,
  t0.displayed AS displayed_7,
  t0.website_id AS website_id_8
FROM
  rarity t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.name_en AS name_en_4, t0.sort_order AS sort_order_5, t0.special AS special_6, t0.displayed AS displayed_7, t0.website_id AS website_id_8 FROM rarity t0 WHERE t0.id = 10;

#	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\Rarity::getReference (line 55)
5	App\Entity\Card->getUntapSerialNumber (line 2024)
6	App\Service\Decks\DeckDataManager->getUntapData (line 133)
7	App\Twig\DeckRuntime->getUntapData (line 31)
8	__TwigTemplate_8a6f090ce389adb0329d7e583ecbcf6f->doDisplay (line 422)
9	Twig\Template->yield (line 461)
10	Twig\Template->display (line 416)
11	Twig\Template->render (line 431)
12	Twig\TemplateWrapper->render (line 53)
13	Twig\Extension\CoreExtension->include (line 1575)
14	__TwigTemplate_7504d517113533dcfd4a35f4f602a266::block_body (line 197)
15	Twig\Template->yieldBlock (line 493)
16	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
17	Twig\Template->yield (line 461)
18	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
19	Twig\Template->yield (line 461)
20	Twig\Template->display (line 416)
21	Twig\Template->render (line 431)
22	Twig\TemplateWrapper->render (line 53)
23	Twig\Environment->render (line 343)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
27	App\Controller\DeckController->view (line 244)
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)

2.09 ms
(0.63%)

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\Model\Item\DeckViewBuilder->buildBlocks (line 26)
5	App\Model\Item\ItemViewDirector->constructItemView (line 25)
6	App\Controller\DeckController->view (line 234)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
9	Symfony\Component\HttpKernel\Kernel->handle (line 205)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

1.78 ms
(0.53%)

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\DeckController->view (line 223)
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)

1.66 ms
(0.50%)

SELECT t0.number AS number_1, t0.updated AS updated_2, t0.deck_id AS deck_id_3, t0.deck_area_id AS deck_area_id_4, t0.card_id AS card_id_5 FROM deck_area_card t0 WHERE t0.deck_area_id = ? AND t0.deck_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.number AS number_1,
  t0.updated AS updated_2,
  t0.deck_id AS deck_id_3,
  t0.deck_area_id AS deck_area_id_4,
  t0.card_id AS card_id_5
FROM
  deck_area_card t0
WHERE
  t0.deck_area_id = ?
  AND t0.deck_id = ?

SELECT t0.number AS number_1, t0.updated AS updated_2, t0.deck_id AS deck_id_3, t0.deck_area_id AS deck_area_id_4, t0.card_id AS card_id_5 FROM deck_area_card t0 WHERE t0.deck_area_id = 1 AND t0.deck_id = 16221;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 86)
4	App\Service\Decks\DeckDataManager->getUntapData (line 126)
5	App\Twig\DeckRuntime->getUntapData (line 31)
6	__TwigTemplate_8a6f090ce389adb0329d7e583ecbcf6f->doDisplay (line 422)
7	Twig\Template->yield (line 461)
8	Twig\Template->display (line 416)
9	Twig\Template->render (line 431)
10	Twig\TemplateWrapper->render (line 53)
11	Twig\Extension\CoreExtension->include (line 1575)
12	__TwigTemplate_7504d517113533dcfd4a35f4f602a266::block_body (line 197)
13	Twig\Template->yieldBlock (line 493)
14	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
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\DeckController->view (line 244)
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.03 ms
(0.31%)

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_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
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\DeckController->view (line 244)
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.94 ms
(0.28%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = ? AND t0.category IN ('USER', 'VIDEOGRAPHER')

Parameters:

[
  1623
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.pseudo AS pseudo_3,
  t0.play_id AS play_id_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.reset_password_link AS reset_password_link_7,
  t0.last_login_date AS last_login_date_8,
  t0.facebook_id AS facebook_id_9,
  t0.facebook_access_token AS facebook_access_token_10,
  t0.google_id AS google_id_11,
  t0.discord_id AS discord_id_12,
  t0.seller_name AS seller_name_13,
  t0.achievements_points AS achievements_points_14,
  t0.nb_logins AS nb_logins_15,
  t0.nb_logins_in_arow AS nb_logins_in_arow_16,
  t0.max_logins_in_arow AS max_logins_in_arow_17,
  t0.capsule_count AS capsule_count_18,
  t0.api_id AS api_id_19,
  t0.credits AS credits_20,
  t0.cardnexus_mail AS cardnexus_mail_21,
  t0.creation_date AS creation_date_22,
  t0.update_date AS update_date_23,
  t0.avatar_id AS avatar_id_24,
  t0.data_player_id AS data_player_id_25,
  t0.country_id AS country_id_26,
  t0.department_id AS department_id_27,
  t0.website_id AS website_id_28,
  t0.category,
  t0.youtube_channel AS youtube_channel_29
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.category IN ('USER', 'VIDEOGRAPHER')

SELECT t0.id AS id_1, t0.email AS email_2, t0.pseudo AS pseudo_3, t0.play_id AS play_id_4, t0.roles AS roles_5, t0.password AS password_6, t0.reset_password_link AS reset_password_link_7, t0.last_login_date AS last_login_date_8, t0.facebook_id AS facebook_id_9, t0.facebook_access_token AS facebook_access_token_10, t0.google_id AS google_id_11, t0.discord_id AS discord_id_12, t0.seller_name AS seller_name_13, t0.achievements_points AS achievements_points_14, t0.nb_logins AS nb_logins_15, t0.nb_logins_in_arow AS nb_logins_in_arow_16, t0.max_logins_in_arow AS max_logins_in_arow_17, t0.capsule_count AS capsule_count_18, t0.api_id AS api_id_19, t0.credits AS credits_20, t0.cardnexus_mail AS cardnexus_mail_21, t0.creation_date AS creation_date_22, t0.update_date AS update_date_23, t0.avatar_id AS avatar_id_24, t0.data_player_id AS data_player_id_25, t0.country_id AS country_id_26, t0.department_id AS department_id_27, t0.website_id AS website_id_28, t0.category, t0.youtube_channel AS youtube_channel_29 FROM user t0 WHERE t0.id = 1623 AND t0.category IN ('USER', 'VIDEOGRAPHER');

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 784)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2726)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 269)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 496)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 748)
9	Doctrine\ORM\EntityRepository->findOneBy (line 126)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 94)
11	App\Controller\DeckController->view (line 225)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
14	Symfony\Component\HttpKernel\Kernel->handle (line 205)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
16	require_once (line 32)
17	require_once (line 5)

0.88 ms
(0.26%)

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	Twig\Extension\CoreExtension::getAttribute (line 1869)
5	__TwigTemplate_7504d517113533dcfd4a35f4f602a266::block_body (line 183)
6	Twig\Template->yieldBlock (line 493)
7	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
8	Twig\Template->yield (line 461)
9	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
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	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\DeckController->view (line 244)
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.86 ms
(0.26%)

SELECT t0.number AS number_1, t0.updated AS updated_2, t0.deck_id AS deck_id_3, t0.deck_area_id AS deck_area_id_4, t0.card_id AS card_id_5 FROM deck_area_card t0 WHERE t0.deck_id = ?

Parameters:

[
  16221
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.number AS number_1,
  t0.updated AS updated_2,
  t0.deck_id AS deck_id_3,
  t0.deck_area_id AS deck_area_id_4,
  t0.card_id AS card_id_5
FROM
  deck_area_card t0
WHERE
  t0.deck_id = ?

SELECT t0.number AS number_1, t0.updated AS updated_2, t0.deck_id AS deck_id_3, t0.deck_area_id AS deck_area_id_4, t0.card_id AS card_id_5 FROM deck_area_card t0 WHERE t0.deck_id = 16221;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
7	App\Entity\Deck->getNumbersOfCardsInArea (line 268)
8	Twig\Extension\CoreExtension->getAttribute (line 1996)
9	__TwigTemplate_8a6f090ce389adb0329d7e583ecbcf6f::doDisplay (line 144)
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\Extension\CoreExtension->include (line 1575)
15	__TwigTemplate_7504d517113533dcfd4a35f4f602a266::block_body (line 197)
16	Twig\Template->yieldBlock (line 493)
17	__TwigTemplate_e3a2fa90063367e6c75c0f4d2df5b519->doDisplay (line 188)
18	Twig\Template->yield (line 461)
19	__TwigTemplate_7504d517113533dcfd4a35f4f602a266->doDisplay (line 64)
20	Twig\Template->yield (line 461)
21	Twig\Template->display (line 416)
22	Twig\Template->render (line 431)
23	Twig\TemplateWrapper->render (line 53)
24	Twig\Environment->render (line 343)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\DeckController->view (line 244)
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.79 ms
(0.24%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 458)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Service\ViewManager->generateView (line 71)
4	App\Controller\DeckController->view (line 230)
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)

0.43 ms
(0.13%)

INSERT INTO deck_view (view_date, ip, deck_id, user_id) VALUES (?, ?, ?, ?)

Parameters:

[
  "2026-11-10 19:42:44"
  "216.73.216.191"
  16221
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO deck_view (view_date, ip, deck_id, user_id)
VALUES
  (?, ?, ?, ?)

INSERT INTO deck_view (view_date, ip, deck_id, user_id) VALUES ('2026-11-10 19:42:44', '216.73.216.191', 16221, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1144)
4	Doctrine\ORM\UnitOfWork->commit (line 426)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\Service\ViewManager->generateView (line 71)
7	App\Controller\DeckController->view (line 230)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.40 ms
(0.12%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.nb_min_cards AS nb_min_cards_4, t0.nb_max_cards AS nb_max_cards_5, t0.filters AS filters_6, t0.sort_order AS sort_order_7, t0.untap_name AS untap_name_8, t0.drawable AS drawable_9, t0.deckbuilder_id AS deckbuilder_id_10 FROM deck_area t0 WHERE t0.deckbuilder_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.nb_min_cards AS nb_min_cards_4,
  t0.nb_max_cards AS nb_max_cards_5,
  t0.filters AS filters_6,
  t0.sort_order AS sort_order_7,
  t0.untap_name AS untap_name_8,
  t0.drawable AS drawable_9,
  t0.deckbuilder_id AS deckbuilder_id_10
FROM
  deck_area t0
WHERE
  t0.deckbuilder_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.nb_min_cards AS nb_min_cards_4, t0.nb_max_cards AS nb_max_cards_5, t0.filters AS filters_6, t0.sort_order AS sort_order_7, t0.untap_name AS untap_name_8, t0.drawable AS drawable_9, t0.deckbuilder_id AS deckbuilder_id_10 FROM deck_area t0 WHERE t0.deckbuilder_id = 1 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->getIterator (line 253)
7	App\Model\Item\DeckViewBuilder->buildBlocks (line 28)
8	App\Model\Item\ItemViewDirector->constructItemView (line 25)
9	App\Controller\DeckController->view (line 234)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
12	Symfony\Component\HttpKernel\Kernel->handle (line 205)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.38 ms
(0.11%)

UPDATE deck SET view_count = ?, update_date = ? WHERE id = ?

Parameters:

[
  699
  "2026-11-10 19:42:44"
  16221
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  deck
SET
  view_count = ?,
  update_date = ?
WHERE
  id = ?

UPDATE deck SET view_count = 699, update_date = '2026-11-10 19:42:44' WHERE id = 16221;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 496)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 380)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1228)
4	Doctrine\ORM\UnitOfWork->commit (line 433)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\Service\ViewManager->generateView (line 71)
7	App\Controller\DeckController->view (line 230)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.22 ms
(0.06%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 405)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\Service\ViewManager->generateView (line 71)
4	App\Controller\DeckController->view (line 230)
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)

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\Card	27
App\Entity\Deckbuilder\DeckAreaCard	26
App\Entity\GroupVersion	25
App\Entity\Rarity	7
App\Entity\CardType	6
App\Entity\Serie	6
App\Entity\Serie\SerieType	4
App\Entity\Deckbuilder\DeckArea	3
App\Entity\Language	2
App\Entity\WebSite	1
App\Entity\Settings\FormFilter	1
App\Entity\Deck	1
App\Entity\User	1
App\Entity\Avatar\Avatar	1
App\Entity\Era	1
App\Entity\View\DeckView	1
App\Entity\Deckbuilder\Deckbuilder	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\Deck	No errors.
App\Entity\Card	No errors.
App\Entity\Era	No errors.
App\Entity\CardType	No errors.
App\Entity\Serie	No errors.
App\Entity\Rarity	No errors.
App\Entity\GroupVersion	No errors.
App\Entity\Avatar\Avatar	No errors.
App\Entity\CardVersion	No errors.
App\Entity\Card\CardVersionAnnotation	No errors.
App\Entity\Event\Event	No errors.
App\Entity\Shop\ShopTournamentPlayer	No errors.
App\Entity\Map\Country	No errors.
App\Entity\Map\Department	No errors.
App\Entity\Video\Videographer	No errors.
App\Entity\Wishlist	No errors.
App\Entity\CardOwned	No errors.
App\Entity\Product\ProductOwned	No errors.
App\Entity\Partnership\CardmarketClick	No errors.
App\Entity\Achievement\AchievementUser	No errors.
App\Entity\Avatar\AvatarUser	No errors.
App\Entity\User\UserLogin	No errors.
App\Entity\User\CapsuleMovement	No errors.
App\Entity\Partnership\GoupiyaClick	No errors.
App\Entity\Search\UserSearch	No errors.
App\Entity\User\CardSale	No errors.
App\Entity\User\UserSettings	No errors.
App\Entity\Shop\Shop	No errors.
App\Entity\User\UserTutorial	No errors.
App\Entity\Video\VideoReview	No errors.
App\Entity\User\Friend\Request	No errors.
App\Entity\User\LeagueStats	No errors.
App\Entity\Deckbuilder\DeckAreaCard	No errors.
App\Entity\View\DeckView	No errors.
App\Entity\Partnership\UntapClick	No errors.
App\Entity\SnapshotDeck	No errors.
App\Entity\Video\Video	No errors.
App\Entity\Character	No errors.
App\Entity\SpecialTrait	No errors.
App\Entity\Color	No errors.
App\Entity\Snapshot	No errors.
App\Entity\Skill	No errors.
App\Entity\Card\Timing	No errors.
App\Entity\CardTag	No errors.
App\Entity\WishlistCard	No errors.
App\Entity\FAQ	No errors.
App\Entity\Errata	No errors.
App\Entity\CardAssociation	No errors.
App\Entity\Product\Product	No errors.
App\Entity\View\CardView	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.
App\Entity\Deckbuilder\Deckbuilder	No errors.
App\Entity\Deckbuilder\DeckArea	No errors.
App\Entity\Deckbuilder\DeckBuilderSkill	No errors.
App\Entity\Serie\SerieType	No errors.
App\Entity\SerieRarity	No errors.

Symfony Profiler

GET https://dev.tcgcards.fr/decks/view/e1b320b5dc6f0b5e97913ff8a67074b080e9b43d

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping