GET https://ironside.prototype.devo.to/admin/dev-queue/indicator

Query Metrics

4 Database Queries
4 Different statements
0.12 ms Query time
0 Invalid entities
15 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.04 ms
(37.47%)
1
SELECT d0_.status AS status_0, COUNT(d0_.id) AS sclr_1, SUM(CASE WHEN d0_.approved_at IS NULL THEN 1 ELSE 0 END) AS sclr_2 FROM dev_prompt d0_ WHERE d0_.kind <> ? GROUP BY d0_.status
Parameters:
[
  "assistant"
]
0.03 ms
(23.40%)
1
SELECT t0.name AS name_1, t0.value AS value_2, t0.updated_at AS updated_at_3 FROM setting t0
Parameters:
[]
0.03 ms
(22.57%)
1
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.content AS content_2, d0_.kind AS kind_3, d0_.status AS status_4, d0_.position AS position_5, d0_.created_by_name AS created_by_name_6, d0_.created_at AS created_at_7, d0_.started_at AS started_at_8, d0_.finished_at AS finished_at_9, d0_.result AS result_10, d0_.approved_at AS approved_at_11, d0_.commit_sha AS commit_sha_12, d0_.created_by_id AS created_by_id_13 FROM dev_prompt d0_ WHERE d0_.status IN (?, ?, ?) AND d0_.kind <> ? ORDER BY d0_.position ASC, d0_.id ASC
Parameters:
[
  "pending"
  "running"
  "blocked"
  "assistant"
]
0.02 ms
(16.56%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.totp_secret AS totp_secret_7, t0.email_auto_send AS email_auto_send_8, t0.email_auth_code AS email_auth_code_9, t0.email_auth_code_generated_at AS email_auth_code_generated_at_10, t0.locale AS locale_11, t0.timezone AS timezone_12, t0.message_email_notifications AS message_email_notifications_13, t0.open_article_new_tab AS open_article_new_tab_14, t0.open_child_article_new_tab AS open_child_article_new_tab_15, t0.last_activity_at AS last_activity_at_16, t0.avatar_filename AS avatar_filename_17, t0.reset_token_hash AS reset_token_hash_18, t0.reset_token_expires_at AS reset_token_expires_at_19 FROM "user" t0 WHERE t0.id = ?
Parameters:
[
  9
]

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\Setting 14
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\DevPrompt No errors.
App\Entity\Setting No errors.