http://tao.api.d.dwm.dev/users?page=1&sort=createdAt%7CDESC

Query Metrics

7 Database Queries
4 Different statements
8.02 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.34 ms
(41.64%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.place_name AS place_name_3, t0.description AS description_4, t0.restaurant_enabled AS restaurant_enabled_5, t0.meta AS meta_6, t0.session_rate AS session_rate_7, t0.media_id AS media_id_8 FROM dwm_area t0 WHERE t0.id = ?
Parameters:
[
  "a6f8f2fb-e67f-4a8d-8442-a6a3499f18d2"
]
1.83 ms
(22.78%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.roles AS roles_5, t0.twofa AS twofa_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM dwm_admin t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "admin"
]
1.74 ms
(21.67%)
1
SELECT d0_.id AS id_0, d0_.email AS email_1, d0_.password AS password_2, d0_.firstname AS firstname_3, d0_.lastname AS lastname_4, d0_.gender AS gender_5, d0_.address AS address_6, d0_.twofa AS twofa_7, d0_.phone AS phone_8, d0_.birthday_at AS birthday_at_9, d0_.imported_at AS imported_at_10, d0_.opt_out AS opt_out_11, d0_.deleted_at AS deleted_at_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.last_login_at AS last_login_at_15, d0_.area_id AS area_id_16 FROM dwm_user d0_ WHERE d0_.deleted_at IS NULL ORDER BY d0_.created_at DESC LIMIT 20
Parameters:
[]
1.12 ms
(13.92%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT d0_.id AS id_0, d0_.email AS email_1, d0_.password AS password_2, d0_.firstname AS firstname_3, d0_.lastname AS lastname_4, d0_.gender AS gender_5, d0_.address AS address_6, d0_.twofa AS twofa_7, d0_.phone AS phone_8, d0_.birthday_at AS birthday_at_9, d0_.imported_at AS imported_at_10, d0_.opt_out AS opt_out_11, d0_.deleted_at AS deleted_at_12, d0_.created_at AS created_at_13, d0_.updated_at AS updated_at_14, d0_.last_login_at AS last_login_at_15 FROM dwm_user d0_ WHERE d0_.deleted_at IS NULL ORDER BY d0_.created_at DESC) dctrn_result) dctrn_table
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\Pims\PimsUser No errors.
App\Entity\User
  • The field App\Entity\User#wallets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Wallet#user does not contain the required 'inversedBy="wallets"' attribute.
App\Entity\Admin No errors.
App\Entity\Area No errors.
App\Entity\Wallet No errors.
App\Entity\Media No errors.
App\Entity\Show\Price No errors.
App\Entity\Show\Session\SittingPlacePrice No errors.
App\Entity\Show\Session\SittingPlace No errors.
App\Entity\Show\Session\SittingPlaceOwner No errors.
App\Entity\Cart\Row No errors.
App\Entity\Smilebox\Ticket No errors.
App\Entity\Show\Session\Reservation No errors.
App\Entity\Show\Session
  • The field App\Entity\Show\Session#state is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Show\Session\State#session does not contain the required 'inversedBy="state"' attribute.
App\Entity\PromotionalCode
  • The field App\Entity\PromotionalCode#prices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PromotionalCode\Price#code does not contain the required 'inversedBy="prices"' attribute.
App\Entity\Reservation\Row No errors.
App\Entity\Quotation No errors.