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 t0.login AS login_1, t0.email AS email_2, t0.password_hash AS password_hash_3, t0.status AS status_4, t0.roles AS roles_5, t0.id AS id_6, t0.public_id AS public_id_7, t0.created_at AS created_at_8, t0.name AS name_9, t0.surname AS surname_10, t0.patronymic AS patronymic_11, t0.avatar_id AS avatar_id_12, t13.chat_id AS chat_id_14, t13.username AS username_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.language_code AS language_code_18, t13.auth_token AS auth_token_19, t13.auth_token_expires AS auth_token_expires_20, t13.id AS id_21, t13.created_at AS created_at_22, t13.status AS status_23, t13.user_id AS user_id_24, t25.token AS token_26, t25.status AS status_27, t25.id AS id_28, t25.public_id AS public_id_29, t25.created_at AS created_at_30, t25.period_from AS period_from_31, t25.period_to AS period_to_32, t25.user_id AS user_id_33 FROM users t0 LEFT JOIN telegram_users t13 ON t13.user_id = t0.id LEFT JOIN confirm_tokens t25 ON t25.user_id = t0.id WHERE t0.login = ? LIMIT 1

[
  "admin"
]

SELECT
  t0.login AS login_1,
  t0.email AS email_2,
  t0.password_hash AS password_hash_3,
  t0.status AS status_4,
  t0.roles AS roles_5,
  t0.id AS id_6,
  t0.public_id AS public_id_7,
  t0.created_at AS created_at_8,
  t0.name AS name_9,
  t0.surname AS surname_10,
  t0.patronymic AS patronymic_11,
  t0.avatar_id AS avatar_id_12,
  t13.chat_id AS chat_id_14,
  t13.username AS username_15,
  t13.first_name AS first_name_16,
  t13.last_name AS last_name_17,
  t13.language_code AS language_code_18,
  t13.auth_token AS auth_token_19,
  t13.auth_token_expires AS auth_token_expires_20,
  t13.id AS id_21,
  t13.created_at AS created_at_22,
  t13.status AS status_23,
  t13.user_id AS user_id_24,
  t25.token AS token_26,
  t25.status AS status_27,
  t25.id AS id_28,
  t25.public_id AS public_id_29,
  t25.created_at AS created_at_30,
  t25.period_from AS period_from_31,
  t25.period_to AS period_to_32,
  t25.user_id AS user_id_33
FROM
  users t0
  LEFT JOIN telegram_users t13 ON t13.user_id = t0.id
  LEFT JOIN confirm_tokens t25 ON t25.user_id = t0.id
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.login AS login_1, t0.email AS email_2, t0.password_hash AS password_hash_3, t0.status AS status_4, t0.roles AS roles_5, t0.id AS id_6, t0.public_id AS public_id_7, t0.created_at AS created_at_8, t0.name AS name_9, t0.surname AS surname_10, t0.patronymic AS patronymic_11, t0.avatar_id AS avatar_id_12, t13.chat_id AS chat_id_14, t13.username AS username_15, t13.first_name AS first_name_16, t13.last_name AS last_name_17, t13.language_code AS language_code_18, t13.auth_token AS auth_token_19, t13.auth_token_expires AS auth_token_expires_20, t13.id AS id_21, t13.created_at AS created_at_22, t13.status AS status_23, t13.user_id AS user_id_24, t25.token AS token_26, t25.status AS status_27, t25.id AS id_28, t25.public_id AS public_id_29, t25.created_at AS created_at_30, t25.period_from AS period_from_31, t25.period_to AS period_to_32, t25.user_id AS user_id_33 FROM users t0 LEFT JOIN telegram_users t13 ON t13.user_id = t0.id LEFT JOIN confirm_tokens t25 ON t25.user_id = t0.id WHERE t0.login = 'admin' LIMIT 1;

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

[
  "KESUSD_otc"
]

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

SELECT a.* FROM assets a WHERE a.symbol = 'KESUSD_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 3

[
  146000
  111
  146000
  111
  292000
]

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
  3

SELECT time_bucket(CAST(146000 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 = 111) AND (q.time >= (SELECT time_bucket(CAST(146000 AS bigint), MAX(l.time)) FROM quotes l WHERE l.asset_id = 111) - CAST(292000 AS bigint)) GROUP BY bucket ORDER BY bucket DESC LIMIT 3;