Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.public AS public_2,
  c0_.draft AS draft_3,
  c0_.slug AS slug_4,
  c0_.type AS type_5,
  c0_.data AS data_6,
  c0_.published_at AS published_at_7,
  c0_.unpublished_at AS unpublished_at_8,
  c0_.position AS position_9,
  c0_.view_count AS view_count_10,
  c0_.deleted_at AS deleted_at_11,
  c0_.created_at AS created_at_12,
  c0_.updated_at AS updated_at_13,
  c1_.id AS id_14,
  c1_.name AS name_15,
  c1_.name_prefix AS name_prefix_16,
  c1_.slug AS slug_17,
  c1_.public AS public_18,
  c1_.types AS types_19,
  c1_.position AS position_20,
  c1_.access_authenticated AS access_authenticated_21,
  c1_.deleted_at AS deleted_at_22,
  c1_.created_at AS created_at_23,
  c1_.updated_at AS updated_at_24,
  c1_.root AS root_25,
  c1_.lvl AS lvl_26,
  c1_.lft AS lft_27,
  c1_.rgt AS rgt_28,
  b2_.id AS id_29,
  b2_.username AS username_30,
  b2_.email AS email_31,
  b2_.enabled AS enabled_32,
  b2_.full_name AS full_name_33,
  b2_.roles AS roles_34,
  b2_.enable_notification_email AS enable_notification_email_35,
  b2_.online_at AS online_at_36,
  b2_.last_login AS last_login_37,
  b2_.password AS password_38,
  b2_.is_verified AS is_verified_39,
  b2_.created_at AS created_at_40,
  b2_.activity_type AS activity_type_41,
  b2_.facebook_username AS facebook_username_42,
  b2_.premium_date AS premium_date_43,
  b2_.firstname AS firstname_44,
  b2_.name AS name_45,
  b2_.session_id AS session_id_46,
  b2_.logged AS logged_47,
  c0_.user_id AS user_id_48,
  c1_.parent_id AS parent_id_49,
  c1_.image_id AS image_id_50
FROM
  content_element c0_
  LEFT JOIN content_element_category c3_ ON c0_.id = c3_.element_id
  LEFT JOIN content_category c1_ ON c1_.id = c3_.category_id
  LEFT JOIN base_user b2_ ON c0_.user_id = b2_.id
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c1_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.public AS public_2, c0_.draft AS draft_3, c0_.slug AS slug_4, c0_.type AS type_5, c0_.data AS data_6, c0_.published_at AS published_at_7, c0_.unpublished_at AS unpublished_at_8, c0_.position AS position_9, c0_.view_count AS view_count_10, c0_.deleted_at AS deleted_at_11, c0_.created_at AS created_at_12, c0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.name AS name_15, c1_.name_prefix AS name_prefix_16, c1_.slug AS slug_17, c1_.public AS public_18, c1_.types AS types_19, c1_.position AS position_20, c1_.access_authenticated AS access_authenticated_21, c1_.deleted_at AS deleted_at_22, c1_.created_at AS created_at_23, c1_.updated_at AS updated_at_24, c1_.root AS root_25, c1_.lvl AS lvl_26, c1_.lft AS lft_27, c1_.rgt AS rgt_28, b2_.id AS id_29, b2_.username AS username_30, b2_.email AS email_31, b2_.enabled AS enabled_32, b2_.full_name AS full_name_33, b2_.roles AS roles_34, b2_.enable_notification_email AS enable_notification_email_35, b2_.online_at AS online_at_36, b2_.last_login AS last_login_37, b2_.password AS password_38, b2_.is_verified AS is_verified_39, b2_.created_at AS created_at_40, b2_.activity_type AS activity_type_41, b2_.facebook_username AS facebook_username_42, b2_.premium_date AS premium_date_43, b2_.firstname AS firstname_44, b2_.name AS name_45, b2_.session_id AS session_id_46, b2_.logged AS logged_47, c0_.user_id AS user_id_48, c1_.parent_id AS parent_id_49, c1_.image_id AS image_id_50 FROM content_element c0_ LEFT JOIN content_element_category c3_ ON c0_.id = c3_.element_id LEFT JOIN content_category c1_ ON c1_.id = c3_.category_id LEFT JOIN base_user b2_ ON c0_.user_id = b2_.id WHERE (c0_.slug = '2021-06-30-10-24-christophe-andre') AND (c0_.deleted_at IS NULL) ORDER BY c1_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.active AS active_3,
  t0.product_reference AS product_reference_4,
  t0.offered_month_count AS offered_month_count_5,
  t0.user_id AS user_id_6,
  t0.sponsored_user_id AS sponsored_user_id_7
FROM
  sponsor t0
WHERE
  t0.sponsored_user_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.active AS active_3, t0.product_reference AS product_reference_4, t0.offered_month_count AS offered_month_count_5, t0.user_id AS user_id_6, t0.sponsored_user_id AS sponsored_user_id_7 FROM sponsor t0 WHERE t0.sponsored_user_id = 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.ext AS ext_3,
  b0_.download_count AS download_count_4,
  b0_.type AS type_5,
  b0_.path AS path_6,
  b0_.size AS size_7,
  b0_.options AS options_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.folder_id AS folder_id_11,
  b0_.user_id AS user_id_12
FROM
  base_file b0_
WHERE
  b0_.id IN (?)
GROUP BY
  id_0,
  name_1,
  slug_2,
  ext_3,
  download_count_4,
  type_5,
  path_6,
  size_7,
  options_8,
  created_at_9,
  updated_at_10

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.ext AS ext_3, b0_.download_count AS download_count_4, b0_.type AS type_5, b0_.path AS path_6, b0_.size AS size_7, b0_.options AS options_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.folder_id AS folder_id_11, b0_.user_id AS user_id_12 FROM base_file b0_ WHERE b0_.id IN (13) GROUP BY id_0, name_1, slug_2, ext_3, download_count_4, type_5, path_6, size_7, options_8, created_at_9, updated_at_10;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.bundle AS bundle_2,
  c0_.value AS value_3,
  c0_.type AS type_4
FROM
  config c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.bundle AS bundle_2, c0_.value AS value_3, c0_.type AS type_4 FROM config c0_ ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_prefix AS name_prefix_2,
  c0_.access_authenticated AS access_authenticated_3,
  c0_.slug AS slug_4,
  c0_.public AS public_5,
  c0_.description AS description_6,
  c0_.menus AS menus_7,
  c0_.template AS template_8,
  c0_.position AS position_9,
  c0_.nofollow AS nofollow_10,
  c0_.data AS data_11,
  c0_.type AS type_12,
  c0_.content_type AS content_type_13,
  c0_.url AS url_14,
  c0_.arguments AS arguments_15,
  c0_.content_options AS content_options_16,
  c0_.deleted_at AS deleted_at_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.root AS root_20,
  c0_.lvl AS lvl_21,
  c0_.lft AS lft_22,
  c0_.rgt AS rgt_23,
  c1_.id AS id_24,
  c1_.name AS name_25,
  c1_.name_prefix AS name_prefix_26,
  c1_.access_authenticated AS access_authenticated_27,
  c1_.slug AS slug_28,
  c1_.public AS public_29,
  c1_.description AS description_30,
  c1_.menus AS menus_31,
  c1_.template AS template_32,
  c1_.position AS position_33,
  c1_.nofollow AS nofollow_34,
  c1_.data AS data_35,
  c1_.type AS type_36,
  c1_.content_type AS content_type_37,
  c1_.url AS url_38,
  c1_.arguments AS arguments_39,
  c1_.content_options AS content_options_40,
  c1_.deleted_at AS deleted_at_41,
  c1_.created_at AS created_at_42,
  c1_.updated_at AS updated_at_43,
  c1_.root AS root_44,
  c1_.lvl AS lvl_45,
  c1_.lft AS lft_46,
  c1_.rgt AS rgt_47,
  c2_.id AS id_48,
  c2_.name AS name_49,
  c2_.name_prefix AS name_prefix_50,
  c2_.access_authenticated AS access_authenticated_51,
  c2_.slug AS slug_52,
  c2_.public AS public_53,
  c2_.description AS description_54,
  c2_.menus AS menus_55,
  c2_.template AS template_56,
  c2_.position AS position_57,
  c2_.nofollow AS nofollow_58,
  c2_.data AS data_59,
  c2_.type AS type_60,
  c2_.content_type AS content_type_61,
  c2_.url AS url_62,
  c2_.arguments AS arguments_63,
  c2_.content_options AS content_options_64,
  c2_.deleted_at AS deleted_at_65,
  c2_.created_at AS created_at_66,
  c2_.updated_at AS updated_at_67,
  c2_.root AS root_68,
  c2_.lvl AS lvl_69,
  c2_.lft AS lft_70,
  c2_.rgt AS rgt_71,
  c0_.parent_id AS parent_id_72,
  c0_.user_id AS user_id_73,
  c1_.parent_id AS parent_id_74,
  c1_.user_id AS user_id_75,
  c2_.parent_id AS parent_id_76,
  c2_.user_id AS user_id_77
FROM
  content_page c0_
  LEFT JOIN content_page c1_ ON c0_.id = c1_.parent_id
  LEFT JOIN content_page c2_ ON c1_.id = c2_.parent_id
WHERE
  c0_.public = ?
  AND c0_.menus LIKE ?
  AND c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC,
  c1_.lft ASC,
  c2_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_prefix AS name_prefix_2, c0_.access_authenticated AS access_authenticated_3, c0_.slug AS slug_4, c0_.public AS public_5, c0_.description AS description_6, c0_.menus AS menus_7, c0_.template AS template_8, c0_.position AS position_9, c0_.nofollow AS nofollow_10, c0_.data AS data_11, c0_.type AS type_12, c0_.content_type AS content_type_13, c0_.url AS url_14, c0_.arguments AS arguments_15, c0_.content_options AS content_options_16, c0_.deleted_at AS deleted_at_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.root AS root_20, c0_.lvl AS lvl_21, c0_.lft AS lft_22, c0_.rgt AS rgt_23, c1_.id AS id_24, c1_.name AS name_25, c1_.name_prefix AS name_prefix_26, c1_.access_authenticated AS access_authenticated_27, c1_.slug AS slug_28, c1_.public AS public_29, c1_.description AS description_30, c1_.menus AS menus_31, c1_.template AS template_32, c1_.position AS position_33, c1_.nofollow AS nofollow_34, c1_.data AS data_35, c1_.type AS type_36, c1_.content_type AS content_type_37, c1_.url AS url_38, c1_.arguments AS arguments_39, c1_.content_options AS content_options_40, c1_.deleted_at AS deleted_at_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, c1_.root AS root_44, c1_.lvl AS lvl_45, c1_.lft AS lft_46, c1_.rgt AS rgt_47, c2_.id AS id_48, c2_.name AS name_49, c2_.name_prefix AS name_prefix_50, c2_.access_authenticated AS access_authenticated_51, c2_.slug AS slug_52, c2_.public AS public_53, c2_.description AS description_54, c2_.menus AS menus_55, c2_.template AS template_56, c2_.position AS position_57, c2_.nofollow AS nofollow_58, c2_.data AS data_59, c2_.type AS type_60, c2_.content_type AS content_type_61, c2_.url AS url_62, c2_.arguments AS arguments_63, c2_.content_options AS content_options_64, c2_.deleted_at AS deleted_at_65, c2_.created_at AS created_at_66, c2_.updated_at AS updated_at_67, c2_.root AS root_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c0_.parent_id AS parent_id_72, c0_.user_id AS user_id_73, c1_.parent_id AS parent_id_74, c1_.user_id AS user_id_75, c2_.parent_id AS parent_id_76, c2_.user_id AS user_id_77 FROM content_page c0_ LEFT JOIN content_page c1_ ON c0_.id = c1_.parent_id LEFT JOIN content_page c2_ ON c1_.id = c2_.parent_id WHERE c0_.public = 1 AND c0_.menus LIKE '%main%' AND c0_.parent_id IS NULL ORDER BY c0_.position ASC, c1_.lft ASC, c2_.lft ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_prefix AS name_prefix_2,
  c0_.access_authenticated AS access_authenticated_3,
  c0_.slug AS slug_4,
  c0_.public AS public_5,
  c0_.description AS description_6,
  c0_.menus AS menus_7,
  c0_.template AS template_8,
  c0_.position AS position_9,
  c0_.nofollow AS nofollow_10,
  c0_.data AS data_11,
  c0_.type AS type_12,
  c0_.content_type AS content_type_13,
  c0_.url AS url_14,
  c0_.arguments AS arguments_15,
  c0_.content_options AS content_options_16,
  c0_.deleted_at AS deleted_at_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.root AS root_20,
  c0_.lvl AS lvl_21,
  c0_.lft AS lft_22,
  c0_.rgt AS rgt_23,
  c1_.id AS id_24,
  c1_.name AS name_25,
  c1_.name_prefix AS name_prefix_26,
  c1_.access_authenticated AS access_authenticated_27,
  c1_.slug AS slug_28,
  c1_.public AS public_29,
  c1_.description AS description_30,
  c1_.menus AS menus_31,
  c1_.template AS template_32,
  c1_.position AS position_33,
  c1_.nofollow AS nofollow_34,
  c1_.data AS data_35,
  c1_.type AS type_36,
  c1_.content_type AS content_type_37,
  c1_.url AS url_38,
  c1_.arguments AS arguments_39,
  c1_.content_options AS content_options_40,
  c1_.deleted_at AS deleted_at_41,
  c1_.created_at AS created_at_42,
  c1_.updated_at AS updated_at_43,
  c1_.root AS root_44,
  c1_.lvl AS lvl_45,
  c1_.lft AS lft_46,
  c1_.rgt AS rgt_47,
  c2_.id AS id_48,
  c2_.name AS name_49,
  c2_.name_prefix AS name_prefix_50,
  c2_.access_authenticated AS access_authenticated_51,
  c2_.slug AS slug_52,
  c2_.public AS public_53,
  c2_.description AS description_54,
  c2_.menus AS menus_55,
  c2_.template AS template_56,
  c2_.position AS position_57,
  c2_.nofollow AS nofollow_58,
  c2_.data AS data_59,
  c2_.type AS type_60,
  c2_.content_type AS content_type_61,
  c2_.url AS url_62,
  c2_.arguments AS arguments_63,
  c2_.content_options AS content_options_64,
  c2_.deleted_at AS deleted_at_65,
  c2_.created_at AS created_at_66,
  c2_.updated_at AS updated_at_67,
  c2_.root AS root_68,
  c2_.lvl AS lvl_69,
  c2_.lft AS lft_70,
  c2_.rgt AS rgt_71,
  c0_.parent_id AS parent_id_72,
  c0_.user_id AS user_id_73,
  c1_.parent_id AS parent_id_74,
  c1_.user_id AS user_id_75,
  c2_.parent_id AS parent_id_76,
  c2_.user_id AS user_id_77
FROM
  content_page c0_
  LEFT JOIN content_page c1_ ON c0_.id = c1_.parent_id
  LEFT JOIN content_page c2_ ON c1_.id = c2_.parent_id
WHERE
  c0_.public = ?
  AND c0_.menus LIKE ?
  AND c0_.parent_id IS NULL
ORDER BY
  c0_.position ASC,
  c1_.lft ASC,
  c2_.lft ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_prefix AS name_prefix_2, c0_.access_authenticated AS access_authenticated_3, c0_.slug AS slug_4, c0_.public AS public_5, c0_.description AS description_6, c0_.menus AS menus_7, c0_.template AS template_8, c0_.position AS position_9, c0_.nofollow AS nofollow_10, c0_.data AS data_11, c0_.type AS type_12, c0_.content_type AS content_type_13, c0_.url AS url_14, c0_.arguments AS arguments_15, c0_.content_options AS content_options_16, c0_.deleted_at AS deleted_at_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.root AS root_20, c0_.lvl AS lvl_21, c0_.lft AS lft_22, c0_.rgt AS rgt_23, c1_.id AS id_24, c1_.name AS name_25, c1_.name_prefix AS name_prefix_26, c1_.access_authenticated AS access_authenticated_27, c1_.slug AS slug_28, c1_.public AS public_29, c1_.description AS description_30, c1_.menus AS menus_31, c1_.template AS template_32, c1_.position AS position_33, c1_.nofollow AS nofollow_34, c1_.data AS data_35, c1_.type AS type_36, c1_.content_type AS content_type_37, c1_.url AS url_38, c1_.arguments AS arguments_39, c1_.content_options AS content_options_40, c1_.deleted_at AS deleted_at_41, c1_.created_at AS created_at_42, c1_.updated_at AS updated_at_43, c1_.root AS root_44, c1_.lvl AS lvl_45, c1_.lft AS lft_46, c1_.rgt AS rgt_47, c2_.id AS id_48, c2_.name AS name_49, c2_.name_prefix AS name_prefix_50, c2_.access_authenticated AS access_authenticated_51, c2_.slug AS slug_52, c2_.public AS public_53, c2_.description AS description_54, c2_.menus AS menus_55, c2_.template AS template_56, c2_.position AS position_57, c2_.nofollow AS nofollow_58, c2_.data AS data_59, c2_.type AS type_60, c2_.content_type AS content_type_61, c2_.url AS url_62, c2_.arguments AS arguments_63, c2_.content_options AS content_options_64, c2_.deleted_at AS deleted_at_65, c2_.created_at AS created_at_66, c2_.updated_at AS updated_at_67, c2_.root AS root_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c0_.parent_id AS parent_id_72, c0_.user_id AS user_id_73, c1_.parent_id AS parent_id_74, c1_.user_id AS user_id_75, c2_.parent_id AS parent_id_76, c2_.user_id AS user_id_77 FROM content_page c0_ LEFT JOIN content_page c1_ ON c0_.id = c1_.parent_id LEFT JOIN content_page c2_ ON c1_.id = c2_.parent_id WHERE c0_.public = 1 AND c0_.menus LIKE '%footer%' AND c0_.parent_id IS NULL ORDER BY c0_.position ASC, c1_.lft ASC, c2_.lft ASC;