https://e-learning.adrec.staging.nellapp-01.drosalys.net/

Query Metrics

4 Database Queries
3 Different statements
0.86 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.21 ms
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.channel_id AS channel_id_2 FROM channel_white_label c0_ WHERE c0_.domain = ?
Parameters:
[
  "adrec.staging.nellapp-01.drosalys.net"
]
2 0.17 ms
SELECT s0_.total_hour_description AS total_hour_description_0 FROM scholar_trainings s0_ LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id ORDER BY s0_.total_hour_description DESC LIMIT 1
Parameters:
[]
3 0.12 ms
SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.channel_id AS channel_id_2 FROM channel_white_label c0_ WHERE c0_.domain = ?
Parameters:
[
  "adrec.staging.nellapp-01.drosalys.net"
]
4 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.in_footer = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Channel\SharedChannel No errors.
App\Entity\Scholar\Lesson\Lesson No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\UserFromChannel No errors.
App\Entity\Scholar\Training\Training No errors.
App\Entity\Scholar\Lesson\OriginLesson No errors.
App\Entity\ChannelUserData\ChannelUserData No errors.
App\Entity\Channel\Channel No errors.
App\Entity\Achievement\AchievementTimeLog No errors.
App\Entity\Achievement\AchievedContent No errors.
App\Entity\Achievement\AchievedLesson No errors.
App\Entity\Achievement\AchievedChapter No errors.
App\Entity\Exercise\User\ExerciseResult No errors.
App\Entity\Common\Assignable No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseUser No errors.
App\Entity\Scholar\Lesson\LessonReview No errors.
App\Entity\Exercise\Stat No errors.
App\Entity\Exercise\Exercise No errors.
App\Entity\ChannelUserData\AbstractCursus No errors.
App\Entity\Account\Advice No errors.
App\Entity\Channel\ChannelWhiteLabel No errors.
App\Entity\Scholar\Training\SharedTraining No errors.
App\Entity\Scholar\Lesson\SharedLesson No errors.
App\Entity\Scholar\Chapter\Chapter No errors.
App\Entity\Payment\Product No errors.
App\Entity\Payment\LessonProduct No errors.
App\Entity\Scholar\Module\ModuleLesson No errors.
App\Entity\Scholar\Lesson\LessonPrerequisite No errors.
Nellapp\Bundle\SDKBundle\Auth\Entity\Token No errors.
App\Entity\Account\User No errors.
App\Entity\Scholar\PracticalCase\PracticalCase No errors.
App\Entity\Scholar\Lesson\LessonStats No errors.
App\Entity\Scholar\ScholarUpdateTracker No errors.
App\Entity\Scholar\Training\TrainingModule No errors.
App\Entity\Channel\Image No errors.
App\Entity\Payment\TrainingProduct No errors.
App\Entity\Scholar\Training\TrainingDescription No errors.
App\Entity\Scholar\Indexed\IndexedContent No errors.
App\Entity\Channel\Link No errors.
App\Entity\Common\Address No errors.
App\Entity\Channel\Institution No errors.
App\Entity\Channel\Partner\Partner No errors.
App\Entity\Channel\ChannelDescription No errors.
App\Entity\Channel\ChannelGallery No errors.
App\Entity\Scholar\Module\Module No errors.
App\Entity\Exercise\User\QuestionResult No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseResponse No errors.
App\Entity\Forum\AbstractMessage No errors.
App\Entity\Forum\ChapterMessage No errors.
App\Entity\Exercise\OriginExercise No errors.
App\Entity\Exercise\SharedExercise No errors.
App\Entity\Scholar\Indexed\IndexedContentMetadata No errors.
App\Entity\Common\File No errors.
App\Entity\Scholar\ScholarVideo No errors.
App\Entity\Scholar\Module\OriginModule No errors.
Nellapp\Bundle\SDKBundle\Permission\Entity\AbstractChannelUserResourcePermission No errors.
App\Entity\Scholar\Module\ModulePermission No errors.
App\Entity\Scholar\Module\SharedModule No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseResource No errors.
App\Entity\Scholar\PracticalCase\FilePracticalCaseResponse No errors.
App\Entity\Scholar\PracticalCase\SharedPracticalCase No errors.
App\Entity\Scholar\PracticalCase\OriginPracticalCase No errors.
App\Entity\Scholar\PracticalCase\FilePracticalCase No errors.
App\Entity\Scholar\Training\TrainingPermission No errors.
App\Entity\Scholar\Chapter\OriginChapter No errors.
App\Entity\Scholar\Chapter\SharedChapter No errors.
App\Entity\Account\LogUserData No errors.
App\Entity\Account\Notification No errors.
App\Entity\PartnerApi\PartnerApiUser No errors.
App\Entity\Channel\ShareContentProgress\AbstractProgress No errors.
App\Entity\Channel\ShareContentProgress\ModuleUpdateShareContentProgress No errors.
App\Entity\Channel\ShareContentProgress\TrainingUpdateShareContentProgress No errors.
App\Entity\Channel\ShareContentProgress\UnShare\AbstractUnShareContentProgress No errors.
App\Entity\Channel\ShareContentProgress\UnShare\LessonUnShareProgress No errors.
App\Entity\Channel\ShareContentProgress\UnShare\ModuleUnShareProgress No errors.
App\Entity\Channel\ShareContentProgress\UnShare\TrainingUnShareProgress No errors.
App\Entity\Channel\ShareContentProgress\Share\AbstractShareContentProgress No errors.
App\Entity\Channel\ShareContentProgress\Share\TrainingShareProgress No errors.
App\Entity\Channel\ShareContentProgress\Share\LessonShareProgress No errors.
App\Entity\Channel\ShareContentProgress\Share\ModuleShareProgress No errors.
App\Entity\Channel\Group No errors.
App\Entity\Template\TemplatePage No errors.
App\Entity\Payment\OrderAttempt No errors.
App\Entity\Payment\ModuleProduct No errors.
App\Entity\Exercise\Question\Question No errors.
App\Entity\Exercise\Question\MultipleChoiceQuestion No errors.
App\Entity\Exercise\Question\MultipleChoiceAnswer No errors.
App\Entity\Exercise\User\MultipleChoiceQuestionResult No errors.
App\Entity\Achievement\AchievementTimeLogLesson No errors.
App\Entity\Achievement\AchievedTraining No errors.
App\Entity\Achievement\AchievedModule No errors.
Nellapp\Bundle\SDKBundle\Entity\AbstractCustomView No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\ChannelUserRole No errors.