http://sandbox.crmgarbal.com/webhook/garbal/messagerie

Query Metrics

3 Database Queries
3 Different statements
1.72 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.70 ms
(40.69%)
1
SELECT t0.id AS id_1, t0.nom_prenom AS nom_prenom_2, t0.telephone AS telephone_3, t0.adresse AS adresse_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.statut AS statut_7, t0.profil AS profil_8 FROM client t0 WHERE t0.telephone = ? AND t0.statut = ? LIMIT 1
Parameters:
[
  "22792829789"
  1
]
0.68 ms
(39.71%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.created_at AS created_at_3, t0.deleted_at AS deleted_at_4, t0.statut AS statut_5 FROM canal t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.34 ms
(19.60%)
1
SELECT t0.id AS id_1, t0.objet AS objet_2, t0.commentaire AS commentaire_3, t0.date_debut_conversation AS date_debut_conversation_4, t0.date_fin_conversation AS date_fin_conversation_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.statut AS statut_8, t0.id_user_id AS id_user_id_9, t0.id_client_id AS id_client_id_10, t0.id_statut_conversation_id AS id_statut_conversation_id_11 FROM conversation t0 WHERE t0.id_client_id = ? AND t0.id_statut_conversation_id = ? LIMIT 1
Parameters:
[
  1
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\AffectationFonctionnalite No errors.
App\Entity\Conversation No errors.
App\Entity\StatutConversation No errors.
App\Entity\Canal No errors.
App\Entity\Client No errors.
App\Entity\TypeMessage No errors.
App\Entity\User
  • The association App\Entity\User#id_profil refers to the inverse side field App\Entity\Profil#user which does not exist.
App\Entity\Onglets No errors.
App\Entity\FonctionnaliteProfil No errors.
App\Entity\SousFonctionnaliteProfil No errors.
App\Entity\Profil No errors.