Query Metrics
204
Database Queries
6
Different statements
149.82 ms
Query time
10
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
62.32 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.email_club AS email_club_11, t0.number_clubes_league AS number_clubes_league_12, t0.type_soccer_id AS type_soccer_id_13, t0.alignment_default_u7_id AS alignment_default_u7_id_14, t0.alignment_default_u8_id AS alignment_default_u8_id_15, t0.alignment_default_u11_id AS alignment_default_u11_id_16 FROM team t0 WHERE t0.id = ?
Parameters:
[
27406
]
|
51.72 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:
[
27165
]
|
32.00 ms (0.00%) |
1 |
SELECT COUNT(c0_.id) AS sclr_0 FROM customer c0_
Parameters:
[] |
2.04 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:
[ [ 27165 27164 27163 27162 27161 27160 27159 27158 27157 27156 27155 27154 27153 27152 27151 27150 27149 27148 27147 27146 27145 27144 27143 27142 27141 27140 27139 27138 27137 27136 27135 27134 27133 27132 27131 27130 27129 27128 27127 27126 27125 27124 27123 27122 27121 27120 27119 27118 27117 27116 27115 27114 27113 27112 27111 27110 27109 27108 27107 27106 27105 27104 27103 27102 27101 27100 27099 27098 27097 27096 27095 27094 27093 27092 27091 27090 27089 27088 27087 27086 27085 27084 27083 27082 27081 27080 27079 27078 27077 27076 27075 27074 27073 27072 27071 27070 27069 27068 27067 27066 ] ] |
0.99 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
]
|
0.75 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:
[] |
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 |
|
App\Entity\AppModule |
|
App\Entity\Support |
|
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 |
|
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 |
|
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 |
|
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 |
|
App\Entity\Strategy | No errors. |
App\Entity\SeasonPlayer |
|
App\Entity\Game |
|
App\Entity\TrainingAsist | No errors. |
App\Entity\ExerciseCalendar |
|
App\Entity\PlayerJustification | No errors. |