Query Metrics
5
Database Queries
5
Different statements
6.57 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary_intro AS summary_intro_3, t0.summary_epilog AS summary_epilog_4, t0.additional_description AS additional_description_5, t0.parameters AS parameters_6, t0.parameters_structure AS parameters_structure_7, t0.author AS author_8, t0.publicated_at AS publicated_at_9, t0.state AS state_10, t0.is_deleted AS is_deleted_11, t0.created_at AS created_at_12, t0.lastmod_at AS lastmod_at_13, t0.users_id AS users_id_14, t0.restricted AS restricted_15, t0.users_id AS users_id_16 FROM scenario t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
17
]
|
2 | 2.64 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.additional_description AS additional_description_3, n0_.question AS question_4, n0_.links_order AS links_order_5, n0_.parameters AS parameters_6, n0_.node_order AS node_order_7, n0_.active AS active_8, n0_.is_deleted AS is_deleted_9, n0_.created_at AS created_at_10, n0_.lastmod_at AS lastmod_at_11, n0_.scenario_id AS scenario_id_12, n0_.users_id AS users_id_13, n0_.scenario_id AS scenario_id_14, n0_.users_id AS users_id_15 FROM node n0_ WHERE n0_.scenario_id = ? AND n0_.is_deleted = ? AND n0_.active = ? ORDER BY n0_.node_order ASC
Parameters:
[ 17 0 1 ] |
3 | 1.15 ms |
SELECT l0_.id AS id_0, l0_.description AS description_1, l0_.feedback AS feedback_2, l0_.score AS score_3, l0_.preferred_order AS preferred_order_4, l0_.correct AS correct_5, l0_.active AS active_6, l0_.is_deleted AS is_deleted_7, l0_.created_at AS created_at_8, l0_.lastmod_at AS lastmod_at_9, l0_.node_id AS node_id_10, l0_.users_id AS users_id_11, l0_.node_id AS node_id_12, l0_.users_id AS users_id_13 FROM link l0_ WHERE l0_.node_id = ? AND l0_.is_deleted = ? AND l0_.active = ? ORDER BY l0_.preferred_order ASC
Parameters:
[ 67 0 1 ] |
4 | 0.62 ms |
SELECT m0_.id AS id_0, m0_.description AS description_1, m0_.options AS options_2, m0_.active AS active_3, m0_.is_deleted AS is_deleted_4, m0_.created_at AS created_at_5, m0_.lastmod_at AS lastmod_at_6, m0_.node_id AS node_id_7, m0_.users_id AS users_id_8, m0_.node_id AS node_id_9, m0_.users_id AS users_id_10 FROM mcq m0_ WHERE m0_.node_id = ? AND m0_.is_deleted = ? AND m0_.active = ?
Parameters:
[ 67 0 1 ] |
5 | 0.91 ms |
SELECT m0_.id AS id_0, m0_.category AS category_1, m0_.filename AS filename_2, m0_.media_name AS media_name_3, m0_.description AS description_4, m0_.media_order AS media_order_5, m0_.active AS active_6, m0_.is_deleted AS is_deleted_7, m0_.created_at AS created_at_8, m0_.lastmod_at AS lastmod_at_9, m0_.scenario_id AS scenario_id_10, m0_.node_id AS node_id_11, m0_.link_id AS link_id_12, m0_.mcq_id AS mcq_id_13, m0_.users_id AS users_id_14, m0_.preview_filename AS preview_filename_15, m0_.use_prview_image AS use_prview_image_16, m0_.media_flag AS media_flag_17, m0_.scenario_id AS scenario_id_18, m0_.node_id AS node_id_19, m0_.link_id AS link_id_20, m0_.mcq_id AS mcq_id_21, m0_.users_id AS users_id_22 FROM media m0_ WHERE m0_.node_id = ? AND m0_.filename IS NOT NULL AND m0_.is_deleted = ? AND m0_.active = ? ORDER BY m0_.media_order ASC
Parameters:
[ 67 0 1 ] |
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\Scenario | No errors. |
App\Entity\Users | No errors. |
App\Entity\Stat | No errors. |
App\Entity\Node | No errors. |
App\Entity\Link | No errors. |
App\Entity\Mcq | No errors. |
App\Entity\Media | No errors. |