GET https://yackr.io/admin/message?page=1&sort%5Bsender%5D=DESC

Query Metrics

6 Database Queries
5 Different statements
14.43 ms Query time
3 Invalid entities
15 Managed entities

Queries

Group similar statements

#▲ Time Info
1 3.03 ms
SELECT DISTINCT m0_.id AS id_0, m0_.sender_id AS sclr_1 FROM message m0_ LEFT JOIN user u1_ ON m0_.sender_id = u1_.id ORDER BY m0_.sender_id DESC LIMIT 20
Parameters:
[]
2 2.15 ms
SELECT m0_.id AS id_0, m0_.slug AS slug_1, m0_.content AS content_2, m0_.image_name AS image_name_3, m0_.created_at AS created_at_4, m0_.is_read AS is_read_5, m0_.sender_id AS sender_id_6, m0_.recipient_id AS recipient_id_7, m0_.qrcode_id AS qrcode_id_8, m0_.conversation_id AS conversation_id_9 FROM message m0_ LEFT JOIN user u1_ ON m0_.sender_id = u1_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.sender_id DESC
Parameters:
[
  b"\x01¡—~ÝCx\x12²[w’hÇ”’"
  b"\x01¡—}£µ~‚”“Ø:–\x16QÁ"
  b"\x01¡–œÒ tV‚kÙ|\x0E&Ã×"
  b"\x01¡šâ”ÅxÁ­\x16̯\x12Õ N"
  b"\x01¡—€\x1Eh}tŠò) gsay"
  b"\x01¡–ž=8tÛªŠç\t]d¤S"
  b"\x01¡–œ{r\t´\x1AÕ\x1D´:Èj"
  b"\x01¡•ïoý\x7F\x1C—„ŸÍ"˜ŒX"
  b"\x01¡•æÞ¬u¯¾¡©nÝÛe>"
  b"\x01¡–§\x07{u\Ÿ†qèT,€2"
]
3 1.60 ms
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM message m0_ LEFT JOIN user u1_ ON m0_.sender_id = u1_.id
Parameters:
[]
4 2.93 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
  b"\x01¡P½µ4y/¯ß¤BÊÜŸc"
]
5 2.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM user t0 WHERE t0.id = ?
Parameters:
[
  b"\x01¡MÄ%\eq^©Á$ß\vL¸"
]
6 2.10 ms
SELECT t0.id AS id_1, t0.pin_code AS pin_code_2, t0.short_slug AS short_slug_3, t0.name AS name_4, t0.mode AS mode_5, t0.assigned_at AS assigned_at_6, t0.image_name AS image_name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.owner_id AS owner_id_10, t0.wall_id AS wall_id_11 FROM qrcode t0 WHERE t0.id = ?
Parameters:
[
  b"\x01¡‘al\fx¦êÛBä\x04ªr"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Message 10
App\Entity\User 2
App\Entity\Conversation 2
App\Entity\Qrcode 1

Entities Mapping

Class Mapping errors
App\Entity\Message
  • The mappings App\Entity\Message#sender and App\Entity\User#sentMessages are inconsistent with each other.
App\Entity\User
  • The association App\Entity\User#sentMessages refers to the owning side field App\Entity\Message#author which does not exist.
App\Entity\Qrcode No errors.
App\Entity\Conversation
  • The association App\Entity\Conversation#qrcode refers to the inverse side field App\Entity\Qrcode#conversations which does not exist.
App\Entity\Wall No errors.
App\Entity\Statistic No errors.