Query Metrics
9
Database Queries
9
Different statements
18.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.61 ms (75.09%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.04 ms (5.72%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t6.id AS id_7, t6.nombre AS nombre_8, t6.apellido AS apellido_9, t6.apellido2 AS apellido2_10, t6.nif AS nif_11, t6.representante AS representante_12, t6.nombre_representante AS nombre_representante_13, t6.dni_representante AS dni_representante_14, t6.telefono AS telefono_15, t6.telefono2 AS telefono2_16, t6.email AS email_17, t6.nombre_via AS nombre_via_18, t6.numero_direccion AS numero_direccion_19, t6.escalera AS escalera_20, t6.piso AS piso_21, t6.puerta AS puerta_22, t6.cp AS cp_23, t6.poblacion AS poblacion_24, t6.provincia AS provincia_25, t6.notificaciones AS notificaciones_26, t6.nombre_notificaciones AS nombre_notificaciones_27, t6.direccion_notificaciones AS direccion_notificaciones_28, t6.poblacion_notificaciones AS poblacion_notificaciones_29, t6.cp_notificaciones AS cp_notificaciones_30, t6.provincia_notificaciones AS provincia_notificaciones_31, t6.observaciones AS observaciones_32, t6.codigo_contable AS codigo_contable_33, t6.informacion_factura_e AS informacion_factura_e_34, t6.codigo_receptor AS codigo_receptor_35, t6.codigo_pagador AS codigo_pagador_36, t6.codigo_fiscal AS codigo_fiscal_37, t6.tipo_documento_id AS tipo_documento_id_38, t6.tipo_via_id AS tipo_via_id_39, t6.user_id AS user_id_40, t41.id AS id_42, t41.nif AS nif_43, t41.nombre AS nombre_44, t41.apellido1 AS apellido1_45, t41.apellido2 AS apellido2_46, t41.telefono AS telefono_47, t41.email AS email_48, t41.codigo_vendedor AS codigo_vendedor_49, t41.total_puntos AS total_puntos_50, t41.user_id AS user_id_51 FROM `user` t0 LEFT JOIN cliente t6 ON t6.user_id = t0.id LEFT JOIN comercial t41 ON t41.user_id = t0.id WHERE t0.id = ?
Parameters:
[
2144
]
|
|
0.94 ms (5.16%) |
1 |
SELECT t0.id AS id_1, t0.lectura_energia_p1 AS lectura_energia_p1_2, t0.lectura_energia_p2 AS lectura_energia_p2_3, t0.lectura_energia_p3 AS lectura_energia_p3_4, t0.lectura_energia_p4 AS lectura_energia_p4_5, t0.lectura_energia_p5 AS lectura_energia_p5_6, t0.lectura_energia_p6 AS lectura_energia_p6_7, t0.lectura_reactiva_p1 AS lectura_reactiva_p1_8, t0.lectura_reactiva_p2 AS lectura_reactiva_p2_9, t0.lectura_reactiva_p3 AS lectura_reactiva_p3_10, t0.lectura_reactiva_p4 AS lectura_reactiva_p4_11, t0.lectura_reactiva_p5 AS lectura_reactiva_p5_12, t0.lectura_reactiva_p6 AS lectura_reactiva_p6_13, t0.maximetro AS maximetro_14, t0.maximetro_p1 AS maximetro_p1_15, t0.maximetro_p2 AS maximetro_p2_16, t0.maximetro_p3 AS maximetro_p3_17, t0.maximetro_p4 AS maximetro_p4_18, t0.maximetro_p5 AS maximetro_p5_19, t0.maximetro_p6 AS maximetro_p6_20, t0.fecha_lectura AS fecha_lectura_21, t0.fecha_lectura_anterior AS fecha_lectura_anterior_22, t0.otros_cargos AS otros_cargos_23, t0.devuelta AS devuelta_24, t0.precio_potencia_p1 AS precio_potencia_p1_25, t0.precio_potencia_p2 AS precio_potencia_p2_26, t0.precio_potencia_p3 AS precio_potencia_p3_27, t0.precio_potencia_p4 AS precio_potencia_p4_28, t0.precio_potencia_p5 AS precio_potencia_p5_29, t0.precio_potencia_p6 AS precio_potencia_p6_30, t0.precio_energia_p1 AS precio_energia_p1_31, t0.precio_energia_p2 AS precio_energia_p2_32, t0.precio_energia_p3 AS precio_energia_p3_33, t0.precio_energia_p4 AS precio_energia_p4_34, t0.precio_energia_p5 AS precio_energia_p5_35, t0.precio_energia_p6 AS precio_energia_p6_36, t0.nombre_cliente AS nombre_cliente_37, t0.nif_cliente AS nif_cliente_38, t0.direccion_cliente AS direccion_cliente_39, t0.cp_cliente AS cp_cliente_40, t0.poblacion_cliente AS poblacion_cliente_41, t0.provincia_cliente AS provincia_cliente_42, t0.fecha_emision AS fecha_emision_43, t0.potencia_p1 AS potencia_p1_44, t0.potencia_p2 AS potencia_p2_45, t0.potencia_p3 AS potencia_p3_46, t0.potencia_p4 AS potencia_p4_47, t0.potencia_p5 AS potencia_p5_48, t0.potencia_p6 AS potencia_p6_49, t0.iban AS iban_50, t0.ccc AS ccc_51, t0.alquiler_equipos AS alquiler_equipos_52, t0.impuesto AS impuesto_53, t0.iva AS iva_54, t0.numero_factura AS numero_factura_55, t0.total_factura AS total_factura_56, t0.nombre_notificaciones AS nombre_notificaciones_57, t0.direccion_notificaciones AS direccion_notificaciones_58, t0.cp_notificaciones AS cp_notificaciones_59, t0.poblacion_notificaciones AS poblacion_notificaciones_60, t0.provincia_notificaciones AS provincia_notificaciones_61, t0.notificaciones AS notificaciones_62, t0.lectura_anterior_p1 AS lectura_anterior_p1_63, t0.lectura_anterior_p2 AS lectura_anterior_p2_64, t0.lectura_anterior_p3 AS lectura_anterior_p3_65, t0.lectura_anterior_p4 AS lectura_anterior_p4_66, t0.lectura_anterior_p5 AS lectura_anterior_p5_67, t0.lectura_anterior_p6 AS lectura_anterior_p6_68, t0.factor_conversion AS factor_conversion_69, t0.lectura_reactiva_anterior_p1 AS lectura_reactiva_anterior_p1_70, t0.lectura_reactiva_anterior_p2 AS lectura_reactiva_anterior_p2_71, t0.lectura_reactiva_anterior_p3 AS lectura_reactiva_anterior_p3_72, t0.lectura_reactiva_anterior_p4 AS lectura_reactiva_anterior_p4_73, t0.lectura_reactiva_anterior_p5 AS lectura_reactiva_anterior_p5_74, t0.lectura_reactiva_anterior_p6 AS lectura_reactiva_anterior_p6_75, t0.precio_reactiva_p1 AS precio_reactiva_p1_76, t0.precio_reactiva_p2 AS precio_reactiva_p2_77, t0.precio_reactiva_p3 AS precio_reactiva_p3_78, t0.precio_reactiva_p4 AS precio_reactiva_p4_79, t0.precio_reactiva_p5 AS precio_reactiva_p5_80, t0.precio_reactiva_p6 AS precio_reactiva_p6_81, t0.total_compra AS total_compra_82, t0.fecha_emision_compra AS fecha_emision_compra_83, t0.fecha_cobro_compra AS fecha_cobro_compra_84, t0.precio_compra_energia_p1 AS precio_compra_energia_p1_85, t0.precio_compra_energia_p2 AS precio_compra_energia_p2_86, t0.precio_compra_energia_p3 AS precio_compra_energia_p3_87, t0.precio_compra_energia_p4 AS precio_compra_energia_p4_88, t0.precio_compra_energia_p5 AS precio_compra_energia_p5_89, t0.precio_compra_energia_p6 AS precio_compra_energia_p6_90, t0.precio_compra_potencia_p1 AS precio_compra_potencia_p1_91, t0.precio_compra_potencia_p2 AS precio_compra_potencia_p2_92, t0.precio_compra_potencia_p3 AS precio_compra_potencia_p3_93, t0.precio_compra_potencia_p4 AS precio_compra_potencia_p4_94, t0.precio_compra_potencia_p5 AS precio_compra_potencia_p5_95, t0.precio_compra_potencia_p6 AS precio_compra_potencia_p6_96, t0.alquiler_equipos_real AS alquiler_equipos_real_97, t0.total_compra_factura AS total_compra_factura_98, t0.rentable AS rentable_99, t0.fecha_devolucion AS fecha_devolucion_100, t0.importe_pagado AS importe_pagado_101, t0.logo_hosteleria AS logo_hosteleria_102, t0.importe_bateria_virtual AS importe_bateria_virtual_103, t0.bateria_virtual AS bateria_virtual_104, t0.tipo_lectura_id AS tipo_lectura_id_105, t0.tipo_lectura_anterior_id AS tipo_lectura_anterior_id_106, t0.contrato_id AS contrato_id_107, t0.tarifa_id AS tarifa_id_108, t0.estado_compra_id AS estado_compra_id_109, t0.estado_id AS estado_id_110 FROM factura t0 WHERE t0.id = ?
Parameters:
[
"114612"
]
|
|
0.77 ms (4.27%) |
1 |
SELECT t0.id AS id_1, t0.referencia_contrato AS referencia_contrato_2, t0.fecha AS fecha_3, t0.consumo_grabado AS consumo_grabado_4, t0.consumo_firmado AS consumo_firmado_5, t0.visita AS visita_6, t0.referido AS referido_7, t0.forma_pago AS forma_pago_8, t0.iban AS iban_9, t0.ccc AS ccc_10, t0.lectura_inicial_p1 AS lectura_inicial_p1_11, t0.lectura_inicial_p2 AS lectura_inicial_p2_12, t0.lectura_inicial_p3 AS lectura_inicial_p3_13, t0.lectura_inicial_p4 AS lectura_inicial_p4_14, t0.lectura_inicial_p5 AS lectura_inicial_p5_15, t0.lectura_inicial_p6 AS lectura_inicial_p6_16, t0.lectura_reactiva_p1 AS lectura_reactiva_p1_17, t0.lectura_reactiva_p2 AS lectura_reactiva_p2_18, t0.lectura_reactiva_p3 AS lectura_reactiva_p3_19, t0.lectura_reactiva_p4 AS lectura_reactiva_p4_20, t0.lectura_reactiva_p5 AS lectura_reactiva_p5_21, t0.lectura_reactiva_p6 AS lectura_reactiva_p6_22, t0.fecha_lectura AS fecha_lectura_23, t0.fecha_cobro AS fecha_cobro_24, t0.fecha_fin AS fecha_fin_25, t0.observaciones AS observaciones_26, t0.comercial AS comercial_27, t0.oculto AS oculto_28, t0.cambio_tarifa AS cambio_tarifa_29, t0.factor_conversion AS factor_conversion_30, t0.ultima_lectura AS ultima_lectura_31, t0.ahorro_anual AS ahorro_anual_32, t0.fecha_caducidad AS fecha_caducidad_33, t0.comision1 AS comision1_34, t0.comision2 AS comision2_35, t0.otros_gastos AS otros_gastos_36, t0.optimizacion AS optimizacion_37, t0.comision_comercial AS comision_comercial_38, t0.factura_devuelta AS factura_devuelta_39, t0.cambios AS cambios_40, t0.consumo_real_p1 AS consumo_real_p1_41, t0.consumo_real_p2 AS consumo_real_p2_42, t0.consumo_real_p3 AS consumo_real_p3_43, t0.consumo_real_p4 AS consumo_real_p4_44, t0.consumo_real_p5 AS consumo_real_p5_45, t0.consumo_real_p6 AS consumo_real_p6_46, t0.comision_cobrada_valor AS comision_cobrada_valor_47, t0.comision_pagada_valor AS comision_pagada_valor_48, t0.comision_cobrada_fecha AS comision_cobrada_fecha_49, t0.comision_pagada_fecha AS comision_pagada_fecha_50, t0.fecha_rentabilidad AS fecha_rentabilidad_51, t0.observaciones_rentabilidad AS observaciones_rentabilidad_52, t0.consumo_acumulado AS consumo_acumulado_53, t0.logo_hosteleria AS logo_hosteleria_54, t0.importe_bateria_virtual AS importe_bateria_virtual_55, t0.bateria_virtual AS bateria_virtual_56, t0.canal_id AS canal_id_57, t0.tipo_lectura_id AS tipo_lectura_id_58, t0.cliente_id AS cliente_id_59, t0.suministro_id AS suministro_id_60, t0.producto_id AS producto_id_61, t0.producto_proveedor_id AS producto_proveedor_id_62, t0.proveedor_id AS proveedor_id_63, t0.tipo_impuesto_id AS tipo_impuesto_id_64, t0.created_by_id AS created_by_id_65, t0.estado_id AS estado_id_66, t0.seller_id AS seller_id_67, t0.comision_cobrada_id AS comision_cobrada_id_68, t0.comision_pagada_id AS comision_pagada_id_69, t0.estado_financiero_id AS estado_financiero_id_70, t0.tipo_iva_id AS tipo_iva_id_71 FROM contrato t0 WHERE t0.id = ?
Parameters:
[
4918
]
|
|
0.51 ms (2.84%) |
1 |
SELECT t0.id AS id_1, t0.cups AS cups_2, t0.nombre_via AS nombre_via_3, t0.numero_direccion AS numero_direccion_4, t0.escalera AS escalera_5, t0.piso AS piso_6, t0.puerta AS puerta_7, t0.cp AS cp_8, t0.poblacion AS poblacion_9, t0.provincia AS provincia_10, t0.potencia_p1 AS potencia_p1_11, t0.potencia_p2 AS potencia_p2_12, t0.potencia_p3 AS potencia_p3_13, t0.potencia_p4 AS potencia_p4_14, t0.potencia_p5 AS potencia_p5_15, t0.potencia_p6 AS potencia_p6_16, t0.alquiler_contador AS alquiler_contador_17, t0.consumo_anual AS consumo_anual_18, t0.observaciones AS observaciones_19, t0.maximetro AS maximetro_20, t0.codigo_contable AS codigo_contable_21, t0.alquiler_contador_real AS alquiler_contador_real_22, t0.direccion_completa AS direccion_completa_23, t0.tipo_via_id AS tipo_via_id_24 FROM suministro t0 WHERE t0.id = ?
Parameters:
[
4303
]
|
|
0.40 ms (2.23%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.apellido AS apellido_3, t0.apellido2 AS apellido2_4, t0.nif AS nif_5, t0.representante AS representante_6, t0.nombre_representante AS nombre_representante_7, t0.dni_representante AS dni_representante_8, t0.telefono AS telefono_9, t0.telefono2 AS telefono2_10, t0.email AS email_11, t0.nombre_via AS nombre_via_12, t0.numero_direccion AS numero_direccion_13, t0.escalera AS escalera_14, t0.piso AS piso_15, t0.puerta AS puerta_16, t0.cp AS cp_17, t0.poblacion AS poblacion_18, t0.provincia AS provincia_19, t0.notificaciones AS notificaciones_20, t0.nombre_notificaciones AS nombre_notificaciones_21, t0.direccion_notificaciones AS direccion_notificaciones_22, t0.poblacion_notificaciones AS poblacion_notificaciones_23, t0.cp_notificaciones AS cp_notificaciones_24, t0.provincia_notificaciones AS provincia_notificaciones_25, t0.observaciones AS observaciones_26, t0.codigo_contable AS codigo_contable_27, t0.informacion_factura_e AS informacion_factura_e_28, t0.codigo_receptor AS codigo_receptor_29, t0.codigo_pagador AS codigo_pagador_30, t0.codigo_fiscal AS codigo_fiscal_31, t0.tipo_documento_id AS tipo_documento_id_32, t0.tipo_via_id AS tipo_via_id_33, t0.user_id AS user_id_34 FROM cliente t0 WHERE t0.id = ?
Parameters:
[
3336
]
|
|
0.38 ms (2.11%) |
1 |
UPDATE factura SET devuelta = ? WHERE id = ?
Parameters:
[ 0 114612 ] |
|
0.24 ms (1.31%) |
1 |
SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM tipo_via t0 WHERE t0.id = ?
Parameters:
[
61
]
|
|
0.23 ms (1.27%) |
1 |
"START TRANSACTION"
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Cliente | No errors. |
| App\Entity\TipoDocumento | No errors. |
| App\Entity\TipoVia | No errors. |
| App\Entity\Comercial | No errors. |
| App\Entity\Contrato | No errors. |
| App\Entity\Notificacion | No errors. |
| App\Entity\Factura | No errors. |
| App\Entity\FacturaGenerica | No errors. |
| App\Entity\EstadoCompraFactura | No errors. |
| App\Entity\Banco | No errors. |
| App\Entity\TipoLectura | No errors. |
| App\Entity\Tarifa | No errors. |
| App\Entity\EstadoFactura | No errors. |
| App\Entity\Concepto | No errors. |
| App\Entity\Fraccionamiento | No errors. |
| App\Entity\Canal | No errors. |
| App\Entity\Suministro | No errors. |
| App\Entity\Producto | No errors. |
| App\Entity\ProductoProveedor | No errors. |
| App\Entity\Proveedor | No errors. |
| App\Entity\TipoImpuesto | No errors. |
| App\Entity\Estado | No errors. |
| App\Entity\EstadoComision | No errors. |
| App\Entity\EstadoFinanciero | No errors. |
| App\Entity\TipoIva | No errors. |
| App\Entity\TipoTarifa | No errors. |
| App\Entity\Impuesto | No errors. |
| App\Entity\Modalidad | No errors. |