http://menu.app.deepideas.digital/job/current?import_id=5277&project_id=3105

Query Metrics

8 Database Queries
5 Different statements
30.21 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.