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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 31.72 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 18300
Parameters:
[]
2 1.19 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:
[
  18905
  19161
  19417
  19673
  19929
  20185
  20441
  20697
  20953
  21209
  21465
  218
  474
  730
  986
  1242
  1498
  1754
  2010
  2266
  2522
  2778
  3034
  3290
  3546
  3802
  4058
  4314
  4570
  4826
  5082
  5338
  5594
  5850
  6106
  6362
  6618
  6874
  7130
  7386
  7642
  7898
  8154
  8410
  8666
  8922
  9178
  9434
  9690
  9946
]
3 16.85 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.