Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 3
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.status AS status_3, i0_.severity AS severity_4, i0_.impact AS impact_5, i0_.detected_at AS detected_at_6, i0_.acknowledged_at AS acknowledged_at_7, i0_.resolved_at AS resolved_at_8, i0_.assigned_team AS assigned_team_9, i0_.assigned_user AS assigned_user_10, i0_.root_cause AS root_cause_11, i0_.resolution_summary AS resolution_summary_12, i0_.metadata AS metadata_13, i0_.incident_scope AS incident_scope_14, i0_.created_at AS created_at_15, i0_.updated_at AS updated_at_16, c1_.id AS id_17, c1_.name AS name_18, c1_.component_type AS component_type_19, c1_.status AS status_20, c1_.severity AS severity_21, c1_.criticality AS criticality_22, c1_.endpoint AS endpoint_23, c1_.external_id AS external_id_24, c1_.responsible_team AS responsible_team_25, c1_.is_active AS is_active_26, c1_.last_check_at AS last_check_at_27, c1_.first_failure_at AS first_failure_at_28, c1_.first_recovery_at AS first_recovery_at_29, c1_.metadata AS metadata_30, c1_.created_at AS created_at_31, c1_.updated_at AS updated_at_32, p2_.id AS id_33, p2_.name AS name_34, p2_.slug AS slug_35, p2_.environment AS environment_36, p2_.product_type AS product_type_37, p2_.base_url AS base_url_38, p2_.status AS status_39, p2_.severity AS severity_40, p2_.health_score AS health_score_41, p2_.is_active AS is_active_42, p2_.last_check_at AS last_check_at_43, p2_.metadata AS metadata_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, c3_.id AS id_47, c3_.name AS name_48, c3_.slug AS slug_49, c3_.owner_team AS owner_team_50, c3_.account_manager AS account_manager_51, c3_.support_level AS support_level_52, c3_.sla_availability AS sla_availability_53, c3_.is_active AS is_active_54, c3_.metadata AS metadata_55, c3_.created_at AS created_at_56, c3_.updated_at AS updated_at_57, i0_.client_id AS client_id_58, i0_.platform_id AS platform_id_59, i0_.component_id AS component_id_60, c1_.platform_id AS platform_id_61, p2_.client_id AS client_id_62 FROM incidents i0_ LEFT JOIN components c1_ ON i0_.component_id = c1_.id LEFT JOIN platforms p2_ ON i0_.platform_id = p2_.id LEFT JOIN clients c3_ ON i0_.client_id = c3_.id LEFT JOIN incident_diagnostics i4_ ON i0_.id = i4_.incident_id WHERE i0_.status IN (?, ?, ?, ?, ?) AND i4_.id IS NULL AND (c1_.external_id = ? OR LOWER(c1_.name) LIKE ? OR LOWER(c1_.endpoint) LIKE ? OR LOWER(p2_.name) LIKE ? OR LOWER(c1_.name) LIKE ? OR LOWER(c1_.endpoint) LIKE ? OR LOWER(p2_.name) LIKE ?) ORDER BY i0_.detected_at ASC LIMIT 1

[
  "open"
  "acknowledged"
  "investigating"
  "identified"
  "mitigated"
  "i-0f84f1f7fd7073dcd"
  "%camprodon-srv.tridenia.es%"
  "%camprodon-srv.tridenia.es%"
  "%camprodon-srv.tridenia.es%"
  "%camprodon-srv%"
  "%camprodon-srv%"
  "%camprodon-srv%"
]

SELECT
  i0_.id AS id_0,
  i0_.title AS title_1,
  i0_.description AS description_2,
  i0_.status AS status_3,
  i0_.severity AS severity_4,
  i0_.impact AS impact_5,
  i0_.detected_at AS detected_at_6,
  i0_.acknowledged_at AS acknowledged_at_7,
  i0_.resolved_at AS resolved_at_8,
  i0_.assigned_team AS assigned_team_9,
  i0_.assigned_user AS assigned_user_10,
  i0_.root_cause AS root_cause_11,
  i0_.resolution_summary AS resolution_summary_12,
  i0_.metadata AS metadata_13,
  i0_.incident_scope AS incident_scope_14,
  i0_.created_at AS created_at_15,
  i0_.updated_at AS updated_at_16,
  c1_.id AS id_17,
  c1_.name AS name_18,
  c1_.component_type AS component_type_19,
  c1_.status AS status_20,
  c1_.severity AS severity_21,
  c1_.criticality AS criticality_22,
  c1_.endpoint AS endpoint_23,
  c1_.external_id AS external_id_24,
  c1_.responsible_team AS responsible_team_25,
  c1_.is_active AS is_active_26,
  c1_.last_check_at AS last_check_at_27,
  c1_.first_failure_at AS first_failure_at_28,
  c1_.first_recovery_at AS first_recovery_at_29,
  c1_.metadata AS metadata_30,
  c1_.created_at AS created_at_31,
  c1_.updated_at AS updated_at_32,
  p2_.id AS id_33,
  p2_.name AS name_34,
  p2_.slug AS slug_35,
  p2_.environment AS environment_36,
  p2_.product_type AS product_type_37,
  p2_.base_url AS base_url_38,
  p2_.status AS status_39,
  p2_.severity AS severity_40,
  p2_.health_score AS health_score_41,
  p2_.is_active AS is_active_42,
  p2_.last_check_at AS last_check_at_43,
  p2_.metadata AS metadata_44,
  p2_.created_at AS created_at_45,
  p2_.updated_at AS updated_at_46,
  c3_.id AS id_47,
  c3_.name AS name_48,
  c3_.slug AS slug_49,
  c3_.owner_team AS owner_team_50,
  c3_.account_manager AS account_manager_51,
  c3_.support_level AS support_level_52,
  c3_.sla_availability AS sla_availability_53,
  c3_.is_active AS is_active_54,
  c3_.metadata AS metadata_55,
  c3_.created_at AS created_at_56,
  c3_.updated_at AS updated_at_57,
  i0_.client_id AS client_id_58,
  i0_.platform_id AS platform_id_59,
  i0_.component_id AS component_id_60,
  c1_.platform_id AS platform_id_61,
  p2_.client_id AS client_id_62
FROM
  incidents i0_
  LEFT JOIN components c1_ ON i0_.component_id = c1_.id
  LEFT JOIN platforms p2_ ON i0_.platform_id = p2_.id
  LEFT JOIN clients c3_ ON i0_.client_id = c3_.id
  LEFT JOIN incident_diagnostics i4_ ON i0_.id = i4_.incident_id
WHERE
  i0_.status IN (?, ?, ?, ?, ?)
  AND i4_.id IS NULL
  AND (
    c1_.external_id = ?
    OR LOWER(c1_.name) LIKE ?
    OR LOWER(c1_.endpoint) LIKE ?
    OR LOWER(p2_.name) LIKE ?
    OR LOWER(c1_.name) LIKE ?
    OR LOWER(c1_.endpoint) LIKE ?
    OR LOWER(p2_.name) LIKE ?
  )
ORDER BY
  i0_.detected_at ASC
LIMIT
  1

SELECT i0_.id AS id_0, i0_.title AS title_1, i0_.description AS description_2, i0_.status AS status_3, i0_.severity AS severity_4, i0_.impact AS impact_5, i0_.detected_at AS detected_at_6, i0_.acknowledged_at AS acknowledged_at_7, i0_.resolved_at AS resolved_at_8, i0_.assigned_team AS assigned_team_9, i0_.assigned_user AS assigned_user_10, i0_.root_cause AS root_cause_11, i0_.resolution_summary AS resolution_summary_12, i0_.metadata AS metadata_13, i0_.incident_scope AS incident_scope_14, i0_.created_at AS created_at_15, i0_.updated_at AS updated_at_16, c1_.id AS id_17, c1_.name AS name_18, c1_.component_type AS component_type_19, c1_.status AS status_20, c1_.severity AS severity_21, c1_.criticality AS criticality_22, c1_.endpoint AS endpoint_23, c1_.external_id AS external_id_24, c1_.responsible_team AS responsible_team_25, c1_.is_active AS is_active_26, c1_.last_check_at AS last_check_at_27, c1_.first_failure_at AS first_failure_at_28, c1_.first_recovery_at AS first_recovery_at_29, c1_.metadata AS metadata_30, c1_.created_at AS created_at_31, c1_.updated_at AS updated_at_32, p2_.id AS id_33, p2_.name AS name_34, p2_.slug AS slug_35, p2_.environment AS environment_36, p2_.product_type AS product_type_37, p2_.base_url AS base_url_38, p2_.status AS status_39, p2_.severity AS severity_40, p2_.health_score AS health_score_41, p2_.is_active AS is_active_42, p2_.last_check_at AS last_check_at_43, p2_.metadata AS metadata_44, p2_.created_at AS created_at_45, p2_.updated_at AS updated_at_46, c3_.id AS id_47, c3_.name AS name_48, c3_.slug AS slug_49, c3_.owner_team AS owner_team_50, c3_.account_manager AS account_manager_51, c3_.support_level AS support_level_52, c3_.sla_availability AS sla_availability_53, c3_.is_active AS is_active_54, c3_.metadata AS metadata_55, c3_.created_at AS created_at_56, c3_.updated_at AS updated_at_57, i0_.client_id AS client_id_58, i0_.platform_id AS platform_id_59, i0_.component_id AS component_id_60, c1_.platform_id AS platform_id_61, p2_.client_id AS client_id_62 FROM incidents i0_ LEFT JOIN components c1_ ON i0_.component_id = c1_.id LEFT JOIN platforms p2_ ON i0_.platform_id = p2_.id LEFT JOIN clients c3_ ON i0_.client_id = c3_.id LEFT JOIN incident_diagnostics i4_ ON i0_.id = i4_.incident_id WHERE i0_.status IN ('open', 'acknowledged', 'investigating', 'identified', 'mitigated') AND i4_.id IS NULL AND (c1_.external_id = 'i-0f84f1f7fd7073dcd' OR LOWER(c1_.name) LIKE '%camprodon-srv.tridenia.es%' OR LOWER(c1_.endpoint) LIKE '%camprodon-srv.tridenia.es%' OR LOWER(p2_.name) LIKE '%camprodon-srv.tridenia.es%' OR LOWER(c1_.name) LIKE '%camprodon-srv%' OR LOWER(c1_.endpoint) LIKE '%camprodon-srv%' OR LOWER(p2_.name) LIKE '%camprodon-srv%') ORDER BY i0_.detected_at ASC LIMIT 1;