GET https://loanhub.fhw.crowbyte.org/admin/article?page=8

Query Metrics

11 Database Queries
7 Different statements
4.66 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.shibboleth_id AS shibboleth_id_7, t0.enabled AS enabled_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.78 ms
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM article a0_ ORDER BY a0_.name ASC LIMIT 20 OFFSET 140
Parameters:
[]
3 0.59 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.inventory_number AS inventory_number_2, a0_.image AS image_3, a0_.description AS description_4, a0_.notes AS notes_5, a0_.status AS status_6, a0_.restrict_to_role AS restrict_to_role_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.article_type_id AS article_type_id_10, a0_.category_id AS category_id_11, a0_.created_by_id AS created_by_id_12 FROM article a0_ WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.name ASC
Parameters:
[
  85
  24
  99
  100
  101
  102
  86
  73
  76
]
4 0.39 ms
SELECT count(*) AS sclr_0 FROM article a0_
Parameters:
[]
5 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  5
]
7 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  6
]
8 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  13
]
9 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  9
]
10 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.parent_id AS parent_id_5, t0.article_type_id AS article_type_id_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  4
]
11 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.icon AS icon_5, t0.access_role AS access_role_6 FROM article_type t0 ORDER BY t0.name ASC
Parameters:
[]

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\Article 9
App\Entity\Category 7
App\Entity\ArticleType 2
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Article No errors.
App\Entity\ArticleType No errors.
App\Entity\Category No errors.
App\Entity\AttributeValue No errors.
App\Entity\Loan No errors.
App\Entity\AttributeDefinition No errors.