GET https://content.gamingdesktop.com.au/admin/supplier-ref?page=722&sort%5BdsCode%5D=ASC

Query Metrics

3 Database Queries
3 Different statements
93.61 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

# Time Info
1 87.93 ms
SELECT DISTINCT s0_.id AS id_0, s0_.ds_code AS ds_code_1 FROM supplier_ref s0_ ORDER BY s0_.ds_code ASC LIMIT 50 OFFSET 36050
Parameters:
[]
2 1.15 ms
SELECT s0_.id AS id_0, s0_.sku AS sku_1, s0_.ls_code AS ls_code_2, s0_.alloy_code AS alloy_code_3, s0_.mmt_code AS mmt_code_4, s0_.ds_code AS ds_code_5, s0_.dd_code AS dd_code_6, s0_.synnex_code AS synnex_code_7 FROM supplier_ref s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.ds_code ASC
Parameters:
[
  29115
  29116
  29117
  29118
  29119
  29120
  29121
  29122
  29123
  29124
  29125
  29126
  29127
  29128
  29777
  29778
  29779
  29780
  30142
  34393
  34391
  34390
  34392
  32883
  30415
  30416
  30417
  30418
  34195
  34347
  34346
  34344
  34345
  34079
  34077
  34078
  34076
  34679
  32714
  29129
  29130
  29131
  29132
  29133
  29134
  29135
  29136
  29137
  29138
  29139
]
3 4.52 ms
SELECT count(*) AS sclr_0 FROM supplier_ref s0_
Parameters:
[]

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\SupplierRef 50

Entities Mapping

Class Mapping errors
App\Entity\SupplierRef No errors.