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

Query Metrics

13 Database Queries
7 Different statements
46.15 ms Query time
0 Invalid entities
32 Managed entities

Grouped Statements

Show all queries

Time Count Info
27.42 ms
(59.40%)
6
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
]
7.40 ms
(16.04%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.bundle_lot_code AS bundle_lot_code_1 FROM copper_bundles c0_ ORDER BY c0_.bundle_lot_code DESC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
4.35 ms
(9.43%)
1
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_lot_code DESC
Parameters:
[
  110
  109
  108
  107
  106
  105
  104
  103
  102
  101
  100
  99
  98
  97
  96
  95
  94
  93
  92
  91
]
2.51 ms
(5.45%)
2
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
]
2.30 ms
(4.97%)
1
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
]
1.77 ms
(3.84%)
1
SELECT count(*) AS sclr_0 FROM copper_bundles c0_
Parameters:
[]
0.40 ms
(0.86%)
1
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
]

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

Entities Mapping