Symfony Profiler

SELECT
  dc.title,
  route.slug,
  route.webspace,
  dc.templateData,
  dc.seoData,
  dc.excerptData,
  dc.authored
FROM
  pa_pages page
  INNER JOIN pa_page_dimension_contents dc ON dc.pageUuid = page.uuid
  INNER JOIN ro_routes route ON route.id = dc.route_id
WHERE
  dc.locale = ?
  AND dc.stage = 'live'
  AND dc.linkProvider IS NULL
  AND dc.templateKey IN (?)
  AND route.slug IS NOT NULL
  AND NOT (
    route.slug = ?
    AND route.webspace <=> ?
  )
ORDER BY
  CASE WHEN JSON_EXTRACT(
    dc.templateData, '$.displayOrder'
  ) IS NULL THEN
    1
  ELSE
    0
  END,
  CAST(
    JSON_EXTRACT(
      dc.templateData, '$.displayOrder'
    ) AS SIGNED
  ),
  COALESCE(
    (
      SELECT
        CAST(
          JSON_EXTRACT(
            adc.templateData, '$.displayOrder'
          ) AS SIGNED
        )
      FROM
        pa_pages anc
        INNER JOIN pa_page_dimension_contents adc ON adc.pageUuid = anc.uuid
        AND adc.locale = dc.locale
        AND adc.stage = 'live'
      WHERE
        anc.webspaceKey = page.webspaceKey
        AND anc.lft <= page.lft
        AND anc.rgt >= page.rgt
        AND anc.depth = CASE WHEN page.webspaceKey = 'mirabeau' THEN
          1
        ELSE
          0
        END
      LIMIT
        1
    ), 999999
  ),
  page.lft

SELECT dc.title, route.slug, route.webspace, dc.templateData, dc.seoData, dc.excerptData, dc.authored
                FROM pa_pages page
                INNER JOIN pa_page_dimension_contents dc ON dc.pageUuid = page.uuid
                INNER JOIN ro_routes route ON route.id = dc.route_id
                WHERE dc.locale = 'en'
                  AND dc.stage = 'live'
                  AND dc.linkProvider IS NULL
                  AND dc.templateKey IN ('single_news')
                  AND route.slug IS NOT NULL
                  AND NOT (route.slug = '/load-news' AND route.webspace <=> 'mirabeau')
                ORDER BY CASE
                             WHEN JSON_EXTRACT(dc.templateData, '$.displayOrder')
                                  IS NULL THEN 1 ELSE 0
                         END,
                         CAST(JSON_EXTRACT(dc.templateData, '$.displayOrder')
                              AS SIGNED),
                         COALESCE((
    SELECT CAST(JSON_EXTRACT(adc.templateData, '$.displayOrder') AS SIGNED)
    FROM pa_pages anc
    INNER JOIN pa_page_dimension_contents adc
            ON adc.pageUuid = anc.uuid AND adc.locale = dc.locale
           AND adc.stage = 'live'
    WHERE anc.webspaceKey = page.webspaceKey
      AND anc.lft <= page.lft AND anc.rgt >= page.rgt
      AND anc.depth = CASE WHEN page.webspaceKey = 'mirabeau' THEN 1 ELSE 0 END
    LIMIT 1
), 999999),
                         page.lft;

SELECT
  s0_.webspace_key AS webspace_key_0,
  s0_.area_key AS area_key_1,
  s0_.uuid AS uuid_2,
  s0_.idSnippet AS idSnippet_3
FROM
  sn_snippet_area s0_
WHERE
  s0_.webspace_key = ?
  AND s0_.area_key = ?

SELECT s0_.webspace_key AS webspace_key_0, s0_.area_key AS area_key_1, s0_.uuid AS uuid_2, s0_.idSnippet AS idSnippet_3 FROM sn_snippet_area s0_ WHERE s0_.webspace_key = 'mirabeau' AND s0_.area_key = 'editorial';

SELECT
  s0_.uuid AS uuid_0,
  s0_.created AS created_1,
  s0_.changed AS changed_2,
  s1_.title AS title_3,
  s1_.id AS id_4,
  s1_.stage AS stage_5,
  s1_.locale AS locale_6,
  s1_.ghostLocale AS ghostLocale_7,
  s1_.availableLocales AS availableLocales_8,
  s1_.version AS version_9,
  s1_.templateKey AS templateKey_10,
  s1_.templateData AS templateData_11,
  s1_.excerptSegment AS excerptSegment_12,
  s1_.workflowPlace AS workflowPlace_13,
  s1_.workflowPublished AS workflowPublished_14,
  s1_.created AS created_15,
  s1_.changed AS changed_16,
  t2_.name AS name_17,
  t2_.id AS id_18,
  t2_.created AS created_19,
  t2_.changed AS changed_20,
  c3_.category_key AS category_key_21,
  c3_.default_locale AS default_locale_22,
  c3_.lft AS lft_23,
  c3_.rgt AS rgt_24,
  c3_.depth AS depth_25,
  c3_.id AS id_26,
  c3_.created AS created_27,
  c3_.changed AS changed_28,
  c4_.translation AS translation_29,
  c4_.locale AS locale_30,
  c4_.description AS description_31,
  c4_.id AS id_32,
  c4_.created AS created_33,
  c4_.changed AS changed_34,
  s0_.idUsersCreator AS idUsersCreator_35,
  s0_.idUsersChanger AS idUsersChanger_36,
  s1_.snippetUuid AS snippetUuid_37,
  s1_.idUsersCreator AS idUsersCreator_38,
  s1_.idUsersChanger AS idUsersChanger_39,
  t2_.idUsersCreator AS idUsersCreator_40,
  t2_.idUsersChanger AS idUsersChanger_41,
  c3_.idCategoriesParent AS idCategoriesParent_42,
  c3_.idUsersCreator AS idUsersCreator_43,
  c3_.idUsersChanger AS idUsersChanger_44,
  c4_.idCategories AS idCategories_45,
  c4_.idUsersCreator AS idUsersCreator_46,
  c4_.idUsersChanger AS idUsersChanger_47
FROM
  sn_snippets s0_
  LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid)
  LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid
  LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id
  LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id
  LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id
  LEFT JOIN ca_categories c3_ ON c3_.id = s7_.category_id
  LEFT JOIN ca_category_translations c4_ ON c3_.id = c4_.idCategories
  AND (
    c4_.locale = c3_.default_locale
    OR c4_.locale IN (?)
  )
WHERE
  s0_.uuid = ?
  AND s5_.locale = ?
  AND s5_.stage = ?
  AND s5_.version = ?
  AND (
    (
      (
        s1_.locale IS NULL
        OR s1_.locale IN (?)
      )
      AND (
        s1_.stage IS NULL
        OR s1_.stage IN (?)
      )
    )
    AND (
      s1_.version IS NULL
      OR s1_.version IN (?)
    )
  )

SELECT s0_.uuid AS uuid_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.title AS title_3, s1_.id AS id_4, s1_.stage AS stage_5, s1_.locale AS locale_6, s1_.ghostLocale AS ghostLocale_7, s1_.availableLocales AS availableLocales_8, s1_.version AS version_9, s1_.templateKey AS templateKey_10, s1_.templateData AS templateData_11, s1_.excerptSegment AS excerptSegment_12, s1_.workflowPlace AS workflowPlace_13, s1_.workflowPublished AS workflowPublished_14, s1_.created AS created_15, s1_.changed AS changed_16, t2_.name AS name_17, t2_.id AS id_18, t2_.created AS created_19, t2_.changed AS changed_20, c3_.category_key AS category_key_21, c3_.default_locale AS default_locale_22, c3_.lft AS lft_23, c3_.rgt AS rgt_24, c3_.depth AS depth_25, c3_.id AS id_26, c3_.created AS created_27, c3_.changed AS changed_28, c4_.translation AS translation_29, c4_.locale AS locale_30, c4_.description AS description_31, c4_.id AS id_32, c4_.created AS created_33, c4_.changed AS changed_34, s0_.idUsersCreator AS idUsersCreator_35, s0_.idUsersChanger AS idUsersChanger_36, s1_.snippetUuid AS snippetUuid_37, s1_.idUsersCreator AS idUsersCreator_38, s1_.idUsersChanger AS idUsersChanger_39, t2_.idUsersCreator AS idUsersCreator_40, t2_.idUsersChanger AS idUsersChanger_41, c3_.idCategoriesParent AS idCategoriesParent_42, c3_.idUsersCreator AS idUsersCreator_43, c3_.idUsersChanger AS idUsersChanger_44, c4_.idCategories AS idCategories_45, c4_.idUsersCreator AS idUsersCreator_46, c4_.idUsersChanger AS idUsersChanger_47 FROM sn_snippets s0_ LEFT JOIN sn_snippet_dimension_contents s5_ ON (s5_.snippetUuid = s0_.uuid) LEFT JOIN sn_snippet_dimension_contents s1_ ON s0_.uuid = s1_.snippetUuid LEFT JOIN sn_snippet_dimension_content_excerpt_tags s6_ ON s1_.id = s6_.snippet_dimension_content_id LEFT JOIN ta_tags t2_ ON t2_.id = s6_.tag_id LEFT JOIN sn_snippet_dimension_content_excerpt_categories s7_ ON s1_.id = s7_.snippet_dimension_content_id LEFT JOIN ca_categories c3_ ON c3_.id = s7_.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 s0_.uuid = '01a0865a-4bcb-74ed-9731-4bf7acfa25f7' AND s5_.locale = 'en' AND s5_.stage = 'live' AND s5_.version = 0 AND (((s1_.locale IS NULL OR s1_.locale IN ('en')) AND (s1_.stage IS NULL OR s1_.stage IN ('live'))) AND (s1_.version IS NULL OR s1_.version IN (0)));

SELECT
  m0_.id AS id_0,
  m1_.version AS version_1,
  m1_.name AS name_2,
  m2_.title AS title_3,
  m3_.title AS title_4
FROM
  me_media m0_
  LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia
  LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles
  AND (m1_.version = m4_.version)
  LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id
  LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions
  AND (m2_.locale = ?)
WHERE
  m0_.id IN (?)

SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = 'en') WHERE m0_.id IN ('715');

SELECT
  p0_.uuid AS uuid_0,
  p1_.title AS title_1,
  r2_.slug AS slug_2,
  p0_.webspaceKey AS webspaceKey_3,
  p1_.linkProvider AS linkProvider_4,
  p1_.linkData AS linkData_5
FROM
  pa_page_dimension_contents p1_
  INNER JOIN pa_pages p0_ ON p1_.pageUuid = p0_.uuid
  LEFT JOIN ro_routes r2_ ON p1_.route_id = r2_.id
WHERE
  p0_.uuid IN (?)
  AND p1_.locale = ?
  AND p1_.stage = ?
  AND p1_.version = ?

SELECT p0_.uuid AS uuid_0, p1_.title AS title_1, r2_.slug AS slug_2, p0_.webspaceKey AS webspaceKey_3, p1_.linkProvider AS linkProvider_4, p1_.linkData AS linkData_5 FROM pa_page_dimension_contents p1_ INNER JOIN pa_pages p0_ ON p1_.pageUuid = p0_.uuid LEFT JOIN ro_routes r2_ ON p1_.route_id = r2_.id WHERE p0_.uuid IN ('01a08614-9898-7b90-8aff-6f7e8794c2ef') AND p1_.locale = 'en' AND p1_.stage = 'live' AND p1_.version = 0;

SELECT
  m0_.type AS type_0,
  m0_.id AS id_1,
  m0_.created AS created_2,
  m0_.changed AS changed_3,
  m1_.style AS style_4,
  m1_.lft AS lft_5,
  m1_.rgt AS rgt_6,
  m1_.depth AS depth_7,
  m1_.collection_key AS collection_key_8,
  m1_.id AS id_9,
  m1_.created AS created_10,
  m1_.changed AS changed_11,
  m2_.version AS version_12,
  m2_.id AS id_13,
  m2_.created AS created_14,
  m2_.changed AS changed_15,
  m3_.name AS name_16,
  m3_.version AS version_17,
  m3_.subVersion AS subVersion_18,
  m3_.size AS size_19,
  m3_.downloadCounter AS downloadCounter_20,
  m3_.storageOptions AS storageOptions_21,
  m3_.mimeType AS mimeType_22,
  m3_.properties AS properties_23,
  m3_.focusPointX AS focusPointX_24,
  m3_.focusPointY AS focusPointY_25,
  m3_.origin AS origin_26,
  m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27,
  m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28,
  m3_.id AS id_29,
  m3_.created AS created_30,
  m3_.changed AS changed_31,
  m4_.crop_x AS crop_x_32,
  m4_.crop_y AS crop_y_33,
  m4_.crop_width AS crop_width_34,
  m4_.crop_height AS crop_height_35,
  m4_.format_key AS format_key_36,
  m5_.title AS title_37,
  m5_.description AS description_38,
  m5_.aiDisclosureText AS aiDisclosureText_39,
  m5_.copyright AS copyright_40,
  m5_.credits AS credits_41,
  m5_.locale AS locale_42,
  m5_.id AS id_43,
  m6_.title AS title_44,
  m6_.description AS description_45,
  m6_.aiDisclosureText AS aiDisclosureText_46,
  m6_.copyright AS copyright_47,
  m6_.credits AS credits_48,
  m6_.locale AS locale_49,
  m6_.id AS id_50,
  s7_.username AS username_51,
  s7_.password AS password_52,
  s7_.locale AS locale_53,
  s7_.salt AS salt_54,
  s7_.locked AS locked_55,
  s7_.enabled AS enabled_56,
  s7_.lastLogin AS lastLogin_57,
  s7_.confirmationKey AS confirmationKey_58,
  s7_.passwordResetToken AS passwordResetToken_59,
  s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60,
  s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61,
  s7_.privateKey AS privateKey_62,
  s7_.apiKey AS apiKey_63,
  s7_.email AS email_64,
  s7_.id AS id_65,
  s7_.created AS created_66,
  s7_.changed AS changed_67,
  c8_.firstName AS firstName_68,
  c8_.middleName AS middleName_69,
  c8_.lastName AS lastName_70,
  c8_.birthday AS birthday_71,
  c8_.salutation AS salutation_72,
  c8_.formOfAddress AS formOfAddress_73,
  c8_.newsletter AS newsletter_74,
  c8_.gender AS gender_75,
  c8_.note AS note_76,
  c8_.mainEmail AS mainEmail_77,
  c8_.mainPhone AS mainPhone_78,
  c8_.mainFax AS mainFax_79,
  c8_.mainUrl AS mainUrl_80,
  c8_.id AS id_81,
  c8_.created AS created_82,
  c8_.changed AS changed_83,
  s9_.username AS username_84,
  s9_.password AS password_85,
  s9_.locale AS locale_86,
  s9_.salt AS salt_87,
  s9_.locked AS locked_88,
  s9_.enabled AS enabled_89,
  s9_.lastLogin AS lastLogin_90,
  s9_.confirmationKey AS confirmationKey_91,
  s9_.passwordResetToken AS passwordResetToken_92,
  s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93,
  s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94,
  s9_.privateKey AS privateKey_95,
  s9_.apiKey AS apiKey_96,
  s9_.email AS email_97,
  s9_.id AS id_98,
  s9_.created AS created_99,
  s9_.changed AS changed_100,
  c10_.firstName AS firstName_101,
  c10_.middleName AS middleName_102,
  c10_.lastName AS lastName_103,
  c10_.birthday AS birthday_104,
  c10_.salutation AS salutation_105,
  c10_.formOfAddress AS formOfAddress_106,
  c10_.newsletter AS newsletter_107,
  c10_.gender AS gender_108,
  c10_.note AS note_109,
  c10_.mainEmail AS mainEmail_110,
  c10_.mainPhone AS mainPhone_111,
  c10_.mainFax AS mainFax_112,
  c10_.mainUrl AS mainUrl_113,
  c10_.id AS id_114,
  c10_.created AS created_115,
  c10_.changed AS changed_116,
  m11_.type AS type_117,
  m11_.id AS id_118,
  m11_.created AS created_119,
  m11_.changed AS changed_120,
  m0_.idPreviewImage AS idPreviewImage_121,
  m0_.idCollections AS idCollections_122,
  m0_.idUsersCreator AS idUsersCreator_123,
  m0_.idUsersChanger AS idUsersChanger_124,
  m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125,
  m1_.idCollectionTypes AS idCollectionTypes_126,
  m1_.idCollectionsParent AS idCollectionsParent_127,
  m1_.idUsersCreator AS idUsersCreator_128,
  m1_.idUsersChanger AS idUsersChanger_129,
  m2_.idMedia AS idMedia_130,
  m2_.idUsersCreator AS idUsersCreator_131,
  m2_.idUsersChanger AS idUsersChanger_132,
  m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133,
  m3_.idFiles AS idFiles_134,
  m3_.idUsersCreator AS idUsersCreator_135,
  m3_.idUsersChanger AS idUsersChanger_136,
  m4_.fileVersion AS fileVersion_137,
  m5_.idFileVersions AS idFileVersions_138,
  m6_.idFileVersions AS idFileVersions_139,
  s7_.idContacts AS idContacts_140,
  s7_.idUsersCreator AS idUsersCreator_141,
  s7_.idUsersChanger AS idUsersChanger_142,
  c8_.idTitles AS idTitles_143,
  c8_.avatar AS avatar_144,
  c8_.idUsersCreator AS idUsersCreator_145,
  c8_.idUsersChanger AS idUsersChanger_146,
  s9_.idContacts AS idContacts_147,
  s9_.idUsersCreator AS idUsersCreator_148,
  s9_.idUsersChanger AS idUsersChanger_149,
  c10_.idTitles AS idTitles_150,
  c10_.avatar AS avatar_151,
  c10_.idUsersCreator AS idUsersCreator_152,
  c10_.idUsersChanger AS idUsersChanger_153,
  m11_.idPreviewImage AS idPreviewImage_154,
  m11_.idCollections AS idCollections_155,
  m11_.idUsersCreator AS idUsersCreator_156,
  m11_.idUsersChanger AS idUsersChanger_157
FROM
  me_media m0_
  LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id
  LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia
  LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles
  LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion
  LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions
  LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id
  LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id
  LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id
  LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id
  LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id
  LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id
WHERE
  m0_.id = ?

SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.origin AS origin_26, m3_.aiDisclosureDisabled AS aiDisclosureDisabled_27, m3_.aiDisclosureIconVariant AS aiDisclosureIconVariant_28, m3_.id AS id_29, m3_.created AS created_30, m3_.changed AS changed_31, m4_.crop_x AS crop_x_32, m4_.crop_y AS crop_y_33, m4_.crop_width AS crop_width_34, m4_.crop_height AS crop_height_35, m4_.format_key AS format_key_36, m5_.title AS title_37, m5_.description AS description_38, m5_.aiDisclosureText AS aiDisclosureText_39, m5_.copyright AS copyright_40, m5_.credits AS credits_41, m5_.locale AS locale_42, m5_.id AS id_43, m6_.title AS title_44, m6_.description AS description_45, m6_.aiDisclosureText AS aiDisclosureText_46, m6_.copyright AS copyright_47, m6_.credits AS credits_48, m6_.locale AS locale_49, m6_.id AS id_50, s7_.username AS username_51, s7_.password AS password_52, s7_.locale AS locale_53, s7_.salt AS salt_54, s7_.locked AS locked_55, s7_.enabled AS enabled_56, s7_.lastLogin AS lastLogin_57, s7_.confirmationKey AS confirmationKey_58, s7_.passwordResetToken AS passwordResetToken_59, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s7_.privateKey AS privateKey_62, s7_.apiKey AS apiKey_63, s7_.email AS email_64, s7_.id AS id_65, s7_.created AS created_66, s7_.changed AS changed_67, c8_.firstName AS firstName_68, c8_.middleName AS middleName_69, c8_.lastName AS lastName_70, c8_.birthday AS birthday_71, c8_.salutation AS salutation_72, c8_.formOfAddress AS formOfAddress_73, c8_.newsletter AS newsletter_74, c8_.gender AS gender_75, c8_.note AS note_76, c8_.mainEmail AS mainEmail_77, c8_.mainPhone AS mainPhone_78, c8_.mainFax AS mainFax_79, c8_.mainUrl AS mainUrl_80, c8_.id AS id_81, c8_.created AS created_82, c8_.changed AS changed_83, s9_.username AS username_84, s9_.password AS password_85, s9_.locale AS locale_86, s9_.salt AS salt_87, s9_.locked AS locked_88, s9_.enabled AS enabled_89, s9_.lastLogin AS lastLogin_90, s9_.confirmationKey AS confirmationKey_91, s9_.passwordResetToken AS passwordResetToken_92, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s9_.privateKey AS privateKey_95, s9_.apiKey AS apiKey_96, s9_.email AS email_97, s9_.id AS id_98, s9_.created AS created_99, s9_.changed AS changed_100, c10_.firstName AS firstName_101, c10_.middleName AS middleName_102, c10_.lastName AS lastName_103, c10_.birthday AS birthday_104, c10_.salutation AS salutation_105, c10_.formOfAddress AS formOfAddress_106, c10_.newsletter AS newsletter_107, c10_.gender AS gender_108, c10_.note AS note_109, c10_.mainEmail AS mainEmail_110, c10_.mainPhone AS mainPhone_111, c10_.mainFax AS mainFax_112, c10_.mainUrl AS mainUrl_113, c10_.id AS id_114, c10_.created AS created_115, c10_.changed AS changed_116, m11_.type AS type_117, m11_.id AS id_118, m11_.created AS created_119, m11_.changed AS changed_120, m0_.idPreviewImage AS idPreviewImage_121, m0_.idCollections AS idCollections_122, m0_.idUsersCreator AS idUsersCreator_123, m0_.idUsersChanger AS idUsersChanger_124, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_125, m1_.idCollectionTypes AS idCollectionTypes_126, m1_.idCollectionsParent AS idCollectionsParent_127, m1_.idUsersCreator AS idUsersCreator_128, m1_.idUsersChanger AS idUsersChanger_129, m2_.idMedia AS idMedia_130, m2_.idUsersCreator AS idUsersCreator_131, m2_.idUsersChanger AS idUsersChanger_132, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_133, m3_.idFiles AS idFiles_134, m3_.idUsersCreator AS idUsersCreator_135, m3_.idUsersChanger AS idUsersChanger_136, m4_.fileVersion AS fileVersion_137, m5_.idFileVersions AS idFileVersions_138, m6_.idFileVersions AS idFileVersions_139, s7_.idContacts AS idContacts_140, s7_.idUsersCreator AS idUsersCreator_141, s7_.idUsersChanger AS idUsersChanger_142, c8_.idTitles AS idTitles_143, c8_.avatar AS avatar_144, c8_.idUsersCreator AS idUsersCreator_145, c8_.idUsersChanger AS idUsersChanger_146, s9_.idContacts AS idContacts_147, s9_.idUsersCreator AS idUsersCreator_148, s9_.idUsersChanger AS idUsersChanger_149, c10_.idTitles AS idTitles_150, c10_.avatar AS avatar_151, c10_.idUsersCreator AS idUsersCreator_152, c10_.idUsersChanger AS idUsersChanger_153, m11_.idPreviewImage AS idPreviewImage_154, m11_.idCollections AS idCollections_155, m11_.idUsersCreator AS idUsersCreator_156, m11_.idUsersChanger AS idUsersChanger_157 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = 530;

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 = 2;