Symfony Profiler

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

Query Metrics

SELECT MIN(i0_.HH_LABEL_ID) AS sclr_0, MAX(i0_.HH_LABEL_ID) AS sclr_1 FROM HellyHansen.IncomingLabels i0_

[]

SELECT
  MIN(i0_.HH_LABEL_ID) AS sclr_0,
  MAX(i0_.HH_LABEL_ID) AS sclr_1
FROM
  HellyHansen.IncomingLabels i0_

SELECT MIN(i0_.HH_LABEL_ID) AS sclr_0, MAX(i0_.HH_LABEL_ID) AS sclr_1 FROM HellyHansen.IncomingLabels i0_;

WITH RankedMessages AS (
    SELECT 
        HH_LABEL_ID,
        Message,
		StatusTime,
        StatusID,
        ROW_NUMBER() OVER (PARTITION BY HH_LABEL_ID, StatusID ORDER BY Message) AS rn
    FROM [Integrations].[HellyHansen].[IncomingLabelsStatusV2]
    WHERE StatusID IN (28,5,10)
)
SELECT TOP (30)
    HH_LABEL_ID,
	MAX(StatusTime) AS RequestTime,
    /*DATEDIFF(MILLISECOND, MIN(StatusTime), MAX(StatusTime)) AS ResponseTime,*/
    1 AS ResponseTime,
    MAX(CASE WHEN StatusID = 28 THEN Message END) AS Request,
    MAX(CASE WHEN StatusID = 5 THEN Message END) AS RangeCheck,
    MAX(CASE WHEN StatusID = 10 THEN Message END) AS PdfLabel,
    MAX(StatusTime) AS LastStatus
FROM RankedMessages
WHERE rn = 1
GROUP BY HH_LABEL_ID
ORDER BY LastStatus DESC;

[]

WITH
  RankedMessages AS (
    SELECT
      HH_LABEL_ID,
      Message,
      StatusTime,
      StatusID,
      ROW_NUMBER() OVER (
        PARTITION BY
          HH_LABEL_ID,
          StatusID
        ORDER BY
          Message
      ) AS rn
    FROM
      [Integrations].[HellyHansen].[IncomingLabelsStatusV2]
    WHERE
      StatusID IN (28, 5, 10)
  )
SELECT
  TOP (30) HH_LABEL_ID,
  MAX(StatusTime) AS RequestTime,

  /*DATEDIFF(MILLISECOND, MIN(StatusTime), MAX(StatusTime)) AS ResponseTime,*/
  1 AS ResponseTime,
  MAX(
    CASE WHEN StatusID = 28 THEN
      Message
    END
  ) AS Request,
  MAX(
    CASE WHEN StatusID = 5 THEN
      Message
    END
  ) AS RangeCheck,
  MAX(
    CASE WHEN StatusID = 10 THEN
      Message
    END
  ) AS PdfLabel,
  MAX(StatusTime) AS LastStatus
FROM
  RankedMessages
WHERE
  rn = 1
GROUP BY
  HH_LABEL_ID
ORDER BY
  LastStatus DESC;

WITH RankedMessages AS (
    SELECT 
        HH_LABEL_ID,
        Message,
		StatusTime,
        StatusID,
        ROW_NUMBER() OVER (PARTITION BY HH_LABEL_ID, StatusID ORDER BY Message) AS rn
    FROM [Integrations].[HellyHansen].[IncomingLabelsStatusV2]
    WHERE StatusID IN (28,5,10)
)
SELECT TOP (30)
    HH_LABEL_ID,
	MAX(StatusTime) AS RequestTime,
    /*DATEDIFF(MILLISECOND, MIN(StatusTime), MAX(StatusTime)) AS ResponseTime,*/
    1 AS ResponseTime,
    MAX(CASE WHEN StatusID = 28 THEN Message END) AS Request,
    MAX(CASE WHEN StatusID = 5 THEN Message END) AS RangeCheck,
    MAX(CASE WHEN StatusID = 10 THEN Message END) AS PdfLabel,
    MAX(StatusTime) AS LastStatus
FROM RankedMessages
WHERE rn = 1
GROUP BY HH_LABEL_ID
ORDER BY LastStatus DESC;;