Query Metrics

2 Database Queries
2 Different statements
0.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.32 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.password_token AS password_token_6, t0.password_token_at AS password_token_at_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.phone_number AS phone_number_10, t0.description AS description_11, t0.role_description AS role_description_12, t0.avatar AS avatar_13, t0.avatar_path AS avatar_path_14, t0.gender AS gender_15, t0.birth_at AS birth_at_16, t0.is_verified AS is_verified_17, t0.signing_limit_date AS signing_limit_date_18, t0.last_connected_at AS last_connected_at_19, t0.created_from_import AS created_from_import_20, t0.address_street AS address_street_21, t0.address_post_code AS address_post_code_22, t0.address_city AS address_city_23, t0.address_country AS address_country_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t27.id AS id_28, t27.created_at AS created_at_29, t27.user_id AS user_id_30, t27.channel_id AS channel_id_31, t27.created_by_id AS created_by_id_32, t0.created_by_id AS created_by_id_33, t34.id AS id_35, t34.email AS email_36, t34.roles AS roles_37, t34.password AS password_38, t34.enabled AS enabled_39, t34.password_token AS password_token_40, t34.password_token_at AS password_token_at_41, t34.first_name AS first_name_42, t34.last_name AS last_name_43, t34.phone_number AS phone_number_44, t34.description AS description_45, t34.role_description AS role_description_46, t34.avatar AS avatar_47, t34.avatar_path AS avatar_path_48, t34.gender AS gender_49, t34.birth_at AS birth_at_50, t34.is_verified AS is_verified_51, t34.signing_limit_date AS signing_limit_date_52, t34.last_connected_at AS last_connected_at_53, t34.created_from_import AS created_from_import_54, t34.address_street AS address_street_55, t34.address_post_code AS address_post_code_56, t34.address_city AS address_city_57, t34.address_country AS address_country_58, t34.created_at AS created_at_59, t34.updated_at AS updated_at_60, t34.created_by_id AS created_by_id_61, t34.updated_by_id AS updated_by_id_62, t0.updated_by_id AS updated_by_id_63, t64.id AS id_65, t64.email AS email_66, t64.roles AS roles_67, t64.password AS password_68, t64.enabled AS enabled_69, t64.password_token AS password_token_70, t64.password_token_at AS password_token_at_71, t64.first_name AS first_name_72, t64.last_name AS last_name_73, t64.phone_number AS phone_number_74, t64.description AS description_75, t64.role_description AS role_description_76, t64.avatar AS avatar_77, t64.avatar_path AS avatar_path_78, t64.gender AS gender_79, t64.birth_at AS birth_at_80, t64.is_verified AS is_verified_81, t64.signing_limit_date AS signing_limit_date_82, t64.last_connected_at AS last_connected_at_83, t64.created_from_import AS created_from_import_84, t64.address_street AS address_street_85, t64.address_post_code AS address_post_code_86, t64.address_city AS address_city_87, t64.address_country AS address_country_88, t64.created_at AS created_at_89, t64.updated_at AS updated_at_90, t64.created_by_id AS created_by_id_91, t64.updated_by_id AS updated_by_id_92 FROM account_users t0 LEFT JOIN channel_user_from_channels t27 ON t27.user_id = t0.id LEFT JOIN account_users t34 ON t0.created_by_id = t34.id LEFT JOIN account_users t64 ON t0.updated_by_id = t64.id WHERE t0.id = ?
Parameters:
[
  "552640ba-756e-11e9-ab7b-0242ac170002"
]
2 0.15 ms
SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.queue_name AS queue_name_2, a0_.secret AS secret_3, a0_.url AS url_4 FROM app a0_ WHERE a0_.queue_name = ?
Parameters:
[
  "nim"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\App\App No errors.
App\Entity\Common\Address No errors.
App\Entity\Account\User No errors.
App\Entity\Channel\UserFromChannel No errors.
App\Entity\Channel\Channel No errors.
App\Entity\ChannelUserData\ChannelUserData No errors.
App\Entity\Channel\Group No errors.
App\Entity\Channel\Service No errors.
App\Entity\Channel\DataImportLog No errors.
App\Entity\Channel\ChannelUserRole No errors.
App\Entity\Channel\Place No errors.
App\Entity\Channel\Organization No errors.
App\Entity\Channel\ChannelWhiteLabel No errors.
App\Entity\Channel\Google\ChannelGoogleDriveFolder No errors.
App\Entity\ChannelUserData\Cursus\AbstractCursus No errors.
App\Entity\Channel\PositioningTest\Attempt\Attempt No errors.
App\Entity\Channel\CompanyChannelUserData No errors.
App\Entity\ChannelUserData\Cursus\Internship No errors.
App\Entity\Channel\Session No errors.
App\Entity\App\SyncAdditionalData No errors.
App\Entity\Common\LicenseEmbeddable No errors.
App\Entity\Commercial\LicensesOffer No errors.
App\Entity\Account\Notification No errors.
App\Entity\ChannelUserData\Activity\AbstractCursusActivity No errors.
App\Entity\ChannelUserData\Activity\MessageActivity No errors.
App\Entity\ChannelUserData\Activity\TrackDataActivity No errors.
App\Entity\ChannelUserData\Activity\MeetingActivity No errors.
App\Entity\ChannelUserData\Cursus\SessionCursus No errors.
App\Entity\ChannelUserData\Cursus\Tutor No errors.
App\Entity\ChannelUserData\Cursus\Exam No errors.
App\Entity\ChannelUserData\Cursus\PurchaseOrder No errors.
App\Entity\ChannelUserData\Cursus\ReportDetails No errors.
App\Entity\ChannelUserData\Cursus\TrainingCursus No errors.
App\Entity\ChannelUserData\Cursus\Founder No errors.
App\Entity\Common\File No errors.
App\Entity\ChannelUserData\Cursus\FileAbstractCursus No errors.
App\Entity\ChannelUserData\Cursus\Company No errors.
App\Entity\ChannelUserData\Cursus\Adviser No errors.
FOS\OAuthServerBundle\Entity\AccessToken No errors.
App\Entity\OAuth\AccessToken No errors.
FOS\OAuthServerBundle\Entity\RefreshToken No errors.
App\Entity\OAuth\RefreshToken No errors.
FOS\OAuthServerBundle\Entity\Client No errors.
App\Entity\OAuth\Client No errors.
FOS\OAuthServerBundle\Entity\AuthCode No errors.
App\Entity\OAuth\AuthCode No errors.
App\Entity\Channel\ProfessionalId\ProfessionalId No errors.
App\Entity\Channel\ProfessionalId\FrenchProfessionalId No errors.
Nellapp\Bundle\SDKBundle\Permission\Entity\AbstractChannelUserResourcePermission No errors.
App\Entity\Channel\ChannelUserTrainingPermission No errors.
App\Entity\Channel\Room No errors.
App\Entity\Channel\PositioningTest\Question No errors.
App\Entity\Channel\PositioningTest\QuestionAnswer No errors.
App\Entity\Channel\PositioningTest\PositioningTest No errors.
App\Entity\Channel\PositioningTest\PositioningTestBlock No errors.
App\Entity\Channel\PositioningTest\Attempt\Answer No errors.
App\Entity\Channel\PositioningTest\Attempt\AttemptBlock No errors.
App\Entity\Channel\PositioningTest\FileQuestion No errors.
App\Entity\Channel\PositioningTest\Block No errors.
App\Entity\Channel\Certificate\AbstractCertificate No errors.
App\Entity\Channel\Certificate\CursusStartCertificate No errors.
App\Entity\Channel\FileOrganization No errors.
App\Entity\Channel\ChannelUserSessionPermission No errors.
App\Entity\Channel\Training No errors.
App\Entity\Channel\ChannelUserCursusPermission No errors.
App\Entity\Channel\Company No errors.
App\Entity\Channel\Payment\LicensesOrder No errors.
App\Entity\Channel\Material No errors.
App\Entity\Channel\ChannelUserServicePermission No errors.
App\Entity\Channel\CRM\Prospect No errors.
Nellapp\Bundle\SDKBundle\Entity\AbstractCustomView No errors.
App\Entity\CustomizableView\CustomViewChannel No errors.
App\Entity\CustomizableView\CustomViewSuperAdmin No errors.
App\Entity\CustomizableView\CustomViewCommercial No errors.
Nellapp\Bundle\SDKBundle\Google\Entity\GoogleDriveItem\GoogleDriveItem No errors.
Nellapp\Bundle\SDKBundle\Google\Entity\GoogleDrivePermission\GoogleDrivePermission No errors.
Nellapp\Bundle\SDKBundle\Google\Entity\GoogleDriveFolder No errors.
Nellapp\Bundle\SDKBundle\Google\Entity\GoogleDriveFile No errors.
Nellapp\Bundle\SDKBundle\Google\Entity\GoogleExportedData\GoogleExportedData No errors.