Symfony Profiler

SET
  @@session.time_zone = ?

SET @@session.time_zone = 'America/Grand_Turk';

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 = ?

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 = 5073;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.min_bet AS min_bet_3,
  t0.max_bet AS max_bet_4,
  t0.percent AS percent_5,
  t0.total_in AS total_in_6,
  t0.total_out AS total_out_7,
  t0.currency AS currency_8,
  t0.is_deleted AS is_deleted_9,
  t0.address AS address_10,
  t0.responsible AS responsible_11,
  t0.rent_currency AS rent_currency_12,
  t0.allow_in_export AS allow_in_export_13,
  t0.logo_disabled AS logo_disabled_14,
  t0.is_test AS is_test_15,
  t0.allow_pay_borlette AS allow_pay_borlette_16,
  t0.low_percent AS low_percent_17,
  t0.high_percent AS high_percent_18,
  t0.club_percent_priority AS club_percent_priority_19,
  t0.affiliate_id AS affiliate_id_20,
  t0.rent AS rent_21,
  t0.partner_percent AS partner_percent_22,
  t0.withdrawal_limit_min AS withdrawal_limit_min_23,
  t0.withdrawal_limit AS withdrawal_limit_24,
  t0.lat AS lat_25,
  t0.lon AS lon_26,
  t0.rent_date AS rent_date_27,
  t0.chain_id AS chain_id_28,
  t0.region_id AS region_id_29
FROM
  clubs t0
  INNER JOIN users_clubs ON t0.id = users_clubs.club_id
WHERE
  users_clubs.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.min_bet AS min_bet_3, t0.max_bet AS max_bet_4, t0.percent AS percent_5, t0.total_in AS total_in_6, t0.total_out AS total_out_7, t0.currency AS currency_8, t0.is_deleted AS is_deleted_9, t0.address AS address_10, t0.responsible AS responsible_11, t0.rent_currency AS rent_currency_12, t0.allow_in_export AS allow_in_export_13, t0.logo_disabled AS logo_disabled_14, t0.is_test AS is_test_15, t0.allow_pay_borlette AS allow_pay_borlette_16, t0.low_percent AS low_percent_17, t0.high_percent AS high_percent_18, t0.club_percent_priority AS club_percent_priority_19, t0.affiliate_id AS affiliate_id_20, t0.rent AS rent_21, t0.partner_percent AS partner_percent_22, t0.withdrawal_limit_min AS withdrawal_limit_min_23, t0.withdrawal_limit AS withdrawal_limit_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.rent_date AS rent_date_27, t0.chain_id AS chain_id_28, t0.region_id AS region_id_29 FROM clubs t0 INNER JOIN users_clubs ON t0.id = users_clubs.club_id WHERE users_clubs.user_id = 5073;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.min_bet AS min_bet_3,
  t0.max_bet AS max_bet_4,
  t0.percent AS percent_5,
  t0.total_in AS total_in_6,
  t0.total_out AS total_out_7,
  t0.currency AS currency_8,
  t0.is_deleted AS is_deleted_9,
  t0.address AS address_10,
  t0.responsible AS responsible_11,
  t0.rent_currency AS rent_currency_12,
  t0.allow_in_export AS allow_in_export_13,
  t0.logo_disabled AS logo_disabled_14,
  t0.is_test AS is_test_15,
  t0.allow_pay_borlette AS allow_pay_borlette_16,
  t0.low_percent AS low_percent_17,
  t0.high_percent AS high_percent_18,
  t0.club_percent_priority AS club_percent_priority_19,
  t0.affiliate_id AS affiliate_id_20,
  t0.rent AS rent_21,
  t0.partner_percent AS partner_percent_22,
  t0.withdrawal_limit_min AS withdrawal_limit_min_23,
  t0.withdrawal_limit AS withdrawal_limit_24,
  t0.lat AS lat_25,
  t0.lon AS lon_26,
  t0.rent_date AS rent_date_27,
  t0.chain_id AS chain_id_28,
  t0.region_id AS region_id_29
FROM
  clubs t0
WHERE
  t0.is_deleted = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.min_bet AS min_bet_3, t0.max_bet AS max_bet_4, t0.percent AS percent_5, t0.total_in AS total_in_6, t0.total_out AS total_out_7, t0.currency AS currency_8, t0.is_deleted AS is_deleted_9, t0.address AS address_10, t0.responsible AS responsible_11, t0.rent_currency AS rent_currency_12, t0.allow_in_export AS allow_in_export_13, t0.logo_disabled AS logo_disabled_14, t0.is_test AS is_test_15, t0.allow_pay_borlette AS allow_pay_borlette_16, t0.low_percent AS low_percent_17, t0.high_percent AS high_percent_18, t0.club_percent_priority AS club_percent_priority_19, t0.affiliate_id AS affiliate_id_20, t0.rent AS rent_21, t0.partner_percent AS partner_percent_22, t0.withdrawal_limit_min AS withdrawal_limit_min_23, t0.withdrawal_limit AS withdrawal_limit_24, t0.lat AS lat_25, t0.lon AS lon_26, t0.rent_date AS rent_date_27, t0.chain_id AS chain_id_28, t0.region_id AS region_id_29 FROM clubs t0 WHERE t0.is_deleted = 0;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.salt AS salt_4,
  u0_.title AS title_5,
  u0_.is_blocked AS is_blocked_6,
  u0_.is_deleted AS is_deleted_7,
  u0_.description AS description_8,
  u0_.type_id AS type_id_9,
  u0_.balance AS balance_10,
  u0_.remote_client_token AS remote_client_token_11,
  u0_.last_action_time AS last_action_time_12,
  u0_.created_date AS created_date_13,
  u0_.timetable_enabled AS timetable_enabled_14,
  u0_.salary_enabled AS salary_enabled_15,
  u0_.hour_cost_0 AS hour_cost_0_16,
  u0_.hour_cost_1 AS hour_cost_1_17,
  u0_.hour_cost_2 AS hour_cost_2_18,
  u0_.shift_duration AS shift_duration_19,
  u0_.shift_cost AS shift_cost_20,
  u0_.start_working_time AS start_working_time_21,
  u0_.finish_working_time AS finish_working_time_22,
  u0_.bank_title AS bank_title_23,
  u0_.ban AS ban_24,
  u0_.last_login_time AS last_login_time_25,
  u0_.current_club_id AS current_club_id_26,
  u0_.current_cashdesk_id AS current_cashdesk_id_27,
  u0_.locale_id AS locale_id_28
FROM
  users u0_
ORDER BY
  u0_.username ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.salt AS salt_4, u0_.title AS title_5, u0_.is_blocked AS is_blocked_6, u0_.is_deleted AS is_deleted_7, u0_.description AS description_8, u0_.type_id AS type_id_9, u0_.balance AS balance_10, u0_.remote_client_token AS remote_client_token_11, u0_.last_action_time AS last_action_time_12, u0_.created_date AS created_date_13, u0_.timetable_enabled AS timetable_enabled_14, u0_.salary_enabled AS salary_enabled_15, u0_.hour_cost_0 AS hour_cost_0_16, u0_.hour_cost_1 AS hour_cost_1_17, u0_.hour_cost_2 AS hour_cost_2_18, u0_.shift_duration AS shift_duration_19, u0_.shift_cost AS shift_cost_20, u0_.start_working_time AS start_working_time_21, u0_.finish_working_time AS finish_working_time_22, u0_.bank_title AS bank_title_23, u0_.ban AS ban_24, u0_.last_login_time AS last_login_time_25, u0_.current_club_id AS current_club_id_26, u0_.current_cashdesk_id AS current_cashdesk_id_27, u0_.locale_id AS locale_id_28 FROM users u0_ ORDER BY u0_.username ASC;

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.is_deleted = ?

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.is_deleted = 0;

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM settings t0 WHERE t0.id = 'available_user_permissions_for_support';

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM settings t0 WHERE t0.id = 'available_user_permissions_for_administrator';

SELECT
  t0.id AS id_1,
  t0.value AS value_2
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2 FROM settings t0 WHERE t0.id = 'available_user_permissions_for_supervisor';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_blocked AS is_blocked_3,
  t0.alias AS alias_4,
  t0.url AS url_5,
  t0.secret_key AS secret_key_6,
  t0.client_class_name AS client_class_name_7,
  t0.history_url AS history_url_8
FROM
  partners t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_blocked AS is_blocked_3, t0.alias AS alias_4, t0.url AS url_5, t0.secret_key AS secret_key_6, t0.client_class_name AS client_class_name_7, t0.history_url AS history_url_8 FROM partners t0;