Query Metrics
8
Database Queries
7
Different statements
1.49 ms
Query time
0
Invalid entities
30
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.43 ms (28.64%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.mobile AS mobile_6, t0.imagefilename AS imagefilename_7, t0.showname AS showname_8, t0.leftmenuclose AS leftmenuclose_9, t0.expiredate AS expiredate_10, t0.dbcon AS dbcon_11, t0.dbsite AS dbsite_12, t0.dbname AS dbname_13, t0.dbuser AS dbuser_14, t0.dbpass AS dbpass_15, t0.lastins AS lastins_16, t0.chkenable AS chkenable_17, t0.dbfolder AS dbfolder_18, t0.homeid AS homeid_19, t0.dbversion AS dbversion_20, t0.pinkey AS pinkey_21, t0.tenant_id AS tenant_id_22 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.33 ms (22.16%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.apickkey AS apickkey_4, t0.apicskey AS apicskey_5, t0.dayback AS dayback_6, t0.courierspeedex AS courierspeedex_7, t0.couriergeniki AS couriergeniki_8, t0.courieracs AS courieracs_9, t0.couriercenter AS couriercenter_10, t0.courierboxnow AS courierboxnow_11, t0.sitenr AS sitenr_12, t0.barcode AS barcode_13, t0.expiredate AS expiredate_14, t0.imagewww AS imagewww_15, t0.lastins AS lastins_16, t0.sms AS sms_17, t0.couriersvuum AS couriersvuum_18, t0.eispraksibankautoclose AS eispraksibankautoclose_19, t0.minordernumberforeispraksis AS minordernumberforeispraksis_20, t0.wswoocapital AS wswoocapital_21, t0.wswoosoftone AS wswoosoftone_22, t0.wooactive AS wooactive_23, t0.chk AS chk_24, t0.skroutzactive AS skroutzactive_25, t0.pluginactive AS pluginactive_26, t0.xwan AS xwan_27, t0.timetracker AS timetracker_28 FROM tenant t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
0.24 ms (15.86%) |
1 |
SHOW TABLES LIKE 'dbversion';
Parameters:
[] |
|
0.15 ms (10.04%) |
1 |
SELECT timetrackertask.startdate AS date, custname.name AS customer, timetrackertask.name, timetrackerproject.name AS project, timetrackertask.starttime AS start, timetrackertask.worktime AS time, timetrackertask.id, timetrackertask.color, timetrackertask.status, timetrackerstatus.name AS statusname, custname.id AS custid FROM `timetrackertask` INNER JOIN timetrackerproject ON timetrackertask.project_id=timetrackerproject.id LEFT JOIN custname ON timetrackertask.custid=custname.id LEFT JOIN timetrackerstatus ON timetrackerstatus.linenr=timetrackertask.status WHERE timetrackertask.startdate='2025-12-19' GROUP BY timetrackertask.id ORDER BY timetrackertask.starttime ASC;
Parameters:
[] |
|
0.14 ms (9.05%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.worktime AS worktime_3, t0.price AS price_4, t0.disc AS disc_5, t0.showweb AS showweb_6, t0.notes AS notes_7, t0.adminnotes AS adminnotes_8, t0.erpcode AS erpcode_9, t0.status AS status_10, t0.lastins AS lastins_11, t0.project AS project_12, t0.color AS color_13 FROM timetrackersourcetask t0 ORDER BY t0.name ASC
Parameters:
[] |
|
0.12 ms (8.23%) |
1 |
SELECT t0.id AS id_1, t0.groupid AS groupid_2, t0.linenr AS linenr_3, t0.name AS name_4 FROM timetrackerstatus t0 WHERE t0.groupid = ?
Parameters:
[
1
]
|
|
0.09 ms (6.02%) |
1 |
SELECT version FROM dbversion WHERE id=1;
Parameters:
[] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Timetrackersourcetask | 20 |
| App\Entity\Timetrackerstatus | 7 |
| App\Entity\Tenant | 2 |
| App\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Tenant | No errors. |
| App\Entity\Timetrackerstatus | No errors. |
| App\Entity\Timetrackersourcetask | No errors. |
| App\Entity\Timetrackertask | No errors. |