GET https://ava.gipa.ge/ka/students

Query Metrics

4 Database Queries
4 Different statements
15.93 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM person_type t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "student"
]
2 5.95 ms
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.photo AS photo_3, t0.bio AS bio_4, t0.start_year AS start_year_5, t0.end_year AS end_year_6, t0.email AS email_7, t0.slug AS slug_8, t0.id AS id_9, t0.created AS created_10, t0.modified AS modified_11, t0.person_type_id AS person_type_id_12, t0.study_group_id AS study_group_id_13, t0.user_id AS user_id_14, t0.created_by_id AS created_by_id_15, t0.modified_by_id AS modified_by_id_16 FROM person t0 WHERE t0.person_type_id = ? AND t0.end_year = ? ORDER BY t0.last_name ASC
Parameters:
[
  2
  2025
]
3 3.76 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM menu t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "main-menu"
]
4 1.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.visible AS visible_4, t0.slug AS slug_5, t0.external AS external_6, t0.icon AS icon_7, t0.menu_id AS menu_id_8 FROM menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
  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\PersonType No errors.
App\Entity\CreatedByUser No errors.
App\Entity\Person No errors.
App\Entity\StudyGroup No errors.
App\Entity\User No errors.
App\Entity\Portfolio No errors.
App\Entity\Subject No errors.
App\Entity\PersonRole No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.
App\Entity\Category No errors.
App\Entity\Semester No errors.
App\Entity\Project No errors.
App\Entity\Event No errors.