GET http://wicadev01.undanet.com/data/index

Query Metrics

7 Database Queries
2 Different statements
39.62 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
36.39 ms
(91.84%)
1
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.email AS email_3, u0_.is_active AS is_active_4, u0_.roles AS roles_5, u0_.created_at AS created_at_6, u0_.confirmation_token AS confirmation_token_7, u0_.active_second_use_conditions AS active_second_use_conditions_8, u0_.mdirector_id AS mdirector_id_9 FROM users u0_ WHERE u0_.roles LIKE ?
Parameters:
[
  "%ROLE_ADMIN%"
]
3.23 ms
(8.16%)
6
SELECT t0.id AS id_1, t0.crm_id AS crm_id_2, t0.name AS name_3, t0.surname AS surname_4, t0.email AS email_5, t0.register_type AS register_type_6, t0.address AS address_7, t0.address2 AS address2_8, t0.address3 AS address3_9, t0.city AS city_10, t0.province AS province_11, t0.country AS country_12, t0.phone AS phone_13, t0.company_crm_id AS company_crm_id_14, t0.company_name AS company_name_15, t0.company_type AS company_type_16, t0.company_phone AS company_phone_17, t0.company_email AS company_email_18, t0.employees_number AS employees_number_19, t0.created_at AS created_at_20, t0.modified_at AS modified_at_21, t0.terms_accepted AS terms_accepted_22, t0.newsletter_accepted AS newsletter_accepted_23, t0.exclusive_events_accepted AS exclusive_events_accepted_24, t0.custom_offers_accepted AS custom_offers_accepted_25, t0.polls_accepted AS polls_accepted_26, t0.request_cancel_data AS request_cancel_data_27, t0.nif AS nif_28, t0.postal_code AS postal_code_29, t0.second_conditions_actived_date AS second_conditions_actived_date_30, t0.user_id AS user_id_31, t0.profile AS profile_32, t0.logo AS logo_33 FROM user_data t0 WHERE t0.user_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\User
  • The field App\Entity\User#userData is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserData#user does not contain the required 'inversedBy="userData"' attribute.
App\Entity\Project No errors.
App\Entity\UserData
  • The association App\Entity\UserData#logo refers to the inverse side field App\Entity\File#id which is not defined as association.
  • The association App\Entity\UserData#logo refers to the inverse side field App\Entity\File#id which does not exist.
App\Entity\UserProfile No errors.
App\Entity\File No errors.
App\Entity\Installation No errors.