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.id = ?

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.id = 19923;

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
  sum(credit_balance) as totalCredits
from
  pck_packages
where
  student_id = :student_id
  and active = 1

select sum(credit_balance) as totalCredits from pck_packages where student_id = 19923 and active = 1;

SELECT
  t0.id AS id_1,
  t0.membershipTypeId AS membershipTypeId_2,
  t0.is_highSchool AS is_highSchool_3,
  t0.pricePerCredit AS pricePerCredit_4
FROM
  pck_membershipTypePrices t0
WHERE
  t0.membershipTypeId = ?

SELECT t0.id AS id_1, t0.membershipTypeId AS membershipTypeId_2, t0.is_highSchool AS is_highSchool_3, t0.pricePerCredit AS pricePerCredit_4 FROM pck_membershipTypePrices t0 WHERE t0.membershipTypeId = 1;

select
  pt.*,
  p.credit_balance as creditsBalance
from
  pck_packages p
  left join pck_packagetypes pt on p.package_types_id = pt.id
where
  p.student_id = :student_id
  and p.active = 1
  and pt.is_special_program = 1;

select pt.*,p.credit_balance as creditsBalance from pck_packages p 
                  left join pck_packagetypes pt on p.package_types_id = pt.id 
                  where p.student_id = 19923 and p.active = 1 and pt.is_special_program = 1; ;

select
  p.*
from
  pck_packages p
  join pck_packagetypes pt on (p.package_types_id = pt.id)
where
  p.student_id = :student_id
  and p.active = 1
  and pt.vendor_package_vendor_id is not null
order by
  p.id asc

select p.*
                    from pck_packages p 
                    join pck_packagetypes pt on (p.package_types_id = pt.id)
                    where p.student_id = 19923 
                      and p.active = 1 
                    and pt.vendor_package_vendor_id is not null order by p.id asc;

select
  sum(credit_balance) as totalCredits,
  pt.vendor_package_vendor_id,
  pt.vendor_package_vendors_allowed as vendors_allowed
from
  pck_packages p
  join pck_packagetypes pt on (p.package_types_id = pt.id)
where
  p.student_id = :student_id
  and p.credit_balance > 0
  and p.active = 1
group by
  vendor_package_vendor_id;

select sum(credit_balance) as totalCredits,pt.vendor_package_vendor_id, pt.vendor_package_vendors_allowed as vendors_allowed
                    from pck_packages p 
                    join pck_packagetypes pt on (p.package_types_id = pt.id)
                    where p.student_id = 19923 
                      and p.credit_balance > 0 and p.active = 1 
                    group by vendor_package_vendor_id;;

select
  pt.*,
  p.credit_balance as creditBalance
from
  pck_packages p
  left join pck_packagetypes pt on p.package_types_id = pt.id
where
  p.student_id = :student_id
  and p.active = 1
  and (
    pt.exams_allowed is not null
    or pt.vendors_allowed is not null
  )
order by
  p.id desc;

select pt.*,p.credit_balance as creditBalance from pck_packages p 
                  left join pck_packagetypes pt on p.package_types_id = pt.id 
                  where p.student_id = 19923 and p.active = 1 and (pt.exams_allowed is not null or pt.vendors_allowed is not null) order by p.id desc; ;

select
  pt.*,
  p.credit_balance as creditBalance
from
  pck_packages p
  left join pck_packagetypes pt on p.package_types_id = pt.id
where
  p.student_id = :student_id
  and p.active = 1
  and (
    pt.exams_allowed is not null
    or pt.vendors_allowed is not null
  )
order by
  p.id desc;

select pt.*,p.credit_balance as creditBalance from pck_packages p 
                  left join pck_packagetypes pt on p.package_types_id = pt.id 
                  where p.student_id = 19923 and p.active = 1 and (pt.exams_allowed is not null or pt.vendors_allowed is not null) order by p.id desc; ;

SELECT
  pck.credit_balance as packageCreditBalance,
  pck.id as specialPackageId,
  pck.*,
  pcp.exams_allowed
from
  pck_packages pck
  join pck_packagetypes pcp on pcp.id = pck.package_types_id
where
  pcp.seminary_study_free_retakes = 1
  and pck.active = 1
  and pck.student_id = :studentId

SELECT pck.credit_balance as packageCreditBalance,pck.id as specialPackageId,pck.* ,pcp.exams_allowed
                    from pck_packages pck 
                    join pck_packagetypes pcp on pcp.id = pck.package_types_id
                    where pcp.seminary_study_free_retakes = 1 and pck.active = 1
                    and pck.student_id = 19923;