Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.path AS path_3,
  c0_.position AS position_4,
  c0_.date_created AS date_created_5,
  c0_.visibility AS visibility_6,
  c0_.parent_id AS parent_id_7,
  c0_.route_name AS route_name_8,
  c0_.template AS template_9,
  c0_.layout_type AS layout_type_10,
  c0_.controller AS controller_11,
  c0_.content_type AS content_type_12,
  c0_.controller AS controller_13,
  c0_.content_type AS content_type_14,
  c0_.url AS url_15,
  c0_.permanent AS permanent_16,
  c0_.route_type AS route_type_17
FROM
  cms_route c0_
WHERE
  c0_.route_type IN (
    'list', 'post', 'page', 'taxon', 'url'
  )
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.path AS path_3, c0_.position AS position_4, c0_.date_created AS date_created_5, c0_.visibility AS visibility_6, c0_.parent_id AS parent_id_7, c0_.route_name AS route_name_8, c0_.template AS template_9, c0_.layout_type AS layout_type_10, c0_.controller AS controller_11, c0_.content_type AS content_type_12, c0_.controller AS controller_13, c0_.content_type AS content_type_14, c0_.url AS url_15, c0_.permanent AS permanent_16, c0_.route_type AS route_type_17 FROM cms_route c0_ WHERE c0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY c0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.required AS required_5
FROM
  fbeen_settings t0

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0;

SELECT
  c0_.id AS id_0,
  c0_.unique_id AS unique_id_1,
  c0_.title AS title_2,
  c0_.slug AS slug_3,
  c0_.summary AS summary_4,
  c0_.body AS body_5,
  c0_.thumbnail AS thumbnail_6,
  c0_.status AS status_7,
  c0_.is_featured AS is_featured_8,
  c0_.promoted AS promoted_9,
  c0_.publish_on_socialmedia AS publish_on_socialmedia_10,
  c0_.is_published_social_media AS is_published_social_media_11,
  c0_.is_home AS is_home_12,
  c0_.date_created AS date_created_13,
  c0_.date_published AS date_published_14,
  c0_.meta_keywords AS meta_keywords_15,
  c0_.meta_description AS meta_description_16,
  c0_.updated_at AS updated_at_17,
  c0_.position AS position_18,
  c1_.parent_id AS parent_id_19,
  c1_.page_icon AS page_icon_20,
  c2_.id AS id_21,
  c2_.contact_number AS contact_number_22,
  c2_.created_at AS created_at_23,
  c2_.updated_at AS updated_at_24,
  c2_.date_of_birth AS date_of_birth_25,
  c2_.thumbnail AS thumbnail_26,
  c2_.profile_cover_image AS profile_cover_image_27,
  c2_.auth_code AS auth_code_28,
  c2_.is_two_factor_enabled AS is_two_factor_enabled_29,
  c2_.profile_photo AS profile_photo_30,
  c2_.profile_cover_photo AS profile_cover_photo_31,
  c2_.account_status AS account_status_32,
  c2_.account_confirmed_at AS account_confirmed_at_33,
  c2_.bio AS bio_34,
  c2_.address AS address_35,
  c2_.city AS city_36,
  c2_.marital_status AS marital_status_37,
  c2_.country AS country_38,
  c2_.nationality AS nationality_39,
  c2_.status AS status_40,
  c2_.username AS username_41,
  c2_.postal_code AS postal_code_42,
  c2_.is_activated AS is_activated_43,
  c2_.online_status AS online_status_44,
  c2_.phone_numbers AS phone_numbers_45,
  c2_.active_role AS active_role_46,
  c2_.active_layout AS active_layout_47,
  c2_.active_theme AS active_theme_48,
  c2_.email AS email_49,
  c2_.password AS password_50,
  c2_.is_verified AS is_verified_51,
  c2_.is_logged_in AS is_logged_in_52,
  c2_.gender AS gender_53,
  c2_.first_name AS first_name_54,
  c2_.last_name AS last_name_55,
  c2_.other_names AS other_names_56,
  c2_.is_deleted AS is_deleted_57,
  c2_.deleted_at AS deleted_at_58,
  c2_.documents AS documents_59,
  c4_.id AS id_60,
  c4_.title AS title_61,
  c4_.slug AS slug_62,
  c4_.path AS path_63,
  c4_.position AS position_64,
  c4_.date_created AS date_created_65,
  c4_.visibility AS visibility_66,
  c4_.parent_id AS parent_id_67,
  c4_.route_name AS route_name_68,
  c4_.template AS template_69,
  c4_.layout_type AS layout_type_70,
  c0_.content_type AS content_type_71,
  c0_.user_id AS user_id_72,
  c0_.term_id AS term_id_73,
  c1_.route_id AS route_id_74,
  c2_.user_type AS user_type_75,
  c2_.department_id AS department_id_76,
  c2_.created_by_id AS created_by_id_77,
  c2_.updated_by_id AS updated_by_id_78,
  c4_.route_type AS route_type_79
FROM
  cms_page c1_
  INNER JOIN cms_contents c0_ ON c1_.id = c0_.id
  LEFT JOIN core_user c2_ ON c0_.user_id = c2_.id
  LEFT JOIN core_user_admin c3_ ON c2_.id = c3_.id
  LEFT JOIN cms_route c4_ ON c1_.route_id = c4_.id
  AND c4_.route_type IN ('page')
WHERE
  c4_.id = ?
  AND c0_.status = ?

SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.thumbnail AS thumbnail_6, c0_.status AS status_7, c0_.is_featured AS is_featured_8, c0_.promoted AS promoted_9, c0_.publish_on_socialmedia AS publish_on_socialmedia_10, c0_.is_published_social_media AS is_published_social_media_11, c0_.is_home AS is_home_12, c0_.date_created AS date_created_13, c0_.date_published AS date_published_14, c0_.meta_keywords AS meta_keywords_15, c0_.meta_description AS meta_description_16, c0_.updated_at AS updated_at_17, c0_.position AS position_18, c1_.parent_id AS parent_id_19, c1_.page_icon AS page_icon_20, c2_.id AS id_21, c2_.contact_number AS contact_number_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.date_of_birth AS date_of_birth_25, c2_.thumbnail AS thumbnail_26, c2_.profile_cover_image AS profile_cover_image_27, c2_.auth_code AS auth_code_28, c2_.is_two_factor_enabled AS is_two_factor_enabled_29, c2_.profile_photo AS profile_photo_30, c2_.profile_cover_photo AS profile_cover_photo_31, c2_.account_status AS account_status_32, c2_.account_confirmed_at AS account_confirmed_at_33, c2_.bio AS bio_34, c2_.address AS address_35, c2_.city AS city_36, c2_.marital_status AS marital_status_37, c2_.country AS country_38, c2_.nationality AS nationality_39, c2_.status AS status_40, c2_.username AS username_41, c2_.postal_code AS postal_code_42, c2_.is_activated AS is_activated_43, c2_.online_status AS online_status_44, c2_.phone_numbers AS phone_numbers_45, c2_.active_role AS active_role_46, c2_.active_layout AS active_layout_47, c2_.active_theme AS active_theme_48, c2_.email AS email_49, c2_.password AS password_50, c2_.is_verified AS is_verified_51, c2_.is_logged_in AS is_logged_in_52, c2_.gender AS gender_53, c2_.first_name AS first_name_54, c2_.last_name AS last_name_55, c2_.other_names AS other_names_56, c2_.is_deleted AS is_deleted_57, c2_.deleted_at AS deleted_at_58, c2_.documents AS documents_59, c4_.id AS id_60, c4_.title AS title_61, c4_.slug AS slug_62, c4_.path AS path_63, c4_.position AS position_64, c4_.date_created AS date_created_65, c4_.visibility AS visibility_66, c4_.parent_id AS parent_id_67, c4_.route_name AS route_name_68, c4_.template AS template_69, c4_.layout_type AS layout_type_70, c0_.content_type AS content_type_71, c0_.user_id AS user_id_72, c0_.term_id AS term_id_73, c1_.route_id AS route_id_74, c2_.user_type AS user_type_75, c2_.department_id AS department_id_76, c2_.created_by_id AS created_by_id_77, c2_.updated_by_id AS updated_by_id_78, c4_.route_type AS route_type_79 FROM cms_page c1_ INNER JOIN cms_contents c0_ ON c1_.id = c0_.id LEFT JOIN core_user c2_ ON c0_.user_id = c2_.id LEFT JOIN core_user_admin c3_ ON c2_.id = c3_.id LEFT JOIN cms_route c4_ ON c1_.route_id = c4_.id AND c4_.route_type IN ('page') WHERE c4_.id = '2' AND c0_.status = 'published';