https://comunicacionprueba.ziving.com/get-listado-conversaciones/144929638711406

Query Metrics

203 Database Queries
5 Different statements
4758.50 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3705.69 ms
(77.88%)
100
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:
[
  "687805358"
  "687805358"
  "144929638711406"
  "687805358"
  "144929638711406"
  "687805358"
  8
]
963.71 ms
(20.25%)
100
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:
[
  "687805358"
]
88.68 ms
(1.86%)
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 100
Parameters:
[
  "144929638711406"
  "144929638711406"
  8
]
0.31 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.valor = ? LIMIT 1
Parameters:
[
  "144929638711406"
]
0.11 ms
(0.00%)
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_centro = ? LIMIT 1
Parameters:
[
  8
]

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\Configuracion No errors.
App\Entity\ZAPP\Centros No errors.
App\Entity\ZAPP\HistorialMensajesWhatsapp No errors.
App\Entity\ZAPP\TelefonosPacienteVc No errors.
App\Entity\ZAPP\PacienteVc No errors.