| 1 |
1.52 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.password AS password_5, t0.last_login_at AS last_login_at_6, t0.last_login_ip AS last_login_ip_7, t0.confirmation_token AS confirmation_token_8, t0.password_recover_token AS password_recover_token_9, t0.password_recover_resquest_ip AS password_recover_resquest_ip_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.usu_image AS usu_image_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.id_crosschex AS id_crosschex_16, t0.default_timezone AS default_timezone_17, t0.usu_dni AS usu_dni_18, t0.usu_vacaciones_utilizadas AS usu_vacaciones_utilizadas_19, t0.usu_prohibido_fichar AS usu_prohibido_fichar_20, t0.usu_teletrabajo AS usu_teletrabajo_21, t0.usu_whats_app_habilitado AS usu_whats_app_habilitado_22, t0.user_almacenamiento AS user_almacenamiento_23, t0.usu_telefono AS usu_telefono_24, t0.usu_fecha_alta AS usu_fecha_alta_25, t0.usu_fecha_baja AS usu_fecha_baja_26, t0.usu_direccion AS usu_direccion_27, t0.usu_toma_datos_last_send AS usu_toma_datos_last_send_28, t0.usu_toma_datos_token AS usu_toma_datos_token_29, t0.usu_toma_datos_estado AS usu_toma_datos_estado_30, t0.usu_social_number AS usu_social_number_31, t0.usu_fecha_nacimiento AS usu_fecha_nacimiento_32, t0.usu_num_banco AS usu_num_banco_33, t0.usu_provincia AS usu_provincia_34, t0.usu_codigo_postal AS usu_codigo_postal_35, t0.usu_ciudad AS usu_ciudad_36, t0.usu_telefono2 AS usu_telefono2_37, t0.usu_estado_civil AS usu_estado_civil_38, t0.usu_num_hijos AS usu_num_hijos_39, t0.usu_idiomas AS usu_idiomas_40, t0.usu_estudios AS usu_estudios_41, t0.usu_titulos AS usu_titulos_42, t0.usu_genero AS usu_genero_43, t0.usu_estado_historico AS usu_estado_historico_44, t0.usu_observaciones AS usu_observaciones_45, t0.usu_tel_empresa AS usu_tel_empresa_46, t0.usu_email_empresa AS usu_email_empresa_47, t0.usu_id_old AS usu_id_old_48, t0.usu_codigo_fichaje AS usu_codigo_fichaje_49, t0.usu_dias_vacaciones_anuales AS usu_dias_vacaciones_anuales_50, t0.usu_prefijo_tel AS usu_prefijo_tel_51, t0.usu_hora_fin_fichajes AS usu_hora_fin_fichajes_52, t0.usu_tel_tr_lunes AS usu_tel_tr_lunes_53, t0.usu_tel_tr_martes AS usu_tel_tr_martes_54, t0.usu_tel_tr_miercoles AS usu_tel_tr_miercoles_55, t0.usu_tel_tr_jueves AS usu_tel_tr_jueves_56, t0.usu_tel_tr_viernes AS usu_tel_tr_viernes_57, t0.usu_tel_tr_sabado AS usu_tel_tr_sabado_58, t0.usu_tel_tr_domingo AS usu_tel_tr_domingo_59, t0.user_ocultar AS user_ocultar_60, t0.usu_dias_vacaciones_extra AS usu_dias_vacaciones_extra_61, t0.usu_id_odoo AS usu_id_odoo_62, t0.created_at AS created_at_63, t0.updated_at AS updated_at_64, t0.deleted_at AS deleted_at_65, t0.sync_at AS sync_at_66, t0.updated_vich_at AS updated_vich_at_67, t0.empresa_id AS empresa_id_68, t69.id AS id_70, t69.name AS name_71, t69.cif AS cif_72, t69.telefono AS telefono_73, t69.enabled AS enabled_74, t69.limit_usu AS limit_usu_75, t69.emp_whats_app_max_usuarios AS emp_whats_app_max_usuarios_76, t69.emp_whats_app_max_mensajes_dia AS emp_whats_app_max_mensajes_dia_77, t69.emp_firma_x AS emp_firma_x_78, t69.emp_firma_y AS emp_firma_y_79, t69.emp_header AS emp_header_80, t69.emp_footer AS emp_footer_81, t69.emp_logo AS emp_logo_82, t69.emp_logo_original_name AS emp_logo_original_name_83, t69.emp_dias_vacaciones AS emp_dias_vacaciones_84, t69.emp_calendario AS emp_calendario_85, t69.emp_calendario_original_name AS emp_calendario_original_name_86, t69.emp_subdominio AS emp_subdominio_87, t69.emp_espacio_ocupado AS emp_espacio_ocupado_88, t69.emp_nomina_disponible AS emp_nomina_disponible_89, t69.emp_firma AS emp_firma_90, t69.emp_firma_original_name AS emp_firma_original_name_91, t69.emp_firma_file_x AS emp_firma_file_x_92, t69.emp_firma_file_y AS emp_firma_file_y_93, t69.emp_firma_width AS emp_firma_width_94, t69.emp_firma_height AS emp_firma_height_95, t69.emp_identificador AS emp_identificador_96, t69.emp_color_principal AS emp_color_principal_97, t69.emp_horas_anuales AS emp_horas_anuales_98, t69.emp_horas_diarias AS emp_horas_diarias_99, t69.emp_vacaciones_desde AS emp_vacaciones_desde_100, t69.emp_vacaciones_hasta AS emp_vacaciones_hasta_101, t69.emp_folder_path AS emp_folder_path_102, t69.emp_url_prevencion_riesgos AS emp_url_prevencion_riesgos_103, t69.emp_hora_fin_fichajes AS emp_hora_fin_fichajes_104, t69.emp_email AS emp_email_105, t69.emp_direccion AS emp_direccion_106, t69.emp_representate AS emp_representate_107, t69.emp_representante_nif AS emp_representante_nif_108, t69.emp_taller_ocultar_lista AS emp_taller_ocultar_lista_109, t69.created_at AS created_at_110, t69.updated_at AS updated_at_111, t69.deleted_at AS deleted_at_112, t69.sync_at AS sync_at_113, t69.updated_vich_at AS updated_vich_at_114, t69.emp_localidad_id AS emp_localidad_id_115, t69.created_by_id AS created_by_id_116, t69.updated_by_id AS updated_by_id_117, t0.empresa_fichador_id AS empresa_fichador_id_118, t0.usu_centro_default_id AS usu_centro_default_id_119, t0.cafeteria_vista_id AS cafeteria_vista_id_120, t0.created_by_id AS created_by_id_121, t0.updated_by_id AS updated_by_id_122 FROM user t0 LEFT JOIN empresa t69 ON t0.empresa_id = t69.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.username AS username_2,
t0.email AS email_3,
t0.enabled AS enabled_4,
t0.password AS password_5,
t0.last_login_at AS last_login_at_6,
t0.last_login_ip AS last_login_ip_7,
t0.confirmation_token AS confirmation_token_8,
t0.password_recover_token AS password_recover_token_9,
t0.password_recover_resquest_ip AS password_recover_resquest_ip_10,
t0.password_requested_at AS password_requested_at_11,
t0.roles AS roles_12,
t0.usu_image AS usu_image_13,
t0.firstname AS firstname_14,
t0.lastname AS lastname_15,
t0.id_crosschex AS id_crosschex_16,
t0.default_timezone AS default_timezone_17,
t0.usu_dni AS usu_dni_18,
t0.usu_vacaciones_utilizadas AS usu_vacaciones_utilizadas_19,
t0.usu_prohibido_fichar AS usu_prohibido_fichar_20,
t0.usu_teletrabajo AS usu_teletrabajo_21,
t0.usu_whats_app_habilitado AS usu_whats_app_habilitado_22,
t0.user_almacenamiento AS user_almacenamiento_23,
t0.usu_telefono AS usu_telefono_24,
t0.usu_fecha_alta AS usu_fecha_alta_25,
t0.usu_fecha_baja AS usu_fecha_baja_26,
t0.usu_direccion AS usu_direccion_27,
t0.usu_toma_datos_last_send AS usu_toma_datos_last_send_28,
t0.usu_toma_datos_token AS usu_toma_datos_token_29,
t0.usu_toma_datos_estado AS usu_toma_datos_estado_30,
t0.usu_social_number AS usu_social_number_31,
t0.usu_fecha_nacimiento AS usu_fecha_nacimiento_32,
t0.usu_num_banco AS usu_num_banco_33,
t0.usu_provincia AS usu_provincia_34,
t0.usu_codigo_postal AS usu_codigo_postal_35,
t0.usu_ciudad AS usu_ciudad_36,
t0.usu_telefono2 AS usu_telefono2_37,
t0.usu_estado_civil AS usu_estado_civil_38,
t0.usu_num_hijos AS usu_num_hijos_39,
t0.usu_idiomas AS usu_idiomas_40,
t0.usu_estudios AS usu_estudios_41,
t0.usu_titulos AS usu_titulos_42,
t0.usu_genero AS usu_genero_43,
t0.usu_estado_historico AS usu_estado_historico_44,
t0.usu_observaciones AS usu_observaciones_45,
t0.usu_tel_empresa AS usu_tel_empresa_46,
t0.usu_email_empresa AS usu_email_empresa_47,
t0.usu_id_old AS usu_id_old_48,
t0.usu_codigo_fichaje AS usu_codigo_fichaje_49,
t0.usu_dias_vacaciones_anuales AS usu_dias_vacaciones_anuales_50,
t0.usu_prefijo_tel AS usu_prefijo_tel_51,
t0.usu_hora_fin_fichajes AS usu_hora_fin_fichajes_52,
t0.usu_tel_tr_lunes AS usu_tel_tr_lunes_53,
t0.usu_tel_tr_martes AS usu_tel_tr_martes_54,
t0.usu_tel_tr_miercoles AS usu_tel_tr_miercoles_55,
t0.usu_tel_tr_jueves AS usu_tel_tr_jueves_56,
t0.usu_tel_tr_viernes AS usu_tel_tr_viernes_57,
t0.usu_tel_tr_sabado AS usu_tel_tr_sabado_58,
t0.usu_tel_tr_domingo AS usu_tel_tr_domingo_59,
t0.user_ocultar AS user_ocultar_60,
t0.usu_dias_vacaciones_extra AS usu_dias_vacaciones_extra_61,
t0.usu_id_odoo AS usu_id_odoo_62,
t0.created_at AS created_at_63,
t0.updated_at AS updated_at_64,
t0.deleted_at AS deleted_at_65,
t0.sync_at AS sync_at_66,
t0.updated_vich_at AS updated_vich_at_67,
t0.empresa_id AS empresa_id_68,
t69.id AS id_70,
t69.name AS name_71,
t69.cif AS cif_72,
t69.telefono AS telefono_73,
t69.enabled AS enabled_74,
t69.limit_usu AS limit_usu_75,
t69.emp_whats_app_max_usuarios AS emp_whats_app_max_usuarios_76,
t69.emp_whats_app_max_mensajes_dia AS emp_whats_app_max_mensajes_dia_77,
t69.emp_firma_x AS emp_firma_x_78,
t69.emp_firma_y AS emp_firma_y_79,
t69.emp_header AS emp_header_80,
t69.emp_footer AS emp_footer_81,
t69.emp_logo AS emp_logo_82,
t69.emp_logo_original_name AS emp_logo_original_name_83,
t69.emp_dias_vacaciones AS emp_dias_vacaciones_84,
t69.emp_calendario AS emp_calendario_85,
t69.emp_calendario_original_name AS emp_calendario_original_name_86,
t69.emp_subdominio AS emp_subdominio_87,
t69.emp_espacio_ocupado AS emp_espacio_ocupado_88,
t69.emp_nomina_disponible AS emp_nomina_disponible_89,
t69.emp_firma AS emp_firma_90,
t69.emp_firma_original_name AS emp_firma_original_name_91,
t69.emp_firma_file_x AS emp_firma_file_x_92,
t69.emp_firma_file_y AS emp_firma_file_y_93,
t69.emp_firma_width AS emp_firma_width_94,
t69.emp_firma_height AS emp_firma_height_95,
t69.emp_identificador AS emp_identificador_96,
t69.emp_color_principal AS emp_color_principal_97,
t69.emp_horas_anuales AS emp_horas_anuales_98,
t69.emp_horas_diarias AS emp_horas_diarias_99,
t69.emp_vacaciones_desde AS emp_vacaciones_desde_100,
t69.emp_vacaciones_hasta AS emp_vacaciones_hasta_101,
t69.emp_folder_path AS emp_folder_path_102,
t69.emp_url_prevencion_riesgos AS emp_url_prevencion_riesgos_103,
t69.emp_hora_fin_fichajes AS emp_hora_fin_fichajes_104,
t69.emp_email AS emp_email_105,
t69.emp_direccion AS emp_direccion_106,
t69.emp_representate AS emp_representate_107,
t69.emp_representante_nif AS emp_representante_nif_108,
t69.emp_taller_ocultar_lista AS emp_taller_ocultar_lista_109,
t69.created_at AS created_at_110,
t69.updated_at AS updated_at_111,
t69.deleted_at AS deleted_at_112,
t69.sync_at AS sync_at_113,
t69.updated_vich_at AS updated_vich_at_114,
t69.emp_localidad_id AS emp_localidad_id_115,
t69.created_by_id AS created_by_id_116,
t69.updated_by_id AS updated_by_id_117,
t0.empresa_fichador_id AS empresa_fichador_id_118,
t0.usu_centro_default_id AS usu_centro_default_id_119,
t0.cafeteria_vista_id AS cafeteria_vista_id_120,
t0.created_by_id AS created_by_id_121,
t0.updated_by_id AS updated_by_id_122
FROM
user t0
LEFT JOIN empresa t69 ON t0.empresa_id = t69.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.enabled AS enabled_4, t0.password AS password_5, t0.last_login_at AS last_login_at_6, t0.last_login_ip AS last_login_ip_7, t0.confirmation_token AS confirmation_token_8, t0.password_recover_token AS password_recover_token_9, t0.password_recover_resquest_ip AS password_recover_resquest_ip_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.usu_image AS usu_image_13, t0.firstname AS firstname_14, t0.lastname AS lastname_15, t0.id_crosschex AS id_crosschex_16, t0.default_timezone AS default_timezone_17, t0.usu_dni AS usu_dni_18, t0.usu_vacaciones_utilizadas AS usu_vacaciones_utilizadas_19, t0.usu_prohibido_fichar AS usu_prohibido_fichar_20, t0.usu_teletrabajo AS usu_teletrabajo_21, t0.usu_whats_app_habilitado AS usu_whats_app_habilitado_22, t0.user_almacenamiento AS user_almacenamiento_23, t0.usu_telefono AS usu_telefono_24, t0.usu_fecha_alta AS usu_fecha_alta_25, t0.usu_fecha_baja AS usu_fecha_baja_26, t0.usu_direccion AS usu_direccion_27, t0.usu_toma_datos_last_send AS usu_toma_datos_last_send_28, t0.usu_toma_datos_token AS usu_toma_datos_token_29, t0.usu_toma_datos_estado AS usu_toma_datos_estado_30, t0.usu_social_number AS usu_social_number_31, t0.usu_fecha_nacimiento AS usu_fecha_nacimiento_32, t0.usu_num_banco AS usu_num_banco_33, t0.usu_provincia AS usu_provincia_34, t0.usu_codigo_postal AS usu_codigo_postal_35, t0.usu_ciudad AS usu_ciudad_36, t0.usu_telefono2 AS usu_telefono2_37, t0.usu_estado_civil AS usu_estado_civil_38, t0.usu_num_hijos AS usu_num_hijos_39, t0.usu_idiomas AS usu_idiomas_40, t0.usu_estudios AS usu_estudios_41, t0.usu_titulos AS usu_titulos_42, t0.usu_genero AS usu_genero_43, t0.usu_estado_historico AS usu_estado_historico_44, t0.usu_observaciones AS usu_observaciones_45, t0.usu_tel_empresa AS usu_tel_empresa_46, t0.usu_email_empresa AS usu_email_empresa_47, t0.usu_id_old AS usu_id_old_48, t0.usu_codigo_fichaje AS usu_codigo_fichaje_49, t0.usu_dias_vacaciones_anuales AS usu_dias_vacaciones_anuales_50, t0.usu_prefijo_tel AS usu_prefijo_tel_51, t0.usu_hora_fin_fichajes AS usu_hora_fin_fichajes_52, t0.usu_tel_tr_lunes AS usu_tel_tr_lunes_53, t0.usu_tel_tr_martes AS usu_tel_tr_martes_54, t0.usu_tel_tr_miercoles AS usu_tel_tr_miercoles_55, t0.usu_tel_tr_jueves AS usu_tel_tr_jueves_56, t0.usu_tel_tr_viernes AS usu_tel_tr_viernes_57, t0.usu_tel_tr_sabado AS usu_tel_tr_sabado_58, t0.usu_tel_tr_domingo AS usu_tel_tr_domingo_59, t0.user_ocultar AS user_ocultar_60, t0.usu_dias_vacaciones_extra AS usu_dias_vacaciones_extra_61, t0.usu_id_odoo AS usu_id_odoo_62, t0.created_at AS created_at_63, t0.updated_at AS updated_at_64, t0.deleted_at AS deleted_at_65, t0.sync_at AS sync_at_66, t0.updated_vich_at AS updated_vich_at_67, t0.empresa_id AS empresa_id_68, t69.id AS id_70, t69.name AS name_71, t69.cif AS cif_72, t69.telefono AS telefono_73, t69.enabled AS enabled_74, t69.limit_usu AS limit_usu_75, t69.emp_whats_app_max_usuarios AS emp_whats_app_max_usuarios_76, t69.emp_whats_app_max_mensajes_dia AS emp_whats_app_max_mensajes_dia_77, t69.emp_firma_x AS emp_firma_x_78, t69.emp_firma_y AS emp_firma_y_79, t69.emp_header AS emp_header_80, t69.emp_footer AS emp_footer_81, t69.emp_logo AS emp_logo_82, t69.emp_logo_original_name AS emp_logo_original_name_83, t69.emp_dias_vacaciones AS emp_dias_vacaciones_84, t69.emp_calendario AS emp_calendario_85, t69.emp_calendario_original_name AS emp_calendario_original_name_86, t69.emp_subdominio AS emp_subdominio_87, t69.emp_espacio_ocupado AS emp_espacio_ocupado_88, t69.emp_nomina_disponible AS emp_nomina_disponible_89, t69.emp_firma AS emp_firma_90, t69.emp_firma_original_name AS emp_firma_original_name_91, t69.emp_firma_file_x AS emp_firma_file_x_92, t69.emp_firma_file_y AS emp_firma_file_y_93, t69.emp_firma_width AS emp_firma_width_94, t69.emp_firma_height AS emp_firma_height_95, t69.emp_identificador AS emp_identificador_96, t69.emp_color_principal AS emp_color_principal_97, t69.emp_horas_anuales AS emp_horas_anuales_98, t69.emp_horas_diarias AS emp_horas_diarias_99, t69.emp_vacaciones_desde AS emp_vacaciones_desde_100, t69.emp_vacaciones_hasta AS emp_vacaciones_hasta_101, t69.emp_folder_path AS emp_folder_path_102, t69.emp_url_prevencion_riesgos AS emp_url_prevencion_riesgos_103, t69.emp_hora_fin_fichajes AS emp_hora_fin_fichajes_104, t69.emp_email AS emp_email_105, t69.emp_direccion AS emp_direccion_106, t69.emp_representate AS emp_representate_107, t69.emp_representante_nif AS emp_representante_nif_108, t69.emp_taller_ocultar_lista AS emp_taller_ocultar_lista_109, t69.created_at AS created_at_110, t69.updated_at AS updated_at_111, t69.deleted_at AS deleted_at_112, t69.sync_at AS sync_at_113, t69.updated_vich_at AS updated_vich_at_114, t69.emp_localidad_id AS emp_localidad_id_115, t69.created_by_id AS created_by_id_116, t69.updated_by_id AS updated_by_id_117, t0.empresa_fichador_id AS empresa_fichador_id_118, t0.usu_centro_default_id AS usu_centro_default_id_119, t0.cafeteria_vista_id AS cafeteria_vista_id_120, t0.created_by_id AS created_by_id_121, t0.updated_by_id AS updated_by_id_122 FROM user t0 LEFT JOIN empresa t69 ON t0.empresa_id = t69.id WHERE t0.id = 1;
|