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

Query Metrics

15 Database Queries
7 Different statements
44.14 ms Query time
0 Invalid entities
34 Managed entities

Grouped Statements

Show all queries

Time Count Info
16.91 ms
(38.31%)
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
]
11.71 ms
(26.54%)
3
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.88 ms
(13.32%)
1
SELECT DISTINCT c0_.id AS id_0, c0_.checked_by_id AS sclr_1 FROM copper_bundles c0_ LEFT JOIN [user] u1_ ON c0_.checked_by_id = u1_.id ORDER BY c0_.checked_by_id DESC OFFSET 60 ROWS FETCH NEXT 20 ROWS ONLY
Parameters:
[]
4.18 ms
(9.48%)
1
SELECT count(DISTINCT c0_.id) AS sclr_0 FROM copper_bundles c0_ LEFT JOIN [user] u1_ ON c0_.checked_by_id = u1_.id
Parameters:
[]
3.75 ms
(8.50%)
2
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
]
1.23 ms
(2.78%)
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_ LEFT JOIN [user] u1_ ON c0_.checked_by_id = u1_.id WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.checked_by_id DESC
Parameters:
[
  73
  72
  71
  70
  69
  68
  67
  66
  65
  64
  63
  62
  61
  60
  59
  58
  57
  56
  55
  54
]
0.48 ms
(1.08%)
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 3
App\Entity\ListStatus 2
App\Entity\ListUnit 2
App\Entity\ListEw 1

Entities Mapping