https://dev-lms.coderslab.pl/webhooks/quiz/result/318433720

Query Metrics

4 Database Queries
4 Different statements
3.32 ms Query time
0 Invalid entities
0 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT id, url, auth_token FROM credential_settings
    WHERE type = :type AND (DATE(limit_date) < NOW() OR limit_date IS NULL)
    ORDER BY RAND() LIMIT 1;
Parameters:
[
  "type" => "surveymonkey_proxy"
]
2 0.46 ms
SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW()
Parameters:
[
  "type" => "surveymonkey_proxy"
]
3 0.71 ms
SELECT t0.id AS id_1, t0.provider_id AS provider_id_2, t0.url AS url_3, t0.state AS state_4, t0.provider_settings AS provider_settings_5 FROM materials_quiz t0 WHERE t0.provider_id = ? LIMIT 1
Parameters:
[
  "318433720"
]
4 1.29 ms
SELECT mpm.id
from materials_pill_material mpm
    JOIN materials_pill_version mpv on mpm.version_id = mpv.id
    JOIN materials_course_chapter_pill_version mccpv on mccpv.pill_version_id = mpv.id
    JOIN materials_course_chapter mcc on mccpv.chapter_id = mcc.id
    JOIN materials_course_module mcm on mcc.module_id = mcm.id
    JOIN materials_course_pass_criterion mcpc on mcc.type = mcpc.type and mcm.course_id = mcpc.course_id
WHERE mcm.course_id = :courseId AND mpm.quiz_id = :quizId
Parameters:
[
  "courseId" => "9dfdcb3f-f47d-46ce-8f54-d3eba1262c3b"
  "quizId" => "f0a042a7-510a-4336-9899-e2be00851041"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
0 Misses
0 Puts

Entities Mapping

Class Mapping errors
CodersLab\Lms\Modules\Materials\Domain\Quiz No errors.
CodersLab\Lms\Modules\Materials\Domain\Pill\Material No errors.