Symfony Profiler

SELECT
  d0_.host AS host_0,
  d0_.identifier AS identifier_1,
  d0_.id AS id_2,
  c1_.title AS title_3,
  c1_.main AS main_4,
  c1_.id AS id_5,
  d2_.host AS host_6,
  d2_.identifier AS identifier_7,
  d2_.id AS id_8,
  l3_.code AS code_9,
  l3_.language_code AS language_code_10,
  l3_.country_code AS country_code_11,
  l3_.id AS id_12,
  d0_.discriminator AS discriminator_13,
  d0_.channel_id AS channel_id_14,
  c1_.discriminator AS discriminator_15,
  c1_.locale_id AS locale_id_16,
  d2_.discriminator AS discriminator_17,
  d2_.channel_id AS channel_id_18,
  l3_.discriminator AS discriminator_19
FROM
  domain d0_
  LEFT JOIN channel c1_ ON d0_.channel_id = c1_.id
  AND c1_.discriminator IN ('basechannel')
  LEFT JOIN domain d2_ ON c1_.id = d2_.channel_id
  AND d2_.discriminator IN ('basedomain')
  LEFT JOIN domain_locale d4_ ON d2_.id = d4_.domain_id
  LEFT JOIN locale l3_ ON l3_.id = d4_.locale_id
  AND l3_.discriminator IN ('baselocale')
WHERE
  (d0_.host = ?)
  AND d0_.discriminator IN ('basedomain')

SELECT d0_.host AS host_0, d0_.identifier AS identifier_1, d0_.id AS id_2, c1_.title AS title_3, c1_.main AS main_4, c1_.id AS id_5, d2_.host AS host_6, d2_.identifier AS identifier_7, d2_.id AS id_8, l3_.code AS code_9, l3_.language_code AS language_code_10, l3_.country_code AS country_code_11, l3_.id AS id_12, d0_.discriminator AS discriminator_13, d0_.channel_id AS channel_id_14, c1_.discriminator AS discriminator_15, c1_.locale_id AS locale_id_16, d2_.discriminator AS discriminator_17, d2_.channel_id AS channel_id_18, l3_.discriminator AS discriminator_19 FROM domain d0_ LEFT JOIN channel c1_ ON d0_.channel_id = c1_.id AND c1_.discriminator IN ('basechannel') LEFT JOIN domain d2_ ON c1_.id = d2_.channel_id AND d2_.discriminator IN ('basedomain') LEFT JOIN domain_locale d4_ ON d2_.id = d4_.domain_id LEFT JOIN locale l3_ ON l3_.id = d4_.locale_id AND l3_.discriminator IN ('baselocale') WHERE (d0_.host = 'components.dapprgemaakt.nl') AND d0_.discriminator IN ('basedomain');

UPDATE
  menu
SET
  updated = ?
WHERE
  id = ?

UPDATE menu SET updated = '2025-12-24 11:47:49' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  r0_.name AS name_0,
  r0_.url AS url_1,
  r0_.active AS active_2,
  r0_.controller AS controller_3,
  r0_.parameters AS parameters_4,
  r0_.entity_key AS entity_key_5,
  r0_.created_by AS created_by_6,
  r0_.updated_by AS updated_by_7,
  r0_.id AS id_8,
  r0_.created AS created_9,
  r0_.updated AS updated_10,
  l1_.code AS code_11,
  l1_.language_code AS language_code_12,
  l1_.country_code AS country_code_13,
  l1_.id AS id_14,
  r0_.discriminator AS discriminator_15,
  r0_.locale_id AS locale_id_16,
  l1_.discriminator AS discriminator_17
FROM
  route r0_
  LEFT JOIN locale l1_ ON r0_.locale_id = l1_.id
  AND l1_.discriminator IN ('baselocale')
WHERE
  (
    r0_.url = '/winkelwagen/'
    AND l1_.code IN ('nl_NL')
    AND r0_.active = 1
  )
  AND r0_.discriminator IN ('baseroute')
GROUP BY
  r0_.id

SELECT r0_.name AS name_0, r0_.url AS url_1, r0_.active AS active_2, r0_.controller AS controller_3, r0_.parameters AS parameters_4, r0_.entity_key AS entity_key_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7, r0_.id AS id_8, r0_.created AS created_9, r0_.updated AS updated_10, l1_.code AS code_11, l1_.language_code AS language_code_12, l1_.country_code AS country_code_13, l1_.id AS id_14, r0_.discriminator AS discriminator_15, r0_.locale_id AS locale_id_16, l1_.discriminator AS discriminator_17 FROM route r0_ LEFT JOIN locale l1_ ON r0_.locale_id = l1_.id AND l1_.discriminator IN ('baselocale') WHERE (r0_.url = '/winkelwagen/' AND l1_.code IN ('nl_NL') AND r0_.active = 1) AND r0_.discriminator IN ('baseroute') GROUP BY r0_.id;

SELECT
  r0_.type AS type_0,
  r0_.url_from AS url_from_1,
  r0_.url_to AS url_to_2,
  r0_.active AS active_3,
  r0_.auto_generated AS auto_generated_4,
  r0_.created_by AS created_by_5,
  r0_.updated_by AS updated_by_6,
  r0_.id AS id_7,
  r0_.created AS created_8,
  r0_.updated AS updated_9,
  r0_.discriminator AS discriminator_10
FROM
  redirect r0_
WHERE
  (
    r0_.url_from = '/winkelwagen/'
    AND r0_.active = 1
  )
  AND r0_.discriminator IN ('baseredirect')
GROUP BY
  r0_.id

SELECT r0_.type AS type_0, r0_.url_from AS url_from_1, r0_.url_to AS url_to_2, r0_.active AS active_3, r0_.auto_generated AS auto_generated_4, r0_.created_by AS created_by_5, r0_.updated_by AS updated_by_6, r0_.id AS id_7, r0_.created AS created_8, r0_.updated AS updated_9, r0_.discriminator AS discriminator_10 FROM redirect r0_ WHERE (r0_.url_from = '/winkelwagen/' AND r0_.active = 1) AND r0_.discriminator IN ('baseredirect') GROUP BY r0_.id;

SELECT
  t0.title AS title_1,
  t0.published AS published_2,
  t0.factory AS factory_3,
  t0.link AS link_4,
  t0.target_blank AS target_blank_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.id AS id_8,
  t0.order_id AS order_id_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.menu_id AS menu_id_12,
  t0.parent_id AS parent_id_13,
  t0.discriminator
FROM
  menu_item t0
WHERE
  t0.menu_id = ?
  AND t0.discriminator IN ('basemenuitem')
ORDER BY
  t0.order_id ASC

SELECT t0.title AS title_1, t0.published AS published_2, t0.factory AS factory_3, t0.link AS link_4, t0.target_blank AS target_blank_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.id AS id_8, t0.order_id AS order_id_9, t0.created AS created_10, t0.updated AS updated_11, t0.menu_id AS menu_id_12, t0.parent_id AS parent_id_13, t0.discriminator FROM menu_item t0 WHERE t0.menu_id = 1 AND t0.discriminator IN ('basemenuitem') ORDER BY t0.order_id ASC;

SELECT
  p0_.published AS published_0,
  p0_.indexable AS indexable_1,
  p0_.layout AS layout_2,
  p0_.system_page AS system_page_3,
  p0_.components AS components_4,
  p0_.created_by AS created_by_5,
  p0_.updated_by AS updated_by_6,
  p0_.id AS id_7,
  p0_.order_id AS order_id_8,
  p0_.created AS created_9,
  p0_.updated AS updated_10,
  p0_.discriminator AS discriminator_11,
  p0_.parent_id AS parent_id_12
FROM
  page p0_
  LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id
  AND p1_.discriminator IN ('basepagecontent')
WHERE
  (
    p0_.id = '1'
    AND p0_.published = 1
  )
  AND p0_.discriminator IN ('basepage')
GROUP BY
  p0_.id

SELECT p0_.published AS published_0, p0_.indexable AS indexable_1, p0_.layout AS layout_2, p0_.system_page AS system_page_3, p0_.components AS components_4, p0_.created_by AS created_by_5, p0_.updated_by AS updated_by_6, p0_.id AS id_7, p0_.order_id AS order_id_8, p0_.created AS created_9, p0_.updated AS updated_10, p0_.discriminator AS discriminator_11, p0_.parent_id AS parent_id_12 FROM page p0_ LEFT JOIN page_content p1_ ON p0_.id = p1_.page_id AND p1_.discriminator IN ('basepagecontent') WHERE (p0_.id = '1' AND p0_.published = 1) AND p0_.discriminator IN ('basepage') GROUP BY p0_.id;

SELECT
  d0_.host AS host_0,
  d0_.identifier AS identifier_1,
  d0_.id AS id_2,
  d0_.discriminator AS discriminator_3,
  d0_.channel_id AS channel_id_4
FROM
  domain d0_
WHERE
  d0_.discriminator IN ('basedomain')
GROUP BY
  d0_.id

SELECT d0_.host AS host_0, d0_.identifier AS identifier_1, d0_.id AS id_2, d0_.discriminator AS discriminator_3, d0_.channel_id AS channel_id_4 FROM domain d0_ WHERE d0_.discriminator IN ('basedomain') GROUP BY d0_.id;

SELECT
  c0_.title AS title_0,
  c0_.main AS main_1,
  c0_.id AS id_2,
  c0_.discriminator AS discriminator_3,
  c0_.locale_id AS locale_id_4
FROM
  channel c0_
WHERE
  c0_.discriminator IN ('basechannel')
GROUP BY
  c0_.id

SELECT c0_.title AS title_0, c0_.main AS main_1, c0_.id AS id_2, c0_.discriminator AS discriminator_3, c0_.locale_id AS locale_id_4 FROM channel c0_ WHERE c0_.discriminator IN ('basechannel') GROUP BY c0_.id;

SELECT
  s0_.name AS name_0,
  s0_.value AS value_1,
  s0_.reference AS reference_2,
  s0_.scope AS scope_3,
  s0_.permission AS permission_4,
  s0_.factory AS factory_5,
  s0_.id AS id_6,
  s0_.discriminator AS discriminator_7
FROM
  setting s0_
WHERE
  s0_.discriminator IN ('basesetting')
GROUP BY
  s0_.id

SELECT s0_.name AS name_0, s0_.value AS value_1, s0_.reference AS reference_2, s0_.scope AS scope_3, s0_.permission AS permission_4, s0_.factory AS factory_5, s0_.id AS id_6, s0_.discriminator AS discriminator_7 FROM setting s0_ WHERE s0_.discriminator IN ('basesetting') GROUP BY s0_.id;

SELECT
  t0.title AS title_1,
  t0.main AS main_2,
  t0.id AS id_3,
  t0.locale_id AS locale_id_4,
  t0.discriminator
FROM
  channel t0
  INNER JOIN menu_channel ON t0.id = menu_channel.channel_id
WHERE
  menu_channel.menu_id = ?
  AND t0.discriminator IN ('basechannel')

SELECT t0.title AS title_1, t0.main AS main_2, t0.id AS id_3, t0.locale_id AS locale_id_4, t0.discriminator FROM channel t0 INNER JOIN menu_channel ON t0.id = menu_channel.channel_id WHERE menu_channel.menu_id = 2 AND t0.discriminator IN ('basechannel');

SELECT
  l0_.code AS code_0,
  l0_.language_code AS language_code_1,
  l0_.country_code AS country_code_2,
  l0_.id AS id_3,
  l0_.discriminator AS discriminator_4
FROM
  locale l0_
WHERE
  l0_.discriminator IN ('baselocale')
GROUP BY
  l0_.id

SELECT l0_.code AS code_0, l0_.language_code AS language_code_1, l0_.country_code AS country_code_2, l0_.id AS id_3, l0_.discriminator AS discriminator_4 FROM locale l0_ WHERE l0_.discriminator IN ('baselocale') GROUP BY l0_.id;

SELECT
  m0_.title AS title_0,
  m0_.reference AS reference_1,
  m0_.created_by AS created_by_2,
  m0_.updated_by AS updated_by_3,
  m0_.id AS id_4,
  m0_.order_id AS order_id_5,
  m0_.created AS created_6,
  m0_.updated AS updated_7,
  c1_.title AS title_8,
  c1_.main AS main_9,
  c1_.id AS id_10,
  m0_.discriminator AS discriminator_11,
  c1_.discriminator AS discriminator_12,
  c1_.locale_id AS locale_id_13
FROM
  menu m0_
  LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id
  LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id
  AND c1_.discriminator IN ('basechannel')
WHERE
  (
    m0_.reference = 'main'
    AND c1_.id = 1
  )
  AND m0_.discriminator IN ('basemenu')
GROUP BY
  m0_.id

SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, c1_.title AS title_8, c1_.main AS main_9, c1_.id AS id_10, m0_.discriminator AS discriminator_11, c1_.discriminator AS discriminator_12, c1_.locale_id AS locale_id_13 FROM menu m0_ LEFT JOIN menu_channel m2_ ON m0_.id = m2_.menu_id LEFT JOIN channel c1_ ON c1_.id = m2_.channel_id AND c1_.discriminator IN ('basechannel') WHERE (m0_.reference = 'main' AND c1_.id = 1) AND m0_.discriminator IN ('basemenu') GROUP BY m0_.id;

SELECT
  t0.title AS title_1,
  t0.browser_title AS browser_title_2,
  t0.meta_description AS meta_description_3,
  t0.meta_keywords AS meta_keywords_4,
  t0.slug AS slug_5,
  t0.html_content AS html_content_6,
  t0.id AS id_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.channel_id AS channel_id_12,
  t0.locale_id AS locale_id_13,
  t0.page_id AS page_id_14,
  t0.discriminator
FROM
  page_content t0
WHERE
  t0.page_id = ?
  AND t0.discriminator IN ('basepagecontent')

SELECT t0.title AS title_1, t0.browser_title AS browser_title_2, t0.meta_description AS meta_description_3, t0.meta_keywords AS meta_keywords_4, t0.slug AS slug_5, t0.html_content AS html_content_6, t0.id AS id_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.created AS created_10, t0.updated AS updated_11, t0.channel_id AS channel_id_12, t0.locale_id AS locale_id_13, t0.page_id AS page_id_14, t0.discriminator FROM page_content t0 WHERE t0.page_id = 1 AND t0.discriminator IN ('basepagecontent');

SELECT
  m0_.title AS title_0,
  m0_.reference AS reference_1,
  m0_.created_by AS created_by_2,
  m0_.updated_by AS updated_by_3,
  m0_.id AS id_4,
  m0_.order_id AS order_id_5,
  m0_.created AS created_6,
  m0_.updated AS updated_7,
  m0_.discriminator AS discriminator_8
FROM
  menu m0_
WHERE
  m0_.discriminator IN ('basemenu')
GROUP BY
  m0_.id

SELECT m0_.title AS title_0, m0_.reference AS reference_1, m0_.created_by AS created_by_2, m0_.updated_by AS updated_by_3, m0_.id AS id_4, m0_.order_id AS order_id_5, m0_.created AS created_6, m0_.updated AS updated_7, m0_.discriminator AS discriminator_8 FROM menu m0_ WHERE m0_.discriminator IN ('basemenu') GROUP BY m0_.id;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.code AS code_1,
  t0.language_code AS language_code_2,
  t0.country_code AS country_code_3,
  t0.id AS id_4,
  t0.discriminator
FROM
  locale t0
  INNER JOIN domain_locale ON t0.id = domain_locale.locale_id
WHERE
  domain_locale.domain_id = ?
  AND t0.discriminator IN ('baselocale')

SELECT t0.code AS code_1, t0.language_code AS language_code_2, t0.country_code AS country_code_3, t0.id AS id_4, t0.discriminator FROM locale t0 INNER JOIN domain_locale ON t0.id = domain_locale.locale_id WHERE domain_locale.domain_id = 1 AND t0.discriminator IN ('baselocale');