Redirect 302 redirect from GET @admin (898aa6)

Query Metrics

19 Database Queries
7 Different statements
20.00 ms Query time
2 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id WHERE t0.id = ?
Parameters:
[
  7
]
2 1.38 ms
SELECT DISTINCT c0_.id AS id_0 FROM course c0_ LIMIT 20
Parameters:
[]
3 5.23 ms
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.description AS description_2, c0_.updated_at AS updated_at_3, c0_.created_at AS created_at_4, c0_.category_id AS category_id_5 FROM course c0_ WHERE c0_.id IN (?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  3
  6
  7
]
4 2.89 ms
SELECT count(c0_.id) AS sclr_0 FROM course c0_
Parameters:
[]
5 1.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id INNER JOIN user_course ON t0.id = user_course.user_id WHERE user_course.course_id = ?
Parameters:
[
  1
]
6 0.63 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.date AS date_5, t0.order_number AS order_number_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.teacher_id AS teacher_id_9, t0.course_id AS course_id_10 FROM teacherLesson t0 WHERE t0.course_id = ?
Parameters:
[
  1
]
7 0.55 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.order_number AS order_number_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.course_id AS course_id_7 FROM course_quiz t0 WHERE t0.course_id = ?
Parameters:
[
  1
]
8 1.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id INNER JOIN user_course ON t0.id = user_course.user_id WHERE user_course.course_id = ?
Parameters:
[
  2
]
9 0.75 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.date AS date_5, t0.order_number AS order_number_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.teacher_id AS teacher_id_9, t0.course_id AS course_id_10 FROM teacherLesson t0 WHERE t0.course_id = ?
Parameters:
[
  2
]
10 0.48 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.order_number AS order_number_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.course_id AS course_id_7 FROM course_quiz t0 WHERE t0.course_id = ?
Parameters:
[
  2
]
11 0.75 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id INNER JOIN user_course ON t0.id = user_course.user_id WHERE user_course.course_id = ?
Parameters:
[
  3
]
12 0.60 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.date AS date_5, t0.order_number AS order_number_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.teacher_id AS teacher_id_9, t0.course_id AS course_id_10 FROM teacherLesson t0 WHERE t0.course_id = ?
Parameters:
[
  3
]
13 0.41 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.order_number AS order_number_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.course_id AS course_id_7 FROM course_quiz t0 WHERE t0.course_id = ?
Parameters:
[
  3
]
14 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id INNER JOIN user_course ON t0.id = user_course.user_id WHERE user_course.course_id = ?
Parameters:
[
  6
]
15 0.52 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.date AS date_5, t0.order_number AS order_number_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.teacher_id AS teacher_id_9, t0.course_id AS course_id_10 FROM teacherLesson t0 WHERE t0.course_id = ?
Parameters:
[
  6
]
16 0.42 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.order_number AS order_number_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.course_id AS course_id_7 FROM course_quiz t0 WHERE t0.course_id = ?
Parameters:
[
  6
]
17 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.patronym AS patronym_4, t0.phone AS phone_5, t0.email AS email_6, t0.telegram_id AS telegram_id_7, t0.date_of_birth AS date_of_birth_8, t0.contract AS contract_9, t0.exam_status AS exam_status_10, t0.license AS license_11, t0.experience AS experience_12, t0.hire_date AS hire_date_13, t0.enroll_date AS enroll_date_14, t0.roles AS roles_15, t0.is_active AS is_active_16, t0.is_approved AS is_approved_17, t0.message AS message_18, t0.about_me AS about_me_19, t0.balance AS balance_20, t0.image AS image_21, t0.password AS password_22, t0.updated_at AS updated_at_23, t0.created_at AS created_at_24, t0.exam_id AS exam_id_25, t0.car_id AS car_id_26, t27.id AS id_28, t27.time_from AS time_from_29, t27.time_to AS time_to_30, t27.days_of_week AS days_of_week_31, t27.notice AS notice_32, t27.created_at AS created_at_33, t27.updated_at AS updated_at_34, t27.autodrome_id AS autodrome_id_35, t27.category_id AS category_id_36, t27.instructor_id AS instructor_id_37, t0.category_id AS category_id_38 FROM user t0 LEFT JOIN drive_schedule t27 ON t27.instructor_id = t0.id INNER JOIN user_course ON t0.id = user_course.user_id WHERE user_course.course_id = ?
Parameters:
[
  7
]
18 0.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.type AS type_4, t0.date AS date_5, t0.order_number AS order_number_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.teacher_id AS teacher_id_9, t0.course_id AS course_id_10 FROM teacherLesson t0 WHERE t0.course_id = ?
Parameters:
[
  7
]
19 0.38 ms
SELECT t0.id AS id_1, t0.question AS question_2, t0.order_number AS order_number_3, t0.image AS image_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6, t0.course_id AS course_id_7 FROM course_quiz t0 WHERE t0.course_id = ?
Parameters:
[
  7
]

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\Course 5
App\Entity\User 3
App\Entity\Category 2

Entities Mapping

Class Mapping errors
App\Entity\User
  • The field 'App\Entity\User#balance' has the property type 'float' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
App\Entity\Exam No errors.
App\Entity\Car No errors.
App\Entity\DriveSchedule No errors.
App\Entity\Autodrome No errors.
App\Entity\Category No errors.
App\Entity\TeacherLesson
  • The field App\Entity\TeacherLesson#studentProgresses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\StudentLessonProgress#lesson does not contain the required 'inversedBy="studentProgresses"' attribute.
App\Entity\InstructorLesson No errors.
App\Entity\Review No errors.
App\Entity\Course No errors.
App\Entity\StudentLessonProgress No errors.
App\Entity\StudentQuizProgress No errors.
App\Entity\Transaction No errors.
App\Entity\CourseQuiz No errors.