Symfony Profiler

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

Query Metrics

SELECT SUBSTRING(h0_.created_at FROM 1 FOR 10) AS sclr_0, COUNT(h0_.id) AS sclr_1 FROM hostess_check_in h0_ WHERE h0_.congress_id = ? GROUP BY sclr_0 ORDER BY sclr_0 ASC

[
  17
]

SELECT
  SUBSTRING(
    h0_.created_at
    FROM
      1 FOR 10
  ) AS sclr_0,
  COUNT(h0_.id) AS sclr_1
FROM
  hostess_check_in h0_
WHERE
  h0_.congress_id = ?
GROUP BY
  sclr_0
ORDER BY
  sclr_0 ASC

SELECT SUBSTRING(h0_.created_at FROM 1 FOR 10) AS sclr_0, COUNT(h0_.id) AS sclr_1 FROM hostess_check_in h0_ WHERE h0_.congress_id = 17 GROUP BY sclr_0 ORDER BY sclr_0 ASC;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.shortname AS shortname_2, c0_.language AS language_3, c0_.logo AS logo_4, c0_.active AS active_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.prefix AS prefix_8, c0_.display_code_app AS display_code_app_9, c0_.mail AS mail_10 FROM congress c0_ WHERE c0_.active = 1 OR c0_.id IN (SELECT h1_.congress_id AS sclr_11 FROM hostess_check_in h1_ WHERE h1_.congress_id IS NOT NULL) ORDER BY c0_.start_date DESC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.shortname AS shortname_2,
  c0_.language AS language_3,
  c0_.logo AS logo_4,
  c0_.active AS active_5,
  c0_.start_date AS start_date_6,
  c0_.end_date AS end_date_7,
  c0_.prefix AS prefix_8,
  c0_.display_code_app AS display_code_app_9,
  c0_.mail AS mail_10
FROM
  congress c0_
WHERE
  c0_.active = 1
  OR c0_.id IN (
    SELECT
      h1_.congress_id AS sclr_11
    FROM
      hostess_check_in h1_
    WHERE
      h1_.congress_id IS NOT NULL
  )
ORDER BY
  c0_.start_date DESC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.shortname AS shortname_2, c0_.language AS language_3, c0_.logo AS logo_4, c0_.active AS active_5, c0_.start_date AS start_date_6, c0_.end_date AS end_date_7, c0_.prefix AS prefix_8, c0_.display_code_app AS display_code_app_9, c0_.mail AS mail_10 FROM congress c0_ WHERE c0_.active = 1 OR c0_.id IN (SELECT h1_.congress_id AS sclr_11 FROM hostess_check_in h1_ WHERE h1_.congress_id IS NOT NULL) ORDER BY c0_.start_date DESC;

SELECT h0_.user_id AS sclr_0, u1_.username AS username_1, u1_.email AS email_2, SUM(CASE WHEN h0_.type = ? THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN h0_.type = ? THEN 1 ELSE 0 END) AS sclr_4, COUNT(h0_.id) AS sclr_5, SUM(h0_.points) AS sclr_6 FROM hostess_check_in h0_ INNER JOIN user u1_ ON h0_.user_id = u1_.id WHERE h0_.congress_id = ? GROUP BY h0_.user_id ORDER BY sclr_6 DESC

[
  "NEW"
  "EXISTING"
  17
]

SELECT
  h0_.user_id AS sclr_0,
  u1_.username AS username_1,
  u1_.email AS email_2,
  SUM(
    CASE WHEN h0_.type = ? THEN 1 ELSE 0 END
  ) AS sclr_3,
  SUM(
    CASE WHEN h0_.type = ? THEN 1 ELSE 0 END
  ) AS sclr_4,
  COUNT(h0_.id) AS sclr_5,
  SUM(h0_.points) AS sclr_6
FROM
  hostess_check_in h0_
  INNER JOIN user u1_ ON h0_.user_id = u1_.id
WHERE
  h0_.congress_id = ?
GROUP BY
  h0_.user_id
ORDER BY
  sclr_6 DESC

SELECT h0_.user_id AS sclr_0, u1_.username AS username_1, u1_.email AS email_2, SUM(CASE WHEN h0_.type = 'NEW' THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN h0_.type = 'EXISTING' THEN 1 ELSE 0 END) AS sclr_4, COUNT(h0_.id) AS sclr_5, SUM(h0_.points) AS sclr_6 FROM hostess_check_in h0_ INNER JOIN user u1_ ON h0_.user_id = u1_.id WHERE h0_.congress_id = 17 GROUP BY h0_.user_id ORDER BY sclr_6 DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.language AS language_4, t0.logo AS logo_5, t0.active AS active_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.prefix AS prefix_9, t0.display_code_app AS display_code_app_10, t0.mail AS mail_11 FROM congress t0 WHERE t0.active = ? LIMIT 1

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.shortname AS shortname_3,
  t0.language AS language_4,
  t0.logo AS logo_5,
  t0.active AS active_6,
  t0.start_date AS start_date_7,
  t0.end_date AS end_date_8,
  t0.prefix AS prefix_9,
  t0.display_code_app AS display_code_app_10,
  t0.mail AS mail_11
FROM
  congress t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.shortname AS shortname_3, t0.language AS language_4, t0.logo AS logo_5, t0.active AS active_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.prefix AS prefix_9, t0.display_code_app AS display_code_app_10, t0.mail AS mail_11 FROM congress t0 WHERE t0.active = 1 LIMIT 1;

SELECT h0_.id AS id_0, h0_.points AS points_1, h0_.type AS type_2, h0_.created_at AS created_at_3, u1_.username AS username_4, u1_.email AS email_5, m2_.firstname AS firstname_6, m2_.lastname AS lastname_7 FROM hostess_check_in h0_ INNER JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN member m2_ ON h0_.remote_id = m2_.remote_id WHERE h0_.congress_id = ? ORDER BY h0_.created_at DESC LIMIT 50

[
  17
]

SELECT
  h0_.id AS id_0,
  h0_.points AS points_1,
  h0_.type AS type_2,
  h0_.created_at AS created_at_3,
  u1_.username AS username_4,
  u1_.email AS email_5,
  m2_.firstname AS firstname_6,
  m2_.lastname AS lastname_7
FROM
  hostess_check_in h0_
  INNER JOIN user u1_ ON h0_.user_id = u1_.id
  LEFT JOIN member m2_ ON h0_.remote_id = m2_.remote_id
WHERE
  h0_.congress_id = ?
ORDER BY
  h0_.created_at DESC
LIMIT
  50

SELECT h0_.id AS id_0, h0_.points AS points_1, h0_.type AS type_2, h0_.created_at AS created_at_3, u1_.username AS username_4, u1_.email AS email_5, m2_.firstname AS firstname_6, m2_.lastname AS lastname_7 FROM hostess_check_in h0_ INNER JOIN user u1_ ON h0_.user_id = u1_.id LEFT JOIN member m2_ ON h0_.remote_id = m2_.remote_id WHERE h0_.congress_id = 17 ORDER BY h0_.created_at DESC LIMIT 50;