Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

11.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.51 ms
(63.72%)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.is_activated AS is_activated_2, w0_.start_date AS start_date_3, w0_.end_date AS end_date_4, w0_.custom_css AS custom_css_5, w0_.custom_javascript AS custom_javascript_6, w0_.preview_token AS preview_token_7, w0_.template_name AS template_name_8, w0_.survey_id AS survey_id_9 FROM wsc_contests w0_ WHERE w0_.is_activated = 1 AND w0_.start_date <= ? AND w0_.end_date >= ? AND w0_.name = ?

Parameters:

[
  "2024-11-26 13:43:02"
  "2024-11-26 13:43:02"
  "webSaver-FestiveCashbackFiesta"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.is_activated AS is_activated_2,
  w0_.start_date AS start_date_3,
  w0_.end_date AS end_date_4,
  w0_.custom_css AS custom_css_5,
  w0_.custom_javascript AS custom_javascript_6,
  w0_.preview_token AS preview_token_7,
  w0_.template_name AS template_name_8,
  w0_.survey_id AS survey_id_9
FROM
  wsc_contests w0_
WHERE
  w0_.is_activated = 1
  AND w0_.start_date <= ?
  AND w0_.end_date >= ?
  AND w0_.name = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.is_activated AS is_activated_2, w0_.start_date AS start_date_3, w0_.end_date AS end_date_4, w0_.custom_css AS custom_css_5, w0_.custom_javascript AS custom_javascript_6, w0_.preview_token AS preview_token_7, w0_.template_name AS template_name_8, w0_.survey_id AS survey_id_9 FROM wsc_contests w0_ WHERE w0_.is_activated = 1 AND w0_.start_date <= '2024-11-26 13:43:02' AND w0_.end_date >= '2024-11-26 13:43:02' AND w0_.name = 'webSaver-FestiveCashbackFiesta';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 40)
7	App\Repository\WscContestsRepository->findActivatedContestByName (line 161)
8	App\Controller\BaseController->getContest (line 70)
9	App\Controller\SecurityController->login (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.59 ms
(13.50%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_activated AS is_activated_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.custom_css AS custom_css_6, t0.custom_javascript AS custom_javascript_7, t0.preview_token AS preview_token_8, t0.template_name AS template_name_9, t0.survey_id AS survey_id_10 FROM wsc_contests t0 WHERE t0.id IN (?)

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_activated AS is_activated_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.custom_css AS custom_css_6,
  t0.custom_javascript AS custom_javascript_7,
  t0.preview_token AS preview_token_8,
  t0.template_name AS template_name_9,
  t0.survey_id AS survey_id_10
FROM
  wsc_contests t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_activated AS is_activated_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.custom_css AS custom_css_6, t0.custom_javascript AS custom_javascript_7, t0.preview_token AS preview_token_8, t0.template_name AS template_name_9, t0.survey_id AS survey_id_10 FROM wsc_contests t0 WHERE t0.id IN (24);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
7	Doctrine\ORM\AbstractQuery->execute (line 901)
8	Doctrine\ORM\AbstractQuery->getResult (line 47)
9	App\Repository\WscContestLocalesRepository->findLastActiveContestByLocale (line 120)
10	App\Controller\BaseController->checkContest (line 79)
11	App\EventSubscriber\WebsaverSubscriber->onKernelController (line 116)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

1.39 ms
(11.76%)

SELECT w0_.id AS id_0, w0_.locale AS locale_1, w0_.banner AS banner_2, w0_.name AS name_3, w0_.title AS title_4, w0_.content AS content_5, w0_.close_content AS close_content_6, w0_.rules AS rules_7, w0_.disclaimer AS disclaimer_8, w0_.carousel_caption AS carousel_caption_9, w0_.carousel_image_url AS carousel_image_url_10, w0_.carousel_image_link AS carousel_image_link_11, w0_.popup_image_url AS popup_image_url_12, w0_.popup_image_link AS popup_image_link_13, w0_.popup_caption AS popup_caption_14, w0_.contest_id AS contest_id_15 FROM wsc_contest_locale w0_ INNER JOIN wsc_contests w1_ ON w0_.contest_id = w1_.id WHERE w1_.is_activated = 1 AND w0_.locale = ? AND w1_.start_date <= ? AND w1_.end_date >= ? ORDER BY w1_.start_date DESC

Parameters:

[
  "en"
  "2024-11-26 13:43:02"
  "2024-11-26 13:43:02"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.locale AS locale_1,
  w0_.banner AS banner_2,
  w0_.name AS name_3,
  w0_.title AS title_4,
  w0_.content AS content_5,
  w0_.close_content AS close_content_6,
  w0_.rules AS rules_7,
  w0_.disclaimer AS disclaimer_8,
  w0_.carousel_caption AS carousel_caption_9,
  w0_.carousel_image_url AS carousel_image_url_10,
  w0_.carousel_image_link AS carousel_image_link_11,
  w0_.popup_image_url AS popup_image_url_12,
  w0_.popup_image_link AS popup_image_link_13,
  w0_.popup_caption AS popup_caption_14,
  w0_.contest_id AS contest_id_15
FROM
  wsc_contest_locale w0_
  INNER JOIN wsc_contests w1_ ON w0_.contest_id = w1_.id
WHERE
  w1_.is_activated = 1
  AND w0_.locale = ?
  AND w1_.start_date <= ?
  AND w1_.end_date >= ?
ORDER BY
  w1_.start_date DESC

SELECT w0_.id AS id_0, w0_.locale AS locale_1, w0_.banner AS banner_2, w0_.name AS name_3, w0_.title AS title_4, w0_.content AS content_5, w0_.close_content AS close_content_6, w0_.rules AS rules_7, w0_.disclaimer AS disclaimer_8, w0_.carousel_caption AS carousel_caption_9, w0_.carousel_image_url AS carousel_image_url_10, w0_.carousel_image_link AS carousel_image_link_11, w0_.popup_image_url AS popup_image_url_12, w0_.popup_image_link AS popup_image_link_13, w0_.popup_caption AS popup_caption_14, w0_.contest_id AS contest_id_15 FROM wsc_contest_locale w0_ INNER JOIN wsc_contests w1_ ON w0_.contest_id = w1_.id WHERE w1_.is_activated = 1 AND w0_.locale = 'en' AND w1_.start_date <= '2024-11-26 13:43:02' AND w1_.end_date >= '2024-11-26 13:43:02' ORDER BY w1_.start_date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\WscContestLocalesRepository->findLastActiveContestByLocale (line 120)
8	App\Controller\BaseController->checkContest (line 79)
9	App\EventSubscriber\WebsaverSubscriber->onKernelController (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

1.30 ms
(11.02%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.banner AS banner_3, t0.name AS name_4, t0.title AS title_5, t0.content AS content_6, t0.close_content AS close_content_7, t0.rules AS rules_8, t0.disclaimer AS disclaimer_9, t0.carousel_caption AS carousel_caption_10, t0.carousel_image_url AS carousel_image_url_11, t0.carousel_image_link AS carousel_image_link_12, t0.popup_image_url AS popup_image_url_13, t0.popup_image_link AS popup_image_link_14, t0.popup_caption AS popup_caption_15, t0.contest_id AS contest_id_16, t17.id AS id_18, t17.name AS name_19, t17.is_activated AS is_activated_20, t17.start_date AS start_date_21, t17.end_date AS end_date_22, t17.custom_css AS custom_css_23, t17.custom_javascript AS custom_javascript_24, t17.preview_token AS preview_token_25, t17.template_name AS template_name_26, t17.survey_id AS survey_id_27 FROM wsc_contest_locale t0 INNER JOIN wsc_contests t17 ON t0.contest_id = t17.id WHERE t0.contest_id = ?

Parameters:

[
  24
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.banner AS banner_3,
  t0.name AS name_4,
  t0.title AS title_5,
  t0.content AS content_6,
  t0.close_content AS close_content_7,
  t0.rules AS rules_8,
  t0.disclaimer AS disclaimer_9,
  t0.carousel_caption AS carousel_caption_10,
  t0.carousel_image_url AS carousel_image_url_11,
  t0.carousel_image_link AS carousel_image_link_12,
  t0.popup_image_url AS popup_image_url_13,
  t0.popup_image_link AS popup_image_link_14,
  t0.popup_caption AS popup_caption_15,
  t0.contest_id AS contest_id_16,
  t17.id AS id_18,
  t17.name AS name_19,
  t17.is_activated AS is_activated_20,
  t17.start_date AS start_date_21,
  t17.end_date AS end_date_22,
  t17.custom_css AS custom_css_23,
  t17.custom_javascript AS custom_javascript_24,
  t17.preview_token AS preview_token_25,
  t17.template_name AS template_name_26,
  t17.survey_id AS survey_id_27
FROM
  wsc_contest_locale t0
  INNER JOIN wsc_contests t17 ON t0.contest_id = t17.id
WHERE
  t0.contest_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.banner AS banner_3, t0.name AS name_4, t0.title AS title_5, t0.content AS content_6, t0.close_content AS close_content_7, t0.rules AS rules_8, t0.disclaimer AS disclaimer_9, t0.carousel_caption AS carousel_caption_10, t0.carousel_image_url AS carousel_image_url_11, t0.carousel_image_link AS carousel_image_link_12, t0.popup_image_url AS popup_image_url_13, t0.popup_image_link AS popup_image_link_14, t0.popup_caption AS popup_caption_15, t0.contest_id AS contest_id_16, t17.id AS id_18, t17.name AS name_19, t17.is_activated AS is_activated_20, t17.start_date AS start_date_21, t17.end_date AS end_date_22, t17.custom_css AS custom_css_23, t17.custom_javascript AS custom_javascript_24, t17.preview_token AS preview_token_25, t17.template_name AS template_name_26, t17.survey_id AS survey_id_27 FROM wsc_contest_locale t0 INNER JOIN wsc_contests t17 ON t0.contest_id = t17.id WHERE t0.contest_id = 24;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1830)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3289)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 250)
8	App\Entity\WscContests->getContestLocaleByLocale (line 72)
9	App\Controller\SecurityController->login (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	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.

Entities Mapping

Class	Mapping errors
App\Entity\WsUser	No errors.
App\Entity\WscContestLocales	No errors.
App\Entity\WscContests	No errors.
App\Entity\WsSurveys	No errors.
App\Entity\WscContestPages	No errors.
App\Entity\WsCoupons	No errors.

Symfony Profiler

GET https://dev.websaver.ca/en_ca/contest/webSaver-FestiveCashbackFiesta/login/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping