https://back.eidetic.eu/api/authentication_token

Query Metrics

1 Database Queries
1 Different statements
4.67 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.67 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.