GET https://ceres.t10central.de/label-review

Query Metrics

7 Database Queries
5 Different statements
3.32 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.password AS password_4, t0.roles AS roles_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  5
]
2 0.58 ms
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.processing_state = ? ORDER BY t0.uploaded_at ASC
Parameters:
[
  "proposed"
]
3 0.56 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.active AS active_4, t0.shopware_article_id AS shopware_article_id_5, t0.shopware_detail_id AS shopware_detail_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.species_id AS species_id_9, t10.id AS id_11, t10.confidence AS confidence_12, t10.last_updated_at AS last_updated_at_13, t10.source AS source_14, t10.created_at AS created_at_15, t10.updated_at AS updated_at_16, t10.article_id AS article_id_17, t10.last_updated_by_id AS last_updated_by_id_18, t0.weighted_mean_group_id AS weighted_mean_group_id_19 FROM article t0 LEFT JOIN mixture t10 ON t10.article_id = t0.id WHERE t0.id = ?
Parameters:
[
  573
]
4 0.62 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.active AS active_4, t0.shopware_article_id AS shopware_article_id_5, t0.shopware_detail_id AS shopware_detail_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.species_id AS species_id_9, t10.id AS id_11, t10.confidence AS confidence_12, t10.last_updated_at AS last_updated_at_13, t10.source AS source_14, t10.created_at AS created_at_15, t10.updated_at AS updated_at_16, t10.article_id AS article_id_17, t10.last_updated_by_id AS last_updated_by_id_18, t0.weighted_mean_group_id AS weighted_mean_group_id_19 FROM article t0 LEFT JOIN mixture t10 ON t10.article_id = t0.id WHERE t0.id = ?
Parameters:
[
  374
]
5 0.39 ms
SELECT a0_.sku AS sku_0, a0_.name AS name_1 FROM article a0_ WHERE a0_.sku IN (?, ?)
Parameters:
[
  "57718"
  "623927"
]
6 0.36 ms
SELECT l0_.processing_state AS processing_state_0, COUNT(l0_.id) AS sclr_1 FROM label_image l0_ GROUP BY l0_.processing_state
Parameters:
[]
7 0.40 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.password AS password_4, t0.roles AS roles_5, t0.active AS active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\LabelImage 3
App\Entity\User 2
App\Entity\Article 2
App\Entity\WeightedMeanGroup 1
App\Entity\Mixture 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\LabelImage No errors.
App\Entity\Article No errors.
App\Entity\Species No errors.
App\Entity\Mixture No errors.
App\Entity\WeightedMeanGroup No errors.
App\Entity\MixtureComponent No errors.