Query Metrics

21 Database Queries
5 Different statements
39.64 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.24 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.name AS name_6, t0.celular AS celular_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
  3
]
2 0.99 ms
SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.is_visible AS is_visible_2, c0_.updated_at AS updated_at_3 FROM category c0_
Parameters:
[]
3 9.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
4 3.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
5 2.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
6 2.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
7 3.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM category_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
8 1.75 ms
SELECT m0_.id AS id_0, m0_.image AS image_1, m0_.updated_at AS updated_at_2 FROM material m0_
Parameters:
[]
9 1.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  1
]
10 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  2
]
11 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  3
]
12 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  4
]
13 0.81 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  5
]
14 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
15 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  7
]
16 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  8
]
17 2.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  9
]
18 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  10
]
19 5.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  11
]
20 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  12
]
21 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM material_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  13
]

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 No errors.
App\Entity\Customer
  • The association App\Entity\Customer#exerciseQualifications refers to the owning side field App\Entity\ExerciseQualification#customer_id which does not exist.
App\Entity\AppModule
  • The association App\Entity\AppModule#supports refers to the owning side field App\Entity\Support#app_module which does not exist.
App\Entity\Support
  • The mappings App\Entity\Support#AppModule and App\Entity\AppModule#supports are inconsistent with each other.
  • The mappings App\Entity\Support#supportFilesTemplate and App\Entity\SupportFile#Support are inconsistent with each other.
App\Entity\Tactic No errors.
App\Entity\TypeNotification No errors.
App\Entity\TypeSoccer No errors.
App\Entity\Category No errors.
App\Entity\Collaborator No errors.
App\Entity\Competition No errors.
App\Entity\Config No errors.
App\Entity\Country No errors.
App\Entity\Coupon No errors.
App\Entity\CouponCustomer No errors.
App\Entity\Difficulty No errors.
App\Entity\Exercise
  • The field App\Entity\Exercise#notes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\NoteExercise#exercise does not contain the required 'inversedBy="notes"' attribute.
  • The mappings App\Entity\Exercise#exerciseQualifications and App\Entity\ExerciseQualification#exercise are inconsistent with each other.
App\Entity\JustificationType No errors.
App\Entity\Locality No errors.
App\Entity\Material No errors.
App\Entity\Membership No errors.
App\Entity\MembershipAttr No errors.
App\Entity\MembershipDesc No errors.
App\Entity\MembershipItems
  • The field App\Entity\MembershipItems#translatable_id is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Membership#membershipItems does not contain the required 'inversedBy="translatable_id"' attribute.
  • The association App\Entity\MembershipItems#membershipTranslation refers to the inverse side field App\Entity\MembershipTranslation#membership_id which does not exist.
App\Entity\Notification No errors.
App\Entity\NotificationAutomaticMessage No errors.
App\Entity\NotificationAutomaticTranslation No errors.
App\Entity\Position No errors.
App\Entity\Suggestion No errors.
App\Entity\Team
  • The association App\Entity\Team#typeSoccer refers to the inverse side field App\Entity\TypeSoccer#teams which does not exist.
App\Entity\AppModuleTranslation No errors.
App\Entity\TypeNotificationTranslation No errors.
App\Entity\CategoryTranslation No errors.
App\Entity\CompetitionTranslation No errors.
App\Entity\DifficultyTranslation No errors.
App\Entity\ExerciseTranslation No errors.
App\Entity\JustificationTypeTranslation No errors.
App\Entity\LocalityTranslation No errors.
App\Entity\MaterialTranslation No errors.
App\Entity\MembershipTranslation No errors.
App\Entity\MembershipAttrTranslation No errors.
App\Entity\MembershipDescTranslation No errors.
App\Entity\NotificationTranslation No errors.
App\Entity\PositionTranslation No errors.
App\Entity\ExerciseUser No errors.