Query Metrics
4
Database Queries
4
Different statements
2662.11 ms
Query time
0
Invalid entities
53
Managed entities
Queries
trading_bot connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2492.95 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.run_id AS run_id_3, t0.symbol AS symbol_4, t0.timeframe AS timeframe_5, t0.open AS open_6, t0.high AS high_7, t0.low AS low_8, t0.price AS price_9, t0.close AS close_10, t0.volume AS volume_11, t0.volume_avg20 AS volume_avg20_12, t0.volume_ratio AS volume_ratio_13, t0.ema7 AS ema7_14, t0.ema25 AS ema25_15, t0.ema90 AS ema90_16, t0.rsi14 AS rsi14_17, t0.atr14 AS atr14_18, t0.bid AS bid_19, t0.ask AS ask_20, t0.timestamp AS timestamp_21, t0.created_at AS created_at_22 FROM market_snapshot t0 WHERE t0.symbol = ? ORDER BY t0.timestamp DESC, t0.id DESC LIMIT 2
Parameters:
[
"BTC/USDT"
]
|
| 2 | 80.10 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.run_id AS run_id_3, t0.symbol AS symbol_4, t0.source AS source_5, t0.direction AS direction_6, t0.alarm_type AS alarm_type_7, t0.timeframe_used AS timeframe_used_8, t0.price_now AS price_now_9, t0.price_1m_ago AS price_1m_ago_10, t0.price_5m_ago AS price_5m_ago_11, t0.speed_1m AS speed_1m_12, t0.speed_5m AS speed_5m_13, t0.delta_pct AS delta_pct_14, t0.delta_usd AS delta_usd_15, t0.strength AS strength_16, t0.entry_confidence AS entry_confidence_17, t0.timestamp AS timestamp_18, t0.created_at AS created_at_19 FROM alarms t0 WHERE t0.symbol = ? ORDER BY t0.created_at DESC, t0.id DESC LIMIT 1
Parameters:
[
"BTC/USDT"
]
|
| 3 | 86.02 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.run_id AS run_id_3, t0.status AS status_4, t0.last_price AS last_price_5, t0.execution_time_ms AS execution_time_ms_6, t0.cron_exit_code AS cron_exit_code_7, t0.processed_candles AS processed_candles_8, t0.memory_usage_mb AS memory_usage_mb_9, t0.peak_memory_mb AS peak_memory_mb_10, t0.error_message AS error_message_11, t0.timestamp AS timestamp_12, t0.created_at AS created_at_13 FROM bot_status t0 ORDER BY t0.created_at DESC LIMIT 1
Parameters:
[] |
| 4 | 3.04 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.run_id AS run_id_3, t0.symbol AS symbol_4, t0.source AS source_5, t0.direction AS direction_6, t0.alarm_type AS alarm_type_7, t0.timeframe_used AS timeframe_used_8, t0.price_now AS price_now_9, t0.price_1m_ago AS price_1m_ago_10, t0.price_5m_ago AS price_5m_ago_11, t0.speed_1m AS speed_1m_12, t0.speed_5m AS speed_5m_13, t0.delta_pct AS delta_pct_14, t0.delta_usd AS delta_usd_15, t0.strength AS strength_16, t0.entry_confidence AS entry_confidence_17, t0.timestamp AS timestamp_18, t0.created_at AS created_at_19 FROM alarms t0 WHERE t0.symbol = ? ORDER BY t0.created_at DESC LIMIT 50
Parameters:
[
"BTC/USDT"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| trading_bot | doctrine.dbal.trading_bot_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| trading_bot | doctrine.orm.trading_bot_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
trading_bot entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\TradingBot\Alarm | 50 |
| App\Entity\TradingBot\MarketSnapshot | 2 |
| App\Entity\TradingBot\BotStatus | 1 |
Entities Mapping
default entity manager
No loaded entities.
trading_bot entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\TradingBot\MarketSnapshot | No errors. |
| App\Entity\TradingBot\Alarm | No errors. |
| App\Entity\TradingBot\BotStatus | No errors. |