Query Metrics
9
Database Queries
3
Different statements
7.75 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.03 ms |
SELECT t0.grp AS grp_1, t0.id AS id_2, t0.position AS position_3, t0.info AS info_4, t0.description AS description_5, t0.value AS value_6, t0.filter AS filter_7, t0.type AS type_8, t0.params AS params_9, t0.timestamp AS timestamp_10 FROM parameters t0 WHERE t0.grp = ? AND t0.id = ? LIMIT 1
Parameters:
[ "main" "webtitle" ] |
| 2 | 0.73 ms |
SELECT t0.grp AS grp_1, t0.id AS id_2, t0.position AS position_3, t0.info AS info_4, t0.description AS description_5, t0.value AS value_6, t0.filter AS filter_7, t0.type AS type_8, t0.params AS params_9, t0.timestamp AS timestamp_10 FROM parameters t0 WHERE t0.grp = ? AND t0.id = ? LIMIT 1
Parameters:
[ "main" "weblogo" ] |
| 3 | 0.69 ms |
SELECT t0.grp AS grp_1, t0.id AS id_2, t0.position AS position_3, t0.info AS info_4, t0.description AS description_5, t0.value AS value_6, t0.filter AS filter_7, t0.type AS type_8, t0.params AS params_9, t0.timestamp AS timestamp_10 FROM parameters t0 WHERE t0.grp = ? AND t0.id = ? LIMIT 1
Parameters:
[ "main" "favicon" ] |
| 4 | 0.75 ms |
SELECT t0.message_id AS message_id_1, t0.filter AS filter_2, t0.language_id AS language_id_3, t0.title AS title_4, t0.content AS content_5, t0.info AS info_6, t0.timestamp AS timestamp_7 FROM messages t0 WHERE t0.message_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "FooterPart1" "DE" ] |
| 5 | 0.72 ms |
SELECT t0.message_id AS message_id_1, t0.filter AS filter_2, t0.language_id AS language_id_3, t0.title AS title_4, t0.content AS content_5, t0.info AS info_6, t0.timestamp AS timestamp_7 FROM messages t0 WHERE t0.message_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "FooterPart2" "DE" ] |
| 6 | 0.72 ms |
SELECT t0.message_id AS message_id_1, t0.filter AS filter_2, t0.language_id AS language_id_3, t0.title AS title_4, t0.content AS content_5, t0.info AS info_6, t0.timestamp AS timestamp_7 FROM messages t0 WHERE t0.message_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "FooterPart3" "DE" ] |
| 7 | 0.71 ms |
SELECT t0.message_id AS message_id_1, t0.filter AS filter_2, t0.language_id AS language_id_3, t0.title AS title_4, t0.content AS content_5, t0.info AS info_6, t0.timestamp AS timestamp_7 FROM messages t0 WHERE t0.message_id = ? AND t0.language_id = ? LIMIT 1
Parameters:
[ "FooterPart4" "DE" ] |
| 8 | 0.75 ms |
SELECT t0.grp AS grp_1, t0.id AS id_2, t0.position AS position_3, t0.info AS info_4, t0.description AS description_5, t0.value AS value_6, t0.filter AS filter_7, t0.type AS type_8, t0.params AS params_9, t0.timestamp AS timestamp_10 FROM parameters t0 WHERE t0.grp = ? AND t0.id = ? LIMIT 1
Parameters:
[ "system" "selfregister" ] |
| 9 | 0.65 ms |
SELECT t0.id AS id_1, t0.info AS info_2, t0.devmode AS devmode_3, t0.param_version AS param_version_4, t0.message_version AS message_version_5 FROM sysinfo t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
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\Parameters | No errors. |
| App\Entity\Messages | No errors. |
| App\Entity\Sysinfo |
|