Query Metrics
18
Database Queries
11
Different statements
1.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.18 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:
[
"010d7016-f578-11ee-aec4-0242c0a89006"
]
|
| 2 | 0.09 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:
[
"010d7016-f578-11ee-aec4-0242c0a89006"
]
|
| 3 | 0.12 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:
[
"010d7016-f578-11ee-aec4-0242c0a89006"
]
|
| 4 | 0.11 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:
[
"374ed287-4852-11ef-9bb3-0242c0a88004"
]
|
| 5 | 0.09 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:
[
"374ed287-4852-11ef-9bb3-0242c0a88004"
]
|
| 6 | 0.10 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:
[
"374ed287-4852-11ef-9bb3-0242c0a88004"
]
|
| 7 | 0.15 ms |
SELECT t0.id AS id_3, t0.is_blocked AS is_blocked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.from_api AS from_api_7, t0.owner_channel_id AS owner_channel_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.dtype, t1.name AS name_11, t1.description AS description_12, t1.public AS public_13, t1.status AS status_14, t1.image_id AS image_id_15, t1.duplicate_from_id AS duplicate_from_id_16, t2.lock_by_status AS lock_by_status_17, t2.lock_by_id AS lock_by_id_18, t2.target_channel_id AS target_channel_id_19 FROM scholar_modules t0 LEFT JOIN scholar_origin_modules t1 ON t0.id = t1.id LEFT JOIN scholar_shared_modules t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
"04953db4-f579-11ee-aec4-0242c0a89006"
]
|
| 8 | 0.08 ms |
SELECT t1.id AS id_2, t1.price AS price_3, t0.module AS module_4, t1.dtype FROM module_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.module = ?
Parameters:
[
"04953db4-f579-11ee-aec4-0242c0a89006"
]
|
| 9 | 0.07 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.module_id = ?
Parameters:
[
"04953db4-f579-11ee-aec4-0242c0a89006"
]
|
| 10 | 0.11 ms |
SELECT t1.id AS id_2, t1.is_blocked AS is_blocked_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t1.from_api AS from_api_6, t0.name AS name_7, t0.description AS description_8, t0.public AS public_9, t0.status AS status_10, t1.owner_channel_id AS owner_channel_id_11, t1.created_by_id AS created_by_id_12, t1.updated_by_id AS updated_by_id_13, t0.image_id AS image_id_14, t0.duplicate_from_id AS duplicate_from_id_15, t1.dtype FROM scholar_origin_modules t0 INNER JOIN scholar_modules t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
"3755e587-4852-11ef-9bb3-0242c0a88004"
]
|
| 11 | 0.08 ms |
SELECT t1.id AS id_2, t1.price AS price_3, t0.module AS module_4, t1.dtype FROM module_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.module = ?
Parameters:
[
"3755e587-4852-11ef-9bb3-0242c0a88004"
]
|
| 12 | 0.08 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.module_id = ?
Parameters:
[
"3755e587-4852-11ef-9bb3-0242c0a88004"
]
|
| 13 | 0.11 ms |
SELECT t0.id AS id_3, t0.minimum_time AS minimum_time_4, t0.lesson_review_activated AS lesson_review_activated_5, t0.enable_chat_bot AS enable_chat_bot_6, t0.support_scorm AS support_scorm_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.from_api AS from_api_10, t0.status AS status_11, t0.referral_trainer_id AS referral_trainer_id_12, t0.lesson_stats_id AS lesson_stats_id_13, t0.owner_channel_id AS owner_channel_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.dtype, t1.ref AS ref_17, t1.objective AS objective_18, t1.name AS name_19, t1.description AS description_20, t1.public AS public_21, t1.image_id AS image_id_22, t1.indexed_content_id AS indexed_content_id_23, t2.lock_by_status AS lock_by_status_24, t2.lock_by_id AS lock_by_id_25, t2.target_channel_id AS target_channel_id_26 FROM scholar_lessons t0 LEFT JOIN scholar_origin_lessons t1 ON t0.id = t1.id LEFT JOIN scholar_shared_lessons t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
"049557d4-f579-11ee-aec4-0242c0a89006"
]
|
| 14 | 0.09 ms |
SELECT t1.id AS id_2, t1.price AS price_3, t0.lesson AS lesson_4, t1.dtype FROM lesson_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.lesson = ?
Parameters:
[
"049557d4-f579-11ee-aec4-0242c0a89006"
]
|
| 15 | 0.07 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.lesson_id = ?
Parameters:
[
"049557d4-f579-11ee-aec4-0242c0a89006"
]
|
| 16 | 0.09 ms |
SELECT t1.id AS id_2, t1.minimum_time AS minimum_time_3, t1.lesson_review_activated AS lesson_review_activated_4, t1.enable_chat_bot AS enable_chat_bot_5, t1.support_scorm AS support_scorm_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.from_api AS from_api_9, t1.status AS status_10, t0.ref AS ref_11, t0.objective AS objective_12, t0.name AS name_13, t0.description AS description_14, t0.public AS public_15, t1.referral_trainer_id AS referral_trainer_id_16, t1.lesson_stats_id AS lesson_stats_id_17, t1.owner_channel_id AS owner_channel_id_18, t1.created_by_id AS created_by_id_19, t1.updated_by_id AS updated_by_id_20, t0.image_id AS image_id_21, t0.indexed_content_id AS indexed_content_id_22, t1.dtype FROM scholar_origin_lessons t0 INNER JOIN scholar_lessons t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
"376f6101-4852-11ef-9bb3-0242c0a88004"
]
|
| 17 | 0.12 ms |
SELECT t1.id AS id_2, t1.price AS price_3, t0.lesson AS lesson_4, t1.dtype FROM lesson_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.lesson = ?
Parameters:
[
"376f6101-4852-11ef-9bb3-0242c0a88004"
]
|
| 18 | 0.11 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.lesson_id = ?
Parameters:
[
"376f6101-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\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\Scholar\Training\Training | No errors. |
| App\Entity\Exercise\Stat | No errors. |
| App\Entity\Exercise\Exercise | No errors. |
| App\Entity\ChannelUserData\AbstractCursus | 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\Scholar\ScholarUpdateTracker | No errors. |
| App\Entity\Scholar\Module\Module | No errors. |
| App\Entity\Scholar\Module\OriginModule | No errors. |
| App\Entity\Scholar\Module\SharedModule | No errors. |
| App\Entity\Scholar\Module\ModuleLesson | No errors. |
| App\Entity\Payment\ModuleProduct | No errors. |
| App\Entity\Scholar\Lesson\OriginLesson | No errors. |
| App\Entity\Scholar\Lesson\SharedLesson | No errors. |
| App\Entity\Scholar\Lesson\LessonStats | No errors. |
| App\Entity\Scholar\Indexed\IndexedContent | No errors. |
| App\Entity\Scholar\Chapter\Chapter | No errors. |
| App\Entity\Payment\LessonProduct | No errors. |
| App\Entity\Scholar\Lesson\LessonPrerequisite | No errors. |
| App\Entity\Scholar\PracticalCase\PracticalCase | 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\ChannelUserData\ChannelUserData | 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\Channel\ChannelWhiteLabel | No errors. |
| App\Entity\Channel\ChannelConfiguration | No errors. |
| App\Entity\Account\LogUserData | No errors. |
| App\Entity\Scholar\Indexed\IndexedContentMetadata | No errors. |
| App\Entity\Common\File | No errors. |
| App\Entity\Scholar\ScholarVideo | No errors. |
| Nellapp\Bundle\SDKBundle\Permission\Entity\AbstractChannelUserResourcePermission | No errors. |
| App\Entity\Scholar\Module\ModulePermission | 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\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\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\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. |