Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.firstName AS firstName_2,
  t0.lastName AS lastName_3,
  t0.similarName AS similarName_4,
  t0.maidenName AS maidenName_5,
  t0.gender AS gender_6,
  t0.membershipType AS membershipType_7,
  t0.advisor AS advisor_8,
  t0.school AS school_9,
  t0.college AS college_10,
  t0.completeCollegeUpdate AS completeCollegeUpdate_11,
  t0.highSchool1 AS highSchool1_12,
  t0.highSchool2 AS highSchool2_13,
  t0.seminary AS seminary_14,
  t0.dob AS dob_15,
  t0.ssn AS ssn_16,
  t0.jseId AS jseId_17,
  t0.cimId AS cimId_18,
  t0.email AS email_19,
  t0.address AS address_20,
  t0.city AS city_21,
  t0.state AS state_22,
  t0.zip AS zip_23,
  t0.country AS country_24,
  t0.phone AS phone_25,
  t0.phone2 AS phone2_26,
  t0.alert AS alert_27,
  t0.commenceNotes AS commenceNotes_28,
  t0.commenceAccountKey AS commenceAccountKey_29,
  t0.adminErrorDate AS adminErrorDate_30,
  t0.financialAid AS financialAid_31,
  t0.noTranscript AS noTranscript_32,
  t0.accommodations AS accommodations_33,
  t0.accommodationsApproved AS accommodationsApproved_34,
  t0.approvedBy AS approvedBy_35,
  t0.approvalDate AS approvalDate_36,
  t0.disAllowed AS disAllowed_37,
  t0.disAllowedComment AS disAllowedComment_38,
  t0.isIsraelStudent AS isIsraelStudent_39,
  t0.israelAddress AS israelAddress_40,
  t0.isapYear AS isapYear_41,
  t0.ttiStudentId AS ttiStudentId_42,
  t0.createdOn AS createdOn_43,
  t0.lastChange AS lastChange_44,
  t0.createdBy AS createdBy_45,
  t0.lastChangeBy AS lastChangeBy_46,
  t0.password AS password_47,
  t0.roles AS roles_48,
  t0.tal_guid AS tal_guid_49,
  t0.school_cohort AS school_cohort_50,
  t0.ccc_id AS ccc_id_51,
  t0.same_dob_ssn_counter AS same_dob_ssn_counter_52,
  t0.phone3 AS phone3_53,
  t0.phone4 AS phone4_54,
  t0.ccc_id_pending AS ccc_id_pending_55,
  t0.authnet_profile_updated AS authnet_profile_updated_56,
  t0.masped_student_id AS masped_student_id_57
FROM
  students t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.firstName AS firstName_2, t0.lastName AS lastName_3, t0.similarName AS similarName_4, t0.maidenName AS maidenName_5, t0.gender AS gender_6, t0.membershipType AS membershipType_7, t0.advisor AS advisor_8, t0.school AS school_9, t0.college AS college_10, t0.completeCollegeUpdate AS completeCollegeUpdate_11, t0.highSchool1 AS highSchool1_12, t0.highSchool2 AS highSchool2_13, t0.seminary AS seminary_14, t0.dob AS dob_15, t0.ssn AS ssn_16, t0.jseId AS jseId_17, t0.cimId AS cimId_18, t0.email AS email_19, t0.address AS address_20, t0.city AS city_21, t0.state AS state_22, t0.zip AS zip_23, t0.country AS country_24, t0.phone AS phone_25, t0.phone2 AS phone2_26, t0.alert AS alert_27, t0.commenceNotes AS commenceNotes_28, t0.commenceAccountKey AS commenceAccountKey_29, t0.adminErrorDate AS adminErrorDate_30, t0.financialAid AS financialAid_31, t0.noTranscript AS noTranscript_32, t0.accommodations AS accommodations_33, t0.accommodationsApproved AS accommodationsApproved_34, t0.approvedBy AS approvedBy_35, t0.approvalDate AS approvalDate_36, t0.disAllowed AS disAllowed_37, t0.disAllowedComment AS disAllowedComment_38, t0.isIsraelStudent AS isIsraelStudent_39, t0.israelAddress AS israelAddress_40, t0.isapYear AS isapYear_41, t0.ttiStudentId AS ttiStudentId_42, t0.createdOn AS createdOn_43, t0.lastChange AS lastChange_44, t0.createdBy AS createdBy_45, t0.lastChangeBy AS lastChangeBy_46, t0.password AS password_47, t0.roles AS roles_48, t0.tal_guid AS tal_guid_49, t0.school_cohort AS school_cohort_50, t0.ccc_id AS ccc_id_51, t0.same_dob_ssn_counter AS same_dob_ssn_counter_52, t0.phone3 AS phone3_53, t0.phone4 AS phone4_54, t0.ccc_id_pending AS ccc_id_pending_55, t0.authnet_profile_updated AS authnet_profile_updated_56, t0.masped_student_id AS masped_student_id_57 FROM students t0 WHERE t0.email = 'testhonorlock@test.com' LIMIT 1;

select
  cc4digits,
  sv.val as cardtype,
  ccExpMonth,
  ccExpYear,
  ccName,
  cc.id as ccId
from
  creditCards cc
  join selectValues sv on (sv.id = cc.ccType)
where
  studentId = :student_id
  and cc.ccCimId is not null
  and (
    cc.ccExpYear > date_format(
      curdate(),
      '%Y'
    ) || (
      (
        cc.ccExpYear = date_format(
          curdate(),
          '%Y'
        )
        AND cc.ccExpMonth >= date_format(
          curdate(),
          '%m'
        )
      )
    )
  )
order by
  cc.id desc

select cc4digits,sv.val as cardtype,ccExpMonth, ccExpYear, ccName, cc.id as ccId
                  from creditCards cc
                  join selectValues sv on (sv.id = cc.ccType) 
                  where studentId = 19923 
                  and cc.ccCimId is not null 
                  and (cc.ccExpYear > date_format(curdate(), '%Y') || ((cc.ccExpYear = date_format(curdate(), '%Y') AND cc.ccExpMonth >= date_format(curdate(), '%m'))))
                  order by cc.id desc;