Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.ean AS ean_3,
  p0_.sku AS sku_4,
  p0_.price AS price_5,
  p0_.vat AS vat_6,
  p0_.gross_price AS gross_price_7,
  p0_.stock_quantity AS stock_quantity_8,
  p0_.added_at AS added_at_9,
  p0_.id_product_category AS id_product_category_10,
  p0_.id_added_by_user AS id_added_by_user_11
FROM
  product p0_
  INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id
WHERE
  u1_.is_active = 1
  AND (
    EXISTS (
      SELECT
        p2_.id
      FROM
        presentation_product p2_
        INNER JOIN promotion_product p3_ ON p2_.id = p3_.id_presentation_product
        INNER JOIN promotion p4_ ON p3_.id_promotion = p4_.id
      WHERE
        p2_.id_product = p0_.id
        AND p4_.date_from <= ?
        AND p4_.date_to >= ?
    )
  )

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.ean AS ean_3, p0_.sku AS sku_4, p0_.price AS price_5, p0_.vat AS vat_6, p0_.gross_price AS gross_price_7, p0_.stock_quantity AS stock_quantity_8, p0_.added_at AS added_at_9, p0_.id_product_category AS id_product_category_10, p0_.id_added_by_user AS id_added_by_user_11 FROM product p0_ INNER JOIN user u1_ ON p0_.id_added_by_user = u1_.id WHERE u1_.is_active = 1 AND (EXISTS (SELECT p2_.id FROM presentation_product p2_ INNER JOIN promotion_product p3_ ON p2_.id = p3_.id_presentation_product INNER JOIN promotion p4_ ON p3_.id_promotion = p4_.id WHERE p2_.id_product = p0_.id AND p4_.date_from <= '2026-04-28 00:00:00' AND p4_.date_to >= '2026-04-28 00:00:00'));

SELECT
  p0_.id AS id_0,
  p0_.template_type AS template_type_1,
  p0_.date_from AS date_from_2,
  p0_.date_to AS date_to_3,
  p0_.url_alias AS url_alias_4,
  p0_.type AS type_5,
  p0_.view_count AS view_count_6,
  p0_.completed_steps AS completed_steps_7,
  p0_.is_draft AS is_draft_8,
  p0_.payment_method AS payment_method_9,
  p0_.payment_id AS payment_id_10,
  p0_.paid_at AS paid_at_11,
  p0_.added_at AS added_at_12,
  p1_.gross_price AS gross_price_13,
  p0_.id_presentation AS id_presentation_14,
  p0_.id_added_by_user AS id_added_by_user_15
FROM
  promotion p0_
  INNER JOIN promotion_product p1_ ON p0_.id = p1_.id_promotion
  INNER JOIN presentation_product p2_ ON p1_.id_presentation_product = p2_.id
WHERE
  p0_.id_added_by_user = ?
  AND p0_.date_from <= ?
  AND p0_.date_to >= ?
  AND p2_.id_product = ?
ORDER BY
  p1_.gross_price ASC

SELECT p0_.id AS id_0, p0_.template_type AS template_type_1, p0_.date_from AS date_from_2, p0_.date_to AS date_to_3, p0_.url_alias AS url_alias_4, p0_.type AS type_5, p0_.view_count AS view_count_6, p0_.completed_steps AS completed_steps_7, p0_.is_draft AS is_draft_8, p0_.payment_method AS payment_method_9, p0_.payment_id AS payment_id_10, p0_.paid_at AS paid_at_11, p0_.added_at AS added_at_12, p1_.gross_price AS gross_price_13, p0_.id_presentation AS id_presentation_14, p0_.id_added_by_user AS id_added_by_user_15 FROM promotion p0_ INNER JOIN promotion_product p1_ ON p0_.id = p1_.id_promotion INNER JOIN presentation_product p2_ ON p1_.id_presentation_product = p2_.id WHERE p0_.id_added_by_user = '3' AND p0_.date_from <= '2026-04-28 00:00:00' AND p0_.date_to >= '2026-04-28 00:00:00' AND p2_.id_product = '1' ORDER BY p1_.gross_price ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
ORDER BY
  p0_.depth ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ ORDER BY p0_.depth ASC, p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.logo AS logo_4,
  t0.primary_button_background_color AS primary_button_background_color_5,
  t0.primary_button_text_color AS primary_button_text_color_6,
  t0.default_button_background_color AS default_button_background_color_7,
  t0.default_button_text_color AS default_button_text_color_8,
  t0.completed_steps AS completed_steps_9,
  t0.is_published AS is_published_10,
  t0.added_at AS added_at_11,
  t0.id_added_by_user AS id_added_by_user_12
FROM
  presentation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.logo AS logo_4, t0.primary_button_background_color AS primary_button_background_color_5, t0.primary_button_text_color AS primary_button_text_color_6, t0.default_button_background_color AS default_button_background_color_7, t0.default_button_text_color AS default_button_text_color_8, t0.completed_steps AS completed_steps_9, t0.is_published AS is_published_10, t0.added_at AS added_at_11, t0.id_added_by_user AS id_added_by_user_12 FROM presentation t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.id_product AS id_product_3
FROM
  product_image t0
WHERE
  t0.id_product = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_product AS id_product_3 FROM product_image t0 WHERE t0.id_product = 1 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.tin AS tin_6,
  t0.street AS street_7,
  t0.postal_code AS postal_code_8,
  t0.city AS city_9,
  t0.bank_account_number AS bank_account_number_10,
  t0.id_user AS id_user_11
FROM
  user_company t0
WHERE
  t0.id_user = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.image AS image_5, t0.tin AS tin_6, t0.street AS street_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.bank_account_number AS bank_account_number_10, t0.id_user AS id_user_11 FROM user_company t0 WHERE t0.id_user = '3';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.type AS type_5,
  t0.is_active AS is_active_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.type AS type_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = '3';

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.description AS description_3,
  p0_.icon AS icon_4,
  p0_.lft AS lft_5,
  p0_.rgt AS rgt_6,
  p0_.depth AS depth_7
FROM
  product_category p0_
WHERE
  p0_.lft < ?
  AND p0_.rgt > ?
ORDER BY
  p0_.lft DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.description AS description_3, p0_.icon AS icon_4, p0_.lft AS lft_5, p0_.rgt AS rgt_6, p0_.depth AS depth_7 FROM product_category p0_ WHERE p0_.lft < 3 AND p0_.rgt > 4 ORDER BY p0_.lft DESC;