Query Metrics
4
Database Queries
4
Different statements
45.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.64 ms |
SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.codigo AS codigo_4, t0.nombre AS nombre_5, t0.apellido1 AS apellido1_6, t0.apellido2 AS apellido2_7, t0.cp AS cp_8, t0.observaciones AS observaciones_9, t0.nif AS nif_10, t0.is_activo AS is_activo_11, t0.descripcion AS descripcion_12, t0.tipo AS tipo_13, t0.nombre_representante AS nombre_representante_14, t0.email_representante AS email_representante_15, t0.telefono_representante AS telefono_representante_16, t0.nif_representante AS nif_representante_17, t0.cargo_representante AS cargo_representante_18, t0.seguimiento AS seguimiento_19, t0.uuid AS uuid_20, t0.id AS id_21, t0.empresa_id AS empresa_id_22, t0.grupo_empresa_id AS grupo_empresa_id_23 FROM `user` t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"ATRUTER"
]
|
| 2 | 37.21 ms |
SELECT s0_.nombre AS nombre_0, s0_.descripcion AS descripcion_1, s0_.codigo AS codigo_2, s0_.temperatura AS temperatura_3, s0_.fecha AS fecha_4, s0_.estado AS estado_5, s0_.control AS control_6, s0_.organizacion AS organizacion_7, s0_.parametros_muestra AS parametros_muestra_8, s0_.hora_fin AS hora_fin_9, s0_.created AS created_10, s0_.updated AS updated_11, s0_.uuid AS uuid_12, s0_.id AS id_13, u1_.username AS username_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.codigo AS codigo_17, u1_.nombre AS nombre_18, u1_.apellido1 AS apellido1_19, u1_.apellido2 AS apellido2_20, u1_.cp AS cp_21, u1_.observaciones AS observaciones_22, u1_.nif AS nif_23, u1_.is_activo AS is_activo_24, u1_.descripcion AS descripcion_25, u1_.tipo AS tipo_26, u1_.nombre_representante AS nombre_representante_27, u1_.email_representante AS email_representante_28, u1_.telefono_representante AS telefono_representante_29, u1_.nif_representante AS nif_representante_30, u1_.cargo_representante AS cargo_representante_31, u1_.seguimiento AS seguimiento_32, u1_.uuid AS uuid_33, u1_.id AS id_34, e2_.nombre AS nombre_35, e2_.cif AS cif_36, e2_.is_activo AS is_activo_37, e2_.codigo AS codigo_38, e2_.params_calculos AS params_calculos_39, e2_.params_informes AS params_informes_40, e2_.logo_name AS logo_name_41, e2_.uuid AS uuid_42, e2_.id AS id_43, e2_.created AS created_44, e2_.updated AS updated_45, m3_.codigo AS codigo_46, m3_.cod_id AS cod_id_47, m3_.nombre AS nombre_48, m3_.productor AS productor_49, m3_.tipo_producto AS tipo_producto_50, m3_.n_informe AS n_informe_51, m3_.fecha AS fecha_52, m3_.is_resuelto AS is_resuelto_53, m3_.fases AS fases_54, m3_.definicion AS definicion_55, m3_.marca AS marca_56, m3_.repetida AS repetida_57, m3_.reproducida AS reproducida_58, m3_.original AS original_59, m3_.codigo_auditor AS codigo_auditor_60, m3_.fecha_toma AS fecha_toma_61, m3_.contraetiqueta_precinta AS contraetiqueta_precinta_62, m3_.created AS created_63, m3_.updated AS updated_64, m3_.uuid AS uuid_65, m3_.id AS id_66, p4_.is_activo AS is_activo_67, p4_.codigo AS codigo_68, p4_.nombre AS nombre_69, p4_.definicion_muestra AS definicion_muestra_70, p4_.fases AS fases_71, p4_.modelo AS modelo_72, p4_.created AS created_73, p4_.updated AS updated_74, p4_.uuid AS uuid_75, p4_.id AS id_76, p5_.val_min AS val_min_77, p5_.val_max AS val_max_78, p5_.peso AS peso_79, p5_.is_defecto AS is_defecto_80, p5_.is_discriminante AS is_discriminante_81, p5_.is_mod_escala AS is_mod_escala_82, p5_.escala AS escala_83, p5_.is_activo AS is_activo_84, p5_.orden_fase AS orden_fase_85, p5_.orden_parametro AS orden_parametro_86, p5_.hook AS hook_87, p5_.uuid AS uuid_88, p5_.id AS id_89, c6_.codigo AS codigo_90, c6_.nombre AS nombre_91, c6_.orden AS orden_92, c6_.color AS color_93, c6_.core AS core_94, c6_.created AS created_95, c6_.updated AS updated_96, c6_.uuid AS uuid_97, c6_.id AS id_98, m7_.codigo AS codigo_99, m7_.cod_id AS cod_id_100, m7_.nombre AS nombre_101, m7_.productor AS productor_102, m7_.tipo_producto AS tipo_producto_103, m7_.n_informe AS n_informe_104, m7_.fecha AS fecha_105, m7_.is_resuelto AS is_resuelto_106, m7_.fases AS fases_107, m7_.definicion AS definicion_108, m7_.marca AS marca_109, m7_.repetida AS repetida_110, m7_.reproducida AS reproducida_111, m7_.original AS original_112, m7_.codigo_auditor AS codigo_auditor_113, m7_.fecha_toma AS fecha_toma_114, m7_.contraetiqueta_precinta AS contraetiqueta_precinta_115, m7_.created AS created_116, m7_.updated AS updated_117, m7_.uuid AS uuid_118, m7_.id AS id_119, s0_.empresa_id AS empresa_id_120, s0_.created_by AS created_by_121, s0_.updated_by AS updated_by_122, u1_.empresa_id AS empresa_id_123, u1_.grupo_empresa_id AS grupo_empresa_id_124, e2_.grupo_empresa_id AS grupo_empresa_id_125, m3_.producto_id AS producto_id_126, m3_.empresa_id AS empresa_id_127, m3_.parent_id AS parent_id_128, m3_.sesion_id AS sesion_id_129, m3_.created_by AS created_by_130, m3_.updated_by AS updated_by_131, p4_.empresa_id AS empresa_id_132, p4_.categoria_id AS categoria_id_133, p4_.created_by AS created_by_134, p4_.updated_by AS updated_by_135, p5_.empresa_id AS empresa_id_136, p5_.fase_id AS fase_id_137, p5_.producto_id AS producto_id_138, p5_.parametro_id AS parametro_id_139, c6_.empresa_id AS empresa_id_140, c6_.created_by AS created_by_141, c6_.updated_by AS updated_by_142, m7_.producto_id AS producto_id_143, m7_.empresa_id AS empresa_id_144, m7_.parent_id AS parent_id_145, m7_.sesion_id AS sesion_id_146, m7_.created_by AS created_by_147, m7_.updated_by AS updated_by_148 FROM sesion s0_ LEFT JOIN sesion_user s8_ ON s0_.id = s8_.sesion_id LEFT JOIN `user` u1_ ON u1_.id = s8_.user_id INNER JOIN empresa e2_ ON s0_.empresa_id = e2_.id LEFT JOIN muestra m3_ ON s0_.id = m3_.sesion_id LEFT JOIN producto p4_ ON m3_.producto_id = p4_.id LEFT JOIN producto_parametros p5_ ON p4_.id = p5_.producto_id LEFT JOIN categoria c6_ ON p4_.categoria_id = c6_.id LEFT JOIN muestra m7_ ON m3_.parent_id = m7_.id WHERE s0_.uuid = ? AND s0_.empresa_id = ?
Parameters:
[ "a8fadbbb-1d78-4c84-9c5f-96f28474bf82" 17 ] |
| 3 | 0.91 ms |
SELECT t0.nombre AS nombre_1, t0.descripcion AS descripcion_2, t0.codigo AS codigo_3, t0.temperatura AS temperatura_4, t0.fecha AS fecha_5, t0.estado AS estado_6, t0.control AS control_7, t0.organizacion AS organizacion_8, t0.parametros_muestra AS parametros_muestra_9, t0.hora_fin AS hora_fin_10, t0.created AS created_11, t0.updated AS updated_12, t0.uuid AS uuid_13, t0.id AS id_14, t0.empresa_id AS empresa_id_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM sesion t0 WHERE t0.uuid = ? LIMIT 1
Parameters:
[
"a8fadbbb-1d78-4c84-9c5f-96f28474bf82"
]
|
| 4 | 6.08 ms |
SELECT t0.valor AS valor_1, t0.is_evaluado AS is_evaluado_2, t0.is_cumple AS is_cumple_3, t0.parametros AS parametros_4, t0.uuid AS uuid_5, t0.id AS id_6, t0.empresa_id AS empresa_id_7, t0.evaluador_id AS evaluador_id_8, t0.muestra_id AS muestra_id_9, t0.producto_parametro_id AS producto_parametro_id_10, t0.sesion_id AS sesion_id_11 FROM sesiones_valores t0 WHERE t0.sesion_id = ?
Parameters:
[
201
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Empresa | No errors. |
| App\Entity\GrupoEmpresa | No errors. |
| App\Entity\Email | No errors. |
| App\Entity\Telefono | No errors. |
| App\Entity\Direccion | No errors. |
| App\Entity\Notificacion | No errors. |
| App\Entity\Sesion | No errors. |
| App\Entity\Muestra | No errors. |
| App\Entity\Producto | No errors. |
| App\Entity\ProductoParametros | No errors. |
| App\Entity\Categoria | No errors. |
| App\Entity\Fase | No errors. |
| App\Entity\Parametro | No errors. |
| App\Entity\SesionesValores | No errors. |
| App\Entity\Evento | No errors. |