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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 7.43 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 0 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
2 14.50 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:
[
  22
  44
  66
  88
  110
  21
  43
  65
  87
  109
  20
  42
  64
  86
  108
  19
  41
  63
  85
  107
]
3 2.37 ms
SELECT count(*) AS sclr_0 FROM copper_bundles c0_
Parameters:
[]
4 11.43 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 4.26 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 7.16 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 3.10 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
]
8 2.73 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 3.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:
[
  1
]
10 21.88 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 2.33 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 1.28 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 10.80 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 18.12 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 3.36 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
]
16 6.27 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 4.25 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
]
18 6.05 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
]
19 19.19 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
]
20 5.82 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
]
21 5.60 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
]
22 5.94 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
]

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