Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7 FROM users t0 WHERE t0.id = ?

[
  31
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.is_verified AS is_verified_7
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_verified AS is_verified_7 FROM users t0 WHERE t0.id = 31;

SELECT demographics.sid, first_name first, last_name last, cell_phone phone, school_email email, emailgroup email_group, IFNUll(r.sid ,0) is_bookmarked
            FROM demographics 
            left join (
            SELECT distinct sid FROM recents 
            where  user_id = 31 and is_bookmarked =1
            ) r ON r.sid = demographics.sid 
            WHERE demographics.sid = 22605

[]

SELECT
  demographics.sid,
  first_name first,
  last_name last,
  cell_phone phone,
  school_email email,
  emailgroup email_group,
  IFNUll(r.sid, 0) is_bookmarked
FROM
  demographics
  left join (
    SELECT
      distinct sid
    FROM
      recents
    where
      user_id = 31
      and is_bookmarked = 1
  ) r ON r.sid = demographics.sid
WHERE
  demographics.sid = 22605

SELECT demographics.sid, first_name first, last_name last, cell_phone phone, school_email email, emailgroup email_group, IFNUll(r.sid ,0) is_bookmarked
            FROM demographics 
            left join (
            SELECT distinct sid FROM recents 
            where  user_id = 31 and is_bookmarked =1
            ) r ON r.sid = demographics.sid 
            WHERE demographics.sid = 22605
            ;

SELECT td.id data_id, td.tag_id value_id, td.action_id,td.sid,td.user,td.note,td.date_start,td.date_end,td.date_followup,td.date_followup_end, 
            tv.name, tv.status_id, tv.color, tv.description, tv.message, tv.message_action, tv.access_by FROM tag_data td
                JOIN tag_values tv
                ON tv.id = td.tag_id
                WHERE sid = 22605 AND  (date_end > now() OR date_end is null)
                ORDER BY tv.color DESC

[]

SELECT
  td.id data_id,
  td.tag_id value_id,
  td.action_id,
  td.sid,
  td.user,
  td.note,
  td.date_start,
  td.date_end,
  td.date_followup,
  td.date_followup_end,
  tv.name,
  tv.status_id,
  tv.color,
  tv.description,
  tv.message,
  tv.message_action,
  tv.access_by
FROM
  tag_data td
  JOIN tag_values tv ON tv.id = td.tag_id
WHERE
  sid = 22605
  AND (
    date_end > now()
    OR date_end is null
  )
ORDER BY
  tv.color DESC

SELECT td.id data_id, td.tag_id value_id, td.action_id,td.sid,td.user,td.note,td.date_start,td.date_end,td.date_followup,td.date_followup_end, 
            tv.name, tv.status_id, tv.color, tv.description, tv.message, tv.message_action, tv.access_by FROM tag_data td
                JOIN tag_values tv
                ON tv.id = td.tag_id
                WHERE sid = 22605 AND  (date_end > now() OR date_end is null)
                ORDER BY tv.color DESC
        ;

SELECT COUNT(*) FROM recents t0 WHERE t0.sid = ? AND t0.user_id = ? AND t0.date_worked = ?

[
  "22605"
  31
  "2025-09-16"
]

SELECT
  COUNT(*)
FROM
  recents t0
WHERE
  t0.sid = ?
  AND t0.user_id = ?
  AND t0.date_worked = ?

SELECT COUNT(*) FROM recents t0 WHERE t0.sid = '22605' AND t0.user_id = 31 AND t0.date_worked = '2025-09-16';

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO recents (sid, user_id, date_worked, created, is_bookmarked) VALUES (?, ?, ?, ?, ?)

[
  22605
  31
  "2025-09-16"
  "2025-09-17 00:46:25"
  0
]

INSERT INTO recents (
  sid, user_id, date_worked, created,
  is_bookmarked
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO recents (sid, user_id, date_worked, created, is_bookmarked) VALUES (22605, 31, '2025-09-16', '2025-09-17 00:46:25', 0);

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT  x.created,x.sid, d.first_name, d.last_name 
            From (SELECT max(created) created, sid FROM recents
            where  user_id = 31
            group by sid
            )x
            JOIN demographics d ON d.sid=x.sid 
            ORDER BY x.created DESC
            LIMIT 10;

[]

SELECT
  x.created,
  x.sid,
  d.first_name,
  d.last_name
From
  (
    SELECT
      max(created) created,
      sid
    FROM
      recents
    where
      user_id = 31
    group by
      sid
  ) x
  JOIN demographics d ON d.sid = x.sid
ORDER BY
  x.created DESC
LIMIT
  10;

SELECT  x.created,x.sid, d.first_name, d.last_name 
            From (SELECT max(created) created, sid FROM recents
            where  user_id = 31
            group by sid
            )x
            JOIN demographics d ON d.sid=x.sid 
            ORDER BY x.created DESC
            LIMIT 10;;