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(c0_.id) AS sclr_0
FROM
  contrato c0_
  LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id
  LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id
  LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id
  LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id
  LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id
  LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id
WHERE
  c0_.oculto <> ?

SELECT COUNT(c0_.id) AS sclr_0 FROM contrato c0_ LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id WHERE c0_.oculto <> 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  contrato c0_
  LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id
  LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id
  LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id
  LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id
  LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id
  LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id
WHERE
  c0_.oculto <> ?
  AND (
    UPPER(
      CONCAT(
        c1_.nombre, ' ', c1_.apellido, ' ',
        c1_.apellido2
      )
    ) LIKE ?
    OR c1_.nif LIKE ?
    OR UPPER(s2_.direccion_completa) LIKE ?
    OR UPPER(s2_.poblacion) LIKE ?
    OR UPPER(s2_.cups) LIKE ?
    OR UPPER(t6_.nombre) LIKE ?
    OR UPPER(e3_.nombre) LIKE ?
    OR DATE_FORMAT(c0_.ultima_lectura, '%d/%m/%Y') LIKE ?
    OR DATE_FORMAT(c0_.fecha_caducidad, '%d/%m/%Y') LIKE ?
  )

SELECT COUNT(c0_.id) AS sclr_0 FROM contrato c0_ LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id WHERE c0_.oculto <> 1 AND (UPPER(CONCAT(c1_.nombre, ' ', c1_.apellido, ' ', c1_.apellido2)) LIKE '%ES0031405431247005PB%' OR c1_.nif LIKE '%ES0031405431247005PB%' OR UPPER(s2_.direccion_completa) LIKE '%ES0031405431247005PB%' OR UPPER(s2_.poblacion) LIKE '%ES0031405431247005PB%' OR UPPER(s2_.cups) LIKE '%ES0031405431247005PB%' OR UPPER(t6_.nombre) LIKE '%ES0031405431247005PB%' OR UPPER(e3_.nombre) LIKE '%ES0031405431247005PB%' OR DATE_FORMAT(c0_.ultima_lectura, '%d/%m/%Y') LIKE '%ES0031405431247005PB%' OR DATE_FORMAT(c0_.fecha_caducidad, '%d/%m/%Y') LIKE '%ES0031405431247005PB%');

SELECT
  c0_.id AS id_0,
  c0_.referencia_contrato AS referencia_contrato_1,
  c0_.fecha AS fecha_2,
  c0_.consumo_grabado AS consumo_grabado_3,
  c0_.consumo_firmado AS consumo_firmado_4,
  c0_.visita AS visita_5,
  c0_.referido AS referido_6,
  c0_.forma_pago AS forma_pago_7,
  c0_.iban AS iban_8,
  c0_.ccc AS ccc_9,
  c0_.lectura_inicial_p1 AS lectura_inicial_p1_10,
  c0_.lectura_inicial_p2 AS lectura_inicial_p2_11,
  c0_.lectura_inicial_p3 AS lectura_inicial_p3_12,
  c0_.lectura_inicial_p4 AS lectura_inicial_p4_13,
  c0_.lectura_inicial_p5 AS lectura_inicial_p5_14,
  c0_.lectura_inicial_p6 AS lectura_inicial_p6_15,
  c0_.lectura_reactiva_p1 AS lectura_reactiva_p1_16,
  c0_.lectura_reactiva_p2 AS lectura_reactiva_p2_17,
  c0_.lectura_reactiva_p3 AS lectura_reactiva_p3_18,
  c0_.lectura_reactiva_p4 AS lectura_reactiva_p4_19,
  c0_.lectura_reactiva_p5 AS lectura_reactiva_p5_20,
  c0_.lectura_reactiva_p6 AS lectura_reactiva_p6_21,
  c0_.fecha_lectura AS fecha_lectura_22,
  c0_.fecha_cobro AS fecha_cobro_23,
  c0_.fecha_fin AS fecha_fin_24,
  c0_.observaciones AS observaciones_25,
  c0_.comercial AS comercial_26,
  c0_.oculto AS oculto_27,
  c0_.cambio_tarifa AS cambio_tarifa_28,
  c0_.factor_conversion AS factor_conversion_29,
  c0_.ultima_lectura AS ultima_lectura_30,
  c0_.ahorro_anual AS ahorro_anual_31,
  c0_.fecha_caducidad AS fecha_caducidad_32,
  c0_.comision1 AS comision1_33,
  c0_.comision2 AS comision2_34,
  c0_.otros_gastos AS otros_gastos_35,
  c0_.optimizacion AS optimizacion_36,
  c0_.comision_comercial AS comision_comercial_37,
  c0_.factura_devuelta AS factura_devuelta_38,
  c0_.cambios AS cambios_39,
  c0_.consumo_real_p1 AS consumo_real_p1_40,
  c0_.consumo_real_p2 AS consumo_real_p2_41,
  c0_.consumo_real_p3 AS consumo_real_p3_42,
  c0_.consumo_real_p4 AS consumo_real_p4_43,
  c0_.consumo_real_p5 AS consumo_real_p5_44,
  c0_.consumo_real_p6 AS consumo_real_p6_45,
  c0_.comision_cobrada_valor AS comision_cobrada_valor_46,
  c0_.comision_pagada_valor AS comision_pagada_valor_47,
  c0_.comision_cobrada_fecha AS comision_cobrada_fecha_48,
  c0_.comision_pagada_fecha AS comision_pagada_fecha_49,
  c0_.fecha_rentabilidad AS fecha_rentabilidad_50,
  c0_.observaciones_rentabilidad AS observaciones_rentabilidad_51,
  c0_.consumo_acumulado AS consumo_acumulado_52,
  c0_.logo_hosteleria AS logo_hosteleria_53,
  c0_.importe_bateria_virtual AS importe_bateria_virtual_54,
  c0_.bateria_virtual AS bateria_virtual_55,
  c0_.canal_id AS canal_id_56,
  c0_.tipo_lectura_id AS tipo_lectura_id_57,
  c0_.cliente_id AS cliente_id_58,
  c0_.suministro_id AS suministro_id_59,
  c0_.producto_id AS producto_id_60,
  c0_.producto_proveedor_id AS producto_proveedor_id_61,
  c0_.proveedor_id AS proveedor_id_62,
  c0_.tipo_impuesto_id AS tipo_impuesto_id_63,
  c0_.created_by_id AS created_by_id_64,
  c0_.estado_id AS estado_id_65,
  c0_.seller_id AS seller_id_66,
  c0_.comision_cobrada_id AS comision_cobrada_id_67,
  c0_.comision_pagada_id AS comision_pagada_id_68,
  c0_.estado_financiero_id AS estado_financiero_id_69,
  c0_.tipo_iva_id AS tipo_iva_id_70
FROM
  contrato c0_
  LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id
  LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id
  LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id
  LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id
  LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id
  LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id
WHERE
  c0_.oculto <> ?
  AND (
    UPPER(
      CONCAT(
        c1_.nombre, ' ', c1_.apellido, ' ',
        c1_.apellido2
      )
    ) LIKE ?
    OR c1_.nif LIKE ?
    OR UPPER(s2_.direccion_completa) LIKE ?
    OR UPPER(s2_.poblacion) LIKE ?
    OR UPPER(s2_.cups) LIKE ?
    OR UPPER(t6_.nombre) LIKE ?
    OR UPPER(e3_.nombre) LIKE ?
    OR DATE_FORMAT(c0_.ultima_lectura, '%d/%m/%Y') LIKE ?
    OR DATE_FORMAT(c0_.fecha_caducidad, '%d/%m/%Y') LIKE ?
  )
ORDER BY
  e3_.nombre ASC,
  c0_.ultima_lectura ASC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.referencia_contrato AS referencia_contrato_1, c0_.fecha AS fecha_2, c0_.consumo_grabado AS consumo_grabado_3, c0_.consumo_firmado AS consumo_firmado_4, c0_.visita AS visita_5, c0_.referido AS referido_6, c0_.forma_pago AS forma_pago_7, c0_.iban AS iban_8, c0_.ccc AS ccc_9, c0_.lectura_inicial_p1 AS lectura_inicial_p1_10, c0_.lectura_inicial_p2 AS lectura_inicial_p2_11, c0_.lectura_inicial_p3 AS lectura_inicial_p3_12, c0_.lectura_inicial_p4 AS lectura_inicial_p4_13, c0_.lectura_inicial_p5 AS lectura_inicial_p5_14, c0_.lectura_inicial_p6 AS lectura_inicial_p6_15, c0_.lectura_reactiva_p1 AS lectura_reactiva_p1_16, c0_.lectura_reactiva_p2 AS lectura_reactiva_p2_17, c0_.lectura_reactiva_p3 AS lectura_reactiva_p3_18, c0_.lectura_reactiva_p4 AS lectura_reactiva_p4_19, c0_.lectura_reactiva_p5 AS lectura_reactiva_p5_20, c0_.lectura_reactiva_p6 AS lectura_reactiva_p6_21, c0_.fecha_lectura AS fecha_lectura_22, c0_.fecha_cobro AS fecha_cobro_23, c0_.fecha_fin AS fecha_fin_24, c0_.observaciones AS observaciones_25, c0_.comercial AS comercial_26, c0_.oculto AS oculto_27, c0_.cambio_tarifa AS cambio_tarifa_28, c0_.factor_conversion AS factor_conversion_29, c0_.ultima_lectura AS ultima_lectura_30, c0_.ahorro_anual AS ahorro_anual_31, c0_.fecha_caducidad AS fecha_caducidad_32, c0_.comision1 AS comision1_33, c0_.comision2 AS comision2_34, c0_.otros_gastos AS otros_gastos_35, c0_.optimizacion AS optimizacion_36, c0_.comision_comercial AS comision_comercial_37, c0_.factura_devuelta AS factura_devuelta_38, c0_.cambios AS cambios_39, c0_.consumo_real_p1 AS consumo_real_p1_40, c0_.consumo_real_p2 AS consumo_real_p2_41, c0_.consumo_real_p3 AS consumo_real_p3_42, c0_.consumo_real_p4 AS consumo_real_p4_43, c0_.consumo_real_p5 AS consumo_real_p5_44, c0_.consumo_real_p6 AS consumo_real_p6_45, c0_.comision_cobrada_valor AS comision_cobrada_valor_46, c0_.comision_pagada_valor AS comision_pagada_valor_47, c0_.comision_cobrada_fecha AS comision_cobrada_fecha_48, c0_.comision_pagada_fecha AS comision_pagada_fecha_49, c0_.fecha_rentabilidad AS fecha_rentabilidad_50, c0_.observaciones_rentabilidad AS observaciones_rentabilidad_51, c0_.consumo_acumulado AS consumo_acumulado_52, c0_.logo_hosteleria AS logo_hosteleria_53, c0_.importe_bateria_virtual AS importe_bateria_virtual_54, c0_.bateria_virtual AS bateria_virtual_55, c0_.canal_id AS canal_id_56, c0_.tipo_lectura_id AS tipo_lectura_id_57, c0_.cliente_id AS cliente_id_58, c0_.suministro_id AS suministro_id_59, c0_.producto_id AS producto_id_60, c0_.producto_proveedor_id AS producto_proveedor_id_61, c0_.proveedor_id AS proveedor_id_62, c0_.tipo_impuesto_id AS tipo_impuesto_id_63, c0_.created_by_id AS created_by_id_64, c0_.estado_id AS estado_id_65, c0_.seller_id AS seller_id_66, c0_.comision_cobrada_id AS comision_cobrada_id_67, c0_.comision_pagada_id AS comision_pagada_id_68, c0_.estado_financiero_id AS estado_financiero_id_69, c0_.tipo_iva_id AS tipo_iva_id_70 FROM contrato c0_ LEFT JOIN cliente c1_ ON c0_.cliente_id = c1_.id LEFT JOIN suministro s2_ ON c0_.suministro_id = s2_.id LEFT JOIN estado e3_ ON c0_.estado_id = e3_.id LEFT JOIN estado_financiero e4_ ON c0_.estado_financiero_id = e4_.id LEFT JOIN producto p5_ ON c0_.producto_id = p5_.id LEFT JOIN tarifa t6_ ON p5_.tarifa_id = t6_.id WHERE c0_.oculto <> 1 AND (UPPER(CONCAT(c1_.nombre, ' ', c1_.apellido, ' ', c1_.apellido2)) LIKE '%ES0031405431247005PB%' OR c1_.nif LIKE '%ES0031405431247005PB%' OR UPPER(s2_.direccion_completa) LIKE '%ES0031405431247005PB%' OR UPPER(s2_.poblacion) LIKE '%ES0031405431247005PB%' OR UPPER(s2_.cups) LIKE '%ES0031405431247005PB%' OR UPPER(t6_.nombre) LIKE '%ES0031405431247005PB%' OR UPPER(e3_.nombre) LIKE '%ES0031405431247005PB%' OR DATE_FORMAT(c0_.ultima_lectura, '%d/%m/%Y') LIKE '%ES0031405431247005PB%' OR DATE_FORMAT(c0_.fecha_caducidad, '%d/%m/%Y') LIKE '%ES0031405431247005PB%') ORDER BY e3_.nombre ASC, c0_.ultima_lectura ASC LIMIT 100;