GET https://boyekoli.com/admin/copper-bundles?page=2&sort%5BbundleNumber%5D=DESC

Query Metrics

22 Database Queries
7 Different statements
15.73 ms Query time
0 Invalid entities
42 Managed entities

Queries

Group similar statements

# Time Info
1 3.31 ms
SELECT DISTINCT c0_.id AS id_0, c0_.bundle_number AS bundle_number_1 FROM copper_bundles c0_ ORDER BY c0_.bundle_number DESC OFFSET 20 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
2 3.16 ms
SELECT c0_.id AS id_0, c0_.production_date AS production_date_1, c0_.bundle_number AS bundle_number_2, c0_.mine_bundle_code AS mine_bundle_code_3, c0_.bundle_lot_number AS bundle_lot_number_4, c0_.bundle_lot_range AS bundle_lot_range_5, c0_.bundle_lot_code AS bundle_lot_code_6, c0_.net_weight AS net_weight_7, c0_.nb_sheets AS nb_sheets_8, c0_.auto_stripping AS auto_stripping_9, c0_.comment AS comment_10, c0_.entry_date AS entry_date_11, c0_.shift AS shift_12, c0_.tare AS tare_13, c0_.washed AS washed_14, c0_.gross_weight AS gross_weight_15, c0_.seal1 AS seal1_16, c0_.seal2 AS seal2_17, c0_.net_weight_from_scale AS net_weight_from_scale_18, c0_.gross_weight_from_scale AS gross_weight_from_scale_19, c0_.encoded_by_id AS encoded_by_id_20, c0_.checked_by_id AS checked_by_id_21, c0_.inspected_by_id AS inspected_by_id_22, c0_.visual_grade_id AS visual_grade_id_23, c0_.status_id AS status_id_24, c0_.unit_id AS unit_id_25 FROM copper_bundles c0_ WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.bundle_number DESC
Parameters:
[
  18
  40
  62
  84
  106
  39
  17
  61
  83
  105
  16
  38
  60
  82
  104
  37
  15
  59
  81
  103
]
3 0.41 ms
SELECT count(*) AS sclr_0 FROM copper_bundles c0_
Parameters:
[]
4 0.63 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:
[
  5
]
5 0.44 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
]
6 0.41 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:
[
  10
]
7 0.39 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:
[
  4
]
8 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM list_status t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.37 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
]
10 0.46 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:
[
  7
]
11 0.42 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
]
12 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.description AS description_4 FROM list_status t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.41 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:
[
  2
]
14 0.52 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:
[
  6
]
15 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:
[
  5
]
16 0.44 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:
[
  3
]
17 0.47 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:
[
  4
]
18 0.50 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:
[
  11
]
19 0.44 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:
[
  1
]
20 0.43 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:
[
  5
]
21 0.47 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:
[
  2
]
22 0.79 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:
[
  6
]

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\CopperBundles 20
App\Entity\User 6
App\Entity\ListBundleGrades 6
App\Entity\ListUnit 5
App\Entity\ListEw 3
App\Entity\ListStatus 2

Entities Mapping