Query Metrics
1
Database Queries
1
Different statements
3.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.58 ms (100.00%) |
1 |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.gsm AS gsm_5, u0_.phone AS phone_6, u0_.activation_code AS activation_code_7, u0_.echopark_name AS echopark_name_8, u0_.echopark_main_community_id AS echopark_main_community_id_9, u0_.locale AS locale_10, u0_.validated AS validated_11, u0_.external_id AS external_id_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u0_.deleted_at AS deleted_at_15, u0_.created_by AS created_by_16, u0_.updated_by AS updated_by_17, u0_.deleted_by AS deleted_by_18, u0_.enabled AS enabled_19, u0_.deleted AS deleted_20, a1_.id AS id_21, a1_.created_at AS created_at_22, a1_.updated_at AS updated_at_23, a1_.deleted_at AS deleted_at_24, a1_.created_by AS created_by_25, a1_.updated_by AS updated_by_26, a1_.deleted_by AS deleted_by_27, a1_.enabled AS enabled_28, a1_.deleted AS deleted_29, a2_.id AS id_30, a2_.name AS name_31, a2_.code AS code_32, a2_.created_at AS created_at_33, a2_.updated_at AS updated_at_34, a2_.deleted_at AS deleted_at_35, a2_.created_by AS created_by_36, a2_.updated_by AS updated_by_37, a2_.deleted_by AS deleted_by_38, a2_.enabled AS enabled_39, a2_.deleted AS deleted_40, u3_.id AS id_41, u3_.created_at AS created_at_42, u3_.updated_at AS updated_at_43, u3_.deleted_at AS deleted_at_44, u3_.created_by AS created_by_45, u3_.updated_by AS updated_by_46, u3_.deleted_by AS deleted_by_47, u3_.enabled AS enabled_48, u3_.deleted AS deleted_49, g4_.id AS id_50, g4_.name AS name_51, g4_.code AS code_52, g4_.created_at AS created_at_53, g4_.updated_at AS updated_at_54, g4_.deleted_at AS deleted_at_55, g4_.created_by AS created_by_56, g4_.updated_by AS updated_by_57, g4_.deleted_by AS deleted_by_58, g4_.enabled AS enabled_59, g4_.deleted AS deleted_60, a5_.id AS id_61, a5_.created_at AS created_at_62, a5_.updated_at AS updated_at_63, a5_.deleted_at AS deleted_at_64, a5_.created_by AS created_by_65, a5_.updated_by AS updated_by_66, a5_.deleted_by AS deleted_by_67, a5_.enabled AS enabled_68, a5_.deleted AS deleted_69, a6_.id AS id_70, a6_.name AS name_71, a6_.code AS code_72, a6_.created_at AS created_at_73, a6_.updated_at AS updated_at_74, a6_.deleted_at AS deleted_at_75, a6_.created_by AS created_by_76, a6_.updated_by AS updated_by_77, a6_.deleted_by AS deleted_by_78, a6_.enabled AS enabled_79, a6_.deleted AS deleted_80, u0_.company_id AS company_id_81, u0_.instance_id AS instance_id_82, a1_.authorization_id AS authorization_id_83, a1_.user_id AS user_id_84, u3_.user_id AS user_id_85, u3_.group_id AS group_id_86, g4_.company_id AS company_id_87, a5_.authorization_id AS authorization_id_88, a5_.group_id AS group_id_89 FROM users u0_ LEFT JOIN authorizations__users a1_ ON u0_.id = a1_.user_id LEFT JOIN authorizations a2_ ON a1_.authorization_id = a2_.id LEFT JOIN users__groups u3_ ON u0_.id = u3_.user_id LEFT JOIN groups g4_ ON u3_.group_id = g4_.id LEFT JOIN authorizations__groups a5_ ON g4_.id = a5_.group_id LEFT JOIN authorizations a6_ ON a5_.authorization_id = a6_.id WHERE (u0_.enabled = 1 AND u0_.deleted = 0) AND u0_.email = ?
Parameters:
[
"root@eidetic.eu"
]
|
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\Geolocation\Cache | No errors. |
| App\Entity\User | No errors. |
| App\Entity\AuthorizationUser | No errors. |
| App\Entity\Authorization | No errors. |
| App\Entity\UserGroup | No errors. |
| App\Entity\Group | No errors. |
| App\Entity\AuthorizationGroup | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\Instance | No errors. |
| App\Entity\InterventionRequest | No errors. |
| App\Entity\InterventionRequest\ReadingStatus | No errors. |
| App\Entity\InterventionRequest\Access | No errors. |
| App\Entity\Contract | No errors. |
| App\Entity\InterventionRequest\Message | No errors. |
| App\Entity\Savills\WorkValidationRequest | No errors. |
| App\Entity\Savills\WorkValidationRequest\ReadingStatusSavills | No errors. |
| App\Entity\Savills\WorkValidationRequest\Access | No errors. |
| App\Entity\Savills\WorkValidationRequest\MessageSavills | No errors. |