0.40 ms (10.37%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token_hash AS token_hash_3, t0.scopes AS scopes_4, t0.last_used_at AS last_used_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM api_token t0 WHERE t0.token_hash = ? LIMIT 1
Parameters: [
"5bd7fc4f731500714b31989c9de464204c5fc2e82469af5da225cb50519010a3"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.token_hash AS token_hash_3, t0.scopes AS scopes_4, t0.last_used_at AS last_used_at_5, t0.expires_at AS expires_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_id AS user_id_9 FROM api_token t0 WHERE t0.token_hash = '5bd7fc4f731500714b31989c9de464204c5fc2e82469af5da225cb50519010a3' LIMIT 1;
|
0.33 ms (8.39%)
|
1 |
UPDATE label_image SET processing_state = ?, n8n_workflow_execution_id = ?, extracted_data = ? WHERE id = ?
Parameters: [
"proposed"
"413812"
"{"ocrText":"RSM 2.3 Gebrauchs- Spielrasen mit Poa Supina. 10kg\n20% Lolium perenne Esquire\n10% Lolium perenne Turfgold\n10% Festuca rubra rubra Corail\n10% Festuca rubra trichophylla Samanta\n15% Festuca rubra commutata Mahindra\n10% Poa pratensis Miracle\n20% Poa pratensis Yvette\n5% Poa Supina Suprem 1.Quali\nVerschluss 04\/2026 DE05-5600816\nANDERE VERWENDUNGSZWECKE\nKleinpackung EG B\nD-560\/BN","detectedSku":"","confidence":0.5,"articleCandidates":[],"varieties":[{"rawName":"Lolium perenne Esquire","artCode":"WD","kennNr":1425,"percentage":20},{"rawName":"Lolium perenne Turfgold","artCode":"WD","kennNr":1291,"percentage":10},{"rawName":"Festuca rubra rubra Corail","artCode":"","kennNr":0,"percentage":10},{"rawName":"Festuca rubra trichophylla Samanta","artCode":"","kennNr":0,"percentage":10},{"rawName":"Festuca rubra commutata Mahindra","artCode":"","kennNr":0,"percentage":15},{"rawName":"Poa pratensis Miracle","artCode":"WRP","kennNr":245,"percentage":10},{"rawName":"Poa pratensis Yvette","artCode":"WRP","kennNr":403,"percentage":20},{"rawName":"Poa Supina Suprem 1.Quali","artCode":"RIS","kennNr":45,"percentage":5}]}"
14
]
UPDATE label_image SET processing_state = 'proposed', n8n_workflow_execution_id = '413812', extracted_data = '{\"ocrText\":\"RSM 2.3 Gebrauchs- Spielrasen mit Poa Supina. 10kg\\n20% Lolium perenne Esquire\\n10% Lolium perenne Turfgold\\n10% Festuca rubra rubra Corail\\n10% Festuca rubra trichophylla Samanta\\n15% Festuca rubra commutata Mahindra\\n10% Poa pratensis Miracle\\n20% Poa pratensis Yvette\\n5% Poa Supina Suprem 1.Quali\\nVerschluss 04\\/2026 DE05-5600816\\nANDERE VERWENDUNGSZWECKE\\nKleinpackung EG B\\nD-560\\/BN\",\"detectedSku\":\"\",\"confidence\":0.5,\"articleCandidates\":[],\"varieties\":[{\"rawName\":\"Lolium perenne Esquire\",\"artCode\":\"WD\",\"kennNr\":1425,\"percentage\":20},{\"rawName\":\"Lolium perenne Turfgold\",\"artCode\":\"WD\",\"kennNr\":1291,\"percentage\":10},{\"rawName\":\"Festuca rubra rubra Corail\",\"artCode\":\"\",\"kennNr\":0,\"percentage\":10},{\"rawName\":\"Festuca rubra trichophylla Samanta\",\"artCode\":\"\",\"kennNr\":0,\"percentage\":10},{\"rawName\":\"Festuca rubra commutata Mahindra\",\"artCode\":\"\",\"kennNr\":0,\"percentage\":15},{\"rawName\":\"Poa pratensis Miracle\",\"artCode\":\"WRP\",\"kennNr\":245,\"percentage\":10},{\"rawName\":\"Poa pratensis Yvette\",\"artCode\":\"WRP\",\"kennNr\":403,\"percentage\":20},{\"rawName\":\"Poa Supina Suprem 1.Quali\",\"artCode\":\"RIS\",\"kennNr\":45,\"percentage\":5}]}' WHERE id = 14;
|
0.30 ms (7.60%)
|
1 |
SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.storage_path AS storage_path_3, t0.mime_type AS mime_type_4, t0.size_bytes AS size_bytes_5, t0.uploaded_at AS uploaded_at_6, t0.processing_state AS processing_state_7, t0.n8n_workflow_execution_id AS n8n_workflow_execution_id_8, t0.extracted_data AS extracted_data_9, t0.error_message AS error_message_10, t0.article_id AS article_id_11, t0.uploaded_by_id AS uploaded_by_id_12 FROM label_image t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.original_filename AS original_filename_2, t0.storage_path AS storage_path_3, t0.mime_type AS mime_type_4, t0.size_bytes AS size_bytes_5, t0.uploaded_at AS uploaded_at_6, t0.processing_state AS processing_state_7, t0.n8n_workflow_execution_id AS n8n_workflow_execution_id_8, t0.extracted_data AS extracted_data_9, t0.error_message AS error_message_10, t0.article_id AS article_id_11, t0.uploaded_by_id AS uploaded_by_id_12 FROM label_image t0 WHERE t0.id = 14;
|