Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = 3 ORDER BY t0.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.content AS content_5,
  t0.slug AS slug_6,
  t0.path AS path_7,
  t0.primary_image AS primary_image_8,
  t0.seo_page_title AS seo_page_title_9,
  t0.seo_description AS seo_description_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.html_head AS html_head_12,
  t0.display_order AS display_order_13,
  t0.parent_id AS parent_id_14,
  t0.project_id AS project_id_15
FROM
  content_pages_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.modified AS modified_3,
  c0_.identifier AS identifier_4,
  c0_.name AS name_5,
  c0_.is_locked AS is_locked_6,
  c0_.disable_child_items AS disable_child_items_7,
  c0_.project_id AS project_id_8
FROM
  content_menus_menu c0_
WHERE
  c0_.identifier = ?
  AND c0_.project_id IS NULL
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = 'primary' AND c0_.project_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.modified AS modified_4,
  t0.label AS label_5,
  t0.url AS url_6,
  t0.auto_update AS auto_update_7,
  t0.open_new_window AS open_new_window_8,
  t0.display_order AS display_order_9,
  t0.type AS type_10,
  t0.menu_id AS menu_id_11,
  t0.page_id AS page_id_12,
  t0.parent_id AS parent_id_13
FROM
  content_menus_menuitem t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = 1 ORDER BY t0.display_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.modified AS modified_3,
  c0_.identifier AS identifier_4,
  c0_.name AS name_5,
  c0_.is_locked AS is_locked_6,
  c0_.disable_child_items AS disable_child_items_7,
  c0_.project_id AS project_id_8
FROM
  content_menus_menu c0_
WHERE
  c0_.identifier = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = 'footer' LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.uuid AS uuid_1,
  d0_.created AS created_2,
  d0_.code_value AS code_value_3,
  d0_.minimum_purchase_quantity AS minimum_purchase_quantity_4,
  d0_.code AS code_5,
  d0_.expiry AS expiry_6,
  d0_.auto_apply AS auto_apply_7,
  d0_.minimum_value AS minimum_value_8,
  d0_.client_id AS client_id_9,
  d0_.course_id AS course_id_10
FROM
  discounts_discount d0_
WHERE
  d0_.auto_apply = ?
  AND d0_.client_id IS NULL

SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.code_value AS code_value_3, d0_.minimum_purchase_quantity AS minimum_purchase_quantity_4, d0_.code AS code_5, d0_.expiry AS expiry_6, d0_.auto_apply AS auto_apply_7, d0_.minimum_value AS minimum_value_8, d0_.client_id AS client_id_9, d0_.course_id AS course_id_10 FROM discounts_discount d0_ WHERE d0_.auto_apply = 1 AND d0_.client_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.`key` AS key_4,
  t0.value AS value_5
FROM
  system_config t0

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.name AS name_3,
  c0_.description AS description_4,
  c0_.code_price AS code_price_5,
  c0_.archived AS archived_6,
  c0_.deleted AS deleted_7,
  c0_.enable_on_shop AS enable_on_shop_8,
  c0_.certificate AS certificate_9,
  c0_.code_expiry_days AS code_expiry_days_10,
  c0_.display_order AS display_order_11,
  c0_.pass_rate AS pass_rate_12,
  c0_.thank_you_page_id AS thank_you_page_id_13,
  c0_.project_id AS project_id_14
FROM
  courses_course c0_
WHERE
  c0_.project_id = ?
  AND c0_.deleted = ?
  AND c0_.archived = ?
  AND c0_.enable_on_shop = ?
ORDER BY
  c0_.display_order ASC

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.description AS description_4, c0_.code_price AS code_price_5, c0_.archived AS archived_6, c0_.deleted AS deleted_7, c0_.enable_on_shop AS enable_on_shop_8, c0_.certificate AS certificate_9, c0_.code_expiry_days AS code_expiry_days_10, c0_.display_order AS display_order_11, c0_.pass_rate AS pass_rate_12, c0_.thank_you_page_id AS thank_you_page_id_13, c0_.project_id AS project_id_14 FROM courses_course c0_ WHERE c0_.project_id = 6 AND c0_.deleted = 0 AND c0_.archived = 0 AND c0_.enable_on_shop = 1 ORDER BY c0_.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.reference AS reference_4,
  t0.primary_email AS primary_email_5,
  t0.hr_email AS hr_email_6,
  t0.name AS name_7,
  t0.type AS type_8,
  t0.phone AS phone_9
FROM
  clients_client t0
  INNER JOIN project_client ON t0.id = project_client.client_id
WHERE
  project_client.project_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.reference AS reference_4, t0.primary_email AS primary_email_5, t0.hr_email AS hr_email_6, t0.name AS name_7, t0.type AS type_8, t0.phone AS phone_9 FROM clients_client t0 INNER JOIN project_client ON t0.id = project_client.client_id WHERE project_client.project_id = 6;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.created AS created_2,
  c0_.time_submitted AS time_submitted_3,
  c0_.submitted AS submitted_4,
  c0_.passed AS passed_5,
  c0_.pass_rate AS pass_rate_6,
  c0_.user_id AS user_id_7,
  c0_.admission_id AS admission_id_8,
  c0_.assessment_id AS assessment_id_9
FROM
  clients_userassessments c0_
WHERE
  c0_.user_id IS NULL
  AND c0_.submitted = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.time_submitted AS time_submitted_3, c0_.submitted AS submitted_4, c0_.passed AS passed_5, c0_.pass_rate AS pass_rate_6, c0_.user_id AS user_id_7, c0_.admission_id AS admission_id_8, c0_.assessment_id AS assessment_id_9 FROM clients_userassessments c0_ WHERE c0_.user_id IS NULL AND c0_.submitted = 0 LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.uuid AS uuid_1,
  p0_.created AS created_2,
  p0_.name AS name_3,
  p0_.domain AS domain_4,
  p0_.logo AS logo_5,
  p0_.publish_on_shop AS publish_on_shop_6,
  p0_.display_order AS display_order_7,
  p0_.code_head AS code_head_8,
  p0_.code_body AS code_body_9
FROM
  projects_project p0_
WHERE
  p0_.uuid = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uuid AS uuid_1, p0_.created AS created_2, p0_.name AS name_3, p0_.domain AS domain_4, p0_.logo AS logo_5, p0_.publish_on_shop AS publish_on_shop_6, p0_.display_order AS display_order_7, p0_.code_head AS code_head_8, p0_.code_body AS code_body_9 FROM projects_project p0_ WHERE p0_.uuid = 'bf3a574e-2752-11ef-a51f-00163e7c8d1a' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created AS created_3,
  t0.name AS name_4,
  t0.domain AS domain_5,
  t0.logo AS logo_6,
  t0.publish_on_shop AS publish_on_shop_7,
  t0.display_order AS display_order_8,
  t0.code_head AS code_head_9,
  t0.code_body AS code_body_10
FROM
  projects_project t0
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.domain AS domain_5, t0.logo AS logo_6, t0.publish_on_shop AS publish_on_shop_7, t0.display_order AS display_order_8, t0.code_head AS code_head_9, t0.code_body AS code_body_10 FROM projects_project t0 WHERE t0.domain = 'srnb.penguin-dev.co.uk' LIMIT 1;