Query Metrics
83
Database Queries
8
Different statements
1278.26 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
643.35 ms (50.33%) |
20 |
SELECT COUNT(h0_.is_read) AS sclr_0 FROM historial_mensajes_whatsapp h0_ WHERE h0_.is_read = 0 AND (h0_.whaba_origen_id = ? OR h0_.whaba_destino_id = ?) AND ((h0_.whaba_destino_id = ? AND h0_.whaba_origen_id = ?) OR (h0_.whaba_origen_id = ? AND h0_.whaba_destino_id = ?)) AND h0_.centro_id = ?
Parameters:
[ "632077385" "632077385" "146940985168116" "632077385" "146940985168116" "632077385" 2 ] |
303.47 ms (23.74%) |
13 |
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 ] |
191.50 ms (14.98%) |
20 |
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"
]
|
136.42 ms (10.67%) |
1 |
SELECT h0_.whaba_origen_id AS whaba_origen_id_0, h0_.whaba_destino_id AS whaba_destino_id_1, h0_.centro_id AS centro_id_2, h0_.vc_id AS vc_id_3, MAX(h0_.fecha_creacion) AS sclr_4 FROM historial_mensajes_whatsapp h0_ WHERE (h0_.whaba_origen_id = ? OR h0_.whaba_destino_id = ?) AND h0_.centro_id = ? GROUP BY h0_.vc_id, h0_.whaba_origen_id, h0_.whaba_destino_id ORDER BY sclr_4 DESC LIMIT 20
Parameters:
[ "146940985168116" "146940985168116" 2 ] |
1.81 ms (0.14%) |
14 |
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
]
|
1.33 ms (0.10%) |
13 |
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 ] |
0.27 ms (0.02%) |
1 |
SELECT t0.id_centro AS id_centro_1, t0.nombre_centro AS nombre_centro_2, t0.ip_centro AS ip_centro_3, t0.id_afiliado AS id_afiliado_4, t0.afiliado AS afiliado_5, t0.emergencias AS emergencias_6, t0.descripcion AS descripcion_7, t0.imagen AS imagen_8, t0.calle AS calle_9, t0.direccion AS direccion_10, t0.telefono AS telefono_11, t0.email AS email_12, t0.coordenadas AS coordenadas_13, t0.email_notifica AS email_notifica_14, t0.url_web AS url_web_15, t0.url_facebook AS url_facebook_16, t0.url_twitter AS url_twitter_17, t0.url_googleplus AS url_googleplus_18, t0.promo_text AS promo_text_19, t0.url_ggmaps AS url_ggmaps_20, t0.url_visita_virtual AS url_visita_virtual_21, t0.info_parkings AS info_parkings_22, t0.email_contact AS email_contact_23, t0.provincia AS provincia_24, t0.poblacion AS poblacion_25 FROM centros t0 WHERE t0.id_afiliado = ? LIMIT 1
Parameters:
[
"400"
]
|
0.10 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.key_identificador AS key_identificador_2, t0.valor AS valor_3, t0.is_active AS is_active_4, t0.centro_id AS centro_id_5 FROM configuracion t0 WHERE t0.key_identificador = ? AND t0.centro_id = ? AND t0.valor = ? LIMIT 1
Parameters:
[ "whaba_id" 2 "146940985168116" ] |
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. |