Query Metrics
4
Database Queries
4
Different statements
69.34 ms
Query time
0
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 7.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.backend_type AS backend_type_7, t0.backend_id AS backend_id_8, t0.profile_key AS profile_key_9, t0.owner_id AS owner_id_10, t0.agent_id AS agent_id_11 FROM printer t0 WHERE t0.backend_type = ? AND t0.backend_id = ? LIMIT 1
Parameters:
[ "sunmi" "N449255G10924" ]
|
||||||||||||||||||||||||||
| 2 | 0.36 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 3 | 60.87 ms |
INSERT INTO print_job (id, external_id, status, payload, error_message, created_at, updated_at, completed_at, printer_id, owner_id, template_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ b"\x1DÊŸ´ì6Gý¹\x15Ó\x03²>ô’" "JOB_1769171801_SM3M" "queued" "{"tradeNo":"JOB_1769171801_SM3M","channel":"sunmi","mode":"template","widthMm":80,"templateId":"receipt-medium","createdAt":"2026-01-23T12:36:42.219Z","data":{"sale":{"id":287373,"receipt":"2220010284","orderNumber":"6971","uuid":"d969d61c-8e62-48d1-b13a-a10139af2bac","status":"Completed","isRefund":false,"isCredited":false,"isPrepay":false,"totalAmount":49,"totalVat":9.8,"totalChange":0,"totalPayment":49,"currency":"DKK","createdAt":"2026-01-23 13:36:16","paidAt":"2026-01-23 13:36:39","dueAt":"2026-01-23 13:36:39","note":null},"locationRegister":{"id":1645,"name":"Kasse 1","printReceipt":true,"emailReceipt":true},"location":{"id":1650,"name":"Democratic Eyewear Odense ApS","street":"Klaregade 7","postcode":"5000","city":"Odense","country":"Danmark","phone":"+4571705000","email":"odense@democraticeyewear.com","website":null,"companyRegistration":"41075805"},"customer":null,"seller":{"id":5920,"firstname":"Dorthe","lastname":"Skjoldager","fullname":"Dorthe Skjoldager","title":"Optiker","email":"dts@democraticeyewear.com","phone":"4527599525","website":null},"items":[{"id":692147,"text":"SeeGreen Brillerens 118ml","quantity":1,"unitPrice":49,"total":49,"vatAmount":9.8,"subtotal":39.2,"type":"product","note":null,"product":{"id":129557,"name":"SeeGreen Brillerens 118ml","sku":null,"storeLocation":null,"receiptText":null},"variant":{"id":116983,"sku":"1001103858","name":"","friendlyName":"SeeGreen Brillerens 118ml","barcode":null,"internalRef":null},"supplier":null}],"payments":[{"id":147576,"amount":49,"changeAmount":null,"type":null,"method":{"id":2214,"name":"Kort OD","type":"verifone-p400"}}]},"printer":{"sunmi_sn":"N449255G10924","orderType":1,"count":1,"mediaText":"","cycle":1},"sunmiResponse":{"code":1,"data":{"trade_no":"JOB_1769171801_SM3M"},"msg":"success"},"electronResponse":null,"voiceResponse":null,"saleId":"1ec0da0c-67ba-4819-9d18-807cc819363f","url":"https:\/\/print.beastscan.com\/sales\/2026\/01\/23\/1ec0da0c-67ba-4819-9d18-807cc819363f.html","view":{"receiptUrl":"https:\/\/print.beastscan.com\/view.html?yyyy=2026&mm=01&dd=23&id=1ec0da0c-67ba-4819-9d18-807cc819363f&type=receipt","invoiceUrl":"https:\/\/print.beastscan.com\/view.html?yyyy=2026&mm=01&dd=23&id=1ec0da0c-67ba-4819-9d18-807cc819363f&type=invoice"}}" null "2026-01-23 12:36:42" "2026-01-23 12:36:42" null b""" 9˜‹s\n \fH›µEOAô:~´ """ 1 null ]
|
||||||||||||||||||||||||||
| 4 | 0.75 ms |
"COMMIT"
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\Printer | 1 |
| App\Entity\User | 1 |
| App\Entity\PrintJob | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Printer | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\PrintJob | No errors. |
| App\Entity\Template | No errors. |