Chat Icon
icon-chatbot
Master Korean Chatbot
point-online
Online
icon-chatbot
masterkorean masterkorean masterkorean
8.0.30PHP Version295msRequest Duration7MBMemory UsageGET course-allRoute
    • Booting (10.05ms)
    • Application (285ms)
    • 1 x Application (96.59%)
      285ms
      1 x Booting (3.4%)
      10.05ms
      17 templates were rendered
      • courses.all (resources/views/courses/all.blade.php)6blade
        Params
        0
        courses
        1
        categoryCourse
        2
        data_paginate
        3
        qs
        4
        num_rows
        5
        suggestAI
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • home.inc-component-course-item (resources/views/home/inc-component-course-item.blade.php)18blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
      • pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
        Params
        0
        paginator
        1
        elements
      • app (resources/views/app.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
      • layouts.commoncss (resources/views/layouts/commoncss.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
      • layouts.nav (resources/views/layouts/nav.blade.php)23blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
        19
        isAnswerNoView
        20
        categoryVideo
        21
        notifications
        22
        total_noti_not_readed
      • layouts.footer (resources/views/layouts/footer.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
      • layouts.app (resources/views/layouts/app.blade.php)22blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
        19
        mklive_redirect
        20
        exam_redirect
        21
        mkjob_redirect
      • layouts.commonjs (resources/views/layouts/commonjs.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
      • layouts.noti (resources/views/layouts/noti.blade.php)19blade
        Params
        0
        __env
        1
        app
        2
        errors
        3
        courses
        4
        categoryCourse
        5
        data_paginate
        6
        qs
        7
        num_rows
        8
        suggestAI
        9
        slug
        10
        title
        11
        locale
        12
        cnt
        13
        value
        14
        key
        15
        __currentLoopData
        16
        item
        17
        loop
        18
        description
      uri
      GET course-all
      middleware
      web
      controller
      App\Http\Controllers\CourseController@all
      namespace
      App\Http\Controllers
      prefix
      where
      as
      course-all
      file
      app/Http/Controllers/CourseController.php:92-120
      113 statements were executed, 4 of which were duplicated, 109 unique230ms
      • select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 1 order by `ca`.`sortorder` asc
        5.84ms/app/QueryBuilderFunctions/Course.php:33moodle_prod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        Backtrace
        • 12. /app/QueryBuilderFunctions/Course.php:33
        • 13. /app/Http/Controllers/CourseController.php:95
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • SELECT distinct b.teacherid, a.firstname, b.courseid FROM m_user AS a inner join m_lmsdata_course_professor as b on a.id = b.teacherid
        1.37ms/app/QueryBuilderFunctions/Course.php:422moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/Course.php:422
        • 11. /app/Http/Controllers/CourseController.php:98
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 1 AND lco.isused = 0 and lc.deleted = 0 UNION select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_lmsdata_textbook lt ON lc.bookid = lt.id JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 3 AND lt.isused = 0 AND lco.isused = 0 ) a WHERE a.learningstart <= 1745879504 AND 1745879504 <= a.learningend AND a.isused = 0 order by a.id desc
        8.1ms/app/QueryBuilderFunctions/Course.php:430moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/Course.php:430
        • 11. /app/Http/Controllers/CourseController.php:98
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 711 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.69ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 784 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.28ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 783 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 782 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.97ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 781 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.83ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 780 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.91ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 779 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.08ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 766 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.13ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 765 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.54ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 763 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        7.74ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 761 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.84ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 760 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.57ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 759 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.36ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 758 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.96ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 757 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.44ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 752 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.25ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 749 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.96ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 745 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.12ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 744 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.84ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 743 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.59ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 742 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.91ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 741 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.09ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 700 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.73ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 691 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.46ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 690 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.46ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 689 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.38ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 688 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.65ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 687 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.64ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 686 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.38ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 154 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        8.24ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 684 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.77ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 681 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.82ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 110 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.84ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 672 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.75ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 670 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.28ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 632 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.52ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 645 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.63ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 644 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.01ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 643 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.31ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 642 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.51ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 641 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.11ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 640 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.24ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 639 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.17ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 638 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.98ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 637 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.84ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 636 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.05ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 635 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.24ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 634 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.39ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 624 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.09ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 604 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.97ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 584 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.89ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 199 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        5.56ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 197 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        4.06ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 182 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.79ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 181 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.02ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 178 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        4.47ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 167 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.58ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 160 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.45ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 159 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        1.86ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 157 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        4.11ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 156 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        4.6ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 108 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        5.41ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 136 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        3.36ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT count(*) as total_student FROM m_lmsdata_payment lp JOIN m_lmsdata_class lc ON lc.id = lp.ref AND lp.status = 1 JOIN m_context ctx ON ctx.instanceid = lc.courseid and ctx.contextlevel = 50 JOIN m_role_assignments ra ON ctx.id = ra.contextid AND ra.userid = lp.userid JOIN m_role ro ON ro.id = ra.roleid and ro.id = 5 JOIN m_course c ON c.id = ctx.instanceid JOIN m_user u ON lp.userid = u.id JOIN m_lmsdata_user lu ON u.id = lu.userid WHERE c.id = 135 and u.id not in (SELECT teacherid FROM m_lmsdata_course_professor) and ro.archetype = 'student'
        2.53ms/app/QueryBuilderFunctions/DataUtility.php:34moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/DataUtility.php:34
        • 11. /app/QueryBuilderFunctions/Course.php:451
        • 12. /app/Http/Controllers/CourseController.php:98
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 1 AND lco.isused = 0 and lc.deleted = 0 UNION select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_lmsdata_textbook lt ON lc.bookid = lt.id JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 3 AND lt.isused = 0 AND lco.isused = 0 ) a WHERE a.learningstart <= 1745879504 AND 1745879504 <= a.learningend AND a.isused = 0 order by a.id desc
        7.95ms/app/QueryBuilderFunctions/Course.php:482moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/Course.php:482
        • 11. /app/Http/Controllers/CourseController.php:98
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `vkl`.`sort_level` from `m_vi_korean_levels` as `vkl` inner join `m_vi_user_korean_levels` as `ukl` on `ukl`.`korean_level_id` = `vkl`.`id` where `ukl`.`user_id` is null limit 1
        1.07ms/app/QueryBuilderFunctions/Course.php:1218moodle_prod
        Metadata
        Backtrace
        • 14. /app/QueryBuilderFunctions/Course.php:1218
        • 15. /app/QueryBuilderFunctions/Course.php:1236
        • 16. /app/Http/Controllers/CourseController.php:100
        • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • (select `lc`.*, `lco`.`courseid` as `img_course_id`, `lco`.`price` as `root_price`, `lco`.`lecturecnt`, `u`.`firstname` from `m_lmsdata_class` as `lc` inner join `m_chatbot_suggest_course_mk` as `msc` on `msc`.`course_id` = `lc`.`id` and `msc`.`user_id` is null inner join `m_course` as `co` on `lc`.`courseid` = `co`.`id` inner join `m_lmsdata_course` as `lco` on `lc`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co2` on `lco`.`courseid` = `co2`.`id` inner join `m_course_categories` as `ca` on `ca`.`id` = `co2`.`category` left join `m_course_categories` as `ca2` on `ca2`.`parent` = `ca2`.`id` left join `m_lmsdata_course_professor` as `lcp` on `lcp`.`courseid` = `lco`.`id` inner join `m_user` as `u` on `u`.`id` = `lcp`.`teacherid` where `lc`.`type` = 1 and `lco`.`isused` = 0 and `lc`.`isused` = 0 and `lc`.`deleted` = 0 and `lc`.`learningstart` <= 1745879505 and `lc`.`learningend` >= 1745879505 and not exists (select 1 from `m_lmsdata_class` as `lc_inner` inner join `m_lmsdata_course` as `lco` on `lc_inner`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co` on `co`.`id` = `lc_inner`.`courseid` inner join `m_enrol` as `e` on `e`.`courseid` = `co`.`id` inner join `m_user_enrolments` as `ue` on `ue`.`enrolid` = `e`.`id` inner join `m_context` as `ctx` on `ctx`.`instanceid` = `co`.`id` inner join `m_role_assignments` as `ra` on `ra`.`contextid` = `ctx`.`id` and `ra`.`userid` = `ue`.`userid` inner join `m_role` as `ro` on `ra`.`roleid` = `ro`.`id` where `ro`.`id` = 5 and `ue`.`status` = 0 and `ctx`.`contextlevel` = 50 and `ra`.`userid` is null and (ue.timeend - (86400*lc_inner.reviewperiod)) > 1745879505 and `lc_inner`.`courseid` = `lc`.`courseid`) group by `lc`.`id` order by `lc`.`id` desc, `lc`.`timecreated` desc) union (select `lc`.*, `lco`.`courseid` as `img_course_id`, `lco`.`price` as `root_price`, `lco`.`lecturecnt`, `u`.`firstname` from `m_lmsdata_class` as `lc` inner join `m_course` as `co` on `lc`.`courseid` = `co`.`id` inner join `m_lmsdata_course` as `lco` on `lc`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co2` on `lco`.`courseid` = `co2`.`id` inner join `m_course_categories` as `ca` on `ca`.`id` = `co2`.`category` left join `m_course_categories` as `ca2` on `ca2`.`parent` = `ca2`.`id` left join `m_lmsdata_course_professor` as `lcp` on `lcp`.`courseid` = `lco`.`id` inner join `m_user` as `u` on `u`.`id` = `lcp`.`teacherid` where 0 = 1 and `lc`.`type` = 1 and `lco`.`isused` = 0 and `lc`.`isused` = 0 and `lc`.`deleted` = 0 and `lc`.`learningstart` <= 1745879505 and `lc`.`learningend` >= 1745879505 and not exists (select 1 from `m_lmsdata_class` as `lc_inner` inner join `m_lmsdata_course` as `lco` on `lc_inner`.`parentcourseid` = `lco`.`id` inner join `m_course` as `co` on `co`.`id` = `lc_inner`.`courseid` inner join `m_enrol` as `e` on `e`.`courseid` = `co`.`id` inner join `m_user_enrolments` as `ue` on `ue`.`enrolid` = `e`.`id` inner join `m_context` as `ctx` on `ctx`.`instanceid` = `co`.`id` inner join `m_role_assignments` as `ra` on `ra`.`contextid` = `ctx`.`id` and `ra`.`userid` = `ue`.`userid` inner join `m_role` as `ro` on `ra`.`roleid` = `ro`.`id` where `ro`.`id` = 5 and `ue`.`status` = 0 and `ctx`.`contextlevel` = 50 and `ra`.`userid` is null and (ue.timeend - (86400*lc_inner.reviewperiod)) > 1745879505 and `lc_inner`.`courseid` = `lc`.`courseid`) group by `lc`.`id` order by `lc`.`id` desc, `lc`.`timecreated` desc) order by RAND()
        3.02ms/app/QueryBuilderFunctions/Course.php:1323moodle_prod
        Metadata
        Bindings
        • 0. 1
        • 1. 0
        • 2. 0
        • 3. 0
        • 4. 1745879505
        • 5. 1745879505
        • 6. 5
        • 7. 0
        • 8. 50
        • 9. 1745879505
        • 10. 1
        • 11. 0
        • 12. 0
        • 13. 0
        • 14. 1745879505
        • 15. 1745879505
        • 16. 5
        • 17. 0
        • 18. 50
        • 19. 1745879505
        Backtrace
        • 12. /app/QueryBuilderFunctions/Course.php:1323
        • 13. /app/Http/Controllers/CourseController.php:100
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select `cm`.`id` as `id`, `lcf`.`duration`, `cs`.`id` as `section_id`, `cs`.`name`, `lcf`.`id` as `contentId`, `cs`.`note_of_ai_speak`, `cs`.`visible`, `lcf`.`filepath` from `m_course_sections` as `cs` inner join `m_course_modules` as `cm` on `cs`.`id` = `cm`.`section` inner join `m_okmedia` as `o` on `cs`.`course` = `o`.`course` inner join `m_lcms_contents_file` as `lcf` on `o`.`contents` = `lcf`.`con_seq` where `cs`.`course` = 763 and `cs`.`section` != 0 and `cs`.`visible` = 1 and `cm`.`module` = 22 and `cm`.`instance` = o.id group by `id` order by `cs`.`section` asc
        2.94ms/app/QueryBuilderFunctions/CourseSection.php:63moodle_prod
        Metadata
        Bindings
        • 0. 763
        • 1. 0
        • 2. 1
        • 3. 22
        Backtrace
        • 12. /app/QueryBuilderFunctions/CourseSection.php:63
        • 13. /app/Http/Controllers/CourseController.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • SELECT cm.*, m.name as modname FROM m_modules as m, m_course_modules as cm WHERE cm.course = 763 AND cm.module = m.id AND m.visible = 1
        730μs/app/QueryBuilderFunctions/CourseSection.php:913moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:913
        • 11. /app/QueryBuilderFunctions/CourseSection.php:715
        • 12. /app/QueryBuilderFunctions/CourseSection.php:66
        • 13. /app/Http/Controllers/CourseController.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select distinct id, section, sequence from m_course_sections where course = 763 order by section ASC
        640μs/app/QueryBuilderFunctions/CourseSection.php:718moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:718
        • 11. /app/QueryBuilderFunctions/CourseSection.php:66
        • 12. /app/Http/Controllers/CourseController.php:108
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • SELECT * FROM m_okmedia where id = 8063
        610μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8064
        590μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8065
        590μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8066
        650μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8067
        580μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8068
        580μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8069
        580μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • SELECT * FROM m_okmedia where id = 8070
        580μs/app/QueryBuilderFunctions/CourseSection.php:848moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:848
        • 12. /app/QueryBuilderFunctions/CourseSection.php:761
        • 13. /app/QueryBuilderFunctions/CourseSection.php:66
        • 14. /app/Http/Controllers/CourseController.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • select a.id as mqs_id, a.course_id, a.section_id, a.exam_id, a.exam_score_min, a.exam_business_id, b.name as exam_name, b.score from m_question_section as a inner join exams as b on a.exam_id = b.id where a.course_id = 763 and (a.exam_business_id LIKE '-1,%' OR a.exam_business_id LIKE '%,-1,%' OR a.exam_business_id LIKE '%,-1' OR a.exam_business_id = '-1')
        980μs/app/QueryBuilderFunctions/CourseSection.php:76moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:76
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select distinct percent_course from m_b2b_course_certificate where branch_id = -1
        570μs/app/QueryBuilderFunctions/CourseSection.php:85moodle_prod
        Metadata
        Backtrace
        • 11. /app/QueryBuilderFunctions/CourseSection.php:85
        • 12. /app/Http/Controllers/CourseController.php:108
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1282
        710μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1283
        710μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1284
        710μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1285
        730μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1286
        700μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1287
        700μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1288
        690μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • select b.id as file_id, b.filepath, a.con_name, c.tags_id from m_lcms_contents as a inner join m_lcms_contents_file as b on a.id = b.con_seq inner join m_tags_video_course as c on c.lcms_contents_id = a.id where b.id = 1289
        690μs/app/QueryBuilderFunctions/CourseSection.php:228moodle_prod
        Metadata
        Backtrace
        • 10. /app/QueryBuilderFunctions/CourseSection.php:228
        • 11. /app/Http/Controllers/CourseController.php:108
        • 12. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 13. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
        • 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • SELECT distinct * FROM m_context where instanceid = 763 and contextlevel = 50
        590μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 38095 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 763 ORDER BY f.itemid, f.filepath, f.filename
        820μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 670 and contextlevel = 50
        590μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 34515 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 670 ORDER BY f.itemid, f.filepath, f.filename
        760μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 170 and contextlevel = 50
        610μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 14305 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 170 ORDER BY f.itemid, f.filepath, f.filename
        740μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 160 and contextlevel = 50
        630μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 13152 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 160 ORDER BY f.itemid, f.filepath, f.filename
        770μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 159 and contextlevel = 50
        630μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 13146 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 159 ORDER BY f.itemid, f.filepath, f.filename
        760μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 161 and contextlevel = 50
        610μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 13158 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 161 ORDER BY f.itemid, f.filepath, f.filename
        770μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 176 and contextlevel = 50
        690μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 16132 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 176 ORDER BY f.itemid, f.filepath, f.filename
        770μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct * FROM m_context where instanceid = 645 and contextlevel = 50
        640μs/app/Helpers/Helpers.php:51moodle_prod
        Metadata
        Backtrace
        • 11. /app/Helpers/Helpers.php:51
        • 14. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 16. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 17. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • SELECT distinct f.id AS id, f.contenthash, f.pathnamehash, f.contextid, f.component, f.filearea, f.itemid, f.filepath, f.filename, f.userid, f.filesize, f.mimetype, f.status, f.source, f.author, f.license FROM m_files as f LEFT JOIN m_files_reference as r ON f.referencefileid = r.id WHERE f.contextid = 33807 AND f.component = 'local_courselist' AND f.filearea = 'thumbnailimg' AND f.itemid = 645 ORDER BY f.itemid, f.filepath, f.filename
        790μs/app/Helpers/Helpers.php:61moodle_prod
        Metadata
        Backtrace
        • 10. /app/Helpers/Helpers.php:61
        • 13. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
        • 14. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 15. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
        • 16. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37
      • select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 3 order by `ca`.`sortorder` desc, `ca`.`id` desc
        1.02ms/app/Providers/AppServiceProvider.php:77moodle_prod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 3
        Backtrace
        • 12. /app/Providers/AppServiceProvider.php:77
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 16. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 18. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3 left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0 ) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 95 order by a.id desc
        2.62ms/app/Providers/AppServiceProvider.php:91moodle_prod
        Metadata
        Backtrace
        • 10. /app/Providers/AppServiceProvider.php:91
        • 13. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 14. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 15. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 16. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3 left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0 ) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 96 order by a.id desc
        2.49ms/app/Providers/AppServiceProvider.php:91moodle_prod
        Metadata
        Backtrace
        • 10. /app/Providers/AppServiceProvider.php:91
        • 13. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 14. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 15. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 16. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3 left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0 ) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 92 order by a.id desc
        2.48ms/app/Providers/AppServiceProvider.php:91moodle_prod
        Metadata
        Backtrace
        • 10. /app/Providers/AppServiceProvider.php:91
        • 13. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 14. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 15. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 16. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
      • SELECT distinct * FROM (select lc.*, lco.courseid as img_course_id , lco.price as root_price, lco.lecturecnt, mc.category from m_lmsdata_class lc JOIN m_course mc ON lc.courseid = mc.id JOIN m_lmsdata_course lco ON lc.parentcourseid = lco.id JOIN m_course mc2 ON lco.courseid = mc2.id JOIN m_course_categories ca ON ca.id = mc2.category and ca.type = 3 left JOIN m_course_categories ca2 ON ca.parent = ca2.id WHERE lc.type = 6 AND lco.isused = 0 and lc.deleted = 0 ) a WHERE a.learningstart <= 1745879505 AND 1745879505 <= a.learningend AND a.isused = 0 AND a.category = 93 order by a.id desc
        2.71ms/app/Providers/AppServiceProvider.php:91moodle_prod
        Metadata
        Backtrace
        • 10. /app/Providers/AppServiceProvider.php:91
        • 13. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 14. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 15. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 16. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
      • select `ca`.*, `cal`.`ko_name`, `cal`.`vi_name`, `cal`.`en_name` from `m_course_categories` as `ca` inner join `m_course_categories_lang` as `cal` on `ca`.`id` = `cal`.`categoryid` where `ca`.`depth` = 1 and `ca`.`visible` = 1 and `ca`.`type` = 1 order by `ca`.`sortorder` asc
        1.02ms/app/Providers/AppServiceProvider.php:105moodle_prod
        Metadata
        Bindings
        • 0. 1
        • 1. 1
        • 2. 1
        Backtrace
        • 12. /app/Providers/AppServiceProvider.php:105
        • 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177
        • 16. /vendor/laravel/framework/src/Illuminate/View/View.php:120
        • 17. /vendor/laravel/framework/src/Illuminate/View/View.php:91
        • 18. view::2d00402f119b6ffe58fab9a26693dd37c924650d:55
          _token
          zzpqWfnY0ZrhXlLL52g2xB0AkioLeewUxlcVfPh9
          _previous
          array:1 [ "url" => "http://www.masterkorean.vn/course-all?page=4" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /course-all
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          0 of 0
          array:1 [ "page" => "4" ]
          request_request
          0 of 0
          array:1 [ "page" => "4" ]
          request_headers
          0 of 0
          array:19 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "x-amzn-trace-id" => array:1 [ 0 => "Root=1-681001d0-088cd6415152c7230c1c68b7" ] "host" => array:1 [ 0 => "www.masterkorean.vn" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-forwarded-for" => array:1 [ 0 => "3.139.99.145" ] ]
          request_server
          0 of 0
          array:44 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_X_AMZN_TRACE_ID" => "Root=1-681001d0-088cd6415152c7230c1c68b7" "HTTP_HOST" => "www.masterkorean.vn" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_FORWARDED_FOR" => "3.139.99.145" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "www.masterkorean.vn" "SERVER_PORT" => "80" "SERVER_ADDR" => "10.0.10.198" "REMOTE_PORT" => "13496" "REMOTE_ADDR" => "10.0.1.34" "SERVER_SOFTWARE" => "nginx/1.18.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REQUEST_SCHEME" => "http" "SERVER_PROTOCOL" => "HTTP/1.1" "DOCUMENT_ROOT" => "/usr/share/nginx/html/masterkorean.vn/public" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/course-all?page=4" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "page=4" "SCRIPT_FILENAME" => "/usr/share/nginx/html/masterkorean.vn/public/index.php" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745879504.9634 "REQUEST_TIME" => 1745879504 ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Mon, 28 Apr 2025 22:31:45 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK2J0TkJsNHlXSlV4Z04ySlBHTWRWd1d5OXVOb0s3bGY5SEpjUGwwakl5cWUvc2pERGxsZldZOVRPVmgiLCJtYWMiOiIwOTkyMWI1NGUxZjgyODlmYWY4NTgzZTQwNjUyZGQxYTU5Yzc3OTkzYzZjYjAzM2M2YWJhODYzYzVjNjc4NTUxIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK" 1 => "laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2dEorZVFyQWtIYkFBZGZKZDJGZFFQZ3lxN0ozR2VYZ3J1b29yUzVOd2Q2TjdJR281eXRXUHlFSXpDRng4RSsiLCJtYWMiOiI1NTNhNTdjZjRhYmZlNTZhMGMzYTZhMzZhNDFiNGYxMmIzYzI5NGE3ZTA2YTY3MzI5ZGE4MGZhZjIwNTNhZDNhIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; Max-Age=7200; path=/; httponly; samesite=laxlaravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK2J0TkJsNHlXSlV4Z04ySlBHTWRWd1d5OXVOb0s3bGY5SEpjUGwwakl5cWUvc2pERGxsZldZOVRPVmgiLCJtYWMiOiIwOTkyMWI1NGUxZjgyODlmYWY4NTgzZTQwNjUyZGQxYTU5Yzc3OTkzYzZjYjAzM2M2YWJhODYzYzVjNjc4NTUxIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; path=/XSRF-TOKEN=eyJpdiI6Ik9ZSFNRWmVzQkQvRGNjbCtYNzB2c2c9PSIsInZhbHVlIjoiV0dPUTRsa0R1TWlramVEU3BWeitxdTFBNTludld3eGJGZGFYeU1LbzFmN1FOK1ZzdGpCYWlrOERlbWZBMEtrb2NXYjRSK" 1 => "laravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2dEorZVFyQWtIYkFBZGZKZDJGZFFQZ3lxN0ozR2VYZ3J1b29yUzVOd2Q2TjdJR281eXRXUHlFSXpDRng4RSsiLCJtYWMiOiI1NTNhNTdjZjRhYmZlNTZhMGMzYTZhMzZhNDFiNGYxMmIzYzI5NGE3ZTA2YTY3MzI5ZGE4MGZhZjIwNTNhZDNhIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 00:31:45 GMT; path=/; httponlylaravel_session=eyJpdiI6Ilhqd0dETkxtRmF6Mmp1UE0yWEdZd0E9PSIsInZhbHVlIjoidVZaZE56TnFCOGRCUTVZQ0h6WTdwbTJvK2lWZ0pBR3kzWCtUNlo5MlUwWGdEL2V5ZktBSEsvMWQ0MzFLWk5JYnA2" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "zzpqWfnY0ZrhXlLL52g2xB0AkioLeewUxlcVfPh9" "_previous" => array:1 [ "url" => "http://www.masterkorean.vn/course-all?page=4" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]