Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 8745;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 8745 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 7262;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 7262 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 28086;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 28086 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 13331;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 13331 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 48;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 48 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 4348;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 4348 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id = 11628;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.discount_percentage AS discount_percentage_2,
  d0_.starts_at AS starts_at_3,
  d0_.ends_at AS ends_at_4,
  d0_.active AS active_5
FROM
  discount d0_
  INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id
  INNER JOIN product p1_ ON p1_.id = d2_.product_id
WHERE
  p1_.id = ?
  AND d0_.active = ?
  AND d0_.starts_at <= ?
  AND d0_.ends_at >= ?
ORDER BY
  d0_.discount_percentage DESC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.discount_percentage AS discount_percentage_2, d0_.starts_at AS starts_at_3, d0_.ends_at AS ends_at_4, d0_.active AS active_5 FROM discount d0_ INNER JOIN discount_product d2_ ON d0_.id = d2_.discount_id INNER JOIN product p1_ ON p1_.id = d2_.product_id WHERE p1_.id = 11628 AND d0_.active = 1 AND d0_.starts_at <= '2026-09-01 01:59:02' AND d0_.ends_at >= '2026-09-01 01:59:02' ORDER BY d0_.discount_percentage DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.image AS image_3,
  c0_.active AS active_4,
  c0_.position AS position_5,
  c0_.meta_title AS meta_title_6,
  c0_.meta_description AS meta_description_7,
  c0_.meta_keywords AS meta_keywords_8,
  COUNT(p1_.id) AS sclr_9,
  c0_.parent_id AS parent_id_10
FROM
  category c0_
  LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id
  LEFT JOIN product p1_ ON p1_.id = p2_.product_id
WHERE
  c0_.active = ?
  AND c0_.parent_id IS NULL
GROUP BY
  c0_.id
ORDER BY
  c0_.position ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image AS image_3, c0_.active AS active_4, c0_.position AS position_5, c0_.meta_title AS meta_title_6, c0_.meta_description AS meta_description_7, c0_.meta_keywords AS meta_keywords_8, COUNT(p1_.id) AS sclr_9, c0_.parent_id AS parent_id_10 FROM category c0_ LEFT JOIN product_category p2_ ON c0_.id = p2_.category_id LEFT JOIN product p1_ ON p1_.id = p2_.product_id WHERE c0_.active = 1 AND c0_.parent_id IS NULL GROUP BY c0_.id ORDER BY c0_.position ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.cod AS cod_2,
  t0.reference AS reference_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.slug AS slug_6,
  t0.stock AS stock_7,
  t0.pvp AS pvp_8,
  t0.discount AS discount_9,
  t0.net_price AS net_price_10,
  t0.extra AS extra_11,
  t0.images AS images_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.views AS views_15,
  t0.position AS position_16,
  t0.active AS active_17,
  t0.meta_title AS meta_title_18,
  t0.meta_description AS meta_description_19,
  t0.meta_keywords AS meta_keywords_20,
  t0.brand_id AS brand_id_21
FROM
  product t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  t0.position ASC,
  t0.name ASC

SELECT t0.id AS id_1, t0.cod AS cod_2, t0.reference AS reference_3, t0.name AS name_4, t0.description AS description_5, t0.slug AS slug_6, t0.stock AS stock_7, t0.pvp AS pvp_8, t0.discount AS discount_9, t0.net_price AS net_price_10, t0.extra AS extra_11, t0.images AS images_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.views AS views_15, t0.position AS position_16, t0.active AS active_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.meta_keywords AS meta_keywords_20, t0.brand_id AS brand_id_21 FROM product t0 WHERE t0.id IN (10693, 2322, 11252, 8900, 10682, 5336, 10698, 9015, 7912, 2328, 8914, 7575, 2332, 8338, 9016, 21080, 7439, 11545, 12481, 10604, 6708, 9385, 8715, 16280, 9495, 11976, 22233, 7559, 6644, 8407, 10993, 8668, 13604, 10145, 6716, 4027, 8544, 6466, 7267, 7517, 20901, 7594, 8138, 9083, 11049, 12879, 21054, 8101, 7794, 7515) ORDER BY t0.position ASC, t0.name ASC;