Symfony Profiler

SELECT
  t0.id_centro AS id_centro_1,
  t0.nombre_centro AS nombre_centro_2,
  t0.ip_centro AS ip_centro_3,
  t0.id_afiliado AS id_afiliado_4,
  t0.afiliado AS afiliado_5,
  t0.emergencias AS emergencias_6,
  t0.descripcion AS descripcion_7,
  t0.imagen AS imagen_8,
  t0.calle AS calle_9,
  t0.direccion AS direccion_10,
  t0.telefono AS telefono_11,
  t0.email AS email_12,
  t0.coordenadas AS coordenadas_13,
  t0.email_notifica AS email_notifica_14,
  t0.url_web AS url_web_15,
  t0.url_facebook AS url_facebook_16,
  t0.url_twitter AS url_twitter_17,
  t0.url_googleplus AS url_googleplus_18,
  t0.promo_text AS promo_text_19,
  t0.url_ggmaps AS url_ggmaps_20,
  t0.url_visita_virtual AS url_visita_virtual_21,
  t0.info_parkings AS info_parkings_22,
  t0.email_contact AS email_contact_23,
  t0.provincia AS provincia_24,
  t0.poblacion AS poblacion_25
FROM
  centros t0
WHERE
  t0.id_afiliado = ?
LIMIT
  1

SELECT t0.id_centro AS id_centro_1, t0.nombre_centro AS nombre_centro_2, t0.ip_centro AS ip_centro_3, t0.id_afiliado AS id_afiliado_4, t0.afiliado AS afiliado_5, t0.emergencias AS emergencias_6, t0.descripcion AS descripcion_7, t0.imagen AS imagen_8, t0.calle AS calle_9, t0.direccion AS direccion_10, t0.telefono AS telefono_11, t0.email AS email_12, t0.coordenadas AS coordenadas_13, t0.email_notifica AS email_notifica_14, t0.url_web AS url_web_15, t0.url_facebook AS url_facebook_16, t0.url_twitter AS url_twitter_17, t0.url_googleplus AS url_googleplus_18, t0.promo_text AS promo_text_19, t0.url_ggmaps AS url_ggmaps_20, t0.url_visita_virtual AS url_visita_virtual_21, t0.info_parkings AS info_parkings_22, t0.email_contact AS email_contact_23, t0.provincia AS provincia_24, t0.poblacion AS poblacion_25 FROM centros t0 WHERE t0.id_afiliado = '2' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.key_identificador AS key_identificador_2,
  t0.valor AS valor_3,
  t0.is_active AS is_active_4,
  t0.centro_id AS centro_id_5
FROM
  configuracion t0
WHERE
  t0.key_identificador = ?
  AND t0.centro_id = ?
  AND t0.valor = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.key_identificador AS key_identificador_2, t0.valor AS valor_3, t0.is_active AS is_active_4, t0.centro_id AS centro_id_5 FROM configuracion t0 WHERE t0.key_identificador = 'whaba_id' AND t0.centro_id = 8 AND t0.valor = '144929638711406' LIMIT 1;

SELECT
  h0_.whaba_origen_id AS whaba_origen_id_0,
  h0_.whaba_destino_id AS whaba_destino_id_1,
  h0_.centro_id AS centro_id_2,
  h0_.vc_id AS vc_id_3,
  MAX(h0_.fecha_creacion) AS sclr_4
FROM
  historial_mensajes_whatsapp h0_
WHERE
  (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND h0_.centro_id = ?
GROUP BY
  h0_.vc_id,
  h0_.whaba_origen_id,
  h0_.whaba_destino_id
ORDER BY
  sclr_4 DESC
LIMIT
  20

SELECT h0_.whaba_origen_id AS whaba_origen_id_0, h0_.whaba_destino_id AS whaba_destino_id_1, h0_.centro_id AS centro_id_2, h0_.vc_id AS vc_id_3, MAX(h0_.fecha_creacion) AS sclr_4 FROM historial_mensajes_whatsapp h0_ WHERE (h0_.whaba_origen_id = '144929638711406' OR h0_.whaba_destino_id = '144929638711406') AND h0_.centro_id = 8 GROUP BY h0_.vc_id, h0_.whaba_origen_id, h0_.whaba_destino_id ORDER BY sclr_4 DESC LIMIT 20;

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '658687736' OR h0_.whaba_destino_id = '658687736') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '658687736') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '658687736')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '658687736';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '639112756' OR h0_.whaba_destino_id = '639112756') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '639112756') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '639112756')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '639112756';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '687647908' OR h0_.whaba_destino_id = '687647908') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '687647908') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '687647908')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '687647908';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '627614537' OR h0_.whaba_destino_id = '627614537') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '627614537') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '627614537')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '627614537';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '685962673' OR h0_.whaba_destino_id = '685962673') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '685962673') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '685962673')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '685962673';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '685962673' OR h0_.whaba_destino_id = '685962673') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '685962673') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '685962673')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '685962673';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '659683115' OR h0_.whaba_destino_id = '659683115') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '659683115') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '659683115')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '659683115';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '680722193' OR h0_.whaba_destino_id = '680722193') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '680722193') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '680722193')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '680722193';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '609858278' OR h0_.whaba_destino_id = '609858278') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '609858278') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '609858278')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '609858278';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '626535338' OR h0_.whaba_destino_id = '626535338') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '626535338') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '626535338')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '626535338';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '626535338' OR h0_.whaba_destino_id = '626535338') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '626535338') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '626535338')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '626535338';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '626495014' OR h0_.whaba_destino_id = '626495014') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '626495014') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '626495014')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '626495014';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '646651397' OR h0_.whaba_destino_id = '646651397') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '646651397') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '646651397')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '646651397';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '650522946' OR h0_.whaba_destino_id = '650522946') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '650522946') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '650522946')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '650522946';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '686946182' OR h0_.whaba_destino_id = '686946182') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '686946182') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '686946182')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '686946182';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '686946182' OR h0_.whaba_destino_id = '686946182') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '686946182') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '686946182')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '686946182';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '673759132' OR h0_.whaba_destino_id = '673759132') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '673759132') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '673759132')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '673759132';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '616355377' OR h0_.whaba_destino_id = '616355377') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '616355377') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '616355377')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '616355377';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '619980306' OR h0_.whaba_destino_id = '619980306') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '619980306') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '619980306')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '619980306';

SELECT
  COUNT(h0_.is_read) AS sclr_0
FROM
  historial_mensajes_whatsapp h0_
WHERE
  h0_.is_read = 0
  AND (
    h0_.whaba_origen_id = ?
    OR h0_.whaba_destino_id = ?
  )
  AND (
    (
      h0_.whaba_destino_id = ?
      AND h0_.whaba_origen_id = ?
    )
    OR (
      h0_.whaba_origen_id = ?
      AND h0_.whaba_destino_id = ?
    )
  )
  AND h0_.centro_id = ?

SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = '661865422' OR h0_.whaba_destino_id = '661865422') AND ((h0_.whaba_destino_id = '144929638711406' AND h0_.whaba_origen_id = '661865422') OR (h0_.whaba_origen_id = '144929638711406' AND h0_.whaba_destino_id = '661865422')) AND h0_.centro_id = 8;

SELECT
  t0.id AS id_1,
  t0.numero_telefono AS numero_telefono_2,
  t0.sms AS sms_3,
  t0.tipo_telefono AS tipo_telefono_4,
  t0.paciente_vc_id AS paciente_vc_id_5
FROM
  telefonos_paciente_vc t0
WHERE
  t0.numero_telefono = ?

SELECT t0.id AS id_1, t0.numero_telefono AS numero_telefono_2, t0.sms AS sms_3, t0.tipo_telefono AS tipo_telefono_4, t0.paciente_vc_id AS paciente_vc_id_5 FROM telefonos_paciente_vc t0 WHERE t0.numero_telefono = '661865422';