Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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

[
  "en"
  "2024-11-26 09:49:20"
  "2024-11-26 09:49:20"
]

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 09:49:20' AND w1_.end_date >= '2024-11-26 09:49:20' ORDER BY w1_.start_date DESC;

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
]

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);

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

[
  "en"
  1
  "AD"
  "PRINT"
  "SQUARE"
  "2024-11-26 09:49:20"
  "2024-11-26 09:49:20"
  1
  1
]

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 <= '2024-11-26 09:49:20' AND w0_.end_date >= '2024-11-26 09:49:20' AND w0_.show_in_print = 1 AND w0_.published = 1;