Query Metrics

8 Database Queries
5 Different statements
2.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.64 ms
(30.65%)
2
SELECT t0.id AS id_2, t0.total_hour_description AS total_hour_description_3, t0.video_description AS video_description_4, t0.diploma_description AS diploma_description_5, t0.training_type AS training_type_6, t0.thematic AS thematic_7, t0.diploma AS diploma_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.from_api AS from_api_11, t0.name AS name_12, t0.description AS description_13, t0.public AS public_14, t0.status AS status_15, t0.image_id AS image_id_16, t0.duplicate_from_id AS duplicate_from_id_17, t0.owner_channel_id AS owner_channel_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.dtype, t1.lock_by_status AS lock_by_status_21, t1.lock_by_id AS lock_by_id_22, t1.target_channel_id AS target_channel_id_23 FROM scholar_trainings t0 LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
  "aba4b475-250b-11f0-b1c2-aa0701787942"
]
0.60 ms
(29.02%)
2
SELECT t1.id AS id_2, t1.price AS price_3, t0.training AS training_4, t1.dtype FROM training_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.training = ?
Parameters:
[
  "aba4b475-250b-11f0-b1c2-aa0701787942"
]
0.39 ms
(18.91%)
2
SELECT t0.id AS id_1, t0.children_updated_at AS children_updated_at_2, t0.training_id AS training_id_3, t0.module_id AS module_id_4, t0.lesson_id AS lesson_id_5 FROM scholar_update_tracker t0 WHERE t0.training_id = ?
Parameters:
[
  "aba4b475-250b-11f0-b1c2-aa0701787942"
]
0.27 ms
(12.81%)
1
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
]
0.18 ms
(8.62%)
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:
[
  "adrec.staging.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\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\Training\SharedTraining No errors.
App\Entity\Channel\Image No errors.
App\Entity\Channel\Channel No errors.
Nellapp\Bundle\SDKBundle\Auth\Entity\Token No errors.
App\Entity\Account\User No errors.
App\Entity\Scholar\Training\TrainingModule No errors.
App\Entity\Payment\Product No errors.
App\Entity\Payment\TrainingProduct No errors.
App\Entity\Payment\OrderAttempt No errors.
App\Entity\Scholar\Training\TrainingDescription No errors.
App\Entity\ChannelUserData\AbstractCursus No errors.
App\Entity\Scholar\ScholarUpdateTracker No errors.
App\Entity\Scholar\Module\Module 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\LessonProduct No errors.
App\Entity\Scholar\Module\ModuleLesson No errors.
App\Entity\Exercise\Stat No errors.
App\Entity\Exercise\Exercise 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\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\ChannelUserData\ChannelUserData No errors.
App\Entity\Channel\ChannelWhiteLabel No errors.
App\Entity\Account\LogUserData No errors.
App\Entity\Scholar\Indexed\IndexedContent No errors.
App\Entity\Scholar\Indexed\IndexedContentMetadata No errors.
App\Entity\Scholar\Lesson\LessonReview 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\Common\Assignable No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseUser No errors.
App\Entity\Scholar\PracticalCase\SharedPracticalCase No errors.
App\Entity\Scholar\PracticalCase\PracticalCaseResponse 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\Account\Advice 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\Forum\AbstractMessage No errors.
App\Entity\Forum\ChapterMessage 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\ExerciseResult No errors.
App\Entity\Exercise\User\QuestionResult No errors.
App\Entity\Exercise\User\MultipleChoiceQuestionResult No errors.
App\Entity\Exercise\SharedExercise No errors.
App\Entity\Exercise\OriginExercise No errors.
App\Entity\Achievement\AchievementTimeLog No errors.
App\Entity\Achievement\AchievedContent No errors.
App\Entity\Achievement\AchievementTimeLogLesson No errors.
App\Entity\Achievement\AchievedChapter No errors.
App\Entity\Achievement\AchievedTraining No errors.
App\Entity\Achievement\AchievedModule No errors.
App\Entity\Achievement\AchievedLesson No errors.
Nellapp\Bundle\SDKBundle\Entity\AbstractCustomView No errors.
Nellapp\Bundle\SDKBundle\Channel\Entity\ChannelUserRole No errors.