GET http://manager.bouygues.vertuoz.fr/user/sites-roles-data?_=1783005339984&columns%5B0%5D%5Bdata%5D=id&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=fa…

Response
200 OK
Browse referrer URL
IP
81.185.168.174
Profiled on
Token
06f9a4

Query Metrics

14 Database Queries
6 Different statements
8.05 ms Query time
0 Invalid entities
23 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.51 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
]
View formatted query    View runnable query    Explain query
2 0.82 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
]
View formatted query    View runnable query    Explain query
3 0.93 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
]
View formatted query    View runnable query    Explain query
4 0.65 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
]
View formatted query    View runnable query    Explain query
5 0.32 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
]
View formatted query    View runnable query    Explain query
6 0.75 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
]
View formatted query    View runnable query    Explain query
7 0.62 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
]
View formatted query    View runnable query    Explain query
8 0.56 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
]
View formatted query    View runnable query    Explain query
9 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
]
View formatted query    View runnable query    Explain query
10 0.57 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
]
View formatted query    View runnable query    Explain query
11 0.34 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: 
[
  10
]
View formatted query    View runnable query    Explain query
12 0.31 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: 
[
  10
]
View formatted query    View runnable query    Explain query
13 0.64 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_.email ASC LIMIT 25
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query
14 0.52 ms 
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
]
View formatted query    View runnable query    Explain query

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.