| 1 |
0.76 ms |
SELECT t0.id AS id_1, t0.eliminado AS eliminado_2, t0.codigoexam AS codigoexam_3, t0.aliasprivada AS aliasprivada_4, t0.indcbpb AS indcbpb_5, t0.indpublicada AS indpublicada_6, t0.incidencia AS incidencia_7, t0.fechapublicacion AS fechapublicacion_8, t0.indcerradaabierta AS indcerradaabierta_9, t0.observacion AS observacion_10, t0.indacademia AS indacademia_11, t0.numplazasmaximo AS numplazasmaximo_12, t0.examdate AS examdate_13, t0.fechacierreiml AS fechacierreiml_14, t0.venuedetailsdate AS venuedetailsdate_15, t0.speakingwindowstart AS speakingwindowstart_16, t0.speakingwindowstart2 AS speakingwindowstart2_17, t0.speakingwindowend AS speakingwindowend_18, t0.resultreleasestart AS resultreleasestart_19, t0.resultreleaseend AS resultreleaseend_20, t0.certificatedispatch AS certificatedispatch_21, t0.color AS color_22, t0.logo AS logo_23, t0.creacionfecha AS creacionfecha_24, t0.modificacionfecha AS modificacionfecha_25, t0.serializado AS serializado_26, t0.numsupervisores AS numsupervisores_27, t0.numvigilantes AS numvigilantes_28, t0.fechaultimoavisoexternos AS fechaultimoavisoexternos_29, t0.numhorasprevistas AS numhorasprevistas_30, t0.entryclosingdate AS entryclosingdate_31, t0.precio AS precio_32, t0.poblacion AS poblacion_33, t0.visto AS visto_34, t0.matriculadosespeciales AS matriculadosespeciales_35, t0.maximosCandidatos AS maximosCandidatos_36, t0.lateEntry1Importe AS lateEntry1Importe_37, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_38, t0.lateEntry1Fecha AS lateEntry1Fecha_39, t0.lateEntry1Permitido AS lateEntry1Permitido_40, t0.lateEntry2Importe AS lateEntry2Importe_41, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_42, t0.lateEntry2Fecha AS lateEntry2Fecha_43, t0.lateEntry2Permitido AS lateEntry2Permitido_44, t0.lateEntry3Importe AS lateEntry3Importe_45, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_46, t0.lateEntry3Fecha AS lateEntry3Fecha_47, t0.lateEntry3Permitido AS lateEntry3Permitido_48, t0.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_49, t0.tramo0 AS tramo0_50, t0.tramo1 AS tramo1_51, t0.tramo2 AS tramo2_52, t0.tramo3 AS tramo3_53, t0.infoExtra AS infoExtra_54, t0.extraImporte AS extraImporte_55, t0.aclaracionExamen AS aclaracionExamen_56, t0.idtipocertificacion_id AS idtipocertificacion_id_57, t0.creacionusuario_id AS creacionusuario_id_58, t0.modificacionusuario_id AS modificacionusuario_id_59, t0.convocatoriapoblacion_id AS convocatoriapoblacion_id_60, t0.vistopor_id AS vistopor_id_61 FROM convocatorias t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.eliminado AS eliminado_2,
t0.codigoexam AS codigoexam_3,
t0.aliasprivada AS aliasprivada_4,
t0.indcbpb AS indcbpb_5,
t0.indpublicada AS indpublicada_6,
t0.incidencia AS incidencia_7,
t0.fechapublicacion AS fechapublicacion_8,
t0.indcerradaabierta AS indcerradaabierta_9,
t0.observacion AS observacion_10,
t0.indacademia AS indacademia_11,
t0.numplazasmaximo AS numplazasmaximo_12,
t0.examdate AS examdate_13,
t0.fechacierreiml AS fechacierreiml_14,
t0.venuedetailsdate AS venuedetailsdate_15,
t0.speakingwindowstart AS speakingwindowstart_16,
t0.speakingwindowstart2 AS speakingwindowstart2_17,
t0.speakingwindowend AS speakingwindowend_18,
t0.resultreleasestart AS resultreleasestart_19,
t0.resultreleaseend AS resultreleaseend_20,
t0.certificatedispatch AS certificatedispatch_21,
t0.color AS color_22,
t0.logo AS logo_23,
t0.creacionfecha AS creacionfecha_24,
t0.modificacionfecha AS modificacionfecha_25,
t0.serializado AS serializado_26,
t0.numsupervisores AS numsupervisores_27,
t0.numvigilantes AS numvigilantes_28,
t0.fechaultimoavisoexternos AS fechaultimoavisoexternos_29,
t0.numhorasprevistas AS numhorasprevistas_30,
t0.entryclosingdate AS entryclosingdate_31,
t0.precio AS precio_32,
t0.poblacion AS poblacion_33,
t0.visto AS visto_34,
t0.matriculadosespeciales AS matriculadosespeciales_35,
t0.maximosCandidatos AS maximosCandidatos_36,
t0.lateEntry1Importe AS lateEntry1Importe_37,
t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_38,
t0.lateEntry1Fecha AS lateEntry1Fecha_39,
t0.lateEntry1Permitido AS lateEntry1Permitido_40,
t0.lateEntry2Importe AS lateEntry2Importe_41,
t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_42,
t0.lateEntry2Fecha AS lateEntry2Fecha_43,
t0.lateEntry2Permitido AS lateEntry2Permitido_44,
t0.lateEntry3Importe AS lateEntry3Importe_45,
t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_46,
t0.lateEntry3Fecha AS lateEntry3Fecha_47,
t0.lateEntry3Permitido AS lateEntry3Permitido_48,
t0.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_49,
t0.tramo0 AS tramo0_50,
t0.tramo1 AS tramo1_51,
t0.tramo2 AS tramo2_52,
t0.tramo3 AS tramo3_53,
t0.infoExtra AS infoExtra_54,
t0.extraImporte AS extraImporte_55,
t0.aclaracionExamen AS aclaracionExamen_56,
t0.idtipocertificacion_id AS idtipocertificacion_id_57,
t0.creacionusuario_id AS creacionusuario_id_58,
t0.modificacionusuario_id AS modificacionusuario_id_59,
t0.convocatoriapoblacion_id AS convocatoriapoblacion_id_60,
t0.vistopor_id AS vistopor_id_61
FROM
convocatorias t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.eliminado AS eliminado_2, t0.codigoexam AS codigoexam_3, t0.aliasprivada AS aliasprivada_4, t0.indcbpb AS indcbpb_5, t0.indpublicada AS indpublicada_6, t0.incidencia AS incidencia_7, t0.fechapublicacion AS fechapublicacion_8, t0.indcerradaabierta AS indcerradaabierta_9, t0.observacion AS observacion_10, t0.indacademia AS indacademia_11, t0.numplazasmaximo AS numplazasmaximo_12, t0.examdate AS examdate_13, t0.fechacierreiml AS fechacierreiml_14, t0.venuedetailsdate AS venuedetailsdate_15, t0.speakingwindowstart AS speakingwindowstart_16, t0.speakingwindowstart2 AS speakingwindowstart2_17, t0.speakingwindowend AS speakingwindowend_18, t0.resultreleasestart AS resultreleasestart_19, t0.resultreleaseend AS resultreleaseend_20, t0.certificatedispatch AS certificatedispatch_21, t0.color AS color_22, t0.logo AS logo_23, t0.creacionfecha AS creacionfecha_24, t0.modificacionfecha AS modificacionfecha_25, t0.serializado AS serializado_26, t0.numsupervisores AS numsupervisores_27, t0.numvigilantes AS numvigilantes_28, t0.fechaultimoavisoexternos AS fechaultimoavisoexternos_29, t0.numhorasprevistas AS numhorasprevistas_30, t0.entryclosingdate AS entryclosingdate_31, t0.precio AS precio_32, t0.poblacion AS poblacion_33, t0.visto AS visto_34, t0.matriculadosespeciales AS matriculadosespeciales_35, t0.maximosCandidatos AS maximosCandidatos_36, t0.lateEntry1Importe AS lateEntry1Importe_37, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_38, t0.lateEntry1Fecha AS lateEntry1Fecha_39, t0.lateEntry1Permitido AS lateEntry1Permitido_40, t0.lateEntry2Importe AS lateEntry2Importe_41, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_42, t0.lateEntry2Fecha AS lateEntry2Fecha_43, t0.lateEntry2Permitido AS lateEntry2Permitido_44, t0.lateEntry3Importe AS lateEntry3Importe_45, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_46, t0.lateEntry3Fecha AS lateEntry3Fecha_47, t0.lateEntry3Permitido AS lateEntry3Permitido_48, t0.necesidadesEspecialesFecha AS necesidadesEspecialesFecha_49, t0.tramo0 AS tramo0_50, t0.tramo1 AS tramo1_51, t0.tramo2 AS tramo2_52, t0.tramo3 AS tramo3_53, t0.infoExtra AS infoExtra_54, t0.extraImporte AS extraImporte_55, t0.aclaracionExamen AS aclaracionExamen_56, t0.idtipocertificacion_id AS idtipocertificacion_id_57, t0.creacionusuario_id AS creacionusuario_id_58, t0.modificacionusuario_id AS modificacionusuario_id_59, t0.convocatoriapoblacion_id AS convocatoriapoblacion_id_60, t0.vistopor_id AS vistopor_id_61 FROM convocatorias t0 WHERE t0.id = '21429';
|
| 2 |
1.75 ms |
SELECT t0.id AS id_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.nif_cif AS nif_cif_8, t0.usuario AS usuario_9, t0.email AS email_10, t0.password AS password_11, t0.salt AS salt_12, t0.activo AS activo_13, t0.role AS role_14, t0.permisocambridge AS permisocambridge_15, t0.permisopagos AS permisopagos_16, t0.permisomatriculacion AS permisomatriculacion_17, t0.creacionusuario AS creacionusuario_18, t0.creacionfecha AS creacionfecha_19, t0.modificacionusuario AS modificacionusuario_20, t0.modificacionfecha AS modificacionfecha_21, t0.permisoacademia AS permisoacademia_22, t0.codigorecuperacion AS codigorecuperacion_23, t0.direccion AS direccion_24, t0.cp AS cp_25, t0.telefono1 AS telefono1_26, t0.telefono2 AS telefono2_27, t0.eliminadologico AS eliminadologico_28, t0.tipos_documento_id AS tipos_documento_id_29, t0.idtipousuario_id AS idtipousuario_id_30, t0.idpoblacion_id AS idpoblacion_id_31, t0.idprovincia_id AS idprovincia_id_32, t0.tipo, t1.latitud AS latitud_33, t1.longitud AS longitud_34, t1.personacontacto AS personacontacto_35, t1.pathacademia AS pathacademia_36, t1.numerosubidasimagen AS numerosubidasimagen_37, t1.orden AS orden_38, t1.indverificado AS indverificado_39, t1.hastaultimodia AS hastaultimodia_40, t1.indadmitecerradas AS indadmitecerradas_41, t1.estadovisual AS estadovisual_42, t1.centrenumber AS centrenumber_43, t1.observaciones AS observaciones_44, t1.web AS web_45, t1.directorcentro AS directorcentro_46, t1.premium AS premium_47, t1.beneficiospremium AS beneficiospremium_48, t1.sendemail AS sendemail_49, t1.showedescription AS showedescription_50, t1.canjeoespecial AS canjeoespecial_51, t1.tipoacuerdo AS tipoacuerdo_52, t1.centropreparador AS centropreparador_53, t1.ispublic AS ispublic_54, t1.mostrarenmapa AS mostrarenmapa_55, t1.codigoacademia AS codigoacademia_56, t1.emailcoe AS emailcoe_57, t1.passopen AS passopen_58, t1.accesoinicial AS accesoinicial_59, t1.contraseniaaleatoria AS contraseniaaleatoria_60, t1.descuento AS descuento_61, t1.tituloposicionamiento AS tituloposicionamiento_62, t1.textoposicionamiento AS textoposicionamiento_63, t1.ordenadores AS ordenadores_64, t1.slug AS slug_65, t1.sluglinguaskill AS sluglinguaskill_66, t1.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_67, t1.seleccionhorario AS seleccionhorario_68, t1.informacion AS informacion_69, t1.codecenter AS codecenter_70, t1.isinstitucion AS isinstitucion_71, t1.tipoenlace AS tipoenlace_72, t1.conversiondinero AS conversiondinero_73, t1.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_74, t1.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_75, t1.puedematricularotroscentros AS puedematricularotroscentros_76, t1.cuentacontable AS cuentacontable_77, t1.razonsocial AS razonsocial_78, t1.direccionfacturacion AS direccionfacturacion_79, t1.cpfacturacion AS cpfacturacion_80, t1.poblacionfacturacion AS poblacionfacturacion_81, t1.provinciafacturacion AS provinciafacturacion_82, t1.paisfacturacion AS paisfacturacion_83, t1.convocatorias_slug AS convocatorias_slug_84, t1.puede_solicitar_facturas AS puede_solicitar_facturas_85, t1.datos_rellenos AS datos_rellenos_86, t1.pagalateentry1 AS pagalateentry1_87, t1.pagalateentry2 AS pagalateentry2_88, t1.pagalateentry3 AS pagalateentry3_89, t1.saltardni AS saltardni_90, t1.condicionesSlugQualifications AS condicionesSlugQualifications_91, t1.tipovenue_id AS tipovenue_id_92, t1.poblacion_info_id AS poblacion_info_id_93, t2.fechanacimiento AS fechanacimiento_94, t2.genero AS genero_95, t2.codigopostal AS codigopostal_96, t2.numerocandidato AS numerocandidato_97, t2.documentacionespecial AS documentacionespecial_98, t2.telefonocontacto AS telefonocontacto_99, t2.alumnopropio AS alumnopropio_100, t2.dni AS dni_101, t2.comunicaciones AS comunicaciones_102, t2.md5registro AS md5registro_103, t2.idtipoespecial_id AS idtipoespecial_id_104, t2.codigoacademia_id AS codigoacademia_id_105, t3.centrotrabajo AS centrotrabajo_106, t3.coche AS coche_107, t3.cuentaBanco AS cuentaBanco_108, t3.examLevel AS examLevel_109, t3.fechanacimiento AS fechanacimiento_110, t3.idtiponivelexterno_id AS idtiponivelexterno_id_111, t3.idocupacionexternos_id AS idocupacionexternos_id_112 FROM usuarios t0 LEFT JOIN academias t1 ON t0.id = t1.id LEFT JOIN alumnos t2 ON t0.id = t2.id LEFT JOIN personalexterno t3 ON t0.id = t3.id WHERE t0.id = ?
SELECT
t0.id AS id_4,
t0.nombre AS nombre_5,
t0.apellido1 AS apellido1_6,
t0.apellido2 AS apellido2_7,
t0.nif_cif AS nif_cif_8,
t0.usuario AS usuario_9,
t0.email AS email_10,
t0.password AS password_11,
t0.salt AS salt_12,
t0.activo AS activo_13,
t0.role AS role_14,
t0.permisocambridge AS permisocambridge_15,
t0.permisopagos AS permisopagos_16,
t0.permisomatriculacion AS permisomatriculacion_17,
t0.creacionusuario AS creacionusuario_18,
t0.creacionfecha AS creacionfecha_19,
t0.modificacionusuario AS modificacionusuario_20,
t0.modificacionfecha AS modificacionfecha_21,
t0.permisoacademia AS permisoacademia_22,
t0.codigorecuperacion AS codigorecuperacion_23,
t0.direccion AS direccion_24,
t0.cp AS cp_25,
t0.telefono1 AS telefono1_26,
t0.telefono2 AS telefono2_27,
t0.eliminadologico AS eliminadologico_28,
t0.tipos_documento_id AS tipos_documento_id_29,
t0.idtipousuario_id AS idtipousuario_id_30,
t0.idpoblacion_id AS idpoblacion_id_31,
t0.idprovincia_id AS idprovincia_id_32,
t0.tipo,
t1.latitud AS latitud_33,
t1.longitud AS longitud_34,
t1.personacontacto AS personacontacto_35,
t1.pathacademia AS pathacademia_36,
t1.numerosubidasimagen AS numerosubidasimagen_37,
t1.orden AS orden_38,
t1.indverificado AS indverificado_39,
t1.hastaultimodia AS hastaultimodia_40,
t1.indadmitecerradas AS indadmitecerradas_41,
t1.estadovisual AS estadovisual_42,
t1.centrenumber AS centrenumber_43,
t1.observaciones AS observaciones_44,
t1.web AS web_45,
t1.directorcentro AS directorcentro_46,
t1.premium AS premium_47,
t1.beneficiospremium AS beneficiospremium_48,
t1.sendemail AS sendemail_49,
t1.showedescription AS showedescription_50,
t1.canjeoespecial AS canjeoespecial_51,
t1.tipoacuerdo AS tipoacuerdo_52,
t1.centropreparador AS centropreparador_53,
t1.ispublic AS ispublic_54,
t1.mostrarenmapa AS mostrarenmapa_55,
t1.codigoacademia AS codigoacademia_56,
t1.emailcoe AS emailcoe_57,
t1.passopen AS passopen_58,
t1.accesoinicial AS accesoinicial_59,
t1.contraseniaaleatoria AS contraseniaaleatoria_60,
t1.descuento AS descuento_61,
t1.tituloposicionamiento AS tituloposicionamiento_62,
t1.textoposicionamiento AS textoposicionamiento_63,
t1.ordenadores AS ordenadores_64,
t1.slug AS slug_65,
t1.sluglinguaskill AS sluglinguaskill_66,
t1.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_67,
t1.seleccionhorario AS seleccionhorario_68,
t1.informacion AS informacion_69,
t1.codecenter AS codecenter_70,
t1.isinstitucion AS isinstitucion_71,
t1.tipoenlace AS tipoenlace_72,
t1.conversiondinero AS conversiondinero_73,
t1.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_74,
t1.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_75,
t1.puedematricularotroscentros AS puedematricularotroscentros_76,
t1.cuentacontable AS cuentacontable_77,
t1.razonsocial AS razonsocial_78,
t1.direccionfacturacion AS direccionfacturacion_79,
t1.cpfacturacion AS cpfacturacion_80,
t1.poblacionfacturacion AS poblacionfacturacion_81,
t1.provinciafacturacion AS provinciafacturacion_82,
t1.paisfacturacion AS paisfacturacion_83,
t1.convocatorias_slug AS convocatorias_slug_84,
t1.puede_solicitar_facturas AS puede_solicitar_facturas_85,
t1.datos_rellenos AS datos_rellenos_86,
t1.pagalateentry1 AS pagalateentry1_87,
t1.pagalateentry2 AS pagalateentry2_88,
t1.pagalateentry3 AS pagalateentry3_89,
t1.saltardni AS saltardni_90,
t1.condicionesSlugQualifications AS condicionesSlugQualifications_91,
t1.tipovenue_id AS tipovenue_id_92,
t1.poblacion_info_id AS poblacion_info_id_93,
t2.fechanacimiento AS fechanacimiento_94,
t2.genero AS genero_95,
t2.codigopostal AS codigopostal_96,
t2.numerocandidato AS numerocandidato_97,
t2.documentacionespecial AS documentacionespecial_98,
t2.telefonocontacto AS telefonocontacto_99,
t2.alumnopropio AS alumnopropio_100,
t2.dni AS dni_101,
t2.comunicaciones AS comunicaciones_102,
t2.md5registro AS md5registro_103,
t2.idtipoespecial_id AS idtipoespecial_id_104,
t2.codigoacademia_id AS codigoacademia_id_105,
t3.centrotrabajo AS centrotrabajo_106,
t3.coche AS coche_107,
t3.cuentaBanco AS cuentaBanco_108,
t3.examLevel AS examLevel_109,
t3.fechanacimiento AS fechanacimiento_110,
t3.idtiponivelexterno_id AS idtiponivelexterno_id_111,
t3.idocupacionexternos_id AS idocupacionexternos_id_112
FROM
usuarios t0
LEFT JOIN academias t1 ON t0.id = t1.id
LEFT JOIN alumnos t2 ON t0.id = t2.id
LEFT JOIN personalexterno t3 ON t0.id = t3.id
WHERE
t0.id = ?
SELECT t0.id AS id_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.nif_cif AS nif_cif_8, t0.usuario AS usuario_9, t0.email AS email_10, t0.password AS password_11, t0.salt AS salt_12, t0.activo AS activo_13, t0.role AS role_14, t0.permisocambridge AS permisocambridge_15, t0.permisopagos AS permisopagos_16, t0.permisomatriculacion AS permisomatriculacion_17, t0.creacionusuario AS creacionusuario_18, t0.creacionfecha AS creacionfecha_19, t0.modificacionusuario AS modificacionusuario_20, t0.modificacionfecha AS modificacionfecha_21, t0.permisoacademia AS permisoacademia_22, t0.codigorecuperacion AS codigorecuperacion_23, t0.direccion AS direccion_24, t0.cp AS cp_25, t0.telefono1 AS telefono1_26, t0.telefono2 AS telefono2_27, t0.eliminadologico AS eliminadologico_28, t0.tipos_documento_id AS tipos_documento_id_29, t0.idtipousuario_id AS idtipousuario_id_30, t0.idpoblacion_id AS idpoblacion_id_31, t0.idprovincia_id AS idprovincia_id_32, t0.tipo, t1.latitud AS latitud_33, t1.longitud AS longitud_34, t1.personacontacto AS personacontacto_35, t1.pathacademia AS pathacademia_36, t1.numerosubidasimagen AS numerosubidasimagen_37, t1.orden AS orden_38, t1.indverificado AS indverificado_39, t1.hastaultimodia AS hastaultimodia_40, t1.indadmitecerradas AS indadmitecerradas_41, t1.estadovisual AS estadovisual_42, t1.centrenumber AS centrenumber_43, t1.observaciones AS observaciones_44, t1.web AS web_45, t1.directorcentro AS directorcentro_46, t1.premium AS premium_47, t1.beneficiospremium AS beneficiospremium_48, t1.sendemail AS sendemail_49, t1.showedescription AS showedescription_50, t1.canjeoespecial AS canjeoespecial_51, t1.tipoacuerdo AS tipoacuerdo_52, t1.centropreparador AS centropreparador_53, t1.ispublic AS ispublic_54, t1.mostrarenmapa AS mostrarenmapa_55, t1.codigoacademia AS codigoacademia_56, t1.emailcoe AS emailcoe_57, t1.passopen AS passopen_58, t1.accesoinicial AS accesoinicial_59, t1.contraseniaaleatoria AS contraseniaaleatoria_60, t1.descuento AS descuento_61, t1.tituloposicionamiento AS tituloposicionamiento_62, t1.textoposicionamiento AS textoposicionamiento_63, t1.ordenadores AS ordenadores_64, t1.slug AS slug_65, t1.sluglinguaskill AS sluglinguaskill_66, t1.sluglinguaskillgratuitas AS sluglinguaskillgratuitas_67, t1.seleccionhorario AS seleccionhorario_68, t1.informacion AS informacion_69, t1.codecenter AS codecenter_70, t1.isinstitucion AS isinstitucion_71, t1.tipoenlace AS tipoenlace_72, t1.conversiondinero AS conversiondinero_73, t1.mostrarconvocatoriasprivadas AS mostrarconvocatoriasprivadas_74, t1.mostrarsolomisconvocatorias AS mostrarsolomisconvocatorias_75, t1.puedematricularotroscentros AS puedematricularotroscentros_76, t1.cuentacontable AS cuentacontable_77, t1.razonsocial AS razonsocial_78, t1.direccionfacturacion AS direccionfacturacion_79, t1.cpfacturacion AS cpfacturacion_80, t1.poblacionfacturacion AS poblacionfacturacion_81, t1.provinciafacturacion AS provinciafacturacion_82, t1.paisfacturacion AS paisfacturacion_83, t1.convocatorias_slug AS convocatorias_slug_84, t1.puede_solicitar_facturas AS puede_solicitar_facturas_85, t1.datos_rellenos AS datos_rellenos_86, t1.pagalateentry1 AS pagalateentry1_87, t1.pagalateentry2 AS pagalateentry2_88, t1.pagalateentry3 AS pagalateentry3_89, t1.saltardni AS saltardni_90, t1.condicionesSlugQualifications AS condicionesSlugQualifications_91, t1.tipovenue_id AS tipovenue_id_92, t1.poblacion_info_id AS poblacion_info_id_93, t2.fechanacimiento AS fechanacimiento_94, t2.genero AS genero_95, t2.codigopostal AS codigopostal_96, t2.numerocandidato AS numerocandidato_97, t2.documentacionespecial AS documentacionespecial_98, t2.telefonocontacto AS telefonocontacto_99, t2.alumnopropio AS alumnopropio_100, t2.dni AS dni_101, t2.comunicaciones AS comunicaciones_102, t2.md5registro AS md5registro_103, t2.idtipoespecial_id AS idtipoespecial_id_104, t2.codigoacademia_id AS codigoacademia_id_105, t3.centrotrabajo AS centrotrabajo_106, t3.coche AS coche_107, t3.cuentaBanco AS cuentaBanco_108, t3.examLevel AS examLevel_109, t3.fechanacimiento AS fechanacimiento_110, t3.idtiponivelexterno_id AS idtiponivelexterno_id_111, t3.idocupacionexternos_id AS idocupacionexternos_id_112 FROM usuarios t0 LEFT JOIN academias t1 ON t0.id = t1.id LEFT JOIN alumnos t2 ON t0.id = t2.id LEFT JOIN personalexterno t3 ON t0.id = t3.id WHERE t0.id = 5800;
|
| 3 |
2.61 ms |
SELECT t0.id AS id_1, t0.abreviatura AS abreviatura_2, t0.descripcion AS descripcion_3, t0.idmaterial AS idmaterial_4, t0.cambridgefee AS cambridgefee_5, t0.speakingwindow AS speakingwindow_6, t0.maxslots AS maxslots_7, t0.preciocambridge AS preciocambridge_8, t0.preciocolegio AS preciocolegio_9, t0.preciofomento AS preciofomento_10, t0.preciouco AS preciouco_11, t0.preciouja AS preciouja_12, t0.precioual AS precioual_13, t0.preciocsanfrancisco AS preciocsanfrancisco_14, t0.preciougibraltar AS preciougibraltar_15, t0.preciogranadacollege AS preciogranadacollege_16, t0.precioceuta AS precioceuta_17, t0.creacionfecha AS creacionfecha_18, t0.modificacionfecha AS modificacionfecha_19, t0.logo AS logo_20, t0.duracionprevista AS duracionprevista_21, t0.nombre AS nombre_22, t0.descripcionpublica AS descripcionpublica_23, t0.color AS color_24, t0.candidatenumberstart AS candidatenumberstart_25, t0.duracionreading AS duracionreading_26, t0.duracionwriting AS duracionwriting_27, t0.duracionlistening AS duracionlistening_28, t0.duracionspeaking AS duracionspeaking_29, t0.esspeaking AS esspeaking_30, t0.orden AS orden_31, t0.descripcionexamen AS descripcionexamen_32, t0.slug AS slug_33, t0.lateEntry1Importe AS lateEntry1Importe_34, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_35, t0.lateEntry1Dias AS lateEntry1Dias_36, t0.lateEntry2Importe AS lateEntry2Importe_37, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_38, t0.lateEntry2Dias AS lateEntry2Dias_39, t0.lateEntry3Importe AS lateEntry3Importe_40, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_41, t0.lateEntry3Dias AS lateEntry3Dias_42, t0.dniObligatorio AS dniObligatorio_43, t0.creacionusuario_id AS creacionusuario_id_44, t0.modificacionusuario_id AS modificacionusuario_id_45 FROM tipos_certificacion t0 WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.abreviatura AS abreviatura_2,
t0.descripcion AS descripcion_3,
t0.idmaterial AS idmaterial_4,
t0.cambridgefee AS cambridgefee_5,
t0.speakingwindow AS speakingwindow_6,
t0.maxslots AS maxslots_7,
t0.preciocambridge AS preciocambridge_8,
t0.preciocolegio AS preciocolegio_9,
t0.preciofomento AS preciofomento_10,
t0.preciouco AS preciouco_11,
t0.preciouja AS preciouja_12,
t0.precioual AS precioual_13,
t0.preciocsanfrancisco AS preciocsanfrancisco_14,
t0.preciougibraltar AS preciougibraltar_15,
t0.preciogranadacollege AS preciogranadacollege_16,
t0.precioceuta AS precioceuta_17,
t0.creacionfecha AS creacionfecha_18,
t0.modificacionfecha AS modificacionfecha_19,
t0.logo AS logo_20,
t0.duracionprevista AS duracionprevista_21,
t0.nombre AS nombre_22,
t0.descripcionpublica AS descripcionpublica_23,
t0.color AS color_24,
t0.candidatenumberstart AS candidatenumberstart_25,
t0.duracionreading AS duracionreading_26,
t0.duracionwriting AS duracionwriting_27,
t0.duracionlistening AS duracionlistening_28,
t0.duracionspeaking AS duracionspeaking_29,
t0.esspeaking AS esspeaking_30,
t0.orden AS orden_31,
t0.descripcionexamen AS descripcionexamen_32,
t0.slug AS slug_33,
t0.lateEntry1Importe AS lateEntry1Importe_34,
t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_35,
t0.lateEntry1Dias AS lateEntry1Dias_36,
t0.lateEntry2Importe AS lateEntry2Importe_37,
t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_38,
t0.lateEntry2Dias AS lateEntry2Dias_39,
t0.lateEntry3Importe AS lateEntry3Importe_40,
t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_41,
t0.lateEntry3Dias AS lateEntry3Dias_42,
t0.dniObligatorio AS dniObligatorio_43,
t0.creacionusuario_id AS creacionusuario_id_44,
t0.modificacionusuario_id AS modificacionusuario_id_45
FROM
tipos_certificacion t0
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.abreviatura AS abreviatura_2, t0.descripcion AS descripcion_3, t0.idmaterial AS idmaterial_4, t0.cambridgefee AS cambridgefee_5, t0.speakingwindow AS speakingwindow_6, t0.maxslots AS maxslots_7, t0.preciocambridge AS preciocambridge_8, t0.preciocolegio AS preciocolegio_9, t0.preciofomento AS preciofomento_10, t0.preciouco AS preciouco_11, t0.preciouja AS preciouja_12, t0.precioual AS precioual_13, t0.preciocsanfrancisco AS preciocsanfrancisco_14, t0.preciougibraltar AS preciougibraltar_15, t0.preciogranadacollege AS preciogranadacollege_16, t0.precioceuta AS precioceuta_17, t0.creacionfecha AS creacionfecha_18, t0.modificacionfecha AS modificacionfecha_19, t0.logo AS logo_20, t0.duracionprevista AS duracionprevista_21, t0.nombre AS nombre_22, t0.descripcionpublica AS descripcionpublica_23, t0.color AS color_24, t0.candidatenumberstart AS candidatenumberstart_25, t0.duracionreading AS duracionreading_26, t0.duracionwriting AS duracionwriting_27, t0.duracionlistening AS duracionlistening_28, t0.duracionspeaking AS duracionspeaking_29, t0.esspeaking AS esspeaking_30, t0.orden AS orden_31, t0.descripcionexamen AS descripcionexamen_32, t0.slug AS slug_33, t0.lateEntry1Importe AS lateEntry1Importe_34, t0.lateEntry1MaximosCandidatos AS lateEntry1MaximosCandidatos_35, t0.lateEntry1Dias AS lateEntry1Dias_36, t0.lateEntry2Importe AS lateEntry2Importe_37, t0.lateEntry2MaximosCandidatos AS lateEntry2MaximosCandidatos_38, t0.lateEntry2Dias AS lateEntry2Dias_39, t0.lateEntry3Importe AS lateEntry3Importe_40, t0.lateEntry3MaximosCandidatos AS lateEntry3MaximosCandidatos_41, t0.lateEntry3Dias AS lateEntry3Dias_42, t0.dniObligatorio AS dniObligatorio_43, t0.creacionusuario_id AS creacionusuario_id_44, t0.modificacionusuario_id AS modificacionusuario_id_45 FROM tipos_certificacion t0 WHERE t0.id = 3;
|