Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

19.06 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.37 ms
(75.38%)

SELECT w0_.position AS position_0, w1_.id AS id_1, w1_.name AS name_2, w1_.locale AS locale_3, w1_.image AS image_4, w1_.image_mobile AS image_mobile_5, w1_.html_code AS html_code_6, w1_.link AS link_7, w1_.clickthrough_count AS clickthrough_count_8, w1_.created_date AS created_date_9, w0_.id AS id_10, w0_.ad_long_id AS ad_long_id_11, w0_.name AS name_12, w0_.status AS status_13, w0_.start_date AS start_date_14, w0_.end_date AS end_date_15, w0_.ads_type AS ads_type_16, w0_.show_in_thank_you AS show_in_thank_you_17, w0_.show_in_dc AS show_in_dc_18, w0_.show_in_print AS show_in_print_19, w0_.active AS active_20, w0_.published AS published_21, w0_.position AS position_22, w2_.id AS id_23, w2_.name AS name_24, w2_.asset_type AS asset_type_25, w2_.position AS position_26, w2_.coupon_type AS coupon_type_27, w2_.date_modified AS date_modified_28, w1_.ad_id AS ad_id_29, w0_.brand_id AS brand_id_30, w2_.asset_id AS asset_id_31 FROM ws_ads_locale w1_ INNER JOIN ws_ads w0_ ON w1_.ad_id = w0_.id INNER JOIN ws_position_ads_coupons w2_ ON w0_.id = w2_.asset_id WHERE w1_.locale = ? AND w0_.active = ? AND w2_.asset_type = ? AND w2_.coupon_type = ? AND w0_.ads_type = ? AND w0_.start_date <= ? AND w0_.end_date >= ? AND w0_.show_in_print = ? AND w0_.published = ?

Parameters:

[
  "en"
  1
  "AD"
  "PRINT"
  "SQUARE"
  "2025-01-18 01:44:59"
  "2025-01-18 01:44:59"
  1
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.position AS position_0,
  w1_.id AS id_1,
  w1_.name AS name_2,
  w1_.locale AS locale_3,
  w1_.image AS image_4,
  w1_.image_mobile AS image_mobile_5,
  w1_.html_code AS html_code_6,
  w1_.link AS link_7,
  w1_.clickthrough_count AS clickthrough_count_8,
  w1_.created_date AS created_date_9,
  w0_.id AS id_10,
  w0_.ad_long_id AS ad_long_id_11,
  w0_.name AS name_12,
  w0_.status AS status_13,
  w0_.start_date AS start_date_14,
  w0_.end_date AS end_date_15,
  w0_.ads_type AS ads_type_16,
  w0_.show_in_thank_you AS show_in_thank_you_17,
  w0_.show_in_dc AS show_in_dc_18,
  w0_.show_in_print AS show_in_print_19,
  w0_.active AS active_20,
  w0_.published AS published_21,
  w0_.position AS position_22,
  w2_.id AS id_23,
  w2_.name AS name_24,
  w2_.asset_type AS asset_type_25,
  w2_.position AS position_26,
  w2_.coupon_type AS coupon_type_27,
  w2_.date_modified AS date_modified_28,
  w1_.ad_id AS ad_id_29,
  w0_.brand_id AS brand_id_30,
  w2_.asset_id AS asset_id_31
FROM
  ws_ads_locale w1_
  INNER JOIN ws_ads w0_ ON w1_.ad_id = w0_.id
  INNER JOIN ws_position_ads_coupons w2_ ON w0_.id = w2_.asset_id
WHERE
  w1_.locale = ?
  AND w0_.active = ?
  AND w2_.asset_type = ?
  AND w2_.coupon_type = ?
  AND w0_.ads_type = ?
  AND w0_.start_date <= ?
  AND w0_.end_date >= ?
  AND w0_.show_in_print = ?
  AND w0_.published = ?

SELECT w0_.position AS position_0, w1_.id AS id_1, w1_.name AS name_2, w1_.locale AS locale_3, w1_.image AS image_4, w1_.image_mobile AS image_mobile_5, w1_.html_code AS html_code_6, w1_.link AS link_7, w1_.clickthrough_count AS clickthrough_count_8, w1_.created_date AS created_date_9, w0_.id AS id_10, w0_.ad_long_id AS ad_long_id_11, w0_.name AS name_12, w0_.status AS status_13, w0_.start_date AS start_date_14, w0_.end_date AS end_date_15, w0_.ads_type AS ads_type_16, w0_.show_in_thank_you AS show_in_thank_you_17, w0_.show_in_dc AS show_in_dc_18, w0_.show_in_print AS show_in_print_19, w0_.active AS active_20, w0_.published AS published_21, w0_.position AS position_22, w2_.id AS id_23, w2_.name AS name_24, w2_.asset_type AS asset_type_25, w2_.position AS position_26, w2_.coupon_type AS coupon_type_27, w2_.date_modified AS date_modified_28, w1_.ad_id AS ad_id_29, w0_.brand_id AS brand_id_30, w2_.asset_id AS asset_id_31 FROM ws_ads_locale w1_ INNER JOIN ws_ads w0_ ON w1_.ad_id = w0_.id INNER JOIN ws_position_ads_coupons w2_ ON w0_.id = w2_.asset_id WHERE w1_.locale = 'en' AND w0_.active = 1 AND w2_.asset_type = 'AD' AND w2_.coupon_type = 'PRINT' AND w0_.ads_type = 'SQUARE' AND w0_.start_date <= '2025-01-18 01:44:59' AND w0_.end_date >= '2025-01-18 01:44:59' AND w0_.show_in_print = 1 AND w0_.published = 1;

#	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 57)
7	App\Repository\WsAdLocalesRepository->findActivatedPartnerCoupons (line 15)
8	App\Controller\CouponController->indexAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

4.69 ms
(24.62%)

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"
  "2025-01-18 01:44:59"
  "2025-01-18 01:44:59"
]

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 <= '2025-01-18 01:44:59' AND w1_.end_date >= '2025-01-18 01:44:59' 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)

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\WsAdLocales	No errors.
App\Entity\WsAds	No errors.
App\Entity\WsAdPositions	No errors.
App\Entity\WsBrands	No errors.
App\Entity\WsAdClickThrough	No errors.

Symfony Profiler

GET https://dev.websaver.ca/en_ca/coupons/

Configuration Settings

Theme