GET https://www.app.examsandalucia.com/

Query Metrics

3 Database Queries
3 Different statements
1.38 ms Query time
2 Invalid entities
1018 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.86 ms
(62.57%)
1
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.activo = ? ORDER BY t1.nombre ASC
Parameters:
[
  1
  1
]
0.26 ms
(19.00%)
1
SELECT t0.id AS id_1, t0.fechacreacion AS fechacreacion_2, t0.titulo AS titulo_3, t0.titulosinespacios AS titulosinespacios_4, t0.descripcion AS descripcion_5, t0.numerolecturas AS numerolecturas_6, t0.mostrar AS mostrar_7, t0.contenidoblog AS contenidoblog_8, t0.imagendestacada AS imagendestacada_9, t0.wdestacada AS wdestacada_10, t0.hdestacada AS hdestacada_11, t0.imageninterior AS imageninterior_12, t0.autor AS autor_13, t0.categoria_id AS categoria_id_14 FROM blog t0 WHERE t0.mostrar = ? ORDER BY t0.fechacreacion DESC LIMIT 3
Parameters:
[
  1
]
0.25 ms
(18.43%)
1
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.creacionusuario AS creacionusuario_4, t0.path AS path_5, t0.url AS url_6, t0.creacionfecha AS creacionfecha_7, t0.colorletra AS colorletra_8, t0.nuevapestana AS nuevapestana_9, t0.posicion AS posicion_10, t0.posicionvertical AS posicionvertical_11, t0.orden AS orden_12 FROM slider t0
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 808
App\Entity\poblaciones 185
App\Entity\provincias 21
App\Entity\slider 2
App\Entity\tipos_documento 1
App\Entity\tiposusuario 1

Entities Mapping

Class Mapping errors
App\Entity\blog
  • The field App\Entity\blog#palabras is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\palabrasclave#blog does not contain the required 'inversedBy: "palabras"' attribute.
  • The field App\Entity\blog#comentarios is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\comentarios#blog does not contain the required 'inversedBy: "comentarios"' attribute.
App\Entity\categoriasblog
  • The field App\Entity\categoriasblog#blogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\blog#categoria does not contain the required 'inversedBy: "blogs"' attribute.
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.
App\Entity\slider No errors.