GET https://loanhub.fhw.crowbyte.org/admin/article

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.58 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.72 ms
SELECT DISTINCT a0_.id AS id_0, a0_.name AS name_1 FROM article a0_ ORDER BY a0_.name ASC LIMIT 20
Parameters:
[]
3 0.66 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:
[
  32
  30
  79
  31
  35
  72
  1
  2
  25
  124
  125
  126
  127
  128
  129
  130
  131
  132
  133
  134
]
4 0.30 ms
SELECT count(*) AS sclr_0 FROM article a0_
Parameters:
[]
5 0.38 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.45 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
]
7 0.34 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
]
8 0.28 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:
[
  11
]
9 0.30 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:
[
  3
]
10 0.30 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
]
11 0.24 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:
[
  7
]
12 0.55 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 20
App\Entity\Category 8
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.