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

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
  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,
  r1_.id AS id_9,
  r1_.title AS title_10,
  r1_.created_at AS created_at_11,
  r1_.updated_at AS updated_at_12,
  u2_.id AS id_13,
  u2_.username AS username_14,
  u2_.api_token AS api_token_15,
  u2_.firstname AS firstname_16,
  u2_.lastname AS lastname_17,
  u2_.website AS website_18,
  u2_.biography AS biography_19,
  u2_.locale AS locale_20,
  u2_.password AS password_21,
  u2_.username_canonical AS username_canonical_22,
  u2_.timezone AS timezone_23,
  u2_.email_canonical AS email_canonical_24,
  u2_.email AS email_25,
  u2_.locked AS locked_26,
  u2_.expired AS expired_27,
  u2_.credentials_expired AS credentials_expired_28,
  u2_.credentials_expire_at AS credentials_expire_at_29,
  u2_.date_of_birth AS date_of_birth_30,
  u2_.expires_at AS expires_at_31,
  u2_.phone AS phone_32,
  u2_.address AS address_33,
  u2_.salt AS salt_34,
  u2_.gender AS gender_35,
  u2_.last_login AS last_login_36,
  u2_.confirmation_token AS confirmation_token_37,
  u2_.password_requested_at AS password_requested_at_38,
  u2_.roles AS roles_39,
  u2_.profile_completed AS profile_completed_40,
  u2_.auth_source AS auth_source_41,
  u2_.status AS status_42,
  u2_.official_code AS official_code_43,
  u2_.picture_uri AS picture_uri_44,
  u2_.creator_id AS creator_id_45,
  u2_.competences AS competences_46,
  u2_.diplomas AS diplomas_47,
  u2_.openarea AS openarea_48,
  u2_.teach AS teach_49,
  u2_.productions AS productions_50,
  u2_.registration_date AS registration_date_51,
  u2_.expiration_date AS expiration_date_52,
  u2_.active AS active_53,
  u2_.openid AS openid_54,
  u2_.theme AS theme_55,
  u2_.hr_dept_id AS hr_dept_id_56,
  u2_.uuid AS uuid_57,
  u2_.created_at AS created_at_58,
  u2_.updated_at AS updated_at_59,
  r3_.id AS id_60,
  r3_.title AS title_61,
  r3_.slug AS slug_62,
  r3_.level AS level_63,
  r3_.path AS path_64,
  r3_.created_at AS created_at_65,
  r3_.updated_at AS updated_at_66,
  r3_.public AS public_67,
  r3_.uuid AS uuid_68,
  r0_.resource_type_id AS resource_type_id_69,
  r0_.resource_format_id AS resource_format_id_70,
  r0_.creator_id AS creator_id_71,
  r0_.parent_id AS parent_id_72,
  r1_.tool_id AS tool_id_73,
  u2_.resource_node_id AS resource_node_id_74,
  r3_.resource_type_id AS resource_type_id_75,
  r3_.resource_format_id AS resource_format_id_76,
  r3_.creator_id AS creator_id_77,
  r3_.parent_id AS parent_id_78
FROM
  resource_node r0_
  INNER JOIN resource_type r1_ ON r0_.resource_type_id = r1_.id
  LEFT JOIN user u2_ ON r0_.creator_id = u2_.id
  LEFT JOIN resource_node r3_ ON r0_.parent_id = r3_.id
WHERE
  r0_.id = ?

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, r1_.id AS id_9, r1_.title AS title_10, r1_.created_at AS created_at_11, r1_.updated_at AS updated_at_12, u2_.id AS id_13, u2_.username AS username_14, u2_.api_token AS api_token_15, u2_.firstname AS firstname_16, u2_.lastname AS lastname_17, u2_.website AS website_18, u2_.biography AS biography_19, u2_.locale AS locale_20, u2_.password AS password_21, u2_.username_canonical AS username_canonical_22, u2_.timezone AS timezone_23, u2_.email_canonical AS email_canonical_24, u2_.email AS email_25, u2_.locked AS locked_26, u2_.expired AS expired_27, u2_.credentials_expired AS credentials_expired_28, u2_.credentials_expire_at AS credentials_expire_at_29, u2_.date_of_birth AS date_of_birth_30, u2_.expires_at AS expires_at_31, u2_.phone AS phone_32, u2_.address AS address_33, u2_.salt AS salt_34, u2_.gender AS gender_35, u2_.last_login AS last_login_36, u2_.confirmation_token AS confirmation_token_37, u2_.password_requested_at AS password_requested_at_38, u2_.roles AS roles_39, u2_.profile_completed AS profile_completed_40, u2_.auth_source AS auth_source_41, u2_.status AS status_42, u2_.official_code AS official_code_43, u2_.picture_uri AS picture_uri_44, u2_.creator_id AS creator_id_45, u2_.competences AS competences_46, u2_.diplomas AS diplomas_47, u2_.openarea AS openarea_48, u2_.teach AS teach_49, u2_.productions AS productions_50, u2_.registration_date AS registration_date_51, u2_.expiration_date AS expiration_date_52, u2_.active AS active_53, u2_.openid AS openid_54, u2_.theme AS theme_55, u2_.hr_dept_id AS hr_dept_id_56, u2_.uuid AS uuid_57, u2_.created_at AS created_at_58, u2_.updated_at AS updated_at_59, r3_.id AS id_60, r3_.title AS title_61, r3_.slug AS slug_62, r3_.level AS level_63, r3_.path AS path_64, r3_.created_at AS created_at_65, r3_.updated_at AS updated_at_66, r3_.public AS public_67, r3_.uuid AS uuid_68, r0_.resource_type_id AS resource_type_id_69, r0_.resource_format_id AS resource_format_id_70, r0_.creator_id AS creator_id_71, r0_.parent_id AS parent_id_72, r1_.tool_id AS tool_id_73, u2_.resource_node_id AS resource_node_id_74, r3_.resource_type_id AS resource_type_id_75, r3_.resource_format_id AS resource_format_id_76, r3_.creator_id AS creator_id_77, r3_.parent_id AS parent_id_78 FROM resource_node r0_ INNER JOIN resource_type r1_ ON r0_.resource_type_id = r1_.id LEFT JOIN user u2_ ON r0_.creator_id = u2_.id LEFT JOIN resource_node r3_ ON r0_.parent_id = r3_.id WHERE r0_.id = 98;

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 = 98;

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.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.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.auth_source AS auth_source_29,
  t0.status AS status_30,
  t0.official_code AS official_code_31,
  t0.picture_uri AS picture_uri_32,
  t0.creator_id AS creator_id_33,
  t0.competences AS competences_34,
  t0.diplomas AS diplomas_35,
  t0.openarea AS openarea_36,
  t0.teach AS teach_37,
  t0.productions AS productions_38,
  t0.registration_date AS registration_date_39,
  t0.expiration_date AS expiration_date_40,
  t0.active AS active_41,
  t0.openid AS openid_42,
  t0.theme AS theme_43,
  t0.hr_dept_id AS hr_dept_id_44,
  t0.uuid AS uuid_45,
  t0.created_at AS created_at_46,
  t0.updated_at AS updated_at_47,
  t0.resource_node_id AS resource_node_id_48,
  t49.id AS id_50,
  t49.user_id AS user_id_51
FROM
  user t0
  LEFT JOIN admin t49 ON t49.user_id = t0.id
WHERE
  t0.status = ?
ORDER BY
  t0.registration_date ASC
LIMIT
  1

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.auth_source AS auth_source_29, t0.status AS status_30, t0.official_code AS official_code_31, t0.picture_uri AS picture_uri_32, t0.creator_id AS creator_id_33, t0.competences AS competences_34, t0.diplomas AS diplomas_35, t0.openarea AS openarea_36, t0.teach AS teach_37, t0.productions AS productions_38, t0.registration_date AS registration_date_39, t0.expiration_date AS expiration_date_40, t0.active AS active_41, t0.openid AS openid_42, t0.theme AS theme_43, t0.hr_dept_id AS hr_dept_id_44, t0.uuid AS uuid_45, t0.created_at AS created_at_46, t0.updated_at AS updated_at_47, t0.resource_node_id AS resource_node_id_48, t49.id AS id_50, t49.user_id AS user_id_51 FROM user t0 LEFT JOIN admin t49 ON t49.user_id = t0.id WHERE t0.status = 6 ORDER BY t0.registration_date ASC LIMIT 1;

SELECT
  t0.login_id AS login_id_1,
  t0.login_date AS login_date_2,
  t0.user_ip AS user_ip_3,
  t0.logout_date AS logout_date_4,
  t0.login_user_id AS login_user_id_5
FROM
  track_e_login t0
WHERE
  t0.user_ip = ?
  AND t0.login_user_id = ?
LIMIT
  1

SELECT t0.login_id AS login_id_1, t0.login_date AS login_date_2, t0.user_ip AS user_ip_3, t0.logout_date AS logout_date_4, t0.login_user_id AS login_user_id_5 FROM track_e_login t0 WHERE t0.user_ip = '18.117.101.7' AND t0.login_user_id = 2 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.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
  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 = 27;

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

SELECT COUNT(*) FROM resource_file t0 WHERE t0.resource_node_id = 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 = ?
  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
  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 = 4;

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 = 26;

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

SELECT COUNT(*) FROM resource_file t0 WHERE t0.resource_node_id = 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 = ?
  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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.mime_type AS mime_type_3,
  t0.original_name AS original_name_4,
  t0.dimensions AS dimensions_5,
  t0.size AS size_6,
  t0.crop AS crop_7,
  t0.metadata AS metadata_8,
  t0.description AS description_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.resource_node_id AS resource_node_id_12
FROM
  resource_file t0
WHERE
  t0.resource_node_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.dimensions AS dimensions_5, t0.size AS size_6, t0.crop AS crop_7, t0.metadata AS metadata_8, t0.description AS description_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.resource_node_id AS resource_node_id_12 FROM resource_file t0 WHERE t0.resource_node_id = 4;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.mime_type AS mime_type_3,
  t0.original_name AS original_name_4,
  t0.dimensions AS dimensions_5,
  t0.size AS size_6,
  t0.crop AS crop_7,
  t0.metadata AS metadata_8,
  t0.description AS description_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.resource_node_id AS resource_node_id_12
FROM
  resource_file t0
WHERE
  t0.resource_node_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.mime_type AS mime_type_3, t0.original_name AS original_name_4, t0.dimensions AS dimensions_5, t0.size AS size_6, t0.crop AS crop_7, t0.metadata AS metadata_8, t0.description AS description_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.resource_node_id AS resource_node_id_12 FROM resource_file t0 WHERE t0.resource_node_id = 93;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.mime_type AS mime_type_3,
  t0.original_name AS original_name_4,
  t0.dimensions AS dimensions_5,
  t0.size AS size_6,
  t0.crop AS crop_7,
  t0.metadata AS metadata_8,
  t0.description AS description_9,
  t0.updated_at AS updated_at_10,
  t0.created_at AS created_at_11,
  t0.resource_node_id AS resource_node_id_12
FROM
  resource_file t0
WHERE
  t0.resource_node_id = ?