Query Metrics
1
Database Queries
1
Different statements
325.40 ms
Query time
0
Invalid entities
0
Managed entities
Queries
extERP connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 325.40 ms |
SELECT concat('ERP_', d.num_diag) as idExterne, concat('ERP_', UCASE(REPLACE(REPLACE(d.type_diag, 'é', 'e'), ' ', '_'))) as nature, # null as actif, @dateDeb := IF(d.date_rv, TIMESTAMP(concat(d.date_rv, ' ', IFNULL(d.heure_rv, '08'), ':', IFNULL(d.min_rv, '00'))), null) as debut, IF(@dateDeb, IF(d.heure_rv, DATE_ADD(@dateDeb, INTERVAL IFNULL(d.duree_rv, 60) MINUTE), DATE_ADD(@dateDeb, INTERVAL 10 HOUR)), null) as fin, IFNULL(duree_rv, 60) as dureeStandard, 1 as priorite, IF(c.num_client, concat('CLT_', c.num_client), 'DEFAULT') as contrat, concat('CTC_', g.num_util) as contactIdExterne_1, IF(c.num_client, concat('CLT_', c.num_client), 'DEFAULT') as diag_commandeClient, UPPER(d.num_dossier) as libelle, d.date_demande_old as dateCreation, 'Europe/Paris' as timeZone, concat('https://erp.arkhedia.net/voir-diagnostic-operateur/', d.num_diag) as urlExterne, d.reference as numCommande, CASE WHEN d.statut = 'Annulée' THEN 'ANNULEE' WHEN d.statut = 'A facturer' THEN 'A_FACTURER' WHEN d.statut = 'Facturée' THEN 'FACTUREE' WHEN d.statut = 'Cloturée' THEN 'CLOTUREE' WHEN d.statut = 'Stand by' THEN 'EN_PAUSE' WHEN d.statut = 'Réalisée G-ordon' THEN 'SENT' ELSE 'A_FAIRE' END as statutIdExterne, d.statut as diag_statut, IF(d.statut = 'Annulée' OR d.statut = 'A facturer' OR d.statut = 'Cloturée' OR d.statut = 'Facturée', 1, 0) as readOnly, concat('TECH_', t.num_util) as ressource, TRIM(d.observations) as commentaire, null as lat, null as lng, concat_ws(', ', d.rue, d.cp, d.ville) as adresse, 1 as isActive, concat(g.nom, ', ', g.prenom) as diag_commandeGestionnaire, concat(ct1.nom, ', ', ct1.prenom) as diag_commandeContact1, concat(cr.nom, ', ', cr.prenom) as diag_commandeCreateur, concat('UTIL_', cr.num_util) as diag_commandeCreateurId, d.num_dossier as diag_numDossier, d.date_demande as diag_dateDemande, d.reference as diag_commandeReference, d.code_ug as diag_codeUG, d.type_diag as diag_typeMission, d.rue as diag_adresseRue, d.cp as diag_adresseCP, d.ville as diag_adresseVille, concat_ws(', ', d.rue, d.cp, d.ville) as diag_gordonAdresse, d.type_lot as diag_typeLot, d.observations as diag_observations, d.observations_operateur as diag_observationsOperateur, d.observations_technicien as diag_observationsTechnicien, d.proprietaire as diag_proprietaire, d.mod_acces as diag_modaliteAcces, d.mod_acces_loc_tel as diag_modaliteAccesLocataireTelephone, d.mod_acces_loc as diag_modaliteAccesLocataire, d.porte as diag_porte, d.etage as diag_etage, d.num_contact1 as diag_numContact, d.date_rv as diag_rdvDate, d.heure_rv as diag_rdvHeure, d.min_rv as diag_rdvMinute, d.duree_rv as diag_rdvDuree, concat(t.nom, ', ', t.prenom) as diag_rdvDiagnostiqueur, t.mail as diag_rdvDiagnostiqueurEmail, concat('TECH_', t.num_util) as diag_rdvDiagnostiqueurIdExterne, d.demolition as diag_perimetreDemolition, d.travaux as diag_perimetreTravaux, d.audit as diag_perimetreAudit, d.carrez as diag_perimetreCarrez, d.gaz as diag_perimetreGaz, d.elec as diag_perimetreElec, d.plomb as diag_perimetrePlomb, d.ernt as diag_perimetreErnt, d.dpe as diag_perimetreDPE, d.termite as diag_perimetreTermite, d.amiante_dapp as diag_perimetreAmianteDAPP, d.raat as diag_perimetreRAAT, d.dapp as diag_perimetreDAPP, d.amiante as diag_perimetreAmiante, d.dta as diag_perimetreDTA, d.etat_conservation as diag_perimetreEC, d.diagnostic_anc as diag_perimetreDiagANC, d.examen_visuel as diag_perimetreEV, d.dta_reperage as diag_perimetreDTAReperage, d.dta_fiche as diag_perimetreDTAFiche, c.is_diag_info as diag_isDiagInfo, d.last_update as diag_lastUpdate FROM diagnostic d INNER JOIN utilisateur g ON d.num_util = g.num_util LEFT JOIN client c ON g.num_client = c.num_client LEFT JOIN utilisateur t ON d.num_diagnostiqueur = t.num_util LEFT JOIN utilisateur cr ON d.createur_id = cr.num_util LEFT JOIN utilisateur ct1 ON d.num_contact1 = ct1.num_util WHERE type_diag IS NOT NULL AND TIMESTAMPDIFF(MINUTE, d.last_update, now()) <= :value ORDER BY d.num_diag DESC
Parameters:
[ "value" => 2 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| extERP | doctrine.dbal.extERP_connection |
| extPROJETS | doctrine.dbal.extPROJETS_connection |
| extMONDIAG | doctrine.dbal.extMONDIAG_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| extERP | doctrine.orm.extERP_entity_manager |
| extPROJETS | doctrine.orm.extPROJETS_entity_manager |
| extMONDIAG | doctrine.orm.extMONDIAG_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
extERP entity manager
| Class | Amount of managed objects |
|---|
extPROJETS entity manager
| Class | Amount of managed objects |
|---|
extMONDIAG entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
No loaded entities.
extERP entity manager
No loaded entities.
extPROJETS entity manager
No loaded entities.
extMONDIAG entity manager
No loaded entities.