11.71 ms (70.46%)
|
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.verified AS verified_8, t0.conformidad AS conformidad_9, t10.id AS id_11, t10.email_personal AS email_personal_12, t10.telefono AS telefono_13, t10.movil AS movil_14, t10.direccion AS direccion_15, t10.poblacion AS poblacion_16, t10.codigo_postal AS codigo_postal_17, t10.provincia AS provincia_18, t10.apellidos AS apellidos_19, t10.fecha_antiguedad AS fecha_antiguedad_20, t10.fecha_baja AS fecha_baja_21, t10.fecha_nacimiento AS fecha_nacimiento_22, t10.horas_contrato AS horas_contrato_23, t10.nacionalidad AS nacionalidad_24, t10.nif AS nif_25, t10.nivel_formativo AS nivel_formativo_26, t10.n_hijos AS n_hijos_27, t10.seguridad_social AS seguridad_social_28, t10.sexo AS sexo_29, t10.vehiculo AS vehiculo_30, t10.tipo_contrato AS tipo_contrato_31, t10.carnet AS carnet_32, t10.zona_trabajo AS zona_trabajo_33, t10.dni_delantero AS dni_delantero_34, t10.dni_trasero AS dni_trasero_35, t10.nombre_contacto AS nombre_contacto_36, t10.telefono_contacto AS telefono_contacto_37, t10.complemento_salarial AS complemento_salarial_38, t10.fecha_contratacion_inicial AS fecha_contratacion_inicial_39, t10.porcentaje_jornada AS porcentaje_jornada_40, t10.sustituye_nombre AS sustituye_nombre_41, t10.sustituye_dni AS sustituye_dni_42, t10.conciliacion_horaria AS conciliacion_horaria_43, t10.observaciones AS observaciones_44, t10.movilidad_geografica AS movilidad_geografica_45, t10.user_id AS user_id_46, t10.informacion_bancaria_id AS informacion_bancaria_id_47, t10.estado_empleado_id AS estado_empleado_id_48, t0.modalidad_ausencia_id AS modalidad_ausencia_id_49, t50.id AS id_51, t50.titulacion AS titulacion_52, t50.documento_titulacion AS documento_titulacion_53, t50.especialidad AS especialidad_54, t50.manipulador_alimentos AS manipulador_alimentos_55, t50.certificado_prl AS certificado_prl_56, t50.documento_prl AS documento_prl_57, t50.fecha_prl AS fecha_prl_58, t50.fecha_creacion AS fecha_creacion_59, t50.usuario_id AS usuario_id_60 FROM `user` t0 LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id LEFT JOIN formacion_empleado t50 ON t50.usuario_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters: [
"frandavid2008@gmail.com"
]
SELECT
t0.id AS id_1,
t0.email AS email_2,
t0.roles AS roles_3,
t0.password AS password_4,
t0.nombre AS nombre_5,
t0.imagen AS imagen_6,
t0.activo AS activo_7,
t0.verified AS verified_8,
t0.conformidad AS conformidad_9,
t10.id AS id_11,
t10.email_personal AS email_personal_12,
t10.telefono AS telefono_13,
t10.movil AS movil_14,
t10.direccion AS direccion_15,
t10.poblacion AS poblacion_16,
t10.codigo_postal AS codigo_postal_17,
t10.provincia AS provincia_18,
t10.apellidos AS apellidos_19,
t10.fecha_antiguedad AS fecha_antiguedad_20,
t10.fecha_baja AS fecha_baja_21,
t10.fecha_nacimiento AS fecha_nacimiento_22,
t10.horas_contrato AS horas_contrato_23,
t10.nacionalidad AS nacionalidad_24,
t10.nif AS nif_25,
t10.nivel_formativo AS nivel_formativo_26,
t10.n_hijos AS n_hijos_27,
t10.seguridad_social AS seguridad_social_28,
t10.sexo AS sexo_29,
t10.vehiculo AS vehiculo_30,
t10.tipo_contrato AS tipo_contrato_31,
t10.carnet AS carnet_32,
t10.zona_trabajo AS zona_trabajo_33,
t10.dni_delantero AS dni_delantero_34,
t10.dni_trasero AS dni_trasero_35,
t10.nombre_contacto AS nombre_contacto_36,
t10.telefono_contacto AS telefono_contacto_37,
t10.complemento_salarial AS complemento_salarial_38,
t10.fecha_contratacion_inicial AS fecha_contratacion_inicial_39,
t10.porcentaje_jornada AS porcentaje_jornada_40,
t10.sustituye_nombre AS sustituye_nombre_41,
t10.sustituye_dni AS sustituye_dni_42,
t10.conciliacion_horaria AS conciliacion_horaria_43,
t10.observaciones AS observaciones_44,
t10.movilidad_geografica AS movilidad_geografica_45,
t10.user_id AS user_id_46,
t10.informacion_bancaria_id AS informacion_bancaria_id_47,
t10.estado_empleado_id AS estado_empleado_id_48,
t0.modalidad_ausencia_id AS modalidad_ausencia_id_49,
t50.id AS id_51,
t50.titulacion AS titulacion_52,
t50.documento_titulacion AS documento_titulacion_53,
t50.especialidad AS especialidad_54,
t50.manipulador_alimentos AS manipulador_alimentos_55,
t50.certificado_prl AS certificado_prl_56,
t50.documento_prl AS documento_prl_57,
t50.fecha_prl AS fecha_prl_58,
t50.fecha_creacion AS fecha_creacion_59,
t50.usuario_id AS usuario_id_60
FROM
`user` t0
LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id
LEFT JOIN formacion_empleado t50 ON t50.usuario_id = t0.id
WHERE
t0.email = ?
LIMIT
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nombre AS nombre_5, t0.imagen AS imagen_6, t0.activo AS activo_7, t0.verified AS verified_8, t0.conformidad AS conformidad_9, t10.id AS id_11, t10.email_personal AS email_personal_12, t10.telefono AS telefono_13, t10.movil AS movil_14, t10.direccion AS direccion_15, t10.poblacion AS poblacion_16, t10.codigo_postal AS codigo_postal_17, t10.provincia AS provincia_18, t10.apellidos AS apellidos_19, t10.fecha_antiguedad AS fecha_antiguedad_20, t10.fecha_baja AS fecha_baja_21, t10.fecha_nacimiento AS fecha_nacimiento_22, t10.horas_contrato AS horas_contrato_23, t10.nacionalidad AS nacionalidad_24, t10.nif AS nif_25, t10.nivel_formativo AS nivel_formativo_26, t10.n_hijos AS n_hijos_27, t10.seguridad_social AS seguridad_social_28, t10.sexo AS sexo_29, t10.vehiculo AS vehiculo_30, t10.tipo_contrato AS tipo_contrato_31, t10.carnet AS carnet_32, t10.zona_trabajo AS zona_trabajo_33, t10.dni_delantero AS dni_delantero_34, t10.dni_trasero AS dni_trasero_35, t10.nombre_contacto AS nombre_contacto_36, t10.telefono_contacto AS telefono_contacto_37, t10.complemento_salarial AS complemento_salarial_38, t10.fecha_contratacion_inicial AS fecha_contratacion_inicial_39, t10.porcentaje_jornada AS porcentaje_jornada_40, t10.sustituye_nombre AS sustituye_nombre_41, t10.sustituye_dni AS sustituye_dni_42, t10.conciliacion_horaria AS conciliacion_horaria_43, t10.observaciones AS observaciones_44, t10.movilidad_geografica AS movilidad_geografica_45, t10.user_id AS user_id_46, t10.informacion_bancaria_id AS informacion_bancaria_id_47, t10.estado_empleado_id AS estado_empleado_id_48, t0.modalidad_ausencia_id AS modalidad_ausencia_id_49, t50.id AS id_51, t50.titulacion AS titulacion_52, t50.documento_titulacion AS documento_titulacion_53, t50.especialidad AS especialidad_54, t50.manipulador_alimentos AS manipulador_alimentos_55, t50.certificado_prl AS certificado_prl_56, t50.documento_prl AS documento_prl_57, t50.fecha_prl AS fecha_prl_58, t50.fecha_creacion AS fecha_creacion_59, t50.usuario_id AS usuario_id_60 FROM `user` t0 LEFT JOIN user_datos_contacto t10 ON t10.user_id = t0.id LEFT JOIN formacion_empleado t50 ON t50.usuario_id = t0.id WHERE t0.email = 'frandavid2008@gmail.com' LIMIT 1;
|