Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.images AS images_1,
  a0_.type AS type_2
FROM
  app_news a0_
  LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id
  LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id
  LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id
  LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id
  LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id
WHERE
  a1_.published = 1
  AND a1_.locale = ?
  AND (
    a0_.type = ?
    OR a0_.type = ?
    OR a0_.type = ?
    OR a0_.type = ?
    OR a0_.type = ?
  )
  AND c4_.id = ?

SELECT a0_.id AS id_0, a0_.images AS images_1, a0_.type AS type_2 FROM app_news a0_ LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id WHERE a1_.published = 1 AND a1_.locale = 'en' AND (a0_.type = 'default' OR a0_.type = 'article' OR a0_.type = 'notice' OR a0_.type = 'announcement' OR a0_.type = 'rating') AND c4_.id = '4';

SELECT
  a0_.id AS id_0,
  a0_.images AS images_1,
  a0_.type AS type_2
FROM
  app_news a0_
  LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id
  LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id
  LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id
  LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id
  LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id
WHERE
  a1_.published = 1
  AND a1_.locale = ?
  AND (
    a0_.type = ?
    OR a0_.type = ?
    OR a0_.type = ?
  )
  AND c4_.id = ?
ORDER BY
  a1_.authored DESC
LIMIT
  9

SELECT a0_.id AS id_0, a0_.images AS images_1, a0_.type AS type_2 FROM app_news a0_ LEFT JOIN app_news_translation a1_ ON a0_.id = a1_.news_id LEFT JOIN app_news_excerpt a2_ ON a0_.id = a2_.news_id LEFT JOIN app_news_excerpt_translation a3_ ON a2_.id = a3_.news_excerpt_id LEFT JOIN app_news_excerpt_categories a5_ ON a3_.id = a5_.excerpt_id LEFT JOIN ca_categories c4_ ON c4_.id = a5_.category_id WHERE a1_.published = 1 AND a1_.locale = 'en' AND (a0_.type = 'default' OR a0_.type = 'notice' OR a0_.type = 'rating') AND c4_.id = '4' ORDER BY a1_.authored DESC LIMIT 9;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.subtitle AS subtitle_4,
  t0.summary AS summary_5,
  t0.text AS text_6,
  t0.footer AS footer_7,
  t0.video_id AS video_id_8,
  t0.published AS published_9,
  t0.published_at AS published_at_10,
  t0.published_state AS published_state_11,
  t0.route_path AS route_path_12,
  t0.link AS link_13,
  t0.show_author AS show_author_14,
  t0.show_date AS show_date_15,
  t0.created AS created_16,
  t0.changed AS changed_17,
  t0.authored AS authored_18,
  t0.news_id AS news_id_19,
  t0.pdf_id AS pdf_id_20,
  t0.image_id AS image_id_21,
  t0.idUsersCreator AS idUsersCreator_22,
  t0.idUsersChanger AS idUsersChanger_23,
  t0.author_contact_id AS author_contact_id_24
FROM
  app_news_translation t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.subtitle AS subtitle_4, t0.summary AS summary_5, t0.text AS text_6, t0.footer AS footer_7, t0.video_id AS video_id_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.published_state AS published_state_11, t0.route_path AS route_path_12, t0.link AS link_13, t0.show_author AS show_author_14, t0.show_date AS show_date_15, t0.created AS created_16, t0.changed AS changed_17, t0.authored AS authored_18, t0.news_id AS news_id_19, t0.pdf_id AS pdf_id_20, t0.image_id AS image_id_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23, t0.author_contact_id AS author_contact_id_24 FROM app_news_translation t0 WHERE t0.news_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_.module AS module_27,
  s3_.permissions AS permissions_28,
  s3_.id AS id_29,
  s0_.idContacts AS idContacts_30,
  s0_.idUsersCreator AS idUsersCreator_31,
  s0_.idUsersChanger AS idUsersChanger_32,
  s1_.idUsers AS idUsers_33,
  s1_.idRoles AS idRoles_34,
  s2_.idSecurityTypes AS idSecurityTypes_35,
  s2_.idUsersCreator AS idUsersCreator_36,
  s2_.idUsersChanger AS idUsersChanger_37,
  s3_.idRoles AS idRoles_38
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_.email = ?
  OR s0_.username = ?
ORDER BY
  s1_.id ASC,
  s3_.id ASC

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_.module AS module_27, s3_.permissions AS permissions_28, s3_.id AS id_29, s0_.idContacts AS idContacts_30, s0_.idUsersCreator AS idUsersCreator_31, s0_.idUsersChanger AS idUsersChanger_32, s1_.idUsers AS idUsers_33, s1_.idRoles AS idRoles_34, s2_.idSecurityTypes AS idSecurityTypes_35, s2_.idUsersCreator AS idUsersCreator_36, s2_.idUsersChanger AS idUsersChanger_37, s3_.idRoles AS idRoles_38 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_.email = 'umk_login_api' OR s0_.username = 'umk_login_api' ORDER BY s1_.id ASC, s3_.id ASC;

SELECT
  t0.name AS name_1,
  t0.version AS version_2,
  t0.subVersion AS subVersion_3,
  t0.size AS size_4,
  t0.downloadCounter AS downloadCounter_5,
  t0.storageOptions AS storageOptions_6,
  t0.mimeType AS mimeType_7,
  t0.properties AS properties_8,
  t0.focusPointX AS focusPointX_9,
  t0.focusPointY AS focusPointY_10,
  t0.id AS id_11,
  t0.created AS created_12,
  t0.changed AS changed_13,
  t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14,
  t0.idFiles AS idFiles_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  me_file_versions t0
WHERE
  t0.idFiles = ?

SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 80;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.changed AS changed_3,
  t0.idMediaTypes AS idMediaTypes_4,
  t0.idPreviewImage AS idPreviewImage_5,
  t0.idCollections AS idCollections_6,
  t0.idUsersCreator AS idUsersCreator_7,
  t0.idUsersChanger AS idUsersChanger_8
FROM
  me_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 80;

SELECT
  t0.version AS version_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idMedia AS idMedia_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  me_files t0
WHERE
  t0.idMedia = ?

SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 80;

SELECT
  t0.id AS id_1,
  t0.hide_in_sitemap AS hide_in_sitemap_2,
  t0.no_follow AS no_follow_3,
  t0.no_index AS no_index_4,
  t0.news_id AS news_id_5
FROM
  app_news_seo t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.hide_in_sitemap AS hide_in_sitemap_2, t0.no_follow AS no_follow_3, t0.no_index AS no_index_4, t0.news_id AS news_id_5 FROM app_news_seo t0 WHERE t0.news_id = 6;

SELECT
  t0.id AS id_1,
  t0.news_id AS news_id_2
FROM
  app_news_excerpt t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.news_id AS news_id_2 FROM app_news_excerpt t0 WHERE t0.news_id = 6;

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;