Symfony Profiler

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

Query Metrics

SELECT FLOOR(q.time / ?) * ? AS bucket, (array_agg(q.price ORDER BY q.time ASC))[1] AS open, MAX(q.price) AS high, MIN(q.price) AS low, (array_agg(q.price ORDER BY q.time DESC))[1] AS close FROM quotes q WHERE (q.asset_id = ?) AND (q.time >= (SELECT FLOOR(MAX(l.time) / ?) * ? FROM quotes l WHERE l.asset_id = ?) - ?) GROUP BY bucket ORDER BY bucket DESC LIMIT 2400

[
  69
  69
  126
  69
  69
  126
  165531
]

SELECT
  FLOOR(q.time / ?) * ? AS bucket,
  (
    array_agg(
      q.price
      ORDER BY
        q.time ASC
    )
  ) [1] AS open,
  MAX(q.price) AS high,
  MIN(q.price) AS low,
  (
    array_agg(
      q.price
      ORDER BY
        q.time DESC
    )
  ) [1] AS close
FROM
  quotes q
WHERE
  (q.asset_id = ?)
  AND (
    q.time >= (
      SELECT
        FLOOR(
          MAX(l.time) / ?
        ) * ?
      FROM
        quotes l
      WHERE
        l.asset_id = ?
    ) - ?
  )
GROUP BY
  bucket
ORDER BY
  bucket DESC
LIMIT
  2400

SELECT FLOOR(q.time / 69) * 69 AS bucket, (array_agg(q.price ORDER BY q.time ASC))[1] AS open, MAX(q.price) AS high, MIN(q.price) AS low, (array_agg(q.price ORDER BY q.time DESC))[1] AS close FROM quotes q WHERE (q.asset_id = 126) AND (q.time >= (SELECT FLOOR(MAX(l.time) / 69) * 69 FROM quotes l WHERE l.asset_id = 126) - 165531) GROUP BY bucket ORDER BY bucket DESC LIMIT 2400;

SELECT a.* FROM assets a WHERE a.symbol = ?

[
  "NZDUSD_otc"
]

SELECT
  a.*
FROM
  assets a
WHERE
  a.symbol = ?

SELECT a.* FROM assets a WHERE a.symbol = 'NZDUSD_otc';