Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.72 ms
SELECT t0.item AS item_1, t0.value AS value_2, t0.locale AS locale_3, t0.translations AS translations_4, t0.data_type AS data_type_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by_id AS created_by_id_9, t0.files_id AS files_id_10 FROM static_data_store t0
Parameters:
[]
2 1.42 ms
SELECT t0.id AS id_2, t0.email AS email_3, t0.password AS password_4, t0.f_name AS f_name_5, t0.l_name AS l_name_6, t0.created_at AS created_at_7, t0.last_login AS last_login_8, t0.token AS token_9, t0.sex AS sex_10, t0.is_enabled AS is_enabled_11, t0.profile_id AS profile_id_12, t0.type, t1.social_reason AS social_reason_13, t1.accept_collect_personal_data AS accept_collect_personal_data_14, t1.current_document AS current_document_15, t1.contact_phone_number AS contact_phone_number_16, t1.contact_email AS contact_email_17, t1.contact_post_box AS contact_post_box_18, t1.address_country AS address_country_19, t1.address_town AS address_town_20, t1.address_detail AS address_detail_21, t1.type_id AS type_id_22, t1.territory_id AS territory_id_23, t1.request_id AS request_id_24 FROM users t0 LEFT JOIN provider t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
  6
]
3 0.53 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.description AS description_3 FROM profiles t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.description AS description_4 FROM roles t0 INNER JOIN profiles_roles ON t0.id = profiles_roles.roles_id WHERE profiles_roles.profiles_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
EToNBundle\Entity\EventToNotificationStore No errors.
App\Entity\Users No errors.
App\Entity\Embedded\Contact No errors.
App\Entity\Embedded\Address No errors.
App\Entity\Provider No errors.
App\Entity\ResetPasswordRequest No errors.
SDataEBundle\Entity\StaticDataStore No errors.
App\Entity\File\Biblios No errors.
App\Entity\Profiles No errors.
App\Entity\ChoiceElement No errors.
App\Entity\ProviderType No errors.
App\Entity\Territory No errors.
App\Entity\Embedded\ProviderRequestStatus No errors.
App\Entity\ProviderRequest No errors.
App\Entity\Roles No errors.