Query Metrics
8
Database Queries
7
Different statements
5.54 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
3.37 ms (60.86%) |
1 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.pid AS pid_3, t0.path AS path_4, t0.name AS name_5, t0.title AS title_6, t0.description AS description_7, t0.keywords AS keywords_8, t0.teaser AS teaser_9, t0.navbar AS navbar_10, t0.navbarsort AS navbarsort_11, t0.navfooter AS navfooter_12, t0.navfootersort AS navfootersort_13, t0.published AS published_14, t0.`from` AS from_15, t0.`to` AS to_16, t0.template AS template_17, t0.controller AS controller_18, t0.cache AS cache_19, t0.sort AS sort_20, t0.sitemap AS sitemap_21, t0.protected AS protected_22, t0.membergroups AS membergroups_23, t0.date AS date_24, t0.is_root AS is_root_25, t0.class AS class_26, t0.redirect_account AS redirect_account_27, t0.redirect_login AS redirect_login_28, t0.redirect_index AS redirect_index_29 FROM c_page t0 WHERE t0.alias = ? AND t0.published = ? LIMIT 1
Parameters:
[ "moebel" 1 ] |
|
0.64 ms (11.49%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.class AS class_4, t0.description AS description_5, t0.settings AS settings_6, t0.sort AS sort_7, t0.template AS template_8, t0.target AS target_9, t0.date AS date_10 FROM c_module t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.36 ms (6.48%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pid AS pid_3, t0.cid AS cid_4, t0.sort AS sort_5, t0.modid AS modid_6, t0.formid AS formid_7, t0.template AS template_8, t0.headline AS headline_9, t0.headlinestyles AS headlinestyles_10, t0.text AS text_11, t0.class AS class_12, t0.container AS container_13, t0.cols AS cols_14, t0.link AS link_15, t0.linktext AS linktext_16, t0.linktitle AS linktitle_17, t0.linkclass AS linkclass_18, t0.linktarget AS linktarget_19, t0.img AS img_20, t0.imgstyles AS imgstyles_21, t0.imgclass AS imgclass_22, t0.imgtitle AS imgtitle_23, t0.imglink AS imglink_24, t0.imglinktarget AS imglinktarget_25, t0.published AS published_26, t0.`from` AS from_27, t0.`to` AS to_28, t0.date AS date_29, t0.addfields AS addfields_30, t0.type AS type_31, t0.imgtitle_caption AS imgtitle_caption_32, t0.imgtitle_position AS imgtitle_position_33 FROM c_content t0 WHERE t0.type = ? AND t0.published = ? LIMIT 1
Parameters:
[ "header" 1 ] |
|
0.32 ms (5.85%) |
1 |
SELECT c0_.id AS id_0, c0_.alias AS alias_1, c0_.pid AS pid_2, c0_.path AS path_3, c0_.name AS name_4, c0_.title AS title_5, c0_.description AS description_6, c0_.keywords AS keywords_7, c0_.teaser AS teaser_8, c0_.navbar AS navbar_9, c0_.navbarsort AS navbarsort_10, c0_.navfooter AS navfooter_11, c0_.navfootersort AS navfootersort_12, c0_.published AS published_13, c0_.`from` AS from_14, c0_.`to` AS to_15, c0_.template AS template_16, c0_.controller AS controller_17, c0_.cache AS cache_18, c0_.sort AS sort_19, c0_.sitemap AS sitemap_20, c0_.protected AS protected_21, c0_.membergroups AS membergroups_22, c0_.date AS date_23, c0_.is_root AS is_root_24, c0_.class AS class_25, c0_.redirect_account AS redirect_account_26, c0_.redirect_login AS redirect_login_27, c0_.redirect_index AS redirect_index_28 FROM c_page c0_ WHERE c0_.navfooter = 1 AND c0_.published = 1 AND ((c0_.pid < 1 OR c0_.pid IS NULL)) ORDER BY c0_.navfootersort ASC, c0_.sort ASC
Parameters:
[] |
|
0.31 ms (5.58%) |
1 |
SELECT c0_.id AS id_0, c0_.alias AS alias_1, c0_.pid AS pid_2, c0_.path AS path_3, c0_.name AS name_4, c0_.title AS title_5, c0_.description AS description_6, c0_.keywords AS keywords_7, c0_.teaser AS teaser_8, c0_.navbar AS navbar_9, c0_.navbarsort AS navbarsort_10, c0_.navfooter AS navfooter_11, c0_.navfootersort AS navfootersort_12, c0_.published AS published_13, c0_.`from` AS from_14, c0_.`to` AS to_15, c0_.template AS template_16, c0_.controller AS controller_17, c0_.cache AS cache_18, c0_.sort AS sort_19, c0_.sitemap AS sitemap_20, c0_.protected AS protected_21, c0_.membergroups AS membergroups_22, c0_.date AS date_23, c0_.is_root AS is_root_24, c0_.class AS class_25, c0_.redirect_account AS redirect_account_26, c0_.redirect_login AS redirect_login_27, c0_.redirect_index AS redirect_index_28 FROM c_page c0_ WHERE c0_.navbar = 1 AND c0_.published = 1 AND ((c0_.pid < 1 OR c0_.pid IS NULL)) ORDER BY c0_.navbarsort ASC
Parameters:
[] |
|
0.30 ms (5.34%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.pid AS pid_3, t0.cid AS cid_4, t0.sort AS sort_5, t0.modid AS modid_6, t0.formid AS formid_7, t0.template AS template_8, t0.headline AS headline_9, t0.headlinestyles AS headlinestyles_10, t0.text AS text_11, t0.class AS class_12, t0.container AS container_13, t0.cols AS cols_14, t0.link AS link_15, t0.linktext AS linktext_16, t0.linktitle AS linktitle_17, t0.linkclass AS linkclass_18, t0.linktarget AS linktarget_19, t0.img AS img_20, t0.imgstyles AS imgstyles_21, t0.imgclass AS imgclass_22, t0.imgtitle AS imgtitle_23, t0.imglink AS imglink_24, t0.imglinktarget AS imglinktarget_25, t0.published AS published_26, t0.`from` AS from_27, t0.`to` AS to_28, t0.date AS date_29, t0.addfields AS addfields_30, t0.type AS type_31, t0.imgtitle_caption AS imgtitle_caption_32, t0.imgtitle_position AS imgtitle_position_33 FROM c_content t0 WHERE t0.pid = ? AND t0.published = ? ORDER BY t0.sort ASC
Parameters:
[ 2 1 ] |
|
0.24 ms (4.40%) |
1 |
SELECT t0.id AS id_1, t0.alias AS alias_2, t0.pid AS pid_3, t0.path AS path_4, t0.name AS name_5, t0.title AS title_6, t0.description AS description_7, t0.keywords AS keywords_8, t0.teaser AS teaser_9, t0.navbar AS navbar_10, t0.navbarsort AS navbarsort_11, t0.navfooter AS navfooter_12, t0.navfootersort AS navfootersort_13, t0.published AS published_14, t0.`from` AS from_15, t0.`to` AS to_16, t0.template AS template_17, t0.controller AS controller_18, t0.cache AS cache_19, t0.sort AS sort_20, t0.sitemap AS sitemap_21, t0.protected AS protected_22, t0.membergroups AS membergroups_23, t0.date AS date_24, t0.is_root AS is_root_25, t0.class AS class_26, t0.redirect_account AS redirect_account_27, t0.redirect_login AS redirect_login_28, t0.redirect_index AS redirect_index_29 FROM c_page t0 WHERE t0.is_root = ? LIMIT 1
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| master | doctrine.dbal.master_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| master | doctrine.orm.master_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| App\Entity\Content | No errors. |
| App\Entity\Module | No errors. |
master entity manager
No loaded entities.