Symfony Profiler

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_;

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
  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.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
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.code AS code_2,
  c0_.visual_code AS visual_code_3,
  c0_.directory AS directory_4,
  c0_.course_language AS course_language_5,
  c0_.description AS description_6,
  c0_.introduction AS introduction_7,
  c0_.visibility AS visibility_8,
  c0_.show_score AS show_score_9,
  c0_.tutor_name AS tutor_name_10,
  c0_.department_name AS department_name_11,
  c0_.department_url AS department_url_12,
  c0_.video_url AS video_url_13,
  c0_.sticky AS sticky_14,
  c0_.disk_quota AS disk_quota_15,
  c0_.last_visit AS last_visit_16,
  c0_.last_edit AS last_edit_17,
  c0_.creation_date AS creation_date_18,
  c0_.expiration_date AS expiration_date_19,
  c0_.subscribe AS subscribe_20,
  c0_.unsubscribe AS unsubscribe_21,
  c0_.registration_code AS registration_code_22,
  c0_.legal AS legal_23,
  c0_.activate_legal AS activate_legal_24,
  c0_.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_25,
  c0_.course_type_id AS course_type_id_26,
  c0_.duration AS duration_27,
  c0_.popularity AS popularity_28,
  r1_.id AS id_29,
  r1_.title AS title_30,
  r1_.slug AS slug_31,
  r1_.level AS level_32,
  r1_.path AS path_33,
  r1_.created_at AS created_at_34,
  r1_.updated_at AS updated_at_35,
  r1_.public AS public_36,
  r1_.uuid AS uuid_37,
  c2_.id AS id_38,
  c2_.relation_type AS relation_type_39,
  c2_.status AS status_40,
  c2_.is_tutor AS is_tutor_41,
  c2_.sort AS sort_42,
  c2_.user_course_cat AS user_course_cat_43,
  c2_.legal_agreement AS legal_agreement_44,
  c2_.progress AS progress_45,
  u3_.id AS id_46,
  u3_.username AS username_47,
  u3_.api_token AS api_token_48,
  u3_.firstname AS firstname_49,
  u3_.lastname AS lastname_50,
  u3_.website AS website_51,
  u3_.biography AS biography_52,
  u3_.locale AS locale_53,
  u3_.password AS password_54,
  u3_.username_canonical AS username_canonical_55,
  u3_.timezone AS timezone_56,
  u3_.email_canonical AS email_canonical_57,
  u3_.email AS email_58,
  u3_.locked AS locked_59,
  u3_.expired AS expired_60,
  u3_.credentials_expired AS credentials_expired_61,
  u3_.credentials_expire_at AS credentials_expire_at_62,
  u3_.date_of_birth AS date_of_birth_63,
  u3_.expires_at AS expires_at_64,
  u3_.phone AS phone_65,
  u3_.address AS address_66,
  u3_.salt AS salt_67,
  u3_.gender AS gender_68,
  u3_.last_login AS last_login_69,
  u3_.confirmation_token AS confirmation_token_70,
  u3_.password_requested_at AS password_requested_at_71,
  u3_.roles AS roles_72,
  u3_.profile_completed AS profile_completed_73,
  u3_.status AS status_74,
  u3_.official_code AS official_code_75,
  u3_.picture_uri AS picture_uri_76,
  u3_.creator_id AS creator_id_77,
  u3_.competences AS competences_78,
  u3_.diplomas AS diplomas_79,
  u3_.openarea AS openarea_80,
  u3_.teach AS teach_81,
  u3_.productions AS productions_82,
  u3_.expiration_date AS expiration_date_83,
  u3_.active AS active_84,
  u3_.openid AS openid_85,
  u3_.theme AS theme_86,
  u3_.hr_dept_id AS hr_dept_id_87,
  u3_.uuid AS uuid_88,
  u3_.mfa_enabled AS mfa_enabled_89,
  u3_.mfa_service AS mfa_service_90,
  u3_.mfa_secret AS mfa_secret_91,
  u3_.mfa_backup_codes AS mfa_backup_codes_92,
  u3_.mfa_last_used AS mfa_last_used_93,
  u3_.password_updated_at AS password_updated_at_94,
  u3_.created_at AS created_at_95,
  u3_.updated_at AS updated_at_96,
  c4_.id AS id_97,
  c4_.title AS title_98,
  c4_.code AS code_99,
  c4_.tree_pos AS tree_pos_100,
  c4_.children_count AS children_count_101,
  c4_.auth_course_child AS auth_course_child_102,
  c4_.auth_cat_child AS auth_cat_child_103,
  c4_.description AS description_104,
  c0_.resource_node_id AS resource_node_id_105,
  c0_.room_id AS room_id_106,
  r1_.resource_type_id AS resource_type_id_107,
  r1_.resource_format_id AS resource_format_id_108,
  r1_.creator_id AS creator_id_109,
  r1_.parent_id AS parent_id_110,
  c2_.user_id AS user_id_111,
  c2_.c_id AS c_id_112,
  u3_.resource_node_id AS resource_node_id_113,
  c4_.parent_id AS parent_id_114,
  c4_.asset_id AS asset_id_115
FROM
  course c0_
  LEFT JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id
  LEFT JOIN course_rel_user c2_ ON c0_.id = c2_.c_id
  LEFT JOIN user u3_ ON c2_.user_id = u3_.id
  LEFT JOIN course_rel_category c5_ ON c0_.id = c5_.course_id
  LEFT JOIN course_category c4_ ON c4_.id = c5_.course_category_id
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.code AS code_2, c0_.visual_code AS visual_code_3, c0_.directory AS directory_4, c0_.course_language AS course_language_5, c0_.description AS description_6, c0_.introduction AS introduction_7, c0_.visibility AS visibility_8, c0_.show_score AS show_score_9, c0_.tutor_name AS tutor_name_10, c0_.department_name AS department_name_11, c0_.department_url AS department_url_12, c0_.video_url AS video_url_13, c0_.sticky AS sticky_14, c0_.disk_quota AS disk_quota_15, c0_.last_visit AS last_visit_16, c0_.last_edit AS last_edit_17, c0_.creation_date AS creation_date_18, c0_.expiration_date AS expiration_date_19, c0_.subscribe AS subscribe_20, c0_.unsubscribe AS unsubscribe_21, c0_.registration_code AS registration_code_22, c0_.legal AS legal_23, c0_.activate_legal AS activate_legal_24, c0_.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_25, c0_.course_type_id AS course_type_id_26, c0_.duration AS duration_27, c0_.popularity AS popularity_28, r1_.id AS id_29, r1_.title AS title_30, r1_.slug AS slug_31, r1_.level AS level_32, r1_.path AS path_33, r1_.created_at AS created_at_34, r1_.updated_at AS updated_at_35, r1_.public AS public_36, r1_.uuid AS uuid_37, c2_.id AS id_38, c2_.relation_type AS relation_type_39, c2_.status AS status_40, c2_.is_tutor AS is_tutor_41, c2_.sort AS sort_42, c2_.user_course_cat AS user_course_cat_43, c2_.legal_agreement AS legal_agreement_44, c2_.progress AS progress_45, u3_.id AS id_46, u3_.username AS username_47, u3_.api_token AS api_token_48, u3_.firstname AS firstname_49, u3_.lastname AS lastname_50, u3_.website AS website_51, u3_.biography AS biography_52, u3_.locale AS locale_53, u3_.password AS password_54, u3_.username_canonical AS username_canonical_55, u3_.timezone AS timezone_56, u3_.email_canonical AS email_canonical_57, u3_.email AS email_58, u3_.locked AS locked_59, u3_.expired AS expired_60, u3_.credentials_expired AS credentials_expired_61, u3_.credentials_expire_at AS credentials_expire_at_62, u3_.date_of_birth AS date_of_birth_63, u3_.expires_at AS expires_at_64, u3_.phone AS phone_65, u3_.address AS address_66, u3_.salt AS salt_67, u3_.gender AS gender_68, u3_.last_login AS last_login_69, u3_.confirmation_token AS confirmation_token_70, u3_.password_requested_at AS password_requested_at_71, u3_.roles AS roles_72, u3_.profile_completed AS profile_completed_73, u3_.status AS status_74, u3_.official_code AS official_code_75, u3_.picture_uri AS picture_uri_76, u3_.creator_id AS creator_id_77, u3_.competences AS competences_78, u3_.diplomas AS diplomas_79, u3_.openarea AS openarea_80, u3_.teach AS teach_81, u3_.productions AS productions_82, u3_.expiration_date AS expiration_date_83, u3_.active AS active_84, u3_.openid AS openid_85, u3_.theme AS theme_86, u3_.hr_dept_id AS hr_dept_id_87, u3_.uuid AS uuid_88, u3_.mfa_enabled AS mfa_enabled_89, u3_.mfa_service AS mfa_service_90, u3_.mfa_secret AS mfa_secret_91, u3_.mfa_backup_codes AS mfa_backup_codes_92, u3_.mfa_last_used AS mfa_last_used_93, u3_.password_updated_at AS password_updated_at_94, u3_.created_at AS created_at_95, u3_.updated_at AS updated_at_96, c4_.id AS id_97, c4_.title AS title_98, c4_.code AS code_99, c4_.tree_pos AS tree_pos_100, c4_.children_count AS children_count_101, c4_.auth_course_child AS auth_course_child_102, c4_.auth_cat_child AS auth_cat_child_103, c4_.description AS description_104, c0_.resource_node_id AS resource_node_id_105, c0_.room_id AS room_id_106, r1_.resource_type_id AS resource_type_id_107, r1_.resource_format_id AS resource_format_id_108, r1_.creator_id AS creator_id_109, r1_.parent_id AS parent_id_110, c2_.user_id AS user_id_111, c2_.c_id AS c_id_112, u3_.resource_node_id AS resource_node_id_113, c4_.parent_id AS parent_id_114, c4_.asset_id AS asset_id_115 FROM course c0_ LEFT JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id LEFT JOIN course_rel_user c2_ ON c0_.id = c2_.c_id LEFT JOIN user u3_ ON c2_.user_id = u3_.id LEFT JOIN course_rel_category c5_ ON c0_.id = c5_.course_id LEFT JOIN course_category c4_ ON c4_.id = c5_.course_category_id WHERE c0_.id = 2;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.resource_node_id AS resource_node_id_3,
  t0.shortcut_node_id AS shortcut_node_id_4
FROM
  c_shortcut t0
WHERE
  t0.shortcut_node_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.resource_node_id AS resource_node_id_3, t0.shortcut_node_id AS shortcut_node_id_4 FROM c_shortcut t0 WHERE t0.shortcut_node_id = 93;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2
FROM
  admin t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2 FROM admin t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2
FROM
  admin t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2 FROM admin t0 WHERE t0.user_id = 25;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2
FROM
  admin t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2 FROM admin t0 WHERE t0.user_id = 26;

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2
FROM
  admin t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.user_id AS user_id_2 FROM admin t0 WHERE t0.user_id = 16;