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, t12.chat_id AS chat_id_13, t12.username AS username_14, t12.first_name AS first_name_15, t12.last_name AS last_name_16, t12.language_code AS language_code_17, t12.auth_token AS auth_token_18, t12.auth_token_expires AS auth_token_expires_19, t12.id AS id_20, t12.created_at AS created_at_21, t12.status AS status_22, t12.user_id AS user_id_23, t24.token AS token_25, t24.status AS status_26, t24.id AS id_27, t24.public_id AS public_id_28, t24.created_at AS created_at_29, t24.period_from AS period_from_30, t24.period_to AS period_to_31, t24.user_id AS user_id_32 FROM users t0 LEFT JOIN telegram_users t12 ON t12.user_id = t0.id LEFT JOIN confirm_tokens t24 ON t24.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,
  t12.chat_id AS chat_id_13,
  t12.username AS username_14,
  t12.first_name AS first_name_15,
  t12.last_name AS last_name_16,
  t12.language_code AS language_code_17,
  t12.auth_token AS auth_token_18,
  t12.auth_token_expires AS auth_token_expires_19,
  t12.id AS id_20,
  t12.created_at AS created_at_21,
  t12.status AS status_22,
  t12.user_id AS user_id_23,
  t24.token AS token_25,
  t24.status AS status_26,
  t24.id AS id_27,
  t24.public_id AS public_id_28,
  t24.created_at AS created_at_29,
  t24.period_from AS period_from_30,
  t24.period_to AS period_to_31,
  t24.user_id AS user_id_32
FROM
  users t0
  LEFT JOIN telegram_users t12 ON t12.user_id = t0.id
  LEFT JOIN confirm_tokens t24 ON t24.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, t12.chat_id AS chat_id_13, t12.username AS username_14, t12.first_name AS first_name_15, t12.last_name AS last_name_16, t12.language_code AS language_code_17, t12.auth_token AS auth_token_18, t12.auth_token_expires AS auth_token_expires_19, t12.id AS id_20, t12.created_at AS created_at_21, t12.status AS status_22, t12.user_id AS user_id_23, t24.token AS token_25, t24.status AS status_26, t24.id AS id_27, t24.public_id AS public_id_28, t24.created_at AS created_at_29, t24.period_from AS period_from_30, t24.period_to AS period_to_31, t24.user_id AS user_id_32 FROM users t0 LEFT JOIN telegram_users t12 ON t12.user_id = t0.id LEFT JOIN confirm_tokens t24 ON t24.user_id = t0.id WHERE t0.login = 'admin' LIMIT 1;

SELECT COUNT(*) FROM (SELECT s.id id, a.title asset, s.timeframe timeframe, s.row_count row_count, s.time time, a.payment payment, st.name strategy FROM signals s INNER JOIN assets a ON a.id = s.asset_id INNER JOIN strategies st ON st.id = s.strategy_id WHERE s.time <= ?) tmp

[
  1791778780
]

SELECT
  COUNT(*)
FROM
  (
    SELECT
      s.id id,
      a.title asset,
      s.timeframe timeframe,
      s.row_count row_count,
      s.time time,
      a.payment payment,
      st.name strategy
    FROM
      signals s
      INNER JOIN assets a ON a.id = s.asset_id
      INNER JOIN strategies st ON st.id = s.strategy_id
    WHERE
      s.time <= ?
  ) tmp

SELECT COUNT(*) FROM (SELECT s.id id, a.title asset, s.timeframe timeframe, s.row_count row_count, s.time time, a.payment payment, st.name strategy FROM signals s INNER JOIN assets a ON a.id = s.asset_id INNER JOIN strategies st ON st.id = s.strategy_id WHERE s.time <= 1791778780) tmp;

SELECT s.id id, a.title asset, s.timeframe timeframe, s.row_count row_count, s.time time, a.payment payment, st.name strategy FROM signals s INNER JOIN assets a ON a.id = s.asset_id INNER JOIN strategies st ON st.id = s.strategy_id WHERE s.time <= ? ORDER BY time DESC LIMIT 100 OFFSET 100

[
  1791778780
]

SELECT
  s.id id,
  a.title asset,
  s.timeframe timeframe,
  s.row_count row_count,
  s.time time,
  a.payment payment,
  st.name strategy
FROM
  signals s
  INNER JOIN assets a ON a.id = s.asset_id
  INNER JOIN strategies st ON st.id = s.strategy_id
WHERE
  s.time <= ?
ORDER BY
  time DESC
LIMIT
  100
OFFSET
  100

SELECT s.id id, a.title asset, s.timeframe timeframe, s.row_count row_count, s.time time, a.payment payment, st.name strategy FROM signals s INNER JOIN assets a ON a.id = s.asset_id INNER JOIN strategies st ON st.id = s.strategy_id WHERE s.time <= 1791778780 ORDER BY time DESC LIMIT 100 OFFSET 100;