Symfony Profiler

SELECT
  s0_.`key` AS key_0,
  s0_.value AS value_1
FROM
  settings s0_

SELECT s0_.`key` AS key_0, s0_.value AS value_1 FROM settings s0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alias AS alias_3,
  t0.domain AS domain_4,
  t0.business AS business_5,
  t0.status AS status_6,
  t0.name_in_logo AS name_in_logo_7,
  t0.slogan AS slogan_8,
  t0.introduction AS introduction_9,
  t0.usp_title AS usp_title_10,
  t0.usps AS usps_11,
  t0.about_us AS about_us_12,
  t0.contact_email AS contact_email_13,
  t0.contact_phone AS contact_phone_14,
  t0.contact_phone_notes AS contact_phone_notes_15,
  t0.agb_code AS agb_code_16,
  t0.facebook_slug AS facebook_slug_17,
  t0.instagram_slug AS instagram_slug_18,
  t0.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_19,
  t0.terms_and_conditions AS terms_and_conditions_20,
  t0.privacy_policy AS privacy_policy_21,
  t0.settings AS settings_22,
  t0.gtm_id AS gtm_id_23,
  t0.logo_id AS logo_id_24,
  t0.hero_image_id AS hero_image_id_25,
  t0.introduction_image_id AS introduction_image_id_26,
  t0.hkz_qr_code_id AS hkz_qr_code_id_27,
  t0.main_location_id AS main_location_id_28,
  t0.specialist_role_id AS specialist_role_id_29,
  t0.main_menu_id AS main_menu_id_30,
  t0.theme_id AS theme_id_31
FROM
  portal t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.domain AS domain_4, t0.business AS business_5, t0.status AS status_6, t0.name_in_logo AS name_in_logo_7, t0.slogan AS slogan_8, t0.introduction AS introduction_9, t0.usp_title AS usp_title_10, t0.usps AS usps_11, t0.about_us AS about_us_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.contact_phone_notes AS contact_phone_notes_15, t0.agb_code AS agb_code_16, t0.facebook_slug AS facebook_slug_17, t0.instagram_slug AS instagram_slug_18, t0.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_19, t0.terms_and_conditions AS terms_and_conditions_20, t0.privacy_policy AS privacy_policy_21, t0.settings AS settings_22, t0.gtm_id AS gtm_id_23, t0.logo_id AS logo_id_24, t0.hero_image_id AS hero_image_id_25, t0.introduction_image_id AS introduction_image_id_26, t0.hkz_qr_code_id AS hkz_qr_code_id_27, t0.main_location_id AS main_location_id_28, t0.specialist_role_id AS specialist_role_id_29, t0.main_menu_id AS main_menu_id_30, t0.theme_id AS theme_id_31 FROM portal t0 WHERE t0.domain = 'www.v3.pharmanexus.nl' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.alias AS alias_2,
  p0_.domain AS domain_3,
  p0_.business AS business_4,
  p0_.status AS status_5,
  p0_.name_in_logo AS name_in_logo_6,
  p0_.slogan AS slogan_7,
  p0_.introduction AS introduction_8,
  p0_.usp_title AS usp_title_9,
  p0_.usps AS usps_10,
  p0_.about_us AS about_us_11,
  p0_.contact_email AS contact_email_12,
  p0_.contact_phone AS contact_phone_13,
  p0_.contact_phone_notes AS contact_phone_notes_14,
  p0_.agb_code AS agb_code_15,
  p0_.facebook_slug AS facebook_slug_16,
  p0_.instagram_slug AS instagram_slug_17,
  p0_.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_18,
  p0_.terms_and_conditions AS terms_and_conditions_19,
  p0_.privacy_policy AS privacy_policy_20,
  p0_.settings AS settings_21,
  p0_.gtm_id AS gtm_id_22,
  p1_.id AS id_23,
  p1_.short_description_override AS short_description_override_24,
  p1_.medium_description_override AS medium_description_override_25,
  p1_.long_description_override AS long_description_override_26,
  p1_.extra_info AS extra_info_27,
  p1_.active AS active_28,
  p2_.id AS id_29,
  p2_.name AS name_30,
  p2_.short_description AS short_description_31,
  p2_.medium_description AS medium_description_32,
  p2_.long_description AS long_description_33,
  p2_.cta_label AS cta_label_34,
  p2_.icon AS icon_35,
  p2_.page_content AS page_content_36,
  p2_.meta_title AS meta_title_37,
  p2_.meta_description AS meta_description_38,
  p2_.status AS status_39,
  p2_.product_variant AS product_variant_40,
  p2_.engagement_method AS engagement_method_41,
  p2_.config AS config_42,
  p3_.id AS id_43,
  p3_.extra_info AS extra_info_44,
  p3_.active AS active_45,
  l4_.id AS id_46,
  l4_.type AS type_47,
  l4_.name AS name_48,
  l4_.contact_email AS contact_email_49,
  l4_.contact_phone AS contact_phone_50,
  l4_.opening_hours AS opening_hours_51,
  l4_.alt_opening_hours AS alt_opening_hours_52,
  l4_.street AS street_53,
  l4_.number AS number_54,
  l4_.number_addition AS number_addition_55,
  l4_.complement AS complement_56,
  l4_.neighborhood AS neighborhood_57,
  l4_.city AS city_58,
  l4_.province AS province_59,
  l4_.state AS state_60,
  l4_.zip AS zip_61,
  l4_.country AS country_62,
  p0_.logo_id AS logo_id_63,
  p0_.hero_image_id AS hero_image_id_64,
  p0_.introduction_image_id AS introduction_image_id_65,
  p0_.hkz_qr_code_id AS hkz_qr_code_id_66,
  p0_.main_location_id AS main_location_id_67,
  p0_.specialist_role_id AS specialist_role_id_68,
  p0_.main_menu_id AS main_menu_id_69,
  p0_.theme_id AS theme_id_70,
  p1_.portal_id AS portal_id_71,
  p1_.product_id AS product_id_72,
  p2_.image_id AS image_id_73,
  p2_.downloadable_form_id AS downloadable_form_id_74,
  p3_.portal_id AS portal_id_75,
  p3_.location_id AS location_id_76
FROM
  portal p0_
  LEFT JOIN portal_product p1_ ON p0_.id = p1_.portal_id
  LEFT JOIN product p2_ ON p1_.product_id = p2_.id
  LEFT JOIN portal_location p3_ ON p0_.id = p3_.portal_id
  LEFT JOIN location l4_ ON p3_.location_id = l4_.id
WHERE
  p0_.id = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.alias AS alias_2, p0_.domain AS domain_3, p0_.business AS business_4, p0_.status AS status_5, p0_.name_in_logo AS name_in_logo_6, p0_.slogan AS slogan_7, p0_.introduction AS introduction_8, p0_.usp_title AS usp_title_9, p0_.usps AS usps_10, p0_.about_us AS about_us_11, p0_.contact_email AS contact_email_12, p0_.contact_phone AS contact_phone_13, p0_.contact_phone_notes AS contact_phone_notes_14, p0_.agb_code AS agb_code_15, p0_.facebook_slug AS facebook_slug_16, p0_.instagram_slug AS instagram_slug_17, p0_.healthcare_contact_email_addresses AS healthcare_contact_email_addresses_18, p0_.terms_and_conditions AS terms_and_conditions_19, p0_.privacy_policy AS privacy_policy_20, p0_.settings AS settings_21, p0_.gtm_id AS gtm_id_22, p1_.id AS id_23, p1_.short_description_override AS short_description_override_24, p1_.medium_description_override AS medium_description_override_25, p1_.long_description_override AS long_description_override_26, p1_.extra_info AS extra_info_27, p1_.active AS active_28, p2_.id AS id_29, p2_.name AS name_30, p2_.short_description AS short_description_31, p2_.medium_description AS medium_description_32, p2_.long_description AS long_description_33, p2_.cta_label AS cta_label_34, p2_.icon AS icon_35, p2_.page_content AS page_content_36, p2_.meta_title AS meta_title_37, p2_.meta_description AS meta_description_38, p2_.status AS status_39, p2_.product_variant AS product_variant_40, p2_.engagement_method AS engagement_method_41, p2_.config AS config_42, p3_.id AS id_43, p3_.extra_info AS extra_info_44, p3_.active AS active_45, l4_.id AS id_46, l4_.type AS type_47, l4_.name AS name_48, l4_.contact_email AS contact_email_49, l4_.contact_phone AS contact_phone_50, l4_.opening_hours AS opening_hours_51, l4_.alt_opening_hours AS alt_opening_hours_52, l4_.street AS street_53, l4_.number AS number_54, l4_.number_addition AS number_addition_55, l4_.complement AS complement_56, l4_.neighborhood AS neighborhood_57, l4_.city AS city_58, l4_.province AS province_59, l4_.state AS state_60, l4_.zip AS zip_61, l4_.country AS country_62, p0_.logo_id AS logo_id_63, p0_.hero_image_id AS hero_image_id_64, p0_.introduction_image_id AS introduction_image_id_65, p0_.hkz_qr_code_id AS hkz_qr_code_id_66, p0_.main_location_id AS main_location_id_67, p0_.specialist_role_id AS specialist_role_id_68, p0_.main_menu_id AS main_menu_id_69, p0_.theme_id AS theme_id_70, p1_.portal_id AS portal_id_71, p1_.product_id AS product_id_72, p2_.image_id AS image_id_73, p2_.downloadable_form_id AS downloadable_form_id_74, p3_.portal_id AS portal_id_75, p3_.location_id AS location_id_76 FROM portal p0_ LEFT JOIN portal_product p1_ ON p0_.id = p1_.portal_id LEFT JOIN product p2_ ON p1_.product_id = p2_.id LEFT JOIN portal_location p3_ ON p0_.id = p3_.portal_id LEFT JOIN location l4_ ON p3_.location_id = l4_.id WHERE p0_.id = 1;

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.`condition` AS condition_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.name AS name_10,
  t0.position AS position_11,
  t0.id AS id_12
FROM
  orm_routes t0
WHERE
  t0.staticPrefix IN (?)
ORDER BY
  t0.position ASC

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.staticPrefix IN ('/') ORDER BY t0.position ASC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.alias AS alias_2,
  p0_.meta_title AS meta_title_3,
  p0_.meta_description AS meta_description_4,
  p0_.page_type AS page_type_5,
  p0_.page_config AS page_config_6,
  p0_.parent_id AS parent_id_7,
  p0_.hero_image_id AS hero_image_id_8
FROM
  page p0_
WHERE
  p0_.parent_id IS NULL

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.alias AS alias_2, p0_.meta_title AS meta_title_3, p0_.meta_description AS meta_description_4, p0_.page_type AS page_type_5, p0_.page_config AS page_config_6, p0_.parent_id AS parent_id_7, p0_.hero_image_id AS hero_image_id_8 FROM page p0_ WHERE p0_.parent_id IS NULL;

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.`condition` AS condition_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.name AS name_10,
  t0.position AS position_11,
  t0.id AS id_12
FROM
  orm_routes t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.`condition` AS condition_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.name AS name_10, t0.position AS position_11, t0.id AS id_12 FROM orm_routes t0 WHERE t0.name = 'vweb_pharma_nexus_home' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.default_theme AS default_theme_3,
  t0.theme AS theme_4,
  t0.theme_config AS theme_config_5,
  t0.brand_color AS brand_color_6,
  t0.accent_color AS accent_color_7,
  t0.gray_color AS gray_color_8
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_theme AS default_theme_3, t0.theme AS theme_4, t0.theme_config AS theme_config_5, t0.brand_color AS brand_color_6, t0.accent_color AS accent_color_7, t0.gray_color AS gray_color_8 FROM theme t0 WHERE t0.id = 1;

SELECT
  t0.settings AS settings_1,
  t0.configured_theme_id AS configured_theme_id_2,
  t0.portal_id AS portal_id_3
FROM
  portal_theme_config t0
WHERE
  t0.configured_theme_id = ?
  AND t0.portal_id = ?

SELECT t0.settings AS settings_1, t0.configured_theme_id AS configured_theme_id_2, t0.portal_id AS portal_id_3 FROM portal_theme_config t0 WHERE t0.configured_theme_id = 1 AND t0.portal_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.checksum AS checksum_3,
  t0.type AS type_4,
  t0.mime_type AS mime_type_5,
  t0.locator AS locator_6,
  t0.storage AS storage_7,
  t0.strategy_signature AS strategy_signature_8
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.checksum AS checksum_3, t0.type AS type_4, t0.mime_type AS mime_type_5, t0.locator AS locator_6, t0.storage AS storage_7, t0.strategy_signature AS strategy_signature_8 FROM media t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.notes AS notes_2,
  t0.holiday AS holiday_3,
  t0.exact_date AS exact_date_4,
  t0.open AS open_5,
  t0.open24_hours AS open24_hours_6,
  t0.disallow_closed_overwriting AS disallow_closed_overwriting_7,
  t0.shifts AS shifts_8,
  t0.location_id AS location_id_9
FROM
  special_opening_hours t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.notes AS notes_2, t0.holiday AS holiday_3, t0.exact_date AS exact_date_4, t0.open AS open_5, t0.open24_hours AS open24_hours_6, t0.disallow_closed_overwriting AS disallow_closed_overwriting_7, t0.shifts AS shifts_8, t0.location_id AS location_id_9 FROM special_opening_hours t0 WHERE t0.location_id = 1;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.message AS message_2,
  n0_.popup AS popup_3,
  n0_.publish_up_at AS publish_up_at_4,
  n0_.publish_down_at AS publish_down_at_5,
  n0_.updated_at AS updated_at_6
FROM
  notification n0_
WHERE
  n0_.popup = 1
  AND (
    ? BETWEEN n0_.publish_up_at
    AND n0_.publish_down_at
  )
ORDER BY
  n0_.publish_up_at DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.message AS message_2, n0_.popup AS popup_3, n0_.publish_up_at AS publish_up_at_4, n0_.publish_down_at AS publish_down_at_5, n0_.updated_at AS updated_at_6 FROM notification n0_ WHERE n0_.popup = 1 AND ('2026-02-05 18:28:59' BETWEEN n0_.publish_up_at AND n0_.publish_down_at) ORDER BY n0_.publish_up_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.checksum AS checksum_3,
  t0.type AS type_4,
  t0.mime_type AS mime_type_5,
  t0.locator AS locator_6,
  t0.storage AS storage_7,
  t0.strategy_signature AS strategy_signature_8
FROM
  media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.checksum AS checksum_3, t0.type AS type_4, t0.mime_type AS mime_type_5, t0.locator AS locator_6, t0.storage AS storage_7, t0.strategy_signature AS strategy_signature_8 FROM media t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.root_node_id AS root_node_id_3,
  t4.id AS id_5,
  t4.name AS name_6,
  t4.action AS action_7,
  t4.label AS label_8,
  t4.options AS options_9,
  t4.position AS position_10,
  t4.menu_id AS menu_id_11,
  t4.parent_id AS parent_id_12
FROM
  menu t0
  LEFT JOIN menu_node t4 ON t0.root_node_id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.root_node_id AS root_node_id_3, t4.id AS id_5, t4.name AS name_6, t4.action AS action_7, t4.label AS label_8, t4.options AS options_9, t4.position AS position_10, t4.menu_id AS menu_id_11, t4.parent_id AS parent_id_12 FROM menu t0 LEFT JOIN menu_node t4 ON t0.root_node_id = t4.id WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (11) ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.action AS action_3,
  t0.label AS label_4,
  t0.options AS options_5,
  t0.position AS position_6,
  t0.menu_id AS menu_id_7,
  t0.parent_id AS parent_id_8
FROM
  menu_node t0
WHERE
  t0.parent_id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.action AS action_3, t0.label AS label_4, t0.options AS options_5, t0.position AS position_6, t0.menu_id AS menu_id_7, t0.parent_id AS parent_id_8 FROM menu_node t0 WHERE t0.parent_id IN (12, 20, 13, 19, 14, 18) ORDER BY t0.position ASC;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.root_node_id AS root_node_id_2
FROM
  menu m0_
WHERE
  m0_.name = ?

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.root_node_id AS root_node_id_2 FROM menu m0_ WHERE m0_.name = 'main';