Query Metrics
6
Database Queries
3
Different statements
1.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.34 ms |
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:
[
"57aebd53-0889-11f0-9774-0242c0a8e006"
]
|
| 2 | 0.22 ms |
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:
[
"57aebd53-0889-11f0-9774-0242c0a8e006"
]
|
| 3 | 0.19 ms |
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:
[
"57aebd53-0889-11f0-9774-0242c0a8e006"
]
|
| 4 | 0.31 ms |
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:
[
"374ecf42-4852-11ef-9bb3-0242c0a88004"
]
|
| 5 | 0.18 ms |
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:
[
"374ecf42-4852-11ef-9bb3-0242c0a88004"
]
|
| 6 | 0.19 ms |
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:
[
"374ecf42-4852-11ef-9bb3-0242c0a88004"
]
|
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\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\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\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. |