Query Metrics

48 Database Queries
11 Different statements
6.90 ms Query time
0 Invalid entities
56 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.25 ms
(18.09%)
9
SELECT t0.id AS id_1, t0.qty AS qty_2, t0.option_id AS option_id_3, t0.ingredient_id AS ingredient_id_4 FROM option_ingredient t0 WHERE t0.option_id = ?
Parameters:
[
  36
]
1.15 ms
(16.62%)
9
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived AS archived_3, t0.label AS label_4, t0.category_id AS category_id_5 FROM option t0 WHERE t0.id = ?
Parameters:
[
  36
]
1.12 ms
(16.28%)
8
SELECT t0.id AS id_1, t0.price AS price_2, t0.price_uber AS price_uber_3, t0.product_id AS product_id_4, t0.option_id AS option_id_5 FROM product_option t0 WHERE t0.product_id = ?
Parameters:
[
  42
]
1.10 ms
(15.99%)
8
SELECT t0.id AS id_1, t0.qty AS qty_2, t0.product_id AS product_id_3, t0.ingredient_id AS ingredient_id_4 FROM product_ingredient t0 WHERE t0.product_id = ?
Parameters:
[
  42
]
0.54 ms
(7.85%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.qtymidi AS qtymidi_3, t0.qtysoir AS qtysoir_4, t0.qtyprevmidi AS qtyprevmidi_5, t0.qtyprevsoir AS qtyprevsoir_6, t0.archived AS archived_7, t0.category_id AS category_id_8 FROM ingredient t0 WHERE t0.id = ?
Parameters:
[
  35
]
0.44 ms
(6.45%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived AS archived_3, t0.label AS label_4, t0.min_options AS min_options_5, t0.max_options AS max_options_6 FROM option_category t0 WHERE t0.id = ?
Parameters:
[
  22
]
0.42 ms
(6.03%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.archived AS archived_3, t0.price AS price_4, t0.price_uber AS price_uber_5, t0.reservable AS reservable_6, t0.image AS image_7, t0.description AS description_8, t0.default_options AS default_options_9, t0.tva_rate AS tva_rate_10, t0.hiboutik_id AS hiboutik_id_11, t0.uber_enabled AS uber_enabled_12, t0.cnc_enabled AS cnc_enabled_13, t0.category_id AS category_id_14 FROM product t0 WHERE t0.category_id = ? AND t0.archived = ? AND t0.cnc_enabled = ?
Parameters:
[
  20
  0
  1
]
0.28 ms
(4.06%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.base_price AS base_price_3, t0.base_price_uber AS base_price_uber_4, t0.archived AS archived_5, t0.category_id AS category_id_6 FROM formule t0 WHERE t0.id = ?
Parameters:
[
  "23"
]
0.25 ms
(3.61%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.archived AS archived_4 FROM product_category t0 WHERE t0.id = ?
Parameters:
[
  20
]
0.17 ms
(2.51%)
1
SELECT t0.id AS id_1, t0.formule_id AS formule_id_2, t0.product_id AS product_id_3 FROM formule_excluded_product t0 WHERE t0.formule_id = ?
Parameters:
[
  23
]
0.17 ms
(2.51%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.excluded_product_ids AS excluded_product_ids_4, t0.extra_prices AS extra_prices_5, t0.extra_prices_uber AS extra_prices_uber_6, t0.formule_id AS formule_id_7, t0.category_id AS category_id_8 FROM formule_slot t0 WHERE t0.formule_id = ?
Parameters:
[
  23
]

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\ProductOption 21
App\Entity\Option 9
App\Entity\Product 8
App\Entity\OptionIngredient 4
App\Entity\Ingredient 4
App\Entity\OptionCategory 3
App\Entity\ProductCategory 2
App\Entity\FormuleSlot 2
App\Entity\IngredientCategory 2
App\Entity\Formule 1