Query Metrics
4
Database Queries
4
Different statements
2.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.82 ms (36.44%) |
1 |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.modifiedon AS modifiedon_4, t0.defaultvalue AS defaultvalue_5, t0.type AS type_6, t0.help AS help_7, t0.display_name AS display_name_8, t0.sourceoptions AS sourceoptions_9 FROM settings t0
Parameters:
[] |
|
0.62 ms (27.57%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.isactive AS isactive_3, t0.description AS description_4, t0.slug AS slug_5, t0.isdeleted AS isdeleted_6, t0.activatedon AS activatedon_7, t0.deletedon AS deletedon_8, t0.navigationtype AS navigationtype_9, t10.id AS id_11, t10.sidebarposition AS sidebarposition_12, t10.css AS css_13, t10.show_info AS show_info_14, t10.show_transcript AS show_transcript_15, t10.show_cast AS show_cast_16, t10.headerimage AS headerimage_17, t10.show_comments AS show_comments_18, t10.theme AS theme_19, t10.comic_id AS comic_id_20, t21.id AS id_22, t21.sunday AS sunday_23, t21.monday AS monday_24, t21.tuesday AS tuesday_25, t21.wednesday AS wednesday_26, t21.thursday AS thursday_27, t21.friday AS friday_28, t21.saturday AS saturday_29, t21.time AS time_30, t21.timezone AS timezone_31, t21.comic_id AS comic_id_32, t0.owner_id AS owner_id_33 FROM comic t0 LEFT JOIN layout t10 ON t10.comic_id = t0.id LEFT JOIN schedule t21 ON t21.comic_id = t0.id WHERE t0.isactive = ? AND t0.activatedon IS NULL
Parameters:
[
0
]
|
|
0.43 ms (19.23%) |
1 |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.email AS email_4, u0_.is_verified AS is_verified_5, u0_.biography AS biography_6, u0_.image AS image_7, u0_.headerimage AS headerimage_8, u0_.name AS name_9, u0_.active AS active_10, u0_.deleted AS deleted_11, u0_.status AS status_12, u0_.request_role AS request_role_13, u0_.createdon AS createdon_14 FROM `user` u0_ WHERE u0_.request_role IS NOT NULL
Parameters:
[] |
|
0.38 ms (16.75%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.isactive AS isactive_3, t0.description AS description_4, t0.slug AS slug_5, t0.isdeleted AS isdeleted_6, t0.activatedon AS activatedon_7, t0.deletedon AS deletedon_8, t0.navigationtype AS navigationtype_9, t10.id AS id_11, t10.sidebarposition AS sidebarposition_12, t10.css AS css_13, t10.show_info AS show_info_14, t10.show_transcript AS show_transcript_15, t10.show_cast AS show_cast_16, t10.headerimage AS headerimage_17, t10.show_comments AS show_comments_18, t10.theme AS theme_19, t10.comic_id AS comic_id_20, t21.id AS id_22, t21.sunday AS sunday_23, t21.monday AS monday_24, t21.tuesday AS tuesday_25, t21.wednesday AS wednesday_26, t21.thursday AS thursday_27, t21.friday AS friday_28, t21.saturday AS saturday_29, t21.time AS time_30, t21.timezone AS timezone_31, t21.comic_id AS comic_id_32, t0.owner_id AS owner_id_33 FROM comic t0 LEFT JOIN layout t10 ON t10.comic_id = t0.id LEFT JOIN schedule t21 ON t21.comic_id = t0.id WHERE t0.isdeleted = ?
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\Settings | No errors. |
| App\Entity\Comic | No errors. |
| App\Entity\Layout | No errors. |
| App\Entity\Schedule | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Page | No errors. |