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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.36 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
Parameters:
[]
2 0.24 ms
SELECT COUNT(*) FROM reference t0
Parameters:
[]
3 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:
[
  163
]
4 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:
[
  162
]
5 0.18 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:
[
  161
]
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:
[
  160
]
7 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:
[
  159
]
8 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:
[
  155
]
9 0.18 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:
[
  152
]
10 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:
[
  139
]
11 0.17 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:
[
  138
]
12 0.17 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:
[
  137
]
13 0.18 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:
[
  135
]
14 0.18 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:
[
  133
]

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.