Query Metrics

26 Database Queries
6 Different statements
11.30 ms Query time
0 Invalid entities
44 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 ms
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
]
2 0.87 ms
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
]
3 0.73 ms
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
]
4 0.72 ms
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
]
5 0.53 ms
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
]
6 0.51 ms
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
]
7 0.27 ms
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
]
8 0.66 ms
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
]
9 0.54 ms
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
]
10 0.52 ms
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
]
11 0.49 ms
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
]
12 0.52 ms
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
]
13 0.48 ms
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
]
14 0.35 ms
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:
[
  9
  10
]
15 0.32 ms
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:
[
  9
  10
]
16 0.77 ms
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_.nom ASC LIMIT 25
Parameters:
[
  9
  10
]
17 0.32 ms
SELECT u0_.id AS id_0, u0_.console_permissions AS console_permissions_1, u0_.platform_user_id AS platform_user_id_2, u0_.environment_id AS environment_id_3 FROM user_environment_access u0_ WHERE u0_.environment_id = ? AND u0_.platform_user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  9
  2
  425
  566
  420
  498
  516
  567
  78
  416
]
18 0.31 ms
SELECT u0_.id AS id_0, u0_.console_permissions AS console_permissions_1, u0_.platform_user_id AS platform_user_id_2, u0_.environment_id AS environment_id_3 FROM user_environment_access u0_ WHERE u0_.environment_id = ? AND u0_.platform_user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  10
  2
  425
  566
  420
  498
  516
  567
  78
  416
]
19 0.24 ms
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:
[
  425
]
20 0.25 ms
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:
[
  566
]
21 0.25 ms
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:
[
  420
]
22 0.24 ms
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:
[
  498
]
23 0.24 ms
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:
[
  516
]
24 0.24 ms
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:
[
  567
]
25 0.24 ms
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:
[
  78
]
26 0.28 ms
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:
[
  416
]

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 28
App\Entity\User 9
App\Entity\Environment 7