Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 8
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• HTTP Client
• Migrations 74
• Httplug 0/0
• E-mails
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary_intro AS summary_intro_3, t0.summary_epilog AS summary_epilog_4, t0.additional_description AS additional_description_5, t0.parameters AS parameters_6, t0.parameters_structure AS parameters_structure_7, t0.author AS author_8, t0.publicated_at AS publicated_at_9, t0.state AS state_10, t0.is_deleted AS is_deleted_11, t0.created_at AS created_at_12, t0.lastmod_at AS lastmod_at_13, t0.users_id AS users_id_14, t0.restricted AS restricted_15, t0.users_id AS users_id_16 FROM scenario t0 WHERE t0.restricted = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.summary_intro AS summary_intro_3,
  t0.summary_epilog AS summary_epilog_4,
  t0.additional_description AS additional_description_5,
  t0.parameters AS parameters_6,
  t0.parameters_structure AS parameters_structure_7,
  t0.author AS author_8,
  t0.publicated_at AS publicated_at_9,
  t0.state AS state_10,
  t0.is_deleted AS is_deleted_11,
  t0.created_at AS created_at_12,
  t0.lastmod_at AS lastmod_at_13,
  t0.users_id AS users_id_14,
  t0.restricted AS restricted_15,
  t0.users_id AS users_id_16
FROM
  scenario t0
WHERE
  t0.restricted = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.summary_intro AS summary_intro_3, t0.summary_epilog AS summary_epilog_4, t0.additional_description AS additional_description_5, t0.parameters AS parameters_6, t0.parameters_structure AS parameters_structure_7, t0.author AS author_8, t0.publicated_at AS publicated_at_9, t0.state AS state_10, t0.is_deleted AS is_deleted_11, t0.created_at AS created_at_12, t0.lastmod_at AS lastmod_at_13, t0.users_id AS users_id_14, t0.restricted AS restricted_15, t0.users_id AS users_id_16 FROM scenario t0 WHERE t0.restricted = 1 LIMIT 1;

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.summary_intro AS summary_intro_2, s0_.summary_epilog AS summary_epilog_3, s0_.additional_description AS additional_description_4, s0_.parameters AS parameters_5, s0_.parameters_structure AS parameters_structure_6, s0_.author AS author_7, s0_.publicated_at AS publicated_at_8, s0_.state AS state_9, s0_.is_deleted AS is_deleted_10, s0_.created_at AS created_at_11, s0_.lastmod_at AS lastmod_at_12, s0_.users_id AS users_id_13, s0_.restricted AS restricted_14, s0_.users_id AS users_id_15 FROM scenario s0_ WHERE s0_.is_deleted = ? AND s0_.state = ? ORDER BY s0_.created_at DESC LIMIT 3

[
  0
  1
]

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.summary_intro AS summary_intro_2,
  s0_.summary_epilog AS summary_epilog_3,
  s0_.additional_description AS additional_description_4,
  s0_.parameters AS parameters_5,
  s0_.parameters_structure AS parameters_structure_6,
  s0_.author AS author_7,
  s0_.publicated_at AS publicated_at_8,
  s0_.state AS state_9,
  s0_.is_deleted AS is_deleted_10,
  s0_.created_at AS created_at_11,
  s0_.lastmod_at AS lastmod_at_12,
  s0_.users_id AS users_id_13,
  s0_.restricted AS restricted_14,
  s0_.users_id AS users_id_15
FROM
  scenario s0_
WHERE
  s0_.is_deleted = ?
  AND s0_.state = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  3

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.summary_intro AS summary_intro_2, s0_.summary_epilog AS summary_epilog_3, s0_.additional_description AS additional_description_4, s0_.parameters AS parameters_5, s0_.parameters_structure AS parameters_structure_6, s0_.author AS author_7, s0_.publicated_at AS publicated_at_8, s0_.state AS state_9, s0_.is_deleted AS is_deleted_10, s0_.created_at AS created_at_11, s0_.lastmod_at AS lastmod_at_12, s0_.users_id AS users_id_13, s0_.restricted AS restricted_14, s0_.users_id AS users_id_15 FROM scenario s0_ WHERE s0_.is_deleted = 0 AND s0_.state = 1 ORDER BY s0_.created_at DESC LIMIT 3;

SELECT m0_.id AS id_0, m0_.category AS category_1, m0_.filename AS filename_2, m0_.media_name AS media_name_3, m0_.description AS description_4, m0_.media_order AS media_order_5, m0_.active AS active_6, m0_.is_deleted AS is_deleted_7, m0_.created_at AS created_at_8, m0_.lastmod_at AS lastmod_at_9, m0_.scenario_id AS scenario_id_10, m0_.node_id AS node_id_11, m0_.link_id AS link_id_12, m0_.mcq_id AS mcq_id_13, m0_.users_id AS users_id_14, m0_.preview_filename AS preview_filename_15, m0_.use_prview_image AS use_prview_image_16, m0_.media_flag AS media_flag_17, m0_.scenario_id AS scenario_id_18, m0_.node_id AS node_id_19, m0_.link_id AS link_id_20, m0_.mcq_id AS mcq_id_21, m0_.users_id AS users_id_22 FROM media m0_ WHERE m0_.scenario_id IN (0, 17, 3) AND m0_.filename IS NOT NULL AND m0_.category = ? AND m0_.is_deleted = ? AND m0_.active = ?

[
  1
  0
  1
]

SELECT
  m0_.id AS id_0,
  m0_.category AS category_1,
  m0_.filename AS filename_2,
  m0_.media_name AS media_name_3,
  m0_.description AS description_4,
  m0_.media_order AS media_order_5,
  m0_.active AS active_6,
  m0_.is_deleted AS is_deleted_7,
  m0_.created_at AS created_at_8,
  m0_.lastmod_at AS lastmod_at_9,
  m0_.scenario_id AS scenario_id_10,
  m0_.node_id AS node_id_11,
  m0_.link_id AS link_id_12,
  m0_.mcq_id AS mcq_id_13,
  m0_.users_id AS users_id_14,
  m0_.preview_filename AS preview_filename_15,
  m0_.use_prview_image AS use_prview_image_16,
  m0_.media_flag AS media_flag_17,
  m0_.scenario_id AS scenario_id_18,
  m0_.node_id AS node_id_19,
  m0_.link_id AS link_id_20,
  m0_.mcq_id AS mcq_id_21,
  m0_.users_id AS users_id_22
FROM
  media m0_
WHERE
  m0_.scenario_id IN (0, 17, 3)
  AND m0_.filename IS NOT NULL
  AND m0_.category = ?
  AND m0_.is_deleted = ?
  AND m0_.active = ?

SELECT m0_.id AS id_0, m0_.category AS category_1, m0_.filename AS filename_2, m0_.media_name AS media_name_3, m0_.description AS description_4, m0_.media_order AS media_order_5, m0_.active AS active_6, m0_.is_deleted AS is_deleted_7, m0_.created_at AS created_at_8, m0_.lastmod_at AS lastmod_at_9, m0_.scenario_id AS scenario_id_10, m0_.node_id AS node_id_11, m0_.link_id AS link_id_12, m0_.mcq_id AS mcq_id_13, m0_.users_id AS users_id_14, m0_.preview_filename AS preview_filename_15, m0_.use_prview_image AS use_prview_image_16, m0_.media_flag AS media_flag_17, m0_.scenario_id AS scenario_id_18, m0_.node_id AS node_id_19, m0_.link_id AS link_id_20, m0_.mcq_id AS mcq_id_21, m0_.users_id AS users_id_22 FROM media m0_ WHERE m0_.scenario_id IN (0, 17, 3) AND m0_.filename IS NOT NULL AND m0_.category = 1 AND m0_.is_deleted = 0 AND m0_.active = 1;

SELECT u0_.id AS id_0, u0_.username AS username_1, COUNT(p1_.scenario_id) AS sclr_2, SUM(p1_.score) AS sclr_3 FROM player_sessionhist p1_ INNER JOIN users u0_ ON p1_.users_id = u0_.id WHERE p1_.is_ended = 1 AND u0_.is_deleted = false GROUP BY u0_.id ORDER BY sclr_3 DESC LIMIT 5

[]

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  COUNT(p1_.scenario_id) AS sclr_2,
  SUM(p1_.score) AS sclr_3
FROM
  player_sessionhist p1_
  INNER JOIN users u0_ ON p1_.users_id = u0_.id
WHERE
  p1_.is_ended = 1
  AND u0_.is_deleted = false
GROUP BY
  u0_.id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT u0_.id AS id_0, u0_.username AS username_1, COUNT(p1_.scenario_id) AS sclr_2, SUM(p1_.score) AS sclr_3 FROM player_sessionhist p1_ INNER JOIN users u0_ ON p1_.users_id = u0_.id WHERE p1_.is_ended = 1 AND u0_.is_deleted = false GROUP BY u0_.id ORDER BY sclr_3 DESC LIMIT 5;

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.title AS title_3, t0.content AS content_4, t0.display AS display_5 FROM page_content t0 WHERE t0.alias = ? LIMIT 1

[
  "home"
]

SELECT
  t0.id AS id_1,
  t0.alias AS alias_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.display AS display_5
FROM
  page_content t0
WHERE
  t0.alias = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.title AS title_3, t0.content AS content_4, t0.display AS display_5 FROM page_content t0 WHERE t0.alias = 'home' LIMIT 1;

SELECT p0_.alias AS alias_0, p0_.display AS display_1 FROM page_content p0_ WHERE p0_.display = true ORDER BY p0_.id ASC

[]

SELECT
  p0_.alias AS alias_0,
  p0_.display AS display_1
FROM
  page_content p0_
WHERE
  p0_.display = true
ORDER BY
  p0_.id ASC

SELECT p0_.alias AS alias_0, p0_.display AS display_1 FROM page_content p0_ WHERE p0_.display = true ORDER BY p0_.id ASC;