-------------------------------- SELECT * FROM user WHERE id = ? AND deleted = ? [array ( 0 => '1', 1 => 0, )] -------------------------------- Query took: 0.0010581016540527 seconds. -------------------------------- -------------------------------- SELECT * FROM context WHERE contextlevel = ? AND instanceid = ? [array ( 0 => 50, 1 => '1', )] -------------------------------- Query took: 0.00084519386291504 seconds. -------------------------------- [PID 31968] Server Time: Thu, 24 Jan 2019 01:18:41 +0800 -------------------------------- SELECT * FROM config WHERE name = ? [array ( 0 => 'scheduledtaskreset', )] -------------------------------- Query took: 0.00081396102905273 seconds. -------------------------------- -------------------------------- SELECT 'x' FROM lock_db WHERE resourcekey = ? LIMIT 0, 1 [array ( 0 => 'core_cron', )] -------------------------------- Query took: 0.00077605247497559 seconds. -------------------------------- -------------------------------- UPDATE lock_db SET expires = ?, owner = ? WHERE resourcekey = ? AND (owner IS NULL OR expires < ?) [array ( 0 => 1548350321, 1 => '51893747-fd25-4787-82c9-3e244182aef1', 2 => 'core_cron', 3 => 1548263921, )] -------------------------------- Query took: 0.004392147064209 seconds. -------------------------------- -------------------------------- SELECT COUNT('x') FROM lock_db WHERE owner = ? AND resourcekey = ? [array ( 0 => '51893747-fd25-4787-82c9-3e244182aef1', 1 => 'core_cron', )] -------------------------------- Query took: 0.00076985359191895 seconds. -------------------------------- -------------------------------- SELECT * FROM task_adhoc WHERE (nextruntime IS NULL OR nextruntime < ?) [array ( 0 => 1548263921, )] -------------------------------- Query took: 0.00084304809570312 seconds. -------------------------------- -------------------------------- SELECT 'x' FROM lock_db WHERE resourcekey = ? LIMIT 0, 1 [array ( 0 => 'adhoc_727', )] -------------------------------- Query took: 0.00074601173400879 seconds. -------------------------------- -------------------------------- INSERT INTO lock_db (resourcekey) VALUES(?) [array ( 0 => 'adhoc_727', )] -------------------------------- Query took: 0.0040450096130371 seconds. -------------------------------- -------------------------------- UPDATE lock_db SET expires = ?, owner = ? WHERE resourcekey = ? AND (owner IS NULL OR expires < ?) [array ( 0 => 1548350321, 1 => '3f3b1a20-ee4f-41b5-8dde-d23312b63c3e', 2 => 'adhoc_727', 3 => 1548263921, )] -------------------------------- Query took: 0.0046648979187012 seconds. -------------------------------- -------------------------------- SELECT COUNT('x') FROM lock_db WHERE owner = ? AND resourcekey = ? [array ( 0 => '3f3b1a20-ee4f-41b5-8dde-d23312b63c3e', 1 => 'adhoc_727', )] -------------------------------- Query took: 0.00077414512634277 seconds. -------------------------------- -------------------------------- SELECT * FROM task_adhoc WHERE id = ? [array ( 0 => '727', )] -------------------------------- Query took: 0.00077199935913086 seconds. -------------------------------- -------------------------------- UPDATE lock_db SET expires = ?, owner = ? WHERE owner = ? [array ( 0 => NULL, 1 => NULL, 2 => '51893747-fd25-4787-82c9-3e244182aef1', )] -------------------------------- Query took: 0.0046172142028809 seconds. -------------------------------- [PID 31968] Execute adhoc task: tool_dataprivacy\task\process_data_request_task [PID 31968] ... started 01:18:41. Current memory use 11.3MB. -------------------------------- SELECT * FROM user WHERE id = ? [array ( 0 => '1601', )] -------------------------------- Query took: 0.00095915794372559 seconds. -------------------------------- -------------------------------- SELECT * FROM tool_dataprivacy_request WHERE id = ? [array ( 0 => 433, )] -------------------------------- Query took: 0.0032298564910889 seconds. -------------------------------- -------------------------------- SELECT * FROM user WHERE id = ? [array ( 0 => '1601', )] -------------------------------- Query took: 0.00089907646179199 seconds. -------------------------------- [PID 31968] Pre-processing request... -------------------------------- SELECT * FROM tool_dataprivacy_request WHERE id = ? [array ( 0 => 433, )] -------------------------------- Query took: 0.00077605247497559 seconds. -------------------------------- -------------------------------- UPDATE tool_dataprivacy_request SET type = ?,comments = ?,commentsformat = ?,userid = ?,requestedby = ?,status = ?,dpo = ?,dpocomment = ?,dpocommentformat = ?,creationmethod = ?,timemodified = ?,usermodified = ? WHERE id=? [array ( 0 => '1', 1 => 'Just a test for MDL-64652', 2 => '2', 3 => '1601', 4 => '1601', 5 => 4, 6 => '1601', 7 => '', 8 => '2', 9 => '0', 10 => 1548263921, 11 => '1601', 12 => '433', )] -------------------------------- Query took: 0.004162073135376 seconds. -------------------------------- [PID 31968] Fetching data from 487 components (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing antivirus_clamav (1/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_completion (2/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_date (3/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_grade (4/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_group (5/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_grouping (6/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing availability_profile (7/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_calculated (8/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_calculatedmulti (9/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_calculatedsimple (10/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_ddimageortext (11/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_ddmarker (12/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_ddwtos (13/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_description (14/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_essay (15/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_gapselect (16/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_match (17/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_missingtype (18/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_multianswer (19/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_multichoice (20/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_numerical (21/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_random (22/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_randomsamatch (23/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_shortanswer (24/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing qtype_truefalse (25/487) (Wednesday, 23 January 2019, 6:18 PM) [PID 31968] Processing mod_assign (26/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT ctx.id FROM course_modules cm JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assign a ON cm.instance = a.id JOIN context ctx ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN assign_grades ag ON a.id = ag.assignment AND (ag.userid = ? OR ag.grader = ?)) target ON ctx.id = target.id [array ( 0 => 'assign', 1 => 70, 2 => 1601, 3 => 1601, )] -------------------------------- Query took: 0.00388503074646 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT ctx.id FROM course_modules cm JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assign a ON cm.instance = a.id JOIN context ctx ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN assign_overrides ao ON a.id = ao.assignid WHERE ao.userid = ?) target ON ctx.id = target.id [array ( 0 => 'assign', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.003093957901001 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT ctx.id FROM course_modules cm JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assign a ON cm.instance = a.id JOIN context ctx ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN assign_submission asn ON a.id = asn.assignment WHERE asn.userid = ?) target ON ctx.id = target.id [array ( 0 => 'assign', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.0093250274658203 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT ctx.id FROM course_modules cm JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assign a ON cm.instance = a.id JOIN context ctx ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN assign_user_flags auf ON a.id = auf.assignment WHERE auf.userid = ?) target ON ctx.id = target.id [array ( 0 => 'assign', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.0025770664215088 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT ctx.id FROM course_modules cm JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assign a ON cm.instance = a.id JOIN context ctx ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN assign_user_mapping aum ON a.id = aum.assignment WHERE aum.userid = ?) target ON ctx.id = target.id [array ( 0 => 'assign', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.0021600723266602 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT contextid FROM comments WHERE component = ? AND commentarea = ? AND userid = ?) target ON ctx.id = target.contextid [array ( 0 => 'assignsubmission_comments', 1 => 'submission_comments', 2 => 1601, )] -------------------------------- Query took: 0.50252485275269 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'assign', )] -------------------------------- Query took: 0.0012071132659912 seconds. -------------------------------- [PID 31968] Processing mod_assignment (27/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT DISTINCT ctx.id FROM context ctx JOIN course_modules cm ON cm.id = ctx.instanceid AND ctx.contextlevel = ? JOIN modules m ON cm.module = m.id AND m.name = ? JOIN assignment a ON cm.instance = a.id JOIN assignment_submissions s ON s.assignment = a.id WHERE s.userid = ? OR s.teacher = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 'assignment', 2 => 1601, 3 => 1601, )] -------------------------------- Query took: 0.033743143081665 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'assignment', )] -------------------------------- Query took: 0.0010390281677246 seconds. -------------------------------- [PID 31968] Processing mod_book (28/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'book', )] -------------------------------- Query took: 0.00095391273498535 seconds. -------------------------------- [PID 31968] Processing mod_chat (29/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN ( SELECT DISTINCT ctx.id FROM chat c JOIN modules m ON m.name = ? JOIN course_modules cm ON cm.instance = c.id AND cm.module = m.id JOIN context ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = ? JOIN chat_messages chm ON chm.chatid = c.id WHERE chm.userid = ?) target ON ctx.id = target.id [array ( 0 => 'chat', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.0033080577850342 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'chat', )] -------------------------------- Query took: 0.00090599060058594 seconds. -------------------------------- [PID 31968] Processing mod_choice (30/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM context c INNER JOIN course_modules cm ON cm.id = c.instanceid AND c.contextlevel = ? INNER JOIN modules m ON m.id = cm.module AND m.name = ? INNER JOIN choice ch ON ch.id = cm.instance INNER JOIN choice_options co ON co.choiceid = ch.id INNER JOIN choice_answers ca ON ca.optionid = co.id AND ca.choiceid = ch.id WHERE ca.userid = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 'choice', 2 => 1601, )] -------------------------------- Query took: 0.015644788742065 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'choice', )] -------------------------------- Query took: 0.00092005729675293 seconds. -------------------------------- [PID 31968] Processing mod_data (31/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM context c INNER JOIN course_modules cm ON cm.id = c.instanceid AND c.contextlevel = ? INNER JOIN modules m ON m.id = cm.module AND m.name = ? INNER JOIN data d ON d.id = cm.instance INNER JOIN data_records dr ON dr.dataid = d.id LEFT JOIN comments com ON com.commentarea=? and com.itemid = dr.id AND com.userid = ? LEFT JOIN rating r ON r.contextid = c.id AND r.itemid = dr.id AND r.component = ? AND r.ratingarea = ? AND r.userid = ? WHERE dr.userid = ? OR com.id IS NOT NULL OR r.id IS NOT NULL) target ON ctx.id = target.id [array ( 0 => 70, 1 => 'data', 2 => 'database_entry', 3 => 1601, 4 => 'mod_data', 5 => 'entry', 6 => 1601, 7 => 1601, )] -------------------------------- Query took: 6.4154670238495 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'data', )] -------------------------------- Query took: 0.0011148452758789 seconds. -------------------------------- [PID 31968] Processing mod_feedback (32/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN ( SELECT DISTINCT ctx.id FROM feedback_completed fc JOIN modules m ON m.name = ? JOIN course_modules cm ON cm.instance = fc.feedback AND cm.module = m.id JOIN context ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = ? WHERE fc.userid = ?) target ON ctx.id = target.id [array ( 0 => 'feedback', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.0027701854705811 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN ( SELECT DISTINCT ctx.id FROM feedback_completedtmp fc JOIN modules m ON m.name = ? JOIN course_modules cm ON cm.instance = fc.feedback AND cm.module = m.id JOIN context ctx ON ctx.instanceid = cm.id AND ctx.contextlevel = ? WHERE fc.userid = ?) target ON ctx.id = target.id [array ( 0 => 'feedback', 1 => 70, 2 => 1601, )] -------------------------------- Query took: 0.002647876739502 seconds. -------------------------------- -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'feedback', )] -------------------------------- Query took: 0.00091695785522461 seconds. -------------------------------- [PID 31968] Processing mod_folder (33/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM course_modules_completion cmp INNER JOIN course_modules cm ON cm.id = cmp.coursemoduleid INNER JOIN modules m ON m.id = cm.module INNER JOIN context c ON c.instanceid = cm.id AND c.contextlevel = ? WHERE cmp.userid = ? AND m.name = ?) target ON ctx.id = target.id [array ( 0 => 70, 1 => 1601, 2 => 'folder', )] -------------------------------- Query took: 0.00088906288146973 seconds. -------------------------------- [PID 31968] Processing mod_forum (34/487) (Wednesday, 23 January 2019, 6:18 PM) -------------------------------- SELECT ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance, ctx.locked AS ctxlocked FROM context ctx JOIN (SELECT c.id FROM context c JOIN course_modules cm ON cm.id = c.instanceid AND c.contextlevel = ? JOIN modules m ON m.id = cm.module AND m.name = ? JOIN forum f ON f.id = cm.instance LEFT JOIN forum_discussions d ON d.forum = f.id LEFT JOIN forum_posts p ON p.discussion = d.id LEFT JOIN forum_digests dig ON dig.forum = f.id AND dig.userid = ? LEFT JOIN forum_subscriptions sub ON sub.forum = f.id AND sub.userid = ? LEFT JOIN forum_track_prefs pref ON pref.forumid = f.id AND pref.userid = ? LEFT JOIN forum_read hasread ON hasread.forumid = f.id AND hasread.userid = ? LEFT JOIN forum_discussion_subs dsub ON dsub.forum = f.id AND dsub.userid = ? LEFT JOIN rating rat ON rat.userid = ? AND rat.component = ? AND rat.ratingarea = ? AND rat.itemid = p.id WHERE ( p.userid = ? OR d.userid = ? OR dig.id IS NOT NULL OR sub.id IS NOT NULL OR pref.id IS NOT NULL OR hasread.id IS NOT NULL OR dsub.id IS NOT NULL OR rat.id IS NOT NULL ) ) target ON ctx.id = target.id [array ( 0 => 70, 1 => 'forum', 2 => 1601, 3 => 1601, 4 => 1601, 5 => 1601, 6 => 1601, 7 => 1601, 8 => 'mod_forum', 9 => 'post', 10 => 1601, 11 => 1601, )] -------------------------------- Query took: 1895.2686400414 seconds. -------------------------------- Fatal error: Out of memory (allocated 7305990144) (tried to allocate 4096 bytes) in /var/www/html/lib/dml/mysqli_native_moodle_recordset.php on line 66 Fatal error: Out of memory (allocated 7305990144) (tried to allocate 4096 bytes) in /var/www/html/lib/dml/moodle_database.php on line 883