Symfony Profiler

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.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.alias = ?
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.alias = 'robots.txt?_locale=nl' LIMIT 1;

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.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 ('/robots.txt', '/robots', '/') ORDER BY t0.position ASC;

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
  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 = '_profiler' LIMIT 1;