GET https://boyekoli.com/admin/off-grade-causes?page=1&sort%5BbrittleSheet%5D=ASC

Query Metrics

7 Database Queries
6 Different statements
8.75 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

# Time Info
1 2.48 ms
SELECT DISTINCT o0_.id AS id_0, o0_.brittle_sheet AS brittle_sheet_1, o0_.date AS date_2 FROM off_grade_causes o0_ ORDER BY o0_.brittle_sheet ASC, o0_.date DESC OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY
Parameters:
[]
2 3.64 ms
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.stripping_type AS stripping_type_2, o0_.number_of_sheets AS number_of_sheets_3, o0_.nodule_on_surface AS nodule_on_surface_4, o0_.nodule_on_edge AS nodule_on_edge_5, o0_.nodule_on_bottom AS nodule_on_bottom_6, o0_.shorts AS shorts_7, o0_.nodule_plus_organic_on_top AS nodule_plus_organic_on_top_8, o0_.spongy_top AS spongy_top_9, o0_.multi_layers AS multi_layers_10, o0_.bent_sheet AS bent_sheet_11, o0_.thine_sheet AS thine_sheet_12, o0_.broken_sheet AS broken_sheet_13, o0_.brittle_sheet AS brittle_sheet_14, o0_.organic_on_surface AS organic_on_surface_15, o0_.oil_or_grease AS oil_or_grease_16, o0_.electrolyte_on_surface AS electrolyte_on_surface_17, o0_.entry_date AS entry_date_18, o0_.unit_id AS unit_id_19, o0_.bundle_grade_id AS bundle_grade_id_20, o0_.encoded_by_id AS encoded_by_id_21, o0_.inspected_by_id AS inspected_by_id_22 FROM off_grade_causes o0_ WHERE o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.brittle_sheet ASC, o0_.date DESC
Parameters:
[
  13
  12
  11
  2
  10
  7
  6
  5
  4
  1
  9
  8
  3
]
3 0.52 ms
SELECT count(*) AS sclr_0 FROM off_grade_causes o0_
Parameters:
[]
4 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.short_name AS short_name_4, t0.ew_id AS ew_id_5 FROM list_unit t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.type AS type_4 FROM list_bundle_grades t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 0.58 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.email AS email_6, t0.phone AS phone_7, t0.is_template AS is_template_8, t0.status_id AS status_id_9, t0.fonction_id AS fonction_id_10, t0.service_id AS service_id_11 FROM [user] t0 WHERE t0.id = ?
Parameters:
[
  37
]
7 0.48 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.email AS email_6, t0.phone AS phone_7, t0.is_template AS is_template_8, t0.status_id AS status_id_9, t0.fonction_id AS fonction_id_10, t0.service_id AS service_id_11 FROM [user] t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\OffGradeCauses 13
App\Entity\User 2
App\Entity\ListUnit 1
App\Entity\ListBundleGrades 1
App\Entity\ListEw 1
App\Entity\ListStatus 1