GET https://queue.drosys.cz/admin/

Query Metrics

9 Database Queries
7 Different statements
5.09 ms Query time
0 Invalid entities
7 Managed entities

Grouped Statements

Show all queries

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.