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,
  t22.id AS id_23,
  t22.user_id AS user_id_24
FROM
  cms_users t0
  LEFT JOIN tm_users_profiles t22 ON t22.user_id = t0.id
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, t22.id AS id_23, t22.user_id AS user_id_24 FROM cms_users t0 LEFT JOIN tm_users_profiles t22 ON t22.user_id = t0.id WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.hwi_oauth_id AS hwi_oauth_id_2,
  t0.hwi_oauth_type AS hwi_oauth_type_3,
  t0.hwi_oauth_response AS hwi_oauth_response_4,
  t0.client_id AS client_id_5,
  t0.client_secret AS client_secret_6,
  t0.hwi_oauth_access_token AS hwi_oauth_access_token_7,
  t0.token_secret AS token_secret_8,
  t0.user_id AS user_id_9
FROM
  cms_users_hwi_oauth t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.hwi_oauth_id AS hwi_oauth_id_2, t0.hwi_oauth_type AS hwi_oauth_type_3, t0.hwi_oauth_response AS hwi_oauth_response_4, t0.client_id AS client_id_5, t0.client_secret AS client_secret_6, t0.hwi_oauth_access_token AS hwi_oauth_access_token_7, t0.token_secret AS token_secret_8, t0.user_id AS user_id_9 FROM cms_users_hwi_oauth t0 WHERE t0.user_id = 1 ORDER BY t0.id DESC;

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.locale = 'ar')
    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 = '36055' AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

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.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
WHERE
  t0.name = ?
LIMIT
  1

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 WHERE t0.name = 'consultation' LIMIT 1;

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.item_class = ?
  AND t0.item_id = ?
  AND t0.item_handler = ?
LIMIT
  1

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.item_class = 'Rawafed\\ContentManagementBundle\\Entity\\Entry' AND t0.item_id = 36055 AND t0.item_handler = 'rawafed.content.consultations.job_handler' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.image AS image_3,
  a0_.template AS template_4,
  a0_.views_count AS views_count_5,
  a0_.lft AS lft_6,
  a0_.rgt AS rgt_7,
  a0_.level AS level_8,
  a0_.root_id AS root_id_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.deleted_at AS deleted_at_12,
  a0_.locale AS locale_13,
  a0_.allowed_type_id AS allowed_type_id_14,
  a0_.parent_id AS parent_id_15,
  a0_.created_by AS created_by_16,
  a0_.updated_by AS updated_by_17
FROM
  aggregate a0_
WHERE
  (
    a0_.allowed_type_id = ?
    OR a0_.allowed_type_id IS NULL
  )
  AND (a0_.locale = 'ar')
  AND (a0_.deleted_at IS NULL)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.image AS image_3, a0_.template AS template_4, a0_.views_count AS views_count_5, a0_.lft AS lft_6, a0_.rgt AS rgt_7, a0_.level AS level_8, a0_.root_id AS root_id_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, a0_.locale AS locale_13, a0_.allowed_type_id AS allowed_type_id_14, a0_.parent_id AS parent_id_15, a0_.created_by AS created_by_16, a0_.updated_by AS updated_by_17 FROM aggregate a0_ WHERE (a0_.allowed_type_id = 7 OR a0_.allowed_type_id IS NULL) AND (a0_.locale = 'ar') AND (a0_.deleted_at IS NULL) AND (a0_.deleted_at IS NULL) ORDER BY a0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.website AS website_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.fax AS fax_6,
  t0.photo AS photo_7,
  t0.is_enabled AS is_enabled_8,
  t0.is_active AS is_active_9,
  t0.popularity AS popularity_10,
  t0.views_count AS views_count_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.extra_fields AS extra_fields_15,
  t0.country_id AS country_id_16,
  t0.user_id AS user_id_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  author t0
  INNER JOIN entry_author ON t0.id = entry_author.author_id
WHERE
  entry_author.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.title AS title_2, t0.website AS website_3, t0.email AS email_4, t0.phone AS phone_5, t0.fax AS fax_6, t0.photo AS photo_7, t0.is_enabled AS is_enabled_8, t0.is_active AS is_active_9, t0.popularity AS popularity_10, t0.views_count AS views_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.extra_fields AS extra_fields_15, t0.country_id AS country_id_16, t0.user_id AS user_id_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM author t0 INNER JOIN entry_author ON t0.id = entry_author.author_id WHERE entry_author.entry_id = 36055 AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  tag t0
  INNER JOIN entry_tag ON t0.id = entry_tag.tag_id
WHERE
  entry_tag.entry_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM tag t0 INNER JOIN entry_tag ON t0.id = entry_tag.tag_id WHERE entry_tag.entry_id = 36055;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.template AS template_5,
  t0.views_count AS views_count_6,
  t0.lft AS lft_7,
  t0.rgt AS rgt_8,
  t0.level AS level_9,
  t0.root_id AS root_id_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.locale AS locale_14,
  t0.allowed_type_id AS allowed_type_id_15,
  t0.parent_id AS parent_id_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  aggregate t0
  INNER JOIN aggregate_entries ON t0.id = aggregate_entries.aggregate_id
WHERE
  aggregate_entries.entry_id = ?
  AND (
    (t0.locale = 'ar')
    AND (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.template AS template_5, t0.views_count AS views_count_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.level AS level_9, t0.root_id AS root_id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.locale AS locale_14, t0.allowed_type_id AS allowed_type_id_15, t0.parent_id AS parent_id_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM aggregate t0 INNER JOIN aggregate_entries ON t0.id = aggregate_entries.aggregate_id WHERE aggregate_entries.entry_id = 36055 AND ((t0.locale = 'ar') AND (t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.lft AS lft_2,
  t0.rgt AS rgt_3,
  t0.level AS level_4,
  t0.root_id AS root_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.parent_id AS parent_id_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  category t0
  INNER JOIN entry_category ON t0.id = entry_category.category_id
WHERE
  entry_category.entry_id = ?
  AND (
    (t0.deleted_at IS NULL)
    AND (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.rgt AS rgt_3, t0.level AS level_4, t0.root_id AS root_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.parent_id AS parent_id_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM category t0 INNER JOIN entry_category ON t0.id = entry_category.category_id WHERE entry_category.entry_id = 36055 AND ((t0.deleted_at IS NULL) AND (t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.entry_id AS entry_id_4
FROM
  entry_property t0
WHERE
  t0.entry_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.entry_id AS entry_id_4 FROM entry_property t0 WHERE t0.entry_id = 36055;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.path AS path_3,
  t0.size_kb AS size_kb_4,
  t0.properties AS properties_5,
  t0.view_order AS view_order_6,
  t0.is_published AS is_published_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.entry_id AS entry_id_10,
  t0.type_id AS type_id_11,
  t12.id AS id_13,
  t12.classification AS classification_14,
  t12.extension AS extension_15,
  t12.mime_type AS mime_type_16,
  t12.embeddable AS embeddable_17,
  t12.priority AS priority_18,
  t12.viewer_width AS viewer_width_19,
  t12.viewer_height AS viewer_height_20
FROM
  entry_resource t0
  INNER JOIN resource_type t12 ON t0.type_id = t12.id
WHERE
  t0.entry_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.path AS path_3, t0.size_kb AS size_kb_4, t0.properties AS properties_5, t0.view_order AS view_order_6, t0.is_published AS is_published_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.entry_id AS entry_id_10, t0.type_id AS type_id_11, t12.id AS id_13, t12.classification AS classification_14, t12.extension AS extension_15, t12.mime_type AS mime_type_16, t12.embeddable AS embeddable_17, t12.priority AS priority_18, t12.viewer_width AS viewer_width_19, t12.viewer_height AS viewer_height_20 FROM entry_resource t0 INNER JOIN resource_type t12 ON t0.type_id = t12.id WHERE t0.entry_id = 36055;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.website AS website_2,
  a0_.email AS email_3,
  a0_.phone AS phone_4,
  a0_.fax AS fax_5,
  a0_.photo AS photo_6,
  a0_.is_enabled AS is_enabled_7,
  a0_.is_active AS is_active_8,
  a0_.popularity AS popularity_9,
  a0_.views_count AS views_count_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.deleted_at AS deleted_at_13,
  a0_.extra_fields AS extra_fields_14,
  a1_.name AS name_15,
  a1_.brief_biography AS brief_biography_16,
  a1_.full_biography AS full_biography_17,
  a1_.deleted_at AS deleted_at_18,
  a1_.locale AS locale_19,
  a0_.country_id AS country_id_20,
  a0_.user_id AS user_id_21,
  a0_.created_by AS created_by_22,
  a0_.updated_by AS updated_by_23,
  a1_.id AS id_24
FROM
  author a0_
  INNER JOIN author_translation a1_ ON a0_.id = a1_.id
  AND (a1_.locale = 'ar')
  AND (a1_.deleted_at IS NULL)
  AND (a1_.deleted_at IS NULL)
WHERE
  (a0_.deleted_at IS NULL)
  AND (a0_.deleted_at IS NULL)
GROUP BY
  a0_.id
ORDER BY
  a1_.name ASC