http://galab.api.dev.staging-env.de/api/order_requests?state=created

Query Metrics

3 Database Queries
3 Different statements
1.38 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.56 ms
(40.50%)
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.is_verified AS is_verified_6, t0.auth_token AS auth_token_7, t0.salutation AS salutation_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "galab-api@galab.de"
]
0.42 ms
(30.44%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_19 FROM (SELECT o0_.article_number AS article_number_0, o0_.state AS state_1, o0_.state_updated_at AS state_updated_at_2, o0_.organic AS organic_3, o0_.estimated_completion_date AS estimated_completion_date_4, o0_.created_by AS created_by_5, o0_.updated_by AS updated_by_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.customer_order_number AS customer_order_number_9, o0_.name AS name_10, o0_.order_details AS order_details_11, o0_.customer_product_number AS customer_product_number_12, o0_.batch_number AS batch_number_13, o0_.best_before AS best_before_14, o0_.comment AS comment_15, o0_.delivery_date AS delivery_date_16, o0_.deleted_at AS deleted_at_17, o0_.auth_token AS auth_token_18, o0_.id AS id_19 FROM order_request o0_ WHERE o0_.deleted_at IS NULL AND o0_.state = ? ORDER BY o0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  "created"
]
0.40 ms
(29.06%)
1
SELECT o0_.article_number AS article_number_0, o0_.state AS state_1, o0_.state_updated_at AS state_updated_at_2, o0_.organic AS organic_3, o0_.estimated_completion_date AS estimated_completion_date_4, o0_.created_by AS created_by_5, o0_.updated_by AS updated_by_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.customer_order_number AS customer_order_number_9, o0_.name AS name_10, o0_.order_details AS order_details_11, o0_.customer_product_number AS customer_product_number_12, o0_.batch_number AS batch_number_13, o0_.best_before AS best_before_14, o0_.comment AS comment_15, o0_.delivery_date AS delivery_date_16, o0_.deleted_at AS deleted_at_17, o0_.auth_token AS auth_token_18, o0_.id AS id_19 FROM order_request o0_ WHERE o0_.deleted_at IS NULL AND o0_.state = ? ORDER BY o0_.created_at DESC LIMIT 30
Parameters:
[
  "created"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Company
  • The mappings App\Entity\Company#preselectedAnalysisGroups and App\Entity\AnalysisServiceGroup#company are inconsistent with each other.
App\Entity\AnalysisServiceWeight No errors.
App\Entity\OrderRequest No errors.