Symfony Profiler

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
  u0_.idprovincia_id IS NOT NULL
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 u0_.idprovincia_id IS NOT NULL ORDER BY u0_.nombre ASC;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 17;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 12;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 10;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 16;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.codineprovincia AS codineprovincia_2,
  t0.nombre AS nombre_3,
  t0.creacionusuario AS creacionusuario_4,
  t0.creacionfecha AS creacionfecha_5,
  t0.modificacionusuario AS modificacionusuario_6,
  t0.modificacionfecha AS modificacionfecha_7
FROM
  provincias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.codineprovincia AS codineprovincia_2, t0.nombre AS nombre_3, t0.creacionusuario AS creacionusuario_4, t0.creacionfecha AS creacionfecha_5, t0.modificacionusuario AS modificacionusuario_6, t0.modificacionfecha AS modificacionfecha_7 FROM provincias t0 WHERE t0.id = 18;

SELECT
  c0_.poblacion AS poblacion_0
FROM
  convocatorias c0_
WHERE
  c0_.poblacion IS NOT NULL
  AND c0_.eliminado = 0
  AND c0_.examdate >= '2025-12-06 00:00:00'
GROUP BY
  c0_.poblacion
ORDER BY
  c0_.poblacion ASC

SELECT c0_.poblacion AS poblacion_0 FROM convocatorias c0_ WHERE c0_.poblacion IS NOT NULL AND c0_.eliminado = 0 AND c0_.examdate >= '2025-12-06 00:00:00' GROUP BY c0_.poblacion ORDER BY c0_.poblacion ASC;

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 = 0;