Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.28 ms
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"
]
2 0.17 ms
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
]
3 0.17 ms
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
]
4 0.22 ms
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
]
5 0.15 ms
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
]
6 0.15 ms
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
]
7 0.14 ms
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
]
8 0.16 ms
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
]
9 0.15 ms
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
]
10 0.15 ms
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
]
11 0.15 ms
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:
[
  37
]
12 0.14 ms
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:
[
  37
]
13 0.13 ms
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:
[
  36
]
14 0.13 ms
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:
[
  38
]
15 0.16 ms
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:
[
  21
]
16 0.14 ms
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:
[
  38
]
17 0.14 ms
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:
[
  33
]
18 0.12 ms
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:
[
  39
]
19 0.13 ms
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:
[
  39
]
20 0.13 ms
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:
[
  34
]
21 0.14 ms
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:
[
  43
]
22 0.16 ms
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:
[
  43
]
23 0.15 ms
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:
[
  44
]
24 0.13 ms
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:
[
  44
]
25 0.12 ms
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:
[
  45
]
26 0.14 ms
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:
[
  45
]
27 0.13 ms
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:
[
  41
]
28 0.12 ms
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:
[
  23
]
29 0.13 ms
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:
[
  41
]
30 0.12 ms
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:
[
  42
]
31 0.15 ms
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:
[
  42
]
32 0.12 ms
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:
[
  45
]
33 0.15 ms
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:
[
  45
]
34 0.12 ms
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:
[
  44
]
35 0.13 ms
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:
[
  44
]
36 0.12 ms
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:
[
  43
]
37 0.13 ms
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:
[
  43
]
38 0.14 ms
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:
[
  46
]
39 0.14 ms
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:
[
  46
]
40 0.13 ms
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
]
41 0.19 ms
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:
[
  21
  0
  1
]
42 0.13 ms
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:
[
  47
]
43 0.13 ms
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:
[
  47
]
44 0.14 ms
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:
[
  48
]
45 0.14 ms
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:
[
  48
]
46 0.13 ms
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:
[
  51
]
47 0.13 ms
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:
[
  51
]
48 0.12 ms
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:
[
  21
]

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