Symfony Profiler

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,
  r4_.webspace AS webspace_44,
  r4_.locale AS locale_45,
  r4_.slug AS slug_46,
  r4_.resource_key AS resource_key_47,
  r4_.resource_id AS resource_id_48,
  r4_.id AS id_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,
  r4_.parent_id AS parent_id_63
FROM
  pa_pages p0_
  LEFT JOIN pa_page_dimension_contents p5_ ON (p5_.pageUuid = p0_.uuid)
  LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid
  LEFT JOIN pa_page_dimension_content_excerpt_tags p6_ ON p1_.id = p6_.page_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = p6_.tag_id
  LEFT JOIN pa_page_dimension_content_excerpt_categories p7_ ON p1_.id = p7_.page_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = p7_.category_id
  LEFT JOIN ro_routes r4_ ON p1_.route_id = r4_.id
WHERE
  p0_.uuid = ?
  AND p5_.stage = ?
  AND p5_.version = ?
  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, r4_.webspace AS webspace_44, r4_.locale AS locale_45, r4_.slug AS slug_46, r4_.resource_key AS resource_key_47, r4_.resource_id AS resource_id_48, r4_.id AS id_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, r4_.parent_id AS parent_id_63 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p5_ ON (p5_.pageUuid = p0_.uuid) LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid LEFT JOIN pa_page_dimension_content_excerpt_tags p6_ ON p1_.id = p6_.page_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = p6_.tag_id LEFT JOIN pa_page_dimension_content_excerpt_categories p7_ ON p1_.id = p7_.page_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = p7_.category_id LEFT JOIN ro_routes r4_ ON p1_.route_id = r4_.id WHERE p0_.uuid = '019c6568-0950-703e-b6bb-5473325adc6a' AND p5_.stage = 'draft' AND p5_.version = 0 AND (((p1_.locale IS NULL OR p1_.locale IN ('en')) AND (p1_.stage IS NULL OR p1_.stage IN ('draft'))) 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 = 13;

SELECT
  s0_.username AS username_0,
  s0_.password AS password_1,
  s0_.locale AS locale_2,
  s0_.salt AS salt_3,
  s0_.locked AS locked_4,
  s0_.enabled AS enabled_5,
  s0_.lastLogin AS lastLogin_6,
  s0_.confirmationKey AS confirmationKey_7,
  s0_.passwordResetToken AS passwordResetToken_8,
  s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9,
  s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10,
  s0_.privateKey AS privateKey_11,
  s0_.apiKey AS apiKey_12,
  s0_.email AS email_13,
  s0_.id AS id_14,
  s0_.created AS created_15,
  s0_.changed AS changed_16,
  s1_.locale AS locale_17,
  s1_.id AS id_18,
  s2_.name AS name_19,
  s2_.role_key AS role_key_20,
  s2_.securitySystem AS securitySystem_21,
  s2_.anonymous AS anonymous_22,
  s2_.id AS id_23,
  s2_.created AS created_24,
  s2_.changed AS changed_25,
  s3_.context AS context_26,
  s3_.permissions AS permissions_27,
  s3_.id AS id_28,
  s0_.idContacts AS idContacts_29,
  s0_.idUsersCreator AS idUsersCreator_30,
  s0_.idUsersChanger AS idUsersChanger_31,
  s1_.idUsers AS idUsers_32,
  s1_.idRoles AS idRoles_33,
  s2_.idUsersCreator AS idUsersCreator_34,
  s2_.idUsersChanger AS idUsersChanger_35,
  s3_.idRoles AS idRoles_36
FROM
  se_users s0_
  LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers
  LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id
  LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles
WHERE
  s0_.id = ?

SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.permissions AS permissions_27, s3_.id AS id_28, s0_.idContacts AS idContacts_29, s0_.idUsersCreator AS idUsersCreator_30, s0_.idUsersChanger AS idUsersChanger_31, s1_.idUsers AS idUsers_32, s1_.idRoles AS idRoles_33, s2_.idUsersCreator AS idUsersCreator_34, s2_.idUsersChanger AS idUsersChanger_35, s3_.idRoles AS idRoles_36 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.id = 1;

SELECT
  t0.webspaceKey AS webspaceKey_1,
  t0.lft AS lft_2,
  t0.rgt AS rgt_3,
  t0.depth AS depth_4,
  t0.uuid AS uuid_5,
  t0.created AS created_6,
  t0.changed AS changed_7,
  t0.parent_id AS parent_id_8,
  t0.idUsersCreator AS idUsersCreator_9,
  t0.idUsersChanger AS idUsersChanger_10
FROM
  pa_pages t0
WHERE
  t0.uuid = ?

SELECT t0.webspaceKey AS webspaceKey_1, t0.lft AS lft_2, t0.rgt AS rgt_3, t0.depth AS depth_4, t0.uuid AS uuid_5, t0.created AS created_6, t0.changed AS changed_7, t0.parent_id AS parent_id_8, t0.idUsersCreator AS idUsersCreator_9, t0.idUsersChanger AS idUsersChanger_10 FROM pa_pages t0 WHERE t0.uuid = '019c6568-0950-703e-b6bb-5473325adc6a';

SELECT
  s0_.permissions AS permissions_0,
  s0_.entityId AS entityId_1,
  s0_.entityClass AS entityClass_2,
  s0_.entityIdInteger AS entityIdInteger_3,
  s0_.id AS id_4,
  s0_.idRoles AS idRoles_5
FROM
  se_access_controls s0_
  LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id
WHERE
  s0_.entityId = ?
  AND s0_.entityClass = ?
  AND s1_.securitySystem = ?

SELECT s0_.permissions AS permissions_0, s0_.entityId AS entityId_1, s0_.entityClass AS entityClass_2, s0_.entityIdInteger AS entityIdInteger_3, s0_.id AS id_4, s0_.idRoles AS idRoles_5 FROM se_access_controls s0_ LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id WHERE s0_.entityId = '019c6568-0950-703e-b6bb-5473325adc6a' AND s0_.entityClass = 'Sulu\\Page\\Domain\\Model\\Page' AND s1_.securitySystem = 'Sulu';

SELECT
  s0_.permissions AS permissions_0,
  s0_.entityId AS entityId_1,
  s0_.entityClass AS entityClass_2,
  s0_.entityIdInteger AS entityIdInteger_3,
  s0_.id AS id_4,
  s0_.idRoles AS idRoles_5
FROM
  se_access_controls s0_
  LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id
WHERE
  s0_.entityId = ?
  AND s0_.entityClass = ?

SELECT s0_.permissions AS permissions_0, s0_.entityId AS entityId_1, s0_.entityClass AS entityClass_2, s0_.entityIdInteger AS entityIdInteger_3, s0_.id AS id_4, s0_.idRoles AS idRoles_5 FROM se_access_controls s0_ LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id WHERE s0_.entityId = '019c6568-0950-703e-b6bb-5473325adc6a' AND s0_.entityClass = 'Sulu\\Page\\Domain\\Model\\Page';

SELECT
  t0.method AS method_1,
  t0.options AS options_2,
  t0.id AS id_3,
  t0.idUsers AS idUsers_4
FROM
  se_user_two_factors t0
WHERE
  t0.idUsers = ?

SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = 1;