Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 26
• 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 first_name, last_name, sid FROM demographics WHERE sid ='22605'

[]

SELECT
  first_name,
  last_name,
  sid
FROM
  demographics
WHERE
  sid = '22605'

SELECT first_name, last_name, sid FROM demographics WHERE sid ='22605' ;

SELECT clin_weeks_req requiredWeeks, clin_weeks_paid paidWeeks FROM attending WHERE sid='22605'

[]

SELECT
  clin_weeks_req requiredWeeks,
  clin_weeks_paid paidWeeks
FROM
  attending
WHERE
  sid = '22605'

SELECT clin_weeks_req requiredWeeks, clin_weeks_paid paidWeeks FROM attending WHERE sid='22605';

SELECT sum(dur_weeks) total FROM clinical WHERE sid = 22605

[]

SELECT
  sum(dur_weeks) total
FROM
  clinical
WHERE
  sid = 22605

SELECT sum(dur_weeks) total FROM clinical WHERE sid = 22605;

SELECT SUM(dur_weeks) AS completeWeeks FROM clinical WHERE sid='22605' AND letter_grade is not null AND number_grade is not null

[]

SELECT
  SUM(dur_weeks) AS completeWeeks
FROM
  clinical
WHERE
  sid = '22605'
  AND letter_grade is not null
  AND number_grade is not null

SELECT SUM(dur_weeks) AS completeWeeks FROM clinical WHERE sid='22605' AND letter_grade is not null AND number_grade is not null;

SELECT SUM(dur_weeks) AS scheduledWeeks FROM clinical WHERE sid='22605' AND (letter_grade is null OR number_grade is null)

[]

SELECT
  SUM(dur_weeks) AS scheduledWeeks
FROM
  clinical
WHERE
  sid = '22605'
  AND (
    letter_grade is null
    OR number_grade is null
  )

SELECT SUM(dur_weeks) AS scheduledWeeks FROM clinical WHERE sid='22605' AND (letter_grade is null OR number_grade is null);

SELECT ct.hospital_name hname, r.name spec,
            ct.dur_weeks, x.transferWeeks
            FROM clinical_transfers ct
            LEFT JOIN class_types cl
            ON cl.id = ct.class_type_id
            LEFT JOIN rotations r
            ON r.id = ct.rotation_id
            JOIN (SELECT sum(dur_weeks) transferWeeks, sid FROM clinical_transfers
                WHERE sid = 22605
            ) x ON x.sid = ct.sid
            WHERE ct.sid = 22605

[]

SELECT
  ct.hospital_name hname,
  r.name spec,
  ct.dur_weeks,
  x.transferWeeks
FROM
  clinical_transfers ct
  LEFT JOIN class_types cl ON cl.id = ct.class_type_id
  LEFT JOIN rotations r ON r.id = ct.rotation_id
  JOIN (
    SELECT
      sum(dur_weeks) transferWeeks,
      sid
    FROM
      clinical_transfers
    WHERE
      sid = 22605
  ) x ON x.sid = ct.sid
WHERE
  ct.sid = 22605

SELECT ct.hospital_name hname, r.name spec,
            ct.dur_weeks, x.transferWeeks
            FROM clinical_transfers ct
            LEFT JOIN class_types cl
            ON cl.id = ct.class_type_id
            LEFT JOIN rotations r
            ON r.id = ct.rotation_id
            JOIN (SELECT sum(dur_weeks) transferWeeks, sid FROM clinical_transfers
                WHERE sid = 22605
            ) x ON x.sid = ct.sid
            WHERE ct.sid = 22605    
        ;

SELECT  h.name hname, r.name rname, c.start_date, c.end_date, c.dur_weeks, c.letter_grade, c.number_grade, 
            c.dur_weeks * cost1 total, rt.`name`,c.hospital_id hid, c.rotation_id rid,c.id cid, pl.id plid, bal.balance, pl.bill_date
            FROM clinical c
            LEFT JOIN hospitals h ON h.id = c.hospital_id
            LEFT JOIN rotations r ON r.id = c.rotation_id
            JOIN rotation_types rt ON rt.id = r.type_id
            LEFT JOIN payments_list pl ON pl.clinical_id = c.id
            LEFT JOIN (
                SELECT sum(amount) balance, payments_list_id from payments
                GROUP BY payments_list_id 
            ) bal ON bal.payments_list_id = pl.id
            WHERE c.sid = 22605
            ORDER BY c.start_date asc;

[]

SELECT
  h.name hname,
  r.name rname,
  c.start_date,
  c.end_date,
  c.dur_weeks,
  c.letter_grade,
  c.number_grade,
  c.dur_weeks * cost1 total,
  rt.`name`,
  c.hospital_id hid,
  c.rotation_id rid,
  c.id cid,
  pl.id plid,
  bal.balance,
  pl.bill_date
FROM
  clinical c
  LEFT JOIN hospitals h ON h.id = c.hospital_id
  LEFT JOIN rotations r ON r.id = c.rotation_id
  JOIN rotation_types rt ON rt.id = r.type_id
  LEFT JOIN payments_list pl ON pl.clinical_id = c.id
  LEFT JOIN (
    SELECT
      sum(amount) balance,
      payments_list_id
    from
      payments
    GROUP BY
      payments_list_id
  ) bal ON bal.payments_list_id = pl.id
WHERE
  c.sid = 22605
ORDER BY
  c.start_date asc;

SELECT  h.name hname, r.name rname, c.start_date, c.end_date, c.dur_weeks, c.letter_grade, c.number_grade, 
            c.dur_weeks * cost1 total, rt.`name`,c.hospital_id hid, c.rotation_id rid,c.id cid, pl.id plid, bal.balance, pl.bill_date
            FROM clinical c
            LEFT JOIN hospitals h ON h.id = c.hospital_id
            LEFT JOIN rotations r ON r.id = c.rotation_id
            JOIN rotation_types rt ON rt.id = r.type_id
            LEFT JOIN payments_list pl ON pl.clinical_id = c.id
            LEFT JOIN (
                SELECT sum(amount) balance, payments_list_id from payments
                GROUP BY payments_list_id 
            ) bal ON bal.payments_list_id = pl.id
            WHERE c.sid = 22605
            ORDER BY c.start_date asc;;