Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.lvl AS lvl_1,
  c0_.lft AS lft_2,
  c0_.rgt AS rgt_3,
  c0_.root AS root_4,
  c0_.name AS name_5,
  c0_.role AS role_6,
  c0_.parent_id AS parent_id_7
FROM
  cms_roles c0_
ORDER BY
  c0_.root ASC,
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.lvl AS lvl_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.root AS root_4, c0_.name AS name_5, c0_.role AS role_6, c0_.parent_id AS parent_id_7 FROM cms_roles c0_ ORDER BY c0_.root ASC, c0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.package AS package_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.display_name AS display_name_5,
  t0.list_name AS list_name_6,
  t0.is_internal AS is_internal_7,
  t0.is_categorizable AS is_categorizable_8,
  t0.is_fileable AS is_fileable_9,
  t0.is_printable AS is_printable_10,
  t0.is_embeddable AS is_embeddable_11,
  t0.is_searchable AS is_searchable_12,
  t0.is_queryable AS is_queryable_13,
  t0.accepts_comments AS accepts_comments_14,
  t0.has_authors AS has_authors_15,
  t0.has_attachments AS has_attachments_16,
  t0.has_source AS has_source_17,
  t0.has_tags AS has_tags_18,
  t0.has_summary AS has_summary_19,
  t0.has_aggregates AS has_aggregates_20
FROM
  content_type t0

SELECT t0.id AS id_1, t0.package AS package_2, t0.name AS name_3, t0.description AS description_4, t0.display_name AS display_name_5, t0.list_name AS list_name_6, t0.is_internal AS is_internal_7, t0.is_categorizable AS is_categorizable_8, t0.is_fileable AS is_fileable_9, t0.is_printable AS is_printable_10, t0.is_embeddable AS is_embeddable_11, t0.is_searchable AS is_searchable_12, t0.is_queryable AS is_queryable_13, t0.accepts_comments AS accepts_comments_14, t0.has_authors AS has_authors_15, t0.has_attachments AS has_attachments_16, t0.has_source AS has_source_17, t0.has_tags AS has_tags_18, t0.has_summary AS has_summary_19, t0.has_aggregates AS has_aggregates_20 FROM content_type t0;

SELECT
  r0_.name AS name_0,
  r0_.value AS value_1
FROM
  runtime_parameter r0_

SELECT r0_.name AS name_0, r0_.value AS value_1 FROM runtime_parameter r0_;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.real_name AS real_name_13,
  t0.updated_at AS updated_at_14,
  t0.created_at AS created_at_15,
  t0.image_name AS image_name_16,
  t0.reporting_reference_id AS reporting_reference_id_17,
  t0.reporting_banned AS reporting_banned_18,
  t0.reporting_immuned AS reporting_immuned_19,
  t0.is_system AS is_system_20,
  t0.public_id AS public_id_21
FROM
  cms_users t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.real_name AS real_name_13, t0.updated_at AS updated_at_14, t0.created_at AS created_at_15, t0.image_name AS image_name_16, t0.reporting_reference_id AS reporting_reference_id_17, t0.reporting_banned AS reporting_banned_18, t0.reporting_immuned AS reporting_immuned_19, t0.is_system AS is_system_20, t0.public_id AS public_id_21 FROM cms_users t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  j0_.id AS id_0,
  j0_.title AS title_1,
  j0_.description AS description_2,
  j0_.created_at AS created_at_3,
  j0_.updated_at AS updated_at_4,
  j1_.id AS id_5,
  j1_.status AS status_6,
  j1_.done_at AS done_at_7,
  j1_.comment AS comment_8,
  c2_.username AS username_9,
  c2_.username_canonical AS username_canonical_10,
  c2_.email AS email_11,
  c2_.email_canonical AS email_canonical_12,
  c2_.enabled AS enabled_13,
  c2_.salt AS salt_14,
  c2_.password AS password_15,
  c2_.last_login AS last_login_16,
  c2_.confirmation_token AS confirmation_token_17,
  c2_.password_requested_at AS password_requested_at_18,
  c2_.roles AS roles_19,
  c2_.id AS id_20,
  c2_.real_name AS real_name_21,
  c2_.updated_at AS updated_at_22,
  c2_.created_at AS created_at_23,
  c2_.image_name AS image_name_24,
  c2_.reporting_reference_id AS reporting_reference_id_25,
  c2_.reporting_banned AS reporting_banned_26,
  c2_.reporting_immuned AS reporting_immuned_27,
  c2_.is_system AS is_system_28,
  c2_.public_id AS public_id_29,
  c3_.username AS username_30,
  c3_.username_canonical AS username_canonical_31,
  c3_.email AS email_32,
  c3_.email_canonical AS email_canonical_33,
  c3_.enabled AS enabled_34,
  c3_.salt AS salt_35,
  c3_.password AS password_36,
  c3_.last_login AS last_login_37,
  c3_.confirmation_token AS confirmation_token_38,
  c3_.password_requested_at AS password_requested_at_39,
  c3_.roles AS roles_40,
  c3_.id AS id_41,
  c3_.real_name AS real_name_42,
  c3_.updated_at AS updated_at_43,
  c3_.created_at AS created_at_44,
  c3_.image_name AS image_name_45,
  c3_.reporting_reference_id AS reporting_reference_id_46,
  c3_.reporting_banned AS reporting_banned_47,
  c3_.reporting_immuned AS reporting_immuned_48,
  c3_.is_system AS is_system_49,
  c3_.public_id AS public_id_50,
  j0_.group_id AS group_id_51,
  j0_.item_id AS item_id_52,
  j1_.job_id AS job_id_53,
  j1_.done_by_id AS done_by_id_54
FROM
  job j0_
  INNER JOIN job_status j1_ ON j0_.id = j1_.job_id
  AND (
    j1_.id IN (
      SELECT
        MAX(j4_.id) AS sclr_55
      FROM
        job_status j4_
      GROUP BY
        j4_.job_id
    )
  )
  LEFT JOIN job_user j5_ ON j0_.id = j5_.job_id
  LEFT JOIN cms_users c2_ ON c2_.id = j5_.user_id
  LEFT JOIN cms_groups c6_ ON j0_.group_id = c6_.id
  LEFT JOIN cms_users c3_ ON j1_.done_by_id = c3_.id
  LEFT JOIN cms_users_groups c8_ ON c6_.id = c8_.group_id
  LEFT JOIN cms_users c7_ ON c7_.id = c8_.user_id
WHERE
  (
    (
      j1_.status IN (?, ?, ?)
      AND j1_.done_by_id = ?
    )
    OR (
      j1_.status IN (?, ?)
      AND (
        c2_.id = ?
        OR c7_.id = ?
      )
    )
  )
  AND j0_.id = ?
ORDER BY
  j0_.created_at DESC,
  j1_.done_at ASC

SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.description AS description_2, j0_.created_at AS created_at_3, j0_.updated_at AS updated_at_4, j1_.id AS id_5, j1_.status AS status_6, j1_.done_at AS done_at_7, j1_.comment AS comment_8, c2_.username AS username_9, c2_.username_canonical AS username_canonical_10, c2_.email AS email_11, c2_.email_canonical AS email_canonical_12, c2_.enabled AS enabled_13, c2_.salt AS salt_14, c2_.password AS password_15, c2_.last_login AS last_login_16, c2_.confirmation_token AS confirmation_token_17, c2_.password_requested_at AS password_requested_at_18, c2_.roles AS roles_19, c2_.id AS id_20, c2_.real_name AS real_name_21, c2_.updated_at AS updated_at_22, c2_.created_at AS created_at_23, c2_.image_name AS image_name_24, c2_.reporting_reference_id AS reporting_reference_id_25, c2_.reporting_banned AS reporting_banned_26, c2_.reporting_immuned AS reporting_immuned_27, c2_.is_system AS is_system_28, c2_.public_id AS public_id_29, c3_.username AS username_30, c3_.username_canonical AS username_canonical_31, c3_.email AS email_32, c3_.email_canonical AS email_canonical_33, c3_.enabled AS enabled_34, c3_.salt AS salt_35, c3_.password AS password_36, c3_.last_login AS last_login_37, c3_.confirmation_token AS confirmation_token_38, c3_.password_requested_at AS password_requested_at_39, c3_.roles AS roles_40, c3_.id AS id_41, c3_.real_name AS real_name_42, c3_.updated_at AS updated_at_43, c3_.created_at AS created_at_44, c3_.image_name AS image_name_45, c3_.reporting_reference_id AS reporting_reference_id_46, c3_.reporting_banned AS reporting_banned_47, c3_.reporting_immuned AS reporting_immuned_48, c3_.is_system AS is_system_49, c3_.public_id AS public_id_50, j0_.group_id AS group_id_51, j0_.item_id AS item_id_52, j1_.job_id AS job_id_53, j1_.done_by_id AS done_by_id_54 FROM job j0_ INNER JOIN job_status j1_ ON j0_.id = j1_.job_id AND (j1_.id IN (SELECT MAX(j4_.id) AS sclr_55 FROM job_status j4_ GROUP BY j4_.job_id)) LEFT JOIN job_user j5_ ON j0_.id = j5_.job_id LEFT JOIN cms_users c2_ ON c2_.id = j5_.user_id LEFT JOIN cms_groups c6_ ON j0_.group_id = c6_.id LEFT JOIN cms_users c3_ ON j1_.done_by_id = c3_.id LEFT JOIN cms_users_groups c8_ ON c6_.id = c8_.group_id LEFT JOIN cms_users c7_ ON c7_.id = c8_.user_id WHERE ((j1_.status IN ('hold', 'in_progress', '') AND j1_.done_by_id = 1) OR (j1_.status IN ('new', 'release') AND (c2_.id = 1 OR c7_.id = 1))) AND j0_.id = '15' ORDER BY j0_.created_at DESC, j1_.done_at ASC;

SELECT
  t0.id AS id_1,
  t0.item_id AS item_id_2,
  t0.item_class AS item_class_3,
  t0.item_handler AS item_handler_4
FROM
  job_item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.item_id AS item_id_2, t0.item_class AS item_class_3, t0.item_handler AS item_handler_4 FROM job_item t0 WHERE t0.id = 15;

SELECT
  t0.id AS id_1,
  t0.local_id AS local_id_2,
  t0.title AS title_3,
  t0.summary AS summary_4,
  t0.content AS content_5,
  t0.is_comments_enabled AS is_comments_enabled_6,
  t0.is_exclusive AS is_exclusive_7,
  t0.show_in_homepage AS show_in_homepage_8,
  t0.is_draft AS is_draft_9,
  t0.is_published AS is_published_10,
  t0.published_at AS published_at_11,
  t0.views_count AS views_count_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.shares AS shares_15,
  t0.popularity AS popularity_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.deleted_at AS deleted_at_19,
  t0.view_order AS view_order_20,
  t0.reporting_reference_id AS reporting_reference_id_21,
  t0.is_banned AS is_banned_22,
  t0.is_immune AS is_immune_23,
  t0.locale AS locale_24,
  t0.type_id AS type_id_25,
  t0.source_id AS source_id_26,
  t0.collection_id AS collection_id_27,
  t0.comments_thread_id AS comments_thread_id_28,
  t0.created_by AS created_by_29,
  t0.updated_by AS updated_by_30
FROM
  entry t0
WHERE
  t0.id = ?
  AND (
    (t0.is_draft = 0)
    AND (t0.locale = 'ar')
    AND (
      t0.published_at <= CURRENT_TIMESTAMP
    )
    AND (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.local_id AS local_id_2, t0.title AS title_3, t0.summary AS summary_4, t0.content AS content_5, t0.is_comments_enabled AS is_comments_enabled_6, t0.is_exclusive AS is_exclusive_7, t0.show_in_homepage AS show_in_homepage_8, t0.is_draft AS is_draft_9, t0.is_published AS is_published_10, t0.published_at AS published_at_11, t0.views_count AS views_count_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.shares AS shares_15, t0.popularity AS popularity_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.view_order AS view_order_20, t0.reporting_reference_id AS reporting_reference_id_21, t0.is_banned AS is_banned_22, t0.is_immune AS is_immune_23, t0.locale AS locale_24, t0.type_id AS type_id_25, t0.source_id AS source_id_26, t0.collection_id AS collection_id_27, t0.comments_thread_id AS comments_thread_id_28, t0.created_by AS created_by_29, t0.updated_by AS updated_by_30 FROM entry t0 WHERE t0.id = '36068' AND ((t0.is_draft = 0) AND (t0.locale = 'ar') AND (t0.published_at <= CURRENT_TIMESTAMP) AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));