| 1 |
0.40 ms |
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 = ?
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;
|
| 2 |
0.77 ms |
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 = ?
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;
|
| 3 |
0.28 ms |
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;
|
| 4 |
0.45 ms |
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 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;
|
| 5 |
0.30 ms |
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 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;
|
| 6 |
0.28 ms |
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_ 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_ ORDER BY p0_.nombre ASC;
|
| 7 |
0.25 ms |
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 = ? AND a1_.isinstitucion = ? ORDER BY u2_.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 AND a1_.isinstitucion = 1 ORDER BY u2_.nombre ASC;
|
| 8 |
0.28 ms |
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;
|