Symfony Profiler

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

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 = '47.128.60.229' AND t0.login_user_id = 2 LIMIT 1;

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

SELECT
  DISTINCT c0_.iid AS iid_0,
  c0_.iid AS iid_1
FROM
  c_tool c0_
  INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id
  INNER JOIN resource_link r2_ ON r1_.id = r2_.resource_node_id
  AND (r2_.deleted_at IS NULL)
  INNER JOIN course c3_ ON c0_.c_id = c3_.id
  INNER JOIN access_url_rel_course a4_ ON c3_.id = a4_.c_id
WHERE
  c0_.iid IN (
    SELECT
      c5_.iid
    FROM
      c_tool c5_
      INNER JOIN resource_node r6_ ON c5_.resource_node_id = r6_.id
      INNER JOIN resource_link r7_ ON r6_.id = r7_.resource_node_id
      AND (r7_.deleted_at IS NULL)
      INNER JOIN course c8_ ON c5_.c_id = c8_.id
      INNER JOIN access_url_rel_course a9_ ON c8_.id = a9_.c_id
    WHERE
      c5_.title NOT IN (
        'course_tool', 'course_homepage'
      )
      AND a9_.access_url_id = ?
  )
ORDER BY
  c0_.iid ASC
LIMIT
  30

SELECT DISTINCT c0_.iid AS iid_0, c0_.iid AS iid_1 FROM c_tool c0_ INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id INNER JOIN resource_link r2_ ON r1_.id = r2_.resource_node_id AND (r2_.deleted_at IS NULL) INNER JOIN course c3_ ON c0_.c_id = c3_.id INNER JOIN access_url_rel_course a4_ ON c3_.id = a4_.c_id WHERE c0_.iid IN (SELECT c5_.iid FROM c_tool c5_ INNER JOIN resource_node r6_ ON c5_.resource_node_id = r6_.id INNER JOIN resource_link r7_ ON r6_.id = r7_.resource_node_id AND (r7_.deleted_at IS NULL) INNER JOIN course c8_ ON c5_.c_id = c8_.id INNER JOIN access_url_rel_course a9_ ON c8_.id = a9_.c_id WHERE c5_.title NOT IN ('course_tool', 'course_homepage') AND a9_.access_url_id = 1) ORDER BY c0_.iid ASC LIMIT 30;

SELECT
  c0_.iid AS iid_0,
  c0_.title AS title_1,
  c0_.visibility AS visibility_2,
  c0_.position AS position_3,
  r1_.id AS id_4,
  r1_.title AS title_5,
  r1_.slug AS slug_6,
  r1_.level AS level_7,
  r1_.path AS path_8,
  r1_.created_at AS created_at_9,
  r1_.updated_at AS updated_at_10,
  r1_.public AS public_11,
  r1_.uuid AS uuid_12,
  r2_.id AS id_13,
  r2_.visibility AS visibility_14,
  r2_.start_visibility_at AS start_visibility_at_15,
  r2_.end_visibility_at AS end_visibility_at_16,
  r2_.display_order AS display_order_17,
  r2_.resource_type_group AS resource_type_group_18,
  r2_.deleted_at AS deleted_at_19,
  r2_.created_at AS created_at_20,
  r2_.updated_at AS updated_at_21,
  c0_.resource_node_id AS resource_node_id_22,
  c0_.c_id AS c_id_23,
  c0_.session_id AS session_id_24,
  c0_.tool_id AS tool_id_25,
  r1_.resource_type_id AS resource_type_id_26,
  r1_.resource_format_id AS resource_format_id_27,
  r1_.creator_id AS creator_id_28,
  r1_.parent_id AS parent_id_29,
  r2_.resource_node_id AS resource_node_id_30,
  r2_.c_id AS c_id_31,
  r2_.session_id AS session_id_32,
  r2_.usergroup_id AS usergroup_id_33,
  r2_.group_id AS group_id_34,
  r2_.user_id AS user_id_35
FROM
  c_tool c0_
  INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id
  INNER JOIN resource_link r2_ ON r1_.id = r2_.resource_node_id
  AND (r2_.deleted_at IS NULL)
  INNER JOIN course c3_ ON c0_.c_id = c3_.id
  INNER JOIN access_url_rel_course a4_ ON c3_.id = a4_.c_id
WHERE
  c0_.iid IN (
    SELECT
      c5_.iid
    FROM
      c_tool c5_
      INNER JOIN resource_node r6_ ON c5_.resource_node_id = r6_.id
      INNER JOIN resource_link r7_ ON r6_.id = r7_.resource_node_id
      AND (r7_.deleted_at IS NULL)
      INNER JOIN course c8_ ON c5_.c_id = c8_.id
      INNER JOIN access_url_rel_course a9_ ON c8_.id = a9_.c_id
    WHERE
      c5_.title NOT IN (
        'course_tool', 'course_homepage'
      )
      AND a9_.access_url_id = ?
  )
  AND c0_.iid IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c0_.iid ASC

SELECT c0_.iid AS iid_0, c0_.title AS title_1, c0_.visibility AS visibility_2, c0_.position AS position_3, r1_.id AS id_4, r1_.title AS title_5, r1_.slug AS slug_6, r1_.level AS level_7, r1_.path AS path_8, r1_.created_at AS created_at_9, r1_.updated_at AS updated_at_10, r1_.public AS public_11, r1_.uuid AS uuid_12, r2_.id AS id_13, r2_.visibility AS visibility_14, r2_.start_visibility_at AS start_visibility_at_15, r2_.end_visibility_at AS end_visibility_at_16, r2_.display_order AS display_order_17, r2_.resource_type_group AS resource_type_group_18, r2_.deleted_at AS deleted_at_19, r2_.created_at AS created_at_20, r2_.updated_at AS updated_at_21, c0_.resource_node_id AS resource_node_id_22, c0_.c_id AS c_id_23, c0_.session_id AS session_id_24, c0_.tool_id AS tool_id_25, r1_.resource_type_id AS resource_type_id_26, r1_.resource_format_id AS resource_format_id_27, r1_.creator_id AS creator_id_28, r1_.parent_id AS parent_id_29, r2_.resource_node_id AS resource_node_id_30, r2_.c_id AS c_id_31, r2_.session_id AS session_id_32, r2_.usergroup_id AS usergroup_id_33, r2_.group_id AS group_id_34, r2_.user_id AS user_id_35 FROM c_tool c0_ INNER JOIN resource_node r1_ ON c0_.resource_node_id = r1_.id INNER JOIN resource_link r2_ ON r1_.id = r2_.resource_node_id AND (r2_.deleted_at IS NULL) INNER JOIN course c3_ ON c0_.c_id = c3_.id INNER JOIN access_url_rel_course a4_ ON c3_.id = a4_.c_id WHERE c0_.iid IN (SELECT c5_.iid FROM c_tool c5_ INNER JOIN resource_node r6_ ON c5_.resource_node_id = r6_.id INNER JOIN resource_link r7_ ON r6_.id = r7_.resource_node_id AND (r7_.deleted_at IS NULL) INNER JOIN course c8_ ON c5_.c_id = c8_.id INNER JOIN access_url_rel_course a9_ ON c8_.id = a9_.c_id WHERE c5_.title NOT IN ('course_tool', 'course_homepage') AND a9_.access_url_id = 1) AND c0_.iid IN (1, 2, 3, 4, 5, 6, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 49, 50, 51, 52, 53, 54, 56, 58) 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

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
  COUNT(*)
FROM
  access_url t0

SELECT COUNT(*) FROM access_url t0;

"COMMIT"

"COMMIT";

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

INSERT INTO track_e_login (
  login_date, user_ip, logout_date,
  login_user_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO track_e_login (login_date, user_ip, logout_date, login_user_id) VALUES ('2025-01-24 08:09:20', '47.128.60.229', NULL, 2);

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

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

"START TRANSACTION"

"START TRANSACTION";