Symfony Profiler

SELECT
  dbname
FROM
  saas_instance
WHERE
  hostname = ?
LIMIT
  1

SELECT dbname FROM saas_instance WHERE hostname = 'ma.gymplusoptimal.com' LIMIT 1;

USE `gym_prod_ma`

USE `gym_prod_ma`;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.code_user AS code_user_3,
  t0.zkteco_id AS zkteco_id_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar_name AS avatar_name_7,
  t0.avatar_base64 AS avatar_base64_8,
  t0.avatar_internal_base64 AS avatar_internal_base64_9,
  t0.password AS password_10,
  t0.salt AS salt_11,
  t0.reset_password_token AS reset_password_token_12,
  t0.reset_password_expires_at AS reset_password_expires_at_13,
  t0.email AS email_14,
  t0.is_super_admin AS is_super_admin_15,
  t0.is_active AS is_active_16,
  t0.is_active_mail AS is_active_mail_17,
  t0.is_dangerous AS is_dangerous_18,
  t0.is_not_reserve AS is_not_reserve_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.deactivated_at AS deactivated_at_22,
  t0.phone AS phone_23,
  t0.phone_emergency AS phone_emergency_24,
  t0.contact_emergency AS contact_emergency_25,
  t0.instagram AS instagram_26,
  t0.facebook AS facebook_27,
  t0.sex AS sex_28,
  t0.birthday AS birthday_29,
  t0.nationality AS nationality_30,
  t0.marital_status AS marital_status_31,
  t0.area AS area_32,
  t0.description AS description_33,
  t0.address AS address_34,
  t0.date_admission AS date_admission_35,
  t0.due_date AS due_date_36,
  t0.is_terms_conditions AS is_terms_conditions_37,
  t0.confidentiality AS confidentiality_38,
  t0.software_updates AS software_updates_39,
  t0.number_files AS number_files_40,
  t0.day_trainning AS day_trainning_41,
  t0.toket_access AS toket_access_42,
  t0.toket_access_personal AS toket_access_personal_43,
  t0.observation AS observation_44,
  t0.is_freeze AS is_freeze_45,
  t0.created_for_owner AS created_for_owner_46,
  t0.updated_for_owner AS updated_for_owner_47,
  t0.dni AS dni_48,
  t0.permissions AS permissions_49,
  t0.app_id AS app_id_50,
  t0.token_app AS token_app_51,
  t0.is_external AS is_external_52,
  t0.is_external_register AS is_external_register_53,
  t0.green_pass AS green_pass_54,
  t0.patent AS patent_55,
  t0.work_plan_id AS work_plan_id_56,
  t0.agreements_id AS agreements_id_57,
  t0.branch_office_id AS branch_office_id_58,
  t0.profession_id AS profession_id_59,
  t0.region_id AS region_id_60,
  t0.comuna_id AS comuna_id_61,
  t0.trainer AS trainer_62
FROM
  member t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.code_user AS code_user_3, t0.zkteco_id AS zkteco_id_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar_name AS avatar_name_7, t0.avatar_base64 AS avatar_base64_8, t0.avatar_internal_base64 AS avatar_internal_base64_9, t0.password AS password_10, t0.salt AS salt_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_expires_at AS reset_password_expires_at_13, t0.email AS email_14, t0.is_super_admin AS is_super_admin_15, t0.is_active AS is_active_16, t0.is_active_mail AS is_active_mail_17, t0.is_dangerous AS is_dangerous_18, t0.is_not_reserve AS is_not_reserve_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deactivated_at AS deactivated_at_22, t0.phone AS phone_23, t0.phone_emergency AS phone_emergency_24, t0.contact_emergency AS contact_emergency_25, t0.instagram AS instagram_26, t0.facebook AS facebook_27, t0.sex AS sex_28, t0.birthday AS birthday_29, t0.nationality AS nationality_30, t0.marital_status AS marital_status_31, t0.area AS area_32, t0.description AS description_33, t0.address AS address_34, t0.date_admission AS date_admission_35, t0.due_date AS due_date_36, t0.is_terms_conditions AS is_terms_conditions_37, t0.confidentiality AS confidentiality_38, t0.software_updates AS software_updates_39, t0.number_files AS number_files_40, t0.day_trainning AS day_trainning_41, t0.toket_access AS toket_access_42, t0.toket_access_personal AS toket_access_personal_43, t0.observation AS observation_44, t0.is_freeze AS is_freeze_45, t0.created_for_owner AS created_for_owner_46, t0.updated_for_owner AS updated_for_owner_47, t0.dni AS dni_48, t0.permissions AS permissions_49, t0.app_id AS app_id_50, t0.token_app AS token_app_51, t0.is_external AS is_external_52, t0.is_external_register AS is_external_register_53, t0.green_pass AS green_pass_54, t0.patent AS patent_55, t0.work_plan_id AS work_plan_id_56, t0.agreements_id AS agreements_id_57, t0.branch_office_id AS branch_office_id_58, t0.profession_id AS profession_id_59, t0.region_id AS region_id_60, t0.comuna_id AS comuna_id_61, t0.trainer AS trainer_62 FROM member t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name_full AS name_full_2,
  t0.name AS name_3,
  t0.description AS description_4
FROM
  role t0
  INNER JOIN member_role ON t0.id = member_role.Role_id
WHERE
  member_role.Member_id = ?

SELECT t0.id AS id_1, t0.name_full AS name_full_2, t0.name AS name_3, t0.description AS description_4 FROM role t0 INNER JOIN member_role ON t0.id = member_role.Role_id WHERE member_role.Member_id = 1;

SELECT
  a0_.id AS id_0,
  a0_.reason AS reason_1,
  a0_.message AS message_2,
  a0_.created_at AS created_at_3,
  a0_.client_id AS client_id_4,
  a0_.branch_office_id AS branch_office_id_5
FROM
  access_alert a0_
WHERE
  a0_.branch_office_id = ?
  AND a0_.id > ?
ORDER BY
  a0_.id ASC

SELECT a0_.id AS id_0, a0_.reason AS reason_1, a0_.message AS message_2, a0_.created_at AS created_at_3, a0_.client_id AS client_id_4, a0_.branch_office_id AS branch_office_id_5 FROM access_alert a0_ WHERE a0_.branch_office_id = 1 AND a0_.id > 0 ORDER BY a0_.id ASC;