Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.subkey AS subkey_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.selected_value AS selected_value_6,
  t0.title AS title_7,
  t0.comment AS comment_8,
  t0.scope AS scope_9,
  t0.subkeytext AS subkeytext_10,
  t0.access_url_changeable AS access_url_changeable_11,
  t0.access_url_locked AS access_url_locked_12,
  t0.access_url AS access_url_13,
  t0.value_template_id AS value_template_id_14
FROM
  settings t0

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13, t0.value_template_id AS value_template_id_14 FROM settings t0;

SELECT
  t0.id AS id_1,
  t0.variable AS variable_2,
  t0.subkey AS subkey_3,
  t0.type AS type_4,
  t0.category AS category_5,
  t0.selected_value AS selected_value_6,
  t0.title AS title_7,
  t0.comment AS comment_8,
  t0.scope AS scope_9,
  t0.subkeytext AS subkeytext_10,
  t0.access_url_changeable AS access_url_changeable_11,
  t0.access_url_locked AS access_url_locked_12,
  t0.access_url AS access_url_13,
  t0.value_template_id AS value_template_id_14
FROM
  settings t0
WHERE
  t0.category = ?

SELECT t0.id AS id_1, t0.variable AS variable_2, t0.subkey AS subkey_3, t0.type AS type_4, t0.category AS category_5, t0.selected_value AS selected_value_6, t0.title AS title_7, t0.comment AS comment_8, t0.scope AS scope_9, t0.subkeytext AS subkeytext_10, t0.access_url_changeable AS access_url_changeable_11, t0.access_url_locked AS access_url_locked_12, t0.access_url AS access_url_13, t0.value_template_id AS value_template_id_14 FROM settings t0 WHERE t0.category = 'tracking';

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  page p0_
  INNER JOIN page_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id
  LEFT JOIN user u3_ ON p0_.creator_id = u3_.id
WHERE
  p0_.id IN (
    SELECT
      p4_.id
    FROM
      page p4_
      INNER JOIN page_category p5_ ON p4_.category_id = p5_.id
    WHERE
      p4_.access_url_id = ?
      AND p4_.enabled = 1
      AND p5_.title NOT IN (
        'block-admin-users', 'block-admin-courses',
        'block-admin-sessions', 'block-admin-gradebook',
        'block-admin-skills', 'block-admin-privacy',
        'block-admin-settings', 'block-admin-platform',
        'block-admin-chamilo'
      )
      AND p5_.title IN (?, ?, ?, ?, ?)
      AND p5_.title LIKE CONCAT('%', ?, '%')
      AND p4_.locale = ?
      AND p4_.enabled = ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ INNER JOIN page_category p1_ ON p0_.category_id = p1_.id LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id LEFT JOIN user u3_ ON p0_.creator_id = u3_.id WHERE p0_.id IN (SELECT p4_.id FROM page p4_ INNER JOIN page_category p5_ ON p4_.category_id = p5_.id WHERE p4_.access_url_id = 1 AND p4_.enabled = 1 AND p5_.title NOT IN ('block-admin-users', 'block-admin-courses', 'block-admin-sessions', 'block-admin-gradebook', 'block-admin-skills', 'block-admin-privacy', 'block-admin-settings', 'block-admin-platform', 'block-admin-chamilo') AND p5_.title IN ('faq', 'demo', 'home', 'public', 'footer_public') AND p5_.title LIKE CONCAT('%', 'footer_private', '%') AND p4_.locale = 'en_US' AND p4_.enabled = 1);

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.content AS content_2,
  p0_.slug AS slug_3,
  p0_.enabled AS enabled_4,
  p0_.position AS position_5,
  p0_.locale AS locale_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p1_.id AS id_9,
  p1_.title AS title_10,
  p1_.type AS type_11,
  p1_.created_at AS created_at_12,
  p1_.updated_at AS updated_at_13,
  a2_.id AS id_14,
  a2_.lft AS lft_15,
  a2_.lvl AS lvl_16,
  a2_.rgt AS rgt_17,
  a2_.url AS url_18,
  a2_.description AS description_19,
  a2_.active AS active_20,
  a2_.created_by AS created_by_21,
  a2_.tms AS tms_22,
  a2_.url_type AS url_type_23,
  a2_.limit_courses AS limit_courses_24,
  a2_.limit_active_courses AS limit_active_courses_25,
  a2_.limit_sessions AS limit_sessions_26,
  a2_.limit_users AS limit_users_27,
  a2_.limit_teachers AS limit_teachers_28,
  a2_.limit_disk_space AS limit_disk_space_29,
  a2_.email AS email_30,
  a2_.is_login_only AS is_login_only_31,
  u3_.id AS id_32,
  u3_.username AS username_33,
  u3_.api_token AS api_token_34,
  u3_.firstname AS firstname_35,
  u3_.lastname AS lastname_36,
  u3_.website AS website_37,
  u3_.biography AS biography_38,
  u3_.locale AS locale_39,
  u3_.password AS password_40,
  u3_.username_canonical AS username_canonical_41,
  u3_.timezone AS timezone_42,
  u3_.email_canonical AS email_canonical_43,
  u3_.email AS email_44,
  u3_.locked AS locked_45,
  u3_.expired AS expired_46,
  u3_.credentials_expired AS credentials_expired_47,
  u3_.credentials_expire_at AS credentials_expire_at_48,
  u3_.date_of_birth AS date_of_birth_49,
  u3_.expires_at AS expires_at_50,
  u3_.phone AS phone_51,
  u3_.address AS address_52,
  u3_.salt AS salt_53,
  u3_.gender AS gender_54,
  u3_.last_login AS last_login_55,
  u3_.confirmation_token AS confirmation_token_56,
  u3_.password_requested_at AS password_requested_at_57,
  u3_.roles AS roles_58,
  u3_.profile_completed AS profile_completed_59,
  u3_.status AS status_60,
  u3_.official_code AS official_code_61,
  u3_.picture_uri AS picture_uri_62,
  u3_.creator_id AS creator_id_63,
  u3_.competences AS competences_64,
  u3_.diplomas AS diplomas_65,
  u3_.openarea AS openarea_66,
  u3_.teach AS teach_67,
  u3_.productions AS productions_68,
  u3_.expiration_date AS expiration_date_69,
  u3_.active AS active_70,
  u3_.openid AS openid_71,
  u3_.theme AS theme_72,
  u3_.hr_dept_id AS hr_dept_id_73,
  u3_.uuid AS uuid_74,
  u3_.mfa_enabled AS mfa_enabled_75,
  u3_.mfa_service AS mfa_service_76,
  u3_.mfa_secret AS mfa_secret_77,
  u3_.mfa_backup_codes AS mfa_backup_codes_78,
  u3_.mfa_last_used AS mfa_last_used_79,
  u3_.password_updated_at AS password_updated_at_80,
  u3_.created_at AS created_at_81,
  u3_.updated_at AS updated_at_82,
  p0_.access_url_id AS access_url_id_83,
  p0_.creator_id AS creator_id_84,
  p0_.category_id AS category_id_85,
  p1_.creator_id AS creator_id_86,
  a2_.resource_node_id AS resource_node_id_87,
  a2_.parent_id AS parent_id_88,
  a2_.tree_root AS tree_root_89,
  u3_.resource_node_id AS resource_node_id_90
FROM
  page p0_
  INNER JOIN page_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id
  LEFT JOIN user u3_ ON p0_.creator_id = u3_.id
WHERE
  p0_.id IN (
    SELECT
      p4_.id
    FROM
      page p4_
      INNER JOIN page_category p5_ ON p4_.category_id = p5_.id
    WHERE
      p4_.access_url_id = ?
      AND p4_.enabled = 1
      AND p5_.title NOT IN (
        'block-admin-users', 'block-admin-courses',
        'block-admin-sessions', 'block-admin-gradebook',
        'block-admin-skills', 'block-admin-privacy',
        'block-admin-settings', 'block-admin-platform',
        'block-admin-chamilo'
      )
      AND p5_.title IN (?, ?, ?, ?, ?)
      AND p5_.title LIKE CONCAT('%', ?, '%')
      AND p4_.locale = ?
      AND p4_.enabled = ?
  )
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.content AS content_2, p0_.slug AS slug_3, p0_.enabled AS enabled_4, p0_.position AS position_5, p0_.locale AS locale_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p1_.id AS id_9, p1_.title AS title_10, p1_.type AS type_11, p1_.created_at AS created_at_12, p1_.updated_at AS updated_at_13, a2_.id AS id_14, a2_.lft AS lft_15, a2_.lvl AS lvl_16, a2_.rgt AS rgt_17, a2_.url AS url_18, a2_.description AS description_19, a2_.active AS active_20, a2_.created_by AS created_by_21, a2_.tms AS tms_22, a2_.url_type AS url_type_23, a2_.limit_courses AS limit_courses_24, a2_.limit_active_courses AS limit_active_courses_25, a2_.limit_sessions AS limit_sessions_26, a2_.limit_users AS limit_users_27, a2_.limit_teachers AS limit_teachers_28, a2_.limit_disk_space AS limit_disk_space_29, a2_.email AS email_30, a2_.is_login_only AS is_login_only_31, u3_.id AS id_32, u3_.username AS username_33, u3_.api_token AS api_token_34, u3_.firstname AS firstname_35, u3_.lastname AS lastname_36, u3_.website AS website_37, u3_.biography AS biography_38, u3_.locale AS locale_39, u3_.password AS password_40, u3_.username_canonical AS username_canonical_41, u3_.timezone AS timezone_42, u3_.email_canonical AS email_canonical_43, u3_.email AS email_44, u3_.locked AS locked_45, u3_.expired AS expired_46, u3_.credentials_expired AS credentials_expired_47, u3_.credentials_expire_at AS credentials_expire_at_48, u3_.date_of_birth AS date_of_birth_49, u3_.expires_at AS expires_at_50, u3_.phone AS phone_51, u3_.address AS address_52, u3_.salt AS salt_53, u3_.gender AS gender_54, u3_.last_login AS last_login_55, u3_.confirmation_token AS confirmation_token_56, u3_.password_requested_at AS password_requested_at_57, u3_.roles AS roles_58, u3_.profile_completed AS profile_completed_59, u3_.status AS status_60, u3_.official_code AS official_code_61, u3_.picture_uri AS picture_uri_62, u3_.creator_id AS creator_id_63, u3_.competences AS competences_64, u3_.diplomas AS diplomas_65, u3_.openarea AS openarea_66, u3_.teach AS teach_67, u3_.productions AS productions_68, u3_.expiration_date AS expiration_date_69, u3_.active AS active_70, u3_.openid AS openid_71, u3_.theme AS theme_72, u3_.hr_dept_id AS hr_dept_id_73, u3_.uuid AS uuid_74, u3_.mfa_enabled AS mfa_enabled_75, u3_.mfa_service AS mfa_service_76, u3_.mfa_secret AS mfa_secret_77, u3_.mfa_backup_codes AS mfa_backup_codes_78, u3_.mfa_last_used AS mfa_last_used_79, u3_.password_updated_at AS password_updated_at_80, u3_.created_at AS created_at_81, u3_.updated_at AS updated_at_82, p0_.access_url_id AS access_url_id_83, p0_.creator_id AS creator_id_84, p0_.category_id AS category_id_85, p1_.creator_id AS creator_id_86, a2_.resource_node_id AS resource_node_id_87, a2_.parent_id AS parent_id_88, a2_.tree_root AS tree_root_89, u3_.resource_node_id AS resource_node_id_90 FROM page p0_ INNER JOIN page_category p1_ ON p0_.category_id = p1_.id LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id LEFT JOIN user u3_ ON p0_.creator_id = u3_.id WHERE p0_.id IN (SELECT p4_.id FROM page p4_ INNER JOIN page_category p5_ ON p4_.category_id = p5_.id WHERE p4_.access_url_id = 1 AND p4_.enabled = 1 AND p5_.title NOT IN ('block-admin-users', 'block-admin-courses', 'block-admin-sessions', 'block-admin-gradebook', 'block-admin-skills', 'block-admin-privacy', 'block-admin-settings', 'block-admin-platform', 'block-admin-chamilo') AND p5_.title IN ('faq', 'demo', 'home', 'public', 'footer_public') AND p5_.title LIKE CONCAT('%', 'footer_private', '%') AND p4_.locale = 'en_US' AND p4_.enabled = 1) ORDER BY p0_.id ASC LIMIT 30;

SELECT
  l0_.id AS id_0,
  l0_.original_name AS original_name_1,
  l0_.english_name AS english_name_2,
  l0_.isocode AS isocode_3,
  l0_.available AS available_4
FROM
  language l0_
WHERE
  l0_.available = 1

SELECT l0_.id AS id_0, l0_.original_name AS original_name_1, l0_.english_name AS english_name_2, l0_.isocode AS isocode_3, l0_.available AS available_4 FROM language l0_ WHERE l0_.available = 1;

SELECT
  t0.id AS id_1,
  t0.lft AS lft_2,
  t0.lvl AS lvl_3,
  t0.rgt AS rgt_4,
  t0.url AS url_5,
  t0.description AS description_6,
  t0.active AS active_7,
  t0.created_by AS created_by_8,
  t0.tms AS tms_9,
  t0.url_type AS url_type_10,
  t0.limit_courses AS limit_courses_11,
  t0.limit_active_courses AS limit_active_courses_12,
  t0.limit_sessions AS limit_sessions_13,
  t0.limit_users AS limit_users_14,
  t0.limit_teachers AS limit_teachers_15,
  t0.limit_disk_space AS limit_disk_space_16,
  t0.email AS email_17,
  t0.is_login_only AS is_login_only_18,
  t0.resource_node_id AS resource_node_id_19,
  t0.parent_id AS parent_id_20,
  t0.tree_root AS tree_root_21
FROM
  access_url t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.url AS url_5, t0.description AS description_6, t0.active AS active_7, t0.created_by AS created_by_8, t0.tms AS tms_9, t0.url_type AS url_type_10, t0.limit_courses AS limit_courses_11, t0.limit_active_courses AS limit_active_courses_12, t0.limit_sessions AS limit_sessions_13, t0.limit_users AS limit_users_14, t0.limit_teachers AS limit_teachers_15, t0.limit_disk_space AS limit_disk_space_16, t0.email AS email_17, t0.is_login_only AS is_login_only_18, t0.resource_node_id AS resource_node_id_19, t0.parent_id AS parent_id_20, t0.tree_root AS tree_root_21 FROM access_url t0 WHERE t0.url = 'https://testing25.beeznest.com/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.lft AS lft_2,
  t0.lvl AS lvl_3,
  t0.rgt AS rgt_4,
  t0.url AS url_5,
  t0.description AS description_6,
  t0.active AS active_7,
  t0.created_by AS created_by_8,
  t0.tms AS tms_9,
  t0.url_type AS url_type_10,
  t0.limit_courses AS limit_courses_11,
  t0.limit_active_courses AS limit_active_courses_12,
  t0.limit_sessions AS limit_sessions_13,
  t0.limit_users AS limit_users_14,
  t0.limit_teachers AS limit_teachers_15,
  t0.limit_disk_space AS limit_disk_space_16,
  t0.email AS email_17,
  t0.is_login_only AS is_login_only_18,
  t0.resource_node_id AS resource_node_id_19,
  t0.parent_id AS parent_id_20,
  t0.tree_root AS tree_root_21
FROM
  access_url t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.url AS url_5, t0.description AS description_6, t0.active AS active_7, t0.created_by AS created_by_8, t0.tms AS tms_9, t0.url_type AS url_type_10, t0.limit_courses AS limit_courses_11, t0.limit_active_courses AS limit_active_courses_12, t0.limit_sessions AS limit_sessions_13, t0.limit_users AS limit_users_14, t0.limit_teachers AS limit_teachers_15, t0.limit_disk_space AS limit_disk_space_16, t0.email AS email_17, t0.is_login_only AS is_login_only_18, t0.resource_node_id AS resource_node_id_19, t0.parent_id AS parent_id_20, t0.tree_root AS tree_root_21 FROM access_url t0 WHERE t0.id = 1;

SELECT
  COUNT(*)
FROM
  access_url t0

SELECT COUNT(*) FROM access_url t0;

SELECT
  MIN(a0_.id) AS sclr_0
FROM
  access_url a0_

SELECT MIN(a0_.id) AS sclr_0 FROM access_url a0_;