Query Metrics
17
Database Queries
5
Different statements
14.74 ms
Query time
6
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.51 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 | 1.39 ms |
SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM coupon c0_ ORDER BY c0_.id DESC LIMIT 15
Parameters:
[] |
3 | 1.19 ms |
SELECT c0_.id AS id_0, c0_.is_generated_promo_code AS is_generated_promo_code_1, c0_.promo_code AS promo_code_2, c0_.expires_at AS expires_at_3, c0_.limit_uses AS limit_uses_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM coupon c0_ WHERE c0_.id IN (?) ORDER BY c0_.id DESC
Parameters:
[ [ 118 117 116 115 114 113 112 110 109 108 107 88 57 ] ] |
4 | 0.82 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
118
]
|
5 | 1.04 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
117
]
|
6 | 0.66 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
116
]
|
7 | 1.10 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
115
]
|
8 | 0.66 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
114
]
|
9 | 0.65 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
113
]
|
10 | 0.62 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
112
]
|
11 | 0.60 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
110
]
|
12 | 0.52 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
109
]
|
13 | 0.47 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
108
]
|
14 | 0.45 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
107
]
|
15 | 0.71 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
88
]
|
16 | 1.96 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.coupon_id AS coupon_id_4, t0.customer_id AS customer_id_5 FROM coupon_customer t0 WHERE t0.coupon_id = ?
Parameters:
[
57
]
|
17 | 0.39 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM coupon c0_
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. |