Query Metrics
46
Database Queries
46
Different statements
8.60 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
extPROJETS connection
| Time▼ | Count | Info |
|---|---|---|
|
0.33 ms (3.88%) |
1 |
SELECT dapp_log.code_ug,dapp_log.etage,dapp_log.porte,dapp_bat.hp3,motif,cep,ges,etq_cep,etq_ges, dapp_log.surface_carrez,dapp_log.conclusion_plomb,dapp_log.statut,diagnostic.con_am_av,diagnostic.conclusion_termite, gaz_elec.anogaz,gaz_elec.ano_dgi,gaz_elec.ano_a1,gaz_elec.ano_a2,gaz_elec.anoelec,gaz_elec.id,diagnostic.date_rv,gaz_elec.alelecoui,gaz_elec.alelecnon ,gaz_elec.algazoui,gaz_elec.algaznon,diagnostic.num_diag,gaz_elec.algazabs,dapp_bat.hp2,gaz_elec.trentema,gaz_elec.prsaobt,gaz_elec.prsapui FROM dapp_log INNER JOIN dapp_bat ON dapp_log.dappbat_id = dapp_bat.id LEFT JOIN diagnostic ON diagnostic.dapplog_id = dapp_log.id LEFT JOIN gaz_elec ON diagnostic.num_diag = gaz_elec.diagnostic_id WHERE dapp_bat.client_id='78' AND dapp_bat.hp2 = '5327' ORDER BY dapp_log.code_ug
Parameters:
[] |
|
0.25 ms (2.94%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121065
Parameters:
[] |
|
0.25 ms (2.86%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121057
Parameters:
[] |
|
0.24 ms (2.76%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121066
Parameters:
[] |
|
0.23 ms (2.70%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121064
Parameters:
[] |
|
0.23 ms (2.67%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121063
Parameters:
[] |
|
0.23 ms (2.64%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121061
Parameters:
[] |
|
0.23 ms (2.62%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121059
Parameters:
[] |
|
0.22 ms (2.59%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121060
Parameters:
[] |
|
0.22 ms (2.58%) |
1 |
SELECT b13a,b13c,b13d,b13e,b13f,b13h,b13i,b13j,b231a,b231b,b231c,b231d,b231f,b232a,b331a,b331b,b331d,b331e,b332b,b333a,b334a,b335a1,b335b1,b335c,b335d,b336a2,b336a4,b336b,b336c,b337a,b337b,b338a,b338b,b339a,b339b,b3310a,b331c,b43a1,b43a2,b43b,b43c,b43e,b43f1,b43f2,b43f3,b43g,b43i,b43j1,b53a,b53b,b53d,b631c,b73b,b73c2,b73e,b83b,b83c,b83d,b932a,b1031a,b1032a,b1031b,b1032b,b1031c,b1032c,b1031d,b1032d,b1031e,b1032e,b11a1,b11a2,b11a3,b11b1,b11b2,b11c1,b11c2,b41,b931a,b335a2,b335b2,alelecoui,alelecnon FROM gaz_elec WHERE diagnostic_id=121062
Parameters:
[] |
|
0.19 ms (2.21%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121064
Parameters:
[] |
|
0.19 ms (2.18%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121063' AND conclusion='Présence'
Parameters:
[] |
|
0.19 ms (2.18%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120687' AND conclusion='Présence'
Parameters:
[] |
|
0.18 ms (2.14%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120689'
Parameters:
[] |
|
0.18 ms (2.13%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120691' AND conclusion='Présence'
Parameters:
[] |
|
0.18 ms (2.11%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120688'
Parameters:
[] |
|
0.18 ms (2.09%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121065
Parameters:
[] |
|
0.18 ms (2.07%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120691'
Parameters:
[] |
|
0.18 ms (2.05%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121066
Parameters:
[] |
|
0.17 ms (2.03%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121065' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (2.00%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121057
Parameters:
[] |
|
0.17 ms (2.00%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120692' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.99%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121060
Parameters:
[] |
|
0.17 ms (1.99%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121063
Parameters:
[] |
|
0.17 ms (1.99%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120688' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.98%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121066' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.98%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120695' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.98%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120689' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.98%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121062
Parameters:
[] |
|
0.17 ms (1.97%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120694' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.97%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '120700' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.96%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121057' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.95%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120695'
Parameters:
[] |
|
0.17 ms (1.95%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121061
Parameters:
[] |
|
0.17 ms (1.95%) |
1 |
SELECT b336a1,b334d,b336a32,b43h,b73a,b332a,b73d,b334b,b83e,b834d,b13g,b231h,b631a,b231i,b83a,b13b FROM gaz_elec WHERE diagnostic_id=121059
Parameters:
[] |
|
0.17 ms (1.94%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121056' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.94%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121060' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.93%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121064' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.93%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121061' AND conclusion='Présence'
Parameters:
[] |
|
0.17 ms (1.93%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '121056'
Parameters:
[] |
|
0.16 ms (1.92%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121062' AND conclusion='Présence'
Parameters:
[] |
|
0.16 ms (1.90%) |
1 |
SELECT amiante_piece.nom_piece,composant,partie_composant,couleur,reco FROM amiante_materiau INNER JOIN amiante_piece ON amiante_piece.num_piece = amiante_materiau.num_piece WHERE amiante_materiau.num_diag = '121059' AND conclusion='Présence'
Parameters:
[] |
|
0.16 ms (1.90%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120692'
Parameters:
[] |
|
0.16 ms (1.85%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120694'
Parameters:
[] |
|
0.16 ms (1.85%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120700'
Parameters:
[] |
|
0.16 ms (1.85%) |
1 |
SELECT conclusion,mode FROM amiante_materiau WHERE num_diag = '120687'
Parameters:
[] |
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.