Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.fname AS fname_5,
  t0.lname AS lname_6,
  t0.username AS username_7,
  t0.creation_date AS creation_date_8,
  t0.edition_date AS edition_date_9,
  t0.target AS target_10,
  t0.is_synch AS is_synch_11,
  t0.deleted AS deleted_12,
  t0.profile_id AS profile_id_13,
  t0.currentshop_id AS currentshop_id_14
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.fname AS fname_5, t0.lname AS lname_6, t0.username AS username_7, t0.creation_date AS creation_date_8, t0.edition_date AS edition_date_9, t0.target AS target_10, t0.is_synch AS is_synch_11, t0.deleted AS deleted_12, t0.profile_id AS profile_id_13, t0.currentshop_id AS currentshop_id_14 FROM `user` t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.code AS code_3,
  t0.creation_date AS creation_date_4
FROM
  shop t0
  INNER JOIN user_shop ON t0.id = user_shop.shop_id
WHERE
  user_shop.user_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.creation_date AS creation_date_4 FROM shop t0 INNER JOIN user_shop ON t0.id = user_shop.shop_id WHERE user_shop.user_id = 5;

SELECT
  t0.id AS id_1,
  t0.barcode AS barcode_2,
  t0.quantity AS quantity_3,
  t0.purchase_price AS purchase_price_4,
  t0.unit_amount AS unit_amount_5,
  t0.pmp_amount AS pmp_amount_6,
  t0.package_count AS package_count_7,
  t0.package_price AS package_price_8,
  t0.package_barcode AS package_barcode_9,
  t0.package_name AS package_name_10,
  t0.expiration_date AS expiration_date_11,
  t0.target AS target_12,
  t0.is_synch AS is_synch_13,
  t0.creation_date AS creation_date_14,
  t0.edition_date AS edition_date_15,
  t0.initial_quantity AS initial_quantity_16,
  t0.deleted AS deleted_17,
  t0.lot AS lot_18,
  t0.price_change AS price_change_19,
  t0.product_id AS product_id_20,
  t0.shop_id AS shop_id_21,
  t0.purchase_id AS purchase_id_22
FROM
  stock t0
WHERE
  t0.package_barcode = ?
  AND t0.shop_id = ?
  AND t0.deleted = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.barcode AS barcode_2, t0.quantity AS quantity_3, t0.purchase_price AS purchase_price_4, t0.unit_amount AS unit_amount_5, t0.pmp_amount AS pmp_amount_6, t0.package_count AS package_count_7, t0.package_price AS package_price_8, t0.package_barcode AS package_barcode_9, t0.package_name AS package_name_10, t0.expiration_date AS expiration_date_11, t0.target AS target_12, t0.is_synch AS is_synch_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.initial_quantity AS initial_quantity_16, t0.deleted AS deleted_17, t0.lot AS lot_18, t0.price_change AS price_change_19, t0.product_id AS product_id_20, t0.shop_id AS shop_id_21, t0.purchase_id AS purchase_id_22 FROM stock t0 WHERE t0.package_barcode = '6132522120011' AND t0.shop_id = 4 AND t0.deleted = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.barcode AS barcode_2,
  t0.quantity AS quantity_3,
  t0.purchase_price AS purchase_price_4,
  t0.unit_amount AS unit_amount_5,
  t0.pmp_amount AS pmp_amount_6,
  t0.package_count AS package_count_7,
  t0.package_price AS package_price_8,
  t0.package_barcode AS package_barcode_9,
  t0.package_name AS package_name_10,
  t0.expiration_date AS expiration_date_11,
  t0.target AS target_12,
  t0.is_synch AS is_synch_13,
  t0.creation_date AS creation_date_14,
  t0.edition_date AS edition_date_15,
  t0.initial_quantity AS initial_quantity_16,
  t0.deleted AS deleted_17,
  t0.lot AS lot_18,
  t0.price_change AS price_change_19,
  t0.product_id AS product_id_20,
  t0.shop_id AS shop_id_21,
  t0.purchase_id AS purchase_id_22
FROM
  stock t0
WHERE
  t0.barcode = ?
  AND t0.shop_id = ?
  AND t0.deleted = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.barcode AS barcode_2, t0.quantity AS quantity_3, t0.purchase_price AS purchase_price_4, t0.unit_amount AS unit_amount_5, t0.pmp_amount AS pmp_amount_6, t0.package_count AS package_count_7, t0.package_price AS package_price_8, t0.package_barcode AS package_barcode_9, t0.package_name AS package_name_10, t0.expiration_date AS expiration_date_11, t0.target AS target_12, t0.is_synch AS is_synch_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.initial_quantity AS initial_quantity_16, t0.deleted AS deleted_17, t0.lot AS lot_18, t0.price_change AS price_change_19, t0.product_id AS product_id_20, t0.shop_id AS shop_id_21, t0.purchase_id AS purchase_id_22 FROM stock t0 WHERE t0.barcode = '6132522120011' AND t0.shop_id = 4 AND t0.deleted = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.unit AS unit_3,
  t0.expiration_delay AS expiration_delay_4,
  t0.stock_limit AS stock_limit_5,
  t0.creation_date AS creation_date_6,
  t0.shortcut AS shortcut_7,
  t0.target AS target_8,
  t0.is_synch AS is_synch_9,
  t0.deleted AS deleted_10,
  t0.category_id AS category_id_11,
  t0.sub_category_id AS sub_category_id_12
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.unit AS unit_3, t0.expiration_delay AS expiration_delay_4, t0.stock_limit AS stock_limit_5, t0.creation_date AS creation_date_6, t0.shortcut AS shortcut_7, t0.target AS target_8, t0.is_synch AS is_synch_9, t0.deleted AS deleted_10, t0.category_id AS category_id_11, t0.sub_category_id AS sub_category_id_12 FROM product t0 WHERE t0.id = 3000508;

SELECT
  t0.id AS id_1,
  t0.discount_id AS discount_id_2,
  t0.product_id AS product_id_3
FROM
  discount_products t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.discount_id AS discount_id_2, t0.product_id AS product_id_3 FROM discount_products t0 WHERE t0.product_id = 3000508;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.price AS price_3,
  t0.creation_date AS creation_date_4,
  t0.quantity AS quantity_5,
  t0.barcode AS barcode_6,
  t0.target AS target_7,
  t0.is_synch AS is_synch_8,
  t0.deleted AS deleted_9
FROM
  pack t0
WHERE
  t0.barcode = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.price AS price_3, t0.creation_date AS creation_date_4, t0.quantity AS quantity_5, t0.barcode AS barcode_6, t0.target AS target_7, t0.is_synch AS is_synch_8, t0.deleted AS deleted_9 FROM pack t0 WHERE t0.barcode = '6132522120011' ORDER BY t0.id DESC LIMIT 1;