https://dev.webhopital.atbg.info/login

Method
GET
HTTP Status
200
IP
216.73.216.36
Profiled on
Token
d004f3

Query Metrics

2 Database Queries
1 Different statements
9.02 ms Query time
0 Invalid entities

Queries

Group similar statements

adada connection

#▲ Time Info
1 4.83 ms 
SELECT count(client_ip_ip) as nbips, client_vidal_token,client_vidal, client_nom, client_id, client_date_fin_installation, client_ref_nom, client_ref_prenom,client_cbip
                 FROM ADADA_CLIENT 
                 LEFT JOIN ADADA_CLIENT_IP on ADADA_CLIENT.client_id=ADADA_CLIENT_IP.client_ip_id_client 
                 WHERE (ADADA_CLIENT_IP.client_ip_ip = :client_ip1 
                 OR  IF(REPLACE(ADADA_CLIENT_IP.client_ip_ip, '.*', '') <> ADADA_CLIENT_IP.client_ip_ip,:client_ip2 like CONCAT(REPLACE(ADADA_CLIENT_IP.client_ip_ip, '.*', ''), '%'),''))
                 AND client_produit like '%hopital_web%'
Parameters: 
[
  "client_ip1" => "216.73.216.36"
  "client_ip2" => "216.73.216.36"
]
View formatted query    View runnable query    Explain query
2 4.19 ms 
SELECT count(client_ip_ip) as nbips, client_vidal_token,client_vidal, client_nom, client_id, client_date_fin_installation, client_ref_nom, client_ref_prenom,client_cbip
                 FROM ADADA_CLIENT 
                 LEFT JOIN ADADA_CLIENT_IP on ADADA_CLIENT.client_id=ADADA_CLIENT_IP.client_ip_id_client 
                 WHERE (ADADA_CLIENT_IP.client_ip_ip = :client_ip1 
                 OR  IF(REPLACE(ADADA_CLIENT_IP.client_ip_ip, '.*', '') <> ADADA_CLIENT_IP.client_ip_ip,:client_ip2 like CONCAT(REPLACE(ADADA_CLIENT_IP.client_ip_ip, '.*', ''), '%'),''))
                 AND client_produit like '%hopital_web%'
Parameters: 
[
  "client_ip1" => "216.73.216.36"
  "client_ip2" => "216.73.216.36"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
app doctrine.dbal.app_connection
adada doctrine.dbal.adada_connection
boutique doctrine.dbal.boutique_connection

Entity Managers

Name Service
app doctrine.orm.app_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Utilisateur No errors.
App\Entity\SessionConnexion No errors.
App\Entity\TypeConnexion No errors.
App\Entity\AbbreviationLangue No errors.
App\Entity\Actualite No errors.
App\Entity\Antibiotique No errors.
App\Entity\CasCliniquesCategorie No errors.
App\Entity\CasCliniquesQuestion No errors.
App\Entity\CasCliniquesReponse No errors.
App\Entity\CasCliniquesReponseUtilisateur No errors.
App\Entity\Cellule No errors.
App\Entity\CelluleTitreComplet No errors.
App\Entity\CoAntibiotiqueCalcul No errors.
App\Entity\Contenu No errors.
App\Entity\Etablissement No errors.
App\Entity\FamilleAntibiotique No errors.
App\Entity\Favoris No errors.
App\Entity\InformationHopital No errors.
App\Entity\InformationReference No errors.
App\Entity\Information No errors.
App\Entity\IntervenantSessionepp No errors.
App\Entity\Langue No errors.
App\Entity\Microorganisme No errors.
App\Entity\Note No errors.
App\Entity\Parametre No errors.
App\Entity\Pays No errors.
App\Entity\Personnalisation No errors.
App\Entity\PersonnalisationSpectre No errors.
App\Entity\Qualite No errors.
App\Entity\ReferenceHopital No errors.
App\Entity\Reference No errors.
App\Entity\Service No errors.
App\Entity\Sessionepp No errors.
App\Entity\SessioneppUrl No errors.
App\Entity\Specialite No errors.
App\Entity\Spectre No errors.
App\Entity\TicketPatient No errors.
App\Entity\TypeInformation No errors.
App\Entity\Version No errors.
App\Entity\AntibiotiqueLien No errors.
App\Entity\CelluleReferenceHopital No errors.
App\Entity\InformationHopitalReferenceHopital No errors.
App\Entity\PersonnalisationReferenceHopital No errors.
App\Entity\TypeReference No errors.