Symfony Profiler

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.icon AS icon_6,
  t0.is_active_in_menu AS is_active_in_menu_7,
  t0.is_active_in_filters AS is_active_in_filters_8,
  t0.super_category_id AS super_category_id_9
FROM
  `product_categories` t0
WHERE
  t0.slug = ?
LIMIT
  1

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.icon AS icon_6, t0.is_active_in_menu AS is_active_in_menu_7, t0.is_active_in_filters AS is_active_in_filters_8, t0.super_category_id AS super_category_id_9 FROM `product_categories` t0 WHERE t0.slug = 'fassade' LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  products p0_
  INNER JOIN products_categories p2_ ON p0_.id = p2_.product_id
  INNER JOIN `product_categories` p1_ ON p1_.id = p2_.product_category_id
WHERE
  p1_.slug = ?

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM products p0_ INNER JOIN products_categories p2_ ON p0_.id = p2_.product_id INNER JOIN `product_categories` p1_ ON p1_.id = p2_.product_category_id WHERE p1_.slug = 'fassade';

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.icon AS icon_6,
  t0.is_active_in_menu AS is_active_in_menu_7,
  t0.is_active_in_filters AS is_active_in_filters_8,
  t0.super_category_id AS super_category_id_9
FROM
  `product_categories` t0
WHERE
  t0.super_category_id IS NULL
ORDER BY
  t0.name 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.icon AS icon_6, t0.is_active_in_menu AS is_active_in_menu_7, t0.is_active_in_filters AS is_active_in_filters_8, t0.super_category_id AS super_category_id_9 FROM `product_categories` t0 WHERE t0.super_category_id IS NULL ORDER BY t0.name ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO carts (
  session_id, type, created_at, updated_at,
  deleted_at, customer_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO carts (session_id, type, created_at, updated_at, deleted_at, customer_id) VALUES ('dvoeh05qes70p7o7habr65gofj', 'cart', '2025-07-19 20:29:07', '2025-07-19 20:29:07', NULL, NULL);

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.reference AS reference_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.price AS price_4,
  p0_.slug AS slug_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.deleted_at AS deleted_at_8
FROM
  products p0_
  INNER JOIN products_categories p2_ ON p0_.id = p2_.product_id
  INNER JOIN `product_categories` p1_ ON p1_.id = p2_.product_category_id
WHERE
  p1_.slug = ?
ORDER BY
  p0_.name ASC
LIMIT
  9
OFFSET
  9

SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price AS price_4, p0_.slug AS slug_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM products p0_ INNER JOIN products_categories p2_ ON p0_.id = p2_.product_id INNER JOIN `product_categories` p1_ ON p1_.id = p2_.product_category_id WHERE p1_.slug = 'fassade' ORDER BY p0_.name ASC LIMIT 9 OFFSET 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.thumbnail AS thumbnail_4,
  t0.featured AS featured_5,
  t0.product_id AS product_id_6
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = 809;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.metadata AS metadata_3,
  t0.price_adjustment AS price_adjustment_4,
  t0.product_id AS product_id_5,
  t0.option_id AS option_id_6
FROM
  product_option_values t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = 809;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  `configurations` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = 'default_currency' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.is_active AS is_active_4,
  t0.is_default AS is_default_5,
  t0.format AS format_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  currencies t0
WHERE
  t0.code = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = 'EUR' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.thumbnail AS thumbnail_4,
  t0.featured AS featured_5,
  t0.product_id AS product_id_6
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = 887;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.metadata AS metadata_3,
  t0.price_adjustment AS price_adjustment_4,
  t0.product_id AS product_id_5,
  t0.option_id AS option_id_6
FROM
  product_option_values t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = 887;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  `configurations` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = 'default_currency' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.is_active AS is_active_4,
  t0.is_default AS is_default_5,
  t0.format AS format_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  currencies t0
WHERE
  t0.code = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = 'EUR' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.thumbnail AS thumbnail_4,
  t0.featured AS featured_5,
  t0.product_id AS product_id_6
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = 920;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.metadata AS metadata_3,
  t0.price_adjustment AS price_adjustment_4,
  t0.product_id AS product_id_5,
  t0.option_id AS option_id_6
FROM
  product_option_values t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.metadata AS metadata_3, t0.price_adjustment AS price_adjustment_4, t0.product_id AS product_id_5, t0.option_id AS option_id_6 FROM product_option_values t0 WHERE t0.product_id = 920;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  `configurations` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = 'default_currency' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3,
  t0.is_active AS is_active_4,
  t0.is_default AS is_default_5,
  t0.format AS format_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9
FROM
  currencies t0
WHERE
  t0.code = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.symbol AS symbol_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.format AS format_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9 FROM currencies t0 WHERE t0.code = 'EUR' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.thumbnail AS thumbnail_4,
  t0.featured AS featured_5,
  t0.product_id AS product_id_6
FROM
  product_images t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.featured AS featured_5, t0.product_id AS product_id_6 FROM product_images t0 WHERE t0.product_id = 958;

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.value AS value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  `configurations` t0
WHERE
  t0.`key` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM `configurations` t0 WHERE t0.`key` = 'default_currency' LIMIT 1;