Query Metrics
9
Database Queries
7
Different statements
5.09 ms
Query time
0
Invalid entities
7
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.09 ms (21.46%) |
2 |
SELECT COUNT(t0_.id) AS sclr_0, SUM(CASE WHEN t0_.status = ? THEN 1 ELSE 0 END) AS sclr_1, SUM(CASE WHEN t0_.status = ? THEN 1 ELSE 0 END) AS sclr_2, SUM(CASE WHEN t0_.status = ? THEN 1 ELSE 0 END) AS sclr_3, SUM(CASE WHEN t0_.status = ? THEN 1 ELSE 0 END) AS sclr_4, AVG(t0_.processing_duration_ms) AS sclr_5, AVG(t0_.queue_wait_time_ms) AS sclr_6 FROM translation_requests t0_ WHERE t0_.created_at BETWEEN ? AND ?
Parameters:
[ "completed" "failed" "processing" "queued" "2025-12-07 00:00:00" "2025-12-07 23:59:59" ]
|
||||||||||||||||||||||||||||||||
|
0.93 ms (18.33%) |
1 |
SELECT t0_.id AS id_0, t0_.request_id AS request_id_1, t0_.source_text AS source_text_2, t0_.priority AS priority_3, t0_.status AS status_4, t0_.request_payload AS request_payload_5, t0_.result_payload AS result_payload_6, t0_.created_at AS created_at_7, t0_.queued_at AS queued_at_8, t0_.processing_started_at AS processing_started_at_9, t0_.completed_at AS completed_at_10, t0_.processing_duration_ms AS processing_duration_ms_11, t0_.queue_wait_time_ms AS queue_wait_time_ms_12, t0_.worker_id AS worker_id_13, t0_.callback_url AS callback_url_14, t0_.callback_status AS callback_status_15, t0_.callback_attempts AS callback_attempts_16, t0_.callback_sent_at AS callback_sent_at_17, t0_.error_message AS error_message_18, t0_.retry_count AS retry_count_19, t0_.fetch_url AS fetch_url_20, t0_.fetch_token AS fetch_token_21, t0_.fetch_status AS fetch_status_22, t0_.fetch_attempted_at AS fetch_attempted_at_23, t0_.fetch_error AS fetch_error_24, t0_.source_id AS source_id_25 FROM translation_requests t0_ WHERE t0_.status = ? ORDER BY t0_.completed_at DESC LIMIT 5
Parameters:
[
"completed"
]
|
||||||||||||||||||||||||||||||||
|
0.81 ms (15.99%) |
2 |
SELECT t0_.id AS id_0, t0_.request_id AS request_id_1, t0_.source_text AS source_text_2, t0_.priority AS priority_3, t0_.status AS status_4, t0_.request_payload AS request_payload_5, t0_.result_payload AS result_payload_6, t0_.created_at AS created_at_7, t0_.queued_at AS queued_at_8, t0_.processing_started_at AS processing_started_at_9, t0_.completed_at AS completed_at_10, t0_.processing_duration_ms AS processing_duration_ms_11, t0_.queue_wait_time_ms AS queue_wait_time_ms_12, t0_.worker_id AS worker_id_13, t0_.callback_url AS callback_url_14, t0_.callback_status AS callback_status_15, t0_.callback_attempts AS callback_attempts_16, t0_.callback_sent_at AS callback_sent_at_17, t0_.error_message AS error_message_18, t0_.retry_count AS retry_count_19, t0_.fetch_url AS fetch_url_20, t0_.fetch_token AS fetch_token_21, t0_.fetch_status AS fetch_status_22, t0_.fetch_attempted_at AS fetch_attempted_at_23, t0_.fetch_error AS fetch_error_24, t0_.source_id AS source_id_25 FROM translation_requests t0_ WHERE t0_.status = ? ORDER BY t0_.created_at DESC LIMIT 50
Parameters:
[
"queued"
]
|
||||||||||||||||||||||||||||||||
|
0.74 ms (14.60%) |
1 |
SELECT t0_.priority AS priority_0, COUNT(t0_.id) AS sclr_1 FROM translation_requests t0_ WHERE t0_.created_at BETWEEN ? AND ? GROUP BY t0_.priority ORDER BY t0_.priority ASC
Parameters:
[ "2025-12-07 00:00:00" "2025-12-07 23:59:59" ]
|
||||||||||||||||||||||||||||||||
|
0.73 ms (14.39%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.name AS name_3, t0.description AS description_4, t0.callback_api_key AS callback_api_key_5, t0.entity_list_endpoint AS entity_list_endpoint_6, t0.entity_detail_endpoint AS entity_detail_endpoint_7, t0.check_entities_endpoint AS check_entities_endpoint_8, t0.last_validated_at AS last_validated_at_9, t0.is_active AS is_active_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_synced_at AS last_synced_at_13 FROM sources t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.39 ms (7.69%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login_at AS last_login_at_8 FROM users t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
0.38 ms (7.54%) |
1 |
SELECT MIN(t0_.queued_at) AS sclr_0 FROM translation_requests t0_ WHERE t0_.status = ?
Parameters:
[
"queued"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\TranslationRequest | 5 |
| App\Entity\User | 1 |
| App\Entity\Source | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\TranslationRequest | No errors. |
| App\Entity\Source | No errors. |
| App\Entity\ApiKey | No errors. |
| App\Entity\CachedEntity | No errors. |
| App\Entity\ContextDocument | No errors. |