Query Metrics
24
Database Queries
5
Different statements
6.82 ms
Query time
0
Invalid entities
22
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.67 ms (68.50%) |
16 |
SELECT t0.id AS id_1, t0.parameter_key AS parameter_key_2, t0.parameter_value AS parameter_value_3, t0.parameter_label AS parameter_label_4, t0.parameter_type AS parameter_type_5, t0.parameter_category AS parameter_category_6 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
"principalColor"
]
|
|
0.76 ms (11.11%) |
4 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.content AS content_4 FROM policy_term t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"cgu"
]
|
|
0.56 ms (8.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"apropos"
]
|
|
0.44 ms (6.46%) |
1 |
SELECT t0.id AS id_1, t0.link_name AS link_name_2, t0.url AS url_3, t0.on_top AS on_top_4, t0.ordre AS ordre_5, t0.visibility AS visibility_6, t0.link_type AS link_type_7, t0.page_id AS page_id_8 FROM menu t0 ORDER BY t0.ordre ASC
Parameters:
[] |
|
0.39 ms (5.75%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.content AS content_4, t0.image_bkg AS image_bkg_5, t0.header_image AS header_image_6, t0.subtitle AS subtitle_7 FROM page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
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\Parameter | 11 |
| App\Entity\Menu | 4 |
| App\Entity\PolicyTerm | 4 |
| App\Entity\Page | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| App\Entity\Parameter | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\PolicyTerm | No errors. |