Query Metrics
4
Database Queries
4
Different statements
3.67 ms
Query time
0
Invalid entities
0
Cache hits
0
Cache misses
0
Cache puts
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.07 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.37 ms |
SELECT count(id) as cnt FROM credential_settings WHERE type = :type AND limit_date < NOW()
Parameters:
[ "type" => "surveymonkey_proxy" ] |
3 | 0.75 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:
[
"282441586"
]
|
4 | 1.48 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" => "88c5bf31-3672-46c9-8ab1-06a7bc8dffe3" "quizId" => "2daa928a-35fd-4590-b580-3104bc08a7e5" ] |
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. |