https://egor.cash.bet25.me/api/v2/user/byToken

Query Metrics

3 Database Queries
3 Different statements
1.14 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.29 ms
SET @@session.time_zone = ?
Parameters:
[
  "America/Port-au-Prince"
]
2 0.43 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.salt AS salt_5, t0.title AS title_6, t0.is_blocked AS is_blocked_7, t0.is_deleted AS is_deleted_8, t0.description AS description_9, t0.type_id AS type_id_10, t0.balance AS balance_11, t0.remote_client_token AS remote_client_token_12, t0.last_action_time AS last_action_time_13, t0.created_date AS created_date_14, t0.timetable_enabled AS timetable_enabled_15, t0.salary_enabled AS salary_enabled_16, t0.hour_cost_0 AS hour_cost_0_17, t0.hour_cost_1 AS hour_cost_1_18, t0.hour_cost_2 AS hour_cost_2_19, t0.shift_duration AS shift_duration_20, t0.shift_cost AS shift_cost_21, t0.start_working_time AS start_working_time_22, t0.finish_working_time AS finish_working_time_23, t0.bank_title AS bank_title_24, t0.ban AS ban_25, t0.last_login_time AS last_login_time_26, t0.current_club_id AS current_club_id_27, t0.current_cashdesk_id AS current_cashdesk_id_28, t0.locale_id AS locale_id_29 FROM users t0 WHERE t0.id = ?
Parameters:
[
  123
]
3 0.42 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.club_id AS club_id_3, t0.balance AS balance_4, t0.limit_max AS limit_max_5, t0.wcb_borlette_1 AS wcb_borlette_1_6, t0.wcb_borlette_2 AS wcb_borlette_2_7, t0.wcb_borlette_3 AS wcb_borlette_3_8, t0.wcb_3 AS wcb_3_9, t0.wcb_maryaj AS wcb_maryaj_10, t0.wcb_4_opt1 AS wcb_4_opt1_11, t0.wcb_4_opt2 AS wcb_4_opt2_12, t0.wcb_4_opt3 AS wcb_4_opt3_13, t0.wcb_5_opt1 AS wcb_5_opt1_14, t0.wcb_5_opt2 AS wcb_5_opt2_15, t0.wcb_5_opt3 AS wcb_5_opt3_16, t0.is_deleted AS is_deleted_17, t0.allow_negative_balance AS allow_negative_balance_18, t0.limit_negative_balance AS limit_negative_balance_19, t0.allow_free_maryaj AS allow_free_maryaj_20, t0.is_blocked AS is_blocked_21, t0.print_koef AS print_koef_22, t0.has_jp AS has_jp_23, t0.roles AS roles_24, t0.remote_client_token AS remote_client_token_25, t0.created_date AS created_date_26, t0.club_id AS club_id_27, t28.id AS id_29, t28.username AS username_30, t28.roles AS roles_31, t28.password AS password_32, t28.salt AS salt_33, t28.title AS title_34, t28.is_blocked AS is_blocked_35, t28.is_deleted AS is_deleted_36, t28.description AS description_37, t28.type_id AS type_id_38, t28.balance AS balance_39, t28.remote_client_token AS remote_client_token_40, t28.last_action_time AS last_action_time_41, t28.created_date AS created_date_42, t28.timetable_enabled AS timetable_enabled_43, t28.salary_enabled AS salary_enabled_44, t28.hour_cost_0 AS hour_cost_0_45, t28.hour_cost_1 AS hour_cost_1_46, t28.hour_cost_2 AS hour_cost_2_47, t28.shift_duration AS shift_duration_48, t28.shift_cost AS shift_cost_49, t28.start_working_time AS start_working_time_50, t28.finish_working_time AS finish_working_time_51, t28.bank_title AS bank_title_52, t28.ban AS ban_53, t28.last_login_time AS last_login_time_54, t28.current_club_id AS current_club_id_55, t28.current_cashdesk_id AS current_cashdesk_id_56, t28.locale_id AS locale_id_57, t0.current_workshift_id AS current_workshift_id_58 FROM cashdesks t0 LEFT JOIN users t28 ON t28.current_cashdesk_id = t0.id WHERE t0.id = ?
Parameters:
[
  318
]

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\Session No errors.
App\Entity\User No errors.
App\Entity\Club No errors.
App\Entity\Cashdesk
  • The field App\Entity\Cashdesk#current_workshift is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Workshift#cashdesk does not contain the required 'mappedBy="current_workshift"' attribute.
  • If association App\Entity\Cashdesk#current_workshift is one-to-one, then the inversed side App\Entity\Workshift#cashdesk has to be one-to-one as well.
App\Entity\Setting No errors.
App\Entity\AuditLog No errors.
App\Entity\Locale No errors.
App\Entity\Payment No errors.
App\Entity\Timetable No errors.
App\Entity\Workshift
  • The association App\Entity\Workshift#user refers to the inverse side field App\Entity\User#workshifts which does not exist.
  • The association App\Entity\Workshift#cashdesk refers to the inverse side field App\Entity\Cashdesk#workshifts which does not exist.
App\Entity\RegionClub No errors.