Symfony Profiler

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
  if(active, 'Yes', 'No') 'Active Student',
  status_name 'Current Status',
  emailgroup 'Email Group',
  demographics.sid 'Student I.D',
  first_name 'First',
  last_name 'Last',
  middle_name 'Middle',
  nick_name 'Nickname',
  gender Gender,
  DATE(birthdate) 'Birth Date',
  birthplace 'Birth Place',
  date(attending.entrance_date) 'Entrance Date',
  date(attending.grad_date) 'Grad Date',
  teamdrivelink team_drive_link
FROM
  demographics
  JOIN status_values ON status_values.const = demographics.status
  LEFT JOIN attending ON demographics.sid = attending.sid
WHERE
  demographics.sid = 22631

SELECT  if(active,'Yes','No') 'Active Student', status_name  'Current Status', emailgroup 'Email Group',demographics.sid 'Student I.D', first_name 'First', last_name 'Last', middle_name 'Middle', nick_name 'Nickname', gender Gender, DATE(birthdate) 'Birth Date', 
            birthplace 'Birth Place', date(attending.entrance_date) 'Entrance Date', date(attending.grad_date) 'Grad Date', teamdrivelink team_drive_link
            FROM demographics 
            JOIN status_values ON status_values.const = demographics.status
            LEFT JOIN attending ON demographics.sid = attending.sid 
            WHERE demographics.sid = 22631;

SELECT
  id,
  entrance_date 'Entrance Date',
  program 'Program',
  grad_date 'Grad Date',
  bms_grad_date 'BMS Grad Date',
  gpa 'GPA',
  basic_gpa 'Basic Science GPA',
  clinical_gpa 'Clinical Science GPA',
  overall_gpa 'Overall GPA',
  academic_advisor 'Academic Advisor',
  projected_start_date 'Projected Start Date',
  normal_clinic_start_date 'Normal Clinical Start Date',
  maximum_clinic_start_date 'Maximum Clinical Start Date',
  normal_graduation_date 'Normal Graduation Date',
  maximum_graduation_date 'Maximum Graduation Date',
  aamc 'AAMC',
  aamc_token_date 'AAMC Token Date',
  usmle
FROM
  attending
WHERE
  sid = 22631

SELECT id, entrance_date 'Entrance Date', program 'Program', grad_date 'Grad Date', bms_grad_date 'BMS Grad Date', gpa 'GPA', basic_gpa 'Basic Science GPA', clinical_gpa 'Clinical Science GPA', overall_gpa 'Overall GPA',academic_advisor 'Academic Advisor', projected_start_date 'Projected Start Date', 
            normal_clinic_start_date 'Normal Clinical Start Date', maximum_clinic_start_date 'Maximum Clinical Start Date', 
            normal_graduation_date 'Normal Graduation Date', maximum_graduation_date 'Maximum Graduation Date', aamc 'AAMC', aamc_token_date 'AAMC Token Date', usmle
            FROM attending WHERE sid = 22631
            ;

SELECT
  d.*,
  dl.degree_name
FROM
  degree d
  JOIN degree_lookup dl ON d.degree_id = dl.const
WHERE
  d.sid = 22631

SELECT d.*, dl.degree_name FROM degree d
            JOIN degree_lookup dl ON d.degree_id = dl.const 
            WHERE d.sid = 22631
        ;

SELECT
  *
FROM
  address
WHERE
  sid = 22631

SELECT  * 
        FROM address
        WHERE sid = 22631;

SELECT
  if(
    photo_video_model_release, 'Yes',
    'No'
  ) photo_video_model_release,
  if(accommodation, 'Yes', 'No') accommodation,
  entrance_code,
  if(
    school_massmail_list = 1, 'Yes', 'No'
  ) school_massmail_list,
  if(
    alternate_massmail_list = 1, 'Yes',
    'No'
  ) alternate_massmail_list,
  recruiter_id,
  marital_status,
  children,
  drivers_license,
  insurance,
  health_info,
  immunization_record,
  date_prospected,
  osap,
  if(canadian = 1, 'Yes', 'No') Canadian,
  tzoffset,
  archive
FROM
  demographics
WHERE
  sid = 22631

SELECT  if(photo_video_model_release,'Yes','No') photo_video_model_release,if(accommodation,'Yes','No') accommodation,entrance_code , if(school_massmail_list = 1, 'Yes', 'No') school_massmail_list , if(alternate_massmail_list = 1, 'Yes', 'No') alternate_massmail_list, recruiter_id , marital_status , children , drivers_license , insurance , health_info , immunization_record , date_prospected , osap , if(canadian = 1, 'Yes', 'No') Canadian, tzoffset , archive 
        FROM demographics
            WHERE sid = 22631;

SELECT
  cell_phone 'Cell',
  school_email 'School Email',
  alternate_email 'Alternate Email 1',
  alternate_email_1 'Alternate Email 2',
  alternate_email_2 'Alternate Email 3',
  pager 'SMS',
  fax 'Fax'
FROM
  demographics
WHERE
  sid = 22631

SELECT cell_phone 'Cell' , school_email 'School Email', alternate_email 'Alternate Email 1', alternate_email_1 'Alternate Email 2', alternate_email_2 'Alternate Email 3',pager 'SMS' , fax 'Fax'
            FROM demographics
            WHERE sid = 22631;

SELECT
  id,
  citizenship,
  native_language,
  alien_reg_no,
  visa_type,
  visa_country,
  visa_entry_date
FROM
  immigration
WHERE
  sid = 22631

SELECT id, citizenship, native_language, alien_reg_no, visa_type, visa_country, visa_entry_date
            FROM immigration
            WHERE sid = 22631;

SELECT
  emergency_first_name,
  emergency_last_name,
  emergency_phone 'Phone'
FROM
  demographics
WHERE
  sid = 22631

SELECT emergency_first_name ,emergency_last_name, emergency_phone 'Phone'  
            FROM demographics
            WHERE sid = 22631;

SELECT
  sv.status_name,
  n.id,
  n.parentnote,
  n.sid,
  n.date,
  n.created_by,
  n.message,
  n.completed,
  n.semesterid,
  n.academicstatus
FROM
  notes n
  LEFT JOIN status_values sv ON sv.const = n.status
WHere
  n.sid = 22631
  AND n.parentnote is null
ORDER BY
  n.id DESC

SELECT sv.status_name, n.id, n.parentnote, n.sid, n.date, n.created_by, n.message, n.completed, n.semesterid, n.academicstatus
             FROM notes n LEFT JOIN status_values sv ON sv.const = n.status 
            WHere n.sid=22631 AND n.parentnote is null ORDER BY n.id DESC;

SELECT
  sv.status_name,
  n.id,
  n.parentnote,
  n.sid,
  n.date,
  n.created_by,
  n.message,
  n.completed,
  n.semesterid,
  n.academicstatus
FROM
  notes n
  LEFT JOIN status_values sv ON sv.const = n.status
WHere
  sid = 22631
  AND parentnote is not null
ORDER BY
  n.id DESC

SELECT sv.status_name, n.id, n.parentnote, n.sid, n.date, n.created_by, n.message, n.completed, n.semesterid, n.academicstatus
        FROM notes n LEFT JOIN status_values sv ON sv.const = n.status 
            WHere sid=22631 AND parentnote is not null ORDER BY n.id DESC;

SELECT
  id,
  `active`,
  designee_first,
  designee_last,
  phone,
  email,
  relationship
FROM
  communication_consent cc
WHERE
  sid = 22631

SELECT id, `active`, designee_first,designee_last, phone, email, relationship  
        FROM communication_consent cc
        WHERE sid = 22631 ;

SELECT
  count(*) cnt
FROM
  symfony.communication_consent
WHERE
  `active` = 1
  AND sid = 22631

SELECT count(*) cnt
        FROM symfony.communication_consent
        WHERE `active`= 1 AND sid = 22631;