Query Metrics
24
Database Queries
3
Different statements
4.94 ms
Query time
0
Invalid entities
1185
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.11 ms (63.04%) |
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 = ?
Parameters:
[
8
]
|
|
1.70 ms (34.47%) |
1 |
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
Parameters:
[] |
|
0.12 ms (2.49%) |
1 |
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
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\usuarios | 965 |
| App\Entity\poblaciones | 196 |
| App\Entity\provincias | 22 |
| App\Entity\tipos_documento | 1 |
| App\Entity\tiposusuario | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\usuarios | No errors. |
| App\Entity\academias | No errors. |
| App\Entity\tipos_documento | No errors. |
| App\Entity\tiposusuario | No errors. |
| App\Entity\poblaciones | No errors. |
| App\Entity\provincias | No errors. |
| App\Entity\venues | No errors. |
| App\Entity\provinciascodigo | No errors. |
| App\Entity\convocatoriaalumno | No errors. |
| App\Entity\cambiodatos | No errors. |
| App\Entity\salareserva | No errors. |
| App\Entity\alumnos | No errors. |
| App\Entity\convocatorias | No errors. |
| App\Entity\porcentaje | No errors. |
| App\Entity\bolsalicencia | No errors. |