GET https://marker.rp.smartotter.fr/admin/marker?page=1&sort%5Bcreator%5D=ASC

Query Metrics

4 Database Queries
4 Different statements
18.94 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.43 ms
(55.07%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.title AS title_2, m0_.region AS region_3, m0_.comment AS comment_4, m0_.image AS image_5, m0_.pos_x AS pos_x_6, m0_.pos_y AS pos_y_7, m0_.display AS display_8, m0_.creator_id AS creator_id_9 FROM marker m0_ LEFT JOIN `user` u1_ ON m0_.creator_id = u1_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.creator_id ASC
Parameters:
[
  10
  11
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
]
5.17 ms
(27.32%)
1
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM marker m0_ LEFT JOIN `user` u1_ ON m0_.creator_id = u1_.id
Parameters:
[]
2.70 ms
(14.26%)
1
SELECT DISTINCT m0_.id AS id_0, m0_.creator_id AS sclr_1 FROM marker m0_ LEFT JOIN `user` u1_ ON m0_.creator_id = u1_.id ORDER BY m0_.creator_id ASC LIMIT 20
Parameters:
[]
0.63 ms
(3.35%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.grade AS grade_6, t0.company AS company_7, t0.grade_level AS grade_level_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Marker No errors.
App\Entity\User No errors.