Symfony Profiler

Query Metrics

52 Database Queries

3 Different statements

51.64 ms Query time

0 Invalid entities

58 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

44.06 ms
(85.32%)

SELECT t0.id AS id_1, t0.exhausts_ticket AS exhausts_ticket_2, t0.discount_type AS discount_type_3, t0.discount_value AS discount_value_4, t0.required_to_view AS required_to_view_5, t0.required_to_register AS required_to_register_6, t0.ticket_id AS ticket_id_7, t0.event_id AS event_id_8 FROM ticket_consumer t0 WHERE t0.event_id = ?

Parameters:

[
  2210
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.exhausts_ticket AS exhausts_ticket_2,
  t0.discount_type AS discount_type_3,
  t0.discount_value AS discount_value_4,
  t0.required_to_view AS required_to_view_5,
  t0.required_to_register AS required_to_register_6,
  t0.ticket_id AS ticket_id_7,
  t0.event_id AS event_id_8
FROM
  ticket_consumer t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.exhausts_ticket AS exhausts_ticket_2, t0.discount_type AS discount_type_3, t0.discount_value AS discount_value_4, t0.required_to_view AS required_to_view_5, t0.required_to_register AS required_to_register_6, t0.ticket_id AS ticket_id_7, t0.event_id AS event_id_8 FROM ticket_consumer t0 WHERE t0.event_id = 2210;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 668)
8	App\Entity\Event->isTicketRequiredToView (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 253)
10	__TwigTemplate_a65b5b5b685f41b7d9f537ca4f8f307c->block_fullpage (line 446)
11	Twig\Template->yieldBlock (line 199)
12	__TwigTemplate_ebc8499bfea252d6deeb84f650457d84->doDisplay (line 402)
13	Twig\Template->yield (line 56)
14	__TwigTemplate_a65b5b5b685f41b7d9f537ca4f8f307c->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 56)
23	App\Controller\ConventionController->app_convention_id_embed (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

6.61 ms
(12.80%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.flags AS flags_7, t0.starts_at AS starts_at_8, t0.registration_fee AS registration_fee_9, t0.max_registration AS max_registration_10, t0.team_size AS team_size_11, t0.registration_open_at AS registration_open_at_12, t0.registration_closed_at AS registration_closed_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.format AS format_16, t0.game AS game_17, t0.tags AS tags_18, t0.prizes AS prizes_19, t0.required_data AS required_data_20, t0.player_note AS player_note_21, t0.public AS public_22, t0.starting_table AS starting_table_23, t0.additional_metadata AS additional_metadata_24, t0.event_timer AS event_timer_25, t0.event_color AS event_color_26, t0.external_registration_url AS external_registration_url_27, t0.featured AS featured_28, t0.image AS image_29, t0.queue_type AS queue_type_30, t0.convention_id AS convention_id_31 FROM event t0 WHERE t0.convention_id = ?

Parameters:

[
  58
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.description AS description_5,
  t0.enabled AS enabled_6,
  t0.flags AS flags_7,
  t0.starts_at AS starts_at_8,
  t0.registration_fee AS registration_fee_9,
  t0.max_registration AS max_registration_10,
  t0.team_size AS team_size_11,
  t0.registration_open_at AS registration_open_at_12,
  t0.registration_closed_at AS registration_closed_at_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.format AS format_16,
  t0.game AS game_17,
  t0.tags AS tags_18,
  t0.prizes AS prizes_19,
  t0.required_data AS required_data_20,
  t0.player_note AS player_note_21,
  t0.public AS public_22,
  t0.starting_table AS starting_table_23,
  t0.additional_metadata AS additional_metadata_24,
  t0.event_timer AS event_timer_25,
  t0.event_color AS event_color_26,
  t0.external_registration_url AS external_registration_url_27,
  t0.featured AS featured_28,
  t0.image AS image_29,
  t0.queue_type AS queue_type_30,
  t0.convention_id AS convention_id_31
FROM
  event t0
WHERE
  t0.convention_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.flags AS flags_7, t0.starts_at AS starts_at_8, t0.registration_fee AS registration_fee_9, t0.max_registration AS max_registration_10, t0.team_size AS team_size_11, t0.registration_open_at AS registration_open_at_12, t0.registration_closed_at AS registration_closed_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.format AS format_16, t0.game AS game_17, t0.tags AS tags_18, t0.prizes AS prizes_19, t0.required_data AS required_data_20, t0.player_note AS player_note_21, t0.public AS public_22, t0.starting_table AS starting_table_23, t0.additional_metadata AS additional_metadata_24, t0.event_timer AS event_timer_25, t0.event_color AS event_color_26, t0.external_registration_url AS external_registration_url_27, t0.featured AS featured_28, t0.image AS image_29, t0.queue_type AS queue_type_30, t0.convention_id AS convention_id_31 FROM event t0 WHERE t0.convention_id = 58;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 46)
8	App\Controller\ConventionController->app_convention_id_embed (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.97 ms
(1.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.location AS location_5, t0.currency AS currency_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.logo AS logo_9, t0.background AS background_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.country AS country_13, t0.timezone AS timezone_14, t0.public AS public_15, t0.game AS game_16, t0.flags AS flags_17, t0.tax_rate_id AS tax_rate_id_18 FROM convention t0 WHERE t0.id = ?

Parameters:

[
  "58"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.enabled AS enabled_4,
  t0.location AS location_5,
  t0.currency AS currency_6,
  t0.start_date AS start_date_7,
  t0.end_date AS end_date_8,
  t0.logo AS logo_9,
  t0.background AS background_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.country AS country_13,
  t0.timezone AS timezone_14,
  t0.public AS public_15,
  t0.game AS game_16,
  t0.flags AS flags_17,
  t0.tax_rate_id AS tax_rate_id_18
FROM
  convention t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.location AS location_5, t0.currency AS currency_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.logo AS logo_9, t0.background AS background_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.country AS country_13, t0.timezone AS timezone_14, t0.public AS public_15, t0.game AS game_16, t0.flags AS flags_17, t0.tax_rate_id AS tax_rate_id_18 FROM convention t0 WHERE t0.id = '58';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Event	50
App\Entity\TicketConsumer	4
App\Entity\Ticket	2
App\Entity\Convention	1
App\Entity\TaxRate	1

Entities Mapping

Class	Mapping errors
App\Entity\Convention	No errors.
App\Entity\TaxRate	No errors.
App\Entity\Event	No errors.
App\Entity\Ticket	No errors.
App\Entity\Display	No errors.
App\Entity\PrizeWall	No errors.
App\Entity\Registration	No errors.
App\Entity\EventTicket	No errors.
App\Entity\TicketConsumer	No errors.
App\Entity\TournamentQueue	No errors.
App\Entity\DisplaySlide	No errors.
App\Entity\EventConnection	No errors.

Symfony Profiler

GET https://fanfinity.playerlink.online/convention/58/embed

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping