Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.can_create AS can_create_1,
  p0_.can_edit AS can_edit_2,
  p0_.can_show AS can_show_3,
  p0_.can_delete AS can_delete_4,
  p0_.can_export AS can_export_5,
  p0_.can_log AS can_log_6,
  p0_.can_run AS can_run_7,
  p0_.can_undo AS can_undo_8,
  p0_.can_data AS can_data_9,
  p0_.can_see_all_entries AS can_see_all_entries_10,
  p0_.permission_entity_id AS permission_entity_id_11,
  p0_.user_id AS user_id_12,
  p0_.user_group_id AS user_group_id_13
FROM
  permission p0_
  INNER JOIN permission_entity p1_ ON (
    p1_.id = p0_.permission_entity_id
  )
WHERE
  p0_.user_group_id = ?
  AND p1_.entity = ?
  AND p1_.permission_entity_id IS NULL

SELECT p0_.id AS id_0, p0_.can_create AS can_create_1, p0_.can_edit AS can_edit_2, p0_.can_show AS can_show_3, p0_.can_delete AS can_delete_4, p0_.can_export AS can_export_5, p0_.can_log AS can_log_6, p0_.can_run AS can_run_7, p0_.can_undo AS can_undo_8, p0_.can_data AS can_data_9, p0_.can_see_all_entries AS can_see_all_entries_10, p0_.permission_entity_id AS permission_entity_id_11, p0_.user_id AS user_id_12, p0_.user_group_id AS user_group_id_13 FROM permission p0_ INNER JOIN permission_entity p1_ ON (p1_.id = p0_.permission_entity_id) WHERE p0_.user_group_id = 1 AND p1_.entity = 'AppBundle\\Entity\\User' AND p1_.permission_entity_id IS NULL;

SELECT
  p0_.id AS id_0,
  p0_.can_create AS can_create_1,
  p0_.can_edit AS can_edit_2,
  p0_.can_show AS can_show_3,
  p0_.can_delete AS can_delete_4,
  p0_.can_export AS can_export_5,
  p0_.can_log AS can_log_6,
  p0_.can_run AS can_run_7,
  p0_.can_undo AS can_undo_8,
  p0_.can_data AS can_data_9,
  p0_.can_see_all_entries AS can_see_all_entries_10,
  p0_.permission_entity_id AS permission_entity_id_11,
  p0_.user_id AS user_id_12,
  p0_.user_group_id AS user_group_id_13
FROM
  permission p0_
  INNER JOIN permission_entity p1_ ON (
    p1_.id = p0_.permission_entity_id
  )
WHERE
  p0_.user_group_id = ?
  AND p1_.entity = ?
  AND p1_.permission_entity_id IS NOT NULL

SELECT p0_.id AS id_0, p0_.can_create AS can_create_1, p0_.can_edit AS can_edit_2, p0_.can_show AS can_show_3, p0_.can_delete AS can_delete_4, p0_.can_export AS can_export_5, p0_.can_log AS can_log_6, p0_.can_run AS can_run_7, p0_.can_undo AS can_undo_8, p0_.can_data AS can_data_9, p0_.can_see_all_entries AS can_see_all_entries_10, p0_.permission_entity_id AS permission_entity_id_11, p0_.user_id AS user_id_12, p0_.user_group_id AS user_group_id_13 FROM permission p0_ INNER JOIN permission_entity p1_ ON (p1_.id = p0_.permission_entity_id) WHERE p0_.user_group_id = 1 AND p1_.entity = 'AppBundle\\Entity\\User' AND p1_.permission_entity_id IS NOT NULL;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.roles AS roles_3,
  t0.intern_name AS intern_name_4
FROM
  fos_user_group t0
  INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id
WHERE
  fos_user_user_group.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.intern_name AS intern_name_4 FROM fos_user_group t0 INNER JOIN fos_user_user_group ON t0.id = fos_user_user_group.group_id WHERE fos_user_user_group.user_id = 61;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pv_id AS pv_id_3,
  t0.pv_active AS pv_active_4,
  t0.intern_name AS intern_name_5,
  t0.jira_department_name AS jira_department_name_6,
  t0.jira_project_key AS jira_project_key_7,
  t0.jira_issue_type AS jira_issue_type_8,
  t0.jira_ticket_lead_id AS jira_ticket_lead_id_9
FROM
  department t0
  INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id
WHERE
  fos_user_user_department.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_user_department ON t0.id = fos_user_user_department.department_id WHERE fos_user_user_department.user_id = 51;

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.property AS property_3,
  t0.permission_entity_id AS permission_entity_id_4
FROM
  permission_entity t0
WHERE
  t0.entity = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.property AS property_3, t0.permission_entity_id AS permission_entity_id_4 FROM permission_entity t0 WHERE t0.entity = 'AppBundle\\Entity\\MetricDashboard' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pv_id AS pv_id_3,
  t0.pv_active AS pv_active_4,
  t0.intern_name AS intern_name_5,
  t0.jira_department_name AS jira_department_name_6,
  t0.jira_project_key AS jira_project_key_7,
  t0.jira_issue_type AS jira_issue_type_8,
  t0.jira_ticket_lead_id AS jira_ticket_lead_id_9
FROM
  department t0
WHERE
  t0.intern_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 WHERE t0.intern_name = 'AI' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.department_id AS department_id_3
FROM
  account_type t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.department_id AS department_id_3 FROM account_type t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pv_id AS pv_id_3,
  t0.pv_active AS pv_active_4,
  t0.jira_project_key AS jira_project_key_5,
  t0.confluence_space_key AS confluence_space_key_6,
  t7.id AS id_8,
  t7.setting AS setting_9,
  t7.value AS value_10,
  t7.area AS area_11,
  t7.customer_id AS customer_id_12,
  t13.id AS id_14,
  t13.target_audience AS target_audience_15,
  t13.type AS type_16,
  t13.backend_url AS backend_url_17,
  t13.username AS username_18,
  t13.password AS password_19,
  t13.created AS created_20,
  t13.updated AS updated_21,
  t13.customer AS customer_22,
  t13.domain AS domain_23,
  t13.description_id AS description_id_24,
  t13.offer_description_id AS offer_description_id_25,
  t13.long_term_goals_id AS long_term_goals_id_26,
  t13.target_audience_description_id AS target_audience_description_id_27,
  t13.cms_system_id AS cms_system_id_28
FROM
  customer t0
  LEFT JOIN custom_setting t7 ON t7.customer_id = t0.id
  LEFT JOIN customer_domain_data t13 ON t13.customer = t0.id
  INNER JOIN fos_user_user_customer ON t0.id = fos_user_user_customer.customer_id
WHERE
  fos_user_user_customer.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.jira_project_key AS jira_project_key_5, t0.confluence_space_key AS confluence_space_key_6, t7.id AS id_8, t7.setting AS setting_9, t7.value AS value_10, t7.area AS area_11, t7.customer_id AS customer_id_12, t13.id AS id_14, t13.target_audience AS target_audience_15, t13.type AS type_16, t13.backend_url AS backend_url_17, t13.username AS username_18, t13.password AS password_19, t13.created AS created_20, t13.updated AS updated_21, t13.customer AS customer_22, t13.domain AS domain_23, t13.description_id AS description_id_24, t13.offer_description_id AS offer_description_id_25, t13.long_term_goals_id AS long_term_goals_id_26, t13.target_audience_description_id AS target_audience_description_id_27, t13.cms_system_id AS cms_system_id_28 FROM customer t0 LEFT JOIN custom_setting t7 ON t7.customer_id = t0.id LEFT JOIN customer_domain_data t13 ON t13.customer = t0.id INNER JOIN fos_user_user_customer ON t0.id = fos_user_user_customer.customer_id WHERE fos_user_user_customer.user_id = 61;

SELECT
  t0.id AS id_1,
  t0.setting AS setting_2,
  t0.value AS value_3,
  t0.area AS area_4,
  t0.customer_id AS customer_id_5
FROM
  custom_setting t0
WHERE
  t0.setting = ?
  AND t0.customer_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.area AS area_4, t0.customer_id AS customer_id_5 FROM custom_setting t0 WHERE t0.setting = 'customTool' AND t0.customer_id IS NULL LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.username AS username_1,
  f0_.username_canonical AS username_canonical_2,
  f0_.email AS email_3,
  f0_.enabled AS enabled_4,
  f0_.salt AS salt_5,
  f0_.email_canonical AS email_canonical_6,
  f0_.password AS password_7,
  f0_.last_login AS last_login_8,
  f0_.confirmation_token AS confirmation_token_9,
  f0_.password_requested_at AS password_requested_at_10,
  f0_.roles AS roles_11,
  f0_.created_at AS created_at_12,
  f0_.updated_at AS updated_at_13,
  f0_.firstname AS firstname_14,
  f0_.lastname AS lastname_15,
  f0_.name AS name_16,
  f0_.jira_account_id AS jira_account_id_17,
  f0_.pv_id AS pv_id_18,
  f0_.pv_active AS pv_active_19,
  f0_.confirmation_first_login_token AS confirmation_first_login_token_20,
  f0_.user_type AS user_type_21,
  f0_.assigned_customer_user_id AS assigned_customer_user_id_22
FROM
  fos_user_user f0_
ORDER BY
  f0_.id ASC
LIMIT
  25
OFFSET
  50

SELECT f0_.id AS id_0, f0_.username AS username_1, f0_.username_canonical AS username_canonical_2, f0_.email AS email_3, f0_.enabled AS enabled_4, f0_.salt AS salt_5, f0_.email_canonical AS email_canonical_6, f0_.password AS password_7, f0_.last_login AS last_login_8, f0_.confirmation_token AS confirmation_token_9, f0_.password_requested_at AS password_requested_at_10, f0_.roles AS roles_11, f0_.created_at AS created_at_12, f0_.updated_at AS updated_at_13, f0_.firstname AS firstname_14, f0_.lastname AS lastname_15, f0_.name AS name_16, f0_.jira_account_id AS jira_account_id_17, f0_.pv_id AS pv_id_18, f0_.pv_active AS pv_active_19, f0_.confirmation_first_login_token AS confirmation_first_login_token_20, f0_.user_type AS user_type_21, f0_.assigned_customer_user_id AS assigned_customer_user_id_22 FROM fos_user_user f0_ ORDER BY f0_.id ASC LIMIT 25 OFFSET 50;

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.roles AS roles_2,
  f0_.intern_name AS intern_name_3
FROM
  fos_user_group f0_

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.roles AS roles_2, f0_.intern_name AS intern_name_3 FROM fos_user_group f0_;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.email_canonical AS email_canonical_7,
  t0.password AS password_8,
  t0.last_login AS last_login_9,
  t0.confirmation_token AS confirmation_token_10,
  t0.password_requested_at AS password_requested_at_11,
  t0.roles AS roles_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.firstname AS firstname_15,
  t0.lastname AS lastname_16,
  t0.name AS name_17,
  t0.jira_account_id AS jira_account_id_18,
  t0.pv_id AS pv_id_19,
  t0.pv_active AS pv_active_20,
  t0.confirmation_first_login_token AS confirmation_first_login_token_21,
  t0.user_type AS user_type_22,
  t0.assigned_customer_user_id AS assigned_customer_user_id_23
FROM
  fos_user_user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.email_canonical AS email_canonical_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.roles AS roles_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.firstname AS firstname_15, t0.lastname AS lastname_16, t0.name AS name_17, t0.jira_account_id AS jira_account_id_18, t0.pv_id AS pv_id_19, t0.pv_active AS pv_active_20, t0.confirmation_first_login_token AS confirmation_first_login_token_21, t0.user_type AS user_type_22, t0.assigned_customer_user_id AS assigned_customer_user_id_23 FROM fos_user_user t0 WHERE t0.id = 61 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.module AS module_1,
  c0_.description AS description_2,
  c0_.current_version AS current_version_3,
  c0_.new_version AS new_version_4
FROM
  composer_version c0_
WHERE
  c0_.new_version <> c0_.current_version

SELECT c0_.id AS id_0, c0_.module AS module_1, c0_.description AS description_2, c0_.current_version AS current_version_3, c0_.new_version AS new_version_4 FROM composer_version c0_ WHERE c0_.new_version <> c0_.current_version;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.pv_id AS pv_id_3,
  t0.pv_active AS pv_active_4,
  t0.intern_name AS intern_name_5,
  t0.jira_department_name AS jira_department_name_6,
  t0.jira_project_key AS jira_project_key_7,
  t0.jira_issue_type AS jira_issue_type_8,
  t0.jira_ticket_lead_id AS jira_ticket_lead_id_9
FROM
  department t0
  INNER JOIN fos_user_group_department ON t0.id = fos_user_group_department.department_id
WHERE
  fos_user_group_department.group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.pv_id AS pv_id_3, t0.pv_active AS pv_active_4, t0.intern_name AS intern_name_5, t0.jira_department_name AS jira_department_name_6, t0.jira_project_key AS jira_project_key_7, t0.jira_issue_type AS jira_issue_type_8, t0.jira_ticket_lead_id AS jira_ticket_lead_id_9 FROM department t0 INNER JOIN fos_user_group_department ON t0.id = fos_user_group_department.department_id WHERE fos_user_group_department.group_id = 1;

SELECT
  count(f0_.id) AS sclr_0
FROM
  fos_user_user f0_

SELECT count(f0_.id) AS sclr_0 FROM fos_user_user f0_;