Query Metrics
3
Database Queries
3
Different statements
1.20 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.45 ms (37.08%) |
1 |
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
]
|
|
0.43 ms (36.15%) |
1 |
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
]
|
|
0.32 ms (26.77%) |
1 |
SET @@session.time_zone = ?
Parameters:
[
"America/Port-au-Prince"
]
|
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 |
|
| 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 |
|
| App\Entity\RegionClub | No errors. |