Symfony Profiler

SELECT
  COUNT(*)
FROM
  access_url t0

SELECT COUNT(*) FROM access_url t0;

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.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
  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://rnap.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.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://rnap.beeznest.com/' LIMIT 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,
  t0.value_template_id AS value_template_id_14
FROM
  settings t0
WHERE
  t0.category = ?
  AND t0.access_url = ?

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' AND t0.access_url = 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 = ?
ORDER BY
  l0_.english_name ASC

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 ORDER BY l0_.english_name ASC;

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,
  l0_.parent_id AS parent_id_5
FROM
  language l0_
WHERE
  l0_.isocode = ?
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, l0_.parent_id AS parent_id_5 FROM language l0_ WHERE l0_.isocode = 'fr_FR' LIMIT 1;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  page p0_
  INNER JOIN page_category p1_ ON p0_.category_id = p1_.id
  LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id
  LEFT JOIN user u3_ ON p0_.creator_id = u3_.id
WHERE
  p0_.id IN (
    SELECT
      p4_.id
    FROM
      page p4_
      INNER JOIN page_category p5_ ON p4_.category_id = p5_.id
    WHERE
      p4_.access_url_id = ?
      AND p4_.enabled = 1
      AND p5_.title NOT IN (
        'block-admin-users', 'block-admin-courses',
        'block-admin-sessions', 'block-admin-gradebook',
        'block-admin-skills', 'block-admin-privacy',
        'block-admin-settings', 'block-admin-platform',
        'block-admin-chamilo'
      )
      AND p5_.title IN (?, ?, ?, ?, ?, ?)
      AND p5_.title LIKE CONCAT('%', ?, '%')
      AND p4_.locale = ?
      AND p4_.enabled = ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM page p0_ INNER JOIN page_category p1_ ON p0_.category_id = p1_.id LEFT JOIN access_url a2_ ON p0_.access_url_id = a2_.id LEFT JOIN user u3_ ON p0_.creator_id = u3_.id WHERE p0_.id IN (SELECT p4_.id FROM page p4_ INNER JOIN page_category p5_ ON p4_.category_id = p5_.id WHERE p4_.access_url_id = 1 AND p4_.enabled = 1 AND p5_.title NOT IN ('block-admin-users', 'block-admin-courses', 'block-admin-sessions', 'block-admin-gradebook', 'block-admin-skills', 'block-admin-privacy', 'block-admin-settings', 'block-admin-platform', 'block-admin-chamilo') AND p5_.title IN ('faq', 'demo', 'home', 'public', 'footer_public', 'index') AND p5_.title LIKE CONCAT('%', 'home', '%') AND p4_.locale = 'fr_FR' AND p4_.enabled = 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 = ?
ORDER BY
  l0_.english_name ASC

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 ORDER BY l0_.english_name ASC;

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,
  l0_.parent_id AS parent_id_5
FROM
  language l0_
WHERE
  l0_.isocode = ?
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, l0_.parent_id AS parent_id_5 FROM language l0_ WHERE l0_.isocode = 'fr_FR' LIMIT 1;