https://prod.golmanagerpanel.com/admin/?action=list&entity=Customer&menuIndex=3&p=admin%2F&submenuIndex=0

Query Metrics

204 Database Queries
6 Different statements
110.83 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.79 ms
(0.00%)
100
SELECT t0.id AS id_1, t0.year AS year_2, t0.is_active AS is_active_3, t0.team_id AS team_id_4, t0.customer_id AS customer_id_5, t0.country_id AS country_id_6 FROM season t0 WHERE t0.customer_id = ?
Parameters:
[
  26869
]
36.27 ms
(0.00%)
100
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.image_trainer AS image_trainer_4, t0.updated_at AS updated_at_5, t0.category AS category_6, t0.monthly_cost AS monthly_cost_7, t0.kit_payment_cost AS kit_payment_cost_8, t0.other_payment_cost AS other_payment_cost_9, t0.stadium_name AS stadium_name_10, t0.number_clubes_league AS number_clubes_league_11, t0.type_soccer_id AS type_soccer_id_12, t0.alignment_default_u7_id AS alignment_default_u7_id_13, t0.alignment_default_u8_id AS alignment_default_u8_id_14, t0.alignment_default_u11_id AS alignment_default_u11_id_15 FROM team t0 WHERE t0.id = ?
Parameters:
[
  27046
]
25.98 ms
(0.00%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_
Parameters:
[]
3.33 ms
(0.00%)
1
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
]
3.10 ms
(0.00%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM customer c0_ ORDER BY c0_.id DESC LIMIT 100
Parameters:
[]
2.36 ms
(0.00%)
1
SELECT c0_.id AS id_0, c0_.email AS email_1, c0_.username AS username_2, c0_.roles AS roles_3, c0_.password AS password_4, c0_.plain_password AS plain_password_5, c0_.enabled AS enabled_6, c0_.name AS name_7, c0_.surname AS surname_8, c0_.address AS address_9, c0_.celular AS celular_10, c0_.image AS image_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c0_.country_id AS country_id_14, c0_.season_active AS season_active_15, c0_.type_account AS type_account_16, c0_.is_pro AS is_pro_17, c0_.purchase AS purchase_18, c0_.purchase_platform AS purchase_platform_19, c0_.membership_id AS membership_id_20, c0_.coupon_status AS coupon_status_21, c0_.phone AS phone_22, c0_.google_auth_code AS google_auth_code_23, c0_.google_auth_code_verified AS google_auth_code_verified_24, c0_.date_of_birth AS date_of_birth_25, c0_.deleted_at AS deleted_at_26, c0_.is_deleted AS is_deleted_27, c0_.country_id AS country_id_28 FROM customer c0_ WHERE c0_.id IN (?) ORDER BY c0_.id DESC
Parameters:
[
  [
    26869
    26868
    26867
    26866
    26865
    26864
    26863
    26862
    26861
    26860
    26859
    26858
    26857
    26856
    26855
    26854
    26853
    26852
    26851
    26850
    26849
    26848
    26847
    26846
    26845
    26844
    26843
    26842
    26841
    26840
    26839
    26838
    26837
    26836
    26835
    26834
    26833
    26832
    26831
    26830
    26829
    26828
    26827
    26826
    26825
    26824
    26823
    26822
    26821
    26820
    26819
    26818
    26817
    26816
    26815
    26814
    26813
    26812
    26811
    26810
    26809
    26808
    26807
    26806
    26805
    26804
    26803
    26802
    26801
    26800
    26799
    26798
    26797
    26796
    26795
    26794
    26793
    26792
    26791
    26790
    26789
    26788
    26787
    26786
    26785
    26784
    26783
    26782
    26781
    26780
    26779
    26778
    26777
    26776
    26775
    26774
    26773
    26772
    26771
    26770
  ]
]

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\Season No errors.
App\Entity\ExerciseQualification
  • The association App\Entity\ExerciseQualification#exercise refers to the inverse side field App\Entity\Exercise#qualifications which does not exist.
  • The association App\Entity\ExerciseQualification#customer refers to the inverse side field App\Entity\Customer#exerciseQualification which does not exist.
  • The association App\Entity\ExerciseQualification#exercises refers to the owning side field App\Entity\Exercise#qualifications which does not exist.
App\Entity\Strategy No errors.
App\Entity\SeasonPlayer
  • The association App\Entity\SeasonPlayer#minutes refers to the owning side field App\Entity\Minutes#player_id which does not exist.
  • The association App\Entity\SeasonPlayer#playerWeights refers to the owning side field App\Entity\PlayerWeight#season_player_id which does not exist.
  • The mappings App\Entity\SeasonPlayer#captainInGames and App\Entity\GameAlignment#seasonplayer are inconsistent with each other.
App\Entity\Game
  • The association App\Entity\Game#minutes refers to the owning side field App\Entity\Minutes#game_id which does not exist.
  • The mappings App\Entity\Game#rival_alignment and App\Entity\GameAlignment#game are inconsistent with each other.
  • The mappings App\Entity\Game#seasonplayer and App\Entity\GamePlayerStatistics#game are inconsistent with each other.
App\Entity\TrainingAsist No errors.
App\Entity\ExerciseCalendar
  • The association App\Entity\ExerciseCalendar#exerciseUser refers to the inverse side field App\Entity\ExerciseUser#exerciseCalendar which does not exist.
App\Entity\PlayerJustification No errors.