Symfony Profiler

SELECT
  t0.id AS id_4,
  t0.nombre AS nombre_5,
  t0.apellidos AS apellidos_6,
  t0.usuario AS usuario_7,
  t0.password AS password_8,
  t0.password_updated_at AS password_updated_at_9,
  t0.password_reset_token AS password_reset_token_10,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_11,
  t0.role AS role_12,
  t0.email AS email_13,
  t0.salt AS salt_14,
  t0.fecharegistro AS fecharegistro_15,
  t0.active AS active_16,
  t0.rolematriculaciones AS rolematriculaciones_17,
  t0.rolecontabilidad AS rolecontabilidad_18,
  t0.rolecobro AS rolecobro_19,
  t0.dni AS dni_20,
  t0.idioma AS idioma_21,
  t0.tipo,
  t1.superadmin AS superadmin_22,
  t1.gestorahelendoron AS gestorahelendoron_23,
  t1.verFacturacion AS verFacturacion_24,
  t1.empresa_id AS empresa_id_25,
  t2.empresa_id AS empresa_id_26,
  t3.titulacion AS titulacion_27,
  t3.direccion AS direccion_28,
  t3.codigopostal AS codigopostal_29,
  t3.localidad AS localidad_30,
  t3.provincia AS provincia_31,
  t3.categoria AS categoria_32,
  t3.movil AS movil_33,
  t3.telefono AS telefono_34,
  t3.telefono2 AS telefono2_35,
  t3.nss AS nss_36,
  t3.pasaporte AS pasaporte_37,
  t3.emailurgente AS emailurgente_38,
  t3.androidorios AS androidorios_39,
  t3.tokenDispositivo AS tokenDispositivo_40,
  t3.desarrollo AS desarrollo_41,
  t3.enviarobservaciones AS enviarobservaciones_42,
  t3.notasporexcel AS notasporexcel_43,
  t3.enviarencuestas AS enviarencuestas_44,
  t3.datosColegio AS datosColegio_45,
  t3.datosAcademicos AS datosAcademicos_46,
  t3.notificafaltas AS notificafaltas_47,
  t3.path AS path_48,
  t3.deviceid AS deviceid_49,
  t3.fcmtoken AS fcmtoken_50,
  t3.updatedFCMToken AS updatedFCMToken_51,
  t3.fechanacimiento AS fechanacimiento_52,
  t3.puedeactivarelearning AS puedeactivarelearning_53,
  t3.enviacopiaemail AS enviacopiaemail_54,
  t3.accesoinformacionalumnos AS accesoinformacionalumnos_55,
  t3.mostraremailtutorias AS mostraremailtutorias_56,
  t3.notificaciontareas AS notificaciontareas_57,
  t3.ajustarhoras AS ajustarhoras_58,
  t3.horasautomaticas AS horasautomaticas_59,
  t3.horasMensuales AS horasMensuales_60,
  t3.enviaNotificaciones AS enviaNotificaciones_61,
  t3.jefeDepartamento AS jefeDepartamento_62,
  t3.subirprogresoenclase AS subirprogresoenclase_63,
  t3.subirsimulaciones AS subirsimulaciones_64,
  t3.subirasistencia AS subirasistencia_65,
  t3.subirdocumentos AS subirdocumentos_66,
  t3.subirtareas AS subirtareas_67,
  t3.subirnotas AS subirnotas_68,
  t3.subircomentarioscurso AS subircomentarioscurso_69,
  t3.accesoaplicacion AS accesoaplicacion_70,
  t3.fechaUltimaConsultaNotificaciones AS fechaUltimaConsultaNotificaciones_71,
  t3.numero_seguridad_social AS numero_seguridad_social_72,
  t3.cuenta_bancaria AS cuenta_bancaria_73,
  t3.fecha_alta_seguridad_social AS fecha_alta_seguridad_social_74,
  t3.categoria_laboral AS categoria_laboral_75,
  t3.fijo_discontinuo AS fijo_discontinuo_76,
  t3.horas_semanales_contrato AS horas_semanales_contrato_77,
  t3.salario_base_anual AS salario_base_anual_78,
  t3.fecha_ultima_renovacion AS fecha_ultima_renovacion_79,
  t3.observaciones_laborales AS observaciones_laborales_80,
  t3.porcentaje_retencion_irpf AS porcentaje_retencion_irpf_81,
  t3.academia_id AS academia_id_82,
  t3.creado_id AS creado_id_83,
  t3.empresa_id AS empresa_id_84
FROM
  usuario t0
  LEFT JOIN administrador t1 ON t0.id = t1.id
  LEFT JOIN superusuario t2 ON t0.id = t2.id
  LEFT JOIN profesor t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.nombre AS nombre_5, t0.apellidos AS apellidos_6, t0.usuario AS usuario_7, t0.password AS password_8, t0.password_updated_at AS password_updated_at_9, t0.password_reset_token AS password_reset_token_10, t0.password_reset_token_expires_at AS password_reset_token_expires_at_11, t0.role AS role_12, t0.email AS email_13, t0.salt AS salt_14, t0.fecharegistro AS fecharegistro_15, t0.active AS active_16, t0.rolematriculaciones AS rolematriculaciones_17, t0.rolecontabilidad AS rolecontabilidad_18, t0.rolecobro AS rolecobro_19, t0.dni AS dni_20, t0.idioma AS idioma_21, t0.tipo, t1.superadmin AS superadmin_22, t1.gestorahelendoron AS gestorahelendoron_23, t1.verFacturacion AS verFacturacion_24, t1.empresa_id AS empresa_id_25, t2.empresa_id AS empresa_id_26, t3.titulacion AS titulacion_27, t3.direccion AS direccion_28, t3.codigopostal AS codigopostal_29, t3.localidad AS localidad_30, t3.provincia AS provincia_31, t3.categoria AS categoria_32, t3.movil AS movil_33, t3.telefono AS telefono_34, t3.telefono2 AS telefono2_35, t3.nss AS nss_36, t3.pasaporte AS pasaporte_37, t3.emailurgente AS emailurgente_38, t3.androidorios AS androidorios_39, t3.tokenDispositivo AS tokenDispositivo_40, t3.desarrollo AS desarrollo_41, t3.enviarobservaciones AS enviarobservaciones_42, t3.notasporexcel AS notasporexcel_43, t3.enviarencuestas AS enviarencuestas_44, t3.datosColegio AS datosColegio_45, t3.datosAcademicos AS datosAcademicos_46, t3.notificafaltas AS notificafaltas_47, t3.path AS path_48, t3.deviceid AS deviceid_49, t3.fcmtoken AS fcmtoken_50, t3.updatedFCMToken AS updatedFCMToken_51, t3.fechanacimiento AS fechanacimiento_52, t3.puedeactivarelearning AS puedeactivarelearning_53, t3.enviacopiaemail AS enviacopiaemail_54, t3.accesoinformacionalumnos AS accesoinformacionalumnos_55, t3.mostraremailtutorias AS mostraremailtutorias_56, t3.notificaciontareas AS notificaciontareas_57, t3.ajustarhoras AS ajustarhoras_58, t3.horasautomaticas AS horasautomaticas_59, t3.horasMensuales AS horasMensuales_60, t3.enviaNotificaciones AS enviaNotificaciones_61, t3.jefeDepartamento AS jefeDepartamento_62, t3.subirprogresoenclase AS subirprogresoenclase_63, t3.subirsimulaciones AS subirsimulaciones_64, t3.subirasistencia AS subirasistencia_65, t3.subirdocumentos AS subirdocumentos_66, t3.subirtareas AS subirtareas_67, t3.subirnotas AS subirnotas_68, t3.subircomentarioscurso AS subircomentarioscurso_69, t3.accesoaplicacion AS accesoaplicacion_70, t3.fechaUltimaConsultaNotificaciones AS fechaUltimaConsultaNotificaciones_71, t3.numero_seguridad_social AS numero_seguridad_social_72, t3.cuenta_bancaria AS cuenta_bancaria_73, t3.fecha_alta_seguridad_social AS fecha_alta_seguridad_social_74, t3.categoria_laboral AS categoria_laboral_75, t3.fijo_discontinuo AS fijo_discontinuo_76, t3.horas_semanales_contrato AS horas_semanales_contrato_77, t3.salario_base_anual AS salario_base_anual_78, t3.fecha_ultima_renovacion AS fecha_ultima_renovacion_79, t3.observaciones_laborales AS observaciones_laborales_80, t3.porcentaje_retencion_irpf AS porcentaje_retencion_irpf_81, t3.academia_id AS academia_id_82, t3.creado_id AS creado_id_83, t3.empresa_id AS empresa_id_84 FROM usuario t0 LEFT JOIN administrador t1 ON t0.id = t1.id LEFT JOIN superusuario t2 ON t0.id = t2.id LEFT JOIN profesor t3 ON t0.id = t3.id WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.idExterno AS idExterno_2,
  t0.nombre AS nombre_3,
  t0.email AS email_4,
  t0.email2 AS email2_5,
  t0.telefono AS telefono_6,
  t0.logotipo AS logotipo_7,
  t0.imagenprincipal AS imagenprincipal_8,
  t0.width AS width_9,
  t0.height AS height_10,
  t0.latitud AS latitud_11,
  t0.longitud AS longitud_12,
  t0.direccion AS direccion_13,
  t0.codigopostal AS codigopostal_14,
  t0.localidad AS localidad_15,
  t0.provincia AS provincia_16,
  t0.director AS director_17,
  t0.persona_contacto AS persona_contacto_18,
  t0.telefono2 AS telefono2_19,
  t0.movil AS movil_20,
  t0.fax AS fax_21,
  t0.correo_adicional AS correo_adicional_22,
  t0.otros_datos AS otros_datos_23,
  t0.ampa AS ampa_24,
  t0.web AS web_25,
  t0.descripcion AS descripcion_26,
  t0.numerofaltas AS numerofaltas_27,
  t0.numeromodificaciones AS numeromodificaciones_28,
  t0.fecharegistro AS fecharegistro_29,
  t0.tipoacademia AS tipoacademia_30,
  t0.enviomasivo AS enviomasivo_31,
  t0.centroPA AS centroPA_32,
  t0.tieneComedor AS tieneComedor_33,
  t0.activa AS activa_34,
  t0.numeroreenvios AS numeroreenvios_35,
  t0.ultimoreenvio AS ultimoreenvio_36,
  t0.tituloscreados AS tituloscreados_37,
  t0.eliminada AS eliminada_38,
  t0.prefijoremesas AS prefijoremesas_39,
  t0.smtphost AS smtphost_40,
  t0.smtpport AS smtpport_41,
  t0.smtpsecurity AS smtpsecurity_42,
  t0.smtpemail AS smtpemail_43,
  t0.smtppassword AS smtppassword_44,
  t0.piedepagina AS piedepagina_45,
  t0.pathpiepagina AS pathpiepagina_46,
  t0.conceptoRenovaciones AS conceptoRenovaciones_47,
  t0.textoExtrasMatriculas AS textoExtrasMatriculas_48,
  t0.precioMatricula AS precioMatricula_49,
  t0.deletedAt AS deletedAt_50,
  t0.textoFicheroPagos AS textoFicheroPagos_51,
  t0.periodicidadPredeterminada AS periodicidadPredeterminada_52,
  t0.tipoCentro AS tipoCentro_53,
  t0.fecha_inicio_inmersion AS fecha_inicio_inmersion_54,
  t0.fecha_fin_inmersion AS fecha_fin_inmersion_55,
  t0.codigoMatriculacion AS codigoMatriculacion_56,
  t0.prefijoGrupos AS prefijoGrupos_57,
  t0.autoProcesarReservas AS autoProcesarReservas_58,
  t0.tieneMenus AS tieneMenus_59,
  t0.precioInmersion AS precioInmersion_60,
  t0.plazosPagoInmersion AS plazosPagoInmersion_61,
  t0.sufijoNombre AS sufijoNombre_62,
  t0.informe_id AS informe_id_63,
  t0.empresa_id AS empresa_id_64,
  t0.contratoempresa_id AS contratoempresa_id_65,
  t0.contratoempresaMenor_id AS contratoempresaMenor_id_66,
  t0.provinciaCCAA AS provinciaCCAA_67,
  t0.paleta_id AS paleta_id_68,
  t0.academia_relacionada_id AS academia_relacionada_id_69,
  t0.hotel_id AS hotel_id_70,
  t0.cursoAcademico_id AS cursoAcademico_id_71,
  t0.formacobro_defecto_id AS formacobro_defecto_id_72
FROM
  academia t0
  INNER JOIN academia_administrador ON t0.id = academia_administrador.academia_id
WHERE
  academia_administrador.administrador_id = ?

SELECT t0.id AS id_1, t0.idExterno AS idExterno_2, t0.nombre AS nombre_3, t0.email AS email_4, t0.email2 AS email2_5, t0.telefono AS telefono_6, t0.logotipo AS logotipo_7, t0.imagenprincipal AS imagenprincipal_8, t0.width AS width_9, t0.height AS height_10, t0.latitud AS latitud_11, t0.longitud AS longitud_12, t0.direccion AS direccion_13, t0.codigopostal AS codigopostal_14, t0.localidad AS localidad_15, t0.provincia AS provincia_16, t0.director AS director_17, t0.persona_contacto AS persona_contacto_18, t0.telefono2 AS telefono2_19, t0.movil AS movil_20, t0.fax AS fax_21, t0.correo_adicional AS correo_adicional_22, t0.otros_datos AS otros_datos_23, t0.ampa AS ampa_24, t0.web AS web_25, t0.descripcion AS descripcion_26, t0.numerofaltas AS numerofaltas_27, t0.numeromodificaciones AS numeromodificaciones_28, t0.fecharegistro AS fecharegistro_29, t0.tipoacademia AS tipoacademia_30, t0.enviomasivo AS enviomasivo_31, t0.centroPA AS centroPA_32, t0.tieneComedor AS tieneComedor_33, t0.activa AS activa_34, t0.numeroreenvios AS numeroreenvios_35, t0.ultimoreenvio AS ultimoreenvio_36, t0.tituloscreados AS tituloscreados_37, t0.eliminada AS eliminada_38, t0.prefijoremesas AS prefijoremesas_39, t0.smtphost AS smtphost_40, t0.smtpport AS smtpport_41, t0.smtpsecurity AS smtpsecurity_42, t0.smtpemail AS smtpemail_43, t0.smtppassword AS smtppassword_44, t0.piedepagina AS piedepagina_45, t0.pathpiepagina AS pathpiepagina_46, t0.conceptoRenovaciones AS conceptoRenovaciones_47, t0.textoExtrasMatriculas AS textoExtrasMatriculas_48, t0.precioMatricula AS precioMatricula_49, t0.deletedAt AS deletedAt_50, t0.textoFicheroPagos AS textoFicheroPagos_51, t0.periodicidadPredeterminada AS periodicidadPredeterminada_52, t0.tipoCentro AS tipoCentro_53, t0.fecha_inicio_inmersion AS fecha_inicio_inmersion_54, t0.fecha_fin_inmersion AS fecha_fin_inmersion_55, t0.codigoMatriculacion AS codigoMatriculacion_56, t0.prefijoGrupos AS prefijoGrupos_57, t0.autoProcesarReservas AS autoProcesarReservas_58, t0.tieneMenus AS tieneMenus_59, t0.precioInmersion AS precioInmersion_60, t0.plazosPagoInmersion AS plazosPagoInmersion_61, t0.sufijoNombre AS sufijoNombre_62, t0.informe_id AS informe_id_63, t0.empresa_id AS empresa_id_64, t0.contratoempresa_id AS contratoempresa_id_65, t0.contratoempresaMenor_id AS contratoempresaMenor_id_66, t0.provinciaCCAA AS provinciaCCAA_67, t0.paleta_id AS paleta_id_68, t0.academia_relacionada_id AS academia_relacionada_id_69, t0.hotel_id AS hotel_id_70, t0.cursoAcademico_id AS cursoAcademico_id_71, t0.formacobro_defecto_id AS formacobro_defecto_id_72 FROM academia t0 INNER JOIN academia_administrador ON t0.id = academia_administrador.academia_id WHERE academia_administrador.administrador_id = 3;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  alumno a0_
WHERE
  a0_.empresa_id = ?
  AND a0_.borrado = ?
  AND a0_.borradoDefinitivo = ?
  AND a0_.bajatemporal = ?
  AND a0_.avisarfaltas = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM alumno a0_ WHERE a0_.empresa_id = 1 AND a0_.borrado = 0 AND a0_.borradoDefinitivo = 0 AND a0_.bajatemporal = 0 AND a0_.avisarfaltas = 1;