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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.76 ms
SELECT DISTINCT u0_.id AS id_0, u0_.grade_level AS grade_level_1 FROM `user` u0_ ORDER BY u0_.grade_level DESC LIMIT 20
Parameters:
[]
2 1.01 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_.grade_level DESC
Parameters:
[
  38
  29
  24
  34
  31
  28
  25
  23
  22
  10
  35
  37
  1
  6
  13
  4
  3
]
3 1.95 ms
SELECT count(*) AS sclr_0 FROM `user` u0_
Parameters:
[]
4 3.49 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.32 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
]
6 1.91 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
]
7 7.05 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 1.71 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.34 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
]
10 6.67 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
]
11 2.97 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
]
12 6.71 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
]
13 3.08 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
]
14 3.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:
[
  35
]
15 2.99 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
]
16 3.63 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
]
17 9.73 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 1.49 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
]
19 8.70 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
]
20 2.89 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
]

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.