GET https://marker.rp.smartotter.fr/admin/user?page=1&sort%5Bid%5D=DESC

Query Metrics

20 Database Queries
4 Different statements
14.71 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3.31 ms
SELECT DISTINCT u0_.id AS id_0, u0_.id AS id_1 FROM `user` u0_ ORDER BY u0_.id DESC LIMIT 20
Parameters:
[]
2 1.60 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.grade AS grade_5, u0_.company AS company_6, u0_.grade_level AS grade_level_7 FROM `user` u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY u0_.id DESC
Parameters:
[
  38
  37
  35
  34
  31
  29
  28
  25
  24
  23
  22
  13
  10
  6
  4
  3
  1
]
3 0.96 ms
SELECT count(*) AS sclr_0 FROM `user` u0_
Parameters:
[]
4 1.01 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  38
]
5 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  37
]
6 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  35
]
7 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  34
]
8 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  31
]
9 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  29
]
10 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  28
]
11 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  25
]
12 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  24
]
13 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  23
]
14 0.66 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  22
]
15 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  13
]
16 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  10
]
17 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  6
]
18 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  4
]
19 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_id = ?
Parameters:
[
  3
]
20 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.region AS region_4, t0.comment AS comment_5, t0.image AS image_6, t0.pos_x AS pos_x_7, t0.pos_y AS pos_y_8, t0.display AS display_9, t0.creator_id AS creator_id_10 FROM marker t0 WHERE t0.creator_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\User No errors.
App\Entity\Marker No errors.