Query Metrics
13
Database Queries
7
Different statements
7.78 ms
Query time
0
Invalid entities
21
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
4.52 ms (58.09%) |
7 |
SELECT v0_.id AS id_0, v0_.check_in_date AS check_in_date_1, v0_.check_out_date AS check_out_date_2, v0_.diploma_school AS diploma_school_3, v0_.diploma_year AS diploma_year_4, v0_.diploma_grade AS diploma_grade_5, v0_.academic_year AS academic_year_6, v0_.university AS university_7, v0_.faculty AS faculty_8, v0_.degree_course AS degree_course_9, v0_.upload_dir AS upload_dir_10, v0_.is_readmission AS is_readmission_11, v0_.privacy_accepted AS privacy_accepted_12, v0_.datetime_creation AS datetime_creation_13, v0_.property_id AS property_id_14, v0_.candidate_id AS candidate_id_15, v0_.stay_type_id AS stay_type_id_16, v0_.student_type_id AS student_type_id_17, v0_.status_id AS status_id_18 FROM v_accommodation_request v0_ LEFT JOIN v_property v1_ ON v0_.property_id = v1_.id LEFT JOIN v_candidate v2_ ON v0_.candidate_id = v2_.id LEFT JOIN v_stay_type v3_ ON v0_.stay_type_id = v3_.id LEFT JOIN v_student_type v4_ ON v0_.student_type_id = v4_.id LEFT JOIN v_accommodation_request_status v5_ ON v0_.status_id = v5_.id WHERE 1 = 1 AND v0_.academic_year LIKE ? AND v5_.id = ? AND v1_.id IN (?, ?, ?, ?) ORDER BY v0_.check_in_date DESC
Parameters:
[ "%2025/2026%" "1" "1" "2" "3" "4" ]
|
||||||||||||||||||||||||||||
|
0.98 ms (12.60%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.is_admin_active AS is_admin_active_6, t0.is_anonimized AS is_anonimized_7, t0.is_ignore_permission AS is_ignore_permission_8, t0.is_credentials_sent AS is_credentials_sent_9, t0.one_time_code AS one_time_code_10, t0.directory_path AS directory_path_11, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_12, t13.id AS id_14, t13.fiscal_code AS fiscal_code_15, t13.surname AS surname_16, t13.name AS name_17, t13.birth_place AS birth_place_18, t13.birth_province AS birth_province_19, t13.birth_country AS birth_country_20, t13.birth_date AS birth_date_21, t13.address AS address_22, t13.zip AS zip_23, t13.city AS city_24, t13.province AS province_25, t13.country AS country_26, t13.phone AS phone_27, t13.image_path AS image_path_28, t13.job AS job_29, t13.gender AS gender_30, t13.emergency1 AS emergency1_31, t13.emergency2 AS emergency2_32, t13.user_id AS user_id_33 FROM v_user t0 LEFT JOIN v_profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
"1"
]
|
||||||||||||||||||||||||||||
|
0.92 ms (11.85%) |
1 |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.location AS location_2, v0_.code AS code_3, v0_.img_path AS img_path_4, v0_.auto_response_active AS auto_response_active_5, v0_.auto_response_text AS auto_response_text_6, v0_.notification_emails AS notification_emails_7 FROM v_property v0_ INNER JOIN v_jt_user_property v2_ ON v0_.id = v2_.property_id INNER JOIN v_user v1_ ON v1_.id = v2_.user_id WHERE v1_.id = ?
Parameters:
[
"1"
]
|
||||||||||||||||||||||||||||
|
0.46 ms (5.90%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_accommodation_request_status t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.45 ms (5.84%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.code AS code_4, t0.img_path AS img_path_5, t0.auto_response_active AS auto_response_active_6, t0.auto_response_text AS auto_response_text_7, t0.notification_emails AS notification_emails_8 FROM v_property t0 INNER JOIN v_jt_user_property ON t0.id = v_jt_user_property.property_id WHERE v_jt_user_property.user_id = ?
Parameters:
[
"1"
]
|
||||||||||||||||||||||||||||
|
0.23 ms (2.90%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_stay_type t0
Parameters:
[]
|
||||||||||||||||||||||||||||
|
0.22 ms (2.83%) |
1 |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_student_type t0
Parameters:
[]
|
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\AccommodationRequestStatus | 7 |
| App\Entity\StudentType | 5 |
| App\Entity\Property | 4 |
| App\Entity\StayType | 3 |
| App\Entity\User | 1 |
| App\Entity\Profile | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Profile | No errors. |
| App\Entity\Property | No errors. |
| App\Entity\JTUserPermission | No errors. |
| App\Entity\AccommodationRequestDocument | No errors. |
| App\Entity\AccommodationRequestAnnotation | No errors. |
| App\Entity\AccommodationRequestLog | No errors. |
| App\Entity\AccommodationRequestStatus | No errors. |
| App\Entity\AccommodationRequest | No errors. |
| App\Entity\Xml | No errors. |
| App\Entity\JoinTableXmlXmlTransactionProperty | No errors. |
| App\Entity\Candidate | No errors. |
| App\Entity\StayType | No errors. |
| App\Entity\StudentType | No errors. |