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
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 FROM settings t0;

SELECT
  c0_.iid AS iid_0,
  c0_.title AS title_1,
  c0_.content AS content_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.all_day AS all_day_5,
  c0_.comment AS comment_6,
  c0_.color AS color_7,
  c0_.invitation_type AS invitation_type_8,
  c0_.collective AS collective_9,
  c0_.subscription_visibility AS subscription_visibility_10,
  c0_.subscription_item_id AS subscription_item_id_11,
  c0_.max_attendees AS max_attendees_12,
  r1_.id AS id_13,
  r1_.title AS title_14,
  r1_.slug AS slug_15,
  r1_.level AS level_16,
  r1_.path AS path_17,
  r1_.created_at AS created_at_18,
  r1_.updated_at AS updated_at_19,
  r1_.public AS public_20,
  r1_.uuid AS uuid_21,
  r2_.id AS id_22,
  r2_.title AS title_23,
  r2_.created_at AS created_at_24,
  r2_.updated_at AS updated_at_25,
  u3_.id AS id_26,
  u3_.username AS username_27,
  u3_.api_token AS api_token_28,
  u3_.firstname AS firstname_29,
  u3_.lastname AS lastname_30,
  u3_.website AS website_31,
  u3_.biography AS biography_32,
  u3_.locale AS locale_33,
  u3_.password AS password_34,
  u3_.username_canonical AS username_canonical_35,
  u3_.timezone AS timezone_36,
  u3_.email_canonical AS email_canonical_37,
  u3_.email AS email_38,
  u3_.locked AS locked_39,
  u3_.expired AS expired_40,
  u3_.credentials_expired AS credentials_expired_41,
  u3_.credentials_expire_at AS credentials_expire_at_42,
  u3_.date_of_birth AS date_of_birth_43,
  u3_.expires_at AS expires_at_44,
  u3_.phone AS phone_45,
  u3_.address AS address_46,
  u3_.salt AS salt_47,
  u3_.gender AS gender_48,
  u3_.last_login AS last_login_49,
  u3_.confirmation_token AS confirmation_token_50,
  u3_.password_requested_at AS password_requested_at_51,
  u3_.roles AS roles_52,
  u3_.profile_completed AS profile_completed_53,
  u3_.auth_source AS auth_source_54,
  u3_.status AS status_55,
  u3_.official_code AS official_code_56,
  u3_.picture_uri AS picture_uri_57,
  u3_.creator_id AS creator_id_58,
  u3_.competences AS competences_59,
  u3_.diplomas AS diplomas_60,
  u3_.openarea AS openarea_61,
  u3_.teach AS teach_62,
  u3_.productions AS productions_63,
  u3_.registration_date AS registration_date_64,
  u3_.expiration_date AS expiration_date_65,
  u3_.active AS active_66,
  u3_.openid AS openid_67,
  u3_.theme AS theme_68,
  u3_.hr_dept_id AS hr_dept_id_69,
  u3_.uuid AS uuid_70,
  u3_.created_at AS created_at_71,
  u3_.updated_at AS updated_at_72,
  r4_.id AS id_73,
  r4_.title AS title_74,
  r4_.slug AS slug_75,
  r4_.level AS level_76,
  r4_.path AS path_77,
  r4_.created_at AS created_at_78,
  r4_.updated_at AS updated_at_79,
  r4_.public AS public_80,
  r4_.uuid AS uuid_81,
  c0_.resource_node_id AS resource_node_id_82,
  c0_.parent_event_id AS parent_event_id_83,
  c0_.room_id AS room_id_84,
  c0_.career_id AS career_id_85,
  c0_.promotion_id AS promotion_id_86,
  r1_.resource_type_id AS resource_type_id_87,
  r1_.resource_format_id AS resource_format_id_88,
  r1_.creator_id AS creator_id_89,
  r1_.parent_id AS parent_id_90,
  r2_.tool_id AS tool_id_91,
  u3_.resource_node_id AS resource_node_id_92,
  r4_.resource_type_id AS resource_type_id_93,
  r4_.resource_format_id AS resource_format_id_94,
  r4_.creator_id AS creator_id_95,
  r4_.parent_id AS parent_id_96
FROM
  c_calendar_event c0_
  INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id
  LEFT JOIN resource_link r5_ ON r1_.id = r5_.resource_node_id
  AND (r5_.deleted_at IS NULL)
  INNER JOIN resource_type r2_ ON r1_.resource_type_id = r2_.id
  LEFT JOIN user u3_ ON r1_.creator_id = u3_.id
  LEFT JOIN resource_node r4_ ON r1_.parent_id = r4_.id
ORDER BY
  c0_.iid ASC

SELECT c0_.iid AS iid_0, c0_.title AS title_1, c0_.content AS content_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.all_day AS all_day_5, c0_.comment AS comment_6, c0_.color AS color_7, c0_.invitation_type AS invitation_type_8, c0_.collective AS collective_9, c0_.subscription_visibility AS subscription_visibility_10, c0_.subscription_item_id AS subscription_item_id_11, c0_.max_attendees AS max_attendees_12, r1_.id AS id_13, r1_.title AS title_14, r1_.slug AS slug_15, r1_.level AS level_16, r1_.path AS path_17, r1_.created_at AS created_at_18, r1_.updated_at AS updated_at_19, r1_.public AS public_20, r1_.uuid AS uuid_21, r2_.id AS id_22, r2_.title AS title_23, r2_.created_at AS created_at_24, r2_.updated_at AS updated_at_25, u3_.id AS id_26, u3_.username AS username_27, u3_.api_token AS api_token_28, u3_.firstname AS firstname_29, u3_.lastname AS lastname_30, u3_.website AS website_31, u3_.biography AS biography_32, u3_.locale AS locale_33, u3_.password AS password_34, u3_.username_canonical AS username_canonical_35, u3_.timezone AS timezone_36, u3_.email_canonical AS email_canonical_37, u3_.email AS email_38, u3_.locked AS locked_39, u3_.expired AS expired_40, u3_.credentials_expired AS credentials_expired_41, u3_.credentials_expire_at AS credentials_expire_at_42, u3_.date_of_birth AS date_of_birth_43, u3_.expires_at AS expires_at_44, u3_.phone AS phone_45, u3_.address AS address_46, u3_.salt AS salt_47, u3_.gender AS gender_48, u3_.last_login AS last_login_49, u3_.confirmation_token AS confirmation_token_50, u3_.password_requested_at AS password_requested_at_51, u3_.roles AS roles_52, u3_.profile_completed AS profile_completed_53, u3_.auth_source AS auth_source_54, u3_.status AS status_55, u3_.official_code AS official_code_56, u3_.picture_uri AS picture_uri_57, u3_.creator_id AS creator_id_58, u3_.competences AS competences_59, u3_.diplomas AS diplomas_60, u3_.openarea AS openarea_61, u3_.teach AS teach_62, u3_.productions AS productions_63, u3_.registration_date AS registration_date_64, u3_.expiration_date AS expiration_date_65, u3_.active AS active_66, u3_.openid AS openid_67, u3_.theme AS theme_68, u3_.hr_dept_id AS hr_dept_id_69, u3_.uuid AS uuid_70, u3_.created_at AS created_at_71, u3_.updated_at AS updated_at_72, r4_.id AS id_73, r4_.title AS title_74, r4_.slug AS slug_75, r4_.level AS level_76, r4_.path AS path_77, r4_.created_at AS created_at_78, r4_.updated_at AS updated_at_79, r4_.public AS public_80, r4_.uuid AS uuid_81, c0_.resource_node_id AS resource_node_id_82, c0_.parent_event_id AS parent_event_id_83, c0_.room_id AS room_id_84, c0_.career_id AS career_id_85, c0_.promotion_id AS promotion_id_86, r1_.resource_type_id AS resource_type_id_87, r1_.resource_format_id AS resource_format_id_88, r1_.creator_id AS creator_id_89, r1_.parent_id AS parent_id_90, r2_.tool_id AS tool_id_91, u3_.resource_node_id AS resource_node_id_92, r4_.resource_type_id AS resource_type_id_93, r4_.resource_format_id AS resource_format_id_94, r4_.creator_id AS creator_id_95, r4_.parent_id AS parent_id_96 FROM c_calendar_event c0_ INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id LEFT JOIN resource_link r5_ ON r1_.id = r5_.resource_node_id AND (r5_.deleted_at IS NULL) INNER JOIN resource_type r2_ ON r1_.resource_type_id = r2_.id LEFT JOIN user u3_ ON r1_.creator_id = u3_.id LEFT JOIN resource_node r4_ ON r1_.parent_id = r4_.id ORDER BY c0_.iid ASC;

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
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 FROM settings t0 WHERE t0.category = 'tracking';

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.resource_node_id AS resource_node_id_18,
  t0.parent_id AS parent_id_19,
  t0.tree_root AS tree_root_20
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.resource_node_id AS resource_node_id_18, t0.parent_id AS parent_id_19, t0.tree_root AS tree_root_20 FROM access_url t0 WHERE t0.url = 'https://testing25.beeznest.com/' LIMIT 1;

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

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

SELECT
  COUNT(*)
FROM
  access_url t0

SELECT COUNT(*) FROM access_url t0;