Query Metrics
3
Database Queries
3
Different statements
0.77 ms
Query time
0
Invalid entities
2
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.36 ms (46.48%) |
1 |
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 = ?
Parameters:
[
1
]
|
|
0.26 ms (33.56%) |
1 |
SELECT t0.id AS id_1, t0.orden AS orden_2, t0.ordenrelacionados AS ordenrelacionados_3, t0.tipo AS tipo_4, t0.ventaconcertificacion AS ventaconcertificacion_5, t0.tipoventa AS tipoventa_6, t0.stock AS stock_7, t0.nombre AS nombre_8, t0.descripcion AS descripcion_9, t0.descripcioncorta AS descripcioncorta_10, t0.deleteAt AS deleteAt_11, t0.createAt AS createAt_12, t0.preciosiniva AS preciosiniva_13, t0.iva AS iva_14, t0.precio AS precio_15, t0.preciosiniva_marketplace AS preciosiniva_marketplace_16, t0.iva_marketplace AS iva_marketplace_17, t0.precio_marketplace AS precio_marketplace_18, t0.path AS path_19, t0.slug AS slug_20, t0.disponible AS disponible_21, t0.textodisponibilidad AS textodisponibilidad_22, t0.contadorclick AS contadorclick_23, t0.activo AS activo_24, t0.solocentros AS solocentros_25, t0.emailnotificacion AS emailnotificacion_26, t0.tipoBased AS tipoBased_27, t0.producto_nominativo AS producto_nominativo_28, t0.ofrecer_descuento_resumen AS ofrecer_descuento_resumen_29, t0.solicitar_certificacion AS solicitar_certificacion_30, t0.solicitar_modulo_lingua AS solicitar_modulo_lingua_31, t0.texto_nominativo AS texto_nominativo_32, t0.producto_sin_precio AS producto_sin_precio_33, t0.usuario_id AS usuario_id_34 FROM producto t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
|
0.15 ms (19.96%) |
1 |
SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.descripcion AS descripcion_4, t0.tipo AS tipo_5 FROM texto_publico t0 WHERE t0.tipo = ? LIMIT 1
Parameters:
[
1
]
|
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\producto | 1 |
| App\Entity\usuarios | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\producto | No errors. |
| App\Entity\usuarios | No errors. |
| App\Entity\academias | No errors. |
| App\Entity\alumnos | No errors. |
| App\Entity\personalexterno | 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\tiposnecesidadespecial | No errors. |
| App\Entity\tiposnivelexterno | No errors. |
| App\Entity\ocupacionexternos | No errors. |
| App\Entity\convocatoriaalumno | No errors. |
| App\Entity\cambiodatos | No errors. |
| App\Entity\salareserva | No errors. |
| App\Entity\tiposcertificacion | No errors. |
| App\Entity\tipomodulo | No errors. |
| App\Entity\TextoPublico | No errors. |