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

Query Metrics

14 Database Queries
7 Different statements
103.07 ms Query time
0 Invalid entities
32 Managed entities

Queries

Group similar statements

# Time Info
1 1.94 ms
SELECT DISTINCT c0_.id AS id_0, c0_.production_date AS production_date_1 FROM copper_bundles c0_ ORDER BY c0_.production_date DESC OFFSET 60 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
2 1.17 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_.production_date DESC
Parameters:
[
  22
  21
  20
  19
  18
  17
  16
  15
  14
  13
  12
  11
  10
  9
  8
  7
  6
  5
  4
  3
]
3 0.60 ms
SELECT count(*) AS sclr_0 FROM copper_bundles c0_
Parameters:
[]
4 6.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:
[
  5
]
5 3.25 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 11.77 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 2.70 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
]
8 1.56 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 10.55 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 11.24 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
]
11 13.05 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 2.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:
[
  1
]
13 15.73 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
]
14 20.93 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
]

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\ListBundleGrades 6
App\Entity\User 3
App\Entity\ListStatus 1
App\Entity\ListUnit 1
App\Entity\ListEw 1

Entities Mapping