Query Metrics

4 Database Queries
4 Different statements
2.08 ms Query time
0 Invalid entities
53 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.subject_id AS subject_id_4, t0.user_id AS user_id_5, t0.course_id AS course_id_6, t0.is_share AS is_share_7, t0.`number` AS number_8, t0.is_private AS is_private_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.subject_id AS subject_id_12, t0.user_id AS user_id_13 FROM `lesson` t0 WHERE t0.id = ?
Parameters:
[
  "120955"
]
2 1.50 ms
SELECT c0_.id AS id_0, c0_.front AS front_1, c0_.back AS back_2, c0_.lesson_id AS lesson_id_3, c0_.user_id AS user_id_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, c0_.lesson_id AS lesson_id_7, c0_.user_id AS user_id_8 FROM `card` c0_ WHERE c0_.lesson_id = ? ORDER BY c0_.id ASC LIMIT 50
Parameters:
[
  120955
]
3 0.05 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.`number` AS number_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM subject t0 WHERE t0.id = ?
Parameters:
[
  142
]
4 0.17 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.activationcode AS activationcode_5, t0.is_activated AS is_activated_6, t0.is_disabled AS is_disabled_7, t0.is_admin AS is_admin_8, t0.box_max AS box_max_9, t0.is_notify_message AS is_notify_message_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  179874
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Card 50
App\Entity\Lesson 1
App\Entity\Subject 1
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\Lesson No errors.
App\Entity\Subject No errors.
App\Entity\User No errors.
App\Entity\Card No errors.