https://dev.mywowenglish.com/api/books

Query Metrics

14 Database Queries
7 Different statements
16.82 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
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"
]
2 4.36 ms
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 2.56 ms
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
  ]
]
4 0.96 ms
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
]
5 3.12 ms
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:
[]
6 0.76 ms
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
]
7 3.11 ms
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
]
8 0.28 ms
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
  2
  624
]
9 0.28 ms
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
  1
  624
]
10 0.17 ms
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
  3
  624
]
11 0.17 ms
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
  4
  624
]
12 0.17 ms
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
  6
  624
]
13 0.14 ms
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
  5
  624
]
14 0.17 ms
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
  8
  624
]

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.