Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  settings t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM settings t0 WHERE t0.id = 'app.host';

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 = ?
  AND t0.type = ?
  AND t0.is_active = ?
LIMIT
  1

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 = '1' AND t0.type = 1 AND t0.is_active = 1 LIMIT 1;

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,
  p0_.id_presentation AS id_presentation_13,
  p0_.id_added_by_user AS id_added_by_user_14
FROM
  promotion p0_
WHERE
  p0_.id_added_by_user = ?
  AND p0_.url_alias = ?

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, p0_.id_presentation AS id_presentation_13, p0_.id_added_by_user AS id_added_by_user_14 FROM promotion p0_ WHERE p0_.id_added_by_user = '1' AND p0_.url_alias = 'promocja-2';

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.gross_price AS gross_price_2,
  t0.quantity AS quantity_3,
  t0.id_promotion AS id_promotion_4,
  t0.id_presentation_product AS id_presentation_product_5
FROM
  promotion_product t0
WHERE
  t0.id_promotion = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.gross_price AS gross_price_2, t0.quantity AS quantity_3, t0.id_promotion AS id_promotion_4, t0.id_presentation_product AS id_presentation_product_5 FROM promotion_product t0 WHERE t0.id_promotion = '2' ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.id_presentation AS id_presentation_2,
  t0.id_product AS id_product_3
FROM
  presentation_product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_presentation AS id_presentation_2, t0.id_product AS id_product_3 FROM presentation_product t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.short_description AS short_description_4,
  t0.description AS description_5,
  t0.ean AS ean_6,
  t0.sku AS sku_7,
  t0.price AS price_8,
  t0.vat AS vat_9,
  t0.gross_price AS gross_price_10,
  t0.stock_quantity AS stock_quantity_11,
  t0.gross_weight AS gross_weight_12,
  t0.package_width AS package_width_13,
  t0.package_height AS package_height_14,
  t0.package_length AS package_length_15,
  t0.shipping_type AS shipping_type_16,
  t0.is_active AS is_active_17,
  t0.added_at AS added_at_18,
  t0.id_product_category AS id_product_category_19,
  t0.id_added_by_user AS id_added_by_user_20
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.description AS description_5, t0.ean AS ean_6, t0.sku AS sku_7, t0.price AS price_8, t0.vat AS vat_9, t0.gross_price AS gross_price_10, t0.stock_quantity AS stock_quantity_11, t0.gross_weight AS gross_weight_12, t0.package_width AS package_width_13, t0.package_height AS package_height_14, t0.package_length AS package_length_15, t0.shipping_type AS shipping_type_16, t0.is_active AS is_active_17, t0.added_at AS added_at_18, t0.id_product_category AS id_product_category_19, t0.id_added_by_user AS id_added_by_user_20 FROM product 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.icon AS icon_5,
  t0.lft AS lft_6,
  t0.rgt AS rgt_7,
  t0.depth AS depth_8
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.lft AS lft_6, t0.rgt AS rgt_7, t0.depth AS depth_8 FROM product_category t0 WHERE t0.id = 9;

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;

UPDATE
  promotion
SET
  view_count = view_count + 1
WHERE
  id = ?

UPDATE promotion SET view_count = view_count + 1 WHERE id = '2';

SELECT
  COALESCE(
    SUM(s0_.quantity),
    0
  ) AS sclr_0
FROM
  store_order_item s0_
  INNER JOIN store_order s1_ ON s0_.id_order = s1_.id
WHERE
  s0_.id_product = ?
  AND s0_.gross_price = ?
  AND s1_.status IN (?, ?, ?)
  AND (
    s1_.added_at BETWEEN ?
    AND ?
  )

SELECT COALESCE(SUM(s0_.quantity), 0) AS sclr_0 FROM store_order_item s0_ INNER JOIN store_order s1_ ON s0_.id_order = s1_.id WHERE s0_.id_product = '1' AND s0_.gross_price = '123.00' AND s1_.status IN (2, 3, 4) AND (s1_.added_at BETWEEN '2026-05-26 00:00:00' AND '2027-04-10 23:59:59');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.logo AS logo_5,
  t0.image AS image_6,
  t0.tin AS tin_7,
  t0.street AS street_8,
  t0.postal_code AS postal_code_9,
  t0.city AS city_10,
  t0.company_data_visible AS company_data_visible_11,
  t0.bank_account_number AS bank_account_number_12,
  t0.is_custom_subdomain AS is_custom_subdomain_13,
  t0.custom_domain_name AS custom_domain_name_14,
  t0.id_user AS id_user_15
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.logo AS logo_5, t0.image AS image_6, t0.tin AS tin_7, t0.street AS street_8, t0.postal_code AS postal_code_9, t0.city AS city_10, t0.company_data_visible AS company_data_visible_11, t0.bank_account_number AS bank_account_number_12, t0.is_custom_subdomain AS is_custom_subdomain_13, t0.custom_domain_name AS custom_domain_name_14, t0.id_user AS id_user_15 FROM user_company t0 WHERE t0.id_user = '1';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.images_position AS images_position_4,
  t0.background_color AS background_color_5,
  t0.text_color AS text_color_6,
  t0.id_presentation AS id_presentation_7
FROM
  presentation_section t0
WHERE
  t0.id_presentation = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.images_position AS images_position_4, t0.background_color AS background_color_5, t0.text_color AS text_color_6, t0.id_presentation AS id_presentation_7 FROM presentation_section t0 WHERE t0.id_presentation = '1' ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.id_presentation_section AS id_presentation_section_3
FROM
  presentation_section_image t0
WHERE
  t0.id_presentation_section = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.image AS image_2, t0.id_presentation_section AS id_presentation_section_3 FROM presentation_section_image t0 WHERE t0.id_presentation_section = 1 ORDER BY t0.id ASC;