Query Metrics
4
Database Queries
4
Different statements
11.63 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
7.69 ms (66.16%) |
1 |
SELECT t0_.id AS id_0, t0_.active AS active_1, t0_.title AS title_2, t0_.content AS content_3, t0_.chapo AS chapo_4, t0_.created_at AS created_at_5, t0_.pdf AS pdf_6, t0_.pinned AS pinned_7, t0_.category_id AS category_id_8, t0_.author_id AS author_id_9 FROM tuto t0_ WHERE t0_.active = ? AND t0_.category_id = ? AND t0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY t0_.created_at DESC
Parameters:
[ 1 5 74 73 72 71 70 69 ] |
1.55 ms (13.35%) |
1 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.name AS name_3, t0.color AS color_4, t0.position AS position_5, t0.created_at AS created_at_6 FROM la_base_category t0 WHERE t0.enabled = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
1.53 ms (13.15%) |
1 |
SELECT count(DISTINCT t0_.id) AS sclr_0 FROM tuto t0_ WHERE t0_.active = ? AND t0_.category_id = ?
Parameters:
[ 1 5 ] |
0.85 ms (7.34%) |
1 |
SELECT DISTINCT t0_.id AS id_0, t0_.created_at AS created_at_1 FROM tuto t0_ WHERE t0_.active = ? AND t0_.category_id = ? ORDER BY t0_.created_at DESC LIMIT 6
Parameters:
[ 1 5 ] |
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Tuto | 6 |
App\Entity\LaBaseCategory | 4 |
App\Entity\User | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\LaBaseCategory | No errors. |
App\Entity\Tuto | No errors. |
App\Entity\User | No errors. |
App\Entity\Keywords | No errors. |
App\Entity\Lexique | No errors. |