MySQL Abuse Report for User: u926327694
Generated: 2026-08-01 02:32:50
Node: sg-nme-web2187.main-hosting.eu
==================================================

User active queries (sleep excluded):

Database User: u926327694_smart_SGSBSVNR
Database: u926327694_smart_SGSBSVNR
Time_s: 0
Time_ms: 1.585
Query:
SELECT `sch_settings`.`lastname`, `sch_settings`.`middlename`, `sch_settings`.`id`, `sch_settings`.`lang_id`, `sch_settings`.`languages`, `sch_settings`.`class_teacher`, `sch_settings`.`cron_secret_key`, `sch_settings`.`timezone`, `sch_settings`.`superadmin_restriction`, `sch_settings`.`student_timeline`, `sch_settings`.`name`, `sch_settings`.`email`, `sch_settings`.`biometric`, `sch_settings`.`biometric_device`, `sch_settings`.`time_format`, `sch_settings`.`phone`, `languages`.`language`, `sch_settings`.`attendence_type`, `sch_settings`.`address`, `sch_settings`.`dise_code`, `sch_settings`.`date_format`, `sch_settings`.`currency`, `sch_settings`.`currency_place`, `sch_settings`.`start_month`, `sch_settings`.`start_week`, `sch_settings`.`session_id`, `sch_settings`.`fee_due_days`, `sch_settings`.`image`, `sch_settings`.`theme`, `sessions`.`session`, `sch_settings`.`online_admission`, `sch_settings`.`is_duplicate_fees_invoice`, `sch_settings`.`is_student_house`, `sch_settings`.`is_blood_group`, `sch_settings`.`admin_logo`, `sch_settings`.`admin_small_logo`, `sch_settings`.`mobile_api_url`, `sch_settings`.`app_primary_color_code`, `sch_settings`.`app_secondary_color_code`, `sch_settings`.`app_logo`, `sch_settings`.`student_profile_edit`, `sch_settings`.`staff_barcode`, `sch_settings`.`student_barcode`, `languages`.`is_rtl`, `sch_settings`.`student_panel_login`, `sch_settings`.`parent_panel_login`, `sch_settings`.`currency_format`, `sch_settings`.`exam_result`, `sch_settings`.`base_url`, `sch_settings`.`folder_path`, `currencies`.`symbol` as `currency_symbol`, `currencies`.`base_price`, `currencies`.`short_name` as `currency`, `sch_settings`.`online_admission_application_form`, `currencies`.`id` as `currency_id`, `sch_settings`.`admin_login_page_background`, `sch_settings`.`user_login_page_background`, `sch_settings`.`low_attendance_limit`
FROM `sch_settings`
JOIN `sessions` ON `sessions`.`id` = `sch_settings`.`session_id`
JOIN `languages` ON `languages`.`id` = `sch_settings`.`lang_id`
JOIN `currencies` ON `currencies`.`id` = `sch_settings`.`currency`
ORDER BY `sch_settings`.`id`
----------------------------------------

Completed slow queries (last 600s):

Database User: u926327694_ASPCD_clg
Database: u926327694_ASPCD_clg
Time_s: 118.899776
Time_ms: 118899.776000
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('08:00:29')  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-08-01' 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-08-01' AND is_staff=0) AND st.id not in (select sid from cron_sms_log where date='2026-08-01' AND status='ABSENT' AND is_staff=0) ORDER BY `sections`.`section` ASC
----------------------------------------

Database User: u926327694_ASPCD_clg
Database: u926327694_ASPCD_clg
Time_s: 4.995681
Time_ms: 4995.681000
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('08:02:28') 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-08-01' AND is_staff=1) AND st.id not in (select sid from cron_sms_log where date='2026-08-01' AND status='ABSENT' AND is_staff=1) AND st.id not in (select staff_id from staff_attendance where date='2026-08-01')
----------------------------------------