Symfony Profiler

SELECT
  t1.id AS id_2,
  t1.nombre AS nombre_3,
  t1.apellido1 AS apellido1_4,
  t1.apellido2 AS apellido2_5,
  t1.nif_cif AS nif_cif_6,
  t1.usuario AS usuario_7,
  t1.email AS email_8,
  t1.password AS password_9,
  t1.salt AS salt_10,
  t1.activo AS activo_11,
  t1.role AS role_12,
  t1.permisocambridge AS permisocambridge_13,
  t1.permisopagos AS permisopagos_14,
  t1.permisomatriculacion AS permisomatriculacion_15,
  t1.creacionusuario AS creacionusuario_16,
  t1.creacionfecha AS creacionfecha_17,
  t1.modificacionusuario AS modificacionusuario_18,
  t1.modificacionfecha AS modificacionfecha_19,
  t1.permisoacademia AS permisoacademia_20,
  t1.codigorecuperacion AS codigorecuperacion_21,
  t1.direccion AS direccion_22,
  t1.cp AS cp_23,
  t1.telefono1 AS telefono1_24,
  t1.telefono2 AS telefono2_25,
  t1.eliminadologico AS eliminadologico_26,
  t0.latitud AS latitud_27,
  t0.longitud AS longitud_28,
  t0.personacontacto AS personacontacto_29,
  t0.pathacademia AS pathacademia_30,
  t0.numerosubidasimagen AS numerosubidasimagen_31,
  t0.orden AS orden_32,
  t0.indverificado AS indverificado_33,
  t0.hastaultimodia AS hastaultimodia_34,
  t0.indadmitecerradas AS indadmitecerradas_35,
  t0.estadovisual AS estadovisual_36,
  t0.centrenumber AS centrenumber_37,
  t0.observaciones AS observaciones_38,
  t0.web AS web_39,
  t0.directorcentro AS directorcentro_40,
  t0.premium AS premium_41,
  t0.beneficiospremium AS beneficiospremium_42,
  t0.sendemail AS sendemail_43,
  t0.showedescription AS showedescription_44,
  t0.canjeoespecial AS canjeoespecial_45,
  t0.tipoacuerdo AS tipoacuerdo_46,
  t0.centropreparador AS centropreparador_47,
  t0.ispublic AS ispublic_48,
  t0.mostrarenmapa AS mostrarenmapa_49,
  t0.codigoacademia AS codigoacademia_50,
  t0.emailcoe AS emailcoe_51,
  t0.passopen AS passopen_52,
  t0.accesoinicial AS accesoinicial_53,
  t0.contraseniaaleatoria AS contraseniaaleatoria_54,
  t0.descuento AS descuento_55,
  t0.tituloposicionamiento AS tituloposicionamiento_56,
  t0.textoposicionamiento AS textoposicionamiento_57,
  t0.ordenadores AS ordenadores_58,
  t0.slug AS slug_59,
  t0.sluglinguaskill AS sluglinguaskill_60,
  t0.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_61,
  t0.seleccionhorario AS seleccionhorario_62,
  t0.informacion AS informacion_63,
  t0.codecenter AS codecenter_64,
  t0.isinstitucion AS isinstitucion_65,
  t0.tipoenlace AS tipoenlace_66,
  t0.conversiondinero AS conversiondinero_67,
  t0.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_68,
  t0.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_69,
  t0.puedematricularotroscentros AS puedematricularotroscentros_70,
  t0.cuentacontable AS cuentacontable_71,
  t0.razonsocial AS razonsocial_72,
  t0.direccionfacturacion AS direccionfacturacion_73,
  t0.cpfacturacion AS cpfacturacion_74,
  t0.poblacionfacturacion AS poblacionfacturacion_75,
  t0.provinciafacturacion AS provinciafacturacion_76,
  t0.paisfacturacion AS paisfacturacion_77,
  t0.convocatorias_slug AS convocatorias_slug_78,
  t0.puede_solicitar_facturas AS puede_solicitar_facturas_79,
  t0.datos_rellenos AS datos_rellenos_80,
  t0.pagalateentry1 AS pagalateentry1_81,
  t0.pagalateentry2 AS pagalateentry2_82,
  t0.pagalateentry3 AS pagalateentry3_83,
  t0.saltardni AS saltardni_84,
  t0.condicionesSlugQualifications AS condicionesSlugQualifications_85,
  t1.tipos_documento_id AS tipos_documento_id_86,
  t1.idtipousuario_id AS idtipousuario_id_87,
  t1.idpoblacion_id AS idpoblacion_id_88,
  t1.idprovincia_id AS idprovincia_id_89,
  t0.tipovenue_id AS tipovenue_id_90,
  t0.poblacion_info_id AS poblacion_info_id_91,
  t1.tipo
FROM
  academias t0
  INNER JOIN usuarios t1 ON t0.id = t1.id
WHERE
  t0.mostrarenmapa = ?
  AND t1.eliminadologico = ?
ORDER BY
  t1.nombre ASC

SELECT t1.id AS id_2, t1.nombre AS nombre_3, t1.apellido1 AS apellido1_4, t1.apellido2 AS apellido2_5, t1.nif_cif AS nif_cif_6, t1.usuario AS usuario_7, t1.email AS email_8, t1.password AS password_9, t1.salt AS salt_10, t1.activo AS activo_11, t1.role AS role_12, t1.permisocambridge AS permisocambridge_13, t1.permisopagos AS permisopagos_14, t1.permisomatriculacion AS permisomatriculacion_15, t1.creacionusuario AS creacionusuario_16, t1.creacionfecha AS creacionfecha_17, t1.modificacionusuario AS modificacionusuario_18, t1.modificacionfecha AS modificacionfecha_19, t1.permisoacademia AS permisoacademia_20, t1.codigorecuperacion AS codigorecuperacion_21, t1.direccion AS direccion_22, t1.cp AS cp_23, t1.telefono1 AS telefono1_24, t1.telefono2 AS telefono2_25, t1.eliminadologico AS eliminadologico_26, t0.latitud AS latitud_27, t0.longitud AS longitud_28, t0.personacontacto AS personacontacto_29, t0.pathacademia AS pathacademia_30, t0.numerosubidasimagen AS numerosubidasimagen_31, t0.orden AS orden_32, t0.indverificado AS indverificado_33, t0.hastaultimodia AS hastaultimodia_34, t0.indadmitecerradas AS indadmitecerradas_35, t0.estadovisual AS estadovisual_36, t0.centrenumber AS centrenumber_37, t0.observaciones AS observaciones_38, t0.web AS web_39, t0.directorcentro AS directorcentro_40, t0.premium AS premium_41, t0.beneficiospremium AS beneficiospremium_42, t0.sendemail AS sendemail_43, t0.showedescription AS showedescription_44, t0.canjeoespecial AS canjeoespecial_45, t0.tipoacuerdo AS tipoacuerdo_46, t0.centropreparador AS centropreparador_47, t0.ispublic AS ispublic_48, t0.mostrarenmapa AS mostrarenmapa_49, t0.codigoacademia AS codigoacademia_50, t0.emailcoe AS emailcoe_51, t0.passopen AS passopen_52, t0.accesoinicial AS accesoinicial_53, t0.contraseniaaleatoria AS contraseniaaleatoria_54, t0.descuento AS descuento_55, t0.tituloposicionamiento AS tituloposicionamiento_56, t0.textoposicionamiento AS textoposicionamiento_57, t0.ordenadores AS ordenadores_58, t0.slug AS slug_59, t0.sluglinguaskill AS sluglinguaskill_60, t0.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_61, t0.seleccionhorario AS seleccionhorario_62, t0.informacion AS informacion_63, t0.codecenter AS codecenter_64, t0.isinstitucion AS isinstitucion_65, t0.tipoenlace AS tipoenlace_66, t0.conversiondinero AS conversiondinero_67, t0.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_68, t0.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_69, t0.puedematricularotroscentros AS puedematricularotroscentros_70, t0.cuentacontable AS cuentacontable_71, t0.razonsocial AS razonsocial_72, t0.direccionfacturacion AS direccionfacturacion_73, t0.cpfacturacion AS cpfacturacion_74, t0.poblacionfacturacion AS poblacionfacturacion_75, t0.provinciafacturacion AS provinciafacturacion_76, t0.paisfacturacion AS paisfacturacion_77, t0.convocatorias_slug AS convocatorias_slug_78, t0.puede_solicitar_facturas AS puede_solicitar_facturas_79, t0.datos_rellenos AS datos_rellenos_80, t0.pagalateentry1 AS pagalateentry1_81, t0.pagalateentry2 AS pagalateentry2_82, t0.pagalateentry3 AS pagalateentry3_83, t0.saltardni AS saltardni_84, t0.condicionesSlugQualifications AS condicionesSlugQualifications_85, t1.tipos_documento_id AS tipos_documento_id_86, t1.idtipousuario_id AS idtipousuario_id_87, t1.idpoblacion_id AS idpoblacion_id_88, t1.idprovincia_id AS idprovincia_id_89, t0.tipovenue_id AS tipovenue_id_90, t0.poblacion_info_id AS poblacion_info_id_91, t1.tipo FROM academias t0 INNER JOIN usuarios t1 ON t0.id = t1.id WHERE t0.mostrarenmapa = 1 AND t1.eliminadologico = 0 ORDER BY t1.nombre ASC;

SELECT
  u0_.id AS id_0,
  u0_.nombre AS nombre_1,
  u0_.apellido1 AS apellido1_2,
  u0_.apellido2 AS apellido2_3,
  u0_.nif_cif AS nif_cif_4,
  u0_.usuario AS usuario_5,
  u0_.email AS email_6,
  u0_.password AS password_7,
  u0_.salt AS salt_8,
  u0_.activo AS activo_9,
  u0_.role AS role_10,
  u0_.permisocambridge AS permisocambridge_11,
  u0_.permisopagos AS permisopagos_12,
  u0_.permisomatriculacion AS permisomatriculacion_13,
  u0_.creacionusuario AS creacionusuario_14,
  u0_.creacionfecha AS creacionfecha_15,
  u0_.modificacionusuario AS modificacionusuario_16,
  u0_.modificacionfecha AS modificacionfecha_17,
  u0_.permisoacademia AS permisoacademia_18,
  u0_.codigorecuperacion AS codigorecuperacion_19,
  u0_.direccion AS direccion_20,
  u0_.cp AS cp_21,
  u0_.telefono1 AS telefono1_22,
  u0_.telefono2 AS telefono2_23,
  u0_.eliminadologico AS eliminadologico_24,
  a1_.latitud AS latitud_25,
  a1_.longitud AS longitud_26,
  a1_.personacontacto AS personacontacto_27,
  a1_.pathacademia AS pathacademia_28,
  a1_.numerosubidasimagen AS numerosubidasimagen_29,
  a1_.orden AS orden_30,
  a1_.indverificado AS indverificado_31,
  a1_.hastaultimodia AS hastaultimodia_32,
  a1_.indadmitecerradas AS indadmitecerradas_33,
  a1_.estadovisual AS estadovisual_34,
  a1_.centrenumber AS centrenumber_35,
  a1_.observaciones AS observaciones_36,
  a1_.web AS web_37,
  a1_.directorcentro AS directorcentro_38,
  a1_.premium AS premium_39,
  a1_.beneficiospremium AS beneficiospremium_40,
  a1_.sendemail AS sendemail_41,
  a1_.showedescription AS showedescription_42,
  a1_.canjeoespecial AS canjeoespecial_43,
  a1_.tipoacuerdo AS tipoacuerdo_44,
  a1_.centropreparador AS centropreparador_45,
  a1_.ispublic AS ispublic_46,
  a1_.mostrarenmapa AS mostrarenmapa_47,
  a1_.codigoacademia AS codigoacademia_48,
  a1_.emailcoe AS emailcoe_49,
  a1_.passopen AS passopen_50,
  a1_.accesoinicial AS accesoinicial_51,
  a1_.contraseniaaleatoria AS contraseniaaleatoria_52,
  a1_.descuento AS descuento_53,
  a1_.tituloposicionamiento AS tituloposicionamiento_54,
  a1_.textoposicionamiento AS textoposicionamiento_55,
  a1_.ordenadores AS ordenadores_56,
  a1_.slug AS slug_57,
  a1_.sluglinguaskill AS sluglinguaskill_58,
  a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59,
  a1_.seleccionhorario AS seleccionhorario_60,
  a1_.informacion AS informacion_61,
  a1_.codecenter AS codecenter_62,
  a1_.isinstitucion AS isinstitucion_63,
  a1_.tipoenlace AS tipoenlace_64,
  a1_.conversiondinero AS conversiondinero_65,
  a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66,
  a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67,
  a1_.puedematricularotroscentros AS puedematricularotroscentros_68,
  a1_.cuentacontable AS cuentacontable_69,
  a1_.razonsocial AS razonsocial_70,
  a1_.direccionfacturacion AS direccionfacturacion_71,
  a1_.cpfacturacion AS cpfacturacion_72,
  a1_.poblacionfacturacion AS poblacionfacturacion_73,
  a1_.provinciafacturacion AS provinciafacturacion_74,
  a1_.paisfacturacion AS paisfacturacion_75,
  a1_.convocatorias_slug AS convocatorias_slug_76,
  a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77,
  a1_.datos_rellenos AS datos_rellenos_78,
  a1_.pagalateentry1 AS pagalateentry1_79,
  a1_.pagalateentry2 AS pagalateentry2_80,
  a1_.pagalateentry3 AS pagalateentry3_81,
  a1_.saltardni AS saltardni_82,
  a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83,
  u0_.tipo AS tipo_84,
  u0_.tipos_documento_id AS tipos_documento_id_85,
  u0_.idtipousuario_id AS idtipousuario_id_86,
  u0_.idpoblacion_id AS idpoblacion_id_87,
  u0_.idprovincia_id AS idprovincia_id_88,
  a1_.tipovenue_id AS tipovenue_id_89,
  a1_.poblacion_info_id AS poblacion_info_id_90
FROM
  academias a1_
  INNER JOIN usuarios u0_ ON a1_.id = u0_.id
WHERE
  a1_.ispublic = 1
  AND u0_.activo = 1
ORDER BY
  a1_.orden ASC,
  u0_.nombre ASC
LIMIT
  32

SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.apellido1 AS apellido1_2, u0_.apellido2 AS apellido2_3, u0_.nif_cif AS nif_cif_4, u0_.usuario AS usuario_5, u0_.email AS email_6, u0_.password AS password_7, u0_.salt AS salt_8, u0_.activo AS activo_9, u0_.role AS role_10, u0_.permisocambridge AS permisocambridge_11, u0_.permisopagos AS permisopagos_12, u0_.permisomatriculacion AS permisomatriculacion_13, u0_.creacionusuario AS creacionusuario_14, u0_.creacionfecha AS creacionfecha_15, u0_.modificacionusuario AS modificacionusuario_16, u0_.modificacionfecha AS modificacionfecha_17, u0_.permisoacademia AS permisoacademia_18, u0_.codigorecuperacion AS codigorecuperacion_19, u0_.direccion AS direccion_20, u0_.cp AS cp_21, u0_.telefono1 AS telefono1_22, u0_.telefono2 AS telefono2_23, u0_.eliminadologico AS eliminadologico_24, a1_.latitud AS latitud_25, a1_.longitud AS longitud_26, a1_.personacontacto AS personacontacto_27, a1_.pathacademia AS pathacademia_28, a1_.numerosubidasimagen AS numerosubidasimagen_29, a1_.orden AS orden_30, a1_.indverificado AS indverificado_31, a1_.hastaultimodia AS hastaultimodia_32, a1_.indadmitecerradas AS indadmitecerradas_33, a1_.estadovisual AS estadovisual_34, a1_.centrenumber AS centrenumber_35, a1_.observaciones AS observaciones_36, a1_.web AS web_37, a1_.directorcentro AS directorcentro_38, a1_.premium AS premium_39, a1_.beneficiospremium AS beneficiospremium_40, a1_.sendemail AS sendemail_41, a1_.showedescription AS showedescription_42, a1_.canjeoespecial AS canjeoespecial_43, a1_.tipoacuerdo AS tipoacuerdo_44, a1_.centropreparador AS centropreparador_45, a1_.ispublic AS ispublic_46, a1_.mostrarenmapa AS mostrarenmapa_47, a1_.codigoacademia AS codigoacademia_48, a1_.emailcoe AS emailcoe_49, a1_.passopen AS passopen_50, a1_.accesoinicial AS accesoinicial_51, a1_.contraseniaaleatoria AS contraseniaaleatoria_52, a1_.descuento AS descuento_53, a1_.tituloposicionamiento AS tituloposicionamiento_54, a1_.textoposicionamiento AS textoposicionamiento_55, a1_.ordenadores AS ordenadores_56, a1_.slug AS slug_57, a1_.sluglinguaskill AS sluglinguaskill_58, a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59, a1_.seleccionhorario AS seleccionhorario_60, a1_.informacion AS informacion_61, a1_.codecenter AS codecenter_62, a1_.isinstitucion AS isinstitucion_63, a1_.tipoenlace AS tipoenlace_64, a1_.conversiondinero AS conversiondinero_65, a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66, a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67, a1_.puedematricularotroscentros AS puedematricularotroscentros_68, a1_.cuentacontable AS cuentacontable_69, a1_.razonsocial AS razonsocial_70, a1_.direccionfacturacion AS direccionfacturacion_71, a1_.cpfacturacion AS cpfacturacion_72, a1_.poblacionfacturacion AS poblacionfacturacion_73, a1_.provinciafacturacion AS provinciafacturacion_74, a1_.paisfacturacion AS paisfacturacion_75, a1_.convocatorias_slug AS convocatorias_slug_76, a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77, a1_.datos_rellenos AS datos_rellenos_78, a1_.pagalateentry1 AS pagalateentry1_79, a1_.pagalateentry2 AS pagalateentry2_80, a1_.pagalateentry3 AS pagalateentry3_81, a1_.saltardni AS saltardni_82, a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83, u0_.tipo AS tipo_84, u0_.tipos_documento_id AS tipos_documento_id_85, u0_.idtipousuario_id AS idtipousuario_id_86, u0_.idpoblacion_id AS idpoblacion_id_87, u0_.idprovincia_id AS idprovincia_id_88, a1_.tipovenue_id AS tipovenue_id_89, a1_.poblacion_info_id AS poblacion_info_id_90 FROM academias a1_ INNER JOIN usuarios u0_ ON a1_.id = u0_.id WHERE a1_.ispublic = 1 AND u0_.activo = 1 ORDER BY a1_.orden ASC, u0_.nombre ASC LIMIT 32;

SELECT
  p0_.id AS id_0,
  p0_.codineprovincia AS codineprovincia_1,
  p0_.nombre AS nombre_2,
  p0_.creacionusuario AS creacionusuario_3,
  p0_.creacionfecha AS creacionfecha_4,
  p0_.modificacionusuario AS modificacionusuario_5,
  p0_.modificacionfecha AS modificacionfecha_6
FROM
  provincias p0_
  INNER JOIN (
    academias a1_
    INNER JOIN usuarios u2_ ON a1_.id = u2_.id
  ) ON (u2_.idprovincia_id = p0_.id)
WHERE
  u2_.activo = ?
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.codineprovincia AS codineprovincia_1, p0_.nombre AS nombre_2, p0_.creacionusuario AS creacionusuario_3, p0_.creacionfecha AS creacionfecha_4, p0_.modificacionusuario AS modificacionusuario_5, p0_.modificacionfecha AS modificacionfecha_6 FROM provincias p0_ INNER JOIN (academias a1_ INNER JOIN usuarios u2_ ON a1_.id = u2_.id) ON (u2_.idprovincia_id = p0_.id) WHERE u2_.activo = 1 ORDER BY p0_.nombre ASC;

SELECT
  u0_.id AS id_0,
  u0_.nombre AS nombre_1,
  u0_.apellido1 AS apellido1_2,
  u0_.apellido2 AS apellido2_3,
  u0_.nif_cif AS nif_cif_4,
  u0_.usuario AS usuario_5,
  u0_.email AS email_6,
  u0_.password AS password_7,
  u0_.salt AS salt_8,
  u0_.activo AS activo_9,
  u0_.role AS role_10,
  u0_.permisocambridge AS permisocambridge_11,
  u0_.permisopagos AS permisopagos_12,
  u0_.permisomatriculacion AS permisomatriculacion_13,
  u0_.creacionusuario AS creacionusuario_14,
  u0_.creacionfecha AS creacionfecha_15,
  u0_.modificacionusuario AS modificacionusuario_16,
  u0_.modificacionfecha AS modificacionfecha_17,
  u0_.permisoacademia AS permisoacademia_18,
  u0_.codigorecuperacion AS codigorecuperacion_19,
  u0_.direccion AS direccion_20,
  u0_.cp AS cp_21,
  u0_.telefono1 AS telefono1_22,
  u0_.telefono2 AS telefono2_23,
  u0_.eliminadologico AS eliminadologico_24,
  a1_.latitud AS latitud_25,
  a1_.longitud AS longitud_26,
  a1_.personacontacto AS personacontacto_27,
  a1_.pathacademia AS pathacademia_28,
  a1_.numerosubidasimagen AS numerosubidasimagen_29,
  a1_.orden AS orden_30,
  a1_.indverificado AS indverificado_31,
  a1_.hastaultimodia AS hastaultimodia_32,
  a1_.indadmitecerradas AS indadmitecerradas_33,
  a1_.estadovisual AS estadovisual_34,
  a1_.centrenumber AS centrenumber_35,
  a1_.observaciones AS observaciones_36,
  a1_.web AS web_37,
  a1_.directorcentro AS directorcentro_38,
  a1_.premium AS premium_39,
  a1_.beneficiospremium AS beneficiospremium_40,
  a1_.sendemail AS sendemail_41,
  a1_.showedescription AS showedescription_42,
  a1_.canjeoespecial AS canjeoespecial_43,
  a1_.tipoacuerdo AS tipoacuerdo_44,
  a1_.centropreparador AS centropreparador_45,
  a1_.ispublic AS ispublic_46,
  a1_.mostrarenmapa AS mostrarenmapa_47,
  a1_.codigoacademia AS codigoacademia_48,
  a1_.emailcoe AS emailcoe_49,
  a1_.passopen AS passopen_50,
  a1_.accesoinicial AS accesoinicial_51,
  a1_.contraseniaaleatoria AS contraseniaaleatoria_52,
  a1_.descuento AS descuento_53,
  a1_.tituloposicionamiento AS tituloposicionamiento_54,
  a1_.textoposicionamiento AS textoposicionamiento_55,
  a1_.ordenadores AS ordenadores_56,
  a1_.slug AS slug_57,
  a1_.sluglinguaskill AS sluglinguaskill_58,
  a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59,
  a1_.seleccionhorario AS seleccionhorario_60,
  a1_.informacion AS informacion_61,
  a1_.codecenter AS codecenter_62,
  a1_.isinstitucion AS isinstitucion_63,
  a1_.tipoenlace AS tipoenlace_64,
  a1_.conversiondinero AS conversiondinero_65,
  a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66,
  a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67,
  a1_.puedematricularotroscentros AS puedematricularotroscentros_68,
  a1_.cuentacontable AS cuentacontable_69,
  a1_.razonsocial AS razonsocial_70,
  a1_.direccionfacturacion AS direccionfacturacion_71,
  a1_.cpfacturacion AS cpfacturacion_72,
  a1_.poblacionfacturacion AS poblacionfacturacion_73,
  a1_.provinciafacturacion AS provinciafacturacion_74,
  a1_.paisfacturacion AS paisfacturacion_75,
  a1_.convocatorias_slug AS convocatorias_slug_76,
  a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77,
  a1_.datos_rellenos AS datos_rellenos_78,
  a1_.pagalateentry1 AS pagalateentry1_79,
  a1_.pagalateentry2 AS pagalateentry2_80,
  a1_.pagalateentry3 AS pagalateentry3_81,
  a1_.saltardni AS saltardni_82,
  a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83,
  u0_.tipo AS tipo_84,
  u0_.tipos_documento_id AS tipos_documento_id_85,
  u0_.idtipousuario_id AS idtipousuario_id_86,
  u0_.idpoblacion_id AS idpoblacion_id_87,
  u0_.idprovincia_id AS idprovincia_id_88,
  a1_.tipovenue_id AS tipovenue_id_89,
  a1_.poblacion_info_id AS poblacion_info_id_90
FROM
  academias a1_
  INNER JOIN usuarios u0_ ON a1_.id = u0_.id
WHERE
  a1_.ispublic = 1
  AND a1_.isinstitucion = 1
  AND u0_.activo = 1
ORDER BY
  u0_.nombre ASC

SELECT u0_.id AS id_0, u0_.nombre AS nombre_1, u0_.apellido1 AS apellido1_2, u0_.apellido2 AS apellido2_3, u0_.nif_cif AS nif_cif_4, u0_.usuario AS usuario_5, u0_.email AS email_6, u0_.password AS password_7, u0_.salt AS salt_8, u0_.activo AS activo_9, u0_.role AS role_10, u0_.permisocambridge AS permisocambridge_11, u0_.permisopagos AS permisopagos_12, u0_.permisomatriculacion AS permisomatriculacion_13, u0_.creacionusuario AS creacionusuario_14, u0_.creacionfecha AS creacionfecha_15, u0_.modificacionusuario AS modificacionusuario_16, u0_.modificacionfecha AS modificacionfecha_17, u0_.permisoacademia AS permisoacademia_18, u0_.codigorecuperacion AS codigorecuperacion_19, u0_.direccion AS direccion_20, u0_.cp AS cp_21, u0_.telefono1 AS telefono1_22, u0_.telefono2 AS telefono2_23, u0_.eliminadologico AS eliminadologico_24, a1_.latitud AS latitud_25, a1_.longitud AS longitud_26, a1_.personacontacto AS personacontacto_27, a1_.pathacademia AS pathacademia_28, a1_.numerosubidasimagen AS numerosubidasimagen_29, a1_.orden AS orden_30, a1_.indverificado AS indverificado_31, a1_.hastaultimodia AS hastaultimodia_32, a1_.indadmitecerradas AS indadmitecerradas_33, a1_.estadovisual AS estadovisual_34, a1_.centrenumber AS centrenumber_35, a1_.observaciones AS observaciones_36, a1_.web AS web_37, a1_.directorcentro AS directorcentro_38, a1_.premium AS premium_39, a1_.beneficiospremium AS beneficiospremium_40, a1_.sendemail AS sendemail_41, a1_.showedescription AS showedescription_42, a1_.canjeoespecial AS canjeoespecial_43, a1_.tipoacuerdo AS tipoacuerdo_44, a1_.centropreparador AS centropreparador_45, a1_.ispublic AS ispublic_46, a1_.mostrarenmapa AS mostrarenmapa_47, a1_.codigoacademia AS codigoacademia_48, a1_.emailcoe AS emailcoe_49, a1_.passopen AS passopen_50, a1_.accesoinicial AS accesoinicial_51, a1_.contraseniaaleatoria AS contraseniaaleatoria_52, a1_.descuento AS descuento_53, a1_.tituloposicionamiento AS tituloposicionamiento_54, a1_.textoposicionamiento AS textoposicionamiento_55, a1_.ordenadores AS ordenadores_56, a1_.slug AS slug_57, a1_.sluglinguaskill AS sluglinguaskill_58, a1_.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_59, a1_.seleccionhorario AS seleccionhorario_60, a1_.informacion AS informacion_61, a1_.codecenter AS codecenter_62, a1_.isinstitucion AS isinstitucion_63, a1_.tipoenlace AS tipoenlace_64, a1_.conversiondinero AS conversiondinero_65, a1_.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_66, a1_.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_67, a1_.puedematricularotroscentros AS puedematricularotroscentros_68, a1_.cuentacontable AS cuentacontable_69, a1_.razonsocial AS razonsocial_70, a1_.direccionfacturacion AS direccionfacturacion_71, a1_.cpfacturacion AS cpfacturacion_72, a1_.poblacionfacturacion AS poblacionfacturacion_73, a1_.provinciafacturacion AS provinciafacturacion_74, a1_.paisfacturacion AS paisfacturacion_75, a1_.convocatorias_slug AS convocatorias_slug_76, a1_.puede_solicitar_facturas AS puede_solicitar_facturas_77, a1_.datos_rellenos AS datos_rellenos_78, a1_.pagalateentry1 AS pagalateentry1_79, a1_.pagalateentry2 AS pagalateentry2_80, a1_.pagalateentry3 AS pagalateentry3_81, a1_.saltardni AS saltardni_82, a1_.condicionesSlugQualifications AS condicionesSlugQualifications_83, u0_.tipo AS tipo_84, u0_.tipos_documento_id AS tipos_documento_id_85, u0_.idtipousuario_id AS idtipousuario_id_86, u0_.idpoblacion_id AS idpoblacion_id_87, u0_.idprovincia_id AS idprovincia_id_88, a1_.tipovenue_id AS tipovenue_id_89, a1_.poblacion_info_id AS poblacion_info_id_90 FROM academias a1_ INNER JOIN usuarios u0_ ON a1_.id = u0_.id WHERE a1_.ispublic = 1 AND a1_.isinstitucion = 1 AND u0_.activo = 1 ORDER BY u0_.nombre ASC;

SELECT
  t1.id AS id_2,
  t1.nombre AS nombre_3,
  t1.apellido1 AS apellido1_4,
  t1.apellido2 AS apellido2_5,
  t1.nif_cif AS nif_cif_6,
  t1.usuario AS usuario_7,
  t1.email AS email_8,
  t1.password AS password_9,
  t1.salt AS salt_10,
  t1.activo AS activo_11,
  t1.role AS role_12,
  t1.permisocambridge AS permisocambridge_13,
  t1.permisopagos AS permisopagos_14,
  t1.permisomatriculacion AS permisomatriculacion_15,
  t1.creacionusuario AS creacionusuario_16,
  t1.creacionfecha AS creacionfecha_17,
  t1.modificacionusuario AS modificacionusuario_18,
  t1.modificacionfecha AS modificacionfecha_19,
  t1.permisoacademia AS permisoacademia_20,
  t1.codigorecuperacion AS codigorecuperacion_21,
  t1.direccion AS direccion_22,
  t1.cp AS cp_23,
  t1.telefono1 AS telefono1_24,
  t1.telefono2 AS telefono2_25,
  t1.eliminadologico AS eliminadologico_26,
  t0.latitud AS latitud_27,
  t0.longitud AS longitud_28,
  t0.personacontacto AS personacontacto_29,
  t0.pathacademia AS pathacademia_30,
  t0.numerosubidasimagen AS numerosubidasimagen_31,
  t0.orden AS orden_32,
  t0.indverificado AS indverificado_33,
  t0.hastaultimodia AS hastaultimodia_34,
  t0.indadmitecerradas AS indadmitecerradas_35,
  t0.estadovisual AS estadovisual_36,
  t0.centrenumber AS centrenumber_37,
  t0.observaciones AS observaciones_38,
  t0.web AS web_39,
  t0.directorcentro AS directorcentro_40,
  t0.premium AS premium_41,
  t0.beneficiospremium AS beneficiospremium_42,
  t0.sendemail AS sendemail_43,
  t0.showedescription AS showedescription_44,
  t0.canjeoespecial AS canjeoespecial_45,
  t0.tipoacuerdo AS tipoacuerdo_46,
  t0.centropreparador AS centropreparador_47,
  t0.ispublic AS ispublic_48,
  t0.mostrarenmapa AS mostrarenmapa_49,
  t0.codigoacademia AS codigoacademia_50,
  t0.emailcoe AS emailcoe_51,
  t0.passopen AS passopen_52,
  t0.accesoinicial AS accesoinicial_53,
  t0.contraseniaaleatoria AS contraseniaaleatoria_54,
  t0.descuento AS descuento_55,
  t0.tituloposicionamiento AS tituloposicionamiento_56,
  t0.textoposicionamiento AS textoposicionamiento_57,
  t0.ordenadores AS ordenadores_58,
  t0.slug AS slug_59,
  t0.sluglinguaskill AS sluglinguaskill_60,
  t0.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_61,
  t0.seleccionhorario AS seleccionhorario_62,
  t0.informacion AS informacion_63,
  t0.codecenter AS codecenter_64,
  t0.isinstitucion AS isinstitucion_65,
  t0.tipoenlace AS tipoenlace_66,
  t0.conversiondinero AS conversiondinero_67,
  t0.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_68,
  t0.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_69,
  t0.puedematricularotroscentros AS puedematricularotroscentros_70,
  t0.cuentacontable AS cuentacontable_71,
  t0.razonsocial AS razonsocial_72,
  t0.direccionfacturacion AS direccionfacturacion_73,
  t0.cpfacturacion AS cpfacturacion_74,
  t0.poblacionfacturacion AS poblacionfacturacion_75,
  t0.provinciafacturacion AS provinciafacturacion_76,
  t0.paisfacturacion AS paisfacturacion_77,
  t0.convocatorias_slug AS convocatorias_slug_78,
  t0.puede_solicitar_facturas AS puede_solicitar_facturas_79,
  t0.datos_rellenos AS datos_rellenos_80,
  t0.pagalateentry1 AS pagalateentry1_81,
  t0.pagalateentry2 AS pagalateentry2_82,
  t0.pagalateentry3 AS pagalateentry3_83,
  t0.saltardni AS saltardni_84,
  t0.condicionesSlugQualifications AS condicionesSlugQualifications_85,
  t1.tipos_documento_id AS tipos_documento_id_86,
  t1.idtipousuario_id AS idtipousuario_id_87,
  t1.idpoblacion_id AS idpoblacion_id_88,
  t1.idprovincia_id AS idprovincia_id_89,
  t0.tipovenue_id AS tipovenue_id_90,
  t0.poblacion_info_id AS poblacion_info_id_91,
  t1.tipo
FROM
  academias t0
  INNER JOIN usuarios t1 ON t0.id = t1.id
WHERE
  t0.ispublic = ?
  AND t1.eliminadologico = ?
  AND t0.premium = ?
ORDER BY
  t0.orden ASC,
  t1.nombre ASC

SELECT t1.id AS id_2, t1.nombre AS nombre_3, t1.apellido1 AS apellido1_4, t1.apellido2 AS apellido2_5, t1.nif_cif AS nif_cif_6, t1.usuario AS usuario_7, t1.email AS email_8, t1.password AS password_9, t1.salt AS salt_10, t1.activo AS activo_11, t1.role AS role_12, t1.permisocambridge AS permisocambridge_13, t1.permisopagos AS permisopagos_14, t1.permisomatriculacion AS permisomatriculacion_15, t1.creacionusuario AS creacionusuario_16, t1.creacionfecha AS creacionfecha_17, t1.modificacionusuario AS modificacionusuario_18, t1.modificacionfecha AS modificacionfecha_19, t1.permisoacademia AS permisoacademia_20, t1.codigorecuperacion AS codigorecuperacion_21, t1.direccion AS direccion_22, t1.cp AS cp_23, t1.telefono1 AS telefono1_24, t1.telefono2 AS telefono2_25, t1.eliminadologico AS eliminadologico_26, t0.latitud AS latitud_27, t0.longitud AS longitud_28, t0.personacontacto AS personacontacto_29, t0.pathacademia AS pathacademia_30, t0.numerosubidasimagen AS numerosubidasimagen_31, t0.orden AS orden_32, t0.indverificado AS indverificado_33, t0.hastaultimodia AS hastaultimodia_34, t0.indadmitecerradas AS indadmitecerradas_35, t0.estadovisual AS estadovisual_36, t0.centrenumber AS centrenumber_37, t0.observaciones AS observaciones_38, t0.web AS web_39, t0.directorcentro AS directorcentro_40, t0.premium AS premium_41, t0.beneficiospremium AS beneficiospremium_42, t0.sendemail AS sendemail_43, t0.showedescription AS showedescription_44, t0.canjeoespecial AS canjeoespecial_45, t0.tipoacuerdo AS tipoacuerdo_46, t0.centropreparador AS centropreparador_47, t0.ispublic AS ispublic_48, t0.mostrarenmapa AS mostrarenmapa_49, t0.codigoacademia AS codigoacademia_50, t0.emailcoe AS emailcoe_51, t0.passopen AS passopen_52, t0.accesoinicial AS accesoinicial_53, t0.contraseniaaleatoria AS contraseniaaleatoria_54, t0.descuento AS descuento_55, t0.tituloposicionamiento AS tituloposicionamiento_56, t0.textoposicionamiento AS textoposicionamiento_57, t0.ordenadores AS ordenadores_58, t0.slug AS slug_59, t0.sluglinguaskill AS sluglinguaskill_60, t0.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_61, t0.seleccionhorario AS seleccionhorario_62, t0.informacion AS informacion_63, t0.codecenter AS codecenter_64, t0.isinstitucion AS isinstitucion_65, t0.tipoenlace AS tipoenlace_66, t0.conversiondinero AS conversiondinero_67, t0.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_68, t0.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_69, t0.puedematricularotroscentros AS puedematricularotroscentros_70, t0.cuentacontable AS cuentacontable_71, t0.razonsocial AS razonsocial_72, t0.direccionfacturacion AS direccionfacturacion_73, t0.cpfacturacion AS cpfacturacion_74, t0.poblacionfacturacion AS poblacionfacturacion_75, t0.provinciafacturacion AS provinciafacturacion_76, t0.paisfacturacion AS paisfacturacion_77, t0.convocatorias_slug AS convocatorias_slug_78, t0.puede_solicitar_facturas AS puede_solicitar_facturas_79, t0.datos_rellenos AS datos_rellenos_80, t0.pagalateentry1 AS pagalateentry1_81, t0.pagalateentry2 AS pagalateentry2_82, t0.pagalateentry3 AS pagalateentry3_83, t0.saltardni AS saltardni_84, t0.condicionesSlugQualifications AS condicionesSlugQualifications_85, t1.tipos_documento_id AS tipos_documento_id_86, t1.idtipousuario_id AS idtipousuario_id_87, t1.idpoblacion_id AS idpoblacion_id_88, t1.idprovincia_id AS idprovincia_id_89, t0.tipovenue_id AS tipovenue_id_90, t0.poblacion_info_id AS poblacion_info_id_91, t1.tipo FROM academias t0 INNER JOIN usuarios t1 ON t0.id = t1.id WHERE t0.ispublic = 1 AND t1.eliminadologico = 0 AND t0.premium = 1 ORDER BY t0.orden ASC, t1.nombre ASC;

SELECT
  p0_.id AS id_0,
  p0_.codineprovincia AS codineprovincia_1,
  p0_.nombre AS nombre_2,
  p0_.creacionusuario AS creacionusuario_3,
  p0_.creacionfecha AS creacionfecha_4,
  p0_.modificacionusuario AS modificacionusuario_5,
  p0_.modificacionfecha AS modificacionfecha_6
FROM
  provincias p0_
  INNER JOIN (
    academias a1_
    INNER JOIN usuarios u2_ ON a1_.id = u2_.id
  ) ON (u2_.idprovincia_id = p0_.id)
WHERE
  a1_.premium = ?
GROUP BY
  p0_.id
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.codineprovincia AS codineprovincia_1, p0_.nombre AS nombre_2, p0_.creacionusuario AS creacionusuario_3, p0_.creacionfecha AS creacionfecha_4, p0_.modificacionusuario AS modificacionusuario_5, p0_.modificacionfecha AS modificacionfecha_6 FROM provincias p0_ INNER JOIN (academias a1_ INNER JOIN usuarios u2_ ON a1_.id = u2_.id) ON (u2_.idprovincia_id = p0_.id) WHERE a1_.premium = 1 GROUP BY p0_.id ORDER BY p0_.nombre ASC;