Query Metrics
11
Database Queries
4
Different statements
13.81 ms
Query time
1
Invalid entities
Queries
| #▲ | 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 |
|