Query Metrics
8
Database Queries
5
Different statements
1.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.63 ms (38.56%) |
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:
[
"d3f39792-9a88-11ea-b7d2-0242ac1c0004"
]
|
|
0.32 ms (19.81%) |
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:
[
"d3f39792-9a88-11ea-b7d2-0242ac1c0004"
]
|
|
0.27 ms (16.78%) |
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:
[
"d3f39792-9a88-11ea-b7d2-0242ac1c0004"
]
|
|
0.26 ms (15.91%) |
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.14 ms (8.94%) |
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. |