https://cefal.olasoft.net/os-admin/registrations/

Query Metrics

11 Database Queries
7 Different statements
11.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.02 ms
SELECT count(r0_.id) AS sclr_0 FROM registrations r0_
Parameters:
[]
2 0.77 ms
SELECT r0_.id AS id_0, r0_.fname AS fname_1, r0_.lname AS lname_2, r0_.sex AS sex_3, r0_.phone AS phone_4, r0_.email AS email_5, r0_.date AS date_6, r0_.closing_date AS closing_date_7, r0_.code AS code_8, r0_.ip AS ip_9, r0_.profession_id AS profession_id_10, r0_.company_id AS company_id_11, r0_.formation_id AS formation_id_12, r0_.session_id AS session_id_13, r0_.status_id AS status_id_14 FROM registrations r0_ ORDER BY r0_.id DESC LIMIT 100
Parameters:
[]
3 2.82 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.outgoing_message AS outgoing_message_6, t0.incoming_message AS incoming_message_7, t0.is_initial_status AS is_initial_status_8, t0.is_final_status AS is_final_status_9, t0.incoming_recipient AS incoming_recipient_10, t0.incoming_cc AS incoming_cc_11, t0.incoming_cci AS incoming_cci_12, t0.outgoing_cc AS outgoing_cc_13, t0.outgoing_cci AS outgoing_cci_14, t0.icon_id AS icon_id_15 FROM registrations_status t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 1.33 ms
SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id = ?
Parameters:
[
  89
]
5 0.74 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM registrations_professions t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.70 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM registrations_companies_types t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 1.18 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.48 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.outgoing_message AS outgoing_message_6, t0.incoming_message AS incoming_message_7, t0.is_initial_status AS is_initial_status_8, t0.is_final_status AS is_final_status_9, t0.incoming_recipient AS incoming_recipient_10, t0.incoming_cc AS incoming_cc_11, t0.incoming_cci AS incoming_cci_12, t0.outgoing_cc AS outgoing_cc_13, t0.outgoing_cci AS outgoing_cci_14, t0.icon_id AS icon_id_15 FROM registrations_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.47 ms
SELECT t0.target AS target_1, t0.thumbnailDir AS thumbnailDir_2, t0.hasThumbnail AS hasThumbnail_3, t0.id AS id_4, t0.pages AS pages_5, t0.downloads AS downloads_6, t0.reading AS reading_7, t0.name AS name_8, t0.dir AS dir_9, t0.source AS source_10, t0.size AS size_11, t0.is_enabled AS is_enabled_12, t0.is_deleted AS is_deleted_13, t0.last_update AS last_update_14, t0.created_at AS created_at_15, t0.formatSize AS formatSize_16, t0.mimetype AS mimetype_17 FROM picture t0 WHERE t0.id = ?
Parameters:
[
  87
]
10 0.44 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM registrations_companies_types t0 WHERE t0.id = ?
Parameters:
[
  2
]
11 0.58 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.details AS details_4, t0.slug AS slug_5, t0.is_enabled AS is_enabled_6, t0.created_at AS created_at_7, t0.has_registration AS has_registration_8, t0.banner_id AS banner_id_9, t0.album_id AS album_id_10, t0.user_id AS user_id_11 FROM formations t0 WHERE t0.id = ?
Parameters:
[
  4
]

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\Registrations No errors.
App\Entity\RegistrationsProfessions No errors.
App\Entity\RegistrationsCompaniesTypes No errors.
App\Entity\Formations No errors.
App\Entity\FormationsSessions No errors.
App\Entity\OSStatus No errors.
App\Entity\RegistrationsStatus No errors.
App\Entity\FormationsThematics No errors.
App\Entity\OSFile No errors.
App\Entity\Picture No errors.
App\Entity\Albums No errors.
App\Entity\Users No errors.