Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.lastname AS lastname_5,
  t0.firstname AS firstname_6,
  t0.is_active AS is_active_7,
  t0.lang AS lang_8,
  t0.is_new AS is_new_9,
  t0.rate_code AS rate_code_10,
  t0.customer_id AS customer_id_11,
  t0.delivery_address_id AS delivery_address_id_12,
  t0.customer_name AS customer_name_13,
  t0.password_request AS password_request_14,
  t0.is_shipping_cost AS is_shipping_cost_15,
  t0.min_order AS min_order_16,
  t0.shipping_costs AS shipping_costs_17,
  t0.is_admin_customer AS is_admin_customer_18,
  t0.default_user AS default_user_19,
  t0.internal_customer AS internal_customer_20
FROM
  user t0
WHERE
  t0.default_user = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.lastname AS lastname_5, t0.firstname AS firstname_6, t0.is_active AS is_active_7, t0.lang AS lang_8, t0.is_new AS is_new_9, t0.rate_code AS rate_code_10, t0.customer_id AS customer_id_11, t0.delivery_address_id AS delivery_address_id_12, t0.customer_name AS customer_name_13, t0.password_request AS password_request_14, t0.is_shipping_cost AS is_shipping_cost_15, t0.min_order AS min_order_16, t0.shipping_costs AS shipping_costs_17, t0.is_admin_customer AS is_admin_customer_18, t0.default_user AS default_user_19, t0.internal_customer AS internal_customer_20 FROM user t0 WHERE t0.default_user = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.customer AS customer_2,
  t0.article_id AS article_id_3
FROM
  catalog t0
WHERE
  t0.customer = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.customer AS customer_2, t0.article_id AS article_id_3 FROM catalog t0 WHERE t0.customer = 'WEB' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name_fr AS name_fr_1,
  c0_.name_en AS name_en_2,
  c0_.name_de AS name_de_3,
  c0_.name_nl AS name_nl_4,
  c0_.image AS image_5
FROM
  category c0_
  INNER JOIN article a1_ ON c0_.id = a1_.category_id
  INNER JOIN catalog c2_ ON a1_.id = c2_.article_id
WHERE
  (
    c0_.id = a1_.category_id
    AND a1_.is_active = 1
  )
  AND a1_.is_bulk = 1
  AND c2_.customer = ?
GROUP BY
  c0_.name_fr
ORDER BY
  c0_.name_fr ASC

SELECT c0_.id AS id_0, c0_.name_fr AS name_fr_1, c0_.name_en AS name_en_2, c0_.name_de AS name_de_3, c0_.name_nl AS name_nl_4, c0_.image AS image_5 FROM category c0_ INNER JOIN article a1_ ON c0_.id = a1_.category_id INNER JOIN catalog c2_ ON a1_.id = c2_.article_id WHERE (c0_.id = a1_.category_id AND a1_.is_active = 1) AND a1_.is_bulk = 1 AND c2_.customer = 'WEB' GROUP BY c0_.name_fr ORDER BY c0_.name_fr ASC;

SELECT
  a0_.id AS id_0,
  a0_.name_fr AS name_fr_1,
  a0_.name_en AS name_en_2,
  a0_.name_de AS name_de_3,
  a0_.name_nl AS name_nl_4,
  a0_.price AS price_5,
  a0_.is_highlight AS is_highlight_6,
  a0_.is_varying_weight AS is_varying_weight_7,
  a0_.is_active AS is_active_8,
  a0_.image AS image_9,
  a0_.updated_at AS updated_at_10,
  a0_.description_fr AS description_fr_11,
  a0_.description_en AS description_en_12,
  a0_.description_de AS description_de_13,
  a0_.description_nl AS description_nl_14,
  a0_.nutritional_value_fr AS nutritional_value_fr_15,
  a0_.nutritional_value_en AS nutritional_value_en_16,
  a0_.nutritional_value_de AS nutritional_value_de_17,
  a0_.nutritional_value_nl AS nutritional_value_nl_18,
  a0_.ingredient_fr AS ingredient_fr_19,
  a0_.ingredient_en AS ingredient_en_20,
  a0_.ingredient_de AS ingredient_de_21,
  a0_.ingredient_nl AS ingredient_nl_22,
  a0_.allergen_fr AS allergen_fr_23,
  a0_.allergen_en AS allergen_en_24,
  a0_.allergen_de AS allergen_de_25,
  a0_.allergen_nl AS allergen_nl_26,
  a0_.array_price AS array_price_27,
  a0_.max_qty AS max_qty_28,
  a0_.article_number AS article_number_29,
  a0_.delivery_min AS delivery_min_30,
  a0_.weight_average AS weight_average_31,
  a0_.packaging AS packaging_32,
  a0_.availability AS availability_33,
  a0_.is_igp AS is_igp_34,
  a0_.technical_data AS technical_data_35,
  a0_.is_bulk AS is_bulk_36,
  a0_.family_id AS family_id_37,
  a0_.category_id AS category_id_38
FROM
  article a0_
  INNER JOIN catalog c1_ ON a0_.id = c1_.article_id
WHERE
  c1_.customer = ?
  AND a0_.is_active = 1
  AND a0_.category_id = ?
ORDER BY
  a0_.name_fr ASC

SELECT a0_.id AS id_0, a0_.name_fr AS name_fr_1, a0_.name_en AS name_en_2, a0_.name_de AS name_de_3, a0_.name_nl AS name_nl_4, a0_.price AS price_5, a0_.is_highlight AS is_highlight_6, a0_.is_varying_weight AS is_varying_weight_7, a0_.is_active AS is_active_8, a0_.image AS image_9, a0_.updated_at AS updated_at_10, a0_.description_fr AS description_fr_11, a0_.description_en AS description_en_12, a0_.description_de AS description_de_13, a0_.description_nl AS description_nl_14, a0_.nutritional_value_fr AS nutritional_value_fr_15, a0_.nutritional_value_en AS nutritional_value_en_16, a0_.nutritional_value_de AS nutritional_value_de_17, a0_.nutritional_value_nl AS nutritional_value_nl_18, a0_.ingredient_fr AS ingredient_fr_19, a0_.ingredient_en AS ingredient_en_20, a0_.ingredient_de AS ingredient_de_21, a0_.ingredient_nl AS ingredient_nl_22, a0_.allergen_fr AS allergen_fr_23, a0_.allergen_en AS allergen_en_24, a0_.allergen_de AS allergen_de_25, a0_.allergen_nl AS allergen_nl_26, a0_.array_price AS array_price_27, a0_.max_qty AS max_qty_28, a0_.article_number AS article_number_29, a0_.delivery_min AS delivery_min_30, a0_.weight_average AS weight_average_31, a0_.packaging AS packaging_32, a0_.availability AS availability_33, a0_.is_igp AS is_igp_34, a0_.technical_data AS technical_data_35, a0_.is_bulk AS is_bulk_36, a0_.family_id AS family_id_37, a0_.category_id AS category_id_38 FROM article a0_ INNER JOIN catalog c1_ ON a0_.id = c1_.article_id WHERE c1_.customer = 'WEB' AND a0_.is_active = 1 AND a0_.category_id = 22 ORDER BY a0_.name_fr ASC;

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 198) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 96) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 305) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 95) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 306) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 90) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 298) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 104) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 315) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 103) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  p0_.id AS id_0,
  p0_.customer_id AS customer_id_1,
  p0_.price AS price_2,
  p0_.price_promo AS price_promo_3,
  p0_.date AS date_4,
  p0_.article_id AS article_id_5
FROM
  promotion p0_
  INNER JOIN article a1_ ON p0_.article_id = a1_.id
  AND (a1_.id = ?)
WHERE
  p0_.customer_id = ?
  AND p0_.date = ?

SELECT p0_.id AS id_0, p0_.customer_id AS customer_id_1, p0_.price AS price_2, p0_.price_promo AS price_promo_3, p0_.date AS date_4, p0_.article_id AS article_id_5 FROM promotion p0_ INNER JOIN article a1_ ON p0_.article_id = a1_.id AND (a1_.id = 316) WHERE p0_.customer_id = 'WEB' AND p0_.date = '2025-10-26';

SELECT
  f0_.id AS id_0,
  f0_.name_fr AS name_fr_1,
  f0_.name_en AS name_en_2,
  f0_.name_de AS name_de_3,
  f0_.name_nl AS name_nl_4,
  f0_.image AS image_5
FROM
  family f0_
  INNER JOIN article a1_ ON f0_.id = a1_.family_id
  INNER JOIN catalog c2_ ON a1_.id = c2_.article_id
WHERE
  (
    f0_.id = a1_.family_id
    AND a1_.is_active = 1
  )
  AND a1_.is_bulk = 1
  AND c2_.customer = ?
GROUP BY
  f0_.name_fr
ORDER BY
  f0_.name_fr ASC

SELECT f0_.id AS id_0, f0_.name_fr AS name_fr_1, f0_.name_en AS name_en_2, f0_.name_de AS name_de_3, f0_.name_nl AS name_nl_4, f0_.image AS image_5 FROM family f0_ INNER JOIN article a1_ ON f0_.id = a1_.family_id INNER JOIN catalog c2_ ON a1_.id = c2_.article_id WHERE (f0_.id = a1_.family_id AND a1_.is_active = 1) AND a1_.is_bulk = 1 AND c2_.customer = 'WEB' GROUP BY f0_.name_fr ORDER BY f0_.name_fr ASC;