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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.16 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.41 ms
SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW()
Parameters:
[
  "type" => "surveymonkey_proxy"
]
3 0.56 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:
[
  "280025889"
]
4 1.74 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" => "8fcd4cfa-9fd5-4736-9fd5-901884eb39e7"
  "quizId" => "6466926c-936e-480f-95ad-fc57a857b7d2"
]

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.