Symfony Profiler

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "params" => [
    "url" => "<redacted>"
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "host" => "localhost"
    "port" => null
    "user" => "sonrieco_api"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "sonrieco_zapp"
  ]
]

[
  "sql" => "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.valor = ? LIMIT 1"
  "params" => [
    1 => "144929638711406"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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_centro = ? LIMIT 1"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 100"
  "params" => [
    1 => "144929638711406"
    2 => "144929638711406"
    3 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "687805358"
    2 => "687805358"
    3 => "144929638711406"
    4 => "687805358"
    5 => "144929638711406"
    6 => "687805358"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "687805358"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "674383291"
    2 => "674383291"
    3 => "144929638711406"
    4 => "674383291"
    5 => "144929638711406"
    6 => "674383291"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "674383291"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655096660"
    2 => "655096660"
    3 => "144929638711406"
    4 => "655096660"
    5 => "144929638711406"
    6 => "655096660"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655096660"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666790799"
    2 => "666790799"
    3 => "144929638711406"
    4 => "666790799"
    5 => "144929638711406"
    6 => "666790799"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666790799"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "651157551"
    2 => "651157551"
    3 => "144929638711406"
    4 => "651157551"
    5 => "144929638711406"
    6 => "651157551"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "651157551"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "722198830"
    2 => "722198830"
    3 => "144929638711406"
    4 => "722198830"
    5 => "144929638711406"
    6 => "722198830"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "722198830"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "657328232"
    2 => "657328232"
    3 => "144929638711406"
    4 => "657328232"
    5 => "144929638711406"
    6 => "657328232"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "657328232"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "675971784"
    2 => "675971784"
    3 => "144929638711406"
    4 => "675971784"
    5 => "144929638711406"
    6 => "675971784"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "675971784"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "665844707"
    2 => "665844707"
    3 => "144929638711406"
    4 => "665844707"
    5 => "144929638711406"
    6 => "665844707"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "665844707"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "607355397"
    2 => "607355397"
    3 => "144929638711406"
    4 => "607355397"
    5 => "144929638711406"
    6 => "607355397"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "607355397"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "672066909"
    2 => "672066909"
    3 => "144929638711406"
    4 => "672066909"
    5 => "144929638711406"
    6 => "672066909"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "672066909"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "660315248"
    2 => "660315248"
    3 => "144929638711406"
    4 => "660315248"
    5 => "144929638711406"
    6 => "660315248"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "660315248"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655580826"
    2 => "655580826"
    3 => "144929638711406"
    4 => "655580826"
    5 => "144929638711406"
    6 => "655580826"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655580826"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696871288"
    2 => "696871288"
    3 => "144929638711406"
    4 => "696871288"
    5 => "144929638711406"
    6 => "696871288"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696871288"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "631019901"
    2 => "631019901"
    3 => "144929638711406"
    4 => "631019901"
    5 => "144929638711406"
    6 => "631019901"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "631019901"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "653087023"
    2 => "653087023"
    3 => "144929638711406"
    4 => "653087023"
    5 => "144929638711406"
    6 => "653087023"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "653087023"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "616355377"
    2 => "616355377"
    3 => "144929638711406"
    4 => "616355377"
    5 => "144929638711406"
    6 => "616355377"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "616355377"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "689959077"
    2 => "689959077"
    3 => "144929638711406"
    4 => "689959077"
    5 => "144929638711406"
    6 => "689959077"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "689959077"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610931499"
    2 => "610931499"
    3 => "144929638711406"
    4 => "610931499"
    5 => "144929638711406"
    6 => "610931499"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610931499"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622302087"
    2 => "622302087"
    3 => "144929638711406"
    4 => "622302087"
    5 => "144929638711406"
    6 => "622302087"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622302087"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "649810439"
    2 => "649810439"
    3 => "144929638711406"
    4 => "649810439"
    5 => "144929638711406"
    6 => "649810439"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "649810439"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622302087"
    2 => "622302087"
    3 => "144929638711406"
    4 => "622302087"
    5 => "144929638711406"
    6 => "622302087"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622302087"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "644183337"
    2 => "644183337"
    3 => "144929638711406"
    4 => "644183337"
    5 => "144929638711406"
    6 => "644183337"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "644183337"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622456395"
    2 => "622456395"
    3 => "144929638711406"
    4 => "622456395"
    5 => "144929638711406"
    6 => "622456395"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622456395"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622456395"
    2 => "622456395"
    3 => "144929638711406"
    4 => "622456395"
    5 => "144929638711406"
    6 => "622456395"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "622456395"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "634231535"
    2 => "634231535"
    3 => "144929638711406"
    4 => "634231535"
    5 => "144929638711406"
    6 => "634231535"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "634231535"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "671053522"
    2 => "671053522"
    3 => "144929638711406"
    4 => "671053522"
    5 => "144929638711406"
    6 => "671053522"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "671053522"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "644183337"
    2 => "644183337"
    3 => "144929638711406"
    4 => "644183337"
    5 => "144929638711406"
    6 => "644183337"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "644183337"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666069135"
    2 => "666069135"
    3 => "144929638711406"
    4 => "666069135"
    5 => "144929638711406"
    6 => "666069135"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666069135"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "619472004"
    2 => "619472004"
    3 => "144929638711406"
    4 => "619472004"
    5 => "144929638711406"
    6 => "619472004"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "619472004"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696132735"
    2 => "696132735"
    3 => "144929638711406"
    4 => "696132735"
    5 => "144929638711406"
    6 => "696132735"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696132735"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "606220616"
    2 => "606220616"
    3 => "144929638711406"
    4 => "606220616"
    5 => "144929638711406"
    6 => "606220616"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "606220616"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "638736913"
    2 => "638736913"
    3 => "144929638711406"
    4 => "638736913"
    5 => "144929638711406"
    6 => "638736913"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "638736913"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626535338"
    2 => "626535338"
    3 => "144929638711406"
    4 => "626535338"
    5 => "144929638711406"
    6 => "626535338"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626535338"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655023303"
    2 => "655023303"
    3 => "144929638711406"
    4 => "655023303"
    5 => "144929638711406"
    6 => "655023303"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655023303"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626535338"
    2 => "626535338"
    3 => "144929638711406"
    4 => "626535338"
    5 => "144929638711406"
    6 => "626535338"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626535338"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666271019"
    2 => "666271019"
    3 => "144929638711406"
    4 => "666271019"
    5 => "144929638711406"
    6 => "666271019"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666271019"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610724322"
    2 => "610724322"
    3 => "144929638711406"
    4 => "610724322"
    5 => "144929638711406"
    6 => "610724322"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610724322"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "667656805"
    2 => "667656805"
    3 => "144929638711406"
    4 => "667656805"
    5 => "144929638711406"
    6 => "667656805"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "667656805"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610496974"
    2 => "610496974"
    3 => "144929638711406"
    4 => "610496974"
    5 => "144929638711406"
    6 => "610496974"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610496974"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610496974"
    2 => "610496974"
    3 => "144929638711406"
    4 => "610496974"
    5 => "144929638711406"
    6 => "610496974"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610496974"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "667656805"
    2 => "667656805"
    3 => "144929638711406"
    4 => "667656805"
    5 => "144929638711406"
    6 => "667656805"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "667656805"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "686461422"
    2 => "686461422"
    3 => "144929638711406"
    4 => "686461422"
    5 => "144929638711406"
    6 => "686461422"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "686461422"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "601310115"
    2 => "601310115"
    3 => "144929638711406"
    4 => "601310115"
    5 => "144929638711406"
    6 => "601310115"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "601310115"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626737871"
    2 => "626737871"
    3 => "144929638711406"
    4 => "626737871"
    5 => "144929638711406"
    6 => "626737871"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "626737871"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610724322"
    2 => "610724322"
    3 => "144929638711406"
    4 => "610724322"
    5 => "144929638711406"
    6 => "610724322"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610724322"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655023303"
    2 => "655023303"
    3 => "144929638711406"
    4 => "655023303"
    5 => "144929638711406"
    6 => "655023303"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "655023303"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "638736913"
    2 => "638736913"
    3 => "144929638711406"
    4 => "638736913"
    5 => "144929638711406"
    6 => "638736913"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "638736913"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "654232467"
    2 => "654232467"
    3 => "144929638711406"
    4 => "654232467"
    5 => "144929638711406"
    6 => "654232467"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "654232467"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "606220616"
    2 => "606220616"
    3 => "144929638711406"
    4 => "606220616"
    5 => "144929638711406"
    6 => "606220616"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "606220616"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696132735"
    2 => "696132735"
    3 => "144929638711406"
    4 => "696132735"
    5 => "144929638711406"
    6 => "696132735"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "696132735"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "619472004"
    2 => "619472004"
    3 => "144929638711406"
    4 => "619472004"
    5 => "144929638711406"
    6 => "619472004"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "619472004"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "620423230"
    2 => "620423230"
    3 => "144929638711406"
    4 => "620423230"
    5 => "144929638711406"
    6 => "620423230"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "620423230"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "651646129"
    2 => "651646129"
    3 => "144929638711406"
    4 => "651646129"
    5 => "144929638711406"
    6 => "651646129"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "651646129"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666069135"
    2 => "666069135"
    3 => "144929638711406"
    4 => "666069135"
    5 => "144929638711406"
    6 => "666069135"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "666069135"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "634231535"
    2 => "634231535"
    3 => "144929638711406"
    4 => "634231535"
    5 => "144929638711406"
    6 => "634231535"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "634231535"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "671053522"
    2 => "671053522"
    3 => "144929638711406"
    4 => "671053522"
    5 => "144929638711406"
    6 => "671053522"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "671053522"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "669058881"
    2 => "669058881"
    3 => "144929638711406"
    4 => "669058881"
    5 => "144929638711406"
    6 => "669058881"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "669058881"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610931499"
    2 => "610931499"
    3 => "144929638711406"
    4 => "610931499"
    5 => "144929638711406"
    6 => "610931499"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "610931499"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "662033106"
    2 => "662033106"
    3 => "144929638711406"
    4 => "662033106"
    5 => "144929638711406"
    6 => "662033106"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "662033106"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "679205519"
    2 => "679205519"
    3 => "144929638711406"
    4 => "679205519"
    5 => "144929638711406"
    6 => "679205519"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "679205519"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "608572525"
    2 => "608572525"
    3 => "144929638711406"
    4 => "608572525"
    5 => "144929638711406"
    6 => "608572525"
    7 => 8
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 1
  ]
]