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,
  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
  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.iid AS iid_1,
  t0.c_id AS c_id_2,
  t0.variable AS variable_3,
  t0.subkey AS subkey_4,
  t0.type AS type_5,
  t0.category AS category_6,
  t0.value AS value_7,
  t0.title AS title_8,
  t0.comment AS comment_9,
  t0.subkeytext AS subkeytext_10
FROM
  c_course_setting t0
WHERE
  t0.c_id = ?
  AND t0.variable = ?
LIMIT
  1

SELECT t0.iid AS iid_1, t0.c_id AS c_id_2, t0.variable AS variable_3, t0.subkey AS subkey_4, t0.type AS type_5, t0.category AS category_6, t0.value AS value_7, t0.title AS title_8, t0.comment AS comment_9, t0.subkeytext AS subkeytext_10 FROM c_course_setting t0 WHERE t0.c_id = 1 AND t0.variable = 'show_course_in_user_language' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.visual_code AS visual_code_4,
  t0.directory AS directory_5,
  t0.course_language AS course_language_6,
  t0.description AS description_7,
  t0.introduction AS introduction_8,
  t0.visibility AS visibility_9,
  t0.show_score AS show_score_10,
  t0.tutor_name AS tutor_name_11,
  t0.department_name AS department_name_12,
  t0.department_url AS department_url_13,
  t0.video_url AS video_url_14,
  t0.sticky AS sticky_15,
  t0.disk_quota AS disk_quota_16,
  t0.last_visit AS last_visit_17,
  t0.last_edit AS last_edit_18,
  t0.creation_date AS creation_date_19,
  t0.expiration_date AS expiration_date_20,
  t0.subscribe AS subscribe_21,
  t0.unsubscribe AS unsubscribe_22,
  t0.registration_code AS registration_code_23,
  t0.legal AS legal_24,
  t0.activate_legal AS activate_legal_25,
  t0.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_26,
  t0.course_type_id AS course_type_id_27,
  t0.duration AS duration_28,
  t0.popularity AS popularity_29,
  t0.resource_node_id AS resource_node_id_30,
  t0.room_id AS room_id_31
FROM
  course t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.visual_code AS visual_code_4, t0.directory AS directory_5, t0.course_language AS course_language_6, t0.description AS description_7, t0.introduction AS introduction_8, t0.visibility AS visibility_9, t0.show_score AS show_score_10, t0.tutor_name AS tutor_name_11, t0.department_name AS department_name_12, t0.department_url AS department_url_13, t0.video_url AS video_url_14, t0.sticky AS sticky_15, t0.disk_quota AS disk_quota_16, t0.last_visit AS last_visit_17, t0.last_edit AS last_edit_18, t0.creation_date AS creation_date_19, t0.expiration_date AS expiration_date_20, t0.subscribe AS subscribe_21, t0.unsubscribe AS unsubscribe_22, t0.registration_code AS registration_code_23, t0.legal AS legal_24, t0.activate_legal AS activate_legal_25, t0.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_26, t0.course_type_id AS course_type_id_27, t0.duration AS duration_28, t0.popularity AS popularity_29, t0.resource_node_id AS resource_node_id_30, t0.room_id AS room_id_31 FROM course t0 WHERE t0.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 = 5 AND r2_.title = 'illustrations' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.code AS code_3,
  t0.visual_code AS visual_code_4,
  t0.directory AS directory_5,
  t0.course_language AS course_language_6,
  t0.description AS description_7,
  t0.introduction AS introduction_8,
  t0.visibility AS visibility_9,
  t0.show_score AS show_score_10,
  t0.tutor_name AS tutor_name_11,
  t0.department_name AS department_name_12,
  t0.department_url AS department_url_13,
  t0.video_url AS video_url_14,
  t0.sticky AS sticky_15,
  t0.disk_quota AS disk_quota_16,
  t0.last_visit AS last_visit_17,
  t0.last_edit AS last_edit_18,
  t0.creation_date AS creation_date_19,
  t0.expiration_date AS expiration_date_20,
  t0.subscribe AS subscribe_21,
  t0.unsubscribe AS unsubscribe_22,
  t0.registration_code AS registration_code_23,
  t0.legal AS legal_24,
  t0.activate_legal AS activate_legal_25,
  t0.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_26,
  t0.course_type_id AS course_type_id_27,
  t0.duration AS duration_28,
  t0.popularity AS popularity_29,
  t0.resource_node_id AS resource_node_id_30,
  t0.room_id AS room_id_31
FROM
  course t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.code AS code_3, t0.visual_code AS visual_code_4, t0.directory AS directory_5, t0.course_language AS course_language_6, t0.description AS description_7, t0.introduction AS introduction_8, t0.visibility AS visibility_9, t0.show_score AS show_score_10, t0.tutor_name AS tutor_name_11, t0.department_name AS department_name_12, t0.department_url AS department_url_13, t0.video_url AS video_url_14, t0.sticky AS sticky_15, t0.disk_quota AS disk_quota_16, t0.last_visit AS last_visit_17, t0.last_edit AS last_edit_18, t0.creation_date AS creation_date_19, t0.expiration_date AS expiration_date_20, t0.subscribe AS subscribe_21, t0.unsubscribe AS unsubscribe_22, t0.registration_code AS registration_code_23, t0.legal AS legal_24, t0.activate_legal AS activate_legal_25, t0.add_teachers_to_sessions_courses AS add_teachers_to_sessions_courses_26, t0.course_type_id AS course_type_id_27, t0.duration AS duration_28, t0.popularity AS popularity_29, t0.resource_node_id AS resource_node_id_30, t0.room_id AS room_id_31 FROM course t0 WHERE t0.code = 'COURSE1' LIMIT 1;

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.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.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
  MIN(a0_.id) AS sclr_0
FROM
  access_url a0_

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