Symfony Profiler

SELECT
  r0_.webspace AS webspace_0,
  r0_.locale AS locale_1,
  r0_.slug AS slug_2,
  r0_.resource_key AS resource_key_3,
  r0_.resource_id AS resource_id_4,
  r0_.id AS id_5,
  r0_.parent_id AS parent_id_6
FROM
  ro_routes r0_
WHERE
  (
    (
      r0_.webspace = ?
      OR r0_.webspace IS NULL
    )
  )
  AND r0_.locale = ?
  AND r0_.slug = ?
ORDER BY
  r0_.webspace DESC
LIMIT
  1

SELECT r0_.webspace AS webspace_0, r0_.locale AS locale_1, r0_.slug AS slug_2, r0_.resource_key AS resource_key_3, r0_.resource_id AS resource_id_4, r0_.id AS id_5, r0_.parent_id AS parent_id_6 FROM ro_routes r0_ WHERE ((r0_.webspace = 'website' OR r0_.webspace IS NULL)) AND r0_.locale = 'de' AND r0_.slug = '/produkte/monstera' ORDER BY r0_.webspace DESC LIMIT 1;

SELECT
  p0_.type AS type_0,
  p0_.position AS position_1,
  p0_.uuid AS uuid_2,
  p0_.created AS created_3,
  p0_.changed AS changed_4,
  p1_.title AS title_5,
  p1_.customizeWebspaceSettings AS customizeWebspaceSettings_6,
  p1_.code AS code_7,
  p1_.external_identifier AS external_identifier_8,
  p1_.status AS status_9,
  p1_.details_data AS details_data_10,
  p1_.id AS id_11,
  p1_.stage AS stage_12,
  p1_.locale AS locale_13,
  p1_.ghostLocale AS ghostLocale_14,
  p1_.availableLocales AS availableLocales_15,
  p1_.version AS version_16,
  p1_.shadowLocale AS shadowLocale_17,
  p1_.shadowLocales AS shadowLocales_18,
  p1_.templateKey AS templateKey_19,
  p1_.templateData AS templateData_20,
  p1_.seoData AS seoData_21,
  p1_.seoNoIndex AS seoNoIndex_22,
  p1_.seoNoFollow AS seoNoFollow_23,
  p1_.seoHideInSitemap AS seoHideInSitemap_24,
  p1_.excerptData AS excerptData_25,
  p1_.excerptSegment AS excerptSegment_26,
  p1_.mainWebspace AS mainWebspace_27,
  p1_.authored AS authored_28,
  p1_.lastModified AS lastModified_29,
  p1_.workflowPlace AS workflowPlace_30,
  p1_.workflowPublished AS workflowPublished_31,
  p1_.created AS created_32,
  p1_.changed AS changed_33,
  t2_.name AS name_34,
  t2_.id AS id_35,
  t2_.created AS created_36,
  t2_.changed AS changed_37,
  c3_.category_key AS category_key_38,
  c3_.default_locale AS default_locale_39,
  c3_.lft AS lft_40,
  c3_.rgt AS rgt_41,
  c3_.depth AS depth_42,
  c3_.id AS id_43,
  c3_.created AS created_44,
  c3_.changed AS changed_45,
  c4_.translation AS translation_46,
  c4_.locale AS locale_47,
  c4_.description AS description_48,
  c4_.id AS id_49,
  c4_.created AS created_50,
  c4_.changed AS changed_51,
  p0_.parent_uuid AS parent_uuid_52,
  p0_.idUsersCreator AS idUsersCreator_53,
  p0_.idUsersChanger AS idUsersChanger_54,
  p1_.route_id AS route_id_55,
  p1_.productUuid AS productUuid_56,
  p1_.productFamilyUuid AS productFamilyUuid_57,
  p1_.author_id AS author_id_58,
  p1_.idUsersCreator AS idUsersCreator_59,
  p1_.idUsersChanger AS idUsersChanger_60,
  t2_.idUsersCreator AS idUsersCreator_61,
  t2_.idUsersChanger AS idUsersChanger_62,
  c3_.idCategoriesParent AS idCategoriesParent_63,
  c3_.idUsersCreator AS idUsersCreator_64,
  c3_.idUsersChanger AS idUsersChanger_65,
  c4_.idCategories AS idCategories_66,
  c4_.idUsersCreator AS idUsersCreator_67,
  c4_.idUsersChanger AS idUsersChanger_68
FROM
  pr_products p0_
  LEFT JOIN pr_product_dimension_contents p1_ ON p0_.uuid = p1_.productUuid
  LEFT JOIN pr_product_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.product_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id
  LEFT JOIN pr_product_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.product_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
  AND (
    c4_.locale = c3_.default_locale
    OR c4_.locale IN (?)
  )
WHERE
  p0_.uuid = ?
  AND (
    (
      (
        p1_.locale IS NULL
        OR p1_.locale IN (?)
      )
      AND (
        p1_.stage IS NULL
        OR p1_.stage IN (?)
      )
    )
    AND (
      p1_.version IS NULL
      OR p1_.version IN (?)
    )
  )

SELECT p0_.type AS type_0, p0_.position AS position_1, p0_.uuid AS uuid_2, p0_.created AS created_3, p0_.changed AS changed_4, p1_.title AS title_5, p1_.customizeWebspaceSettings AS customizeWebspaceSettings_6, p1_.code AS code_7, p1_.external_identifier AS external_identifier_8, p1_.status AS status_9, p1_.details_data AS details_data_10, p1_.id AS id_11, p1_.stage AS stage_12, p1_.locale AS locale_13, p1_.ghostLocale AS ghostLocale_14, p1_.availableLocales AS availableLocales_15, p1_.version AS version_16, p1_.shadowLocale AS shadowLocale_17, p1_.shadowLocales AS shadowLocales_18, p1_.templateKey AS templateKey_19, p1_.templateData AS templateData_20, p1_.seoData AS seoData_21, p1_.seoNoIndex AS seoNoIndex_22, p1_.seoNoFollow AS seoNoFollow_23, p1_.seoHideInSitemap AS seoHideInSitemap_24, p1_.excerptData AS excerptData_25, p1_.excerptSegment AS excerptSegment_26, p1_.mainWebspace AS mainWebspace_27, p1_.authored AS authored_28, p1_.lastModified AS lastModified_29, p1_.workflowPlace AS workflowPlace_30, p1_.workflowPublished AS workflowPublished_31, p1_.created AS created_32, p1_.changed AS changed_33, t2_.name AS name_34, t2_.id AS id_35, t2_.created AS created_36, t2_.changed AS changed_37, c3_.category_key AS category_key_38, c3_.default_locale AS default_locale_39, c3_.lft AS lft_40, c3_.rgt AS rgt_41, c3_.depth AS depth_42, c3_.id AS id_43, c3_.created AS created_44, c3_.changed AS changed_45, c4_.translation AS translation_46, c4_.locale AS locale_47, c4_.description AS description_48, c4_.id AS id_49, c4_.created AS created_50, c4_.changed AS changed_51, p0_.parent_uuid AS parent_uuid_52, p0_.idUsersCreator AS idUsersCreator_53, p0_.idUsersChanger AS idUsersChanger_54, p1_.route_id AS route_id_55, p1_.productUuid AS productUuid_56, p1_.productFamilyUuid AS productFamilyUuid_57, p1_.author_id AS author_id_58, p1_.idUsersCreator AS idUsersCreator_59, p1_.idUsersChanger AS idUsersChanger_60, t2_.idUsersCreator AS idUsersCreator_61, t2_.idUsersChanger AS idUsersChanger_62, c3_.idCategoriesParent AS idCategoriesParent_63, c3_.idUsersCreator AS idUsersCreator_64, c3_.idUsersChanger AS idUsersChanger_65, c4_.idCategories AS idCategories_66, c4_.idUsersCreator AS idUsersCreator_67, c4_.idUsersChanger AS idUsersChanger_68 FROM pr_products p0_ LEFT JOIN pr_product_dimension_contents p1_ ON p0_.uuid = p1_.productUuid LEFT JOIN pr_product_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.product_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pr_product_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.product_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p6_.category_id LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories AND (c4_.locale = c3_.default_locale OR c4_.locale IN ('de')) WHERE p0_.uuid = '66666666-0000-4000-8000-000000000001' AND (((p1_.locale IS NULL OR p1_.locale IN ('de')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0)));

SELECT
  p0_.title AS title_0,
  p0_.customizeWebspaceSettings AS customizeWebspaceSettings_1,
  p0_.code AS code_2,
  p0_.external_identifier AS external_identifier_3,
  p0_.status AS status_4,
  p0_.details_data AS details_data_5,
  p0_.id AS id_6,
  p0_.stage AS stage_7,
  p0_.locale AS locale_8,
  p0_.ghostLocale AS ghostLocale_9,
  p0_.availableLocales AS availableLocales_10,
  p0_.version AS version_11,
  p0_.shadowLocale AS shadowLocale_12,
  p0_.shadowLocales AS shadowLocales_13,
  p0_.templateKey AS templateKey_14,
  p0_.templateData AS templateData_15,
  p0_.seoData AS seoData_16,
  p0_.seoNoIndex AS seoNoIndex_17,
  p0_.seoNoFollow AS seoNoFollow_18,
  p0_.seoHideInSitemap AS seoHideInSitemap_19,
  p0_.excerptData AS excerptData_20,
  p0_.excerptSegment AS excerptSegment_21,
  p0_.mainWebspace AS mainWebspace_22,
  p0_.authored AS authored_23,
  p0_.lastModified AS lastModified_24,
  p0_.workflowPlace AS workflowPlace_25,
  p0_.workflowPublished AS workflowPublished_26,
  p0_.created AS created_27,
  p0_.changed AS changed_28,
  p1_.attributeKey AS attributeKey_29,
  p1_.valueKey AS valueKey_30,
  p1_.number AS number_31,
  p1_.text AS text_32,
  p1_.id AS id_33,
  p2_.external_identifier AS external_identifier_34,
  p2_.attribute_key AS attribute_key_35,
  p2_.type AS type_36,
  p2_.position AS position_37,
  p2_.config AS config_38,
  p2_.default_locale AS default_locale_39,
  p2_.localized AS localized_40,
  p2_.filterable AS filterable_41,
  p2_.uuid AS uuid_42,
  p2_.created AS created_43,
  p2_.changed AS changed_44,
  p0_.route_id AS route_id_45,
  p0_.productUuid AS productUuid_46,
  p0_.productFamilyUuid AS productFamilyUuid_47,
  p0_.author_id AS author_id_48,
  p0_.idUsersCreator AS idUsersCreator_49,
  p0_.idUsersChanger AS idUsersChanger_50,
  p1_.productDimensionContentId AS productDimensionContentId_51,
  p1_.attributeUuid AS attributeUuid_52,
  p1_.attributeOptionUuid AS attributeOptionUuid_53,
  p1_.productFamilyAttributeId AS productFamilyAttributeId_54,
  p2_.attributeGroupUuid AS attributeGroupUuid_55,
  p2_.idUsersCreator AS idUsersCreator_56,
  p2_.idUsersChanger AS idUsersChanger_57
FROM
  pr_product_dimension_contents p0_
  LEFT JOIN pr_product_attribute_values p1_ ON p0_.id = p1_.productDimensionContentId
  LEFT JOIN pr_attributes p2_ ON p1_.attributeUuid = p2_.uuid
WHERE
  p0_.id IN (?, ?)

SELECT p0_.title AS title_0, p0_.customizeWebspaceSettings AS customizeWebspaceSettings_1, p0_.code AS code_2, p0_.external_identifier AS external_identifier_3, p0_.status AS status_4, p0_.details_data AS details_data_5, p0_.id AS id_6, p0_.stage AS stage_7, p0_.locale AS locale_8, p0_.ghostLocale AS ghostLocale_9, p0_.availableLocales AS availableLocales_10, p0_.version AS version_11, p0_.shadowLocale AS shadowLocale_12, p0_.shadowLocales AS shadowLocales_13, p0_.templateKey AS templateKey_14, p0_.templateData AS templateData_15, p0_.seoData AS seoData_16, p0_.seoNoIndex AS seoNoIndex_17, p0_.seoNoFollow AS seoNoFollow_18, p0_.seoHideInSitemap AS seoHideInSitemap_19, p0_.excerptData AS excerptData_20, p0_.excerptSegment AS excerptSegment_21, p0_.mainWebspace AS mainWebspace_22, p0_.authored AS authored_23, p0_.lastModified AS lastModified_24, p0_.workflowPlace AS workflowPlace_25, p0_.workflowPublished AS workflowPublished_26, p0_.created AS created_27, p0_.changed AS changed_28, p1_.attributeKey AS attributeKey_29, p1_.valueKey AS valueKey_30, p1_.number AS number_31, p1_.text AS text_32, p1_.id AS id_33, p2_.external_identifier AS external_identifier_34, p2_.attribute_key AS attribute_key_35, p2_.type AS type_36, p2_.position AS position_37, p2_.config AS config_38, p2_.default_locale AS default_locale_39, p2_.localized AS localized_40, p2_.filterable AS filterable_41, p2_.uuid AS uuid_42, p2_.created AS created_43, p2_.changed AS changed_44, p0_.route_id AS route_id_45, p0_.productUuid AS productUuid_46, p0_.productFamilyUuid AS productFamilyUuid_47, p0_.author_id AS author_id_48, p0_.idUsersCreator AS idUsersCreator_49, p0_.idUsersChanger AS idUsersChanger_50, p1_.productDimensionContentId AS productDimensionContentId_51, p1_.attributeUuid AS attributeUuid_52, p1_.attributeOptionUuid AS attributeOptionUuid_53, p1_.productFamilyAttributeId AS productFamilyAttributeId_54, p2_.attributeGroupUuid AS attributeGroupUuid_55, p2_.idUsersCreator AS idUsersCreator_56, p2_.idUsersChanger AS idUsersChanger_57 FROM pr_product_dimension_contents p0_ LEFT JOIN pr_product_attribute_values p1_ ON p0_.id = p1_.productDimensionContentId LEFT JOIN pr_attributes p2_ ON p1_.attributeUuid = p2_.uuid WHERE p0_.id IN (310, 314);

SELECT
  p0_.external_identifier AS external_identifier_0,
  p0_.attribute_key AS attribute_key_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.config AS config_4,
  p0_.default_locale AS default_locale_5,
  p0_.localized AS localized_6,
  p0_.filterable AS filterable_7,
  p0_.uuid AS uuid_8,
  p0_.created AS created_9,
  p0_.changed AS changed_10,
  p1_.locale AS locale_11,
  p1_.name AS name_12,
  p1_.description AS description_13,
  p1_.id AS id_14,
  p2_.external_identifier AS external_identifier_15,
  p2_.default_locale AS default_locale_16,
  p2_.uuid AS uuid_17,
  p2_.created AS created_18,
  p2_.changed AS changed_19,
  p0_.attributeGroupUuid AS attributeGroupUuid_20,
  p0_.idUsersCreator AS idUsersCreator_21,
  p0_.idUsersChanger AS idUsersChanger_22,
  p1_.attributeUuid AS attributeUuid_23,
  p2_.idUsersCreator AS idUsersCreator_24,
  p2_.idUsersChanger AS idUsersChanger_25
FROM
  pr_attributes p0_
  LEFT JOIN pr_attribute_translations p1_ ON p0_.uuid = p1_.attributeUuid
  INNER JOIN pr_attribute_groups p2_ ON p0_.attributeGroupUuid = p2_.uuid
WHERE
  p0_.uuid IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.external_identifier AS external_identifier_0, p0_.attribute_key AS attribute_key_1, p0_.type AS type_2, p0_.position AS position_3, p0_.config AS config_4, p0_.default_locale AS default_locale_5, p0_.localized AS localized_6, p0_.filterable AS filterable_7, p0_.uuid AS uuid_8, p0_.created AS created_9, p0_.changed AS changed_10, p1_.locale AS locale_11, p1_.name AS name_12, p1_.description AS description_13, p1_.id AS id_14, p2_.external_identifier AS external_identifier_15, p2_.default_locale AS default_locale_16, p2_.uuid AS uuid_17, p2_.created AS created_18, p2_.changed AS changed_19, p0_.attributeGroupUuid AS attributeGroupUuid_20, p0_.idUsersCreator AS idUsersCreator_21, p0_.idUsersChanger AS idUsersChanger_22, p1_.attributeUuid AS attributeUuid_23, p2_.idUsersCreator AS idUsersCreator_24, p2_.idUsersChanger AS idUsersChanger_25 FROM pr_attributes p0_ LEFT JOIN pr_attribute_translations p1_ ON p0_.uuid = p1_.attributeUuid INNER JOIN pr_attribute_groups p2_ ON p0_.attributeGroupUuid = p2_.uuid WHERE p0_.uuid IN ('01a1126d-bc59-769d-b372-d2c224863970', '01a1126d-bc69-75f3-a00a-d11b5bbee837', '01a1126d-bc7b-71d3-9cb2-7f7a4b9ca388', '01a1126d-bc88-7713-bc0e-340e27414882', '01a1126d-bc97-7707-adb9-d841898e9265', '01a1126d-bcbc-7b34-aad1-fbeb55af60d5', '01a1126d-bcc7-7102-b06a-cdc675ffa0e3', '01a1126d-bcd1-768f-aea6-509627ceb602');

SELECT
  p0_.external_identifier AS external_identifier_0,
  p0_.default_locale AS default_locale_1,
  p0_.uuid AS uuid_2,
  p0_.created AS created_3,
  p0_.changed AS changed_4,
  p1_.locale AS locale_5,
  p1_.name AS name_6,
  p1_.description AS description_7,
  p1_.id AS id_8,
  p0_.idUsersCreator AS idUsersCreator_9,
  p0_.idUsersChanger AS idUsersChanger_10,
  p1_.attributeGroupUuid AS attributeGroupUuid_11
FROM
  pr_attribute_groups p0_
  LEFT JOIN pr_attribute_group_translations p1_ ON p0_.uuid = p1_.attributeGroupUuid
WHERE
  p0_.uuid IN (?)

SELECT p0_.external_identifier AS external_identifier_0, p0_.default_locale AS default_locale_1, p0_.uuid AS uuid_2, p0_.created AS created_3, p0_.changed AS changed_4, p1_.locale AS locale_5, p1_.name AS name_6, p1_.description AS description_7, p1_.id AS id_8, p0_.idUsersCreator AS idUsersCreator_9, p0_.idUsersChanger AS idUsersChanger_10, p1_.attributeGroupUuid AS attributeGroupUuid_11 FROM pr_attribute_groups p0_ LEFT JOIN pr_attribute_group_translations p1_ ON p0_.uuid = p1_.attributeGroupUuid WHERE p0_.uuid IN ('01a1126d-bc4d-7a34-b40e-bee3e704466a');

SELECT
  p0_.external_identifier AS external_identifier_0,
  p0_.attribute_key AS attribute_key_1,
  p0_.type AS type_2,
  p0_.position AS position_3,
  p0_.config AS config_4,
  p0_.default_locale AS default_locale_5,
  p0_.localized AS localized_6,
  p0_.filterable AS filterable_7,
  p0_.uuid AS uuid_8,
  p0_.created AS created_9,
  p0_.changed AS changed_10,
  p1_.attribute_option_key AS attribute_option_key_11,
  p1_.position AS position_12,
  p1_.uuid AS uuid_13,
  p2_.locale AS locale_14,
  p2_.name AS name_15,
  p2_.id AS id_16,
  p0_.attributeGroupUuid AS attributeGroupUuid_17,
  p0_.idUsersCreator AS idUsersCreator_18,
  p0_.idUsersChanger AS idUsersChanger_19,
  p1_.attributeUuid AS attributeUuid_20,
  p2_.attributeOptionUuid AS attributeOptionUuid_21
FROM
  pr_attributes p0_
  LEFT JOIN pr_attribute_options p1_ ON p0_.uuid = p1_.attributeUuid
  LEFT JOIN pr_attribute_option_translations p2_ ON p1_.uuid = p2_.attributeOptionUuid
WHERE
  p0_.uuid IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT p0_.external_identifier AS external_identifier_0, p0_.attribute_key AS attribute_key_1, p0_.type AS type_2, p0_.position AS position_3, p0_.config AS config_4, p0_.default_locale AS default_locale_5, p0_.localized AS localized_6, p0_.filterable AS filterable_7, p0_.uuid AS uuid_8, p0_.created AS created_9, p0_.changed AS changed_10, p1_.attribute_option_key AS attribute_option_key_11, p1_.position AS position_12, p1_.uuid AS uuid_13, p2_.locale AS locale_14, p2_.name AS name_15, p2_.id AS id_16, p0_.attributeGroupUuid AS attributeGroupUuid_17, p0_.idUsersCreator AS idUsersCreator_18, p0_.idUsersChanger AS idUsersChanger_19, p1_.attributeUuid AS attributeUuid_20, p2_.attributeOptionUuid AS attributeOptionUuid_21 FROM pr_attributes p0_ LEFT JOIN pr_attribute_options p1_ ON p0_.uuid = p1_.attributeUuid LEFT JOIN pr_attribute_option_translations p2_ ON p1_.uuid = p2_.attributeOptionUuid WHERE p0_.uuid IN ('01a1126d-bc59-769d-b372-d2c224863970', '01a1126d-bc69-75f3-a00a-d11b5bbee837', '01a1126d-bc7b-71d3-9cb2-7f7a4b9ca388', '01a1126d-bc88-7713-bc0e-340e27414882', '01a1126d-bc97-7707-adb9-d841898e9265', '01a1126d-bcbc-7b34-aad1-fbeb55af60d5', '01a1126d-bcc7-7102-b06a-cdc675ffa0e3', '01a1126d-bcd1-768f-aea6-509627ceb602');

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.product_dimension_content_id AS product_dimension_content_id_3
FROM
  pr_product_dimension_content_additional_webspaces t0
WHERE
  t0.product_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.product_dimension_content_id AS product_dimension_content_id_3 FROM pr_product_dimension_content_additional_webspaces t0 WHERE t0.product_dimension_content_id = 310;

SELECT
  t0.type AS type_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.productDimensionContentId AS productDimensionContentId_4,
  t0.targetProductUuid AS targetProductUuid_5
FROM
  pr_product_associations t0
WHERE
  t0.productDimensionContentId = ?

SELECT t0.type AS type_1, t0.position AS position_2, t0.id AS id_3, t0.productDimensionContentId AS productDimensionContentId_4, t0.targetProductUuid AS targetProductUuid_5 FROM pr_product_associations t0 WHERE t0.productDimensionContentId = 310;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.product_dimension_content_id AS product_dimension_content_id_3
FROM
  pr_product_dimension_content_additional_webspaces t0
WHERE
  t0.product_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.product_dimension_content_id AS product_dimension_content_id_3 FROM pr_product_dimension_content_additional_webspaces t0 WHERE t0.product_dimension_content_id = 314;

SELECT
  t0.type AS type_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.productDimensionContentId AS productDimensionContentId_4,
  t0.targetProductUuid AS targetProductUuid_5
FROM
  pr_product_associations t0
WHERE
  t0.productDimensionContentId = ?

SELECT t0.type AS type_1, t0.position AS position_2, t0.id AS id_3, t0.productDimensionContentId AS productDimensionContentId_4, t0.targetProductUuid AS targetProductUuid_5 FROM pr_product_associations t0 WHERE t0.productDimensionContentId = 314;

SELECT
  t0.webspace AS webspace_1,
  t0.locale AS locale_2,
  t0.slug AS slug_3,
  t0.resource_key AS resource_key_4,
  t0.resource_id AS resource_id_5,
  t0.id AS id_6,
  t0.parent_id AS parent_id_7
FROM
  ro_routes t0
WHERE
  t0.id = ?

SELECT t0.webspace AS webspace_1, t0.locale AS locale_2, t0.slug AS slug_3, t0.resource_key AS resource_key_4, t0.resource_id AS resource_id_5, t0.id AS id_6, t0.parent_id AS parent_id_7 FROM ro_routes t0 WHERE t0.id = 9;

SELECT
  t0.external_identifier AS external_identifier_1,
  t0.product_family_key AS product_family_key_2,
  t0.default_locale AS default_locale_3,
  t0.uuid AS uuid_4,
  t0.created AS created_5,
  t0.changed AS changed_6,
  t0.image_id AS image_id_7,
  t0.idUsersCreator AS idUsersCreator_8,
  t0.idUsersChanger AS idUsersChanger_9
FROM
  pr_product_families t0
WHERE
  t0.uuid = ?

SELECT t0.external_identifier AS external_identifier_1, t0.product_family_key AS product_family_key_2, t0.default_locale AS default_locale_3, t0.uuid AS uuid_4, t0.created AS created_5, t0.changed AS changed_6, t0.image_id AS image_id_7, t0.idUsersCreator AS idUsersCreator_8, t0.idUsersChanger AS idUsersChanger_9 FROM pr_product_families t0 WHERE t0.uuid = '01a1126d-bcda-7b3c-bfcc-ff2f04e74f49';

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.productFamilyUuid AS productFamilyUuid_5
FROM
  pr_product_family_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.productFamilyUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.description AS description_3, t0.id AS id_4, t0.productFamilyUuid AS productFamilyUuid_5 FROM pr_product_family_translations t0 WHERE (t0.locale = 'de' AND t0.productFamilyUuid = '01a1126d-bcda-7b3c-bfcc-ff2f04e74f49');