Query Metrics
5
Database Queries
4
Different statements
1.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.43 ms (31.97%) |
2 |
SELECT a0_.id AS id_0, a0_.images AS images_1, a0_.type AS type_2 FROM app_news a0_ LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id WHERE a1_.published = 1 AND a1_.locale = ? AND (a0_.type = ? OR a0_.type = ? OR a0_.type = ? OR a0_.type = ? OR a0_.type = ?) AND c4_.id = ?
Parameters:
[ "en" "default" "article" "notice" "announcement" "rating" "9" ] |
|
0.41 ms (30.54%) |
1 |
SELECT a0_.id AS id_0, a0_.images AS images_1, a0_.type AS type_2 FROM app_news a0_ LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id WHERE a1_.published = 1 AND a1_.locale = ? AND (a0_.type = ? OR a0_.type = ? OR a0_.type = ?) AND c4_.id = ? ORDER BY a1_.authored DESC LIMIT 9
Parameters:
[ "en" "default" "notice" "rating" "9" ] |
|
0.40 ms (29.57%) |
1 |
SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.email = ? OR s0_.username = ? ORDER BY s1_.id ASC, s3_.id ASC
Parameters:
[ "umk_login_api" "umk_login_api" ] |
|
0.11 ms (7.92%) |
1 |
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
2
]
|
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.