https://staging.delsap.be/ecommerce/profile/team/roles Return to referer URL

Query Metrics

9 Database Queries
6 Different statements
9.99 ms Query time
9 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.58 ms
(55.87%)
2
SELECT t0.id AS id_1, t0.deleted AS deleted_2, t0.role_id AS role_id_3, t0.authorized_action_id AS authorized_action_id_4 FROM roles_authorized_actions t0 WHERE t0.role_id = ?
Parameters:
[
  9871
]
1.61 ms
(16.12%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3 FROM authorized_actions t0 WHERE t0.deleted = ?
Parameters:
[
  0
]
0.90 ms
(9.05%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.dev_name AS dev_name_3, t0.id_perso AS id_perso_4, t0.visible_in_app AS visible_in_app_5 FROM user_status t0 WHERE t0.id = ?
Parameters:
[
  3
]
0.89 ms
(8.94%)
1
SELECT t0.id AS id_1, t0.id_punch AS id_punch_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.email AS email_5, t0.created_at AS created_at_6, t0.deleted AS deleted_7, t0.token AS token_8, t0.password AS password_9, t0.validated AS validated_10, t0.not_present AS not_present_11, t0.city AS city_12, t0.zip AS zip_13, t0.number_phone AS number_phone_14, t0.points AS points_15, t0.client_card AS client_card_16, t0.cgv_accepted AS cgv_accepted_17, t0.genre AS genre_18, t0.address AS address_19, t0.tva_number AS tva_number_20, t0.new_password_code AS new_password_code_21, t0.new_password_created_at AS new_password_created_at_22, t0.email_validated AS email_validated_23, t0.email_validation_token AS email_validation_token_24, t0.new_password_token AS new_password_token_25, t0.first_connexion AS first_connexion_26, t0.deleted_at AS deleted_at_27, t0.zendesk_id AS zendesk_id_28, t0.my_responsable_id AS my_responsable_id_29, t0.status_intern_id AS status_intern_id_30, t0.tva_id AS tva_id_31, t0.deleted_by_id AS deleted_by_id_32, t0.connected_at_id AS connected_at_id_33 FROM users t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.53 ms
(5.29%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.deleted AS deleted_3, t0.status_id AS status_id_4, t0.user_id AS user_id_5, t0.establishment_id AS establishment_id_6, t0.role_id AS role_id_7 FROM user_establishment t0 WHERE t0.user_id = ?
Parameters:
[
  1
]
0.47 ms
(4.72%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted AS deleted_3, t0.not_removable AS not_removable_4, t0.establishment_id AS establishment_id_5 FROM roles t0 WHERE t0.establishment_id = ? AND t0.deleted = ?
Parameters:
[
  63559
  0
]

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\Users
  • The mappings App\Entity\Users#requestModificationsResponsable and App\Entity\RequestModification#responsable are inconsistent with each other.
  • The association App\Entity\Users#favorites refers to the owning side field App\Entity\Favorite#User which does not exist.
  • The association App\Entity\Users#invoices refers to the owning side field App\Entity\Invoice#user which does not exist.
  • The association App\Entity\Users#backOrders refers to the owning side field App\Entity\BackOrder#createdBy which does not exist.
  • The mappings App\Entity\Users#articlesChangeVisibility and App\Entity\Articles#visibleBy are inconsistent with each other.
App\Entity\UserStatusIntern No errors.
App\Entity\TVA No errors.
App\Entity\Establishments
  • The association App\Entity\Establishments#favorites refers to the owning side field App\Entity\Favorite#Establishment which does not exist.
App\Entity\NumberOfCardCustomer No errors.
App\Entity\TypeEstablishment No errors.
App\Entity\ReferenceUserEstablishment No errors.
App\Entity\UserEstablishment No errors.
App\Entity\ShoppingCart No errors.
App\Entity\Orders
  • The association App\Entity\Orders#articleOrderOutOfStocks refers to the owning side field App\Entity\ArticleOrderOutOfStock#orders which does not exist.
App\Entity\OrderArticle No errors.
App\Entity\RequestModification
  • The association App\Entity\RequestModification#responsable refers to the inverse side field App\Entity\Users#requestModificationsUser which does not exist.
App\Entity\Favorite
  • The mappings App\Entity\Favorite#article and App\Entity\Articles#favorites are inconsistent with each other.
  • The mappings App\Entity\Favorite#establishment and App\Entity\Establishments#favorites are inconsistent with each other.
  • The mappings App\Entity\Favorite#user and App\Entity\Users#favorites are inconsistent with each other.
App\Entity\Banner No errors.
App\Entity\Invoice No errors.
App\Entity\EmailInvoice No errors.
App\Entity\ArticleOrderOutOfStock
  • The mappings App\Entity\ArticleOrderOutOfStock#order and App\Entity\Orders#articleOrderOutOfStocks are inconsistent with each other.
App\Entity\BackOrder
  • The mappings App\Entity\BackOrder#user and App\Entity\Users#backOrders are inconsistent with each other.
App\Entity\InvoiceDownloads No errors.
App\Entity\Articles
  • The association App\Entity\Articles#favorites refers to the owning side field App\Entity\Favorite#Article which does not exist.
  • The association App\Entity\Articles#promotions refers to the owning side field App\Entity\Promotions#article which does not exist.
  • The association App\Entity\Articles#visibleBy refers to the inverse side field App\Entity\Users#articles which does not exist.
App\Entity\ChildTags No errors.
App\Entity\TagGroups No errors.
App\Entity\Feedback No errors.
App\Entity\UserStatus No errors.
App\Entity\Roles
  • The association App\Entity\Roles#users refers to the owning side field App\Entity\Users#role which does not exist.
App\Entity\RolesAuthorizedActions No errors.
App\Entity\AuthorizedActions No errors.