GET http://www.devillejsa.be/references/load?category=all&page=2

Query Metrics

14 Database Queries
3 Different statements
3.28 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.category_id AS category_id_3 FROM reference t0 ORDER BY t0.id DESC LIMIT 12 OFFSET 12
Parameters:
[]
2 0.24 ms
SELECT COUNT(*) FROM reference t0
Parameters:
[]
3 0.26 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  186
]
4 0.25 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  185
]
5 0.21 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  184
]
6 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  183
]
7 0.21 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  182
]
8 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  181
]
9 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  179
]
10 0.21 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  178
]
11 0.25 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  177
]
12 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  176
]
13 0.19 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  175
]
14 0.20 ms
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.reference_id AS reference_id_3 FROM photo t0 WHERE t0.reference_id = ?
Parameters:
[
  174
]

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\Reference No errors.
App\Entity\Category No errors.
App\Entity\Photo No errors.