Query Metrics
8
Database Queries
5
Different statements
30.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
9.18 ms (30.39%) |
1 |
SELECT s0_.id AS id_0, s0_.project_id AS project_id_1, s0_.import_id AS import_id_2, s0_.hash AS hash_3, s0_.created AS created_4, s0_.created_by AS created_by_5, s0_.modified AS modified_6, s0_.modified_by AS modified_by_7, s0_.content AS content_8, s0_.export AS export_9, s0_.hash_params AS hash_params_10, s0_.deleted AS deleted_11, s0_.deleted_by AS deleted_by_12, s0_.deleted_at AS deleted_at_13 FROM metro_menu_engineering.snapshot s0_ WHERE s0_.project_id = ? AND s0_.import_id = ? ORDER BY s0_.created DESC
Parameters:
[ "3105" "5277" ] |
|
8.66 ms (28.65%) |
4 |
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.import_id AS import_id_3, t0.item_id AS item_id_4, t0.item_name AS item_name_5, t0.quantity AS quantity_6, t0.sum_net AS sum_net_7, t0.price_gross AS price_gross_8, t0.category AS category_9, t0.super_category AS super_category_10, t0.cogs_net AS cogs_net_11, t0.export AS export_12, t0.alternative_name AS alternative_name_13, t0.created AS created_14, t0.modified AS modified_15 FROM metro_menu_engineering.import_order_summary t0 WHERE t0.project_id = ? AND t0.import_id = ?
Parameters:
[ "3105" "5277" ] |
|
6.44 ms (21.31%) |
1 |
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.import_id AS import_id_3, t0.item_id AS item_id_4, t0.item_name AS item_name_5, t0.quantity AS quantity_6, t0.sum_net AS sum_net_7, t0.price_gross AS price_gross_8, t0.category AS category_9, t0.super_category AS super_category_10, t0.cogs_net AS cogs_net_11, t0.export AS export_12, t0.alternative_name AS alternative_name_13, t0.created AS created_14, t0.modified AS modified_15 FROM metro_menu_engineering.import_order_summary t0 WHERE t0.project_id = ? AND t0.import_id = ? ORDER BY t0.created DESC
Parameters:
[ "3105" "5277" ] |
|
4.03 ms (13.32%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.active AS active_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.language AS language_7, t0.country_id AS country_id_8, t0.user_role AS user_role_9, t0.export AS export_10, t0.modified AS modified_11, t0.created AS created_12, t0.team_id AS team_id_13 FROM metro_menu_engineering.user t0 WHERE t0.id = ?
Parameters:
[
43
]
|
|
1.91 ms (6.33%) |
1 |
SELECT t0.id AS id_1, t0.project_id AS project_id_2, t0.created AS created_3, t0.created_by AS created_by_4, t0.number_imported_orders AS number_imported_orders_5, t0.description AS description_6, t0.active AS active_7, t0.status_id AS status_id_8, t0.start_date AS start_date_9, t0.end_date AS end_date_10, t0.overhead_costs AS overhead_costs_11, t0.default_cogs_net AS default_cogs_net_12, t0.start_date_analysis AS start_date_analysis_13, t0.end_date_analysis AS end_date_analysis_14, t0.type AS type_15, t0.export AS export_16, t0.cash_register_id AS cash_register_id_17, t0.modified AS modified_18 FROM metro_menu_engineering.import t0 WHERE t0.id = ?
Parameters:
[
"5277"
]
|
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\Team | No errors. |
| App\Entity\ImportOrderSummary | No errors. |
| App\Entity\Snapshot | No errors. |
| App\Entity\Import | No errors. |