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 = 'en' AND r0_.slug = '/products' ORDER BY r0_.webspace DESC LIMIT 1;

SELECT
  p0_.webspaceKey AS webspaceKey_0,
  p0_.lft AS lft_1,
  p0_.rgt AS rgt_2,
  p0_.depth AS depth_3,
  p0_.uuid AS uuid_4,
  p0_.created AS created_5,
  p0_.changed AS changed_6,
  p1_.title AS title_7,
  p1_.id AS id_8,
  p1_.stage AS stage_9,
  p1_.locale AS locale_10,
  p1_.ghostLocale AS ghostLocale_11,
  p1_.availableLocales AS availableLocales_12,
  p1_.version AS version_13,
  p1_.shadowLocale AS shadowLocale_14,
  p1_.shadowLocales AS shadowLocales_15,
  p1_.templateKey AS templateKey_16,
  p1_.templateData AS templateData_17,
  p1_.seoData AS seoData_18,
  p1_.seoNoIndex AS seoNoIndex_19,
  p1_.seoNoFollow AS seoNoFollow_20,
  p1_.seoHideInSitemap AS seoHideInSitemap_21,
  p1_.excerptData AS excerptData_22,
  p1_.excerptSegment AS excerptSegment_23,
  p1_.authored AS authored_24,
  p1_.lastModified AS lastModified_25,
  p1_.workflowPlace AS workflowPlace_26,
  p1_.workflowPublished AS workflowPublished_27,
  p1_.linkProvider AS linkProvider_28,
  p1_.linkData AS linkData_29,
  p1_.created AS created_30,
  p1_.changed AS changed_31,
  t2_.name AS name_32,
  t2_.id AS id_33,
  t2_.created AS created_34,
  t2_.changed AS changed_35,
  c3_.category_key AS category_key_36,
  c3_.default_locale AS default_locale_37,
  c3_.lft AS lft_38,
  c3_.rgt AS rgt_39,
  c3_.depth AS depth_40,
  c3_.id AS id_41,
  c3_.created AS created_42,
  c3_.changed AS changed_43,
  c4_.translation AS translation_44,
  c4_.locale AS locale_45,
  c4_.description AS description_46,
  c4_.id AS id_47,
  c4_.created AS created_48,
  c4_.changed AS changed_49,
  p0_.parent_id AS parent_id_50,
  p0_.idUsersCreator AS idUsersCreator_51,
  p0_.idUsersChanger AS idUsersChanger_52,
  p1_.route_id AS route_id_53,
  p1_.pageUuid AS pageUuid_54,
  p1_.author_id AS author_id_55,
  p1_.idUsersCreator AS idUsersCreator_56,
  p1_.idUsersChanger AS idUsersChanger_57,
  t2_.idUsersCreator AS idUsersCreator_58,
  t2_.idUsersChanger AS idUsersChanger_59,
  c3_.idCategoriesParent AS idCategoriesParent_60,
  c3_.idUsersCreator AS idUsersCreator_61,
  c3_.idUsersChanger AS idUsersChanger_62,
  c4_.idCategories AS idCategories_63,
  c4_.idUsersCreator AS idUsersCreator_64,
  c4_.idUsersChanger AS idUsersChanger_65
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
  LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id
  LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_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_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, t2_.name AS name_32, t2_.id AS id_33, t2_.created AS created_34, t2_.changed AS changed_35, c3_.category_key AS category_key_36, c3_.default_locale AS default_locale_37, c3_.lft AS lft_38, c3_.rgt AS rgt_39, c3_.depth AS depth_40, c3_.id AS id_41, c3_.created AS created_42, c3_.changed AS changed_43, c4_.translation AS translation_44, c4_.locale AS locale_45, c4_.description AS description_46, c4_.id AS id_47, c4_.created AS created_48, c4_.changed AS changed_49, p0_.parent_id AS parent_id_50, p0_.idUsersCreator AS idUsersCreator_51, p0_.idUsersChanger AS idUsersChanger_52, p1_.route_id AS route_id_53, p1_.pageUuid AS pageUuid_54, p1_.author_id AS author_id_55, p1_.idUsersCreator AS idUsersCreator_56, p1_.idUsersChanger AS idUsersChanger_57, t2_.idUsersCreator AS idUsersCreator_58, t2_.idUsersChanger AS idUsersChanger_59, c3_.idCategoriesParent AS idCategoriesParent_60, c3_.idUsersCreator AS idUsersCreator_61, c3_.idUsersChanger AS idUsersChanger_62, c4_.idCategories AS idCategories_63, c4_.idUsersCreator AS idUsersCreator_64, c4_.idUsersChanger AS idUsersChanger_65 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p5_ ON p1_.id = p5_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p5_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p6_ ON p1_.id = p6_.page_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 ('en')) WHERE p0_.uuid = '11111111-0000-4000-8000-000000000003' AND (((p1_.locale IS NULL OR p1_.locale IN ('en')) AND (p1_.stage IS NULL OR p1_.stage IN ('live'))) AND (p1_.version IS NULL OR p1_.version IN (0)));

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 25;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.page_dimension_content_id AS page_dimension_content_id_3
FROM
  pa_page_dimension_content_navigation_contexts t0
WHERE
  t0.page_dimension_content_id = ?

SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = 26;

SELECT
  p0_.attribute_key AS attribute_key_0
FROM
  pr_attributes p0_
WHERE
  p0_.type IN (?, ?)
  AND p0_.filterable = 1
ORDER BY
  p0_.attribute_key ASC

SELECT p0_.attribute_key AS attribute_key_0 FROM pr_attributes p0_ WHERE p0_.type IN ('number', 'date') AND p0_.filterable = 1 ORDER BY p0_.attribute_key ASC;

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_.locale IN (?, ?)
  AND r0_.resource_key = ?
  AND r0_.resource_id = ?

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_.locale IN ('en', 'de') AND r0_.resource_key = 'pages' AND r0_.resource_id = '11111111-0000-4000-8000-000000000003';

SELECT
  t0.external_identifier AS external_identifier_1,
  t0.attribute_key AS attribute_key_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.config AS config_5,
  t0.default_locale AS default_locale_6,
  t0.localized AS localized_7,
  t0.filterable AS filterable_8,
  t0.uuid AS uuid_9,
  t0.created AS created_10,
  t0.changed AS changed_11,
  t0.attributeGroupUuid AS attributeGroupUuid_12,
  t0.idUsersCreator AS idUsersCreator_13,
  t0.idUsersChanger AS idUsersChanger_14
FROM
  pr_attributes t0
WHERE
  t0.filterable = ?
ORDER BY
  t0.attribute_key ASC

SELECT t0.external_identifier AS external_identifier_1, t0.attribute_key AS attribute_key_2, t0.type AS type_3, t0.position AS position_4, t0.config AS config_5, t0.default_locale AS default_locale_6, t0.localized AS localized_7, t0.filterable AS filterable_8, t0.uuid AS uuid_9, t0.created AS created_10, t0.changed AS changed_11, t0.attributeGroupUuid AS attributeGroupUuid_12, t0.idUsersCreator AS idUsersCreator_13, t0.idUsersChanger AS idUsersChanger_14 FROM pr_attributes t0 WHERE t0.filterable = 1 ORDER BY t0.attribute_key ASC;

SELECT
  t0.external_identifier AS external_identifier_1,
  t0.attribute_key AS attribute_key_2,
  t0.type AS type_3,
  t0.position AS position_4,
  t0.config AS config_5,
  t0.default_locale AS default_locale_6,
  t0.localized AS localized_7,
  t0.filterable AS filterable_8,
  t0.uuid AS uuid_9,
  t0.created AS created_10,
  t0.changed AS changed_11,
  t0.attributeGroupUuid AS attributeGroupUuid_12,
  t0.idUsersCreator AS idUsersCreator_13,
  t0.idUsersChanger AS idUsersChanger_14
FROM
  pr_attributes t0
WHERE
  t0.attribute_key = ?
  AND t0.type = ?
LIMIT
  1

SELECT t0.external_identifier AS external_identifier_1, t0.attribute_key AS attribute_key_2, t0.type AS type_3, t0.position AS position_4, t0.config AS config_5, t0.default_locale AS default_locale_6, t0.localized AS localized_7, t0.filterable AS filterable_8, t0.uuid AS uuid_9, t0.created AS created_10, t0.changed AS changed_11, t0.attributeGroupUuid AS attributeGroupUuid_12, t0.idUsersCreator AS idUsersCreator_13, t0.idUsersChanger AS idUsersChanger_14 FROM pr_attributes t0 WHERE t0.attribute_key = 'temperature' AND t0.type = 'range' LIMIT 1;

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
ORDER BY
  t0.product_family_key ASC

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 ORDER BY t0.product_family_key ASC;

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bca8-7223-99aa-b34048ae394f';

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bc7b-71d3-9cb2-7f7a4b9ca388';

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bc59-769d-b372-d2c224863970';

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bc88-7713-bc0e-340e27414882';

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bc97-7707-adb9-d841898e9265';

SELECT
  t0.attribute_option_key AS attribute_option_key_1,
  t0.position AS position_2,
  t0.uuid AS uuid_3,
  t0.attributeUuid AS attributeUuid_4
FROM
  pr_attribute_options t0
WHERE
  t0.attributeUuid = ?

SELECT t0.attribute_option_key AS attribute_option_key_1, t0.position AS position_2, t0.uuid AS uuid_3, t0.attributeUuid AS attributeUuid_4 FROM pr_attribute_options t0 WHERE t0.attributeUuid = '01a1126d-bc69-75f3-a00a-d11b5bbee837';

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 = 'en' AND t0.productFamilyUuid = '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 = 'en' AND t0.productFamilyUuid = '01a1126d-bd2f-760c-bc4b-c7d7a089a573');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.attributeUuid AS attributeUuid_5
FROM
  pr_attribute_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.description AS description_3, t0.id AS id_4, t0.attributeUuid AS attributeUuid_5 FROM pr_attribute_translations t0 WHERE (t0.locale = 'en' AND t0.attributeUuid = '01a1126d-bca8-7223-99aa-b34048ae394f');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.id AS id_3, t0.attributeOptionUuid AS attributeOptionUuid_4 FROM pr_attribute_option_translations t0 WHERE (t0.locale = 'en' AND t0.attributeOptionUuid = '01a1126d-bca8-732f-99aa-b340494063f9');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.id AS id_3, t0.attributeOptionUuid AS attributeOptionUuid_4 FROM pr_attribute_option_translations t0 WHERE (t0.locale = 'en' AND t0.attributeOptionUuid = '01a1126d-bca8-736f-99aa-b3404a13ef37');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.id AS id_3, t0.attributeOptionUuid AS attributeOptionUuid_4 FROM pr_attribute_option_translations t0 WHERE (t0.locale = 'en' AND t0.attributeOptionUuid = '01a1126d-bca8-739b-99aa-b3404ac9ec88');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.id AS id_3, t0.attributeOptionUuid AS attributeOptionUuid_4 FROM pr_attribute_option_translations t0 WHERE (t0.locale = 'en' AND t0.attributeOptionUuid = '01a1126d-bca8-73c3-99aa-b3404b56252f');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )

SELECT t0.locale AS locale_1, t0.name AS name_2, t0.id AS id_3, t0.attributeOptionUuid AS attributeOptionUuid_4 FROM pr_attribute_option_translations t0 WHERE (t0.locale = 'en' AND t0.attributeOptionUuid = '01a1126d-bca8-73eb-99aa-b3404be95e09');

SELECT
  t0.locale AS locale_1,
  t0.name AS name_2,
  t0.id AS id_3,
  t0.attributeOptionUuid AS attributeOptionUuid_4
FROM
  pr_attribute_option_translations t0
WHERE
  (
    t0.locale = ?
    AND t0.attributeOptionUuid = ?
  )