Symfony Profiler

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.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.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.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.id = 1;

SELECT
  COUNT(*)
FROM
  access_url t0

SELECT COUNT(*) FROM access_url t0;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.api_token AS api_token_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.website AS website_6,
  t0.biography AS biography_7,
  t0.locale AS locale_8,
  t0.password AS password_9,
  t0.username_canonical AS username_canonical_10,
  t0.timezone AS timezone_11,
  t0.email_canonical AS email_canonical_12,
  t0.email AS email_13,
  t0.locked AS locked_14,
  t0.expired AS expired_15,
  t0.credentials_expired AS credentials_expired_16,
  t0.credentials_expire_at AS credentials_expire_at_17,
  t0.date_of_birth AS date_of_birth_18,
  t0.expires_at AS expires_at_19,
  t0.phone AS phone_20,
  t0.address AS address_21,
  t0.salt AS salt_22,
  t0.gender AS gender_23,
  t0.last_login AS last_login_24,
  t0.confirmation_token AS confirmation_token_25,
  t0.password_requested_at AS password_requested_at_26,
  t0.roles AS roles_27,
  t0.profile_completed AS profile_completed_28,
  t0.status AS status_29,
  t0.official_code AS official_code_30,
  t0.picture_uri AS picture_uri_31,
  t0.creator_id AS creator_id_32,
  t0.competences AS competences_33,
  t0.diplomas AS diplomas_34,
  t0.openarea AS openarea_35,
  t0.teach AS teach_36,
  t0.productions AS productions_37,
  t0.expiration_date AS expiration_date_38,
  t0.active AS active_39,
  t0.openid AS openid_40,
  t0.theme AS theme_41,
  t0.hr_dept_id AS hr_dept_id_42,
  t0.uuid AS uuid_43,
  t0.mfa_enabled AS mfa_enabled_44,
  t0.mfa_service AS mfa_service_45,
  t0.mfa_secret AS mfa_secret_46,
  t0.mfa_backup_codes AS mfa_backup_codes_47,
  t0.mfa_last_used AS mfa_last_used_48,
  t0.created_at AS created_at_49,
  t0.updated_at AS updated_at_50,
  t0.resource_node_id AS resource_node_id_51,
  t52.id AS id_53,
  t52.user_id AS user_id_54
FROM
  user t0
  LEFT JOIN admin t52 ON t52.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.api_token AS api_token_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.website AS website_6, t0.biography AS biography_7, t0.locale AS locale_8, t0.password AS password_9, t0.username_canonical AS username_canonical_10, t0.timezone AS timezone_11, t0.email_canonical AS email_canonical_12, t0.email AS email_13, t0.locked AS locked_14, t0.expired AS expired_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.date_of_birth AS date_of_birth_18, t0.expires_at AS expires_at_19, t0.phone AS phone_20, t0.address AS address_21, t0.salt AS salt_22, t0.gender AS gender_23, t0.last_login AS last_login_24, t0.confirmation_token AS confirmation_token_25, t0.password_requested_at AS password_requested_at_26, t0.roles AS roles_27, t0.profile_completed AS profile_completed_28, t0.status AS status_29, t0.official_code AS official_code_30, t0.picture_uri AS picture_uri_31, t0.creator_id AS creator_id_32, t0.competences AS competences_33, t0.diplomas AS diplomas_34, t0.openarea AS openarea_35, t0.teach AS teach_36, t0.productions AS productions_37, t0.expiration_date AS expiration_date_38, t0.active AS active_39, t0.openid AS openid_40, t0.theme AS theme_41, t0.hr_dept_id AS hr_dept_id_42, t0.uuid AS uuid_43, t0.mfa_enabled AS mfa_enabled_44, t0.mfa_service AS mfa_service_45, t0.mfa_secret AS mfa_secret_46, t0.mfa_backup_codes AS mfa_backup_codes_47, t0.mfa_last_used AS mfa_last_used_48, t0.created_at AS created_at_49, t0.updated_at AS updated_at_50, t0.resource_node_id AS resource_node_id_51, t52.id AS id_53, t52.user_id AS user_id_54 FROM user t0 LEFT JOIN admin t52 ON t52.user_id = t0.id WHERE t0.id = 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
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 = 'profile';

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 = 'display';

SELECT
  t0.id AS id_1,
  t0.authentication AS authentication_2,
  t0.url_id AS url_id_3,
  t0.user_id AS user_id_4
FROM
  user_auth_source t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.authentication AS authentication_2, t0.url_id AS url_id_3, t0.user_id AS user_id_4 FROM user_auth_source t0 WHERE t0.user_id = 1;

SELECT
  *
FROM
  admin
WHERE
  user_id = 1

SELECT * FROM admin WHERE user_id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.title AS title_3,
  t0.roles AS roles_4
FROM
  fos_group t0
  INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id
WHERE
  fos_user_user_group.user_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.roles AS roles_4 FROM fos_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.level AS level_4,
  t0.path AS path_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.public AS public_8,
  t0.uuid AS uuid_9,
  t0.resource_type_id AS resource_type_id_10,
  t0.resource_format_id AS resource_format_id_11,
  t0.creator_id AS creator_id_12,
  t0.parent_id AS parent_id_13,
  t14.id AS id_15,
  t14.title AS title_16,
  t14.resource_node_id AS resource_node_id_17,
  t14.shortcut_node_id AS shortcut_node_id_18
FROM
  resource_node t0
  LEFT JOIN c_shortcut t14 ON t14.shortcut_node_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.level AS level_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.public AS public_8, t0.uuid AS uuid_9, t0.resource_type_id AS resource_type_id_10, t0.resource_format_id AS resource_format_id_11, t0.creator_id AS creator_id_12, t0.parent_id AS parent_id_13, t14.id AS id_15, t14.title AS title_16, t14.resource_node_id AS resource_node_id_17, t14.shortcut_node_id AS shortcut_node_id_18 FROM resource_node t0 LEFT JOIN c_shortcut t14 ON t14.shortcut_node_id = t0.id WHERE t0.id = 1;

SELECT
  COUNT(*)
FROM
  resource_file t0
WHERE
  t0.resource_node_id = ?

SELECT COUNT(*) FROM resource_file t0 WHERE t0.resource_node_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.tool_id AS tool_id_5
FROM
  resource_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.tool_id AS tool_id_5 FROM resource_type t0 WHERE t0.id = 28;

SELECT
  t0.id AS id_1,
  t0.title AS title_2
FROM
  tool t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2 FROM tool t0 WHERE t0.id = 15;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.slug AS slug_2,
  r0_.level AS level_3,
  r0_.path AS path_4,
  r0_.created_at AS created_at_5,
  r0_.updated_at AS updated_at_6,
  r0_.public AS public_7,
  r0_.uuid AS uuid_8,
  r0_.resource_type_id AS resource_type_id_9,
  r0_.resource_format_id AS resource_format_id_10,
  r0_.creator_id AS creator_id_11,
  r0_.parent_id AS parent_id_12
FROM
  resource_node r1_,
  resource_node r0_
  INNER JOIN resource_type r2_ ON r0_.resource_type_id = r2_.id
  INNER JOIN resource_file r3_ ON r0_.id = r3_.resource_node_id
WHERE
  r0_.parent_id = ?
  AND r2_.title = ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.slug AS slug_2, r0_.level AS level_3, r0_.path AS path_4, r0_.created_at AS created_at_5, r0_.updated_at AS updated_at_6, r0_.public AS public_7, r0_.uuid AS uuid_8, r0_.resource_type_id AS resource_type_id_9, r0_.resource_format_id AS resource_format_id_10, r0_.creator_id AS creator_id_11, r0_.parent_id AS parent_id_12 FROM resource_node r1_, resource_node r0_ INNER JOIN resource_type r2_ ON r0_.resource_type_id = r2_.id INNER JOIN resource_file r3_ ON r0_.id = r3_.resource_node_id WHERE r0_.parent_id = 1 AND r2_.title = 'illustrations' LIMIT 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 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.relation_type AS relation_type_2,
  t0.status AS status_3,
  t0.is_tutor AS is_tutor_4,
  t0.sort AS sort_5,
  t0.user_course_cat AS user_course_cat_6,
  t0.legal_agreement AS legal_agreement_7,
  t0.progress AS progress_8,
  t0.user_id AS user_id_9,
  t0.c_id AS c_id_10
FROM
  course_rel_user t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.relation_type AS relation_type_2, t0.status AS status_3, t0.is_tutor AS is_tutor_4, t0.sort AS sort_5, t0.user_course_cat AS user_course_cat_6, t0.legal_agreement AS legal_agreement_7, t0.progress AS progress_8, t0.user_id AS user_id_9, t0.c_id AS c_id_10 FROM course_rel_user t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.score_certificate AS score_certificate_2,
  t0.created_at AS created_at_3,
  t0.path_certificate AS path_certificate_4,
  t0.downloaded_at AS downloaded_at_5,
  t0.publish AS publish_6,
  t0.cat_id AS cat_id_7,
  t0.user_id AS user_id_8
FROM
  gradebook_certificate t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.score_certificate AS score_certificate_2, t0.created_at AS created_at_3, t0.path_certificate AS path_certificate_4, t0.downloaded_at AS downloaded_at_5, t0.publish AS publish_6, t0.cat_id AS cat_id_7, t0.user_id AS user_id_8 FROM gradebook_certificate t0 WHERE t0.user_id = 1;

SELECT
  t0.exe_id AS exe_id_1,
  t0.exe_date AS exe_date_2,
  t0.score AS score_3,
  t0.max_score AS max_score_4,
  t0.user_ip AS user_ip_5,
  t0.status AS status_6,
  t0.data_tracking AS data_tracking_7,
  t0.start_date AS start_date_8,
  t0.steps_counter AS steps_counter_9,
  t0.orig_lp_id AS orig_lp_id_10,
  t0.orig_lp_item_id AS orig_lp_item_id_11,
  t0.exe_duration AS exe_duration_12,
  t0.expired_time_control AS expired_time_control_13,
  t0.orig_lp_item_view_id AS orig_lp_item_view_id_14,
  t0.questions_to_check AS questions_to_check_15,
  t0.blocked_categories AS blocked_categories_16,
  t0.exe_user_id AS exe_user_id_17,
  t0.c_id AS c_id_18,
  t0.session_id AS session_id_19,
  t0.exe_exo_id AS exe_exo_id_20
FROM
  track_e_exercises t0
WHERE
  t0.exe_user_id = ?

SELECT t0.exe_id AS exe_id_1, t0.exe_date AS exe_date_2, t0.score AS score_3, t0.max_score AS max_score_4, t0.user_ip AS user_ip_5, t0.status AS status_6, t0.data_tracking AS data_tracking_7, t0.start_date AS start_date_8, t0.steps_counter AS steps_counter_9, t0.orig_lp_id AS orig_lp_id_10, t0.orig_lp_item_id AS orig_lp_item_id_11, t0.exe_duration AS exe_duration_12, t0.expired_time_control AS expired_time_control_13, t0.orig_lp_item_view_id AS orig_lp_item_view_id_14, t0.questions_to_check AS questions_to_check_15, t0.blocked_categories AS blocked_categories_16, t0.exe_user_id AS exe_user_id_17, t0.c_id AS c_id_18, t0.session_id AS session_id_19, t0.exe_exo_id AS exe_exo_id_20 FROM track_e_exercises t0 WHERE t0.exe_user_id = 1;

SELECT
  t0.id AS id_1,
  t0.visibility AS visibility_2,
  t0.start_visibility_at AS start_visibility_at_3,
  t0.end_visibility_at AS end_visibility_at_4,
  t0.display_order AS display_order_5,
  t0.resource_type_group AS resource_type_group_6,
  t0.deleted_at AS deleted_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.resource_node_id AS resource_node_id_10,
  t0.c_id AS c_id_11,
  t0.session_id AS session_id_12,
  t0.usergroup_id AS usergroup_id_13,
  t0.group_id AS group_id_14,
  t0.user_id AS user_id_15
FROM
  resource_link t0
WHERE
  t0.resource_node_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.visibility AS visibility_2, t0.start_visibility_at AS start_visibility_at_3, t0.end_visibility_at AS end_visibility_at_4, t0.display_order AS display_order_5, t0.resource_type_group AS resource_type_group_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.resource_node_id AS resource_node_id_10, t0.c_id AS c_id_11, t0.session_id AS session_id_12, t0.usergroup_id AS usergroup_id_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM resource_link t0 WHERE t0.resource_node_id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.down_id AS down_id_1,
  t0.down_user_id AS down_user_id_2,
  t0.down_date AS down_date_3,
  t0.down_doc_path AS down_doc_path_4,
  t0.resource_link_id AS resource_link_id_5
FROM
  track_e_downloads t0
WHERE
  t0.resource_link_id = ?

SELECT t0.down_id AS down_id_1, t0.down_user_id AS down_user_id_2, t0.down_date AS down_date_3, t0.down_doc_path AS down_doc_path_4, t0.resource_link_id AS resource_link_id_5 FROM track_e_downloads t0 WHERE t0.resource_link_id = 0;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.sort AS sort_3,
  t0.collapsed AS collapsed_4,
  t0.user_id AS user_id_5
FROM
  user_course_category t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.sort AS sort_3, t0.collapsed AS collapsed_4, t0.user_id AS user_id_5 FROM user_course_category t0 WHERE t0.user_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.title AS title_2,
  t0.post_text AS post_text_3,
  t0.post_date AS post_date_4,
  t0.post_notification AS post_notification_5,
  t0.visible AS visible_6,
  t0.status AS status_7,
  t0.resource_node_id AS resource_node_id_8,
  t0.thread_id AS thread_id_9,
  t0.forum_id AS forum_id_10,
  t0.poster_id AS poster_id_11,
  t0.post_parent_id AS post_parent_id_12
FROM
  c_forum_post t0
WHERE
  t0.poster_id = ?

SELECT t0.iid AS iid_1, t0.title AS title_2, t0.post_text AS post_text_3, t0.post_date AS post_date_4, t0.post_notification AS post_notification_5, t0.visible AS visible_6, t0.status AS status_7, t0.resource_node_id AS resource_node_id_8, t0.thread_id AS thread_id_9, t0.forum_id AS forum_id_10, t0.poster_id AS poster_id_11, t0.post_parent_id AS post_parent_id_12 FROM c_forum_post t0 WHERE t0.poster_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.title AS title_2,
  t0.thread_date AS thread_date_3,
  t0.thread_replies AS thread_replies_4,
  t0.thread_views AS thread_views_5,
  t0.thread_sticky AS thread_sticky_6,
  t0.locked AS locked_7,
  t0.thread_title_qualify AS thread_title_qualify_8,
  t0.thread_qualify_max AS thread_qualify_max_9,
  t0.thread_close_date AS thread_close_date_10,
  t0.thread_weight AS thread_weight_11,
  t0.thread_peer_qualify AS thread_peer_qualify_12,
  t0.resource_node_id AS resource_node_id_13,
  t0.forum_id AS forum_id_14,
  t0.thread_poster_id AS thread_poster_id_15,
  t0.thread_last_post AS thread_last_post_16,
  t0.lp_item_id AS lp_item_id_17
FROM
  c_forum_thread t0
WHERE
  t0.thread_poster_id = ?

SELECT t0.iid AS iid_1, t0.title AS title_2, t0.thread_date AS thread_date_3, t0.thread_replies AS thread_replies_4, t0.thread_views AS thread_views_5, t0.thread_sticky AS thread_sticky_6, t0.locked AS locked_7, t0.thread_title_qualify AS thread_title_qualify_8, t0.thread_qualify_max AS thread_qualify_max_9, t0.thread_close_date AS thread_close_date_10, t0.thread_weight AS thread_weight_11, t0.thread_peer_qualify AS thread_peer_qualify_12, t0.resource_node_id AS resource_node_id_13, t0.forum_id AS forum_id_14, t0.thread_poster_id AS thread_poster_id_15, t0.thread_last_post AS thread_last_post_16, t0.lp_item_id AS lp_item_id_17 FROM c_forum_thread t0 WHERE t0.thread_poster_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.title AS title_2,
  t0.thread_date AS thread_date_3,
  t0.thread_replies AS thread_replies_4,
  t0.thread_views AS thread_views_5,
  t0.thread_sticky AS thread_sticky_6,
  t0.locked AS locked_7,
  t0.thread_title_qualify AS thread_title_qualify_8,
  t0.thread_qualify_max AS thread_qualify_max_9,
  t0.thread_close_date AS thread_close_date_10,
  t0.thread_weight AS thread_weight_11,
  t0.thread_peer_qualify AS thread_peer_qualify_12,
  t0.resource_node_id AS resource_node_id_13,
  t0.forum_id AS forum_id_14,
  t0.thread_poster_id AS thread_poster_id_15,
  t0.thread_last_post AS thread_last_post_16,
  t0.lp_item_id AS lp_item_id_17
FROM
  c_forum_thread t0
WHERE
  t0.thread_poster_id = ?

SELECT t0.iid AS iid_1, t0.title AS title_2, t0.thread_date AS thread_date_3, t0.thread_replies AS thread_replies_4, t0.thread_views AS thread_views_5, t0.thread_sticky AS thread_sticky_6, t0.locked AS locked_7, t0.thread_title_qualify AS thread_title_qualify_8, t0.thread_qualify_max AS thread_qualify_max_9, t0.thread_close_date AS thread_close_date_10, t0.thread_weight AS thread_weight_11, t0.thread_peer_qualify AS thread_peer_qualify_12, t0.resource_node_id AS resource_node_id_13, t0.forum_id AS forum_id_14, t0.thread_poster_id AS thread_poster_id_15, t0.thread_last_post AS thread_last_post_16, t0.lp_item_id AS lp_item_id_17 FROM c_forum_thread t0 WHERE t0.thread_poster_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.c_id AS c_id_2,
  t0.status AS status_3,
  t0.role AS role_4,
  t0.ready_autogroup AS ready_autogroup_5,
  t0.user_id AS user_id_6,
  t0.group_id AS group_id_7
FROM
  c_group_rel_user t0
WHERE
  t0.user_id = ?

SELECT t0.iid AS iid_1, t0.c_id AS c_id_2, t0.status AS status_3, t0.role AS role_4, t0.ready_autogroup AS ready_autogroup_5, t0.user_id AS user_id_6, t0.group_id AS group_id_7 FROM c_group_rel_user t0 WHERE t0.user_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.presence AS presence_2,
  t0.signature AS signature_3,
  t0.user_id AS user_id_4,
  t0.attendance_calendar_id AS attendance_calendar_id_5
FROM
  c_attendance_sheet t0
WHERE
  t0.user_id = ?

SELECT t0.iid AS iid_1, t0.presence AS presence_2, t0.signature AS signature_3, t0.user_id AS user_id_4, t0.attendance_calendar_id AS attendance_calendar_id_5 FROM c_attendance_sheet t0 WHERE t0.user_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.score AS score_2,
  t0.user_id AS user_id_3,
  t0.attendance_id AS attendance_id_4
FROM
  c_attendance_result t0
WHERE
  t0.user_id = ?

SELECT t0.iid AS iid_1, t0.score AS score_2, t0.user_id AS user_id_3, t0.attendance_id AS attendance_id_4 FROM c_attendance_result t0 WHERE t0.user_id = 1;

SELECT
  t0.id AS id_1,
  t0.msg_type AS msg_type_2,
  t0.status AS status_3,
  t0.send_date AS send_date_4,
  t0.title AS title_5,
  t0.content AS content_6,
  t0.update_date AS update_date_7,
  t0.votes AS votes_8,
  t0.user_sender_id AS user_sender_id_9,
  t0.group_id AS group_id_10,
  t0.parent_id AS parent_id_11
FROM
  message t0
WHERE
  t0.user_sender_id = ?

SELECT t0.id AS id_1, t0.msg_type AS msg_type_2, t0.status AS status_3, t0.send_date AS send_date_4, t0.title AS title_5, t0.content AS content_6, t0.update_date AS update_date_7, t0.votes AS votes_8, t0.user_sender_id AS user_sender_id_9, t0.group_id AS group_id_10, t0.parent_id AS parent_id_11 FROM message t0 WHERE t0.user_sender_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.option_id AS option_id_2,
  t0.value AS value_3,
  t0.user AS user_4,
  t0.session_id AS session_id_5,
  t0.c_lp_item_id AS c_lp_item_id_6,
  t0.survey_id AS survey_id_7,
  t0.question_id AS question_id_8
FROM
  c_survey_answer t0
WHERE
  t0.user = ?

SELECT t0.iid AS iid_1, t0.option_id AS option_id_2, t0.value AS value_3, t0.user AS user_4, t0.session_id AS session_id_5, t0.c_lp_item_id AS c_lp_item_id_6, t0.survey_id AS survey_id_7, t0.question_id AS question_id_8 FROM c_survey_answer t0 WHERE t0.user = 1;

SELECT
  t0.iid AS iid_1,
  t0.view_count AS view_count_2,
  t0.last_item AS last_item_3,
  t0.progress AS progress_4,
  t0.user_id AS user_id_5,
  t0.lp_id AS lp_id_6,
  t0.c_id AS c_id_7,
  t0.session_id AS session_id_8
FROM
  c_lp_view t0
WHERE
  t0.user_id = ?

SELECT t0.iid AS iid_1, t0.view_count AS view_count_2, t0.last_item AS last_item_3, t0.progress AS progress_4, t0.user_id AS user_id_5, t0.lp_id AS lp_id_6, t0.c_id AS c_id_7, t0.session_id AS session_id_8 FROM c_lp_view t0 WHERE t0.user_id = 1;

SELECT
  t0.iid AS iid_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.author AS author_4,
  t0.active AS active_5,
  t0.accepted AS accepted_6,
  t0.post_group_id AS post_group_id_7,
  t0.sent_date AS sent_date_8,
  t0.filetype AS filetype_9,
  t0.has_properties AS has_properties_10,
  t0.view_properties AS view_properties_11,
  t0.qualification AS qualification_12,
  t0.date_of_qualification AS date_of_qualification_13,
  t0.qualificator_id AS qualificator_id_14,
  t0.weight AS weight_15,
  t0.allow_text_assignment AS allow_text_assignment_16,
  t0.contains_file AS contains_file_17,
  t0.document_id AS document_id_18,
  t0.filesize AS filesize_19,
  t0.duration AS duration_20,
  t0.student_delete_own_publication AS student_delete_own_publication_21,
  t0.default_visibility AS default_visibility_22,
  t0.extensions AS extensions_23,
  t0.group_category_work_id AS group_category_work_id_24,
  t0.resource_node_id AS resource_node_id_25,
  t0.parent_id AS parent_id_26,
  t0.user_id AS user_id_27,
  t28.iid AS iid_29,
  t28.expires_on AS expires_on_30,
  t28.ends_on AS ends_on_31,
  t28.add_to_calendar AS add_to_calendar_32,
  t28.enable_qualification AS enable_qualification_33,
  t28.publication_id AS publication_id_34,
  t0.group_category_id AS group_category_id_35
FROM
  c_student_publication t0
  LEFT JOIN c_student_publication_assignment t28 ON t28.publication_id = t0.iid
WHERE
  t0.user_id = ?