https://flashconsulting.slapp.me/manager/clients/add?particulier=1

Query Metrics

11 Database Queries
4 Different statements
13.81 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.id = ?
Parameters:
[
  11
]
2 5.19 ms
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.admin AS admin_4, t0.allow_particuliers AS allow_particuliers_5, t0.allow_offres_sur_grilles AS allow_offres_sur_grilles_6, t0.allow_cotations AS allow_cotations_7, t0.allow_customer_base AS allow_customer_base_8, t0.email AS email_9, t0.phone AS phone_10, t0.referent_pricing AS referent_pricing_11, t12.id AS id_13, t12.email AS email_14, t12.password AS password_15, t12.salt AS salt_16, t12.registration_date AS registration_date_17, t12.password_request_date AS password_request_date_18, t12.password_request AS password_request_19, t12.email_valid AS email_valid_20, t12.email_valid_token AS email_valid_token_21, t12.last_login AS last_login_22, t12.enabled AS enabled_23, t12.roles AS roles_24, t12.manager_id AS manager_id_25, t12.user_id AS user_id_26 FROM manager t0 LEFT JOIN account t12 ON t12.manager_id = t0.id WHERE t0.id = ?
Parameters:
[
  8
]
3 0.92 ms
SELECT m0_.id AS id_0, m0_.first_name AS first_name_1, m0_.last_name AS last_name_2, m0_.admin AS admin_3, m0_.allow_particuliers AS allow_particuliers_4, m0_.allow_offres_sur_grilles AS allow_offres_sur_grilles_5, m0_.allow_cotations AS allow_cotations_6, m0_.allow_customer_base AS allow_customer_base_7, m0_.email AS email_8, m0_.phone AS phone_9, m0_.referent_pricing AS referent_pricing_10 FROM manager m0_ LEFT JOIN account a1_ ON m0_.id = a1_.manager_id WHERE a1_.enabled = 1
Parameters:
[]
4 0.55 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  1
]
5 0.48 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  2
]
6 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  4
]
7 0.47 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  5
]
8 0.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  6
]
9 3.62 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  9
]
10 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  10
]
11 0.46 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.email_valid AS email_valid_8, t0.email_valid_token AS email_valid_token_9, t0.last_login AS last_login_10, t0.enabled AS enabled_11, t0.roles AS roles_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14 FROM account t0 WHERE t0.manager_id = ?
Parameters:
[
  11
]

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\Account No errors.
App\Entity\Manager No errors.
App\Entity\User
  • The mappings App\Entity\User#device and App\Entity\Device#user are inconsistent with each other.
  • The field App\Entity\User#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contract#user does not contain the required 'inversedBy="contracts"' attribute.