Query Metrics

83 Database Queries
13 Different statements
96.32 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.19 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.civility AS civility_5, t0.first_name AS first_name_6, t0.email AS email_7, t0.description AS description_8, t0.phone AS phone_9, t0.second_phone AS second_phone_10, t0.adress AS adress_11, t0.country AS country_12, t0.region AS region_13, t0.city AS city_14, t0.zip AS zip_15, t0.type AS type_16, t0.is_verified AS is_verified_17, t0.created_at AS created_at_18, t0.is_blocked AS is_blocked_19, t0.blocked_at AS blocked_at_20, t0.unblocked_at AS unblocked_at_21, t0.block_reason AS block_reason_22, t0.blocked_hours AS blocked_hours_23, t0.client_type AS client_type_24, t0.supplier_id AS supplier_id_25, t0.promotion_id AS promotion_id_26, t0.group_user_id AS group_user_id_27, t0.user_post_id AS user_post_id_28 FROM `users` t0 WHERE t0.id = ?
Parameters:
[
  65007
]
2 17.34 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM produit_declination_value p0_ LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id LEFT JOIN produit p2_ ON p0_.produit_id = p2_.id WHERE UPPER(p0_.reference) LIKE ? AND (s1_.qt_stock - s1_.qt_reserved) >= 1 AND p2_.deleted_at IS NULL
Parameters:
[
  "EN%"
]
3 21.54 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.description AS description_3, p0_.buying_price_ht AS buying_price_ht_4, p0_.buying_price_ttc AS buying_price_ttc_5, p0_.price_ht AS price_ht_6, p0_.created_at AS created_at_7, p0_.uuid AS uuid_8, p0_.produit_id AS produit_id_9 FROM produit_declination_value p0_ LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id LEFT JOIN produit p2_ ON p0_.produit_id = p2_.id WHERE UPPER(p0_.reference) LIKE ? AND (s1_.qt_stock - s1_.qt_reserved) >= 1 AND p2_.deleted_at IS NULL ORDER BY p0_.created_at DESC LIMIT 20
Parameters:
[
  "EN%"
]
4 15.28 ms
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.description AS description_3, p0_.buying_price_ht AS buying_price_ht_4, p0_.buying_price_ttc AS buying_price_ttc_5, p0_.price_ht AS price_ht_6, p0_.created_at AS created_at_7, p0_.uuid AS uuid_8, p0_.produit_id AS produit_id_9 FROM produit_declination_value p0_ LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id LEFT JOIN produit p2_ ON p0_.produit_id = p2_.id WHERE UPPER(p0_.reference) LIKE ? AND (s1_.qt_stock - s1_.qt_reserved) >= 1 AND p2_.deleted_at IS NULL ORDER BY p0_.created_at DESC LIMIT 20
Parameters:
[
  "EN%"
]
5 7.55 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM produit_declination_value p0_ LEFT JOIN stock s1_ ON p0_.id = s1_.declination_produit_id LEFT JOIN produit p2_ ON p0_.produit_id = p2_.id WHERE UPPER(p0_.reference) LIKE ? AND (s1_.qt_stock - s1_.qt_reserved) >= 1 AND p2_.deleted_at IS NULL
Parameters:
[
  "EN%"
]
6 0.46 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17817
]
7 0.43 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17817
]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.display_in_filter AS display_in_filter_4 FROM declination t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.display_in_filter AS display_in_filter_4 FROM declination t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  7
]
11 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  66
]
12 0.51 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.usual_quantity AS usual_quantity_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.price_ttc AS price_ttc_9, t0.unit AS unit_10, t0.is_stock AS is_stock_11, t0.is_declination AS is_declination_12, t0.created_at AS created_at_13, t0.uuid AS uuid_14, t0.information AS information_15, t0.is_archived AS is_archived_16, t0.deleted_at AS deleted_at_17, t0.reason_of_delete AS reason_of_delete_18, t0.best_selection AS best_selection_19, t0.material AS material_20, t0.supplier_reference AS supplier_reference_21, t0.meta_description AS meta_description_22, t0.show_in_web_site AS show_in_web_site_23, t0.buy_tva_id AS buy_tva_id_24, t0.categories_id AS categories_id_25, t0.tva_id AS tva_id_26, t0.promotion_id AS promotion_id_27, t0.supplier_id AS supplier_id_28 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  1343
]
13 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5, t0.created_at AS created_at_6, t0.discount_type AS discount_type_7, t0.discount_value AS discount_value_8, t0.code AS code_9, t0.total_quantity AS total_quantity_10, t0.quantity_user AS quantity_user_11, t0.is_enabled AS is_enabled_12, t0.type AS type_13 FROM promotion t0 WHERE t0.id = ?
Parameters:
[
  9
]
14 1.05 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17817
]
15 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM group_user t0 WHERE t0.id = ?
Parameters:
[
  3
]
16 1.05 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.module_code AS module_code_4, t0.module_name AS module_name_5, t0.description AS description_6, t0.module_order AS module_order_7 FROM `right` t0 INNER JOIN right_group_user ON t0.id = right_group_user.right_id WHERE right_group_user.group_user_id = ?
Parameters:
[
  3
]
17 0.42 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17818
]
18 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17818
]
19 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  68
]
20 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17818
]
21 0.41 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17819
]
22 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17819
]
23 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  70
]
24 0.52 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17819
]
25 0.40 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17820
]
26 0.37 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17820
]
27 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  72
]
28 0.41 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17820
]
29 0.41 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17715
]
30 0.41 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17715
]
31 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  5
]
32 0.44 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.usual_quantity AS usual_quantity_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.price_ttc AS price_ttc_9, t0.unit AS unit_10, t0.is_stock AS is_stock_11, t0.is_declination AS is_declination_12, t0.created_at AS created_at_13, t0.uuid AS uuid_14, t0.information AS information_15, t0.is_archived AS is_archived_16, t0.deleted_at AS deleted_at_17, t0.reason_of_delete AS reason_of_delete_18, t0.best_selection AS best_selection_19, t0.material AS material_20, t0.supplier_reference AS supplier_reference_21, t0.meta_description AS meta_description_22, t0.show_in_web_site AS show_in_web_site_23, t0.buy_tva_id AS buy_tva_id_24, t0.categories_id AS categories_id_25, t0.tva_id AS tva_id_26, t0.promotion_id AS promotion_id_27, t0.supplier_id AS supplier_id_28 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  1333
]
33 0.43 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17715
]
34 0.40 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17716
]
35 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17716
]
36 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17716
]
37 0.40 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17718
]
38 0.37 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17718
]
39 0.45 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17718
]
40 0.40 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17719
]
41 0.51 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17719
]
42 0.54 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17719
]
43 0.37 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17723
]
44 0.44 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17723
]
45 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  19
]
46 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  74
]
47 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17723
]
48 0.39 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17647
]
49 0.38 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17647
]
50 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  2
]
51 0.62 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.usual_quantity AS usual_quantity_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.price_ttc AS price_ttc_9, t0.unit AS unit_10, t0.is_stock AS is_stock_11, t0.is_declination AS is_declination_12, t0.created_at AS created_at_13, t0.uuid AS uuid_14, t0.information AS information_15, t0.is_archived AS is_archived_16, t0.deleted_at AS deleted_at_17, t0.reason_of_delete AS reason_of_delete_18, t0.best_selection AS best_selection_19, t0.material AS material_20, t0.supplier_reference AS supplier_reference_21, t0.meta_description AS meta_description_22, t0.show_in_web_site AS show_in_web_site_23, t0.buy_tva_id AS buy_tva_id_24, t0.categories_id AS categories_id_25, t0.tva_id AS tva_id_26, t0.promotion_id AS promotion_id_27, t0.supplier_id AS supplier_id_28 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  1328
]
52 0.46 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17647
]
53 0.37 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17648
]
54 0.37 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17648
]
55 0.44 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17648
]
56 0.38 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17649
]
57 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17649
]
58 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17649
]
59 0.39 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17650
]
60 0.37 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17650
]
61 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.declination_id AS declination_id_4, t0.parent_id AS parent_id_5 FROM value_declination t0 WHERE t0.id = ?
Parameters:
[
  26
]
62 0.39 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17650
]
63 0.42 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17651
]
64 0.35 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17651
]
65 0.39 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17651
]
66 0.38 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17652
]
67 0.37 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17652
]
68 0.41 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17652
]
69 0.40 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17653
]
70 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17653
]
71 0.64 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17653
]
72 0.37 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17654
]
73 0.36 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17654
]
74 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17654
]
75 0.37 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17655
]
76 0.47 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17655
]
77 0.40 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17655
]
78 0.35 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17656
]
79 0.35 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17656
]
80 0.37 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17656
]
81 0.41 ms
SELECT t0.id AS id_1, t0.qt_stock AS qt_stock_2, t0.qt_reserved AS qt_reserved_3, t0.storehouse AS storehouse_4, t0.produit_id AS produit_id_5, t0.declination_produit_id AS declination_produit_id_6 FROM stock t0 WHERE t0.declination_produit_id = ?
Parameters:
[
  17657
]
82 0.43 ms
SELECT t0.id AS id_1, t0.produit_declination_id AS produit_declination_id_2, t0.declination_id AS declination_id_3, t0.value_id AS value_id_4 FROM group_declination_value t0 WHERE t0.produit_declination_id = ?
Parameters:
[
  17657
]
83 0.43 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.updated_at AS updated_at_3, t0.image_size AS image_size_4, t0.is_selected AS is_selected_5 FROM file t0 INNER JOIN produit_declination_value_file ON t0.id = produit_declination_value_file.file_id WHERE produit_declination_value_file.produit_declination_value_id = ?
Parameters:
[
  17657
]

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\Supplier No errors.
App\Entity\Promotion No errors.
App\Entity\GroupUser No errors.
App\Entity\UserPost No errors.
App\Entity\Link No errors.
App\Entity\Document No errors.
App\Entity\Address No errors.
App\Entity\Comment No errors.
App\Entity\Activity No errors.
App\Entity\Produit
  • The field App\Entity\Produit#promotionHistories is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProduitPromotionHistory#product does not contain the required 'inversedBy="promotionHistories"' attribute.
App\Entity\ProduitDeclinationValue No errors.
App\Entity\Stock No errors.
App\Entity\File No errors.
App\Entity\DocumentDeclinationProduit No errors.
App\Entity\Pack No errors.
App\Entity\GroupDeclinationValue No errors.
App\Entity\Declination No errors.
App\Entity\ValueDeclination No errors.
App\Entity\Tva No errors.
App\Entity\Category No errors.
App\Entity\Tag No errors.
App\Entity\DocumentProduit No errors.
App\Entity\ProduitPromotionHistory No errors.
App\Entity\Right No errors.