MySQL Abuse Report for User: u926327694
Generated: 2026-07-29 13:00:59
Node: sg-nme-web2187.main-hosting.eu
==================================================

User active queries (sleep excluded):

Database User: u926327694_ASPCD_clg
Database: u926327694_ASPCD_clg
Time_s: 8
Time_ms: 8780.248
Query:
SELECT st.*,student_session.id as `student_session_id` FROM `class_section_times` JOIN `class_sections` ON `class_sections`.`id` = `class_section_times`.`class_section_id` and time <= TIME('18:30:50')  JOIN `classes` ON `classes`.`id` = `class_sections`.`class_id` JOIN `sections` ON `sections`.`id` = `class_sections`.`section_id` INNER JOIN  student_session  on student_session.class_id=classes.id and student_session.section_id=sections.id JOIN students as st ON st.id = student_session.student_id LEFT OUTER JOIN student_attendences on student_attendences.student_session_id=student_session.id and student_attendences.date='2026-07-29' WHERE student_session.session_id='22' and student_attendences.student_session_id IS NULL AND st.weight != '' AND st.weight != 0 AND st.weight not in(select RFID from bio_attendance where status='PRESENT' AND date='2026-07-29' AND is_staff=0) AND st.id not in (select sid from cron_sms_log where date='2026-07-29' AND status='ABSENT' AND is_staff=0) ORDER BY `sections`.`section` ASC
----------------------------------------

Completed slow queries (last 600s):

Database User: u926327694_ASCHBL_School
Database: u926327694_ASCHBL_School
Time_s: 35.949898
Time_ms: 35949.898000
Query:
SELECT st.*,student_session.id as `student_session_id` FROM `class_section_times` JOIN `class_sections` ON `class_sections`.`id` = `class_section_times`.`class_section_id` and time <= TIME('18:30:02')  JOIN `classes` ON `classes`.`id` = `class_sections`.`class_id` JOIN `sections` ON `sections`.`id` = `class_sections`.`section_id` INNER JOIN  student_session  on student_session.class_id=classes.id and student_session.section_id=sections.id JOIN students as st ON st.id = student_session.student_id LEFT OUTER JOIN student_attendences on student_attendences.student_session_id=student_session.id and student_attendences.date='2026-07-29' WHERE student_session.session_id='21' and student_attendences.student_session_id IS NULL AND st.weight != '' AND st.weight != 0 AND st.weight not in(select RFID from bio_attendance where status='PRESENT' AND date='2026-07-29' AND is_staff=0) AND st.id not in (select sid from cron_sms_log where date='2026-07-29' AND status='ABSENT' AND is_staff=0) ORDER BY `sections`.`section` ASC
----------------------------------------

Database User: u926327694_HMBEG_stu
Database: u926327694_HMBEG_stu
Time_s: 21.487888
Time_ms: 21487.888000
Query:
select * from student_registration as st where RFID != '' AND  S_id not in(select S_id from attendence where Status='PRESENT' AND date='2026-07-29') AND S_id not in (select S_id from sms_log where date='2026-07-29' AND status='ABSENT')
----------------------------------------

Database User: u926327694_HMBEG_stu
Database: u926327694_HMBEG_stu
Time_s: 17.116343
Time_ms: 17116.343000
Query:
select * from student_registration as st where RFID != '' AND  S_id not in(select S_id from attendence where Status='PRESENT' AND date='2026-07-29') AND S_id not in (select S_id from sms_log where date='2026-07-29' AND status='ABSENT')
----------------------------------------

Database User: u926327694_JHBHAG_school
Database: u926327694_JHBHAG_school
Time_s: 6.506402
Time_ms: 6506.402000
Query:
SELECT st.*,student_session.id as `student_session_id` FROM `class_section_times` JOIN `class_sections` ON `class_sections`.`id` = `class_section_times`.`class_section_id` and time <= TIME('18:30:42')  JOIN `classes` ON `classes`.`id` = `class_sections`.`class_id` JOIN `sections` ON `sections`.`id` = `class_sections`.`section_id` INNER JOIN  student_session  on student_session.class_id=classes.id and student_session.section_id=sections.id JOIN students as st ON st.id = student_session.student_id LEFT OUTER JOIN student_attendences on student_attendences.student_session_id=student_session.id and student_attendences.date='2026-07-29' WHERE student_session.session_id='22' and student_attendences.student_session_id IS NULL AND st.weight != '' AND st.weight != 0 AND st.weight not in(select RFID from bio_attendance where status='PRESENT' AND date='2026-07-29' AND is_staff=0) AND st.id not in (select sid from cron_sms_log where date='2026-07-29' AND status='ABSENT' AND is_staff=0) ORDER BY `sections`.`section` ASC
----------------------------------------

Database User: u926327694_HCBIDI_stu
Database: u926327694_HCBIDI_stu
Time_s: 6.183004
Time_ms: 6183.004000
Query:
select * from student_registration as st where RFID != '' AND  S_id not in(select S_id from attendence where Status='PRESENT' AND date='2026-07-29') AND S_id not in (select S_id from sms_log where date='2026-07-29' AND status='ABSENT')
----------------------------------------

Database User: u926327694_HCBIDI_stu
Database: u926327694_HCBIDI_stu
Time_s: 4.282239
Time_ms: 4282.239000
Query:
select * from student_registration as st where RFID != '' AND  S_id not in(select S_id from attendence where Status='PRESENT' AND date='2026-07-29') AND S_id not in (select S_id from sms_log where date='2026-07-29' AND status='ABSENT')
----------------------------------------

Database User: u926327694_ASCHBL_School
Database: u926327694_ASCHBL_School
Time_s: 4.128718
Time_ms: 4128.718000
Query:
select st.* from staff as st JOIN staff_roles as sr ON sr.staff_id = st.id JOIN roles as rl ON rl.id = sr.role_id AND rl.absent_cron_time <= TIME('18:30:38') where st.employee_id != '' AND st.employee_id != 0 AND st.employee_id not in(select RFID from bio_attendance where status='PRESENT' AND date='2026-07-29' AND is_staff=1) AND st.id not in (select sid from cron_sms_log where date='2026-07-29' AND status='ABSENT' AND is_staff=1) AND st.id not in (select staff_id from staff_attendance where date='2026-07-29')
----------------------------------------