Query Metrics
2
Database Queries
2
Different statements
2.24 ms
Query time
0
Invalid entities
168
Managed entities
Queries
customer connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.38 ms |
SELECT t0.id AS id_1, t0.ts AS ts_2, t0.user_id AS user_id_3, t0.`read` AS read_4, t0.msg AS msg_5 FROM global_notification t0 WHERE t0.user_id = ?
Parameters:
[
101
]
|
| 2 | 0.86 ms |
SELECT t0.id AS id_1, t0.ts AS ts_2, t0.user_id AS user_id_3, t0.`read` AS read_4, t0.msg AS msg_5 FROM global_notification t0 WHERE t0.user_id = ? AND t0.`read` = ?
Parameters:
[ 101 0 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| customer | doctrine.dbal.customer_connection |
| test_sfm_cust_tpl | doctrine.dbal.test_sfm_cust_tpl_connection |
| test_sfm_cust_scheidegg | doctrine.dbal.test_sfm_cust_scheidegg_connection |
| test_sfm_cust_sturban | doctrine.dbal.test_sfm_cust_sturban_connection |
| test_sfm_cust_rosenweg | doctrine.dbal.test_sfm_cust_rosenweg_connection |
| test_sfm_cust_demo | doctrine.dbal.test_sfm_cust_demo_connection |
| test_sfm_cust_marienhaus | doctrine.dbal.test_sfm_cust_marienhaus_connection |
| test_sfm_cust_leuenmatt | doctrine.dbal.test_sfm_cust_leuenmatt_connection |
| test_sfm_cust_johanniter | doctrine.dbal.test_sfm_cust_johanniter_connection |
| test_sfm_cust_kontiki | doctrine.dbal.test_sfm_cust_kontiki_connection |
| test_sfm_cust_gaeu | doctrine.dbal.test_sfm_cust_gaeu_connection |
| test_sfm_cust_wasserturm | doctrine.dbal.test_sfm_cust_wasserturm_connection |
| test_sfm_cust_buchsifeld | doctrine.dbal.test_sfm_cust_buchsifeld_connection |
| test_sfm_cust_spz | doctrine.dbal.test_sfm_cust_spz_connection |
| test_sfm_cust_dahlia | doctrine.dbal.test_sfm_cust_dahlia_connection |
| test_sfm_cust_stniklaus | doctrine.dbal.test_sfm_cust_stniklaus_connection |
| test_sfm_cust_kastanienpark | doctrine.dbal.test_sfm_cust_kastanienpark_connection |
| test_sfm_cust_dahlia_oberfeld | doctrine.dbal.test_sfm_cust_dahlia_oberfeld_connection |
| test_sfm_cust_dahlia_zollbruck | doctrine.dbal.test_sfm_cust_dahlia_zollbruck_connection |
| test_sfm_cust_hasle | doctrine.dbal.test_sfm_cust_hasle_connection |
| test_sfm_cust_wng | doctrine.dbal.test_sfm_cust_wng_connection |
| test_sfm_cust_seewinkel | doctrine.dbal.test_sfm_cust_seewinkel_connection |
| test_sfm_cust_sonnenhof | doctrine.dbal.test_sfm_cust_sonnenhof_connection |
| test_sfm_cust_goldenberg | doctrine.dbal.test_sfm_cust_goldenberg_connection |
| test_sfm_cust_phsj | doctrine.dbal.test_sfm_cust_phsj_connection |
| test_sfm_cust_sue | doctrine.dbal.test_sfm_cust_sue_connection |
| test_sfm_cust_kirchfeld | doctrine.dbal.test_sfm_cust_kirchfeld_connection |
| test_sfm_cust_azw | doctrine.dbal.test_sfm_cust_azw_connection |
| test_sfm_cust_schaerme | doctrine.dbal.test_sfm_cust_schaerme_connection |
| test_sfm_cust_kurhaus | doctrine.dbal.test_sfm_cust_kurhaus_connection |
| test_sfm_cust_tabea | doctrine.dbal.test_sfm_cust_tabea_connection |
| test_sfm_cust_apzhb | doctrine.dbal.test_sfm_cust_apzhb_connection |
| test_sfm_cust_aphw | doctrine.dbal.test_sfm_cust_aphw_connection |
| test_sfm_cust_szn | doctrine.dbal.test_sfm_cust_szn_connection |
| test_sfm_cust_kunde01 | doctrine.dbal.test_sfm_cust_kunde01_connection |
| test_sfm_cust_retis | doctrine.dbal.test_sfm_cust_retis_connection |
| test_sfm_cust_wald | doctrine.dbal.test_sfm_cust_wald_connection |
| test_sfm_cust_lum_test | doctrine.dbal.test_sfm_cust_lum_test_connection |
| test_sfm_cust_tcs | doctrine.dbal.test_sfm_cust_tcs_connection |
| test_sfm_cust_wisler | doctrine.dbal.test_sfm_cust_wisler_connection |
| test_sfm_cust_ulme | doctrine.dbal.test_sfm_cust_ulme_connection |
| test_sfm_cust_eiche | doctrine.dbal.test_sfm_cust_eiche_connection |
| test_sfm_cust_maien | doctrine.dbal.test_sfm_cust_maien_connection |
| test_sfm_cust_mac | doctrine.dbal.test_sfm_cust_mac_connection |
| test_sfm_cust_siter | doctrine.dbal.test_sfm_cust_siter_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| customer | doctrine.orm.customer_entity_manager |
| test_sfm_cust_tpl | doctrine.orm.test_sfm_cust_tpl_entity_manager |
| test_sfm_cust_scheidegg | doctrine.orm.test_sfm_cust_scheidegg_entity_manager |
| test_sfm_cust_sturban | doctrine.orm.test_sfm_cust_sturban_entity_manager |
| test_sfm_cust_rosenweg | doctrine.orm.test_sfm_cust_rosenweg_entity_manager |
| test_sfm_cust_demo | doctrine.orm.test_sfm_cust_demo_entity_manager |
| test_sfm_cust_marienhaus | doctrine.orm.test_sfm_cust_marienhaus_entity_manager |
| test_sfm_cust_leuenmatt | doctrine.orm.test_sfm_cust_leuenmatt_entity_manager |
| test_sfm_cust_johanniter | doctrine.orm.test_sfm_cust_johanniter_entity_manager |
| test_sfm_cust_kontiki | doctrine.orm.test_sfm_cust_kontiki_entity_manager |
| test_sfm_cust_gaeu | doctrine.orm.test_sfm_cust_gaeu_entity_manager |
| test_sfm_cust_wasserturm | doctrine.orm.test_sfm_cust_wasserturm_entity_manager |
| test_sfm_cust_buchsifeld | doctrine.orm.test_sfm_cust_buchsifeld_entity_manager |
| test_sfm_cust_spz | doctrine.orm.test_sfm_cust_spz_entity_manager |
| test_sfm_cust_dahlia | doctrine.orm.test_sfm_cust_dahlia_entity_manager |
| test_sfm_cust_stniklaus | doctrine.orm.test_sfm_cust_stniklaus_entity_manager |
| test_sfm_cust_kastanienpark | doctrine.orm.test_sfm_cust_kastanienpark_entity_manager |
| test_sfm_cust_dahlia_oberfeld | doctrine.orm.test_sfm_cust_dahlia_oberfeld_entity_manager |
| test_sfm_cust_dahlia_zollbruck | doctrine.orm.test_sfm_cust_dahlia_zollbruck_entity_manager |
| test_sfm_cust_hasle | doctrine.orm.test_sfm_cust_hasle_entity_manager |
| test_sfm_cust_wng | doctrine.orm.test_sfm_cust_wng_entity_manager |
| test_sfm_cust_seewinkel | doctrine.orm.test_sfm_cust_seewinkel_entity_manager |
| test_sfm_cust_sonnenhof | doctrine.orm.test_sfm_cust_sonnenhof_entity_manager |
| test_sfm_cust_goldenberg | doctrine.orm.test_sfm_cust_goldenberg_entity_manager |
| test_sfm_cust_phsj | doctrine.orm.test_sfm_cust_phsj_entity_manager |
| test_sfm_cust_sue | doctrine.orm.test_sfm_cust_sue_entity_manager |
| test_sfm_cust_kirchfeld | doctrine.orm.test_sfm_cust_kirchfeld_entity_manager |
| test_sfm_cust_azw | doctrine.orm.test_sfm_cust_azw_entity_manager |
| test_sfm_cust_schaerme | doctrine.orm.test_sfm_cust_schaerme_entity_manager |
| test_sfm_cust_kurhaus | doctrine.orm.test_sfm_cust_kurhaus_entity_manager |
| test_sfm_cust_tabea | doctrine.orm.test_sfm_cust_tabea_entity_manager |
| test_sfm_cust_apzhb | doctrine.orm.test_sfm_cust_apzhb_entity_manager |
| test_sfm_cust_aphw | doctrine.orm.test_sfm_cust_aphw_entity_manager |
| test_sfm_cust_szn | doctrine.orm.test_sfm_cust_szn_entity_manager |
| test_sfm_cust_kunde01 | doctrine.orm.test_sfm_cust_kunde01_entity_manager |
| test_sfm_cust_retis | doctrine.orm.test_sfm_cust_retis_entity_manager |
| test_sfm_cust_wald | doctrine.orm.test_sfm_cust_wald_entity_manager |
| test_sfm_cust_lum_test | doctrine.orm.test_sfm_cust_lum_test_entity_manager |
| test_sfm_cust_tcs | doctrine.orm.test_sfm_cust_tcs_entity_manager |
| test_sfm_cust_wisler | doctrine.orm.test_sfm_cust_wisler_entity_manager |
| test_sfm_cust_ulme | doctrine.orm.test_sfm_cust_ulme_entity_manager |
| test_sfm_cust_eiche | doctrine.orm.test_sfm_cust_eiche_entity_manager |
| test_sfm_cust_maien | doctrine.orm.test_sfm_cust_maien_entity_manager |
| test_sfm_cust_mac | doctrine.orm.test_sfm_cust_mac_entity_manager |
| test_sfm_cust_siter | doctrine.orm.test_sfm_cust_siter_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| SmartFM\Entity\Main\User | 2 |
| SmartFM\Entity\Main\Customer | 1 |
| SmartFM\Entity\Main\SamlConfig | 1 |
customer entity manager
| Class | Amount of managed objects |
|---|---|
| SmartFM\Entity\Customer\GlobalNotification | 164 |
test_sfm_cust_tpl entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_scheidegg entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_sturban entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_rosenweg entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_demo entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_marienhaus entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_leuenmatt entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_johanniter entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_kontiki entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_gaeu entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_wasserturm entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_buchsifeld entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_spz entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_dahlia entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_stniklaus entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_kastanienpark entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_dahlia_oberfeld entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_dahlia_zollbruck entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_hasle entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_wng entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_seewinkel entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_sonnenhof entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_goldenberg entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_phsj entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_sue entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_kirchfeld entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_azw entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_schaerme entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_kurhaus entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_tabea entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_apzhb entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_aphw entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_szn entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_kunde01 entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_retis entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_wald entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_lum_test entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_tcs entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_wisler entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_ulme entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_eiche entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_maien entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_mac entity manager
| Class | Amount of managed objects |
|---|
test_sfm_cust_siter entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| SmartFM\Entity\Main\Helptext | No errors. |
| SmartFM\Entity\Main\User | No errors. |
| SmartFM\Entity\Main\Customer | No errors. |
| SmartFM\Entity\Main\Building | No errors. |
| SmartFM\Entity\Main\SamlConfig | No errors. |
| SmartFM\Entity\Main\BuildingGroup | No errors. |
customer entity manager
| Class | Mapping errors |
|---|---|
| SmartFM\Entity\Customer\GlobalNotification | No errors. |
test_sfm_cust_tpl entity manager
No loaded entities.
test_sfm_cust_scheidegg entity manager
No loaded entities.
test_sfm_cust_sturban entity manager
No loaded entities.
test_sfm_cust_rosenweg entity manager
No loaded entities.
test_sfm_cust_demo entity manager
No loaded entities.
test_sfm_cust_marienhaus entity manager
No loaded entities.
test_sfm_cust_leuenmatt entity manager
No loaded entities.
test_sfm_cust_johanniter entity manager
No loaded entities.
test_sfm_cust_kontiki entity manager
No loaded entities.
test_sfm_cust_gaeu entity manager
No loaded entities.
test_sfm_cust_wasserturm entity manager
No loaded entities.
test_sfm_cust_buchsifeld entity manager
No loaded entities.
test_sfm_cust_spz entity manager
No loaded entities.
test_sfm_cust_dahlia entity manager
No loaded entities.
test_sfm_cust_stniklaus entity manager
No loaded entities.
test_sfm_cust_kastanienpark entity manager
No loaded entities.
test_sfm_cust_dahlia_oberfeld entity manager
No loaded entities.
test_sfm_cust_dahlia_zollbruck entity manager
No loaded entities.
test_sfm_cust_hasle entity manager
No loaded entities.
test_sfm_cust_wng entity manager
No loaded entities.
test_sfm_cust_seewinkel entity manager
No loaded entities.
test_sfm_cust_sonnenhof entity manager
No loaded entities.
test_sfm_cust_goldenberg entity manager
No loaded entities.
test_sfm_cust_phsj entity manager
No loaded entities.
test_sfm_cust_sue entity manager
No loaded entities.
test_sfm_cust_kirchfeld entity manager
No loaded entities.
test_sfm_cust_azw entity manager
No loaded entities.
test_sfm_cust_schaerme entity manager
No loaded entities.
test_sfm_cust_kurhaus entity manager
No loaded entities.
test_sfm_cust_tabea entity manager
No loaded entities.
test_sfm_cust_apzhb entity manager
No loaded entities.
test_sfm_cust_aphw entity manager
No loaded entities.
test_sfm_cust_szn entity manager
No loaded entities.
test_sfm_cust_kunde01 entity manager
No loaded entities.
test_sfm_cust_retis entity manager
No loaded entities.
test_sfm_cust_wald entity manager
No loaded entities.
test_sfm_cust_lum_test entity manager
No loaded entities.
test_sfm_cust_tcs entity manager
No loaded entities.
test_sfm_cust_wisler entity manager
No loaded entities.
test_sfm_cust_ulme entity manager
No loaded entities.
test_sfm_cust_eiche entity manager
No loaded entities.
test_sfm_cust_maien entity manager
No loaded entities.
test_sfm_cust_mac entity manager
No loaded entities.
test_sfm_cust_siter entity manager
No loaded entities.