Symfony Profiler

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 = ?

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 = 2142;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  factura f1_
  LEFT JOIN contrato c2_ ON f1_.contrato_id = c2_.id
  LEFT JOIN cliente c3_ ON c2_.cliente_id = c3_.id
  LEFT JOIN suministro s4_ ON c2_.suministro_id = s4_.id
  LEFT JOIN producto p5_ ON c2_.producto_id = p5_.id
  LEFT JOIN tarifa t0_ ON p5_.tarifa_id = t0_.id
  LEFT JOIN tipo_tarifa t6_ ON t0_.tipo_tarifa_id = t6_.id
  LEFT JOIN comercial c7_ ON c2_.seller_id = c7_.id

SELECT COUNT(t0_.id) AS sclr_0 FROM factura f1_ LEFT JOIN contrato c2_ ON f1_.contrato_id = c2_.id LEFT JOIN cliente c3_ ON c2_.cliente_id = c3_.id LEFT JOIN suministro s4_ ON c2_.suministro_id = s4_.id LEFT JOIN producto p5_ ON c2_.producto_id = p5_.id LEFT JOIN tarifa t0_ ON p5_.tarifa_id = t0_.id LEFT JOIN tipo_tarifa t6_ ON t0_.tipo_tarifa_id = t6_.id LEFT JOIN comercial c7_ ON c2_.seller_id = c7_.id;

SELECT
  f0_.id AS id_0,
  f0_.lectura_energia_p1 AS lectura_energia_p1_1,
  f0_.lectura_energia_p2 AS lectura_energia_p2_2,
  f0_.lectura_energia_p3 AS lectura_energia_p3_3,
  f0_.lectura_energia_p4 AS lectura_energia_p4_4,
  f0_.lectura_energia_p5 AS lectura_energia_p5_5,
  f0_.lectura_energia_p6 AS lectura_energia_p6_6,
  f0_.lectura_reactiva_p1 AS lectura_reactiva_p1_7,
  f0_.lectura_reactiva_p2 AS lectura_reactiva_p2_8,
  f0_.lectura_reactiva_p3 AS lectura_reactiva_p3_9,
  f0_.lectura_reactiva_p4 AS lectura_reactiva_p4_10,
  f0_.lectura_reactiva_p5 AS lectura_reactiva_p5_11,
  f0_.lectura_reactiva_p6 AS lectura_reactiva_p6_12,
  f0_.maximetro AS maximetro_13,
  f0_.maximetro_p1 AS maximetro_p1_14,
  f0_.maximetro_p2 AS maximetro_p2_15,
  f0_.maximetro_p3 AS maximetro_p3_16,
  f0_.maximetro_p4 AS maximetro_p4_17,
  f0_.maximetro_p5 AS maximetro_p5_18,
  f0_.maximetro_p6 AS maximetro_p6_19,
  f0_.fecha_lectura AS fecha_lectura_20,
  f0_.fecha_lectura_anterior AS fecha_lectura_anterior_21,
  f0_.otros_cargos AS otros_cargos_22,
  f0_.devuelta AS devuelta_23,
  f0_.precio_potencia_p1 AS precio_potencia_p1_24,
  f0_.precio_potencia_p2 AS precio_potencia_p2_25,
  f0_.precio_potencia_p3 AS precio_potencia_p3_26,
  f0_.precio_potencia_p4 AS precio_potencia_p4_27,
  f0_.precio_potencia_p5 AS precio_potencia_p5_28,
  f0_.precio_potencia_p6 AS precio_potencia_p6_29,
  f0_.precio_energia_p1 AS precio_energia_p1_30,
  f0_.precio_energia_p2 AS precio_energia_p2_31,
  f0_.precio_energia_p3 AS precio_energia_p3_32,
  f0_.precio_energia_p4 AS precio_energia_p4_33,
  f0_.precio_energia_p5 AS precio_energia_p5_34,
  f0_.precio_energia_p6 AS precio_energia_p6_35,
  f0_.nombre_cliente AS nombre_cliente_36,
  f0_.nif_cliente AS nif_cliente_37,
  f0_.direccion_cliente AS direccion_cliente_38,
  f0_.cp_cliente AS cp_cliente_39,
  f0_.poblacion_cliente AS poblacion_cliente_40,
  f0_.provincia_cliente AS provincia_cliente_41,
  f0_.fecha_emision AS fecha_emision_42,
  f0_.potencia_p1 AS potencia_p1_43,
  f0_.potencia_p2 AS potencia_p2_44,
  f0_.potencia_p3 AS potencia_p3_45,
  f0_.potencia_p4 AS potencia_p4_46,
  f0_.potencia_p5 AS potencia_p5_47,
  f0_.potencia_p6 AS potencia_p6_48,
  f0_.iban AS iban_49,
  f0_.ccc AS ccc_50,
  f0_.alquiler_equipos AS alquiler_equipos_51,
  f0_.impuesto AS impuesto_52,
  f0_.iva AS iva_53,
  f0_.numero_factura AS numero_factura_54,
  f0_.total_factura AS total_factura_55,
  f0_.nombre_notificaciones AS nombre_notificaciones_56,
  f0_.direccion_notificaciones AS direccion_notificaciones_57,
  f0_.cp_notificaciones AS cp_notificaciones_58,
  f0_.poblacion_notificaciones AS poblacion_notificaciones_59,
  f0_.provincia_notificaciones AS provincia_notificaciones_60,
  f0_.notificaciones AS notificaciones_61,
  f0_.lectura_anterior_p1 AS lectura_anterior_p1_62,
  f0_.lectura_anterior_p2 AS lectura_anterior_p2_63,
  f0_.lectura_anterior_p3 AS lectura_anterior_p3_64,
  f0_.lectura_anterior_p4 AS lectura_anterior_p4_65,
  f0_.lectura_anterior_p5 AS lectura_anterior_p5_66,
  f0_.lectura_anterior_p6 AS lectura_anterior_p6_67,
  f0_.factor_conversion AS factor_conversion_68,
  f0_.lectura_reactiva_anterior_p1 AS lectura_reactiva_anterior_p1_69,
  f0_.lectura_reactiva_anterior_p2 AS lectura_reactiva_anterior_p2_70,
  f0_.lectura_reactiva_anterior_p3 AS lectura_reactiva_anterior_p3_71,
  f0_.lectura_reactiva_anterior_p4 AS lectura_reactiva_anterior_p4_72,
  f0_.lectura_reactiva_anterior_p5 AS lectura_reactiva_anterior_p5_73,
  f0_.lectura_reactiva_anterior_p6 AS lectura_reactiva_anterior_p6_74,
  f0_.precio_reactiva_p1 AS precio_reactiva_p1_75,
  f0_.precio_reactiva_p2 AS precio_reactiva_p2_76,
  f0_.precio_reactiva_p3 AS precio_reactiva_p3_77,
  f0_.precio_reactiva_p4 AS precio_reactiva_p4_78,
  f0_.precio_reactiva_p5 AS precio_reactiva_p5_79,
  f0_.precio_reactiva_p6 AS precio_reactiva_p6_80,
  f0_.total_compra AS total_compra_81,
  f0_.fecha_emision_compra AS fecha_emision_compra_82,
  f0_.fecha_cobro_compra AS fecha_cobro_compra_83,
  f0_.precio_compra_energia_p1 AS precio_compra_energia_p1_84,
  f0_.precio_compra_energia_p2 AS precio_compra_energia_p2_85,
  f0_.precio_compra_energia_p3 AS precio_compra_energia_p3_86,
  f0_.precio_compra_energia_p4 AS precio_compra_energia_p4_87,
  f0_.precio_compra_energia_p5 AS precio_compra_energia_p5_88,
  f0_.precio_compra_energia_p6 AS precio_compra_energia_p6_89,
  f0_.precio_compra_potencia_p1 AS precio_compra_potencia_p1_90,
  f0_.precio_compra_potencia_p2 AS precio_compra_potencia_p2_91,
  f0_.precio_compra_potencia_p3 AS precio_compra_potencia_p3_92,
  f0_.precio_compra_potencia_p4 AS precio_compra_potencia_p4_93,
  f0_.precio_compra_potencia_p5 AS precio_compra_potencia_p5_94,
  f0_.precio_compra_potencia_p6 AS precio_compra_potencia_p6_95,
  f0_.alquiler_equipos_real AS alquiler_equipos_real_96,
  f0_.total_compra_factura AS total_compra_factura_97,
  f0_.rentable AS rentable_98,
  f0_.fecha_devolucion AS fecha_devolucion_99,
  f0_.importe_pagado AS importe_pagado_100,
  f0_.logo_hosteleria AS logo_hosteleria_101,
  f0_.importe_bateria_virtual AS importe_bateria_virtual_102,
  f0_.bateria_virtual AS bateria_virtual_103,
  f0_.tipo_lectura_id AS tipo_lectura_id_104,
  f0_.tipo_lectura_anterior_id AS tipo_lectura_anterior_id_105,
  f0_.contrato_id AS contrato_id_106,
  f0_.tarifa_id AS tarifa_id_107,
  f0_.estado_compra_id AS estado_compra_id_108,
  f0_.estado_id AS estado_id_109
FROM
  factura f0_
  LEFT JOIN contrato c1_ ON f0_.contrato_id = c1_.id
  LEFT JOIN cliente c2_ ON c1_.cliente_id = c2_.id
  LEFT JOIN suministro s3_ ON c1_.suministro_id = s3_.id
  LEFT JOIN producto p4_ ON c1_.producto_id = p4_.id
  LEFT JOIN tarifa t5_ ON p4_.tarifa_id = t5_.id
  LEFT JOIN tipo_tarifa t6_ ON t5_.tipo_tarifa_id = t6_.id
  LEFT JOIN comercial c7_ ON c1_.seller_id = c7_.id
ORDER BY
  f0_.fecha_emision DESC
LIMIT
  100

SELECT f0_.id AS id_0, f0_.lectura_energia_p1 AS lectura_energia_p1_1, f0_.lectura_energia_p2 AS lectura_energia_p2_2, f0_.lectura_energia_p3 AS lectura_energia_p3_3, f0_.lectura_energia_p4 AS lectura_energia_p4_4, f0_.lectura_energia_p5 AS lectura_energia_p5_5, f0_.lectura_energia_p6 AS lectura_energia_p6_6, f0_.lectura_reactiva_p1 AS lectura_reactiva_p1_7, f0_.lectura_reactiva_p2 AS lectura_reactiva_p2_8, f0_.lectura_reactiva_p3 AS lectura_reactiva_p3_9, f0_.lectura_reactiva_p4 AS lectura_reactiva_p4_10, f0_.lectura_reactiva_p5 AS lectura_reactiva_p5_11, f0_.lectura_reactiva_p6 AS lectura_reactiva_p6_12, f0_.maximetro AS maximetro_13, f0_.maximetro_p1 AS maximetro_p1_14, f0_.maximetro_p2 AS maximetro_p2_15, f0_.maximetro_p3 AS maximetro_p3_16, f0_.maximetro_p4 AS maximetro_p4_17, f0_.maximetro_p5 AS maximetro_p5_18, f0_.maximetro_p6 AS maximetro_p6_19, f0_.fecha_lectura AS fecha_lectura_20, f0_.fecha_lectura_anterior AS fecha_lectura_anterior_21, f0_.otros_cargos AS otros_cargos_22, f0_.devuelta AS devuelta_23, f0_.precio_potencia_p1 AS precio_potencia_p1_24, f0_.precio_potencia_p2 AS precio_potencia_p2_25, f0_.precio_potencia_p3 AS precio_potencia_p3_26, f0_.precio_potencia_p4 AS precio_potencia_p4_27, f0_.precio_potencia_p5 AS precio_potencia_p5_28, f0_.precio_potencia_p6 AS precio_potencia_p6_29, f0_.precio_energia_p1 AS precio_energia_p1_30, f0_.precio_energia_p2 AS precio_energia_p2_31, f0_.precio_energia_p3 AS precio_energia_p3_32, f0_.precio_energia_p4 AS precio_energia_p4_33, f0_.precio_energia_p5 AS precio_energia_p5_34, f0_.precio_energia_p6 AS precio_energia_p6_35, f0_.nombre_cliente AS nombre_cliente_36, f0_.nif_cliente AS nif_cliente_37, f0_.direccion_cliente AS direccion_cliente_38, f0_.cp_cliente AS cp_cliente_39, f0_.poblacion_cliente AS poblacion_cliente_40, f0_.provincia_cliente AS provincia_cliente_41, f0_.fecha_emision AS fecha_emision_42, f0_.potencia_p1 AS potencia_p1_43, f0_.potencia_p2 AS potencia_p2_44, f0_.potencia_p3 AS potencia_p3_45, f0_.potencia_p4 AS potencia_p4_46, f0_.potencia_p5 AS potencia_p5_47, f0_.potencia_p6 AS potencia_p6_48, f0_.iban AS iban_49, f0_.ccc AS ccc_50, f0_.alquiler_equipos AS alquiler_equipos_51, f0_.impuesto AS impuesto_52, f0_.iva AS iva_53, f0_.numero_factura AS numero_factura_54, f0_.total_factura AS total_factura_55, f0_.nombre_notificaciones AS nombre_notificaciones_56, f0_.direccion_notificaciones AS direccion_notificaciones_57, f0_.cp_notificaciones AS cp_notificaciones_58, f0_.poblacion_notificaciones AS poblacion_notificaciones_59, f0_.provincia_notificaciones AS provincia_notificaciones_60, f0_.notificaciones AS notificaciones_61, f0_.lectura_anterior_p1 AS lectura_anterior_p1_62, f0_.lectura_anterior_p2 AS lectura_anterior_p2_63, f0_.lectura_anterior_p3 AS lectura_anterior_p3_64, f0_.lectura_anterior_p4 AS lectura_anterior_p4_65, f0_.lectura_anterior_p5 AS lectura_anterior_p5_66, f0_.lectura_anterior_p6 AS lectura_anterior_p6_67, f0_.factor_conversion AS factor_conversion_68, f0_.lectura_reactiva_anterior_p1 AS lectura_reactiva_anterior_p1_69, f0_.lectura_reactiva_anterior_p2 AS lectura_reactiva_anterior_p2_70, f0_.lectura_reactiva_anterior_p3 AS lectura_reactiva_anterior_p3_71, f0_.lectura_reactiva_anterior_p4 AS lectura_reactiva_anterior_p4_72, f0_.lectura_reactiva_anterior_p5 AS lectura_reactiva_anterior_p5_73, f0_.lectura_reactiva_anterior_p6 AS lectura_reactiva_anterior_p6_74, f0_.precio_reactiva_p1 AS precio_reactiva_p1_75, f0_.precio_reactiva_p2 AS precio_reactiva_p2_76, f0_.precio_reactiva_p3 AS precio_reactiva_p3_77, f0_.precio_reactiva_p4 AS precio_reactiva_p4_78, f0_.precio_reactiva_p5 AS precio_reactiva_p5_79, f0_.precio_reactiva_p6 AS precio_reactiva_p6_80, f0_.total_compra AS total_compra_81, f0_.fecha_emision_compra AS fecha_emision_compra_82, f0_.fecha_cobro_compra AS fecha_cobro_compra_83, f0_.precio_compra_energia_p1 AS precio_compra_energia_p1_84, f0_.precio_compra_energia_p2 AS precio_compra_energia_p2_85, f0_.precio_compra_energia_p3 AS precio_compra_energia_p3_86, f0_.precio_compra_energia_p4 AS precio_compra_energia_p4_87, f0_.precio_compra_energia_p5 AS precio_compra_energia_p5_88, f0_.precio_compra_energia_p6 AS precio_compra_energia_p6_89, f0_.precio_compra_potencia_p1 AS precio_compra_potencia_p1_90, f0_.precio_compra_potencia_p2 AS precio_compra_potencia_p2_91, f0_.precio_compra_potencia_p3 AS precio_compra_potencia_p3_92, f0_.precio_compra_potencia_p4 AS precio_compra_potencia_p4_93, f0_.precio_compra_potencia_p5 AS precio_compra_potencia_p5_94, f0_.precio_compra_potencia_p6 AS precio_compra_potencia_p6_95, f0_.alquiler_equipos_real AS alquiler_equipos_real_96, f0_.total_compra_factura AS total_compra_factura_97, f0_.rentable AS rentable_98, f0_.fecha_devolucion AS fecha_devolucion_99, f0_.importe_pagado AS importe_pagado_100, f0_.logo_hosteleria AS logo_hosteleria_101, f0_.importe_bateria_virtual AS importe_bateria_virtual_102, f0_.bateria_virtual AS bateria_virtual_103, f0_.tipo_lectura_id AS tipo_lectura_id_104, f0_.tipo_lectura_anterior_id AS tipo_lectura_anterior_id_105, f0_.contrato_id AS contrato_id_106, f0_.tarifa_id AS tarifa_id_107, f0_.estado_compra_id AS estado_compra_id_108, f0_.estado_id AS estado_id_109 FROM factura f0_ LEFT JOIN contrato c1_ ON f0_.contrato_id = c1_.id LEFT JOIN cliente c2_ ON c1_.cliente_id = c2_.id LEFT JOIN suministro s3_ ON c1_.suministro_id = s3_.id LEFT JOIN producto p4_ ON c1_.producto_id = p4_.id LEFT JOIN tarifa t5_ ON p4_.tarifa_id = t5_.id LEFT JOIN tipo_tarifa t6_ ON t5_.tipo_tarifa_id = t6_.id LEFT JOIN comercial c7_ ON c1_.seller_id = c7_.id ORDER BY f0_.fecha_emision DESC LIMIT 100;

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 = ?

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 = 1442;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.gasto_gestion AS gasto_gestion_3,
  t0.duracion AS duracion_4,
  t0.precio_potencia_p1 AS precio_potencia_p1_5,
  t0.precio_potencia_p2 AS precio_potencia_p2_6,
  t0.precio_potencia_p3 AS precio_potencia_p3_7,
  t0.precio_potencia_p4 AS precio_potencia_p4_8,
  t0.precio_potencia_p5 AS precio_potencia_p5_9,
  t0.precio_potencia_p6 AS precio_potencia_p6_10,
  t0.precio_energia_p1 AS precio_energia_p1_11,
  t0.precio_energia_p2 AS precio_energia_p2_12,
  t0.precio_energia_p3 AS precio_energia_p3_13,
  t0.precio_energia_p4 AS precio_energia_p4_14,
  t0.precio_energia_p5 AS precio_energia_p5_15,
  t0.precio_energia_p6 AS precio_energia_p6_16,
  t0.factura_electronica AS factura_electronica_17,
  t0.personalizado AS personalizado_18,
  t0.tarifa_id AS tarifa_id_19,
  t0.modalidad_id AS modalidad_id_20
FROM
  producto t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.gasto_gestion AS gasto_gestion_3, t0.duracion AS duracion_4, t0.precio_potencia_p1 AS precio_potencia_p1_5, t0.precio_potencia_p2 AS precio_potencia_p2_6, t0.precio_potencia_p3 AS precio_potencia_p3_7, t0.precio_potencia_p4 AS precio_potencia_p4_8, t0.precio_potencia_p5 AS precio_potencia_p5_9, t0.precio_potencia_p6 AS precio_potencia_p6_10, t0.precio_energia_p1 AS precio_energia_p1_11, t0.precio_energia_p2 AS precio_energia_p2_12, t0.precio_energia_p3 AS precio_energia_p3_13, t0.precio_energia_p4 AS precio_energia_p4_14, t0.precio_energia_p5 AS precio_energia_p5_15, t0.precio_energia_p6 AS precio_energia_p6_16, t0.factura_electronica AS factura_electronica_17, t0.personalizado AS personalizado_18, t0.tarifa_id AS tarifa_id_19, t0.modalidad_id AS modalidad_id_20 FROM producto t0 WHERE t0.id = 12537;

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 = ?

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 = 1413;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  tipo_via t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM tipo_via t0 WHERE t0.id = 61;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.oculto AS oculto_3,
  t0.potencia_p1 AS potencia_p1_4,
  t0.potencia_p2 AS potencia_p2_5,
  t0.potencia_p3 AS potencia_p3_6,
  t0.potencia_p4 AS potencia_p4_7,
  t0.potencia_p5 AS potencia_p5_8,
  t0.potencia_p6 AS potencia_p6_9,
  t0.energia_p1 AS energia_p1_10,
  t0.energia_p2 AS energia_p2_11,
  t0.energia_p3 AS energia_p3_12,
  t0.energia_p4 AS energia_p4_13,
  t0.energia_p5 AS energia_p5_14,
  t0.energia_p6 AS energia_p6_15,
  t0.reactiva_p1 AS reactiva_p1_16,
  t0.reactiva_p2 AS reactiva_p2_17,
  t0.reactiva_p3 AS reactiva_p3_18,
  t0.reactiva_p4 AS reactiva_p4_19,
  t0.reactiva_p5 AS reactiva_p5_20,
  t0.reactiva_p6 AS reactiva_p6_21,
  t0.maximetro AS maximetro_22,
  t0.tipo_tarifa_id AS tipo_tarifa_id_23
FROM
  tarifa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.oculto AS oculto_3, t0.potencia_p1 AS potencia_p1_4, t0.potencia_p2 AS potencia_p2_5, t0.potencia_p3 AS potencia_p3_6, t0.potencia_p4 AS potencia_p4_7, t0.potencia_p5 AS potencia_p5_8, t0.potencia_p6 AS potencia_p6_9, t0.energia_p1 AS energia_p1_10, t0.energia_p2 AS energia_p2_11, t0.energia_p3 AS energia_p3_12, t0.energia_p4 AS energia_p4_13, t0.energia_p5 AS energia_p5_14, t0.energia_p6 AS energia_p6_15, t0.reactiva_p1 AS reactiva_p1_16, t0.reactiva_p2 AS reactiva_p2_17, t0.reactiva_p3 AS reactiva_p3_18, t0.reactiva_p4 AS reactiva_p4_19, t0.reactiva_p5 AS reactiva_p5_20, t0.reactiva_p6 AS reactiva_p6_21, t0.maximetro AS maximetro_22, t0.tipo_tarifa_id AS tipo_tarifa_id_23 FROM tarifa t0 WHERE t0.id = 23;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  tipo_tarifa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM tipo_tarifa t0 WHERE t0.id = 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 = ?

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 = 1015;

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  estado_compra_factura t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM estado_compra_factura t0 WHERE t0.id = 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 = ?