Symfony Profiler

SELECT
  d0_.cat_id AS cat_id_0,
  d0_.cat_name AS cat_name_1,
  d0_.cat_letter AS cat_letter_2,
  d0_.bg_image AS bg_image_3,
  d0_.bg_style AS bg_style_4,
  d1_.kpi_id AS kpi_id_5,
  d1_.kpi_status AS kpi_status_6,
  d1_.kpi_name AS kpi_name_7,
  d1_.visbility AS visbility_8,
  d1_.kpi_type AS kpi_type_9,
  d1_.kpi_formula AS kpi_formula_10,
  d1_.takt_based AS takt_based_11,
  d1_.is_default AS is_default_12,
  d2_.uk_id AS uk_id_13,
  d1_.kpi_no_data_after_decimal_space AS kpi_no_data_after_decimal_space_14,
  d1_.kpi_data_type AS kpi_data_type_15,
  d1_.planning_module_kpi AS planning_module_kpi_16,
  d1_.lower_threshold AS lower_threshold_17,
  d1_.upper_threshold AS upper_threshold_18,
  d1_.lt_upper_color AS lt_upper_color_19,
  d1_.lt_lower_color AS lt_lower_color_20,
  d1_.ut_upper_color AS ut_upper_color_21,
  d1_.ut_lower_color AS ut_lower_color_22,
  d1_.kpi_uof AS kpi_uof_23,
  d1_.kpi_direction AS kpi_direction_24
FROM
  dp_kpi d1_
  LEFT JOIN dp_oput_kpi_assign d2_ ON (d2_.uk_kpi_id = d1_.kpi_id)
  LEFT JOIN dp_category d0_ ON (d0_.cat_id = d1_.kpi_category)
WHERE
  d2_.uk_status = ?
  AND d1_.kpi_status = ?
  AND d2_.uk_oput_id IN (NULL)
  AND d1_.kpi_data_type = ?
ORDER BY
  d0_.cat_order ASC

SELECT d0_.cat_id AS cat_id_0, d0_.cat_name AS cat_name_1, d0_.cat_letter AS cat_letter_2, d0_.bg_image AS bg_image_3, d0_.bg_style AS bg_style_4, d1_.kpi_id AS kpi_id_5, d1_.kpi_status AS kpi_status_6, d1_.kpi_name AS kpi_name_7, d1_.visbility AS visbility_8, d1_.kpi_type AS kpi_type_9, d1_.kpi_formula AS kpi_formula_10, d1_.takt_based AS takt_based_11, d1_.is_default AS is_default_12, d2_.uk_id AS uk_id_13, d1_.kpi_no_data_after_decimal_space AS kpi_no_data_after_decimal_space_14, d1_.kpi_data_type AS kpi_data_type_15, d1_.planning_module_kpi AS planning_module_kpi_16, d1_.lower_threshold AS lower_threshold_17, d1_.upper_threshold AS upper_threshold_18, d1_.lt_upper_color AS lt_upper_color_19, d1_.lt_lower_color AS lt_lower_color_20, d1_.ut_upper_color AS ut_upper_color_21, d1_.ut_lower_color AS ut_lower_color_22, d1_.kpi_uof AS kpi_uof_23, d1_.kpi_direction AS kpi_direction_24 FROM dp_kpi d1_ LEFT JOIN dp_oput_kpi_assign d2_ ON (d2_.uk_kpi_id = d1_.kpi_id) LEFT JOIN dp_category d0_ ON (d0_.cat_id = d1_.kpi_category) WHERE d2_.uk_status = 'enabled' AND d1_.kpi_status = 'enabled' AND d2_.uk_oput_id IN (NULL) AND d1_.kpi_data_type = 'day' ORDER BY d0_.cat_order ASC;

SELECT
  d0_.op_ut_id AS op_ut_id_0,
  d0_.op_ut_name AS op_ut_name_1,
  d1_.op_type_name AS op_type_name_2,
  d1_.op_type_id AS op_type_id_3,
  d0_.time AS time_4,
  d2_.level_name AS level_name_5,
  d2_.level_id AS level_id_6
FROM
  dp_operational_unit d0_
  LEFT JOIN dp_level_op_ut_relation d3_ ON (d3_.lu_op_ut_id = d0_.op_ut_id)
  LEFT JOIN dp_operational_unit_type d1_ ON (d1_.op_type_id = d0_.op_ut_type)
  LEFT JOIN dp_levels d2_ ON (d2_.level_id = d3_.lu_level_id)
WHERE
  d0_.op_ut_status = ?
  AND d3_.lu_level_id = ?
GROUP BY
  d0_.op_ut_id
ORDER BY
  d0_.op_ut_name ASC

SELECT d0_.op_ut_id AS op_ut_id_0, d0_.op_ut_name AS op_ut_name_1, d1_.op_type_name AS op_type_name_2, d1_.op_type_id AS op_type_id_3, d0_.time AS time_4, d2_.level_name AS level_name_5, d2_.level_id AS level_id_6 FROM dp_operational_unit d0_ LEFT JOIN dp_level_op_ut_relation d3_ ON (d3_.lu_op_ut_id = d0_.op_ut_id) LEFT JOIN dp_operational_unit_type d1_ ON (d1_.op_type_id = d0_.op_ut_type) LEFT JOIN dp_levels d2_ ON (d2_.level_id = d3_.lu_level_id) WHERE d0_.op_ut_status = 'enabled' AND d3_.lu_level_id = '23' GROUP BY d0_.op_ut_id ORDER BY d0_.op_ut_name ASC;

SELECT
  d0_.data_shift_id AS sclr_0,
  d0_.data_id AS data_id_1,
  d0_.data_type AS data_type_2,
  d0_.data_date AS data_date_3,
  DATE(
    CONVERT_TZ(d0_.data_date, ?, ?)
  ) AS sclr_4,
  d1_.uk_kpi_id AS sclr_5,
  d2_.op_ut_id AS op_ut_id_6,
  CONCAT(
    d1_.uk_kpi_id,
    '-',
    DATE(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    d0_.data_type
  ) AS sclr_7,
  CONCAT(
    d1_.uk_kpi_id,
    '-',
    YEAR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    d0_.data_type
  ) AS sclr_8,
  CONCAT(
    d1_.uk_kpi_id,
    '-',
    DATE(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    HOUR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    d0_.data_type
  ) AS sclr_9,
  CONCAT(
    d1_.uk_kpi_id,
    '-',
    YEAR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    WEEK(
      CONVERT_TZ(d0_.data_date, ?, ?),
      4
    ),
    '-',
    d0_.data_type
  ) AS sclr_10,
  CONCAT(
    d1_.uk_kpi_id,
    '-',
    YEAR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    MONTH(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    d0_.data_type
  ) AS sclr_11,
  DATE(
    CONVERT_TZ(d0_.data_date, ?, ?)
  ) AS sclr_12,
  CONCAT(
    DATE(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    HOUR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    )
  ) AS sclr_13,
  CONCAT(
    YEAR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    WEEK(
      CONVERT_TZ(d0_.data_date, ?, ?),
      4
    )
  ) AS sclr_14,
  CONCAT(
    YEAR(
      CONVERT_TZ(d0_.data_date, ?, ?)
    ),
    '-',
    MONTH(
      CONVERT_TZ(d0_.data_date, ?, ?)
    )
  ) AS sclr_15,
  YEAR(
    CONVERT_TZ(d0_.data_date, ?, ?)
  ) AS sclr_16,
  SUM(d0_.data_value) AS sclr_17,
  COUNT(d0_.data_value) AS sclr_18
FROM
  dp_data d0_
  LEFT JOIN dp_oput_kpi_assign d1_ ON (d1_.uk_id = d0_.data_uk_id)
  LEFT JOIN dp_operational_unit d2_ ON (d2_.op_ut_id = d1_.uk_oput_id)
WHERE
  d1_.uk_status = ?
  AND d2_.op_ut_status = ?
  AND TRIM(d0_.data_value) <> ?
  AND d2_.op_ut_id IN (NULL)
  AND d1_.uk_kpi_id IN (?, ?, ?, ?, ?, ?, ?)
  AND (
    d0_.data_date BETWEEN ?
    AND ?
  )
GROUP BY
  sclr_7

SELECT d0_.data_shift_id AS sclr_0, d0_.data_id AS data_id_1, d0_.data_type AS data_type_2, d0_.data_date AS data_date_3, DATE(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')) AS sclr_4, d1_.uk_kpi_id AS sclr_5, d2_.op_ut_id AS op_ut_id_6, CONCAT(d1_.uk_kpi_id, '-', DATE(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', d0_.data_type) AS sclr_7, CONCAT(d1_.uk_kpi_id, '-', YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', d0_.data_type) AS sclr_8, CONCAT(d1_.uk_kpi_id, '-', DATE(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', HOUR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', d0_.data_type) AS sclr_9, CONCAT(d1_.uk_kpi_id, '-', YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', WEEK(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London'), 4), '-', d0_.data_type) AS sclr_10, CONCAT(d1_.uk_kpi_id, '-', YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', MONTH(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', d0_.data_type) AS sclr_11, DATE(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')) AS sclr_12, CONCAT(DATE(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', HOUR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London'))) AS sclr_13, CONCAT(YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', WEEK(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London'), 4)) AS sclr_14, CONCAT(YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')), '-', MONTH(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London'))) AS sclr_15, YEAR(CONVERT_TZ(d0_.data_date, 'UTC', 'Europe/London')) AS sclr_16, SUM(d0_.data_value) AS sclr_17, COUNT(d0_.data_value) AS sclr_18 FROM dp_data d0_ LEFT JOIN dp_oput_kpi_assign d1_ ON (d1_.uk_id = d0_.data_uk_id) LEFT JOIN dp_operational_unit d2_ ON (d2_.op_ut_id = d1_.uk_oput_id) WHERE d1_.uk_status = 'enabled' AND d2_.op_ut_status = 'enabled' AND TRIM(d0_.data_value) <> '' AND d2_.op_ut_id IN (NULL) AND d1_.uk_kpi_id IN (2, 10, 11, 18, 19, 21, 22) AND (d0_.data_date BETWEEN '2025-01-01 00:00:00' AND '2025-01-31 23:59:59') GROUP BY sclr_7;

SELECT
  d0_.kpi_id AS kpi_id_0,
  d0_.kpi_name AS kpi_name_1,
  d0_.visbility AS visbility_2,
  d0_.kpi_type AS kpi_type_3,
  d0_.kpi_formula AS kpi_formula_4,
  d0_.kpi_entry_type AS kpi_entry_type_5,
  d0_.kpi_direction AS kpi_direction_6,
  d0_.takt_based AS takt_based_7,
  d0_.kpi_status AS kpi_status_8,
  d0_.kpi_no_data_after_decimal_space AS kpi_no_data_after_decimal_space_9,
  d0_.kpi_data_type AS kpi_data_type_10,
  d0_.kpi_uof AS kpi_uof_11,
  d1_.icon_link AS icon_link_12,
  d2_.cat_name AS cat_name_13,
  d0_.lower_threshold AS lower_threshold_14,
  d0_.upper_threshold AS upper_threshold_15,
  d0_.lt_upper_color AS lt_upper_color_16,
  d0_.lt_lower_color AS lt_lower_color_17,
  d0_.ut_upper_color AS ut_upper_color_18,
  d0_.ut_lower_color AS ut_lower_color_19,
  CONCAT('kpi_', '', d0_.kpi_id) AS sclr_20
FROM
  dp_kpi d0_
  LEFT JOIN dp_icons d1_ ON (d1_.icon_id = d0_.kpi_icon)
  LEFT JOIN dp_category d2_ ON (d2_.cat_id = d0_.kpi_category)
WHERE
  d0_.kpi_status <> ?
  AND d0_.kpi_data_type = ?

SELECT d0_.kpi_id AS kpi_id_0, d0_.kpi_name AS kpi_name_1, d0_.visbility AS visbility_2, d0_.kpi_type AS kpi_type_3, d0_.kpi_formula AS kpi_formula_4, d0_.kpi_entry_type AS kpi_entry_type_5, d0_.kpi_direction AS kpi_direction_6, d0_.takt_based AS takt_based_7, d0_.kpi_status AS kpi_status_8, d0_.kpi_no_data_after_decimal_space AS kpi_no_data_after_decimal_space_9, d0_.kpi_data_type AS kpi_data_type_10, d0_.kpi_uof AS kpi_uof_11, d1_.icon_link AS icon_link_12, d2_.cat_name AS cat_name_13, d0_.lower_threshold AS lower_threshold_14, d0_.upper_threshold AS upper_threshold_15, d0_.lt_upper_color AS lt_upper_color_16, d0_.lt_lower_color AS lt_lower_color_17, d0_.ut_upper_color AS ut_upper_color_18, d0_.ut_lower_color AS ut_lower_color_19, CONCAT('kpi_', '', d0_.kpi_id) AS sclr_20 FROM dp_kpi d0_ LEFT JOIN dp_icons d1_ ON (d1_.icon_id = d0_.kpi_icon) LEFT JOIN dp_category d2_ ON (d2_.cat_id = d0_.kpi_category) WHERE d0_.kpi_status <> 'deleted' AND d0_.kpi_data_type = 'day';

SELECT
  d0_.ap_id AS ap_id_0,
  d0_.ap_kpi AS sclr_1,
  d1_.cat_id AS cat_id_2,
  d0_.ap_status AS ap_status_3,
  DATE(d0_.ap_due_date) AS sclr_4,
  d2_.assigned_to AS sclr_5,
  d2_.ap_3c_type AS ap_3c_type_6,
  d0_.ap_shift AS sclr_7
FROM
  dp_action_plan d0_
  LEFT JOIN dp_kpi d3_ ON (d3_.kpi_id = d0_.ap_kpi)
  LEFT JOIN dp_category d1_ ON (d1_.cat_id = d3_.kpi_category)
  LEFT JOIN dp_action_plan_assign d2_ ON (d2_.ap_id = d0_.ap_id)
WHERE
  d3_.kpi_status <> ?
  AND d1_.cat_status <> ?
  AND d0_.ap_status <> ?
  AND d0_.ap_level = ?
GROUP BY
  d0_.ap_id

SELECT d0_.ap_id AS ap_id_0, d0_.ap_kpi AS sclr_1, d1_.cat_id AS cat_id_2, d0_.ap_status AS ap_status_3, DATE(d0_.ap_due_date) AS sclr_4, d2_.assigned_to AS sclr_5, d2_.ap_3c_type AS ap_3c_type_6, d0_.ap_shift AS sclr_7 FROM dp_action_plan d0_ LEFT JOIN dp_kpi d3_ ON (d3_.kpi_id = d0_.ap_kpi) LEFT JOIN dp_category d1_ ON (d1_.cat_id = d3_.kpi_category) LEFT JOIN dp_action_plan_assign d2_ ON (d2_.ap_id = d0_.ap_id) WHERE d3_.kpi_status <> 'deleted' AND d1_.cat_status <> 'deleted' AND d0_.ap_status <> 'deleted' AND d0_.ap_level = '23' GROUP BY d0_.ap_id;

SELECT
  d0_.id AS id_0,
  d0_.tier_id AS sclr_1,
  d0_.kpi_id AS sclr_2,
  d0_.level_id AS sclr_3,
  d0_.oput_id AS sclr_4,
  d1_.lower_threshold AS lower_threshold_5,
  d1_.upper_threshold AS upper_threshold_6,
  d1_.lt_lower_color AS lt_lower_color_7,
  d1_.lt_upper_color AS lt_upper_color_8,
  d1_.ut_lower_color AS ut_lower_color_9,
  d1_.ut_upper_color AS ut_upper_color_10,
  CASE WHEN d0_.oput_id <> 'null' THEN
    CONCAT(
      'kpi-', d0_.kpi_id, '-oput-', d0_.oput_id
    )
  WHEN d0_.level_id <> 'null' THEN
    CONCAT(
      'kpi-', d0_.kpi_id, '-level-', d0_.level_id
    )
  WHEN d0_.tier_id <> 'null' THEN
    CONCAT(
      'kpi-', d0_.kpi_id, '-tier-', d0_.tier_id
    )
  ELSE
    CONCAT('kpi-', d0_.kpi_id, '-', '-')
  END AS sclr_11
FROM
  dp_rules d0_
  LEFT JOIN dp_rule_conditions d1_ ON (d1_.rule_id = d0_.id)
WHERE
  d0_.level_id = ?

SELECT d0_.id AS id_0, d0_.tier_id AS sclr_1, d0_.kpi_id AS sclr_2, d0_.level_id AS sclr_3, d0_.oput_id AS sclr_4, d1_.lower_threshold AS lower_threshold_5, d1_.upper_threshold AS upper_threshold_6, d1_.lt_lower_color AS lt_lower_color_7, d1_.lt_upper_color AS lt_upper_color_8, d1_.ut_lower_color AS ut_lower_color_9, d1_.ut_upper_color AS ut_upper_color_10, CASE WHEN d0_.oput_id <> 'null' THEN CONCAT('kpi-', d0_.kpi_id, '-oput-', d0_.oput_id) WHEN d0_.level_id <> 'null' THEN CONCAT('kpi-', d0_.kpi_id, '-level-', d0_.level_id) WHEN d0_.tier_id <> 'null' THEN CONCAT('kpi-', d0_.kpi_id, '-tier-', d0_.tier_id) ELSE CONCAT('kpi-', d0_.kpi_id, '-', '-') END AS sclr_11 FROM dp_rules d0_ LEFT JOIN dp_rule_conditions d1_ ON (d1_.rule_id = d0_.id) WHERE d0_.level_id = '23';

SELECT
  c0_.id AS id_0
FROM
  company_tier c0_
WHERE
  c0_.tier_type IN (?, ?)

SELECT c0_.id AS id_0 FROM company_tier c0_ WHERE c0_.tier_type IN ('operator', 'line');

SELECT
  d0_.id AS id_0,
  d0_.holiday_name AS holiday_name_1,
  DATE(d0_.holiday_date) AS sclr_2
FROM
  dp_public_holidays d0_
ORDER BY
  d0_.holiday_date ASC

SELECT d0_.id AS id_0, d0_.holiday_name AS holiday_name_1, DATE(d0_.holiday_date) AS sclr_2 FROM dp_public_holidays d0_ ORDER BY d0_.holiday_date ASC;

SELECT
  t0.id AS id_1,
  t0.admin_id AS admin_id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.is_verified AS is_verified_6,
  t0.main_admin AS main_admin_7,
  t0.super_admin AS super_admin_8,
  t0.is_active AS is_active_9,
  t0.is_deleted AS is_deleted_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.user_group_id AS user_group_id_14,
  t0.user_type AS user_type_15,
  t0.deleted_by AS deleted_by_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.admin_id AS admin_id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_verified AS is_verified_6, t0.main_admin AS main_admin_7, t0.super_admin AS super_admin_8, t0.is_active AS is_active_9, t0.is_deleted AS is_deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.user_group_id AS user_group_id_14, t0.user_type AS user_type_15, t0.deleted_by AS deleted_by_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18 FROM user t0 WHERE t0.id = 1;

SELECT
  d0_.tl_dashboard AS tl_dashboard_0,
  d0_.kpi_dashboard AS kpi_dashboard_1,
  d0_.score_card AS score_card_2,
  d0_.one_minute_manager AS one_minute_manager_3,
  d0_.quad_chart AS quad_chart_4
FROM
  dp_preferences d0_
  LEFT JOIN user u1_ ON (u1_.id = d0_.user_id)
WHERE
  u1_.is_deleted = ?
  AND d0_.user_id = ?
LIMIT
  1

SELECT d0_.tl_dashboard AS tl_dashboard_0, d0_.kpi_dashboard AS kpi_dashboard_1, d0_.score_card AS score_card_2, d0_.one_minute_manager AS one_minute_manager_3, d0_.quad_chart AS quad_chart_4 FROM dp_preferences d0_ LEFT JOIN user u1_ ON (u1_.id = d0_.user_id) WHERE u1_.is_deleted = 0 AND d0_.user_id = 1 LIMIT 1;

SELECT
  d0_.cat_id AS cat_id_0,
  d0_.cat_name AS cat_name_1,
  d0_.cat_letter AS cat_letter_2
FROM
  dp_category d0_
WHERE
  d0_.cat_status = ?
ORDER BY
  d0_.cat_order ASC

SELECT d0_.cat_id AS cat_id_0, d0_.cat_name AS cat_name_1, d0_.cat_letter AS cat_letter_2 FROM dp_category d0_ WHERE d0_.cat_status = 'enabled' ORDER BY d0_.cat_order ASC;