[2026-09-15 07:15:12] 0.55977 sec
INSERT INTO exam_attempt_questions (attempt_id, exam_question_id, question_id, display_order, marks, negative_marks, selected_option_id, answer_status, is_correct, obtained_marks, answered_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[2026-09-17 10:08:41] 0.75944 sec
UPDATE exam_questions
        SET status=?,approved_by_user_id=?,approved_at=?,updated_by_user_id=?
        WHERE question_id=?

[2026-09-17 12:07:46] 0.60229 sec


            SELECT DISTINCT
                   p.permission_code

            FROM exam_user_roles ur

            INNER JOIN exam_role_permissions rp
                    ON rp.role_id = ur.role_id

            INNER JOIN exam_permissions p
                    ON p.permission_id = rp.permission_id

            WHERE ur.user_id = ?
              AND ur.status = 1
              AND rp.is_allowed = 1
              AND p.status = 1