Query Metrics
83
Database Queries
8
Different statements
1278.26 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.27 ms |
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
Parameters:
[
"400"
]
|
2 | 0.10 ms |
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
Parameters:
[ "whaba_id" 2 "146940985168116" ] |
3 | 136.42 ms |
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
Parameters:
[ "146940985168116" "146940985168116" 2 ] |
4 | 32.35 ms |
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 = ?
Parameters:
[ "632077385" "632077385" "146940985168116" "632077385" "146940985168116" "632077385" 2 ] |
5 | 9.61 ms |
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 = ?
Parameters:
[
"632077385"
]
|
6 | 0.15 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
130492
]
|
7 | 32.25 ms |
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 = ?
Parameters:
[ "669904355" "669904355" "146940985168116" "669904355" "146940985168116" "669904355" 2 ] |
8 | 9.61 ms |
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 = ?
Parameters:
[
"669904355"
]
|
9 | 0.13 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
132230
]
|
10 | 32.16 ms |
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 = ?
Parameters:
[ "626355923" "626355923" "146940985168116" "626355923" "146940985168116" "626355923" 2 ] |
11 | 9.57 ms |
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 = ?
Parameters:
[
"626355923"
]
|
12 | 0.12 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
127987
]
|
13 | 0.09 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
127989
]
|
14 | 32.13 ms |
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 = ?
Parameters:
[ "626355923" "626355923" "146940985168116" "626355923" "146940985168116" "626355923" 2 ] |
15 | 9.60 ms |
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 = ?
Parameters:
[
"626355923"
]
|
16 | 32.16 ms |
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 = ?
Parameters:
[ "646749911" "646749911" "146940985168116" "646749911" "146940985168116" "646749911" 2 ] |
17 | 9.57 ms |
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 = ?
Parameters:
[
"646749911"
]
|
18 | 32.12 ms |
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 = ?
Parameters:
[ "680470715" "680470715" "146940985168116" "680470715" "146940985168116" "680470715" 2 ] |
19 | 9.52 ms |
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 = ?
Parameters:
[
"680470715"
]
|
20 | 0.13 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
132940
]
|
21 | 0.09 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
132941
]
|
22 | 32.15 ms |
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 = ?
Parameters:
[ "666207266" "666207266" "146940985168116" "666207266" "146940985168116" "666207266" 2 ] |
23 | 9.56 ms |
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 = ?
Parameters:
[
"666207266"
]
|
24 | 32.19 ms |
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 = ?
Parameters:
[ "610969326" "610969326" "146940985168116" "610969326" "146940985168116" "610969326" 2 ] |
25 | 9.57 ms |
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 = ?
Parameters:
[
"610969326"
]
|
26 | 32.12 ms |
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 = ?
Parameters:
[ "680470715" "680470715" "146940985168116" "680470715" "146940985168116" "680470715" 2 ] |
27 | 9.49 ms |
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 = ?
Parameters:
[
"680470715"
]
|
28 | 32.15 ms |
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 = ?
Parameters:
[ "636876088" "636876088" "146940985168116" "636876088" "146940985168116" "636876088" 2 ] |
29 | 9.57 ms |
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 = ?
Parameters:
[
"636876088"
]
|
30 | 32.15 ms |
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 = ?
Parameters:
[ "610969326" "610969326" "146940985168116" "610969326" "146940985168116" "610969326" 2 ] |
31 | 9.57 ms |
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 = ?
Parameters:
[
"610969326"
]
|
32 | 32.10 ms |
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 = ?
Parameters:
[ "699965157" "699965157" "146940985168116" "699965157" "146940985168116" "699965157" 2 ] |
33 | 9.58 ms |
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 = ?
Parameters:
[
"699965157"
]
|
34 | 0.19 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
130060
]
|
35 | 32.37 ms |
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 = ?
Parameters:
[ "676533975" "676533975" "146940985168116" "676533975" "146940985168116" "676533975" 2 ] |
36 | 9.61 ms |
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 = ?
Parameters:
[
"676533975"
]
|
37 | 0.16 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
437524
]
|
38 | 32.26 ms |
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 = ?
Parameters:
[ "616694584" "616694584" "146940985168116" "616694584" "146940985168116" "616694584" 2 ] |
39 | 9.69 ms |
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 = ?
Parameters:
[
"616694584"
]
|
40 | 0.15 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
441383
]
|
41 | 0.10 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
441384
]
|
42 | 0.09 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
441385
]
|
43 | 32.09 ms |
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 = ?
Parameters:
[ "610093550" "610093550" "146940985168116" "610093550" "146940985168116" "610093550" 2 ] |
44 | 9.56 ms |
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 = ?
Parameters:
[
"610093550"
]
|
45 | 0.13 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
123557
]
|
46 | 32.15 ms |
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 = ?
Parameters:
[ "627669737" "627669737" "146940985168116" "627669737" "146940985168116" "627669737" 2 ] |
47 | 9.56 ms |
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 = ?
Parameters:
[
"627669737"
]
|
48 | 0.16 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
121325
]
|
49 | 32.00 ms |
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 = ?
Parameters:
[ "601214545" "601214545" "146940985168116" "601214545" "146940985168116" "601214545" 2 ] |
50 | 9.57 ms |
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 = ?
Parameters:
[
"601214545"
]
|
51 | 32.20 ms |
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 = ?
Parameters:
[ "601214545" "601214545" "146940985168116" "601214545" "146940985168116" "601214545" 2 ] |
52 | 9.57 ms |
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 = ?
Parameters:
[
"601214545"
]
|
53 | 32.13 ms |
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 = ?
Parameters:
[ "625261664" "625261664" "146940985168116" "625261664" "146940985168116" "625261664" 2 ] |
54 | 9.56 ms |
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 = ?
Parameters:
[
"625261664"
]
|
55 | 32.12 ms |
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 = ?
Parameters:
[ "631940984" "631940984" "146940985168116" "631940984" "146940985168116" "631940984" 2 ] |
56 | 9.55 ms |
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 = ?
Parameters:
[
"631940984"
]
|
57 | 0.12 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id = ?
Parameters:
[
438155
]
|
58 | 21.73 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "131054" 2 ] |
59 | 0.10 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "632077385" 130492 ] |
60 | 22.63 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "132801" 2 ] |
61 | 0.08 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "669904355" 132230 ] |
62 | 20.38 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "128530" 2 ] |
63 | 0.10 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "626355923" 127987 ] |
64 | 20.35 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "128532" 2 ] |
65 | 0.11 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "626355923" 127989 ] |
66 | 23.09 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "133517" 2 ] |
67 | 0.09 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "680470715" 132940 ] |
68 | 23.06 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "133518" 2 ] |
69 | 0.12 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "680470715" 132941 ] |
70 | 21.52 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "130616" 2 ] |
71 | 0.13 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "699965157" 130060 ] |
72 | 28.96 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "128325" 2 ] |
73 | 0.11 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "676533975" 437524 ] |
74 | 29.23 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "130038" 2 ] |
75 | 0.11 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "616694584" 438116 ] |
76 | 29.42 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "130039" 2 ] |
77 | 0.11 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "616694584" 438117 ] |
78 | 17.67 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "124053" 2 ] |
79 | 0.09 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "610093550" 123557 ] |
80 | 16.24 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "18675" 2 ] |
81 | 0.08 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "627669737" 121325 ] |
82 | 29.19 ms |
SELECT t0.id AS id_1, t0.id_vc AS id_vc_2, t0.nombre AS nombre_3, t0.apellidos AS apellidos_4, t0.dni AS dni_5, t0.email AS email_6, t0.sexo AS sexo_7, t0.edad AS edad_8, t0.fecha_nacimiento AS fecha_nacimiento_9, t0.direccion AS direccion_10, t0.localidad AS localidad_11, t0.provincia AS provincia_12, t0.diagnostico AS diagnostico_13, t0.plan_tratamiento AS plan_tratamiento_14, t0.codigo_postal AS codigo_postal_15, t0.foto AS foto_16, t0.foto_base AS foto_base_17, t0.inicio_tratamiento AS inicio_tratamiento_18, t0.fecha_prevision_fin AS fecha_prevision_fin_19, t0.duracion AS duracion_20, t0.id_base AS id_base_21, t0.ebp_nombre_padre AS ebp_nombre_padre_22, t0.ebp_prof_padre AS ebp_prof_padre_23, t0.ebp_nif_padre AS ebp_nif_padre_24, t0.ebp_nombre_madre AS ebp_nombre_madre_25, t0.ebp_prof_madre AS ebp_prof_madre_26, t0.ebp_nif_madre AS ebp_nif_madre_27, t0.colegio AS colegio_28, t0.tutor_legal AS tutor_legal_29, t0.nif_tutor_legal AS nif_tutor_legal_30, t0.num_cuenta_entidad AS num_cuenta_entidad_31, t0.num_cuenta_sucursal AS num_cuenta_sucursal_32, t0.num_cuenta_dc AS num_cuenta_dc_33, t0.num_cuenta_cc AS num_cuenta_cc_34, t0.modo_pago AS modo_pago_35, t0.claves AS claves_36, t0.ebp_alergias AS ebp_alergias_37, t0.observaciones AS observaciones_38, t0.estatus AS estatus_39, t0.centro_id AS centro_id_40, t0.fin_tratamiento AS fin_tratamiento_41, t0.tipo_tratamiento AS tipo_tratamiento_42, t0.isSendEmail AS isSendEmail_43, t0.profesional_id AS profesional_id_44 FROM paciente_vc t0 WHERE t0.id_vc = ? AND t0.centro_id = ? LIMIT 1
Parameters:
[ "135855" 2 ] |
83 | 0.11 ms |
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 = ? AND t0.paciente_vc_id = ? LIMIT 1
Parameters:
[ "631940984" 438155 ] |
Database Connections
Name | Service |
---|---|
zapp | doctrine.dbal.zapp_connection |
Entity Managers
Name | Service |
---|---|
zapp | doctrine.orm.zapp_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\ZAPP\Centros | No errors. |
App\Entity\ZAPP\Configuracion | No errors. |
App\Entity\ZAPP\HistorialMensajesWhatsapp | No errors. |
App\Entity\ZAPP\TelefonosPacienteVc | No errors. |
App\Entity\ZAPP\PacienteVc | No errors. |