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 a.* FROM assets a WHERE a.symbol = ?

[
  "USDCOP_otc"
]

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

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

SELECT time_bucket(CAST(? AS bigint), q.time) / 1000 AS bucket, first(q.price, q.time) AS open, MAX(q.price) AS high, MIN(q.price) AS low, last(q.price, q.time) AS close FROM quotes q WHERE (q.asset_id = ?) AND (q.time >= (SELECT time_bucket(CAST(? AS bigint), MAX(l.time)) FROM quotes l WHERE l.asset_id = ?) - CAST(? AS bigint)) GROUP BY bucket ORDER BY bucket DESC LIMIT 2400

[
  46000
  152
  46000
  152
  110354000
]

SELECT
  time_bucket(
    CAST(? AS bigint),
    q.time
  ) / 1000 AS bucket,
  first(q.price, q.time) AS open,
  MAX(q.price) AS high,
  MIN(q.price) AS low,
  last(q.price, q.time) AS close
FROM
  quotes q
WHERE
  (q.asset_id = ?)
  AND (
    q.time >= (
      SELECT
        time_bucket(
          CAST(? AS bigint),
          MAX(l.time)
        )
      FROM
        quotes l
      WHERE
        l.asset_id = ?
    ) - CAST(? AS bigint)
  )
GROUP BY
  bucket
ORDER BY
  bucket DESC
LIMIT
  2400

SELECT time_bucket(CAST(46000 AS bigint), q.time) / 1000 AS bucket, first(q.price, q.time) AS open, MAX(q.price) AS high, MIN(q.price) AS low, last(q.price, q.time) AS close FROM quotes q WHERE (q.asset_id = 152) AND (q.time >= (SELECT time_bucket(CAST(46000 AS bigint), MAX(l.time)) FROM quotes l WHERE l.asset_id = 152) - CAST(110354000 AS bigint)) GROUP BY bucket ORDER BY bucket DESC LIMIT 2400;