POST https://chezamusicschool.co.ke/teacher/attendance/manage

Query Metrics

33 Database Queries
13 Different statements
181.83 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.01 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  312
]
2 3.67 ms
SELECT t0.id AS id_1, t0.begin_at AS begin_at_2, t0.end_at AS end_at_3, t0.starting_on AS starting_on_4, t0.numberofsessions AS numberofsessions_5, t0.paid AS paid_6, t0.cleared AS cleared_7, t0.done AS done_8, t0.invoiced AS invoiced_9, t0.teacher_id AS teacher_id_10, t0.student_id AS student_id_11, t0.package_id AS package_id_12, t0.user_instrument_grade_id AS user_instrument_grade_id_13, t14.id AS id_15, t14.added_on AS added_on_16, t14.work AS work_17, t14.activities AS activities_18, t14.assessment AS assessment_19, t14.nextlesson AS nextlesson_20, t14.session_id AS session_id_21, t14.student_id AS student_id_22 FROM session t0 LEFT JOIN lesson_plan t14 ON t14.session_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "9130"
]
3 0.93 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  338
]
4 0.89 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "chezamusicschool@gmail.com"
]
5 0.32 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "oumabenjah018@gmail.com"
]
6 0.50 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "chezamusicschool@gmail.com"
]
7 0.62 ms
SELECT t0.id AS id_1, t0.price AS price_2, t0.duration AS duration_3, t0.name AS name_4, t0.no_of_sessions AS no_of_sessions_5, t0.cost_per_lesson AS cost_per_lesson_6 FROM package t0 WHERE t0.id = ?
Parameters:
[
  43
]
8 10.04 ms
SELECT t0.id AS id_1, t0.payment AS payment_2, t0.active AS active_3, t0.siblingname AS siblingname_4, t0.percentage AS percentage_5, t0.alt_email AS alt_email_6, t0.alt_phone AS alt_phone_7, t0.student_user_data_id AS student_user_data_id_8, t0.teacher_user_data_id AS teacher_user_data_id_9, t0.grade_id AS grade_id_10, t0.instrument_id AS instrument_id_11, t0.teacher_id AS teacher_id_12, t0.term_id AS term_id_13, t0.student_id AS student_id_14 FROM user_instrument_grade t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "1232"
]
9 22.66 ms
SELECT t0.id AS id_1, t0.begin_at AS begin_at_2, t0.end_at AS end_at_3, t0.starting_on AS starting_on_4, t0.numberofsessions AS numberofsessions_5, t0.paid AS paid_6, t0.cleared AS cleared_7, t0.done AS done_8, t0.invoiced AS invoiced_9, t0.teacher_id AS teacher_id_10, t0.student_id AS student_id_11, t0.package_id AS package_id_12, t0.user_instrument_grade_id AS user_instrument_grade_id_13, t14.id AS id_15, t14.added_on AS added_on_16, t14.work AS work_17, t14.activities AS activities_18, t14.assessment AS assessment_19, t14.nextlesson AS nextlesson_20, t14.session_id AS session_id_21, t14.student_id AS student_id_22 FROM session t0 LEFT JOIN lesson_plan t14 ON t14.session_id = t0.id WHERE t0.user_instrument_grade_id = ?
Parameters:
[
  1232
]
10 7.37 ms
SELECT t0.id AS id_1, t0.amount AS amount_2, t0.balance AS balance_3, t0.done_on AS done_on_4, t0.type AS type_5, t0.doc_number AS doc_number_6, t0.user_id AS user_id_7, t0.uig_id AS uig_id_8 FROM payment t0 WHERE t0.uig_id = ?
Parameters:
[
  1232
]
11 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.availability AS availability_3, t0.category AS category_4, t0.description AS description_5, t0.image AS image_6, t0.book_online AS book_online_7 FROM instrument t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.78 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "muriukihellen123@gmail.com"
]
13 46.22 ms
SELECT t0.id AS id_1, t0.resumelnk AS resumelnk_2, t0.phone AS phone_3, t0.lessonmode AS lessonmode_4, t0.branch AS branch_5, t0.sex AS sex_6, t0.nextofkinname AS nextofkinname_7, t0.nextofkinphonenum AS nextofkinphonenum_8, t0.nextofkinemail AS nextofkinemail_9, t0.nextofkinrship AS nextofkinrship_10, t0.about AS about_11, t0.conditions AS conditions_12, t0.percentage AS percentage_13, t14.id AS id_15, t14.email AS email_16, t14.roles AS roles_17, t14.password AS password_18, t14.active AS active_19, t14.fullname AS fullname_20, t14.is_verified AS is_verified_21, t14.usertype AS usertype_22, t14.photo AS photo_23, t14.book_online AS book_online_24, t14.teacherdata_id AS teacherdata_id_25, t14.studentdata_id AS studentdata_id_26 FROM teacher_user_data t0 LEFT JOIN `user` t14 ON t14.teacherdata_id = t0.id WHERE t0.id = ?
Parameters:
[
  51
]
14 17.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/communication.html.twig"
]
15 2.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/communication.html.twig"
]
16 3.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/emailBase.html.twig"
]
17 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/emailBase.html.twig"
]
18 3.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@images/cheza_logo.jpg"
]
19 1.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@styles/foundation-emails.css"
]
20 27.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "oumabenjah018@gmail.com"
]
21 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/communication.html.twig"
]
22 5.89 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/emailBase.html.twig"
]
23 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@images/cheza_logo.jpg"
]
24 2.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@styles/foundation-emails.css"
]
25 7.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.fullname AS fullname_6, t0.is_verified AS is_verified_7, t0.usertype AS usertype_8, t0.photo AS photo_9, t0.book_online AS book_online_10, t0.teacherdata_id AS teacherdata_id_11, t0.studentdata_id AS studentdata_id_12 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "chezamusicschool@gmail.com"
]
26 0.58 ms
SELECT t0.id AS id_1, t0.resumelnk AS resumelnk_2, t0.phone AS phone_3, t0.lessonmode AS lessonmode_4, t0.branch AS branch_5, t0.sex AS sex_6, t0.nextofkinname AS nextofkinname_7, t0.nextofkinphonenum AS nextofkinphonenum_8, t0.nextofkinemail AS nextofkinemail_9, t0.nextofkinrship AS nextofkinrship_10, t0.about AS about_11, t0.conditions AS conditions_12, t0.percentage AS percentage_13, t14.id AS id_15, t14.email AS email_16, t14.roles AS roles_17, t14.password AS password_18, t14.active AS active_19, t14.fullname AS fullname_20, t14.is_verified AS is_verified_21, t14.usertype AS usertype_22, t14.photo AS photo_23, t14.book_online AS book_online_24, t14.teacherdata_id AS teacherdata_id_25, t14.studentdata_id AS studentdata_id_26 FROM teacher_user_data t0 LEFT JOIN `user` t14 ON t14.teacherdata_id = t0.id WHERE t0.id = ?
Parameters:
[
  35
]
27 3.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/communication.html.twig"
]
28 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emails/emailBase.html.twig"
]
29 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@images/cheza_logo.jpg"
]
30 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "@styles/foundation-emails.css"
]
31 1.61 ms
"START TRANSACTION"
Parameters:
[]
32 0.32 ms
UPDATE session SET done = ? WHERE id = ?
Parameters:
[
  1
  9130
]
33 2.20 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.