Query Metrics
14
Database Queries
7
Different statements
16.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.49 ms (26.70%) |
8 |
SELECT t0.expiration AS expiration_1, t0.extend AS extend_2, t0.locked AS locked_3, t0.active AS active_4, t0.user_id AS user_id_5, t0.book_id AS book_id_6, t0.code_id AS code_id_7 FROM wow_subscription t0 WHERE ((t0.active = ? AND t0.book_id = ?) AND t0.user_id = ?)
Parameters:
[ 1 7 624 ] |
|
4.36 ms (25.91%) |
1 |
SELECT s0_.id AS id_0, s0_.facebook_id AS facebook_id_1, s0_.google_id AS google_id_2, s0_.apple_id AS apple_id_3, s0_.username AS username_4, s0_.password AS password_5, s0_.email AS email_6, s0_.created AS created_7, s0_.active AS active_8, s0_.group_id AS group_id_9, s0_.language_id AS language_id_10, s0_.country_id AS country_id_11, s0_.code_game_bank_id AS code_game_bank_id_12 FROM sm_user s0_ WHERE s0_.username = ? OR s0_.email = ?
Parameters:
[ "test@test.cz" "test@test.cz" ] |
|
3.12 ms (18.53%) |
1 |
SELECT w0_.id AS id_0, w0_.title AS title_1, w0_.position AS position_2, w1_.id AS id_3, w1_.resolution AS resolution_4, w1_.uri AS uri_5, w1_.discr AS discr_6, w2_.book_id AS book_id_7 FROM wow_book w0_ LEFT JOIN wow_book_icon w2_ ON w0_.id = w2_.book_id LEFT JOIN wow_resource w1_ ON w2_.id = w1_.id ORDER BY w0_.position ASC
Parameters:
[] |
|
2.56 ms (15.24%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.atribute_id AS atribute_id_4 FROM sm_user_attribute_value t0 WHERE t0.user_id IN (?)
Parameters:
[
[
624
]
]
|
|
0.96 ms (5.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.role AS role_3 FROM sm_user_group t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.76 ms (4.53%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.direction AS direction_3, t0.priority AS priority_4, t0.active AS active_5, t0.date_format AS date_format_6 FROM sm_language t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.57 ms (3.37%) |
1 |
SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?
Parameters:
[
"82ab7873a581e91448a151ba60bd5b6016d6b4a09d18524eaeb66b7f60f802799b28d311006f3c45"
]
|
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 |
|---|---|
| League\Bundle\OAuth2ServerBundle\Model\AccessToken | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\Client | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserGroup | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Code | No errors. |
| App\Entity\CodeGameBank | No errors. |
| App\Entity\UserAttributeValue | No errors. |
| App\Entity\IntextConcept | No errors. |
| App\Entity\SectionBackup | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\UserAttribute | No errors. |
| App\Entity\SectionAcl | No errors. |
| App\Entity\Book | No errors. |
| App\Entity\Resource | No errors. |
| App\Entity\BookIcon | No errors. |
| App\Entity\Unit | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Intext | No errors. |
| App\Entity\Slug | No errors. |