Query Metrics
3
Database Queries
3
Different statements
2.14 ms
Query time
2
Invalid entities
1018
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.35 ms |
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
]
|
| 2 | 1.50 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.activo = ? ORDER BY t1.nombre ASC
Parameters:
[ 1 1 ] |
| 3 | 0.29 ms |
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 |
|
| App\Entity\categoriasblog |
|
| 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. |