Query Metrics
14
Database Queries
6
Different statements
8.05 ms
Query time
0
Invalid entities
23
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.40 ms (67.16%) |
8 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.slug AS slug_2, e0_.base_url AS base_url_3, e0_.status AS status_4, e0_.database_dsn_cipher AS database_dsn_cipher_5, e0_.instance_shared_secret_cipher AS instance_shared_secret_cipher_6, e0_.last_schema_version AS last_schema_version_7, e0_.created_at AS created_at_8, e0_.instance_deploy_path AS instance_deploy_path_9, e0_.provision_status AS provision_status_10, e0_.provision_log AS provision_log_11 FROM environment e0_ INNER JOIN user_environment_access u1_ ON e0_.id = u1_.environment_id WHERE u1_.platform_user_id = ? AND u1_.console_permissions IS NOT NULL AND u1_.console_permissions <> '' AND u1_.console_permissions <> '[]' ORDER BY e0_.name ASC
Parameters:
[
2
]
|
|
0.65 ms (8.03%) |
2 |
SELECT COUNT(DISTINCT u0_.id) AS sclr_0 FROM user u0_ INNER JOIN user_environment_access u1_ ON u0_.id = u1_.platform_user_id WHERE u1_.environment_id IN (?)
Parameters:
[
10
]
|
|
0.64 ms (7.99%) |
1 |
SELECT DISTINCT u0_.id AS id_0, u0_.statut AS statut_1, u0_.email AS email_2, u0_.prenom AS prenom_3, u0_.nom AS nom_4, u0_.trigramme AS trigramme_5, u0_.roles AS roles_6, u0_.password AS password_7, u0_.api_token AS api_token_8, u0_.central_id AS central_id_9, u0_.externe AS externe_10, u0_.tabs_at_login AS tabs_at_login_11, u0_.avatar AS avatar_12, u0_.langage AS langage_13, u0_.token_refresh AS token_refresh_14, u0_.date_refresh AS date_refresh_15, u0_.notes AS notes_16, u0_.responsable_id AS responsable_id_17 FROM user u0_ INNER JOIN user_environment_access u1_ ON u0_.id = u1_.platform_user_id WHERE u1_.environment_id IN (?) ORDER BY u0_.email ASC LIMIT 25
Parameters:
[
10
]
|
|
0.52 ms (6.49%) |
1 |
SELECT u0_.id AS id_0, u0_.console_permissions AS console_permissions_1, r1_.id AS id_2, r1_.code AS code_3, r1_.libelle AS libelle_4, r1_.hierarchie AS hierarchie_5, u2_.id AS id_6, u2_.est_principale AS est_principale_7, s3_.id AS id_8, s3_.libelle AS libelle_9, s3_.adresse AS adresse_10, s3_.codepostal AS codepostal_11, s3_.ville AS ville_12, s3_.telephone AS telephone_13, s3_.mail AS mail_14, s3_.pays_code AS pays_code_15, s3_.enabled AS enabled_16, s3_.remote_id AS remote_id_17, s3_.created_at AS created_at_18, s3_.updated_at AS updated_at_19, u0_.platform_user_id AS platform_user_id_20, u0_.environment_id AS environment_id_21, r1_.parent_id AS parent_id_22, r1_.context_id AS context_id_23, u2_.access_id AS access_id_24, u2_.site_id AS site_id_25, s3_.environment_id AS environment_id_26 FROM user_environment_access u0_ LEFT JOIN user_environment_role u4_ ON u0_.id = u4_.user_environment_access_id LEFT JOIN role r1_ ON r1_.id = u4_.role_id LEFT JOIN user_environment_site u2_ ON u0_.id = u2_.access_id LEFT JOIN site s3_ ON u2_.site_id = s3_.id WHERE u0_.environment_id = ? AND u0_.platform_user_id IN (?, ?, ?)
Parameters:
[ 10 425 2 462 ] |
|
0.51 ms (6.31%) |
1 |
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.email AS email_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.trigramme AS trigramme_6, t0.roles AS roles_7, t0.password AS password_8, t0.api_token AS api_token_9, t0.central_id AS central_id_10, t0.externe AS externe_11, t0.tabs_at_login AS tabs_at_login_12, t0.avatar AS avatar_13, t0.langage AS langage_14, t0.token_refresh AS token_refresh_15, t0.date_refresh AS date_refresh_16, t0.notes AS notes_17, t0.responsable_id AS responsable_id_18 FROM user t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.32 ms (4.03%) |
1 |
SELECT t0.id AS id_1, t0.console_permissions AS console_permissions_2, t0.platform_user_id AS platform_user_id_3, t0.environment_id AS environment_id_4 FROM user_environment_access t0 WHERE t0.platform_user_id = ?
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\UserEnvironmentAccess | 6 |
| App\Entity\UserEnvironmentSite | 6 |
| App\Entity\Environment | 4 |
| App\Entity\User | 3 |
| App\Entity\Role | 2 |
| App\Entity\Site | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserEnvironmentAccess | No errors. |
| App\Entity\DroitInvisible | No errors. |
| App\Entity\MenuInvisible | No errors. |
| App\Entity\Environment | No errors. |
| App\Entity\Site | No errors. |
| App\Entity\EnvironmentFormIndex | No errors. |
| App\Entity\EnvironmentRoleDroit | No errors. |
| App\Entity\HabilitationType | No errors. |
| App\Entity\Role | No errors. |
| App\Entity\UserEnvironmentSite | No errors. |
| App\Entity\UserHabilitation | No errors. |
| App\Entity\AppContexte | No errors. |
| App\Entity\RoleDroit | No errors. |
| App\Entity\RoleMenu | No errors. |