https://e-learning.staging2.nellapp-01.drosalys.net/channel/e231122f-1f18-11e9-8180-00163e87308f

Query Metrics

2 Database Queries
2 Different statements
0.32 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.16 ms
(51.87%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.approved AS approved_4, t0.can_share_content AS can_share_content_5, t0.image_path AS image_path_6, t0.description AS description_7, t0.contact_email AS contact_email_8, t0.contact_phone AS contact_phone_9, t0.presentation_title AS presentation_title_10, t0.presentation_text AS presentation_text_11, t0.payment_alert AS payment_alert_12, t0.enabled_indexing AS enabled_indexing_13, t0.enabled_nellbot_tutor AS enabled_nellbot_tutor_14, t0.enabled_nellbot_agent AS enabled_nellbot_agent_15, t0.enable_scorm AS enable_scorm_16, t0.owner_id AS owner_id_17, t0.image_id AS image_id_18, t19.id AS id_20, t19.domain AS domain_21, t19.channel_id AS channel_id_22, t0.configuration_id AS configuration_id_23 FROM channel_channels t0 LEFT JOIN channel_white_label t19 ON t19.channel_id = t0.id WHERE t0.id = ?
Parameters:
[
  "e231122f-1f18-11e9-8180-00163e87308f"
]
0.15 ms
(48.13%)
1
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:
[
  "staging2.nellapp-01.drosalys.net"
]

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\Bunny\BunnyVideoCollection No errors.
App\Entity\Bunny\BunnyVideo No 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\Account\Advice 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.
Nellapp\Bundle\SDKBundle\Assignable\Entity\AbstractAssignable 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\Channel\Channel No errors.
Nellapp\Bundle\SDKBundle\Auth\Entity\Token No errors.
App\Entity\Account\User No errors.
App\Entity\Channel\Image No errors.
App\Entity\Channel\ChannelWhiteLabel No errors.
App\Entity\Channel\ChannelConfiguration No errors.
App\Entity\Channel\Link No errors.
Nellapp\Bundle\SDKBundle\Entity\Common\Address\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\ChannelUserData\ChannelUserData No errors.
App\Entity\Scholar\Lesson\OriginLesson 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.
App\Entity\Scholar\PracticalCase\PracticalCase No errors.
App\Entity\Scholar\Lesson\LessonStats No errors.
App\Entity\Scholar\ScholarUpdateTracker No errors.
App\Entity\Scholar\Training\SharedTraining No errors.
App\Entity\Scholar\Training\TrainingModule No errors.
App\Entity\Payment\TrainingProduct No errors.
App\Entity\Scholar\Training\TrainingDescription 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.
Nellapp\Bundle\SDKBundle\Assignable\Entity\AbstractAssignableNote No errors.
App\Entity\Common\AssignableNote No errors.
App\Entity\Exercise\OriginExercise No errors.
App\Entity\Exercise\SharedExercise No errors.
App\Entity\Account\LogUserData No errors.
App\Entity\Scholar\Indexed\IndexedContent 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\Notification 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\Scorm\ContentFolder No errors.
App\Entity\Scorm\LessonProductItem No errors.
App\Entity\Scorm\LessonProductFolder No errors.
App\Entity\Scorm\ModuleProductFolder No errors.
App\Entity\Scorm\ProductFolder No errors.
App\Entity\Scorm\TrainingProductItem No errors.
App\Entity\Scorm\ContentFile No errors.
App\Entity\Scorm\ModuleProductItem No errors.
App\Entity\Scorm\TrainingProductFolder No errors.
App\Entity\Scorm\ProductItem No errors.
App\Entity\Scorm\LessonContentFolder No errors.
App\Entity\Scorm\ProductItemContent 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\Developers\Entity\ApiClient\ApiClient No errors.
Nellapp\Bundle\SDKBundle\Developers\Entity\ApiToken\ApiToken No errors.
Nellapp\Bundle\SDKBundle\Developers\Entity\ApiTokenChannelAccess\ApiTokenChannelAccess No errors.
Nellapp\Bundle\SDKBundle\Developers\Entity\ApiTokenChannelUserAccess\ApiTokenChannelUserAccess No errors.
Nellapp\Bundle\SDKBundle\ActivityFeed\Entity\AbstractActivity No errors.
Nellapp\Bundle\SDKBundle\ActivityFeed\Entity\AbstractActivityFeed No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\ChannelUserRole No errors.