GET https://ro.rcc-vp.com/scenario/17/node

Query Metrics

5 Database Queries
5 Different statements
6.57 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.