Symfony Profiler

SELECT
  t0.reference AS reference_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.short_description AS short_description_4,
  t0.long_description AS long_description_5,
  t0.status AS status_6,
  t0.featured AS featured_7,
  t0.cta_label AS cta_label_8,
  t0.promo_message AS promo_message_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.og_image_url AS og_image_url_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.id AS id_15,
  t0.price AS price_16,
  t0.promo_price AS promo_price_17
FROM
  product t0
WHERE
  t0.status = ?
  AND t0.featured = ?
LIMIT
  1

SELECT t0.reference AS reference_1, t0.slug AS slug_2, t0.name AS name_3, t0.short_description AS short_description_4, t0.long_description AS long_description_5, t0.status AS status_6, t0.featured AS featured_7, t0.cta_label AS cta_label_8, t0.promo_message AS promo_message_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.og_image_url AS og_image_url_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.price AS price_16, t0.promo_price AS promo_price_17 FROM product t0 WHERE t0.status = 'active' AND t0.featured = 1 LIMIT 1;

SELECT
  t0.product_id AS product_id_1,
  t0.path AS path_2,
  t0.alt_text AS alt_text_3,
  t0.is_main AS is_main_4,
  t0.display_order AS display_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.id AS id_8
FROM
  product_image t0
WHERE
  t0.product_id = ?

SELECT t0.product_id AS product_id_1, t0.path AS path_2, t0.alt_text AS alt_text_3, t0.is_main AS is_main_4, t0.display_order AS display_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8 FROM product_image t0 WHERE t0.product_id = '03333333-3333-7333-8333-333333333333';

SELECT
  t0.product_id AS product_id_1,
  t0.label AS label_2,
  t0.display_order AS display_order_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6
FROM
  product_size t0
WHERE
  t0.product_id = ?

SELECT t0.product_id AS product_id_1, t0.label AS label_2, t0.display_order AS display_order_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6 FROM product_size t0 WHERE t0.product_id = '03333333-3333-7333-8333-333333333333';

SELECT
  t0.product_id AS product_id_1,
  t0.label AS label_2,
  t0.hex_code AS hex_code_3,
  t0.display_order AS display_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7
FROM
  product_color t0
WHERE
  t0.product_id = ?

SELECT t0.product_id AS product_id_1, t0.label AS label_2, t0.hex_code AS hex_code_3, t0.display_order AS display_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM product_color t0 WHERE t0.product_id = '03333333-3333-7333-8333-333333333333';

SELECT
  t0.product_id AS product_id_1,
  t0.label AS label_2,
  t0.kind AS kind_3,
  t0.display_order AS display_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7
FROM
  product_badge t0
WHERE
  t0.product_id = ?

SELECT t0.product_id AS product_id_1, t0.label AS label_2, t0.kind AS kind_3, t0.display_order AS display_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7 FROM product_badge t0 WHERE t0.product_id = '03333333-3333-7333-8333-333333333333';

INSERT INTO landing_visit (
  id, product_id, visit_date, view_count,
  created_at
)
VALUES
  (?, ?, ?, 1, ?) ON DUPLICATE KEY
UPDATE
  view_count = view_count + 1,
  updated_at = ?

INSERT INTO landing_visit (id, product_id, visit_date, view_count, created_at) VALUES ('01a006d6-49e3-72d7-b572-9ad7bf91a689', '03333333-3333-7333-8333-333333333333', '2026-08-15', 1, '2026-08-15 19:11:42') ON DUPLICATE KEY UPDATE view_count = view_count + 1, updated_at = '2026-08-15 19:11:42';

SELECT
  s0_.platform AS platform_0,
  s0_.url AS url_1,
  s0_.is_enabled AS is_enabled_2,
  s0_.display_order AS display_order_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.id AS id_6
FROM
  social_link s0_
WHERE
  s0_.is_enabled = 1
  AND s0_.url IS NOT NULL
ORDER BY
  s0_.display_order ASC

SELECT s0_.platform AS platform_0, s0_.url AS url_1, s0_.is_enabled AS is_enabled_2, s0_.display_order AS display_order_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.id AS id_6 FROM social_link s0_ WHERE s0_.is_enabled = 1 AND s0_.url IS NOT NULL ORDER BY s0_.display_order ASC;