Query Metrics
9
Database Queries
5
Different statements
7.65 ms
Query time
0
Invalid entities
348
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.43 ms (31.80%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.label AS label_6, t0.status AS status_7, t0.number_of_seats AS number_of_seats_8, t0.duration AS duration_9, t0.education_area AS education_area_10, t0.target_group AS target_group_11, t0.event_location AS event_location_12, t0.education_description AS education_description_13, t0.outcomes AS outcomes_14, t0.keywords AS keywords_15, t0.image AS image_16, t0.time_of_maintenance AS time_of_maintenance_17, t0.implementation_requirements AS implementation_requirements_18, t0.document AS document_19, t0.original_name AS original_name_20, t0.planned_realization_date AS planned_realization_date_21, t0.full_document_path AS full_document_path_22, t0.educator_certificate_document_name AS educator_certificate_document_name_23, t0.educator_certificate_document_path AS educator_certificate_document_path_24, t0.educator_census_lists_name AS educator_census_lists_name_25, t0.educator_census_list_path AS educator_census_list_path_26, t0.educator_document AS educator_document_27, t0.census_list AS census_list_28, t0.remark AS remark_29, t0.educator_mzo_point_name AS educator_mzo_point_name_30, t0.educator_mzo_point_value AS educator_mzo_point_value_31, t0.mzo_point_name AS mzo_point_name_32, t0.mzo_point_value AS mzo_point_value_33, t0.user_created AS user_created_34, t0.user_changed AS user_changed_35, t0.institution AS institution_36, t0.education_manager AS education_manager_37, t0.school_year AS school_year_38, t0.school_list AS school_list_39, t0.form_of_education AS form_of_education_40, t0.method_of_implementation AS method_of_implementation_41 FROM education t0 WHERE t0.status = ? AND t0.active = ?
Parameters:
[ "FINISHED" 1 ] |
|
1.70 ms (22.18%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.label AS label_6, t0.status AS status_7, t0.number_of_seats AS number_of_seats_8, t0.duration AS duration_9, t0.education_area AS education_area_10, t0.target_group AS target_group_11, t0.event_location AS event_location_12, t0.education_description AS education_description_13, t0.outcomes AS outcomes_14, t0.keywords AS keywords_15, t0.image AS image_16, t0.time_of_maintenance AS time_of_maintenance_17, t0.implementation_requirements AS implementation_requirements_18, t0.document AS document_19, t0.original_name AS original_name_20, t0.planned_realization_date AS planned_realization_date_21, t0.full_document_path AS full_document_path_22, t0.educator_certificate_document_name AS educator_certificate_document_name_23, t0.educator_certificate_document_path AS educator_certificate_document_path_24, t0.educator_census_lists_name AS educator_census_lists_name_25, t0.educator_census_list_path AS educator_census_list_path_26, t0.educator_document AS educator_document_27, t0.census_list AS census_list_28, t0.remark AS remark_29, t0.educator_mzo_point_name AS educator_mzo_point_name_30, t0.educator_mzo_point_value AS educator_mzo_point_value_31, t0.mzo_point_name AS mzo_point_name_32, t0.mzo_point_value AS mzo_point_value_33, t0.user_created AS user_created_34, t0.user_changed AS user_changed_35, t0.institution AS institution_36, t0.education_manager AS education_manager_37, t0.school_year AS school_year_38, t0.school_list AS school_list_39, t0.form_of_education AS form_of_education_40, t0.method_of_implementation AS method_of_implementation_41 FROM education t0 WHERE t0.status = ? AND t0.active = ? ORDER BY t0.id ASC LIMIT 3
Parameters:
[ "FINISHED" 1 ] |
|
1.55 ms (20.27%) |
3 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.bank AS bank_3, t0.iban AS iban_4, t0.roles AS roles_5, t0.password AS password_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.registration_token AS registration_token_9, t0.password_reset_token AS password_reset_token_10, t0.image AS image_11, t0.oib AS oib_12, t0.gender AS gender_13, t0.date_of_birth AS date_of_birth_14, t0.phone AS phone_15, t0.address AS address_16, t0.place AS place_17, t0.menu_visibility AS menu_visibility_18, t0.active AS active_19, t0.professional_qualification AS professional_qualification_20 FROM user t0 WHERE t0.id = ?
Parameters:
[
39
]
|
|
1.50 ms (19.59%) |
3 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.ordinal_number_on_education AS ordinal_number_on_education_5, t0.user_created AS user_created_6, t0.user_changed AS user_changed_7, t0.education AS education_8, t0.education_manager AS education_manager_9 FROM education_educator t0 WHERE t0.education = ?
Parameters:
[
1
]
|
|
0.47 ms (6.17%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_changed AS date_changed_3, t0.active AS active_4, t0.name AS name_5, t0.label AS label_6, t0.color AS color_7, t0.oib AS oib_8, t0.address AS address_9, t0.place AS place_10, t0.country AS country_11, t0.contact_phone AS contact_phone_12, t0.contact_email AS contact_email_13, t0.web_page AS web_page_14, t0.additional_data AS additional_data_15, t0.is_pdv AS is_pdv_16, t0.user_created AS user_created_17, t0.user_changed AS user_changed_18, t0.legal_entity AS legal_entity_19 FROM institution t0 WHERE t0.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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Education | 225 |
| App\Entity\User | 92 |
| App\Entity\SchoolList | 19 |
| App\Entity\SchoolYear | 4 |
| App\Entity\FormOfEducation | 3 |
| App\Entity\MethodOfImplementation | 2 |
| App\Entity\Institution | 1 |
| App\Entity\LegalEntity | 1 |
| App\Entity\ProfessionalQualification | 1 |